Microsoft Excel 2010: Existing User

Course Overview

This course is aimed at people who want expand their basic knowledge of Microsoft Excel to work with larger spreadsheets and workbooks, create charts and manage tables of data.

CourseMonster offers the best available Microsoft training in your area.

Related Courses

• Microsoft Excel 2010: Introduction for Beginners
• Microsoft Excel 2010: Intermediate Level 2
• Microsoft Excel 2010: Advanced
• Microsoft Excel 2007 or 2010: Advanced - Validate & Summarise
• Microsoft Excel 2007 or 2010: Advanced - Formulae & Functions
• Microsoft Excel 2007/2010: Intermediate
• Microsoft Excel 2010: Intermediate
• Microsoft Excel 2010: Visual Basic
• Microsoft Excel 2010: upgrade from Excel 2003 2007
• Microsoft Excel 2010: Expert 2010

Skills Gained

On completion of this course delegates will be able to:

• Manage and enhance large worksheets
• Create formulas across multiple worksheets
• Copy formats and values across multiple worksheets
• Create range names and use range names in formulas
• Copy and link information across multiple workbooks
• Represent data graphically using charts
• Understand the concepts of databasing and create and modify databases
• Sort lists and filter information

Prerequisites

Students who wish to attend this course must have a basic knowledge of Excel and feel comfortable with creating, saving, editing and formatting spreadsheets and creating simple formulas and functions.

Course Outline

Using Large Worksheets

• Increasing & Decreasing the Magnification
• Changing Range Magnification, Full Screen View, Splitting the Window, Freezing the Panes & Unfreezing the Panes

Working with Multiple Worksheets

• Navigating between, Selecting, Renaming Worksheets
• Selecting Multiple Worksheets
• Colouring Worksheet Tabs
• Copying & Moving Worksheets & Data Between Worksheets
• Using Grouped Worksheets
• Creating 3-D Formulas
• Using 3-D Ranges in Functions

Using Paste Special

• Working with Paste Special
• Copying Values & Formulas between Worksheets
• Performing Mathematical Operations

Using Range Names

• Jumping to a Named Range
• Assigning Names
• Using Range Names in Formulas
• Creating Range Names from Headings
• Applying & Deleting Range Names
• Using Range Names in 3-D Formulas
• Creating 3-D Range Names & Using 3-D Range Names In Formulas

Using Multiple Workbooks

• Opening, Tiling Open & Activating Workbooks
• Copying Data Between Workbooks
• Saving & Opening a Workspace
• Linking Workbooks

Creating Charts

• Creating, Moving, Resizing, Printing & Deleting Charts
• Formatting Chart Objects & Data Series
• Creating User-Defined Charts
• Changing the Data Source; Editing Text/Axis Titles
• Removing/Adding Axes Labels; Adding Data Labels & Tables
• Using a Secondary Axis & Adding a Trendline
• Data Chart in a cell

Working with Databases

• Creating & Modifying a Database
• Working with the Data Form
• Creating an Excel Table

Analysing Data

• Sorting Lists
• Sorting Records By Multiple Fields
• Using Autofilter
• Creating a Custom Autofilter

Appendix - AddingGraphics to a Worksheet

• Drawing and Formatting Objects
• SmartArt