Video description
In this Microsoft Excel 2010 tutorial video, veteran Infinite Skills trainer Guy Vaccaro introduces you to the latest version of Microsoft's standard spreadsheet application.
In this Excel Training Video, you will learn by watching the author actually perform the operations he is instructing on, as he explains step by step to how to perform these functions. Guy explains Microsoft Excel 2010 starting with the absolute basics of creating your very first worksheet. He slowly works you up through learning the various capabilities of this very powerful program, and even covers topics such as basic to advanced formula and functions. He has even included a chapter on connecting to the new Microsoft Web Apps, and how to use your own SkyDrive to store and share your Microsoft Excel projects. Included with this training video are full practical working files, to allow you to work along side of Guy as he teaches you how to use Microsoft Excel 2010.
By the completion of this computer based training course, you will be fully versed, and capable of working with Microsoft Excel 2010 in a commercial environment.
Table of contents
- Getting Started
- Working With An Excel Worksheet
-
Selecting And Entering Data
- Entering Text And Numbers
- Entering Numbers As Text
- Inputting Dates And Times
- Editing The Contents Of A Cell
- Using Copy And Paste
- The FILL Handle
- Using Undo And Redo
- Shortcuts For Selecting Cells
- Inserting Cells, Columns And Rows
- Deleting Cells, Columns And Rows
- Changing Column Widths And Row Heights
- Hiding And Unhiding A Column Or Row
- Searching For Values In A Worksheet
- Developing A Workbook
-
Printing And Page Setup
- Using The Print Area Command To Control What Excel Prints
- Setting Page Margins And Page Orientation
- Creating A Header And Footer
- Using Page Break View
- Setting Print Titles For Large Worksheets
- Printing Gridlines Column Row Headings And Other Related Options
- Enabling The New Page Layout View
- Running The Spell Checker
- Print Preview And Printing The Whole Or Part Of The Worksheet
- Workbook Formatting
-
Carrying Out Calculations
- Getting Started With Basic Math Formula Addition
- Getting Started With Basic Math Formula Subtraction
- Getting Started With Basic Math Formula Multiplication
- Getting Started With Basic Math Formula Division
- Getting Started With Basic Math Formula Operand
- Order Of Operations with BODMAS
- Introduction To Excel Formulas: SUM
- Copying Formulas And Functions
- Displaying Formulae On A Worksheet
- Some Useful Functions For Counting
- Some Useful Functions For Averages
- Some Useful Functions For Highest And Lowest
- Absolute Referencing Requirements
- Formulas Across Worksheets
- Functions Across Worksheets
- 3D Referencing
- Making Use Of Named Cells And Ranges
- Advanced Formatting
- Security
- Using Templates
-
Graphics Objects
- Inserting And Modifying Clipart
- Using SmartArt Graphics
- Adding Drawn Shapes To A Worksheet
- Inserting An External Picture
- Adding A Background Image To A Worksheet
- Formatting Graphic Objects
- Controlling Stacking Order And Alignment Of Multiple Graphics Objects
- Grouping Graphic Objects
- Accessing Formula Results In A Callout Bubble
-
Using Excel As A Database
- Fixing Rows And Columns On Screen
- Fixing Rows And Columns For Print
- Sorting Data In A Worksheet
- Filtering Data In A Worksheet
- Removing Duplicates In An Excel Database
- Adding And Using Subtotals In An Excel Database
- Splitting One Column Of Data Into More Columns
- Splitting The Screen To View Different Parts Of The Same Worksheet
- Linking To Data On A Webpage
- Using Charts In Excel
- More Advanced Formula
-
Conditional Formatting
- Changing Cell Appearance Based On Its Value
- Editing Conditional Formatting Rules On A Worksheet
- Removing Conditional Formatting Rules
- Highlighting Duplicate Values Using Conditional Formatting
- Identifying The Top Or Bottom Percentage Of A Range
- Use Of Data Bars Within Conditional Formatting
- Use Of Colour Scales Within Conditional Formatting
- Applying An Icon Set To Conditional Formatting Rules
-
Office Web Apps And Excel
- What Is Office Web Apps?
- Sign In To Or Sign Up For Your Own SkyDrive
- Saving An Excel Workbook Into SkyDrive
- Accessing And Editing An Excel Workbook Through SkyDrive
- Telling Others Where Your Public Documents Are
- Direct Linking Or Embedding Of SkyDrive Documents
- Creating A Folder Structure Within SkyDrive
- Deleting Files From SkyDrive
- Credits And Beyond
Product information
- Title: Microsoft Excel 2010
- Author(s):
- Release date: June 2010
- Publisher(s): Infinite Skills
- ISBN: 9781926873077
You might also like
video
Advanced Microsoft Excel 2010
In this Advanced Excel 2010 training video, expert author Guy Vaccaro follows up his bestselling Beginners …
video
Using Microsoft Excel 2010
Using Microsoft Excel 2010brings you over 45 media elements detailing everything from getting familiar with the …
video
Microsoft Excel 2013 Data Analysis Essentials
Master data analysis with Excel 2013 on your terms with this one-of-a-kind video training course. Excel …
video
Microsoft Excel - Tables Deep Dive
In this Microsoft Excel – Tables Deep Dive training course, expert author Erin Olsen takes you …