Microsoft Excel Level 3 – Office 2016/Office 365
Take your Microsoft Excel skills to the next level and enroll now and receive step-by-step mentoring on mastering Microsoft Excel at an advanced level. You will learn how to work with additional Excel features including: macros, advanced conditional formatting, digital signatures, power view and consolidating data.
2 Days
Microsoft Excel
7 PDUs
Personal Development Unit
MS Excel Level 3 – Advance
WORKING WITH MULTIPLE WORKSHEETS & WORKBOOKS
- Use Links and External References
- Use 3-D References
- Consolidate Data
USING LOOKUP FORMULAS AND FORMULA AUDITING
- Use Lookup Functions
- Trace Cells
- Watch and Evaluate Formulas
SHARING AND PROTECTING WORKBOOKS
- Collaborate on a Workbook
- Protect Worksheets and Workbooks
AUTOMATING WORKBOOK FUNCTIONALITY
- Apply Data Validation
- Search for Invalid Data and Formulas with Errors
- Work with Macros
CREATING SPARKLINES AND MAPPING DATA
- Create Sparklines
- Map Data
FORECASTING DATA
- Determine Potential Outcomes Using Data Tables
- Determine Potential Outcomes Using Scenarios
- Use the Goal Seek Feature
- Forecasting Data Trends
Workshop Wrap-Up
At the end of the course, students will have an opportunity to ask questions.
