Microsoft Excel is the spreadsheet application in the MS Office suite.
Contact me if you are interested in individual or small group face-to-face training by following the link to my Training Solution page:
Microsoft Excel Basics – Training Solution
Alternatively, you can get help in this free Excel series. Learn how to create formulas and charts with your spreadsheets. Use functions and format cells effectively.
Follow these excellent online tutorials from Learnfree.org® for more guidance.
- 1
- 2
Understanding OneDrive for Excel
Learn all about working with your Microsoft account and OneDrive.
🕑 3 min - 3
- 4
- 5
Cell Basics
Learn how to insert and delete cells and cell content, drag and drop cells, use the fill handle, and use the cut, copy, and paste functions.
🕑 12 min - 6
Modifying Columns, Rows, and Cells in Excel
Learn how to modify rows, columns, and cells in Excel.
🕑 13 min - 7
- 8
- 9
Working with Multiple Worksheets
Learn how to add, delete, copy, and move worksheets, as well as group and ungroup worksheets.
🕑 12 min - 10
Using Find & Replace
Learn how to use Excel’s Find and Replace features to search for specific data.
🕑 8 min - 11
Checking Spelling
Before sharing a workbook, you’ll want to make sure it doesn’t include any spelling errors. Excel includes a spell check tool to make sure everything is spelled correctly.
🕑 4 min - 12
Page Layout and Printing
Learn how to use Excel commands that let you control the way your content will appear on a printed page.
🕑 10 min - 13
- 14
- 15
Relative and Absolute Cell References
Learn all about absolute and relative cell references and how they’re used in Excel.
🕑 10 min - 16
Functions
Learn the different parts of a function and how to create arguments to calculate values and cell references.
🕑 15 min - 17
Basic Tips for Working with Data
Learn these basic tips for working with data to help you organize it and find what you need.
🕑 6 min - 18
Freezing Panes and View Options
Learn how to freeze panes and split your worksheet so you’re only seeing certain parts of your worksheet.
🕑 10 min - 19
Sorting Data
Learn how to sort data to better view and organize the contents of your spreadsheet.
🕑 12 min - 20
Filtering Data
Learn how to filter the data in your worksheet to display only the information you need.
🕑 14 min - 21
Groups and Subtotals
Learn how to organize data in groups, summarize different groups using the Subtotal command, and create an outline for your worksheet.
🕑 12 min - 22
- 23
- 24
Conditional Formatting
Learn how to apply, modify, and delete conditional formatting rules in Excel.
🕑 11 min - 25
Comments and Co-authoring
Learn how to use Excel’s track changes and comments features when proofreading workbooks.
🕑 11 min - 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
Office Intelligent Services for Excel
Learn more about the features available through Intelligent Services.
🕑 4 min - 34
- 35
- 36
Source: Excel: Foundations | LearnFree