The course content for Advance Excel.

• Understanding on Cell Reference. -              with practical examples

• User Forms. (User forms come handy in our day to day data entry needs, therefore we make sure that you never miss out on the following)
  • Series (Own list creation) (Introduction to Series)
  • Paste Special. (Cell attributes pasting tricks)
  • Data Validation. (With data validation we ensure that correct data is being entered always)
  • Filter / Advanced Filter.
  • Data Sort. (organizing data in ascending or descending order).
  • Text to Column.
  • Go to. (Selection tips and Tricks using GoTo UF).
  • Custom Number Format. (Learn magic with cell values).
  • Conditional Formatting. (Format cell value based on conditions).
• Functions-
  • Function anatomy
  • Text Functions
  • Date & Time Functions
  • Logical Functions
  • Lookup & Reference Functions
  • Math & Trig Functions
  • Statistical Functions
  • Database Functions
  • Information Functions
  • Array Function

 

• Data connections-
  • Fetching live data from internet
  • Importing data from other databases like Access, Sql etc.
  • Connection with other database applications.

 

• • Workbook Protection.
  • Worksheet Protection.
  • Cell Protection with other properties of itâ??s.

 

• Reports & Analysis
  • Understanding report preparations.
  • Summarizing data using Pivot Table.
  • Data visualization using Charts.
  • Prepare consolidated reports using Consolidation.
  • What if analysis.
  • Dashboards Creation with interactive charts.

 

• Macros
  • Understanding on Macros
  • Creation of macros.