Experts Exchange > Courses > Microsoft Excel 2016 Data Analysis
Microsoft Excel 2016 Data Analysis
- Category
- Office Productivity
- Level
- Beginner
- Lessons
- 58
- Duration
- 3h 57m 50s
- Microsoft Applications
Microsoft Applications
- Microsoft Office
Microsoft Office
- Office Productivity
Office Productivity
- Microsoft Excel
Microsoft Excel
- Business Administration
Business Administration
Last Updated:
2019-03-25
We will begin this course with an introduction to functions and formulas, including logical and conditional functions, financial and statistical functions, and date/time and arrays.
Then we’ll move onto lookups and data tables, during which we will also discussing validating cells, filtering, charting, and graphics.
Next you will learn about PivotTables, including how to work, modify, format, and use them, as well as exporting, importing, and modifying data. We will also cover the PowerPivot.
Lastly, we will cover analytical tools, including goal seek, scenarios, solver, and instant data analysis.
Then we’ll move onto lookups and data tables, during which we will also discussing validating cells, filtering, charting, and graphics.
Next you will learn about PivotTables, including how to work, modify, format, and use them, as well as exporting, importing, and modifying data. We will also cover the PowerPivot.
Lastly, we will cover analytical tools, including goal seek, scenarios, solver, and instant data analysis.
- Category
- Office Productivity
- Level
- Beginner
- Lessons
- 58
- Duration
- 3h 57m 50s
- Microsoft Applications
Microsoft Applications
- Microsoft Office
Microsoft Office
- Office Productivity
Office Productivity
- Microsoft Excel
Microsoft Excel
- Business Administration
Business Administration
Microsoft Excel 2016 Data Analysis - Module 01 - Functions and Formulas
Topic A: Logical and Conditional Functions - Part 1
3 lessons27m 29sCompleted 0 / 3
Topic B: Financial and Statistical Functions - Part 1
3 lessons19m 18sCompleted 0 / 3
Topic C: Date/Time and Arrays - Part 1
4 lessons13m 05sCompleted 0 / 4
Microsoft Excel 2016 Data Analysis - Module 02 - Lookups and Data Tables
Topic A: Lookup Functions - Part 1
3 lessons8m 41sCompleted 0 / 3
Topic B: Data Tables - Part 1
3 lessons12m 15sCompleted 0 / 3
Topic C: Validating Cells - Part 1
3 lessons15m 09sCompleted 0 / 3
Topic D: Filtering - Part 1
3 lessons10m 10sCompleted 0 / 3
Topic E: Charting and Graphics - Part 1
4 lessons17m 29sCompleted 0 / 4
Microsoft Excel 2016 Data Analysis - Module 03 - PivotTables
Topic A: Working with PivotTables - Part 1
3 lessons13m 21sCompleted 0 / 3
Topic B: Modifying PivotTable Data - Part 1
3 lessons9m 46sCompleted 0 / 3
Topic C: Formatting PivotTables - Part 1
3 lessons16m 57sCompleted 0 / 3
Topic D: Using PivotCharts - Part 1
3 lessons4m 19sCompleted 0 / 3
Topic E: PowerPivot - Part 1
3 lessons12m 22sCompleted 0 / 3
Topic F: Exporting and Importing Data - Part 1
4 lessons8m 27sCompleted 0 / 4
Microsoft Excel 2016 Data Analysis - Module 04 - Analytical Tools
Topic A: Goal Seek - Part 1
3 lessons7m 21sCompleted 0 / 3
Topic B: Scenarios - Part 1
3 lessons17m 45sCompleted 0 / 3
Topic C: Solver - Part 1
3 lessons12m 20sCompleted 0 / 3
Topic D: Instant Data Analysis - Part 1
4 lessons11m 36sCompleted 0 / 4
Sondra Nelson
I am a Microsoft Certified Trainer and have been teaching Microsoft Office for over 15 years. I have both teaching and consulting experience with high school students, college students and corporate employees.
Sondra NelsonSoftware Program Engineer & Instructor
- Services
- Individual | Training
- SMB | Training
- Enterprise
- Pricing
- Experts
- Certified Professionals
- Apply Now
- Company
- About
- Topics
- Careers
- Contact Us
© 1996-2019 Experts Exchange, LLC. All rights reserved. Covered by US Patent.