MARS Excel 2010 Essentials - Basics

Getting To Know Microsoft Excel

  • starting Microsoft Excel
  • the Excel 2010 screen
  • how Microsoft Excel 2010 works
  • using The Ribbon
  • using Ribbon Key tips
  • minimising The Ribbon
  • understanding The Backstage View
  • accessing the backstage view
  • using short cut menus
  • understanding dialog boxes
  • launching dialog boxes
  • understanding the Quick Access Toolbar
  • adding commands to the QAT
  • understanding the status bar

Formulas And Functions

  • understanding formulas
  • creating formulas that add
  • creating formulas that subtract
  • formulas that multiply and divide
  • understanding functions
  • using the SUM function to add
  • summing non-contiguous ranges
  • calculating an average
  • finding a maximum value
  • finding a minimum value
  • more complex formulas
  • what if formulas 

Copying Data

  • understanding copying in Excel
  • using fill for quick copying
  • copying from one cell to another
  • copying from one cell to a range
  • copying from one range to another
  • copying relative formulas
  • copying to a non-contiguous range
  • copying to another worksheet
  • copying to another workbook.

Moving Data

  • understanding moving in Excel
  • moving cells and ranges
  • moving data to other worksheets
  • moving data to other workbooks 


  • understanding printing
  • previewing before you print
  • selecting a printer
  • printing a range
  • printing an entire workbook
  • specifying the number of copies
  • the print options.

On-Site Training

If you need training for three or more people, ask us about training at your site. You can enjoy the convenience of reduced travel cost and time, as well as a familiar environment for your staff. Additionally, we can customise the course for your business needs.

User Reviews

Not yet rated. You will need to follow this course before you can write a review.

Course Info

Next Step

Enquire Now
Tell a Friend
Email Course Outline