Microsoft Excel Tutorials & Training Resources
Learning Microsoft Excel can be perfect for organizing business data as well as keeping track of different types of records. This computer program can be a powerful tool, but it can also be daunting for beginners to pick up. However, with the use of a few helpful resources, anyone can begin getting the most out of this common business tool.
- Excel 2016/2019 – Level 1
- Excel 2016/2019 – Level 2
- Excel 2016/2019 – Level 3
- Excel 2013/2016 – Data Analysis with PivotTables
- Excel 2013/2016 – Dashboards
- Excel 2013/2016 – VBA Programming
Tutorial: This guide provides basic training for people who are starting from scratch with Excel.
Tutorial: Excel’s major function is to organize data by using a workbook system. If you’re using multiple workbooks at the same time, learning how to open many of them without losing your data is essential. This article gives you the basics of what you need to know.
Tutorial: Entering data into Excel can be a bit more complicated than it may seem. Read this article to learn how to enter data the right way.
Tutorial: Using columns, you can easily adjust different data in your workbook.
Tutorial: There are many reasons you may want to print your spreadsheets, but this format doesn’t automatically lend itself to easy printing.
Tutorial: One of the best features of Excel is the ability to calculate data without having to enter all of your numbers into a calculator. Here is a breakdown of how to enter data to take advantage of these functions, including images and examples for reference.
Tutorial: Excel automatically adjusts your cell references when you’re copying specific formulas from one location to the other. However, if this is something you didn’t want, then it’s easily preventable with this simple technique.
Tutorial: Beyond formulas and basic data entry, Excel has multiple functions you can use to make life much easier when collecting and interpreting data. This article provides 16 different functions that can assist you in performing some of the most tedious tasks on the computer.
Tutorial: Selecting specific cells can be tedious if you don’t know how to do so in an efficient manner. At different points, you may want to select multiple cells that aren’t aligned on the spreadsheet. Reading this article will help you avoid the difficulties you may encounter when selecting and deselecting cells.
Tutorial: Read here to find out about how to use custom views and switch between whichever ones you choose.
Tutorial: Saving your spreadsheets as a workspace is a great way to organize all of your data and ensure a stress-free experience. Learn how to arrange your workspaces to your liking and stay organized with this article.
Tutorial: If you need to delete or rename worksheets in Excel, there are shortcuts you can use to do so quickly and simply. This article gives a detailed overview of how to create, delete, and rename your worksheets.
Tutorial: This is a PDF that goes into great detail on how to work with multiple files at a time; it’s a long read that gives an in-depth explanation of how to keep everything orderly.
How to Make Bulleted Lists (video)
Tutorial: Making bulleted lists in Excel workbooks isn’t always intuitive, but watching this video should help clear things up a bit.
Tutorial: When creating your lists, keeping them organized and detailed can save a lot of time. Using AutoFilter organizes specifics in each category on your list so you can cross-reference as needed.
Tutorial: Excel has a function that allows you to calculate a subtotal of your numbers. This article gives insight on how to calculate grand totals the smart way.
Tutorial: Formulas are powerful tools for getting things done more quickly and easily in Excel, and this document provides a list of some of the most common ones you can use and how they work.
Tutorial: In this article, you’ll learn how to create, modify, and delete data using Excel.
Tutorial: If your work is private and valuable, you’re going to want to know how to secure it and grant permission to whoever may need to access the data. Read about how to create a password and ensure the safety of your information here.
Tutorial: This article simplifies how to share your workbooks in Excel. Overall, learning how to share your workbooks is fairly easy.
Tutorial: Authenticating your documents in Excel can be done by adding a digital signature. Here is an explanation of the right way to add your signature in order to ensure the authenticity of your data.
Tutorial: Adding protection to your data can prevent unauthorized users from manipulating it without your permission. This article explains how to protect your data by setting up a password.
Tutorial: Learning how to use comments in your work can make communicating with others easier because you can document your thought process for reference. Here is a detailed explanation of how to do so.
Microsoft Excel Classes:
|Excel 2013/2010 – Advanced||1 days|
|Excel 2013/2010 – Basic||1 days|
|Excel 2013/2010 – Intermediate||1 days|
|Excel 2013/2016 – Dashboards||1 days|
|Excel 2013/2016 – Data Analysis with PivotTables||0.5 days|
|Excel 2013/2016: VBA Programming||3 days|
|Excel 2016/2019 – Level 1||1 days|
|Excel 2016/2019 – Level 2||1 days|
|Excel 2016/2019 – Level 3||1 days|