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