Have a Question? Call 0800 689 3038 or Click here to email us.
Cart 0
Excel 2010 Essentials Online Training

Excel 2010 Essentials Online Training

[ TTAC10ES ]

£48.00

This series is for anyone who wants to know Excel in a non-intimidating, soup-to-nuts manner. If you've never used Excel, this is your starting point. No prior experience is necessary. If you've used Excel but never had formal training, this course will fill in the gaps so it all makes sense and so you are efficient and accurate. If you've used previous versions of Excel (prior to Office 2007) then there are a lot of features and changes you need to be aware of to fully utilize this software. In this course we take you from start to finish including entering data, configuring workbooks, working with calculations, applying regular and conditional formatting, creating custom formats, using names, leveraging the power of tables and charts and outputting your work. These are the skills every Excel user needs to know no matter how new or how experienced you may be!

Chapter 1: GETTING COMFORTABLE WITH EXCEL (51 min)

Introducing Excel
Recognizing Interface Features Unique to Excel
Understanding Workbook Structure
Navigating through Workbooks
Making Workbook Selections

Chapter 2: THE BASICS OF DATA (41 min)

Entering Text
Entering Dates & Numbers
Editing Cell Entries
Copying & Moving Data
Filling a Series

Chapter 3: MANAGING WORKBOOK STRUCTURE (28 min)

Modifying Workbook & Worksheet Structure
Resizing Worksheet Elements
Hiding Workbook Components

Chapter 4: CREATING FORMULAS (33 min)

Excel Calculations 101
Entering Formulas
Enforcing Absolute Referencing
Controlling Calculation Options

Chapter 5: THE BASICS OF FUNCTIONS (26 min)

The Foundation of Functions
Using AutoSum & the Formulas Tab
Using Function AutoComplete

Chapter 6: WHAT'S IN A NAME? (43 min)

Creating Named Cells
Defining Names
Creating Names from Selections
Creating Named Formulas
Using Names as References
Managing & Displaying Names

Chapter 7: MAKING DATA LOOK GOOD (74 min)

Applying Basic Formatting
Formatting Numbers
Exploring the Format Cells Dialog Box
Dening Custom Formats
Creating & Applying Cell Styles
Conditional Formatting
Applying & Editing Conditional Formatting Rules

Chapter 8 A PICTURE IS WORTH A THOUSAND WORDS (38 min)

Getting In-Cell Summaries with Sparklines
Creating Charts
Modifying Chart Design
Working with Chart Layout & Format
Saving & Using a Chart Template

Chapter 9 THE SIMPLICITY OF TABLES (54 min)

Converting Data Ranges to Tables
Modifying Table Formatting
Working with Table Records
Using Table Calculations
Sorting Data
Creating Custom Lists
Filtering Data

Chapter 10 MANAGING THE EXCEL ENVIRONMENT (20 min)

Configuring Excel Options
Adjusting the View
Controlling Excel Windows

Chapter 11 PREPARING FILES FOR DISTRIBUTION (23 min)

Print Area, Print Titles & Sheet Options
Renaming Sheets & Adding Headers/Footers
Printing Worksheets
Credits



  • Length of Subscription: 12 Months Online On-Demand Access
  • Running Time: 7.2 Hours
  • Platform: Windows & MAC OS
  • Level: Beginner to Intermediate
  • Project Files: Included

Learn anytime, anywhere, at home or on the go.

Stream your training via the internet, or download to your computer and supported mobile device, including iPad, iPhone, iPod Touch and most Android devices.


More from this collection