MS Excel - Windows

By now, you're already familiar with Microsoft® Office Excel® 2021, its functions and formulas, a lot of its features and functionality, and its powerful data analysis tools. You are likely called upon to analyze and report on data frequently, work in collaboration with others to deliver actionable organizational intelligence, and keep and maintain workbooks for all manner of purposes. At this level of use and collaboration, you have also likely encountered your fair share of issues and challenges. You're too busy, though, to waste time scouring over workbooks to resolve issues or to perform repetitive, monotonous tasks. You need to know how to get Excel to do more for you so you can focus on what's really important: staying ahead of the competition. That's exactly what this course aims to help you do.This course is intended for students who are experienced Excel 2021 users and have a desire or need to advance their skills in working with some of the more advanced Excel features.

Whether you need to crunch numbers for sales, inventory, IT, human resources, or other anyone else, the ability to get the right information to the right people at the right time can create a powerful competitive advantage. After all, the world runs on data more than ever before and that's a trend not likely to change, or even slow down. But with so much data available and being created on a nearly constant basis, the ability to make sense of that data becomes more critical & challenging everyday. You already know how to get Excel® to perform calculations & how to modify your workbooks/worksheets to make them easier to read, interpret, & present. But, Excel is capable of doing so much more. To gain a competitive edge, you need to be able to extract actionable organizational intelligence from your raw data. In other words, when you have questions about your data, you need to know how to get Excel to provide the answers for you. And that's exactly what this course aims to help you do.

Students will create a variety of charts, with emphasis on selecting appropriate chart types and personalizing them by using various chart options. Here are the activities covered: · Picture your Excel data in a chart · Emphasize a single data range with a pie chart · Track data over time Spice up your reports with charts Students participating in this Lab should be educated Excel worksheet users who are familiar with: Prerequisites The following course (or equivalent knowledge): Excel : Worksheets

Upon successful completion of this course, you will be able to use Power Pivot along with Excel to analyze data from a variety of sources. This course presents information and skills that are appropriate for users of either the Office 2021 or Office 365 applications. However, the instructional environment for the delivery of this course utilizes Office 365. You will: Get started with Power Pivot. Visualize Power Pivot data. Work with advanced functionality in Power Pivot. Students taking this course are experienced Excel users who are seeking to advance their data-analysis capabilities by using Power Pivot.

In this 1/2 day course you will learn how to use the Excel tool to make a pivot table. A pivot table is a table of statistics that summarizes the data of a more extensive table such as a database, spreadsheet, or business intelligence program. This summary might include sums, averages, or other statistics, which the pivot table groups together in a meaningful way. Pivot tables are a technique in data processing. They enable a person to arrange and rearrange (or "pivot") statistics in order to draw attention to useful information. With a pivot table, you can transform one million rows of transactional data into a summary report in seconds. If you can drag a mouse, you can create a pivot table. In addition to quickly summarizing and calculating data, pivot tables enable you to change your analysis on the fly by simply moving fields from one area of a report to another. Students taking this course are experienced Excel users who are seeking to advance their data analysis capabilities.

Advances in technology have made it possible to store ever increasing amounts of data. Along with this, the need to analyze that data and gain actionable insight is greater than ever. You already have experience working with Excel and creating basic PivotTables to summarize data. But, Excel is capable of doing much more. You will not only be able to summarize data for you to analyze, but also organize the data in a way that can be meaningfully presented to others. This leads to data-driven business decisions that have a better chance for success for everyone involved. Course Objectives: Upon successful completion of this course, you will be able to use Excel 2016 advanced PivotTable functionality to analyze your raw data. Prepare data for PivotTable reporting and create PivotTables from various data sources. Analyze Data Using PivotTables. Work with PivotCharts.

Organizations the world over rely on information to make sound decisions regarding all manner of affairs. But with the amount of available data growing on a daily basis, the ability to make sense of all of that data is becoming more and more challenging. Fortunately, this is where the power of Microsoft® Office Excel® 2021 can help. Excel can help you organize, calculate, analyze, revise, update, and present your data in ways that will help the decision makers in your organization steer you in the right direction. It will also make these tasks much easier for you to accomplish, and in much less time, than if you used traditional pen-and-paper methods or non-specialized software. This course aims to provide you with a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in data manipulation.

This 1 day course builds upon the foundational and intermediate knowledge presented in the Microsoft® Office Excel® 2019: Part 1 and Microsoft® Office Excel® 2019: Part 2 courses to help you get the most of your Excel experience. The ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions will put the full power of Excel right at your fingertips. The more you learn about how to get Excel to do the hard work for you, the more you'll be able to focus on getting the answers you need from the vast amounts of data your organization generates. This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Excel Associate (Office 365 and Office 2019): Exam MO-200 and Excel Expert (Office 365 and Office 2019): Exam MO-201 certifications.

Whether you need to crunch numbers for sales, inventory, IT, HR, or other organizational purposes & departments, the ability to get the right info to the right people at the right time can be powerful. After all, the world runs on data more than ever before & that's a trend not likely to change. But with so much data available and being created on a nearly constant basis, the ability to make sense of that data becomes more critical & challenging with every passing day. You already know how to get Excel® to perform simple calculations & how to modify your workbooks & worksheets to make them easier to read, interpret, and present to others. But, Excel is capable of doing so much more. To be truly competitive, you need to be able to extract actionable organizational intelligence from your raw data. In other words, when you have questions about your data, you need to know how to get Excel to provide the answers for you. And that's exactly what this course aims to help you do.

Organizations the world over rely on information to make sound decisions regarding all manner of affairs. But with the amount of available data growing on a daily basis, the ability to make sense of all of that data is becoming more and more challenging. Fortunately, this is where the power of Microsoft® Office Excel® 2019 can help. Excel can help you organize, calculate, analyze, revise, update, and present your data in ways that will help the decision makers in your organization steer you in the right direction. It will also make these tasks much easier for you to accomplish, and in much less time, than if you used traditional pen-and-paper methods or non-specialized software. This course aims to provide you with a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in data manipulation.

This course builds off of the foundational and intermediate knowledge presented in the Microsoft® Office Excel® 2016 Level 1 and Level 2 courses to help you get the most of your Excel experience. The ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions will put the full power of Excel right at your fingertips. The more you learn about how to get Excel to do the hard work for you, the more you'll be able to focus on getting the answers you need from the vast amounts of data your organization generates. This course covers Microsoft Office Specialist exam objectives to help students prepare for the Excel 2016 Exam and the Excel 2016 Expert Exam. This course is intended for students who are experienced Excel 2016 users and have a desire or need to advance their skills in working with some of the more advanced Excel features.

This course builds upon the foundational knowledge presented in the Microsoft® Office Excel® 2016: Part 1 course and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization that is able to compete at a high level. Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions. You will: Work with functions. Work with lists. Analyze data. Visualize data with charts. Use PivotTables and PivotCharts. This course is designed for students who already have foundational knowledge and skills in Excel 2016 and who wish to begin taking advantage of some of the higher-level functionality in Excel.

Organizations the world over rely on information to make sound decisions regarding all manner of affairs. But with the amount of available data growing on a daily basis, the ability to make sense of all of that data is becoming more and more challenging. Fortunately, this is where the power of Microsoft® Office Excel® 2016 can help. Excel can help you organize, calculate, analyze, revise, update, and present your data in ways that will help the decision makers in your organization steer you in the right direction. It will also make these tasks much easier for you to accomplish, and in much less time, than if you used traditional pen / paper methods or non-specialized software. This course aims to provide you with a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in data manipulation. This course is for students who wish to gain the foundational understanding of MS Office Excel 2016 that is necessary to create and work with spreadsheets

Overview: Excel® Applications are widely used in laboratories, offices and manufacturing e.g., for data capture, data manipulation and report generation. Regulations such as HIPAA, Sarbanes Oxley Act and FDA's GxP and 21 CFR Part 11 require users of software and computer systems to demonstrate and document data accuracy, integrity and confidentiality. Out-of-the box Excel® has not been designed for regulated environments. However, with a good knowledge of Excel® capabilities combined with good procedures and practices on how to validate and use Excel® requirements can be met. For example, the FDA is widely using Excel® and complies with its own regulations.

Overview: "How do I look up a value in list ONE and pick up a related value from list TWO" "How do I avoid my lookup formula displaying an ugly error when it can't find a match?" "I've heard of VLOOKUP but what's HLOOKUP and what’s XLOOKUP?" These are just a few of the questions I get asked on a regular basis. You can get the answers to these questions (and more) by attending this training session dedicated to mastering the various lookup functions that are built into Excel.

Overview: PivotTable capabilities are enormous; among its many tools and features. You will learn the following in this webinar, The quickest and best ways to create PivotTables and Pivot Charts, including these capabilities: The following subjects will be covered in detail: How to compare two or more fields in a variety of layout styles How to sort and filter results How to perform ad-hoc grouping of information How to use Slicers instead of filters to identify which field elements are displayed How to drill down to see the details behind the summary How to categorize date/time data in multiple levels How to create a Pivot Chart that is in sync with a PivotTable How to add calculated fields to perform additional analysis How to hide/reveal detail/summary information with a simple click How to deal with dynamic source data and the "refresh" concept How to create a PivotTable based on data from multiple worksheets

Overview: If you're looking for ways to improve the integrity of your decision-making formulas other than relying on Excel's IF function, you'll find this presentation quite helpful. Excel expert David Ringstrom, CPA, briefly discusses the IF function and then, in detail, takes you beyond the basics. He explains what can go awry with the IF function, and he then shares alternatives to using the IF function, including IFNA, MINIFS, SUMPRODUCT, and others. David's assertion is that if you're nesting more than a couple of IF functions, there are probably more refined and resilient approaches you can take.

How to compare two or more fields in a variety of layout styles How to sort and filter results How to perform ad-hoc grouping of information How to use Slicers instead of filters to identify which field elements are displayed How to drill down to see the details behind the summary How to categorize date/time data in multiple levels How to create a Pivot Chart that is in sync with a PivotTable

This webinar will show you how to use the tools sort and filter and subtotals in Excel to really help get the most out of your data, be more efficient, and find the information that you are looking for. Attend this webinar if you are using MS Office in a business or educational setting to create reports and presentations.

This webinar on how to use VLOOKUP, MATCH and INDEX, which will help you tremendously. In this webinar you will learn about VLOOKUP function in Excel, which enables you to quickly and easily look for a value down a column of data and return a value from the same row in a different column.