Basic Excel

EXCEL INTRODUCTION :

• A overview of the screen, navigation and basic spreadsheet concepts
• Understanding workbooks, worksheets, rows, columns, cells
• Various selection techniques

ENTERING DATA

• Entering, Editing and Deleting Text, Numbers, Dates
• Using Auto Lists
• Moving and Copying data
• Inserting, Deleting and Hiding Rows & Columns
• Inserting, Deleting, Moving and Copying Sheets
• Using navigation techniques

CUSTOMIZING EXCEL

• Customizing the Ribbon
• Customizing the Quick Access Toolbar
• Using and Customizing AutoCorrect
• Changing Excel’s Default Options
• Creating a Custom AutoFill List
• Creating a Custom Number Format
• Customizing Excel Review

MANAGING AND NAVIGATING LARGE WORKBOOKS

• Using Workbook Views
• Selecting and Switching Between Worksheets
• Splitting and Freezing a Window
• Creating Headers and Footers
• Hiding Rows, Columns, Worksheets, and Windows
• Working with Multiple Workbook Windows
• Creating a Template
• Managing Workbooks Review

CREATING AND EDITING FORMULAE

• Concept of Formulae
• Creating Formulae, Editing Formulae
• Bodmas : Mathematical Order
• Copying Formulae
• Using Functions - Sum, Average, Max,Min, Count, Counta
• Applying Absolute (Fixed) Referencing

REFERENCING TECHNIQUES

• Relative Reference
• Absolute Reference
• Mixed Reference
• Moving Range Reference

FORMATTING AND PROOFING

• Formatting Cells with Number formats, Font formats, Alignment, Borders, etc
• Basic conditional formatting
• Copying and Clearing Formats
• Working with Styles
• Spell Check, Find & Replace and AutoCorrect

Intermediate Excel

L FUNCTIONS

• SumIf, SumIfs
• CountIf, CountIfs
• AverageIf, AverageIfs
• SumProduct, Subtotal

LOOKUP FUNCTIONS