Who Should Attend?

This course is ideal for those who would like to be able to work comfortably with Microsoft® Excel. Users who are very new to Microsoft® Excel and those who are keen to further their basic working knowledge of Microsoft® Excel, would benefit from this course..

About the Programme

This two day programme, covers the basics of Microsoft® Excel on Day One, and looks at advanced topics on Day Two. Delegates who feel they already have a basic working knowledge of Microsoft® Excel, or are familiar with some Day One topics, should view Day One as a refresher.

Course Objectives

• Understand the basics of Microsoft® Excel 2007 / 2010, and how it is different from the previous versions
• Understand how to navigate efficiently to the relevant tools within the Microsoft®Excel Ribbon
• Prepare and format Microsoft® Excel sheets
• Review the various formulas available in Microsoft® Excel, and how they can be used
• Use data within a sheet to create charts and graphs
• Review the various chart and graph options available in Microsoft® Excel, and how they can be used
• Be able to rearrange and filter data
• Be able to insert media into Excel sheets, charts, etc.
• Use the protect function for your sheet and workbook, and know how the protect function can be applied to different elements of a Microsoft® Excel sheet

What You Will Gain

• Basic working knowledge of Microsoft® Excel
• Quick and easy ways of creating and formatting your Excel sheets
• An understanding of how to perform calculations using the various formulas available in Microsoft® Excel
• The ability to sort, and filter your data, as well as customise the 'Sort' and 'Filter' functions to suit your needs
• An awareness of the types of charts, graphs, pictures, etc., that can be inserted into your Excel sheets, and how they can be formatted
• A list of keyboard shortcuts for frequently used tools, and how to use them to increase speed
• Knowledge of how to insert links from websites, and other files, into your Excel sheets

Programme Contents

DAY ONE
• The Microsoft® Ribbon - What Is New In Microsoft® Excel
• Understanding Commands, Tabs, & Groups
  > Creating New Excel Sheets
  > Getting To Know The Excel Terminology, e.g. Active Cell, Name Box, Formula Bar, etc.,
• Entering Data Into Your Excel Sheet
• Navigating Quickly Within Your Excel Sheet
• Quick Ways Of Selecting Your Data
  > Selecting A Cell
  > Selecting A Range Of Connecting Cells
  > Selecting A Range Of Non-Connecting Cells
  > Selecting A Range Of Connected Rows & Columns
  > Selecting A Range Of Non-Connected Rows & Columns
  > Selecting The Entire Worksheet
• Inserting Or Deleting Rows & Columns
• Changing Row Height & Column Width
  > Using Drag Technique To Change Row Height & Column Width
  > Using The Auto Fit Technique To Change Row Height & Column Width
• Copying & Pasting Contents Of Cell(s), Row(s) Or Column(s) To Other Cell(s), Row(s) Or Column(s)
• Freezing Panes Of Your Sheet For Better Viewing
• Auto Fill Data Automatically Into Your Cells
• Working With Multiple Excel Sheets
  > Renaming Your Sheet
  > Inserting & Deleting Sheets
  > Changing The Order Of Your Sheets
  > Creating A Copy Of A Sheet
• Enhancing The Appearance Of Your Excel Sheet
  > Changing Font Type, Size, Colour, etc.,
  > Applying Borders To Your Cells, Tables, etc.,
  > Changing The Background Colour Of Your Cells, Tables, Sheet, etc.,
  > Aligning & Changing The Orientation Of Text Within A Cell
  > Using The Text Wrapping Function
  > Formatting Cells To Match Various Number Formats e.g. Currency, Decimal Point, Percentage, etc.,
• Using Formulas & Functions In Your Excel Sheets
  > Using Preset Excel Formulas
  > Creating Your Own Formulas
  > Copying Formulas From One Cell To Others
• Using Absolute Value Formulas
• Creating Charts Within Microsoft® Excel
  > Viewing Various Preset Chart Options Available Within Microsoft® Excel
  > Resizing A Chart
  > Formatting The Text, Colour, etc., Within A Chart
  > Copying & Moving Charts Within Worksheets
• Using The Different View Options Available & Their Benefits
• Setting The Print Area For Your Sheet
• Inserting Headers & Footers
• Repeating Rows & Columns On Printed Sheets For Easy Viewing

DAY TWO
• Using The Paste Special Options
• Importing & Exporting Text
• Naming Cell Ranges For Easy Viewing
• Working With Subtotals
  > Creating & Removing Subtotals
• Formatting & Display
  > Formatting Tables Using Preset Styles
  > Customising Preset Styles
  > Using Conditional Formatting Options For Easy Formatting As You Type
  > Hiding & Unhiding Rows, Columns & Worksheets
• Use The Sort & Query Functions
  > Customising The Sort Function
  > Applying Single / Multiple Filters To Data
  > Customising The Filter Queries
  > Removing Filters
• Consolidating Data
  > Combining Data From Various Cells Into A Single Cell
  > Linking Cells, Charts, etc., - In Same & Different Sheets
• Formatting The Following In Your Charts:
  > Pie Chart Angles
  > Formatting & Positioning The Chart Axis, Chart Title & Chart Legend
  > Changing The Chart Design After A Chart Has Been Created
  > Adding & Deleting A Data Series Within A Chart
• Inserting Pivot Tables & Charts Into Your Excel Sheets
• Protecting Your Workbook
  > Adding A Password Protection For Your Workbook
  > Finalising Your Workbook As 'Read Only'
  > Defining Data Entry Rules To Prevent Incorrect Information From Being Entered
  > Customised Protection For Your Workbook To Allow Selective Editing
• Macros
  > Recording Macros To Speed Up Frequently Performed Actions
  > Assigning Shortcut Keys To Recorded Macros
  Customising The Quick Access Toolbar

2 Days - Non-Residential

Delegate spaces available on the following course dates: