Guides: Excel for Business Guide: Learn at your pace

Search the Business FAQ

Quick start

Introductions for beginners

More introductions to Excel

Next-level techniques

More next-level Excel training

Introductions for beginners

Video courses
Text guides and books

Videos and courses to get you started:

LinkedIn Learning - Excel Essential Training
Get up to speed with Microsoft Excel, the world's most popular spreadsheet program. Follow along with Excel expert Dennis Taylor as he demonstrates how to efficiently manage and analyze data with this powerful program.
O'Reilly for Higher Education - The Complete Excel Guide
Everyone knows that the Microsoft Office suite is used by millions worldwide. Unlocking its full potential and learning it thoroughly will improve your productivity drastically. This course will help you grasp all the essential and advanced skills for Microsoft Excel 2019 with the help of interesting activities.
Microsoft Excel Video Training
A library of training guides and videos created by Microsoft.
YouTube - Excel Introduction
Excel Basics playlist includes Excel tutorials for those who're new to Excel and also for anyone who's used Excel for a while but has missed out on some of these techniques. The playlist includes, IF, VLOOKUP, changing the Default Excel theme and some formula tricks.

Written resources to get you started:

Excel Easy
A free, online guide to using Excel.

Excel Workbook for Dummies by Paul McFedries; Greg Harvey
ISBN: 1119832179
Publication Date: 2021-12-13
Get practical walkthroughs for the most useful Excel features.
Excel Formulas and Functions for Dummies by Ken Bluttman
ISBN: 1119839130
Publication Date: 2021-11-16
Unlock the power of Excel with a step-by-step roadmap to its formulas and functions.
Excel 2019 Bible by Michael Alexander; Richard Kusleika; John Walkenbach
ISBN: 1119514762
Publication Date: 2018-09-25
Whether you use Excel at work or at home, you will be guided through the powerful new features and capabilities to take full advantage of what the updated version offers.

Learn to handle pivot tables, advanced formulas such as VLOOKUP or HLOOKUP, and data visualizations:

LinkedIn Learning - VLOOKUP and XLOOKUP for Beginners
In this mini-course, Jess Stratton walks you step-by-step through creating a simple lookup in Excel using both VLOOKUP and XLOOKUP, then shows you how to error-proof your formulas.
YouTube - Excel Lookup Formulas
Excel has many great lookup formulas - such as VLOOKUP, INDEX MATCH and now the new Excel XLOOKUP function. This playlist will give you many ideas and formula combinations so you can use the best lookup formula for your task.
LinkedIn Learning - Pivot Tables for Beginners
In this concise course, Excel trainer Dave Ludwig demystifies PivotTables and shows you how to get started using them to analyze your data.
O'Reilly for Higher Education - A Beginner's Guide to Pivot Tables in Excel
This course will discuss the importance of cleaning your data before creating your first Pivot Table. You’ll also learn how to create Pivot Charts and how to format your Pivot Tables and Charts. This course includes downloadable Excel data files that the instructor uses in the guide to follow along.
YouTube - Excel Pivot Tables
Learn how to use Excel Pivot Tables, from beginner to advanced, with this YouTube playlist.
YouTube - Excel Charts
Learn about charting in Excel including bar charts, line graphs, pie charts, and histograms.
YouTube - Excel Intermediate Functions and Features
Watch this YouTube playlist to learn about intermediate Excel formulas.

Learn to use Excel for business analytics, financial planning, and accounting:

Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365), 7th Edition
Master business modeling and analysis techniques with Microsoft Excel and Office 365 and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide helps you use Excel to ask the right questions and get accurate, actionable answers.
YouTube - Excel for Business and Finance
Watch this YouTube playlist to learn how to use Excel for financial modeling.
DataQuest - Introduction to Data Analysis with Excel
Free with Penn registration. Self-paced online learning platform with interactive courses.
LinkedIn Learning - Excel for Business Analysts
In this course, Professor Michael McDonald walks you through everything you need to know to start implementing business analytics skills and concepts.
LinkedIn Learning - Excel for Accounting
In this course, Steve Friedman, the founder and Chief Instructor of Rockstar Excel, teaches you skills to ensure you can confidently leverage Excel in your role as an accountant.
LinkedIn Learning - Excel for Financial Planning and Analysis
In this course, join instructor, CSP, and CPA Carl Seidman as he provides a comprehensive overview of how to harness the power of Excel for forecasting, planning, analysis, and modeling. Along the way, find out why Excel can be so useful for FP&A, including coverage of how to leverage key analytic tools such as dynamic data tables, dynamic data ranges, dynamic data arrays, and more.
API/Excel - Bloomberg Help Guide
Read through this guide to understand how to use the Bloomberg Add-In for Excel.

Business & Data Analysis Librarian

Kevin Thomas

He/Him/His

Email Me

Subjects: Statistics

Excel for Business Guide

Search the Business FAQ

Quick start

Introductions for beginners

Next-level techniques

Introductions for beginners

Next-level techniques

Business & Data Analysis Librarian

Chat