Data Analysis & Visualization
Microsoft Excel Training
Basic to Advanced
OVERVIEW
Organizations all over the world 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 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.
Course Learning Outcomes
- Manage workbooks
- Work with functions
- Analyze data
- Visualize data with charts
- Use PivotTables and PivotCharts
- Work with multiple worksheets and workbooks
- Share and protect workbooks
- Automate workbook functionality
- Use lookup functions and formula auditing
- Forecast data
- Create sparklines and map data
Course Audience Profile
This course is intended for students who wish to gain the foundational understanding of Microsoft Office Excel 2019 that is necessary to create and work with electronic spreadsheets.
- Module 1: Getting started with Excel 2019
- Module 2: Performing Calculations
- Module 3: Modifying Worksheets
- Module 4: Formatting Worksheets
- Module 5: Printing Workbooks
- Module 6: Managing Workbooks
- Module 7: Basic Excel Customizations & Common Keyboards Shortcuts
- Module 1: Working with Functions
- Module 2: Working with List
- Module 3: Analysing Data
- Module 4: Visualizing Data with Charts
- Module 5: Using PivotCharts and PivotTables
Financial Functions
Working with Graphical Objects
Internationalizing Workbooks
Using Array Formulas
- Module 1: Working with Multiple Worksheets and Workbooks
- Module 2: Sharing and Protecting Workbooks
- Module 3: Automating Workbook Functionality
- Module 4: Using Lookup Functions & Formula Auditing
- Module 5: Forecasting Data
- Module 6: Creating Sparklines and Mapping Data
Cube Functions
Importing and Exporting Data
Internationalizing Workbooks
Working with Power Pivots
Advanced Customization Options
Working with Forms and Controls
