Advance Excel Classes Hyderabad (16 Days)

Learn advance 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. Send an email with subject " Advance Excel Classes in Hyderabad" or "Online Classes for Advance Excel" to info@upskilltechnologies today.

Intoduction to New Excel
  • Intro to 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

EXCEL ONLINE TEST

Keywords: Advance Excel Online training Hyderabad, Advance Excel Online Training Bangalore, Advance Excel Online Training Pune, Advance excel online training Chennai, Excel Dashboards Bangalore, Excel Dashboards Chennai, Excel Dashboards Pune, Excel Dashboards Mumbai, Excel Dashboards Delhi.