Take your skills to the next level with this advanced Excel training course. Harness the power of Excel and become an advanced user.

Introduces the features of Microsoft Excel and spreadsheet concepts to design and create accurate professional worksheets for use in business and industry, and academic environments. Includes entering data; creating formulas; professional formatting; creating charts; creating, sorting, and filtering lists; creating and using templates; and working with functions. Make MIS and dashboards using tools and formulas.

Students who have intermediate skills with Microsoft Excel who want to learn more advanced skills or students who want to learn the topics covered in this course in the course interface.

After completing this course, students will be able to: Insert the course objectives in a bulleted list with periods. For example.

Create pivot tables and charts

Learn to trace precedents and dependents

Learn functions and dependents calculation

Convert text and validate and consolidate data.

Create, use, edit, and manage macros

Import and export data

This Advanced Microsoft Excel 2016 training class is designed for students to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros.

What is the Excel?, Excel Application Setting - Calculation, Vba Tab options, Edit Custom list, Worksheet Calculation, Autocorrect Option, Macro Enable / Disable
Shortcuts, keyboard shortcuts, navigation shortcuts, Paste Special - many more paste options
Name Manager and Subtotal tools, Validation and Text to Columns
Conditional formatting - New Formatting Rule dialog box, Data Shorting, Filter and Selection Concept
Data Analyzing with Pivot - Chart , multiple conditions, Over 60 Most useful Excel formulas with examples
Page setting, Excel Protection System - Sheet, Cells, window, Hide Formulas, Insert Other Application in Excel Sheet - Links and file, Hyperlink
Basic Macro introduction, Vba Project, procedures and write some Vba code.

No Additional reading just do practice on sheet given by institute.