Course Syllabus:
Excel Overview
A overview of the navigation, screen and basic concepts of spreadsheets
Understanding workbooks, worksheets, columns, rows,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
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
Formatting and Proofing
Formatting Cells with Number formats, Font formats, Alignment, Borders and Patterns
Basic conditional formatting
Copying and Clearing Formats
Working with Styles
Spell Check, Find & Replace and AutoCorrect
Printing and Page Setup
Page Orientation
Adding Headers and Footers
Printing a selection
Setting a print area
Shrink to Fit
Adjusting page breaks within Page Break Preview
Repeating columns and rows
Printing Grid lines
Setting a print area
Basic List Management
Sorting
AutoFilters