Microsoft Excel

Make sense of your data with the power of spreadsheets. Excel is easily the most widely used industrial-strength spreadsheet application, and it's useful in just about any career path that involves working in an office. The resources listed here will help you learn the fundamentals of Excel as well as more advanced topics such as pivot tables, lookups, formulas, macros, special formatting, remote data sources, and more.

How to Learn Microsoft Excel

Microsoft Excel is a spreadsheet application that is part of the Microsoft Office suite of productivity software. Excel allows users to input, calculate, and graphical data in a grid format. The software also features extensive formulas and functions for data analysis, as well as macros for automating repetitive tasks.

There are a few basics that every Excel user should know. First, Excel uses a grid system to organize data. This grid is made up of rows and columns, and each cell can contain a specific piece of information. You can navigate around the grid using the arrow keys on your keyboard.

Excel also has a number of built-in functions that can be used to perform calculations on your data. These functions can be accessed by clicking on the "Formulas" tab at the top of the Excel window.

If you're new to Excel, there are a number of ways to get started. You can find plenty of tutorials and how-to guides online. You can also purchase books or attend training courses. Once you have a basic understanding of how Excel works, you'll be able to use it to your advantage in both personal and professional settings.

Microsoft Excel Resources

Microsoft Excel - Pivot Tables

Microsoft Excel - Pivot Tables

Learn Pivot Tables through Excel video tutorials from award-winning Microsoft MVP Ken Puls with this personalized online course.

Microsoft Excel - Básico y Avanzado

Microsoft Excel - Básico y Avanzado

¿Estás listo para aprender a usar Excel? Conviértase en un ninja certificado de Excel hoy mismo con nuestro curso en línea de Excel.

Microsoft Excel for Mac - Basic

Microsoft Excel for Mac - Basic

Learn the basics of Excel for Mac through HD video tutorials from award-winning Microsoft MVP Ken Puls with this personalized online course.

Microsoft Excel for Mac - Advanced

Microsoft Excel for Mac - Advanced

Learn Advanced Excel for Mac through HD video tutorials from award-winning Microsoft MVP Ken Puls with this personalized online course.

Microsoft Excel 365 - Advanced

Microsoft Excel 365 - Advanced

Learn advanced Excel techniques through online, bite-sized lessons from award-winning Microsoft MVP Ken Puls.

Microsoft Excel 2019 - Basic

Microsoft Excel 2019 - Basic

Learn the basics of Excel through HD video tutorials from award-winning Microsoft MVP Ken Puls with this personalized online course.

The 5-Day Excel Challenge

The 5-Day Excel Challenge

Take this fun and fast 5-day Excel challenge to test and build your Excel skills. The challenges are based on the questions that Excel expert Dennis Taylor encounters most often, and they grow progressively harder each day. For every challenge, Denni...

MrExcel.com

MrExcel.com

A resource collection and online community dedicated to Excel since 1998, the MrExcel.com community answers 30,000 Excel-related questions per year on their message boards, and offers seminars and consulting as well....

Excel 2016 Tutorial

Excel 2016 Tutorial

Microsoft Excel 2016 is the spreadsheet application in the MS Office 2016 suite. Get help organizing and calculating data in this Excel 2016 tutorial. Excel 2016 Basics 1 Getting Started with Excel 2 Understanding OneDrive 3 Creating and Opening W...

PRDV004: Spreadsheets

PRDV004: Spreadsheets

This course will provide you with a comprehensive introduction to spreadsheets. The course is designed for first-time users with very little or no exposure to the subject. For this course, you will use Microsoft Excel as the software. The course will...

Mastering Data Analysis in Excel

Mastering Data Analysis in Excel

In business, data and algorithms create economic value when they reduce uncertainty about financially important outcomes. This course teaches the concepts and mathematical methods behind the most powerful and universal metrics used by Data Scientists...

Microsoft Excel - Power Query

Microsoft Excel - Power Query

A beginner’s Power Query online course - learn how to get and transform your data in Excel with award-winning instructor Ken Puls.