Categories Menu

Posted on Apr 16, 2013 in Microsoft Office, Superguides | 0 comments

Master Microsoft’s powerful Excel 2013 spreadsheet package with this amazing training course

Excel 2013 training course

Microsoft Office 2013 is used by millions of businesses and home users all around the world. Microsoft Excel, the spreadsheet component of Office 2013, is the benchmark all other spreadsheet packages are compared to. While OpenOffice Calc is a viable alternative for light spreadsheet users, it cannot compare with the power of Microsoft’s mighty Excel.

Several of our readers have asked us about a training course for Microsoft Excel. Currently we do not have the resources to produce one in-house, so we searched the internet for the best training materials. Guy Vaccaro has produced an amazingly in-depth, beginner friendly guide to this incredibly powerful package.

In this project-based Learning Microsoft Excel 2013 video tutorial series, you’ll quickly have relevant skills for real-world applications. Follow along with our expert instructor in this training course and get concise, informative and broadcast-quality Microsoft Excel 2013 training videos on your desktop. Learn at your own pace with the intuitive, easy-to-use interface. Quickly grasp even the most complex Microsoft Excel 2013 training subjects with simple, easy to follow segments.

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 tutorial, online or offline.

The complete contents of the training course are listed below. Thanks to our friends at Infinite Skills, we are able to bring you 14 video tutorials absolutely free, simply click on the links to be taken to the relevant lesson (videos open in a new window/tab due to their size).

Free videos from this course:-

01. Start Here

  • Getting Started With Excel 2013
  • The Excel Workbook Explained
  • Signing Up For Your Own Free SkyDrive
  • Customize The Quick Access Toolbar
  • Using The Included Working Files
  • About The Author

02. Managing Excel Workbooks And Worksheets

  • Creating And Saving A New Workbook
  • Opening Workbooks And Save As Options
  • Saving And Opening SkyDrive Files
  • Navigating An Excel Workbook
  • Adding And Removing Worksheets
  • Renaming Copying And Moving Worksheets

03. Entering And Editing Data In Cells

  • Entering Text, Numbers, And Dates
  • Entering Numbers As Text
  • Editing The Contents Of A Cell
  • Undo And Redo Actions
  • Cut, Copy, And Paste
  • Dragging And Dropping Cells
  • The Fill Handle
  • Inserting And Deleting Cells Columns And Rows
  • Changing Column Widths And Row Heights
  • Hiding And Un-Hiding Columns And Rows
  • Searching For Values In A Workbook

Ready to order? Microsoft Excel 2013 Training Costs $99.95. Click here to be taken directly to the order page. Alternatively, you can see the contents of the rest of the training course below:-

04. Math Basics

  • Getting Started With Basic Math Formulas
  • Order Of Operation With BODMAS
  • Introduction To Basic Formulas
  • Copying Formulas And Functions
  • Displaying Formulas On A Worksheet

05. Formatting Worksheets

  • Selecting Cells For Formatting
  • Modifying Typeface Font, Size, And Colour
  • Merging And Wrapping Cell Contents
  • Using Number Formats
  • Cell Content Alignment And Orientation
  • Adding And Removing Borders From A Selection
  • Applying A Date Format To A Cell Or Range
  • The Format Painter
  • Finding And Replacing Formats
  • Clearing Cell Contents Vs. Clearing Cell Formatting

06. Workbook And Worksheet Management

  • Worksheet Navigation And Coloured Worksheet Tabs
  • Moving Or Copying Worksheets Within And Between Workbooks
  • Viewing And Scrolling Multiple Workbooks At The Same Time
  • Hiding And Un-Hiding Sheets
  • Modifying More Than One Worksheet At A Time

07. Page Setup And Printing

  • Using Print Titles And Print Areasn
  • Paper Size, Orientation, Margins, And Scaling Options
  • Creating Headers and Footers
  • Using The Page Break And The Page Layout Views
  • Printing A Range Of Cells
  • Running The Spell Checker
  • Controlling Most Print Settings In One Place

08. Mathematical Formulas

  • The Sum Function
  • Copying Formulas And Functions
  • Other Mathematical Functions: Average, Min, And Max
  • Useful Count Functions
  • Absolute Referencing Explained
  • Formulas Across Worksheets
  • 3D Referencing
  • Making Use Of Named Cells And Ranges

09. Advanced Formatting

  • Enhancing Worksheets Using Themes
  • Adding, Editing, And Deleting Comments
  • Creating Your Own Autofill List
  • Converting Data To A Table For Formatting

10. Security

  • Activating And Deactivating Worksheet Protection
  • Protecting Part Of A Worksheet To Aid Data Entry
  • Password Protecting The Whole Workbook

11. Excel 2013 Templates

  • Using The 2013 Templates
  • Creating And Using Your Own Template

12. Graphics Objects

  • Obtaining And Inserting Online Images
  • Using SmartArt Graphics
  • Inserting Shapes And Screenshotst
  • Formatting Graphical Objects
  • The Stacking Order
  • Grouping Multiple Objects Together
  • Using Graphical Objects And Mathematical Formulas

13. Using Charts In Excel

  • The New Recommended Charts Option
  • Create A Chart Using The Long Or The Short Method
  • Formatting A Chart With The 2013 Shortcut Options
  • Modifying The Chart Type
  • Formatting Chart Elements
  • Adding A Trendline
  • The Pie Chart In Detail
  • Mini Graphs: Sparklines

14. Excel As A Database

  • Fixing On Screen Rows And Columns
  • Fixing Print Rows And Columns
  • Sorting Data In Excel
  • Filtering Data To Reduce Dataset Size
  • Removing Duplicate Entries In The Data
  • Adding Subtotals To A Worksheet Of Data
  • Using Text To Columns Effectively
  • Linking To Data On A Webpage

15. Advanced Formulas

  • Using An If Formula
  • Use Of The If Function To Hide Excel Error Messages
  • Datedif: A Useful But Hidden Formula
  • Text Manipulation Using Functions
  • Use The Text Function To Format Numbers
  • Date Manipulation Functions
  • Introducing Sumif, Countif, And Averageif
  • Use Of Rank To Calculate Placings
  • Flash Fill: The Magic Touch

16. Conditional Formatting

  • Altering Cell Appearance Based On The Cell Value
  • Displaying Data Bars, Color Scales, Or Icon Sets
  • Using Top And Bottom Rules For Formatting
  • Creating A Formatting Rule From Scratch
  • Managing The Conditional Formatting Rulese

17. What’s Next

  • The New Office Apps For Excel 2013
  • Ready To Go Advanced

Order now!

To order for $99.95, either as a DVD or digital download, click here. We are confident you won’t find a better, easier and more thorough Microsoft Excel training course anywhere on the internet.

Post a Reply

Your email address will not be published. Required fields are marked *