Home > Data Science > Certificate in Advanced MS Excel 2016
Certificate in Advanced MS Excel 2016
Add a highly valuable skill to your resume by mastering the essential tools and features of Microsoft Excel with our advanced online excel course.
-
11378
learners -
106 hours
of learning -
3 hours of doubt
clearing sessions (online) -
25 hours
of videos
11378
learners
learners
106 hours
of learning
of learning
3 hours of doubt
clearing sessions (online)
clearing sessions (online)
25 hours
of videos
of videos
₹
6,400
Ask us everything about the program
Certificate in Advanced MS Excel 2016
_
Overview
-
Recognition at Work70% learners got more recognition after completing the Microsoft Excel certification course. -
Enhanced Job Opportunities20% of our learners got jobs immediately after completing the advanced excel course online. -
Who Should AttendEntry to senior level managers, graduates aspiring for entry-level jobs -
Essential SkillEmployees with a sound knowledge of Excel are considered as a valuable asset. -
Expert FacultyLearn from experts with a vast experience in Microsoft Excel 2016.
Recognition at Work
70% learners got more recognition after completing the Microsoft Excel certification course.
Enhanced Job Opportunities
20% of our learners got jobs immediately after completing the advanced excel course online.
Who Should Attend
Entry to senior level managers, graduates aspiring for entry-level jobs
Essential Skill
Employees with a sound knowledge of Excel are considered as a valuable asset.
Expert Faculty
Learn from experts with a vast experience in Microsoft Excel 2016.
About Course
Microsoft Excel is one of the most widely used tools for organising, analysing, modelling, and visualising data. Proficiency with Microsoft Excel is a highly desired skill-set in today’s complex business environment, one that can position you way ahead of your peers.
With Manipal ProLearn’s online Microsoft Excel certification, you’ll learn how to design sophisticated spreadsheets from scratch and perform complex calculations using advanced Excel features and techniques. One of the best online excel training courses available, it’ll enable you to solve a broad range of real-time business problems and help you propel your career forward.
What skills you learn
After completing this advanced excel course online, you’ll find yourself competent using Microsoft Excel and ready to take the Microsoft Excel certification exam. This advanced excel certification course will help you:
- Master Excel Functions and Formulas that save time and increases productivity
- Cut hours of labour by using Pivot tables to analyse data
- Discover new tools to share your work
- Find new and more efficient ways to analyse data
- Add colour and images to improve readability and get messages across to the audience more effectively
- Learn the tricks to produce professional charts and graphs
- Include diagrams in marketing reports and sales presentations to boost sales and readability
- Find new ways to visualise data
- Reduce workload each month by automating repetitive tasks by using macros
- Import data using Power Pivot
- Prepare better for your exam with tips, tricks & strategies
Who Should Attend this course
Entry to senior level managers in any industry
Engineering/IT Graduates
Management/Commerce Graduates
Students aspiring for entry-level jobs in any industry
Entry to senior level managers in any industry | Engineering/IT Graduates |
Management/Commerce Graduates | Students aspiring for entry-level jobs in any industry |
Key Features
Prep for Microsoft Office Specialist Exam
The program is oriented towards preparing you for Microsoft Office Specialist certification exam.
Comprehensive Course Curriculum
An online excel certification course taught through videos, case studies, reading material, simulated mock tests, and live online sessions by experts.
Superior Learning Outcome
Upon successful completion of the MS Excel online training, you’ll become a pro in excel techniques like Formatting Data, Formulas & Functions, Vlookup, Hlookup, Pivot Table, VBA-Macros, Data Validation, etc.
Request a Call Back
_
Course Curriculum
1.1 Introducing Microsoft Excel
Starting Excel
Worksheets and Workbook
Understanding the User Interface
Quick Access Toolbar
Ribbon
Formula Bar
Worksheet Area
Worksheet Tab
Status Bar
Saving Excel Workbook
Creating New Excel Workbook
Opening Existing Excel Workbook
1.2 Working with Workbook and Worksheets
Concept of Tabular Data
Cell Nomenclature
Editing Workbook
Editing Worksheets
Adjust Row Height and Column Width
Modify Document Properties
Change Magnification by using Zoom Tools
Entering Data
AutoComplete, Pick From Drop-Down List
Auto Fill, Fill Series
1.3 Introducing Excel Tables Formulas and References
Organizing Data in Excel Tables
Transposing Rows Into Columns
Creating Simple Formulas
Relative vs. Absolute Reference
Introduction to Excel Functions
1.4 Formatting Data
Common Font Formatting
Font Type & Size
Font Colour
Font Style
Cell Border
Fill Colour
Cell Alignment
Text Alignment
Text Orientation
Text Indentation
Text Wrapping
Merging Cells
Formatting Numbers
Number Format
Currency Format
Accounting Format
Format As Percent
Decimal Formatting
Additional Cell Formatting Features
Applying Styles
Conditional Formatting
Using Format Painter
Change Workbook Themes
1.5 Inserting Objects in Worksheets
Inserting Pictures
Inserting Hyperlinks
Inserting Drawing Objects
Inserting Symbols and Equations
Add alternative text to objects for accessibility
1.6 Managing Data in Excel
Setting Named Range
Finding and Replacing Data
Inserting Cut or Copied Cells
Sorting Worksheet Data
Filtering Worksheet Data
Adding, Displaying, Editing, and Removing Comments
Search for Data within a Workbook
Smart Lookup
Spell Check
Track Changes
1.7 Excel Formulas and Functions
Text Formulas
Mathematical and Statistical Formulas
Date and Time Formulas
Logic Formulas
Financial Formulas
Informational Formulas
2.1 References and LOOKUPs
What is VLOOKUP and HLOOKUP?
Comparing Lists
Looking to the Left
Wildcard Search
2-Way Lookup
VLOOKUP Tips and Tricks
2.2 Excel Tables
Format Excel List as Excel Table
Filtering Records in an Excel Table
Filter Records Using an Excel Slicer
Adding Row Calculations and Changing the Table Size
Adding the Total Row to an Excel Table
2.3 Working with Charts
Common type of Charts in Excel
Chart Tools Tabs
The Anatomy of a Chart
Creating Charts
Changing Chart Type
Editing Charts
Changing Data Source
2.4 Working with Pivot Table
Pivot Table Tools Tabs
Pivot Table Field List Task Pane
Applying Style to Pivot Table
Applying Filters and Slicers
Inserting Pivot Charts
Customizing Pivot Table
Analysing Pivot Table Data
2.5 What If Analysis - Goal Seek and Scenario Manager
Using Goal Seek
Using Scenario Manager
2.6 Data Analysis and Validation
Importing Data from Other Sources
Converting Text to Columns
Formula Auditing
Removing Duplicates
Data Validation and Inserting References
Using Groups and Subtotals
2.7 Macros
Recording Macro
Managing Macro Security Level in Excel
Running Macro
Editing Macro
3.1 Printing Excel Workbooks
Page Layout
Setting Up Your Page
Printing Your Worksheet
Applying Background
Printing Headers and Footers
Printing Data
3.2 Managing Excel Files
Saving Excel Files in Different Formats
Emailing Workbooks
Sharing Workbooks
Protecting Workbooks
Change Workbook Views
Change Window Views
3.3 Visual Basic for Application
Visual Basic for Applications
Basic Concepts - Procedures and Variables
Basic Concepts - Loops and Conditional Logic
3.4 Case Study 1 - Editing an Excel Macro in VBA
Editing a Macro in Excel's Visual Basic Editor
Record Macro
Understand Macro Code
Edit the Macro Code
Worksheets Object
Declare Variables for User Input
Run the edited Macro
3.5 Case Study 2 – Creating User Forms in VBA
Create a User Form
Adding Controls to Form
Editing the Properties of Form Controls
Populating ComboBox with Worksheet Names
Change Event for ComboBox Control
Adding Code to Button Control
Setting a Value to the Text Box Control
Adding Code to Open Event of Workbook
3.6 Case Study 3 – Custom Excel Functions
Create a User Defined Custom Function
Adding Conditional Logic to Function
Adding Help to User Defined Function
How to use User Defined Function in Worksheet
3.7 Case Study 4 – Conditional Logic in VBA
Automate the SUM Function
Automate SUM Function for all worksheets
_
Frequent Questions we get
Is the price of the program inclusive of taxes?
The price mentioned on the page is inclusive of all taxes and you do not have to pay anything over and above that.
What is the course duration?
The duration of the course is 3 months. You simply need to invest 1 hour every day for 90 days to become a master in MS Excel.
Which version of MS Excel will be taught in this course?
MS Excel 2016.
Do I have to pay separately for the exam?
Not at all. The exam fee is included in the fee.
What is the passing mark?
The minimum passing marks for the Advanced MS Excel 2016 course exam are 50%.
What if I am not able to pass the exam?
No sweat. If you are not able to pass the exam in the first attempt, you will get two more shots at your exam, and that too FREE!
Didn’t find your question here? What would you like to know?
Ask a Question add_circle_outline
_
Read up our trending blogs
Apr 04
Top Five Skills Necessary to Set Up a Stellar Career in Cyber Security
The mind-boggling pace at which technologies continue to evolve has opened a whole new front of...
1930
Apr 04
How to Get Hands-On Experience in Cyber Security
This is the best time to take up a career in Cyber Security! The ever-growing market for experts...
1870
Apr 04
3 Steps to create an AI-First Enterprise
Smarter organisations are already adopting AI to reduce time-to-market and enable better customer...
1975
