Excel Beginner 2010 Course

GETTING STARTED

The Microsoft Excel Screen

The Microsoft Excel Ribbon

• Contextual Tabs In The Ribbon
• Live Previews
• Working With The Quick Access Toolbar
• Adding Icons To The Quick Access Toolbar
• Removing Icons From Quick Access Toolbar
• Change The Location Of The Quick Access Toolbar
• Group Dialogue Box Launchers
• Right Click Using The Mouse
• Keyboard Shortcuts
• Changing The Workbook View
• Show / Hide Excel Elements

The Excel Backstage View

• Introduction To The Backstage View
• Opening An Excel Spreadsheet
• Closing An Excel Spreadsheet
• Create a New Workbook In Excel

Selection Techniques In Excel

• Single Cell Selection
• Selecting A Range of Cells Using the Mouse
• Select A Group Of Cells Using
• Select A Whole Column
• Select A Whole Row
• Select The Whole Worksheet
• Selecting Non-Adjacent Ranges In A Worksheet

Navigating In Excel

• The ActiveCell
• Moving The ActiveCell Using The Keyboard
• Moving The ActiveCell Using The Name Box
• Moving The ActiveCell Within A Selected Range
• Inserting A New Worksheet
• Selecting Different Sheets Within A Workbook

Data Entry

• Entering Text
• Edit Text In the ActiveCell
• Edit Text In The ActiveCell Using The Formula Bar
• Replacing The Contents Of A Cell
• Deleting The Contents Of A Cell
• Undo And Redo Actions
• Entering A Date
• Entering A Heading
• Enter A Number As A Value
• Enter A Number As A Label

AutoFilling In Excel

• Automatically Fill In A Series Of Months
• Automatically Fill In A Series Of Days
• Enter A Series Of Dates
• Enter A Series Of Numbers

AutoFill Customisation

• Create A Custom List
• Delete A Custom List
• Use AutoFill To Enter Data
• Enter Data Into A Range Of Cells In A Worksheet
• Filling Common Data Into A Range Of Cells

Workbook Management

• Saving For The First Time
• Creating A Copy Using Save As
• Save Using A Different File Format
• Saving Workbooks To Another Folder
• Saving To A USB
• Close The Workbook
• Open An Excel Workbook

CALCULATIONS IN EXCEL

Using Simple Formulas

• Resize The Formula Bar In Excel
• Using The Keyboard To Enter A Formula
• Entering Manual Operators
• AutoFilling Using Relative Cell References
• AutoFilling Using Absolute References
• Applying an Absolute Reference To Cell References

Simple Functions In Excel

• Entering A Simple Function
• Using The AutoSum Button To Calculate Totals
• AutoSum and Manual Selections
• Entering Other Simple Functions
• Using AutoComplete To Enter Formulas
• Turning AutoComplete On Or Off
• Insert Other Simple Functions Using AutoSum Button
• Inserting Functions Using A Wizard

AutoCalculate

• Using AutoCalculate To Do A Calculation

MANAGE WORKSHEETS INFORMATION

Managing Worksheet Information

• Move Content Using Cut And Paste
• Drag And Drop Content Using The Mouse
• Copying And Pasting Content
• Setting Paste Options
• Drag And Drop To Copy Content
• Insert Rows
• Insert Multiple Rows
• Delete Rows
• Insert Columns
• Insert Multiple Columns
• Delete Columns
• Insert And Deleting Cells
• Rename A Worksheet
• Add A New Worksheet To The Workbook
• Moving a Worksheet Within The Workbook
• Delete a Worksheet Within The Workbook

FORMATTING WORKSHEET INFORMATION

Adjusting Column Widths And Row Heights

• Adjust The Column Widths
• Adjust The Row Height
• Hiding And Unhiding Rows or Columns
• Freeze Columns And Rows
• Unfreeze Columns And Rows
• Split The Worksheet
• Removing A Split

Formatting Cells With The Ribbon

• Changing The Font
• Changing The Current Font Size
• Make Content Bold
• Italicize Content
• Underline Content
• Changing Font Colour
• Align Data Within A Cell
• Indent Data Within A Cell
• Merge Multiple Cells
• Wrap Text Into Multiple Rows Within A Cell
• Change The Number Format To Percentage
• Setting The Number Of Decimal Places
• Copy Formats With Format Painter
• Correcting Display Problems

The Format Cells Dialogue Box

• Apply A Double Underline
• Setting The Text Orientation
• Text Wrapping In A Cell
• Show Numbers As Currency
• Set The Date Format
• Changing The Background Colour Of A Cell
• Apply An Outline Border To Content
• Apply A Double Line Border To Content
• Drawing Borders

SETTING UP THE PAGE AND PRINTING

Setting Up The Page

• Insert A Page Break
• Remove A Page Break
• Setting The Print Area
• Clearing The Print Area
• Setting Page Margins By Clicking And Dragging
• Set The Page Orientation
• Set The Print Size By Scaling
• Setting Paper Size
• Change The Page Margin Using Page Setup
• Centring Content On The Page
• Add A Header And Footer For Printing

Print Preview

• Entering Print Preview
• Setting Print Preview Options
• Print The Active Sheets
• Print The Selected Cells
• Set Multiple Copies For Print