excel 2013 online course

The excel 2013 online courses is a great value or anyone that would like to learn Excel, but isn’t interested in an actual class format. The quality of the content is excellent and covers the full spectrum of skills for Excel. To make your manual purchase easier, the course package includes access to an online version of the course so you can view it from anywhere!

Learn Excel 2013 online with this online Excel 2013 course from Microsoft Certified Trainer, Lisa Miller. Learn to work in the new interface, understand formulas and functions, create charts and tables, use PivotTables and PowerPivot, audit data and formulas, collaborate with coworkers, manage multiple worksheets and workbooks, audit data and formulas, share dashboards with Power View, use macros to automate tasks

What Will You Learn?

Excel 2013 Training Videos will introduce you to the basics of creating a: spreadsheet, with simple formulas and calculations to more powerful ones, and how you can use Excel 2013 as a database with many sorting and filtering options. It’s also important to know how to create your database right the first time, like how to avoid common design flaws, and numerous time saving features!

Learn how to create charts from your organized data, how to format your data range into a nice looking table, and more by our Microsoft Certified Trainer training Excel 2013!

Our Excel 2013 Levels 1, 2 & 3 training videos include all the training you need to pass the Excel 2013 Core (77-420) and Expert Part 1 (77-427) and Part 2 (77-428) Exams and become certified!

Excel 2013: Getting Started with Excel

Top 10 free online excel 2013 training courses

If you are looking for a free course to teach you important Excell 2013 skills, look no further. Excel 2013 is a resource from Microsoft that is used to calculate and analyze numbers. If you have little or no knowledge of these lessons, you should take one of our courses.

1. Microsoft Excel – Excel from Beginner to Advanced (Udemy)

This course helps you master Microsoft Excel from beginner to advanced level. It is taught by Kyle Pew, a Microsoft Office Certified Expert and also a Microsoft Certified Trainer with over 18+ years of live classroom and online training experience. He uses his Excel training experience to guide you step-by-step so you can build a strong foundation as you progress through intermediate, advanced levels and beyond.

This course is very in-depth and combines 4 different Excel courses:

  • Microsoft Excel 101 (Introduction) – covers the fundamentals of Excel, like, excel interface, creating spreadsheets, entering/editing data, working with formulas, formatting data, excel print options, common excel shortcuts, and visualize data with charts
  • Microsoft Excel 102 (Intermediate level) – covers topics like working with excel lists/tables, sorting and filtering data, working with list functions, data validation, importing and exporting data, pivot tables, and managing large sets of data
  • Microsoft Excel 103 (Advanced level) – covers topics like, creating advanced excel formulas, lookup functions, text based functions, auditing excel formulas, protecting excel sheets, what if analysis and introduction to macros
  • Master Microsoft Excel Macros and VBA in 6 Simple Projects – covers macros and VBA in detail so you learn how to automate excel tasks and how to create VBA procedures etc.

This course was created with Excel 2013. But all features work in Excel 2010, 2013 and 2016. You get lifetime access to 16 hours of video content, 4 articles and 37 downloadable resources.

Key Highlights

  • Learn to create effective spreadsheets
  • Master Excel’s most popular functions like, SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH and more
  • Learn Microsoft Excel’s AddIn, PowerPivot tools
  • Learn to create dynamic reports with Excel PivotTables
  • Learn to automate day to day Excel tasks using Macros and VBA

Duration : 16 hours on-demand video
Rating : 4.6
Sign up Here

2. Excel Skills for Business Specialization by Macquarie University (Coursera)

This Excel certification is intended for those who want to develop advanced Excel skills for business. It will progressively take you through 4 levels of Excel topics, (Essentials, Intermediate I, Intermediate II and Advanced), building up on the knowledge gained in the previous level. Upon completion of this Excel specialization courses, you will be able to design sophisticated spreadsheets, including professional dashboards, and perform complex calculations using advanced Excel features and techniques.

You will also acquire the skills to manage large datasets efficiently, present data effectively and extract meaningful information from datasets. In addition, you will be able to validate data and prevent errors in spreadsheets, create automation, apply advanced formulas and conditional logic to make informed business decisions.

Key Highlights

  • Best Microsoft Excel Certification online course for self-learners and business users
  • Learn to navigate the Excel user interface, entering, manipulating and formatting data
  • Learn to create spreadsheets that help forecast and model data
  • Learn efficient techniques and tools that allow automation of everyday tasks in Excel
  • Understand how to clean and prepare data for analysis
  • Learn to create charts and tables to effectively summarize raw data in a user-friendly way
  • Learn how to work with dates and financial functions
  • Build professional dashboards in Excel
  • Learn to create navigation aids for large workbooks
  • Includes a broad range of practice quizzes and challenges that provide great opportunities to build up your skill set
  • Great teaching team to help you every step of the way

Duration : Approx. 3 months, 11 hours per week
Rating : 4.9

3. Excel 2016 Essential Training (LinkedIn Learning – Lynda)

This course has been created by Excel expert Dennis Taylor, Principal at Taylor Associates. It aims to impart necessary skills to use Microsoft Excel and become proficient at it. The course begins with getting you familiar with Excel interface, menu system, how to enter and organize data, how to edit and format the data, how to create formulas using simple functions. Then it progresses to advanced topics like building charts and PivotTables, working with multiple worksheets, using powerful functions like IF, VLOOKUP, COUNTIF etc. You will also learn to automate tasks using Macros and use data analysis tools like Goal Seek and Solver.

Key Highlights

  • Understand Excel’s Menu system and perform simple to complex calculations easily
  • Get time saving tips and tricks to improve efficiency like entering data with AutoFill
  • Work with dates and times
  • Learn how to use printing and charting capabilities of Excel
  • Learn to work with multiple worksheets and workbooks
  • Understand security and sharing of workbooks
  • Learn data management features of Excel like sorting, using filters, validation tools etc.
  • Understand how to create PivotTables and use PivotCharts

Duration : 8 hours 53 minutes
Rating : 4.6

4. Microsoft Excel – From Beginner to Expert in 6 Hours (Udemy)

This Microsoft Excel crash course provides learners everything that they need to know about Excel, right from the fundamentals to the most advanced features, so they can quickly be able to use Excel at an expert level. This course has been developed by a Microsoft Certified Master Instructor, Todd McLeod, who is a university professor with over twenty years of experience teaching Microsoft Excel. It is one of the best courses on Microsoft Excel and has been refined and perfected to make it easy for learners to grasp with the help of short video lectures.
You will learn how to navigate around Excel, enter and edit data, write formulas, perform calculations using Excel functions, work with charts and graphs, use Excel data tools, use Pivot Tables and Pivot Charts, how to automate tasks with time saving macros and much more.

This Microsoft Excel training uses Excel 2013 for Windows and comes with lifetime access that allows you to review material and continue learning new material. Every video lecture is followed by a quiz that helps you to review and reinforce your learning from the video. You will also get a certificate of Completion at the end of the class.

Key Highlights

  • Perfect for all skill levels from beginner to advanced
  • Presented with high-quality video lectures, that visually demonstrate how to easily do everything in Excel
  • Excel Project Files and Excel Templates are included allowing for enhanced learning through hands-on activities
  • Learn how to find and download free Excel templates that you can use like budget templates or a calendar template or a schedule template
  • Learn tips and tricks about Excel, as well as Excel secrets and shortcuts
  • Learn how to use passwords in Excel to protect your work in multiple scenarios
  • Learn how to integrate Microsoft Excel with Microsoft Word

Duration : 6.5 hours on-demand video
Rating : 4.4

5. Microsoft Excel – Advanced Excel Formulas & Functions (Udemy)

This course is the best advanced Excel training available online with all the advanced Excel formulas and functions that you need to become an Excel Power user. In this course you will be introduced to 75+ of Excel’s most powerful functions using hands-on-demos and crystal clear explanations. The instructor Chris Dutton (who is a Microsoft Certified Excel Expert Instructor with tons of teaching experience) makes you think like Excel rather than just having to memorise formula syntax. He focuses through contextual examples on how to apply those formulas in a number of ways.

The course begins with a quick review of the fundamentals, then dive into each formula category from basic stats functions, conditional statements to more advanced array formulas, named ranges, and data tools like WebService and FilterXML. You will also learn to work with texts, dates, times and arrays and build custom interactive dashboards.

With this bestselling course you get 7 hours of video content, downloadable project files, quizzes and homework assignments and one-on-one instructor support.

Key Highlights

  • Learn to write powerful and dynamic formulas from scratch
  • Master unique tips, tools and case studies that you won’t find in any other course
  • Learn to build dynamic tools & Excel dashboards to filter, display and analyze your data
  • Learn to pull real-time data from APIs directly into Excel (weather, stock quotes, directions, etc.)
  • Understand how to join datasets from multiple sources with Excel’s LOOKUP, INDEX & MATCH functions
  • Learn to automate tedious and time-consuming tasks using cell formulas and functions in Excel

Duration : 7 hours on-demand video
Rating : 4.6

6. Introduction to Data Analysis Using Excel by Rice University (Coursera)

This is an introductory course in the use of Excel and is a part of the Business Statistics and Analysis Specialization by Rice University. It has been designed for two kinds of learners – those who have a basic functional knowledge of Excel and those who use Excel regularly and wish to improve their knowhow. This Excel training consists of 4 modules that progressively take you from learning basic operations (such as reading data into Excel using various data formats, editing and organizing data etc.) to more advanced functionality (such as Pivot Tables, Charts and Graphs etc.).

The instructor Sharad Borle has structured the course very well and uses easy to understand examples that make learners understand everything quickly and be able to apply them in real life scenarios. There are plenty of quizzes and assignments in the course which will require access to Windows Microsoft Excel 2010 or later to complete.

The details of course modules are as follows:
1. Module 1: Introduction to Spreadsheets – Introduction to Excel spreadsheets and basic data functions and formulas
2. Module 2: Spreadsheet Functions to Organize Data – Introduction to Excel functions to organise and query data, like, IF, nested IF, VLOOKUP, HLOOKUP and RANDBETWEEN
3. Module 3: Introduction to Filtering, Pivot Tables, and Charts – Introduction to data filtering capabilities of Excel and Pivot Tables
4. Module 4: Advanced Graphing and Charting – Introduction to advanced graphing and charting techniques available in Excel

Key Highlights

  • Learn to use formulas in Excel using absolute and relative referencing
  • Learn to use Pivot Tables with categorical as well as numerical data
  • Understand various line, bar and pie charts and get to build them on your own
  • Understand Pivot Charts, Scatter Plots and Histograms
  • Prepares learners for more advance topics in Business Statistics

Duration : 4 weeks, 1-2 hours per week
Rating : 4.7

7. Microsoft Excel – Data Analysis with Excel Pivot Tables (Udemy)

This course is a master class in Excel Pivot tables, one of Excel’s most powerful data analysis tools. It is the best course in Excel to take your data analysis skills to the next level. You will learn when, why, and how to use Excel Pivot Tables and Charts. You will learn how to explore and shape raw data and indentify patterns, trends and insights from that data. The course uses sample data from IMDB Movie database to review core Pivot table functionality including sorting, filtering and grouping tools, conditional formatting and calculated values. You will also learn data visualization, how to build interactive dashboards using Pivot Charts, Slicers and Timelines. The course also includes 10 real-world case studies for demonstration.

This Excel course has been developed by Chris Dutton who is a Microsoft Certified, best-selling Excel instructor and teaches the course in a fun, interactive and effective style. It is compatible with Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, or Office 365. It includes Excel project files, 6 downloadable resources, 22 articles, homework assignments and quizzes and lifetime access to course material.

Key Highlights

  • Gain 100% comprehensive understanding of Excel Pivot Tables and Excel Pivot Charts to streamline your workflow in Excel
  • Master unique Pivot Table tips, tools and case studies
  • Learn about Excel Calculated fields, items & values
  • Learn to build Interactive Excel dashboards
  • Test your skills with 10 real-world Pivot Table case studies (weather, shark attacks, wine tastings, burrito ratings, major league baseball, stock market, and more)
  • Interactive, hands-on demos and Excel exercises throughout the course
  • Requires learners to have basic functional experience with Excel

Duration : 6.5 hours on-demand video
Rating : 4.6

8. Data Visualization with Advanced Excel by PwC (Coursera)

This course is part of the Data Analysis and Presentation Skills: the PwC Approach Specialization on Coursera. It is the best course to learn Advanced Excel. It comprises of 4 modules where you will get hands-on instruction of advanced Excel 2013 functions and skills to use PowerPivot for building databases and models. You will learn Excel’s built in tools like Solver, Data Tables, Scenario Manager and Goal Seek. Finally, you will learn about Data Visualization, Graphs & Power View Reports and how to combine them into dynamic dashboards.

The Course modules are:
1. Preparing a Professional excel – Covers data models and databases, PowerPivot tool
2. Advanced Scenario Analysis – Explores different analytical methods and how to use them
3. Data Visualization – Covers elements of data visualization like charts and graphs in details
4. Dashboarding – Details design principles and requirements for building a dashboard

The course is taught by Alex Mannella and contains several graded quizzes and assignments with peer feedback. You will earn an electronic Certificate at the end of the course.

Key Highlights

  • Master Advanced Excel functions
  • Learn 3 different analytical methods – Scenario Analysis, Sensitivity Analysis and Simulation
  • Learn how to create detailed graphs and charts to effectively tell a story about your data
  • Perform different types of scenario and simulation analysis using Excel’s set of built in tools
  • Create your own functional dashboard in Excel

Duration : 4 weeks, 3-4 hours per week
Rating : 4.8

9. Excel Essentials: The Complete Excel Series – Level 1, 2 & 3 (Udemy)

This is a whole Excel Mastery Series combined in one course that takes a learner from being a complete novice to a skilled VBA programmer. It imparts complete and comprehensive understanding of Microsoft Excel in 3 levels where you progressively master all the basics, master the advanced functions of Excel and Master programming Excel using VBA. It covers Excel 2010, Excel 2013 and Excel 2016.

You will cover the following in three levels:
1. Level 1 – Learn Excel basics, entering & editing data, formulas, functions
2. Level 2 – Learn to use Excel like professionals using advanced functions, conditional formatting, custom formatting, calculations with time and dates, macros, creating databases, Gantt charts etc
3. Level 3 – Learn to program in VBA and automate routine tasks like report generation, even automate Outlook, Word & PowerPoint

The course has been designed and is instructed by Alan Jarvis who has been teaching Microsoft Excel for over 20 years. He has created this all-in-one Excel master course for anybody who is a complete beginner, or someone who wants to take their Excel skills a notch higher, or someone who wants to create efficient business solutions using Excel. Upon enrolling for the course, you get access to all the video lectures, articles, quizzes, projects, and 116 downloadable resources for lifetime.

Key Highlights

  • Learn to create a fully functioning relational database using Excel
  • Build Gantt charts in Excel for project planning
  • Understand how to import data from multiple sources
  • Create a simple data entry screen to auto-populate complex templates
  • Build Powerful Advanced Excel Projects & Complex applications from scratch
  • Learn how to fully automate report generation
  • Learn to program simple “helper” solutions
  • Learn through multiple in-depth step-by-step projects
  • Control other Microsoft applications like Outlook, Word, PowerPoint and even Windows itself

Duration : 26.5 hours on-demand video
Rating : 4.6

10. Master Microsoft Excel Macros and Excel VBA (Udemy)

This is a project based course on Excel VBA and Excel Macros. It has been created by Kyle Pew who is a certified Microsoft trainer with decades of experience. He has set up handful of different projects through which he introduces you to how you can learn and excel at Macros and VBA. The course covers key foundational concepts of programming within Excel (like procedures, variables, loops, conditional statements etc), so no prior programming experience is needed. Greater learning is guaranteed with project based scenarios.

The course contains detailed instructions in the form of video lectures and PDF documents that you can reference for lifetime. It is designed for those who use Excel for business and want to automate their daily tasks or build small applications using Excel. The Course Material Works in Microsoft Excel 2007, 2010, 2013 and 2016.

Key Highlights

  • Master the process of automating routine tasks through the use of Excel Macros and Excel VBA
  • Determine when it’s best to use the Macro Recorder versus VBA
  • Learn to apply VBA concepts to real world scenarios
  • Learn how to write custom VBA Macros to create more robust automation
  • Learn to import data from external text files
  • Learn to work with Excel VBA user forms
  • Complete real world Macro/VBA projects from beginning to end

Duration : 5 hours on-demand video
Rating : 4.5

About the author

Study on Scholarship Today -- Check your eligibility for up to 100% scholarship.