Introduction:
Organizations today have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. Data analysis & representation is indispensable to facilitate decision making and strategy development. It’s very challenging to turn a huge amount of data into useful information without the help of Excel.
The Advanced Excel Course is designed for executives who are already familiar with the basics of Microsoft Excel, and who would like to work with more advanced features of Microsoft Excel that help in improving their efficiency of working with worksheets, analyzing data, creating MIS reports, and automating various tasks. In this course, you will use Microsoft Office Excel to streamline and enhance your spreadsheets with templates, charts, graphics, data analysis and formulas.
Demonstration will be based on the MS Office version.
Program Outline:
Advanced Formulas and Functions:
Advanced Logical
Advanced Lookup & Reference Functions
What-If Analysis (Data Analysis)
Scenario Analysis
Goal Seek
Data Table
Advanced Conditional Formatting
Advanced Filters
Working on the large size files
Sparklines, Slicers & Timelines
Advanced Pivot Tables
PivotTable calculations
Using slicers in PivotTables
Conditional formatting in PivotTables
Creating PivotCharts
Advanced Charting
Importing data from different sources
Avoid manual data entry – User restrictions with Data Validation
Macros
Recognizing situations ideal for creating macros
How to create a macro by recording, and why this is usually the best way to create a macro
Four ways to run a macro: keystroke shortcut, toolbar button, command, or graphic
Ways to work with macro code (in the language called Visual Basic), created when you record command sequences
How to use the step method to test a macro slowly
Understanding when you need to add code to a macro and efficient ways to do it
Ways to extend the power of macros to perform tasks you cannot achieve with standard Excel features
Tips & Tricks
Benefits of this Advanced Excel Workshop:
Perform complex calculations more efficiently, using various Excel functions.
Create Dashboards and MIS reports.
Consolidate and manage data from multiple workbooks.
Save Time by Automating Repetitive Tasks with Simple-to-Use Macros
IITD Sr. Expert Faculty:
Highly experienced faculty from Indian Institute of Training & Development will conduct this training. The training sessions will provide participants an opportunity to discuss specific problems with the expert faculty.
Medium: English/ Hindi/ Marathi
Fees and Registration:
Rs. 2,600 + GST 18% per person.
Rs. 2,400 + GST 18% per person for a group of Three to Four participants.
Rs. 2,200 + GST 18% per person for a group of Five or more participants.
Kindly provide details for registration to Email: iitdpune@gmail.com & rajiv@iitdworld.com; Name of the Program, name of the participants, company name, GST no., contact details.
Certification:
Digital Certificate of Participation will be provided to all the participants.