Courses
Microsoft Excel 365 Data Analysis, Part 1 of 4: Functions and Formulas
Understanding when and how to use advanced functions and arrays is an important step in mastering data analyzation in Excel. Discover the importance of multiple functions including logical and conditional functions, financial and statistical function...
Microsoft Excel 365 Data Analysis, Part 2 of 4: Lookups and DataTables
Excel contains an endless amount of useful data tools to help you sift, sort, and present data. Explore some of these convenient tools including Lookup functions, Data Tables, Validating Cells, and tools for filtering data and creating charts and gra...
Microsoft Excel 365 Data Analysis, Part 3 of 4: PivotTables and PivotCharts
Data summarization is essential when managing large datasets. This course will take a closer look at PivotTables, PivotCharts, PowerPivot, and importing and exporting data in Excel. Learn about building, modifying, and formatting PivotTables from giv...
Microsoft Excel 365 Data Analysis, Part 4 of 4: Analytical Tools
Explore an amazing set of topics in analysis and forecasting in this course which covers topics including Goal Seek, Scenarios, Solver, and Data Analysis. Learn to use Goal Seek’s capabilities when a value is unknown, explore Scenarios which allow fo...
Microsoft Excel 365 Data Analysis: Parts 1 through 4 Exam Only
Exam only version of Microsoft Excel 365 Data Analysis, Part 1 of 4: Functions and Formulas Microsoft Excel 365 Data Analysis, Part 2 of 4: Lookups and DataTables Microsoft Excel 265 Data Analysis, Part 3 of 4: PivotTables and PivotCharts Mic...
Microsoft Excel 2016 Data Analysis, Part 1 of 4: Functions and Formulas
Understanding when and how to use advanced functions and arrays is an important step in mastering data analyzation in Excel. Discover the importance of multiple functions including logical and conditional functions, financial and statistical function...
Microsoft Excel 2016 Data Analysis, Part 2 of 4: Lookups and DataTables
Excel contains an endless amount of useful data tools to help you sift, sort, and present data. Explore some of these convenient tools including Lookup functions, Data Tables, Validating Cells, and tools for filtering data and creating charts and gra...
Microsoft Excel 2016 Data Analysis, Part 3 of 4: PivotTables and PivotCharts
Data summarization is essential when managing large datasets. This course will take a closer look at PivotTables, PivotCharts, PowerPivot, and importing and exporting data in Excel. Learn about building, modifying, and formatting PivotTables from giv...