Excel Intro

Excel - Intro

Our 1 day Microsoft Excel Introduction course is suitable for complete beginners to Microsoft Excel 2007, Microsoft Excel 2010 and Microsoft Excel 2013.

Our 1 day Microsoft Excel 2010 Introduction course is suitable for complete beginners to Microsoft Excel.

Prerequisites

A working knowledge of Windows is required, or our Introduction to MS Windows course. No experience of MS Excel is required.

Benefits

• At the end of this course you will have a good working knowledge of Excel basics
• You will feel more confident using Excel and be able to create a spreadsheet from scratch
• Understanding and using some of the built in calculation and formula functionality will allow you to be more productive in your work and home Excel environments
• Spreadsheets that you create will be easier to use and look more presentable
• After completing this course you will be prepared to attend our Advanced MS Excel training course

The Ribbon

• Tabs
• Groups
• Commands

The Backstage View (The File Menu)

• Introduction to the Backstage View
• New Workbooks and Excel Templates
• Getting Help
• Adding Your Name to Microsoft Excel

The Quick Access Toolbar

• Adding Common Commands
• Adding Additional Commands with the Customize Dialog Box
• Adding Ribbon Commands or Groups
• Placement

Entering Data in Microsoft Excel Worksheets

• Entering Text
• Using AutoComplete
• Entering Numbers and Dates
• Using the Fill Handle

Formatting Microsoft Excel Worksheets

• Selecting multiple cell ranges 
• The Font Group
• The Alignment Group
• The Number Group
• Custom Number & Date formats

Using Formulas in Microsoft Excel

• Math Operators and the Order of Operations (+ - / * &)
• Entering Formulas
• AutoSum (and Other Common Auto-Formulas)
• Copying Formulas and Functions
• Relative and Absolute Cell References

Working with Rows and Columns

• Inserting Rows and Columns
• Deleting Rows and Columns
• Setting Row Height and Column Width
• Hiding and Unhiding Rows and Columns
• Freezing Panes
• Split Screen
• Adjust multiple column widths simultaneously)

Editing Worksheets

• Find
• Find and Replace

Visualizing Your Data

• Inserting Charts
• Editing Charts

Finalizing Microsoft Excel Worksheets

• Setting Margins
• Setting Page Orientation
• Setting the Print Area
• Print Scaling (Fit Sheet on One Page)
• Headers and Footers
• Using Group Mode to update multiple sheets simultaneously