- 106 hours
- 3 hours of doubt
clearing sessions (online)
- 25 hours
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.
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.
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
Entry to senior level managers in any industry
Students aspiring for entry-level jobs in any industry
Worksheets and Workbook
Understanding the User Interface
Quick Access Toolbar
Saving Excel Workbook
Creating New Excel Workbook
Opening Existing Excel Workbook
Concept of Tabular Data
Adjust Row Height and Column Width
Modify Document Properties
Change Magnification by using Zoom Tools
AutoComplete, Pick From Drop-Down List
Auto Fill, Fill Series
Organizing Data in Excel Tables
Transposing Rows Into Columns
Creating Simple Formulas
Relative vs. Absolute Reference
Introduction to Excel Functions
Common Font Formatting
Font Type & Size
Format As Percent
Additional Cell Formatting Features
Using Format Painter
Change Workbook Themes
Inserting Drawing Objects
Inserting Symbols and Equations
Add alternative text to objects for accessibility
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
Mathematical and Statistical Formulas
Date and Time Formulas
What is VLOOKUP and HLOOKUP?
Looking to the Left
VLOOKUP Tips and Tricks
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
Common type of Charts in Excel
Chart Tools Tabs
The Anatomy of a Chart
Changing Chart Type
Changing Data Source
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
Using Goal Seek
Using Scenario Manager
Importing Data from Other Sources
Converting Text to Columns
Data Validation and Inserting References
Using Groups and Subtotals
Managing Macro Security Level in Excel
Setting Up Your Page
Printing Your Worksheet
Printing Headers and Footers
Saving Excel Files in Different Formats
Change Workbook Views
Change Window Views
Visual Basic for Applications
Basic Concepts - Procedures and Variables
Basic Concepts - Loops and Conditional Logic
Editing a Macro in Excel's Visual Basic Editor
Understand Macro Code
Edit the Macro Code
Declare Variables for User Input
Run the edited Macro
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
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
Automate the SUM Function
Automate SUM Function for all worksheets
The price mentioned on the page is inclusive of all taxes and you do not have to pay anything over and above that.
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.
MS Excel 2016.
Not at all. The exam fee is included in the fee.
The minimum passing marks for the Advanced MS Excel 2016 course exam are 50%.
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!
As soon you pay for the course, you will be provided with a login and password to access EDUNXT.MANIPALPROLEARN.COM. You can find all the information and study material related to your course on the EDUNXT.MANIPALPROLEARN.COM platform. You can access this platform 24x7x365, download PDF files of study material and chat with faculty, when in doubt.
You will have 12 months of access to the course material.;
Students get to practice the concepts hands-on via a simulated environment run on Adobe Captivate. If you get stuck on MS Excel, it will help you at each and every step.
The number of webinars may vary. Each webinar session will be for 2 to 2 ½ hours. The timing of the webinar will be shared 4-5 days in advance, via e-mail.
No. The webinars are conducted online and can be accessed from even the comfort of your home.
In case you are unable to attend the live webinar, you can access the recorded version of the webinar on the EDUNXT.MANIPALPROLEARN.COM.
Yes, of course. You can watch all the recorded version of all the webinars, how many ever times you want during the course duration.
No, while there are no pre-requisites for the Advanced MS Excel course, having a little background knowledge of MS Excel will be helpful.
You can pay through your debit card or net banking in one shot. You can also pay by Credit Card from all the leading banks. EMI Option can be availed when using a credit card (interest will have to be borne by you).
In case, there is something more that you want to know, then please do call us at our toll-free number 1800-103-5941 or drop us a mail at firstname.lastname@example.org