Basic & Adv. Excel

Contact Us

Syllabus :-

  • Formulae and Functions
  • Excel Basics
  • Working with Files
  • Styles
  • Number and Date Formats
  • Conditional Formatting
  • Absolute and Relative References
  • Range Names
  • Cell Comments
  • Printing
  • Formatting worksheets
  • Multiple Worksheets
  • Consolidating Data
  • Data Validation
  • Protection
  • Protection
  • Tables
  • Formatting Tables
  • Subtotals
  • Pivot Tables
  • IF Functions
  • The VLOOKUP Function
  • Other Lookup Functions
  • Date and Time Functions
  • Text Functions
  • Information Functions
  • Conditional Statistics
  • The SUMPRODUCT Function
  • Grouping (Outlining)
  • Recording Macros
  • Charts
  • Scenarios
  • Data Tables
  • Goal-Seeking
  • Excel Short-Cut Keys

Syllabus :-

  • Functions,
    Sum,Count, Counta, Countblank, Average, Max, Large Min, Abs,
    Sumif, Countif, Sumifs, Countifs, Lower, Upper, Proper, Trim, Len,
    Left, Right, Mid, Concatenate, Subtotal,And, Or, Day, Year,
    Eomonth, Edate, Networkdays, Today, Weekday, Weeknumber,
    Workday, Find,Search, Vlookup, Hlookup, Match, Iferror, Ifna, If, Index, Offset
  • Filters (Basic, Advanced , Conditional), Sort ( Ascending, Descending, Cell/ Font Colour), Single and Multiple Charts/Graphs, Conditional Formatting, Data validation, Group & ungroup, Data split.
  • Pivot Table and Chart, Import and Export data, Protect/Unprotect sheets/workbooks. Worksheet formatting and Print Display.

Syllabus :-

  • Object-orientated programming
  • Working across applications
  • File System Objects
  • Using built-in file dialog boxes
  • Macro security
  • Protecting applications
  • ActiveX controls
  • Class modules
  • Good programming techniques
  • Customizing menus and toolbars
  • VBA Editor
  • Debugging
  • Handling errors
  • Recording macros
  • Running macros
  • Customizing menus and toolbars
  • Writing macros
  • Selecting cells and ranges
  • Variables
  • Subroutines, arguments and functions
  • Loops and logic
  • Debugging
  • Handling errors
  • Event-handling
  • Looping over collections
  • Creating forms
  • Using forms
  • Advanced form controls
  • Programming menus and toolbars
  • Working across applications
  • Working with ADO & DAO