EOT Logo Efficient Office Training.
Home Courses Prices Contact Us About Us

Basic Excel Course Content List

What is Excel used for?
Introduction to the screen
Introduction to the keyboard
Introduction to the mouse
Creating a new workbook
Selecting cells, rows, columns, ranges etc.
Cursor movements
Types of data
Entering data
Editing data
Clearing data
Undo/redo
Saving workbooks
Backing up workbooks
Closing workbooks
Opening existing workbooks
Formatting from the toolbar
Clearing formatting
Basic formulae
BODMAS - Order of Calculations
AutoSum
Fill handle - existing custom lists
Fill handle - dragging formulae
Absolute & Relative references
Adjusting column width
Adjusting row height
Merge and Center
Adding new columns/rows
Deleting columns/rows
Moving/copying data
Moving/copying formulae
Sorting using toolbar icons
Zoom
Freeze panes
Page setup
Printing
Print headers
Adding page breaks
Charts / Graphs
Office Assistant

Home Courses PricesContact UsAbout Us