ONE DAY WORKSHOP ON EXCEL ESSENTIALS

#

    Topic

        Additional Information

1

Getting started with Excel (What is NAME BOX in Excel?)

• Excel Ribbon, Tabs & sections
• Quick Access Tool bar & customizing it
• Using Formula bar, Name box and status bar
• Short-cut menus and mini tool bar
• Creating new files, saving existing file

2

Entering Data (Learn a trick with Autofill)

• Data entry, editing and manipulating data
• Autofill
• Adding comments to cells
• Working with dates and times
• Finding and replacing data

3

Creating formulas and functions and becoming LIGHTENING FASTER with ADVANCED FORMULAS

• Creating simple formulas (Totals, averages etc.,)
• Copying/Moving formulae to other cells
• Calculating year-to-date profit
• Creating a percentage increase formula
• Other basic functions

4

Formatting and conditional formatting

(Create formula based conditional formatting and create visual indicators with CF)

• Fonts, styles
• Row height, column width, wrap text, merge cells, alignment options
• Number formats; date formats; custom formats
• Borders
• Creating visual indicators with conditional formatting options
• Converting range into tables and vice-versa

5

Handling worksheet layout (Be sure to protect your data)

• Inserting and deleting cells
• Inserting and deleting rows/columns
• Inserting and deleting worksheets
• Protecting worksheets with password

6

Creating basic charts AS IF IT IS MAGIC

• Creating basic charts
• Different types of charts and their uses
• Chart secrets

7

Question Hour

• Post training test/quiz
• Follow-up exercises
• Discussions