Introduction to Microsoft Excel 2007

Who is it for
This course is for anyone who needs to understand the way Excel works. It's suitable for complete beginners, or those who have a little self taught knowledge but want to know how to use Excel more efficiently for day to day tasks.
Not sure if this course is the right level for you? Why don't you take our quick online test to find out >


What is it about
You will learn how to create spreadsheets from new, enter data, basic formulas and functions. Learn to manipulate data by inserting rows, columns and sheets as well as move, copy and delete data. As printing in Excel is somewhat different from the other components of Microsoft Office you will learn how to set up data for printing and produce charts.


What will i get out of it
Microsoft Office Excel 2007 has many changes from the previous versions. The new tabs and ribbon form the basis of a new user interface. Learn the difference between text data, numerical data, and formulas and functions. Learn to set-up your own spreadsheets without relying on anyone else. Develop your skills to present your work clearly by learning how to create purchase orders, bank statements and compile sales figures.


Course overview

• Explore the various new user interface elements
  
  
• How to master the ribbon
  
  
• Learn the new keyboard shortcuts
  
  
• Working with contextual tabs
  
  
• Use the Excel galleries
  
  
• Customise the interface
  
  
• Creating, opening and saving a workbook
  
  
• Inserting tables
  
  
• Formatting tables
  
  
• Creating forms with Excel 2007
  
  
• Utilising Excel help
  
  
• Understanding basic formulas
  
  
• Entering Excel 2007 functions
  
  
• Replicate Formulas & Functions
  
  
• Create an absolute reference
  
  
• Setting up data for printing
  
  
• Adding headers & footers
  
  
• Recording the current date and time on the printed spreadsheet
  
  
• Turning your figures in to charts
  
  
• Formatting charts