Practical Excel 2010 Tips & Tricks for the Workplace (ILT)

COURSE DESCRIPTION

This course covers Tips & Tricks on Microsoft Excel 2010. It assumes you have used Excel and are familiar with creating, editing & formatting worksheets.  In a quick and lively manner this will cover what is new in this version of Excel and also show you some tips to increase your productivity in Excel and widen your skills.  These tips also apply to Excel 2013 so videos 1,2,4,8 & 11 would be good background for Excel 2013 users.

The course begins with a review of some basics of cell selection, copy, paste and formatting.  Use of the format painter is shown in detail.  A review of formula entry and the difference between absolute and relative formulas is covered.  How to deal with errors and audit a worksheet is demonstrated.  Intro to tables is next with examples of sorting & multilevel filtering. A Pivot Table is built from scratch in a simple and easy to understand manner and then it is filtered using data slicers and charted with Sparkline charts.  The basics of creating & editing a chart, plotting trend lines, and other fancy chart formatting are demonstrated.  The powerful analysis of conditional formatting is introduced and custom settings reviewed.  Finally some basics on printing and spreadsheet layout are covered.

Category: Office Productivity/Microsoft

Duration: 1/2 Day

What are the requirements?

• Microsoft Office 2010

Pre-requisite: Basic skills in editing and formatting a worksheet

What am I going to get from this course?

• Basics of copying & pasting cells, paste preview and other special paste options
• Formatting basics, live preview, font dialog, format painter, mini toolbar
• See the amazing paste transpose feature to flip a spreadsheet
• A clear & simple explanation of absolute and relative references in formulas
• Detect worksheet errors individually and in the errors tool, and correct them
• See how to do audits and traces in a worksheet
• See how to create a table, format, sort & filter it with smart headings
• Build a chart from scratch, format it and plot trend lines
• How to build a PivotTable from scratch, customize and filter
• Using Slicers to filter Pivots for ease and clarity
• Using Sparkline charts to create an effective chart in a single cell
• How to use Conditional Formatting to clarify worksheet data
• See printing options, page layout and formatting headers & footers

What is the target audience?

Busy Excel users of any skill level who want a quick look at what is new and can save them time.  Those needing a review of some basics. You should have some basic skills in editing, formatting and working with Excel worksheets.

Lesson Plan

1. 1. Introduction

Introduction to Excel 2010 Tips & Tricks Course

1. 2. Copy & Paste

Copy, paste, Transpose,  Paste Preview and other paste special like paste values

1. 3. Formatting

Formatting basics, live preview, font dialog, format painter, minitoolbar

1. 4. Formulas: Absolute & Relative

Show examples of relative and absolute and how to manage these

1. 5. Errors & Auditing

Detect errors individually and in Errors tool.  Do audit traces & print audit reports.

1. 6. Tables

Creating a table, finding duplicates, sorting & filtering a table

1. 7. PivotTables

Creating a basic Pivot table, formatting & pivoting views

1. 8. Slicers

Adding data slicers to a pivot table

1. 9. Charts

Creating a hart & formatting options

1. 10. Sparklines

Adding a Sparkline chart to a worksheet, formatting

1. 11. Conditional Formatting

Intro & examples of Conditional formatting including editing conditions

1. 12. Page Layout & Printing

Printing options, page setup, formatting headers and footers