Microsoft 365 Excel: Part 3
This advanced course covers the full breadth of Microsoft 365 Excel's most powerful features. You will learn how to work in both Excel Online and the Excel desktop application, automate worksheets with macros and templates, audit and error-check your workbooks, analyze and present data with advanced tools, work across multiple workbooks, and export and source data from a variety of formats and platforms—including Microsoft Forms.
What you'll learn
- Access and use Excel Online, manage workbooks in OneDrive, and switch between Excel Online and the Excel desktop application.
- Identify key feature differences between Excel Online and the Excel desktop application.
- View, add, and edit workbook properties and use the Document Inspector to remove sensitive metadata.
- Record, save, inspect, and secure macros using the VBA Editor and macro security settings.
- Create, edit, and use Excel templates to standardize and automate workbook creation.
- Apply data validation settings, input messages, and error alerts to control data entry accuracy.
- Use formula auditing tools—including Show Formulas, Trace Precedents, and Trace Dependents—to understand and verify workbook logic.
- Identify and resolve common formula errors using Error Checking and the Evaluate Formula tool.
- Monitor formula results across worksheets using the Watch Window and Camera tool.
- Organize large data sets using outlines, auto outlines, and the Subtotal command.
- Use the Quick Analysis Tool to rapidly apply formatting, charts, totals, tables, and sparklines.
- Insert and customize Line, Column, and Win/Loss Sparklines to visualize data trends.
- Perform What-If Analysis using Scenario Manager, Goal Seek, and Solver.
- Load and use the Analysis ToolPak to perform advanced statistical and financial analysis.
- Arrange, compare, and synchronously scroll through multiple open workbooks.
- Create and manage external references (links) between workbooks, and resolve broken links.
- Consolidate data from multiple workbooks using the Consolidate dialog box.
- Export workbook data to file formats including CSV, PDF, and others.
- Import delimited files and web data using Get & Transform Data and Power Query.
- Create, share, and manage Microsoft Forms integrated with Excel Online for data collection.
Preview a lesson
What Is Excel Online? Excel Online is a browser-based version of Excel available through your Microsoft 365 subscription. It works on any device with an internet connection—even if that device doesn't have the Excel desktop application installed. Using your Microsoft 365 account and OneDrive, you can store files online, share them, and collaborate with others in real time. Logging Into Microsoft 365 To log in, open your browser and navigate to [https://login.microsoftonline.com](https://login.microsoftonline.com). Enter your email address, click **Next**, then enter your password and click **Sign in**. Once logged in, you'll see the Office landing page. Click the **Excel** app icon—or open an existing Excel file—to launch Excel Online. Opening Files in the Excel Desktop Application When you have a workbook open in Excel Online and need access to advanced features, click **Open in Desktop App** in the ribbon. Excel will open the file on your desktop, and any changes you make are automatically saved back to the online file. When finished, close the desktop app and click **Resume editing here** in your browser to continue in Excel Online. Identifying Where Your Workbook Is Saved In the desktop application, click the **file name** at the top of the workbook window to see the current file name and storage location. From this dialog you can rename the file, move it to a
…Enroll to read the rest and the full curriculum.
Curriculum
Lesson 1: Excel Online
3 lessons- textAccessing and Using Excel OnlinePreview
- textFeatures That Differ Between Excel Online and the Excel Desktop Application
- quizLesson 1 Quiz
Lesson 2: Worksheet Automation
5 lessons- textManaging Workbook Properties
- textWorking with Macros
- textCreating and Using Templates
- textUsing Data Validation in a Workbook
- quizLesson 2 Quiz
Lesson 3: Auditing and Error Checking
5 lessons- textTracing Cells
- textError Checking
- textEvaluating Formulas and Using the Watch Window
- textData List Outlines
- quizLesson 3 Quiz
Lesson 4: Data Analysis and Presentation
5 lessons- textThe Quick Analysis Tool
- textAdding Sparklines
- textWhat-If Analysis
- textThe Analysis ToolPak
- quizLesson 4 Quiz
Lesson 5: Working with Multiple Workbooks
4 lessons- textArranging Workbooks for Viewing
- textLinking to Data in Multiple Workbooks
- textConsolidating Data
- quizLesson 5 Quiz
Lesson 6: Exporting and Sourcing Data
4 lessons- textExporting Data
- textUsing Data Sources
- textUsing Microsoft Forms for Data Collection
- quizLesson 6 Quiz