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

Excel 2011 Introduction Online Training Course

[ TTEX2011ES ]

£48.00

Seen this product cheaper elsewhere?
We'll beat any like-for-like training quote!
CLICK HERE


Course Description

Microsoft® Office Excel® 2011 is a powerful tool you can use to create and format spreadsheets, and analyze and share information to make more informed decisions. Learn the basics of using Excel in this thorough introductory-level tutorial training series, Excel 2011- Intro.

Created by Beth Bruestle and Flip Crummer, the Excel 2011 – Intro online training series covers topics such as working with cells, formatting columns and rows, adding styles and themes, and printing your worksheets. By the time you’ve completed this course, you’ll have a strong foundation in Excel 2011.

This training course is for Microsoft Office Excel 2011 for Mac.

A. Basics
  • Introducing the Ribbon
  • Using the tabs on the Ribbon
  • Using the Contextual tabs
  • Minimizing the Ribbon
  • Changing Ribbon preferences pt. 1
  • Changing Ribbon preferences pt. 2
  • Customizing/resetting the Ribbon tab order pt. 1
  • Customizing/resetting the Ribbon tab order pt. 2
  • Understanding a worksheet and entering information into a cell
  • Changing the default number of worksheets and the cell movement
  • Using Save and Save As
  • Understanding the XML file format pt. 1
  • Understanding the XML file format pt. 2
  • Opening Excel 2011 files in earlier versions of Excel
  • Moving with the keyboard pt. 1
  • Moving with the keyboard pt. 2
  • Using the Template gallery pt. 1
  • Using the Template gallery pt. 2
  • Creating a PDF

B. Working with Cells
  • Using AutoComplete
  • Editing a cell
  • Using spell check
  • Selecting cell ranges pt. 1
  • Selecting cell ranges pt. 2
  • Entering values in a cell range
  • Using AutoFill
  • Using Cut, Copy and Paste
  • Using Paste options
  • Using Paste Special
  • Using the scrapbook
  • Using Drag and Drop editing
  • Using Undo and Redo
  • Using the Clear command

C. Formulas and Functions
  • Using AutoCalculate
  • Using AutoSum
  • Creating formulas
  • Using functions in formulas
  • Using the Formula Builder
  • Editing formulas
  • Checking formulas for errors
  • Using relative cell referencing
  • Understanding absolute cell references
  • Creating an absolute cell reference

D. Formatting Cells
  • Formatting numbers using the Ribbon
  • Formatting text using the Ribbon
  • Using the Alignment and Indentation commands
  • Rotating information in a cell
  • Wrapping text in a cell
  • Using the Merge and Center command
  • Using the Borders command
  • Formatting cells using the Format Cells dialog box
  • Using the Format Painter command

E. Working with Columns and Rows
  • Selecting columns and rows pt. 1
  • Selecting columns and rows pt. 2
  • Changing column width
  • Changing row height
  • Hiding and unhiding columns and rows
  • Inserting columns
  • Inserting rows
  • Deleting columns and rows
  • Inserting and deleting cells

F. Styles, Themes, and Tables
  • Using cell styles
  • Creating a custom cell style by example
  • Creating a custom cell style
  • Deleting a custom cell style
  • Modifying a custom cell style
  • Importing custom cell styles
  • Using themes
  • Customizing themes
  • Formatting as a table pt. 1
  • Formatting as a table pt. 2
  • Creating a custom table style pt. 1
  • Creating a custom table style pt. 2
  • Deleting a custom table style

G. Workbook Views and Page Setup
  • Using Normal view
  • Using Page Layout view
  • Using the Layout tab
  • Changing the margins
  • Changing the page orientation and paper size
  • Setting manual page breaks
  • Setting repeat titles
  • Creating headers and footers pt. 1
  • Creating headers and footers pt. 2
  • Using the Page Setup dialog box

H. Printing
  • Using Print and Print Preview
  • Using Share
  • Setting print areas
  • Adding to and clearing print areas

PACKAGE INCLUDES:
  • Length of Subscription: 12 Months Online On-Demand Access
  • Running Time: 5 hrs 4 min
  • Platform:  MAC
  • Level: Intro
  • 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.

If you'd like a Free Demo of this product then please complete the form here :

Need to train your Team? Contact Us for Discounts on Multiple Subscription Purchases.


More from this collection