Course Details

We provide Advanced Excel training classes to our clients at affordable rate. Our highly qualified and reputed professional assist our students with individual care. The specifications for the program are :

• Introduction
• The Function Wizard
• Using the Function Wizard
• Shortcut for entering a function
• Data RELATIVE & ABSOLUTE ADDRESSING
• Naming Cells And Ranges
• Method 1 : Insert, Name, Define option (or CTRL+F3)
• Method 2 : Using the Name box
• Applying a Range Name In a Formula
• Using Names For Constants or Formulas  
• Referencing Other worksheet And Workbooks
• Fill Handle And Fill series Command
• Using the fill Handle & Fill Series
• Deleting Custom List
• Conditional Formatting
• Creating Conditional Format
• Creating a Conditional Format
• Find cells that Have Conditional Formats
• Sorting And Filtering
• Simple Sorts
• Sorting on more than one criteria (Data, Sort)
• Filtering Data
• Turning Auto filter off
• Macros
• Introduction
• Recording a Macro
• Running a Macro
• Absolute Vs Relative
• Assigning buttons to macro
• Assigning the macro to an icon on a Toolbar
• Viewing the Macro
• Deleting a Macro
• Advanced Excel
• Importing/ Exporting
• Working With the quick Access Toolbar
• Working With the Quick Access Toolbar
• Viewing / hiding tools
• Custom Styles
• Custom Views
• File Properties customizing Excel, etc