Microsoft Excel Introduction
Microsoft Excel Introduction Course Duration: One Day
Target Audience:
Aimed at users who are new to Microsoft Excel and want to set up their own spreadsheets and manipulate existing ones.
Course Objectives:
To develop a good working knowledge of Excel to include features such as basic functions and formulae, sorting and filtering data, formatting, and printing spreadsheets.
Course Outline:
Basic Knowledge
-
Understanding Workbooks, Worksheets, Rows, Columns, Cells
-
The Ribbon
-
Selection techniques
-
Understanding the different Mouse shapes
-
Quick Access Toolbar
-
Customizing the Quick Access Toolbar
-
Customising the formula Bar
-
Quick Access Toolbar
-
Live Preview
-
Contextual tabs
-
Zoom Feature
-
Views explained
-
Shortcut keys
-
Saving, File types, File Compatibility
-
Tell me what you want to do – feature
-
Smart Lookup
-
Pinning Recent Files
Entering, Selecting and Editing Data
-
Entering, Editing, and deleting information in cells (Text, Date, and numbers)
-
Entering Auto Lists
-
Using Fill handle to create simple lists
-
Creating custom lists
-
Deleting Rows, Columns and Cells
-
Inserting Rows, Columns and Cells
-
Inserting, Deleting, Moving, Copying and Renaming Sheets
-
Various Navigation Techniques using Scroll bar, Keyboards and Go To command
-
Using the Paste Preview
Creating Formulae and Functions
-
Creating Formulae
-
Editing Existing Formulae
-
Mathematical Order
-
Copying Formulae
-
Understanding Relative Referencing
-
Understanding Absolute Referencing
-
Using the Auto sum Feature
Frequently Used Functions
-
SUM, MIN, MAX, AVERAGE, COUNT, COUNTA
-
Using the Formulas Tab
Formatting your Spreadsheet
-
Formatting Cells
-
Number Formatting
-
Date Formatting
-
Text Formatting
-
Cell Alignment and Orientation
-
Wrap text
-
Applying cell styles
-
Border drawing
-
Clearing Formats
-
Changing Column Widths
-
Changing Row Heights
-
Changing sheet Tab Colours
-
Using Format Painter
Data Sort and Filter
-
Sorting Data
-
Auto Filter
-
Filtering using Timeline
Charts / Graphs
-
Creating Simple Charts
-
Editing Charts
-
Formatting Charts
-
Using Recommended Charts
Printing
-
Print Preview
-
Page Orientation
-
Adding Headers and Footers
-
Printing a Selection
-
Setting a Print Area
-
Scaling
-
Adjusting page breaks using Page Break Preview
-
Repeating columns and rows
-
Changing Margins
-
Centre on Page
Discussion and Question Time
Contact us today to enquire about all our courses, classroom and virtual training options. Follow us on Facebook and LinkedIn for latest updates.