Microsoft Excel 2013 Training Bundle Training Video

Courses For Success
Online

AU$ 189 - (Rs 9,535)
+ VAT

Important information

  • Course
  • Online
  • When:
    Flexible
Description

  Microsoft Excel 2013 Training Bundle Training Video A Practical Excel Training Course That Teaches Real World Skills In this project-based Microsoft Excel 2013 Training Bundle video tutorial series, you'll quickly have relevant skills for real-world applications. Follow along with our expert instructor in this Microsoft Excel 2013 Training Bundle Training Video course to get: Concise, informative and broadcast-quality Microsoft Excel 2013 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 2013 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 2013 Training Bundle tutorial, online or offline... so you'll know the exact steps for your own projects. Course Fast Facts: Only 17.75 hours to complete this course 234 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 This training bundle includes, Learning Microsoft Excel 2013 Advanced Microsoft Excel 2013
In this training bundle for Microsoft Excel 2013, you will learn how to take control of the most popular and most powerful spreadsheet software on the planet. Expert author Guy Vaccaro is your guide through this training course, and takes you from the absolute basics to a very advanced level of proficiency in Excel 2013.
Even if you have never used Microsoft Excel before, this video tutorial will show you the ins and outs of using the program. You start with the absolute basics in the Learning...

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
Basic IT
Syntax
Microsoft excel training
MS Excel
Skills and Training

Course programme

01. Learning Microsoft Excel 2013 - Start Here
  • 0101 Let's Get Started With Excel 2013
  • 0102 The Excel Workbook Explained
  • 0103 Signing Up For Your Own Free SkyDrive
  • 0104 Customize The Quick Access Toolbar
  • 0105 Using The Included Working Files
  • 0106 About The Author
  • 02. Learning Microsoft Excel 2013 - Managing Excel Workbooks And Worksheets
    • 0201 Creating And Saving A New Workbook
    • 0202 Opening Workbooks And Save As Options
    • 0203 Saving And Opening SkyDrive Files
    • 0204 Navigating An Excel Workbook
    • 0205 Adding And Removing Worksheets
    • 0206 Renaming Copying And Moving Worksheets
  • 03. Learning Microsoft Excel 2013 - Entering And Editing Data In Cells
    • 0301 Entering Text, Numbers, And Dates
    • 0302 Entering Numbers As Text
    • 0303 Editing The Contents Of A Cell
    • 0304 Undo And Redo Actions
    • 0305 Cut, Copy, And Paste
    • 0306 Dragging And Dropping Cells
    • 0307 The Fill Handle
    • 0308 Inserting And Deleting Cells Columns And Rows
    • 0309 Changing Column Widths And Row Heights
    • 0310 Hiding And Un-Hiding Columns And Rows
    • 0311 Searching For Values In A Workbook
  • 04. Learning Microsoft Excel 2013 - Math Basics
    • 0401 Getting Started With Basic Math Formulas
    • 0402 Order Of Operation With BODMAS
    • 0403 Introduction To Basic Formulas
    • 0404 Copying Formulas And Functions
    • 0405 Displaying Formulas On A Worksheet
  • 05. Learning Microsoft Excel 2013 - Formatting Worksheets
    • 0501 Selecting Cells For Formatting
    • 0502 Modifying Typeface Font, Size, And Colour
    • 0503 Merging And Wrapping Cell Contents
    • 0504 Using Number Formats
    • 0505 Cell Content Alignment And Orientation
    • 0506 Adding And Removing Borders From A Selection
    • 0507 Applying A Date Format To A Cell Or Range
    • 0508 The Format Painter
    • 0509 Finding And Replacing Formats
    • 0510 Clearing Cell Contents Vs. Clearing Cell Formatting
  • 06. Learning Microsoft Excel 2013 - Workbook And Worksheet Management
    • 0601 Worksheet Navigation And Coloured Worksheet Tabs
    • 0602 Moving Or Copying Worksheets Within And Between Workbooks
    • 0603 Viewing And Scrolling Multiple Workbooks At The Same Time
    • 0604 Hiding And Un-Hiding Sheets
    • 0605 Modifying More Than One Worksheet At A Time
  • 07. Learning Microsoft Excel 2013 - Page Setup And Printing
    • 0701 Using Print Titles And Print Areas
    • 0702 Paper Size, Orientation, Margins, And Scaling Options
    • 0703 Creating Headers and Footers
    • 0704 Using The Page Break And The Page Layout Views
    • 0705 Printing A Range Of Cells
    • 0706 Running The Spell Checker
    • 0707 Controlling Most Print Settings In One Place
  • 08. Learning Microsoft Excel 2013 - Mathematical Formulas
    • 0801 The Sum Function
    • 0802 Copying Formulas And Functions
    • 0803 Other Mathematical Functions: Average, Min, And Max
    • 0804 Useful Count Functions
    • 0805 Absolute Referencing Explained
    • 0806 Formulas Across Worksheets
    • 0807 3D Referencing
    • 0808 Making Use Of Named Cells And Ranges
  • 09. Learning Microsoft Excel 2013 - Advanced Formatting
    • 0901 Enhancing Worksheets Using Themes
    • 0902 Adding, Editing, And Deleting Comments
    • 0903 Creating Your Own Autofill List
    • 0904 Converting Data To A Table For Formatting
  • 10. Learning Microsoft Excel 2013 - Security
    • 1001 Activating And Deactivating Worksheet Protection
    • 1002 Protecting Part Of A Worksheet To Aid Data Entry
    • 1003 Password Protecting The Whole Workbook
  • 11. Learning Microsoft Excel 2013 - Excel 2013 Templates
    • 1101 Using The 2013 Templates
    • 1102 Creating And Using Your Own Template
  • 12. Learning Microsoft Excel 2013 - Graphics Objects
    • 1201 Obtaining And Inserting Online Images
    • 1202 Using SmartArt Graphics
    • 1203 Inserting Shapes And Screenshots
    • 1204 Formatting Graphical Objects
    • 1205 The Stacking Order
    • 1206 Grouping Multiple Objects Together
    • 1207 Using Graphical Objects And Mathematical Formulas
  • 13. Learning Microsoft Excel 2013 - Using Charts In Excel
    • 1301 The New Recommended Charts Option
    • 1302 Create A Chart Using The Long Or The Short Method
    • 1303 Formatting A Chart With The 2013 Shortcut Options
    • 1304 Modifying The Chart Type
    • 1305 Formatting Chart Elements
    • 1306 Adding A Trendline
    • 1307 The Pie Chart In Detail
    • 1308 Mini Graphs: Sparklines
  • 14. Learning Microsoft Excel 2013 - Excel As A Database
    • 1401 Fixing On Screen Rows And Columns
    • 1402 Fixing Print Rows And Columns
    • 1403 Sorting Data In Excel
    • 1404 Filtering Data To Reduce Dataset Size
    • 1405 Removing Duplicate Entries In The Data
    • 1406 Adding Subtotals To A Worksheet Of Data
    • 1407 Using Text To Columns Effectively
    • 1408 Linking To Data On A Webpage
  • 15. Learning Microsoft Excel 2013 - Advanced Formulas
    • 1501 Using An If Formula
    • 1502 Use Of The If Function To Hide Excel Error Messages
    • 1503 Datedif: A Useful But Hidden Formula
    • 1504 Text Manipulation Using Functions
    • 1505 Use The Text Function To Format Numbers
    • 1506 Date Manipulation Functions
    • 1507 Introducing Sumif, Countif, And Averageif
    • 1508 Use Of Rank To Calculate Placings
    • 1509 Flash Fill: The Magic Touch
  • 16. Learning Microsoft Excel 2013 - Conditional Formatting
    • 1601 Altering Cell Appearance Based On The Cell Value
    • 1602 Displaying Data Bars, Color Scales, Or Icon Sets
    • 1603 Using Top And Bottom Rules For Formatting
    • 1604 Creating A Formatting Rule From Scratch
    • 1605 Managing The Conditional Formatting Rules
  • 17. Learning Microsoft Excel 2013 - What's Next
    • 1701 The New Office Apps For Excel 2013
    • 1702 Ready To Go Advanced
  • 01. Advanced Microsoft Excel 2013 Training - Getting Started
    • 0101 Will I Be Able To Keep Up?
    • 0102 Using The Included Files
    • 0103 New For 2013: Its All In The Cloud
    • 0104 The Very Clever Flash Fill
  • 02. Advanced Microsoft Excel 2013 Training - Using Mathematical Functions
    • 0201 The Basic SUM, COUNT, MIN, And MAX
    • 0202 AVERAGE, MODE, MEAN, And MEDIAN
    • 0203 SUMIF For Selective Adding Up
    • 0204 COUNTIF For Selective Counting
    • 0205 AVERAGEIF For The Mean Of Selected Cells
    • 0206 Multiple Criteria Within SUMIF, COUNTIF, And AVERAGEIF
    • 0207 Area And Volume Calculations
  • 03. Advanced Microsoft Excel 2013 Training - IF Functionality
    • 0301 IF Syntax And Uses
    • 0302 Nesting The IF Statement
    • 0303 Use Of The AND Operator Within An IF
    • 0304 Use Of The OR Operator Within An IF
    • 0305 The NOT Operator Within AND And OR Statements
    • 0306 Display Cell Formulas In Another Cell
  • 04. Advanced Microsoft Excel 2013 Training - Performing Data Lookups
    • 0401 VLOOKUP: Syntax And Usage
    • 0402 VLOOKUP In Live Action
    • 0403 HLOOKUP: Variation On A Theme
    • 0404 Using A Near Match In The Lookup
    • 0405 Dealing With Missing Data In A Lookup
    • 0406 Managing The Lookup Table
    • 0407 Lookups Nested Within Lookups
  • 05. Advanced Microsoft Excel 2013 Training - Sparklines
    • 0501 Creating A Sparkline
    • 0502 Altering The Design Of Sparklines
    • 0503 Dealing With Empty Cells
    • 0504 Comparing Sparklines Within A Sparkline Group
    • 0505 Removing Sparklines From A Worksheet
  • 06. Advanced Microsoft Excel 2013 Training - Further Mathematical Functions
    • 0601 Working With Time In Excel
    • 0602 Calculations Using Time
    • 0603 Useful Time And Date Functions
    • 0604 Rounding Decimal Places
    • 0605 MOD And INT Functions And Uses
    • 0606 Generate And Use A Random Number
    • 0607 Loan And Investment Calculations
    • 0608 Loan Calculation Elements And Functions
  • 07. Advanced Microsoft Excel 2013 Training - Outlining
    • 0701 Create An Outline Automatically
    • 0702 Adding An Outline Manually
    • 0703 Editing And Removing Outlining
  • 08. Advanced Microsoft Excel 2013 Training - Scenarios
    • 0801 Setting Up A Set Of Scenarios
    • 0802 Displaying And Editing The Different Scenarios
    • 0803 How To Work Out Which Scenario You Are Displaying
    • 0804 Merging And Deleting Scenarios
    • 0805 Producing A Summary Of Scenarios
  • 09. Advanced Microsoft Excel 2013 Training - Custom Views
    • 0901 Custom Views Explained
    • 0902 Use Of Outlining To Help Setup Custom Views
    • 0903 Editing And Deleting Custom Views
    • 0904 Add Quick Access To Custom Views
  • 10. Advanced Microsoft Excel 2013 Training - Functions For Manipulating Text
    • 1001 LEFT And RIGHT: Text Manipulation
    • 1002 LEN And TRIM: String Extractions
    • 1003 FIND And MID: Text Functions Working Together
    • 1004 CONCATENATE: Building Strings From Multiple Cells
    • 1005 Changing Case Functions
    • 1006 REPLACE And SUBSTITUTE: Two More String Manipulation Functions
    • 1007 Use Of CHAR Function For More Obscure Characters
    • 1008 Formatting Numeric And Date Values Using TEXT
    • 1009 Keeping The Values Created By String Manipulation
  • 11. Advanced Microsoft Excel 2013 Training - Arrays
    • 1101 Arrays And Creating A New Array Formula
    • 1102 Array Formulas With IF Statements
    • 1103 Conditional Evaluation With No IFs
    • 1104 The Array-Only TRANSPOSE Function
  • 12. Advanced Microsoft Excel 2013 Training - Useful Data Functions
    • 1201 Using The MATCH Function
    • 1202 How The INDEX Function Works
    • 1203 Handling Out Of Range Index Requests
    • 1204 The CHOOSE Lookup Function
    • 1205 MATCH And INDEX Functions Working Together
  • 13. Advanced Microsoft Excel 2013 Training - Some Other Useful Functions
    • 1301 Introducing IS Functions
    • 1302 Error Checking Using ISERR, ISERROR, And IFERROR
    • 1303 OFFSET Function Syntax
    • 1304 OFFSET Function: Creating A Dynamic Named Range
    • 1305 INDIRECT Function To Build Dynamic Formulas
    • 1306 Dealing With INDIRECT Errors
    • 1307 The CELL Function And Determining File Or Sheet Names
  • 14. Advanced Microsoft Excel 2013 Training - Auditing And Troubleshooting Formulas
    • 1401 What Are Tracer Arrows
    • 1402 Adding And Removing Tracer Arrows
    • 1403 Auditing Tools: Error Checking And Tracing
    • 1404 Step-By-Step Formula Processing
    • 1405 Using The Watch Window In Troubleshooting
  • 15. Advanced Microsoft Excel 2013 Training - PivotTables
    • 1501 What Is A PivotTable?
    • 1502 The New Recommended PivotTable Route
    • 1503 Creating Your Own PivotTables
    • 1504 Changing The Formatting And Formulas In PivotTable Summaries
    • 1505 Creating Multiple PivotTables On The Same Dataset
    • 1506 Moving And Deleting PivotTables
    • 1507 Making Use Of The Report Filter Options
    • 1508 Sorting The PivotTable Columns
    • 1509 Refreshing A PivotTable
    • 1510 Drilling Down Behind The Pivot Numbers
    • 1511 Multiple Fields In Row, Column, Or Data Sections
    • 1512 Controlling Grand Totals And Subtotals
    • 1513 Dealing With Empty Cells And Other Additional Options
    • 1514 PivotTable Styles
    • 1515 Creating Your Own PivotTable Styles
    • 1516 Creating And Using Calculated Fields
    • 1517 Using The New Timeline Filter Option
    • 1518 Adding And Using The Data Slicer
    • 1519 Using Data From An SQL Server In A PivotTable
    • 1520 Managing The External Connection To SQL Server
  • 16. Advanced Microsoft Excel 2013 Training - PivotCharts
    • 1601 Creating A PivotChart
    • 1602 Changing The Fields Used In A PivotChart
    • 1603 Formatting The PivotChart
    • 1604 Changing The PivotChart Type
    • 1605 Filtering A PivotChart
    • 1606 Hiding The PivotChart Buttons
    • 1607 Moving And Deleting PivotCharts
  • 17. Advanced Microsoft Excel 2013 Training - Goal Seek And Solver
    • 1701 What-If Analysis Using Goal Seek
    • 1702 Activating The Solver Add-In
    • 1703 Using Solver To Complete A What-If
    • 1704 Adding Constraints To Solver
  • 18. Advanced Microsoft Excel 2013 Training - Macros
    • 1801 What Is A Macro
    • 1802 Creating And Running Your First Macro
    • 1803 Saving Workbooks With Macros
    • 1804 Macro Security Settings For Workbooks With Macros
    • 1805 The Personal Macro Workbook
    • 1806 Deleting Macros
    • 1807 Use Of Relative Or Absolute Referencing
    • 1808 Trigger A Macro With A Keyboard Shortcut
    • 1809 Formatting With A Macro
    • 1810 Switch Scenarios And Views With Macros
    • 1811 Use Of Worksheet Buttons To Trigger Macros
    • 1812 Customizing Form Buttons And Other Shape Triggers
    • 1813 Assigning Macros To Ribbon Icons
    • 1814 Create Your Own Ribbon
    • 1815 View And Edit Macro Code
    • 1816 Add An Are You Sure Box To Macros
  • 19. Advanced Microsoft Excel 2013 Training - Summary And Credits
    • 1901 What Have I Learned
    • 1902 About The Author

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...