Microsoft Excel 2016 Advance Online Course

Course Curriculum

➤ Module 01 - Working with Multiple Worksheets and Workbooks

1.0 Topic A: Use Links and External References

2.0 Topic B: Use 3-D References

3.0 Topic C: Consolidate Data

➤ Module 02 - Using Lookup Functions and Formula Auditing

1.0 Topic A: Use Lookup Functions

2.0 Topic B: Trace Cells

3.0 Topic C: Watch and Evaluate Formulas

➤ Module 03 - Sharing and Protecting Workbooks

1.0 Topic A: Collaborate on a Workbook

2.0 Topic B: Protect Worksheets and Workbooks

➤ Module 04 - Automating Workbook Functionality

1.0 Topic A: Apply Data Validation

2.0 Topic B: Search for Invalid Data and Formulas with Errors

3.0 Topic C: Work with Macros

➤ Module 05 - Creating Sparklines and Mapping Data

1.0 Topic A: Create Sparklines

2.0 Topic B: Map Data

➤ Module 06 - Forecasting Data

1.0 Topic A: Determine Potential Outcomes Using Data Tables

2.0 Topic B: Determine Potential Outcomes Using Scenarios

3.0 Topic C: Use the Goal Seek Feature

4.0 Topic D: Forecasting Data Trends

Learning Outcomes

• Use Advanced Lookup Functions
• Use Complex Logical and Text Functions
• Use Advanced IF Statements
• Auditing Formulas
• Working with What-If Analysis Tools
• Protecting Worksheet and Workbook
• Use Advanced PivotTables and PowerPivot Tools
• Automate with Macros
• Work with Form Controls
• Ensure Data Integrity
• Collaborate in Excel
• Import and Export Data to a Text File

Progression and Career Path

Once you successfully complete the Microsoft Excel 2016 Advanced course you will be qualified to work with enhanced confidence in the following positions. Also, your potential will be highlighted by the way you manage, organize, present, and distribute your company’s data and information.

• Office Administrator – £17,158 per annum
• Office Manager – £24,073 per annum
• Receptionist – £15,961 per annum
• Personal Assistant – £25,003 per annum
• Project Assistant – £20,785 per annum
• Business Executive – £23,667 per annum
• Secretary – £19,460 per annum
• Business Analyst – £35,543 per annum
• Technical Support Analyst – £22,753 per annum

Other Benefits

• Written and designed by the industry’s finest expert instructors with over 15 years of experience
• Repeat and rewind all your lectures and enjoy a personalised learning experience
• Gain access to quality video tutorials
• Unlimited 12 months access from anywhere, anytime
• Excellent Tutor Support Service (Monday to Friday)
• Save time and money on travel
• Learn at your convenience and leisure
• Quizzes, tests mock exams, practice exams to ensure you are 100% ready
• Eligible for an NUS discount card
• Free Career Support Service
• 25% Discount on personal Statement and covering letter writing service
• Free Access to Over 150 courses for 2 days (48 hours)
• Free access to the course before you purchase (For selected courses only)