top of page

Beginners edition

1 

Excel - Elements

  1. Overview Of Current Versions In Market

  2. Office As Product Vs Subscription - Which Is Better?

  3. Ways Of Opening Excel

  4. Working With Templates

  5. Ripping The Ribbon

  6. Quick Access Toolbar

  7. Excel Screen - Where Is What ?

  8. Common Terms Used

  9. Ways Of Accessing Help

  10. Saving Options

  11. Quitting Excel

2

Navigation Options and Customizing Excel

  1. Ways Of Moving Across Workbooks / Worksheets

  2. Ways Of Selecting Data - Copy, Cut, Paste

  3. Use Office Clipboard Effectively - 14 Ways Of Copy / Paste

  4. View Multiple Workbooks / Worksheets In Single Screen

  5. Essential Keystrokes For Navigating

  6. Configuring Quick Access Toolbar

  7. Configuring Developer Tab For Recording Macros

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

3

Data Entry In Excel

  1. Understanding Different Data Types - Text,Number,Date & Others

  2. Understanding Special Treatment Of Dates

  3. Entering / Editing / Modifying / Deleting Data

  4. Cells And Ranges

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

  6. Entering Formulas

  7. Cell Contents - Default Alignments

  8. Modify Methods Of Inputs For Desired Outcomes

  9. Fill - Series / Auto / Flash

  10. Configure Customized List For Auto Fill

  11. Insert / Delete - Cells & Ranges & Worksheets

4

Content to Cosmetics

  1. Converting Data Set  As Tables

  2. Advantages Of Table

  3. Formatting Design Worksheets / Cells / Ranges

  4. Formatting Contents - Worksheets / Cells / Ranges

  5. Exploring Ctrl + F1

  6. Use Themes And Styles

  7. Format Painter - Ways Of Using It

5

Diving into Feature List

  1. Conditional Formatting - Normal And Graphical

  2. Cell Alignments

  3. Understanding And Performing Fsr - Find,Select,Replace

  4. Eliminating Duplicates

  5. Zoom Options

  6. Text To Speech

  7. Freezing Panes

  8. Hiding And Unhiding - Worksheet, Range, Columns, Rows

  9. Move / Copy Worksheet

  10. Quick Analysis Tool

  11. Transpose Cells

  12. Data Validation

  13. Text To Columns

  14. Working With Hyperlinks

  15. Custom Formatting

  16. Filters And Its Variations

  17. Sorting Options

  18. Working With Shapes

6

Experience with 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

  9. Trim,Convert Case,Search & Extract Characters

  10. Logical Functions

  11. Mathemetical / Arithmetic Functions

  12. Rounding And Conversion Functions

  13. Count Unique, Count With Multiple Conditions / Criterias

  14. Sum Functions And Its Variations

  15. Sub Total And Its Variations

  16. Lookup / Reference Functions

  17. All Variants Of Lookup - Vlookup, Hlookup, Xlookup

  18. Working With Dates And Dates Functions

7

Pivot Table

  1. Draw A Pivot Table

  2. Understand The Layers In Pivot

  3. Use Recommended Pivots

8

Wrap Up Session

  1. Best Practices

  2. Importatnt Tips And Tricks

  3. Extremely Useful Keystrokes

  4. Review Of Topics Discussed

  5. Planning For Free Future Follow Up Session

  • For Absolute Beginners to Learn from Scratch.

  • Anyone Who Wish to Become Brilliant in Basics.

  • Anyone Who Has Limited Usage of Excel Day to Day.

  • Anyone Who Wants to Explore Excel.

bottom of page