Advance Excel

Introduction

Microsoft Excel is a spreadsheet program that is used to record and analyse numerical data. Think of a spreadsheet as a collection of columns and rows that form a table. ... The point where a column and a row meet is called a cell

As advance excel by Microsoft is used for personal as well as professional use for Reporting, analyzing data, graph presentation, data management, and inventory and much more. So people believe that training of advance excel is costly but it’s not right, one can get it at nominal fee at Expert Computer Education. This Training is very helpful in completing various tasks of management in any organization.

Course Syllabus

What is MS Excel?
How to Use of Shortcut keys of Excel
What is Formatting/ Conditional Formatting?
What is Formulas? in Excel
What is Logical & Text Functions?
What is Filter and Data Validation in MS Excel
How to use Pivot Tables for Data Analysis.
How to Protect Worksheet.
What is Name Range function? in Excel
How to draw Charts.
Trends and Scenarios using charts.
What is Data Tool?
How to record Macro in Excel
Introduction to Dashboards.
Advanced Charting Techniques using.
Thermometer, Doughnut, Pareto, Panel, Step Chart.
Designing Sample Dashboard using Form Controls.
Tips and Tricks to enhance dashboard designing.
Introduction and Basic Overview Working with Workbook and Worksheets Formatting Cells.
Customized formatting of Cells in Excel
Cell References (Absolute, Relative & Mixed) Shortcut Keys .
Other Features (Paste Special and finding and replacing data etc.).
Text Formulas (CONCATENATE, UPPER, LOWER, PROPER, DATE, MOD, MODE, TODAY, NOW) Inserting Comments.
Use of Go to Feature.
Use of ? to Join data in different cells Logical formula (IF function and its use) Conditional Formatting and its Use in different scenarios.
Logical Complex Formulas (IF, OR, AND & IFERROR) Use of Nested IF formula with examples.
Other Text Formulas (TEXT, CLEAN, TRIM, Len.
COUNT, COUNTA,COUNTBLANK, COUNTIF, SUBTOTAL.
Defining Cell Range & Name Manager.
Applying Auto filter Use of Advanced Filter.
Displaying Unique Record by using Advanced Filter Freezing and Unfreezing Panes Linking of Worksheets & Workbooks.
Open websites, existing files etc by Inserting Hyperlink More useful formulas (RIGHT, LEFT, LEN, FIND, SUMIF & SUMPRODUCT) Formatting
Financial Formulas (PMT, PV, DISC, DB, IRR, NPV etc.) Text to Column to fetch data.
Lookup & Reference cell Formulas (CELL, ADDRESS, ROW, COLUMN, LOOKUP, VLOOKUP, HLOOKUP, MATCH, OFFSET, SUMPRODUCT.