Excel Basics
Getting Started with Excel
📘 Lesson - 01Learn your way around the Excel environment and the user interface.
Start Tutorial
Understanding OneDrive
📘 Lesson - 02Learn all about working with your Microsoft account and OneDrive cloud storage.
Start Tutorial
Creating and Opening Workbooks
📘 Lesson - 03Learn how to create and open Excel workbooks efficiently.
Start Tutorial
Saving and Sharing Workbooks
📘 Lesson - 04Learn how to save your progress and collaborate by sharing workbooks.
Start Tutorial
Cell Basics
📘 Lesson - 05Learn to insert, delete, drag, and drop cells, plus copy/paste functions.
Start Tutorial
Modifying Columns, Rows, and Cells
📘 Lesson - 06Learn how to modify the structure of your Excel worksheets.
Start Tutorial
Formatting Cells
📘 Lesson - 07Learn all about formatting text and visual styles in Excel.
Start Tutorial
Understanding Number Formats
📘 Lesson - 08Learn how to display dates, currency, and percentages correctly.
Start Tutorial
Working with Multiple Worksheets
📘 Lesson - 09Learn to add, delete, copy, move, and group multiple sheets.
Start Tutorial
Using Find & Replace
📘 Lesson - 10Learn how to use Excel's search features to find specific data.
Start Tutorial
Checking Spelling
📘 Lesson - 11Learn how to use Excel's spell check feature to avoid errors.
Start Tutorial
Page Layout and Printing
📘 Lesson - 12Control the way your content appears on a printed page.
Start Tutorial
Intro to Formulas
📘 Lesson - 13Learn how to use cell references to create simple math formulas.
Start Tutorial
Creating Complex Formulas
📘 Lesson - 14Master complex calculations and the order of operations.
Start Tutorial
Relative and Absolute References
📘 Lesson - 15Learn the critical difference between relative and absolute cell references.
Start Tutorial
Functions
📘 Lesson - 16Learn how to use functions and arguments to calculate data quickly.
Start Tutorial
Basic Tips for Working with Data
📘 Lesson - 17Organize your data and find exactly what you need with these tips.
Start Tutorial
Freezing Panes and View Options
📘 Lesson - 18Learn how to keep headers visible while scrolling through data.
Start Tutorial
Sorting Data
📘 Lesson - 19Learn how to sort data to better view and organize your spreadsheets.
Start Tutorial
Filtering Data
📘 Lesson - 20Learn how to filter data to display only the information you need.
Start Tutorial
Groups and Subtotals
📘 Lesson - 21Organize data in groups and summarize them using subtotals.
Start Tutorial
Tables
📘 Lesson - 22Learn how to use styles and structured formats for tables in Excel.
Start Tutorial
Charts
📘 Lesson - 23Visualize comparisons in your data by inserting and modifying charts.
Start Tutorial
Conditional Formatting
📘 Lesson - 24Apply rules to format cells automatically based on their content.
Start Tutorial
Comments and Co-authoring
📘 Lesson - 25Learn how to use track changes and comments for collaboration.
Start Tutorial
Inspecting and Protecting Workbooks
📘 Lesson - 26Learn how to inspect for hidden data and protect your work.
Start Tutorial
Intro to PivotTables
📘 Lesson - 27Master one of Excel's most powerful tools for data analysis.
Start Tutorial
Doing More with PivotTables
📘 Lesson - 28Advanced techniques to better summarize and filter PivotTable data.
Start Tutorial
What-if Analysis
📘 Lesson - 29Answer complex scenarios using Excel's what-if analysis tools.
Start Tutorial
What is Office 365?
📘 Lesson - 30Discover the benefits and features of the Office 365 ecosystem.
Start Tutorial
What are Reference Styles?
📘 Lesson - 31Learn about different reference styles like A1 vs R1C1.
Start Tutorial
Office Intelligent Services
📘 Lesson - 32Learn about smart features like data types and researcher tools.
Start Tutorial
Using the Draw Tab
📘 Lesson - 33Learn how to use digital ink and drawing features within Excel.
Start Tutorial
Working with Icons
📘 Lesson - 34Enhance your spreadsheets by adding and customizing SVG icons.
Start Tutorial
Excel Quiz
📝 Final Step - 35Test your knowledge of Excel basics by taking our comprehensive quiz.
Take Quiz
No comments:
Post a Comment