What is Excel?

Microsoft Excel is a general-purpose electronic spreadsheet to use to organize, calculate, and analyze data. The task you can complete with Excel ranges from preparing a simple family budget, preparing a purchase order, create an elaborate graph/chart, or managing a complex accounting ledger for a medium size business.

Provide Basic/Advanced Understanding of Excel, make user familiar to create a formula and give the platform to make a good analysis and introduce Powerful tools of advance excel so that user can make advance analysis with the help of those tools.

Introduction to Excel, Basic Understanding Menu and Toolbar, Introduction to a different category of functions like Basics, Mathematical, and Statistical, Date and Time, Logical, Lookup, References, Text and Information.

Advanced Excel Training Units:

Unit One

  • Introduction and Basic Overview
  • Working with Workbook and Worksheets
  • Formatting Cells
  • Customized formatting of Cells
  • Cell References (Absolute, Relative & Mixed)
  • Shortcut Keys
  • Other Features (Paste Special and finding and replacing data etc.)

Unit Two

  • 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

Unit Three

  • Logical Complex Formulas (IF, OR, AND &  IFERROR)
  • Use of Nested IF formula with examples
  • Other Text Formulas (TEXT, CLEAN, TRIM, Len,  T, COUNT, COUNTA, COUNTBLANK, COUNTIF, SUBTOTAL)
  • Defining Cell Range & Name Manager

Unit Four

  • Applying Autofilter
  • 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 Data as Table

 Unit Five

  • 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, INDEX, CHOOSE, INDIRECT etc.)
  • Data Validation and its use in different scenarios

 Unit Six

  • Understanding the Page layout of the workbook (Orientation, Print preview, Page Break etc.)
  • Consolidate the data range from multiple sources.
  • What if Analysis (Goal Seek, Scenario Manager, and Data Table)
  • Protecting worksheet and workbook
  • Customized Protection of worksheet
  • Sharing Workbook
  • Track and Highlight Changes
  • Encrypting Document

 Unit Seven

  • Understanding & Preparing Dashboards.
  • Group and Ungroup Data
  • Formula Auditing (Trace Precedents/Dependents, Error Checking, Show/Evaluate Formula, Watch Window)
  • Applying Subtotal to a Data Source
  • Export and Import Data from (Different Sources like Access, Web, Text, CSV etc.)

Unit Eight

  • Understanding Macros
  • Recording new Macros
  • Understanding the use of Form Controls
  • Inserting User form / Module using VBA
  • Creating own formulas using VBA
  • Protecting and working on VBA projects

 

For corporate or individual training, kindly mail us:

info@continualbusinesssolutions.com  OR  training@continualbusinesssolutions.com

Call us:  +91 9654350490