Basic-Intermediate

1. Excel - Elements

​

• Overview Of Current Versions In Market

• Office As Product Vs Subscription - Which Is Better?

• Working With Templates

• Ripping The Ribbon

• 14 Ways Of Using Clipboard

• Variations In Viewing Multiple Workbooks / Worksheets

• Configuring Developer Tab For Recording Macros

• Learn To Configure Hidden Commands Not In Ribbon - Select From Menu Of 2500+ Commands !!

 

 

2. Features - Part I (Refreshing Basic)

​

• Cell Alignments, Merge Options

• Zoom Variations

• Essentials Of Rows / Columns

• Cells Styles

• Quick Access Toolbar

• Exploring Ctrl + F1

• Use Themes And Styles

• Format Painter - Ways Of Using It

• Fill - Seris / Auto / Flash

• Configuring Custom List

• Freezing Panes

• Hiding And Unhiding - Worksheet, Range, Columns, Rows

 

3. Features - Part II

​

• Conditional Formatting - Normal And Graphical

• Conditional Formatting - Advanced / Custom

• Find / Select & Replace - Advanced Version

• Text To Speech

• Quick Analysis Tool

• Transpose Cells

• Data Validation In Depth - Validate Entries, Post Error, Alerts

• Text To Columns

• Working With Hyperlinks

• Filters And Its Variations

• Basics And Advanced Sort Includig Custom Sort

• Working With Shapes

• Using Sparklines

• Comments / Notes

• Workbook / Worksheet Protection

 

 

4. Custom Formatting - Advanced

​

• Understanding 4 Types Of Formatting

• Rules Of Custom Formatting

• 25+ Combinations Of Custom Formatting

 

 

5. Before Working with Formulas

​

• Using Function Argument Dialog Box

• Understanding Special Treatment Of Dates

• Cell Reference - Absolute Vs Relative

• Formula Menu

• Detect Formula Errors And Resolving It

​

 

6. Accelerate Learning Formulas

​

1. Covers 25+ Important Formulas Used 80% Of Time

2. Compare Cells

3. Auto Sum / Quick Sum Rows And Col

4. Quick Summary On Status Bar

5. Cell Reference - Absolute Vs Relative ( Part Ii - Must To Know )

6. Defining Names And Working With Named Ranges

7. Using Function Arugment Dialog Box

 

    8. Text Functions:

​

        Trim,Convert Case,Search & Extract Characters

​

    9. Logical Functions

​

    10. Mathemetical / Arithmetic Functions :

 

• Rounding And Conversion Functions

• Count Unique, Count With Multiple Conditions / Criterias

• Sum Functions And Its Variations

• Sub Total And Its Variations

 

     11. Lookup / Reference Functions

 

• All Variants Of Lookup - Vlookup, Hlookup, Xlookup

• Index / Match Combinations

 

    12. Working With Dates And Dates Functions

    13. Understanding And Writing Nested Functions

    14. Common Errors And Handling Errors

 

 

7. Special Section - Working With Dates

​

Understand How Excel Treats Dates

​

Key Date Formulas / Functions

•    Calculate Business Days, Working Days, Days in a week

•    Extracting Dates from Text

​

8. Pivot Table - Level 1

​

• Pivot Concepts

• Data Cleansing Rules

• Use Recommended Pivots

• Pivot Table Anatonmy and Configuration

• Five Focus Areas

• List Of Major Do'S And Don'Ts On Pivot

 

9. Pivot Table - Level 2

​​

• Get Familiar With Pivot Table Style And Layout Options

• Understand Contextual Tab - Analyze

• Sorting And Filtering Tricks

• Grouping / Ungrouping - Custom And Recommended

• Auto Refresh, Auto Clear And Controlling Pivot Display

• Slicers And Timelines

• Customizing Slicers

• Pivot Chart

• Relationship Between Pivot Chart And Pivot Data

 

 

10. Graphs / Charts

​

Basics Of Graphs And Charts

Using Recommended Charts And Graphs

Explore Key Chart Types

•        Column, Bar, Line Charts

•        Developing Combo Charts

•        Pie Charts / Donought Charts

 

 

11. Wrap Up Session

​

• Best Practices

• Importatnt Tips And Tricks

• Extremely Useful Keystrokes

• Review Of Topics Discussed

• Planning For Free Future Follow Up Session