Microsoft Excel Part 3 (Advanced)

About the Course:
Microsoft Excel Training at BIT aims to impart basic skills in using Excel to its best. Participants will learn to use statistical, math, and logical functions, organize data using filter and sort and effectively present data for quick decision making using charts and graphs. Participants will also gain some advanced skills in Excel, such as using VLOOKUP, PivotTables, and Macros among others.
This Excel 2016 Course is ideal for any business user or student or beginners as well as advanced users who wish to maximize their productivity using Microsoft Excel 2016.

Exams:
Pre and Post Course Tests

Course Duration:
8 Hours

Awarding Body:
Microsoft

Pre-Requisites:
Learners have the following pre requisites courses
• Microsoft® Office Excel® 2016: Part 1
• Microsoft® Office Excel® 2016: Part 2

Target Audience:
Accountants , Secretaries, Office Admins, All computers Using
Professionals & Job seekers

Modules:
Lesson 1: Working with Multiple Worksheets and Workbooks
Lesson 2: Using Lookup Functions and Formula Auditing
Lesson 3: Sharing and Protecting Workbooks
Lesson 4: Automating Workbook Functionality
Lesson 5: Creating Sparklines and Mapping Data
Lesson 6: Forecasting Data

Upon Completion of this Course, you will accomplish following:-
• Learn Working with Multiple Worksheets and Workbooks
• Using Lookup Functions and Formula Auditing
• Learn Sharing and Protecting Workbooks
• Learn Automating Workbook Functionality
• Creating Sparklines and Mapping Data , Forecasting Data
• Create different variations of charts and graphs that can be used to represent real life scenarios
• Manipulate data to gather useful action-oriented information
• Analyze and sort/filter data to create powerful and captivating pivot tables