Microsoft Excel 2010 Bundle Training Video

Courses For Success
Online

AU$ 199 - (Rs 10,016)
+ VAT

Important information

  • Course
  • Online
  • When:
    Flexible
Description

Microsoft Excel 2010 Bundle Training Video A Practical Excel Training Course That Teaches Real World Skills In this project-based Microsoft Excel 2010 Bundle video tutorial series, you'll quickly have relevant skills for real-world applications. Follow along with our expert instructor in this Microsoft Excel 2010 Bundle Training Video course to get: Concise, informative and broadcast-quality Microsoft Excel 2010 Training Bundle training videos delivered to your desktop The ability to learn at your own pace with our intuitive, easy-to-use interface A quick grasp of even the most complex Microsoft Excel 2010 Training Bundle subjects because they're broken into simple, easy to follow tutorial videos Practical working files further enhance the learning process and provide a degree of retention that is unmatched by any other form of Microsoft Excel 2010 Training Bundle tutorial, online or offline... so you'll know the exact steps for your own projects. Course Fast Facts: Only 18 hours to complete this course 260 tutorial videos Expert instructors lead each course Download to any Windows PC or Mac and save for viewing off line Course is accessible 24/7 from any computer once downloaded You can study from home or at work at your own pace in your own time Course Description Learning Microsoft Excel 2010 Advanced Microsoft Excel 2010 Training
In this Microsoft Excel 2010 Bundle Training Video, you will learn first, how to use the basics of the industry standard spreadsheet program, Excel 2010, and then how to utilize the advanced features and functions in this software.  Expert author Guy Vaccaro guides you through these two popular video based tutorials.
In the beginners tutorial, you will start with the basics of Excel 2010, learning the interface, and quickly move into entering data, and building a workbook.  You then move on to formatting, and basic functions such as SUM,...

Important information

Requirements: System Requirements - DVD and Digital Download Digital Download: Microsoft Windows XP or higher, Mac OS X 10.4 or higher. Minimum screen resolution of 1024x768 Digital Download specific requirements: Between 1GB and 6GB of available hard drive space (depending on the training course) An Internet connection with sufficient bandwidth. You must have at least a 56K modem connection (Broadband recommended). Most modern ADSL and Cable internet solutions will be sufficient. Do...

Venues

Where and when

Starts Location
Flexible
Online

What you'll learn on the course

Excel
Options
Basic
Basic IT training
Microsoft Excel
Database
Database training
Basic IT
Graphics
Layout
Printing
Microsoft excel training
MS Excel
Skills and Training

Course programme

01. Learning Microsoft Excel 2010 - Getting Started
  • 0101 Overview Of Excel 2010
  • 0102 The New File Menu In Excel 2010
  • 0103 Exploring The Excel Workbook
  • 0104 What Will I Be Able To Do At The End Of This Course
  • 0105 Customizing The Quick Access Toolbar
  • 0106 Working With The Ribbons
  • 0107 Using The Files Included With This Course
  • 02. Learning Microsoft Excel 2010 - Working With An Excel Worksheet
    • 0201 Creating A New Workbook
    • 0202 Saving A Workbook
    • 0203 Saving In Other Formats
    • 0204 Open A Existing Workbook
    • 0205 Navigating An Excel Workbook
  • 03. Learning Microsoft Excel 2010 - Selecting And Entering Data
    • 0301 Entering Text And Numbers
    • 0302 Entering Numbers As Text
    • 0303 Inputting Dates And Times
    • 0304 Editing The Contents Of A Cell
    • 0305 Using Copy And Paste
    • 0306 The FILL Handle
    • 0307 Using Undo And Redo
    • 0308 Shortcuts For Selecting Cells
    • 0309 Inserting Cells, Columns And Rows
    • 0310 Deleting Cells, Columns And Rows
    • 0311 Changing Column Widths And Row Heights
    • 0312 Hiding And Unhiding A Column Or Row
    • 0313 Searching For Values In A Worksheet
  • 04. Learning Microsoft Excel 2010 - Developing A Workbook
    • Formatting And Naming Of Worksheet Tabs
    • Moving Worksheets Within And Between Workbooks
    • Copying Worksheets Within Workbooks
    • Inserting And Deleting Worksheets
    • Viewing More Than One Workbook
    • Hiding And Unhiding Worksheets
  • 05. Learning Microsoft Excel 2010 - 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
  • 06. Learning Microsoft Excel 2010 - Workbook Formatting
    • Modifying Typeface, Font Size And Colors
    • Merging Cells
    • Applying Number Formats
    • Aligning Cell Contents
    • Changing The Text Direction In A Cell
    • Adding Borders To Cells And Ranges
    • Applying A Date Format To A Cell Or Range
    • Use Of The Format Painter
    • Clearing Cell Contents And/Or Formatting
  • 07. Learning Microsoft Excel 2010 - 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
  • 08. Learning Microsoft Excel 2010 - Advanced Formatting
    • Enhancing Worksheets Using Themes
    • Working With Comments
    • Creating Your Own AutoFill List
    • Turning Your Data Into A Table For Formatting
  • 09. Learning Microsoft Excel 2010 - Security
    • Using Protection On A Worksheet
    • Protecting Part Of A Worksheet To Facilitate Data Entry
    • Controlling Access To Cell Ranges By Password And Or User Accounts
    • Saving A Workbook With Password Protection
  • 10. Learning Microsoft Excel 2010 - Using Templates
    • Creating A Workbook From A Template
    • Creating Your Own Custom Template
  • 11. Learning Microsoft Excel 2010 - 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
  • 12. Learning Microsoft Excel 2010 - 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
  • 13. Learning Microsoft Excel 2010 - Using Charts In Excel
    • Creating A Chart The Long Way
    • Creating A Chart The Quick Way
    • Changing A Chart From A Sheet Object To A Sheet
    • Modifying Your Chart Type
    • Controlling Chart Style And Layout
    • Adding A Trend line To A Chart
    • Pie Charts In More Detail
  • 14. Learning Microsoft Excel 2010 - More Advanced Formula
    • Adding An IF Function For Cell Comparisons
    • Using the IF Function To Suppress Excel Error Messages
    • Text Manipulation With Formulae - Part 1
    • Text Manipulation With Formulae - Part 2
    • Date Formula In Excel
    • DATEDIF - A Hidden But Useful Formula
    • SUMIF COUNTIF And AVERAGEIF
    • Use Of A Formula To Rank Scores
  • 15. Learning Microsoft Excel 2010 - 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
  • 16. Learning Microsoft Excel 2010 - 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
  • 17. Learning Microsoft Excel 2010 - Credits And Beyond
    • About The Author
  • 01. Advanced Microsoft Excel 2010 Training - Getting Started
    • 0101 How Advanced Does The Advanced Get?
    • 0102 Using The Files Included
    • 0103 About The Author
    • 0104 New In 2010 - The Sparkline
  • 02. Advanced Microsoft Excel 2010 Training - The IF Function
    • 0201 The Syntax Of IF
    • 0202 Nesting The IF Statement
    • 0203 Use The AND Operator To Reduce Quantity Of Nested IFs
    • 0204 Use The OR Operator To Reduce Quantity Of Nested IFs
    • 0205 The NOT Operator Within AND And OR Statements
    • 0206 SUMIF For Selective Adding Up
    • 0207 COUNTIF For Selective Counting
    • 0208 AVERAGEIF For The Mean Of Cells That Meet Our Criteria
    • 0209 Multiple Criteria Within The Same SUM AVERAGE And COUNT Functions
  • 03. Advanced Microsoft Excel 2010 Training - Performing Lookups
    • 0301 VLOOKUP Explained
    • 0302 Applied Examples For VLOOKUP
    • 0303 HLOOKUP Explained
    • 0304 HLOOKUP In Action
    • 0305 Looking For A Near Match In A Lookup
    • 0306 Checking For Missing Data In A Lookup
    • 0307 Extending The Size Of A Lookup Table
    • 0308 Nested LOOKUPs
  • 04. Advanced Microsoft Excel 2010 Training - Data Functions
    • 0401 The MATCH Function Explained
    • 0402 The INDEX Function Syntax
    • 0403 How To Stop Nonexistent Row Or Column Lookups In INDEX
    • 0404 The CHOOSE Lookup Function
  • 05. Advanced Microsoft Excel 2010 Training - Math Functions
    • 0501 Working With TIME In Excel
    • 0502 Rounding To Fractional Values
    • 0503 MOD For Working Out Remainders
    • 0504 Generating A Random Number
    • 0505 Pick A List Item At Random
    • 0506 Calculating Loan Repayments Using PMT
    • 0507 Investment Calculations Using PMT
    • 0508 Working Out Depreciation
    • 0509 Working Out Different Parts Of A Loan Calculation
  • 06. Advanced Microsoft Excel 2010 Training - Arrays
    • 0601 What Is An Array And An Array Formula
    • 0602 Creating And Using An Array Formula
    • 0603 Conditional Evaluation In An Array Formula
    • 0604 The Very Clever TRANSPOSE Array Function
  • 07. Advanced Microsoft Excel 2010 Training - Functions For Working With Text
    • 0701 LEN And TRIM Two Very Useful Text Functions
    • 0702 Using LEFT And RIGHT For String Extraction
    • 0703 FIND And MID Working Together To Extract Parts Of Strings
    • 0704 Build Strings From Multiple Cells
    • 0705 Changing The Case Of Text In Cells
    • 0706 REPLACE And SUBSTITUTE In Action
    • 0707 Formatting Numeric Values With A Text String Using TEXT
    • 0708 Extracting The Values From The Text Functions We Have Used
  • 08. Advanced Microsoft Excel 2010 Training - Other Useful Functions
    • 0801 Welcome To IS Functions
    • 0802 Error Checking With ISERR ISERROR ISNA And IFERROR
    • 0803 The OFFSET Formula Explained
    • 0804 Dynamic Named Ranges Using The OFFSET Function
    • 0805 Use The INDIRECT Function To Build Dynamic Formulas
    • 0806 Dealing With INDIRECT Errors
    • 0807 Use Formulas To Determine An Excel Filename And Or Sheet Name
  • 09. Advanced Microsoft Excel 2010 Training - Sparklines
    • 0901 Creating A Sparkline
    • 0902 Change The Design Of Sparklines
    • 0903 Dealing with Empty Cells
    • 0904 Comparing One Sparkline To Another by Altering Vertical Scale
    • 0905 Removing Sparklines From A Sheet
  • 10. Advanced Microsoft Excel 2010 Training - Outlining
    • 1001 Outlining Explained
    • 1002 Creating An Outline Automatically
    • 1003 Creating An Outline Manually
    • 1004 Manually Removing Data From An Outline
    • 1005 Removing The Outlining From A Worksheet
    • 1006 Adjusting A Grouping Created By Automatic Outlining
  • 11. Advanced Microsoft Excel 2010 Training - Custom Views
    • 1101 Creating A Custom View Of A Worksheet
    • 1102 Changing From One Custom View To Another
    • 1103 Editing A Custom View
    • 1104 How To Delete A Custom View
  • 12. Advanced Microsoft Excel 2010 Training - Scenario
    • 1201 Setting Up A Scenario And Entering Values
    • 1202 Display The Scenario Values
    • 1203 Editing The Values Of A Scenario
    • 1204 Deleting A Scenario
    • 1205 Merge Scenarios From Different Sheets
    • 1206 Getting A Summary Of All Scenarios
  • 13. Advanced Microsoft Excel 2010 Training - Auditing And Troubleshooting Formulas
    • 1301 Description Of Tracer Arrows
    • 1302 Tracing Precedents And Dependents
    • 1303 Remove Tracer Arrows
    • 1304 Error Checking Using Auditing Tools
    • 1305 Step By Step Processing Of Formula To Help With Troubleshooting
    • 1306 Utilizing The Watch Window
  • 14. Advanced Microsoft Excel 2010 Training - Pivot Tables
    • 1401 What Is A Pivot Table
    • 1402 Steps To Create A Pivot Table
    • 1403 Rearranging Fields In A Pivot Table
    • 1404 Changing The Math Of The Data Summary
    • 1405 Number Format Control Of The Summary Area
    • 1406 Creating A Second (Or More) Pivot Table On The Same Data
    • 1407 Moving A Pivot Table
    • 1408 Removing A Pivot Table
    • 1409 Making Use Of The Report Filter Option
    • 1410 Sorting A Pivot Tables Columns
    • 1411 Displaying Values As A Percentage
    • 1412 Refreshing A Pivot Table Manually Or Semi-Automatically
    • 1413 Drilling Down Behind The Pivot Table Summaries
    • 1414 Applying Pivot Table Styles
    • 1415 Creating Your Own Custom Pivot Table Style
    • 1416 Copying A Pivot Table Style Between Workbooks
    • 1417 Using More Than One Field In Row And Column Headings
    • 1418 Disabling And Enabling Grand And Sub Totals
    • 1419 Filtering Columns And Rows Within A Pivot Table
    • 1420 Dealing With Empty (NULL) Cells
    • 1421 Exploring The Additional Pivot Table Options
    • 1422 Introducing The Slicer Tool
    • 1423 Managing Your Slices
    • 1424 Formatting Your Slices
    • 1425 Connecting A Pivot Table To SQL Server
    • 1426 External Connection Refresh Rate And Password Saving
  • 15. Advanced Microsoft Excel 2010 Training - Pivot Charts
    • 1501 Creating A Pivot Chart
    • 1502 Altering Chart Types Formats And Layouts
    • 1503 Advanced Layout Control Of A Pivot Chart
    • 1504 Filtering A Pivot Chart
    • 1505 Hiding Pivot Chart Elements
    • 1506 Moving A Pivot Chart Between Sheets
    • 1507 Deleting A Pivot Chart (With Care)
  • 16. Advanced Microsoft Excel 2010 Training - Goal Seek And Solver
    • 1601 Using Goal Seek To Carry Out What If Analysis
    • 1602 Using SOLVER To Carry Out What if Analysis
    • 1603 Activating The SOLVER Add In
    • 1604 Add Constraints Into A SOLVER Problem
    • 1605 Alberts Cafe Solver Solution
  • 17. Advanced Microsoft Excel 2010 Training - Macros
    • 1701 What Is A Macro
    • 1702 Creating Storing And Running Your First Macro
    • 1703 Using Relative Or Absolute Referencing During Recording
    • 1704 Saving Workbooks With Macros Issues
    • 1705 Opening Files Containing Macros
    • 1706 The PERSONAL Workbook
    • 1707 How To Delete Macros
    • 1708 Use A Macro For Formatting
    • 1709 Trigger A Macro With A Keyboard Shortcut
    • 1710 Using Form Buttons To Trigger Macros
    • 1711 Customizing The Form Buttons
    • 1712 Assigning Macros To Ribbon Icons
    • 1713 Create Your Own Ribbon
    • 1714 Remove Options From Ribbons
    • 1715 View And Edit Macro Code
    • 1716 Add A Confirmation Dialog Box To Macros

Additional information

Digital Download FAQs

Q: What is a digital download?

A digital download is training that you download from the internet using your web browser instead of us shipping you a physical CD.

Q: How instant is the "Instant Purchase"?

If you complete your purchase, you are emailed your access key within minutes of the transaction completing.

Q: How do I access my digital download...