Microsoft IT Courses

Introduction to Microsoft Excel

(0 review)
Microsoft Excel 4

This course is for new users to Excel who need to understand the basics and to be able to use the software to produce simple spreadsheets and use basic formulae.

Course Aim
To enable delegates to be confident in using the basic features of Excel to create and amend simple spreadsheets and use simple formulae.

Laptop with Excel installed and working. No prior experience needed.
Topics Covered:

The Essentials
• Starting Excel
• Understanding the Excel Program Screen
• Understanding the Ribbon
• Using the Office Button and Quick Access Toolbar
• Using Keyboard Commands
• Using Contextual Menus and the Mini Toolbar
• Using Help
• Exiting Excel

Worksheet Basics
• Creating a New Workbook
• Opening a Workbook
• Navigating a Worksheet
• Entering Labels
• Entering Values
• Selecting a Cell Range

Overview of Formulas and Using AutoSum
• Entering simple Formulas
• Using AutoFill
• Understanding Absolute and Relative Cell References
• Using Undo and Redo

Saving a Workbook
• Previewing and Printing a Worksheet
• Closing a Workbook
• Editing a Worksheet

Editing Cell Contents
• Cutting, Copying, and Pasting Cells
• Moving and Copying Cells Using the Mouse
• Using the Office Clipboard
• Inserting Cells, Rows, and Columns
• Deleting Cells, Rows, and Columns
• Using Find and Replace
• Using Cell Comments
• Formatting a Worksheet
• Formatting Labels
• Formatting Values
• Adjusting Row Height and Column Width
• Modifying Cell Alignment
• Adding Cell Borders, Background Colour and Fill Pattern

Introduction to Charts
• Creating a simple Chart
• Resizing and Moving a Chart
• Changing Chart Type
• Applying Built-in Chart Layouts and Styles

Versions 2010 onward

Curriculum is empty


Lucy Gordon

0.00 average based on 0 ratings

5 Star
4 Star
3 Star
2 Star
1 Star

Related Courses