Advance Excel Classes (16 Days)

Learn advanced excel from the very basic of copy-paste to writing advance functions like offset, index, indirect and many more. You will learn how to create professional dashboards using excel features like pivots, graphs, subtotals and many more. Weekend batches also available.

Introduction to New Excel:

• Intro to a new version of Excel.

• Changing the defaults in excel.

• Customize Quick Access Toolbar.

• Look beyond the basic copy paste.

• Customizing list.

• Using Autofill

• Quick Data Entry tips.

• Basic cell formatting

• Using Conditional Formatting.

• Power for Tables.

• Hiding the unrequired.

• Using grouping and outline.

• Freeze panes and split screen.

• Create your own templates.

Formatting

Excel Formulas

• Basic Excel Functions.

• Using IF and multiple IFs

• Using Sumif, Countif, Sumproduct

• Lookup Functions

• Getpivot Function

• Get Dynamic with Offset function

• Pmt Function and much more...

Data Analysis

• Explore Pivot Tables

• Scenarios and Goal Seek

• Excel References

• Subtotals

• Getting access data to excel

• Explore Excel Charts

• Creating Dynamic Charts.

Project: Creating Dashboard
Sales and commission tracking

• Gather reporting requirement.

• Create layout to gather data.

• Design summary page.

• Define names and validations.

• Use Formulas to get info on dashboard.

• Create Dynamic charts.

• Give flexible options to users.

• Debug for Errors