Guides: Excel for Business Guide: Learn at your pace

Search the Business FAQ

Looking to expand your Excel skills? Whether you're just starting out or a seasoned user, these resources will strengthen your Excel proficiency. See our resources for beginners or resources for intermediate users.

Check out these written resources to get you started on 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.

See these resources for guided instruction on starting out with Excel.

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.

See these resources to learn how to use 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.

Explore these resources to learn about using Excel for business analysis, 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.
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.

He/Him/His

Email Me

Subjects: Statistics