An Introduction to MS Excel - Course Outline

Running the program Excel

• Create a New Folder
• Workbook vs worksheet
• Saving a File to Another Name
• Saving as a different file type
• Exiting the program

Working with worksheets

• Calling a New Sheet
• Open a Sheet
• Closing a Sheet
• Switching between Sheets
• Saving a Sheet

Tricks, shortcuts and techniques

• Maximising Windows
• Toolbars (Main Menu, Standard, Formatting, etc)
• Moving a toolbar
• Moving around using Shortcuts (Top, Bottom, Start of Row, End of Row)
• Zoom
• Go To function, Name Box, Cell Reference
• Selecting Cells
• Selecting an entire sheet/row/column
• Undo and Redo and Repeat

Formatting Cells, Text and Appearance

• Size
• Currency
• Bold and Underline
• Lines and Borders
• Italics
• Percentage
• Increase and Decrease Decimal Position
• Left, Center and Right align
• Merge and Center data across Multiple Cells
• Adjusting Column Width / Row Height

Data entry and calculations

• Activating a function (menu method, icon, shortcut)
• Entering Text and Numbers into Cells
• Editing and Deleting data
• Sum formula, AutoSum
• Multiplication, Division, Subtraction and Addition formulas
• Autofill

Printing

• Print Preview
• Page Setup
• Page breaks
• Zoom, Margins

Courses available