Overview
Excel 2019 – Level 1
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 MOS 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.
Excel 2019 – Level 2
This course builds upon the foundational knowledge presented in the Microsoft Office Excel 2019-Level 1 course and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your understanding or 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 manipulation.
This course covers MOS 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.
Excel 2019 – Level 3
This course builds upon the foundational knowledge presented in the Microsoft Office Excel 2019-Level 1 & 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 MOS 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.
Prerequisites
Excel 2019 – Level 1
To ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and a mouse. Students should also be comfortable working in the Windows 10 environment and be able to use Windows 10 to manage information on their computers. Specific tasks the students should be able to perform include: opening and closing applications, navigating basic file structures, and managing files and folders. To obtain this level of skill and knowledge, you can take either one of the following Logical Operations courses:
- Using Microsoft Windows 10
- Microsoft Windows 10: Transition from Windows 7
Excel 2019 – Level 2
- Excel 2019 – Level 1
Excel 2019 – Level 3
- Excel 2019 – Level 1
- Excel 2019 – Level 2
Course Outline Level 1
- Navigate the Excel User Interface
- Use Excel Commands
- Create and Save Basic Workbook
- Enter Cell Data
- Use Excel Help
- Create Worksheet Formulas
- Insert Functions
- Reuse Formulas and Functions
- Insert, Delete, and Adjust Cells, Columns, Rows
- Search for and Replace Data
- Use Proofing and Research Tools
- Apply Text Formats
- Apply Number Formats
- Align Cell Contents
- Apply Styles and Themes
- Apply Basic Conditional Formatting
- Create and Use Templates
- Preview and Print a Workbook
- Set Up the Page Layout
- Configure Headers and Footers
- Manage Worksheets
- Manage Workbook and Worksheet Views
- Manage Workbook Properties
Course Outline Level 2
- Work with Ranges
- Use Specialized Functions
- Work with Logical Functions
- Work with Date & Time Functions
- Work with Text Functions
- Sort Data
- Filter Data
- Query Data with Database Functions
- Outline and Subtotal Data
- Create and Modify Tables
- Apply Intermediate Conditional Formatting
- Apply Advanced Conditional Formatting
- Create Charts
- Modify and Format Charts
- Use Advanced Chart Features
- Create a PivotTable
- Analyze PivotTable Data
- Present Data with PivotCharts
- Filter Data by Using Timelines and Slicers
Course Outline Level 3
- Use Linked and External References
- Use 3-D References
- Consolidate Data
- Collaborate on a Workbook
- Protect Worksheet and Workbooks
- Apply Data Validation
- Search for Invalid Data and Formulas with Errors
- Work with Macros
- Use Lookup Functions
- Trace Cells
- Watch and Evaluate Formulas
- Determine Potential Outcomes Using Data Tables
- Determine Potential Outcomes Using Scenarios
- Use the Goal Seek Feature
- Forecast Data Trends
- Create Sparklines
- Map Data
