Microsoft Excel Course

Navigate Excel through the file tab and ribbons; learn save and save as, password protect, export to PDF, and explore Home, Insert, Page Layout, Formulas, Data, and View tabs.

Master data entry in Excel by learning how to enter and edit data in cells, navigate with tab or arrows, wrap text, and use undo, redo, copy, cut, and paste.

Explore how to format text in Excel by adjusting fonts, sizes, colors, borders, alignment, and cell merging to create polished tables.

Insert rows and columns, add serial numbers, and use auto fill to create patterns; format as currency or percent for salary data; apply simple formulas to compute new salaries.

Learn to sort data in ascending or descending order and filter records in Excel using header arrows, sorting by student number, name, phone number, or salary, and extracting targeted records.

Explore data validation and error checking in Excel, using whole numbers, text length, between rules, and custom formulas to validate emails and dates of birth within a template.

Learn to use data validation in Excel to enforce valid emails, customize input messages and error alerts, and guide users with clear explanations when errors occur.

Explore basic formulas and functions in Microsoft Excel, perform addition, subtraction, multiplication, and division using cell references, and apply the sum function for quick range calculations.

Explore building a student score sheet in Excel using sum, max, min, and average. Drag formulas across rows to compute totals, highest, lowest, and average scores for each subject.

Learn how the if function tests a logical condition and returns true or false. Apply it to determine student status as pass or fail when scores above 200.

Learn how to insert tables in Excel by selecting a range, using insert table, confirming headers, and using table styles, sort, and filter features for a presentable, searchable scoresheet.

Explore Excel's rich library of functions and formulas, from Autosum and count to text functions like concatenate and lower, and learn how to apply them in cells.

Explore text functions in Excel, including the proper function to capitalize words, the upper function to convert to uppercase, and the trim function to remove extra spaces.

Explore the find and replace text functions in Excel, learning how to locate text, obtain character positions, use a start number and a case-insensitive search, and replace characters.

Learn to insert and customize charts in Excel using the insert tab, select data ranges with ctrl, and visualize scores and percentages with pie, bar, and other chart types.

Explore how to create a combo chart in Excel to compare mathematics and science scores for students, then customize designs and insert the chart into Word or PowerPoint.

Explore pivot tables and pivot charts to analyze table data in a flexible way, filtering by regions and summing quantities by product and sales method.

Insert pivot charts from your data and place them on a worksheet. Drag fields such as region, product, and sales method to update the chart with filters like date.

Use vlookup to search a table for a product, retrieve its price, and create dynamic, exact-match lookups with a drop-down validation in Excel.

learn how to use hlookup as the horizontal counterpart to vlookup, performing exact-match lookups by specifying the table array and the row index.

Identify common Excel errors—ref, value, name, div zero, and hash errors—and apply fixes, such as correcting references, data types, and using if error to return an empty string.

Explore conditional formatting and data visualization in Excel, using the randbetween function to generate dummy sales data, and apply rules, top/bottom, above average, and data bars to reveal trends.

Apply icon sets in Excel to a table using numeric rules, with green above 9000, yellow 2000–9000, and red below 2000, and learn to manage and edit these rules.

Create a dynamic project tracker in Excel that uses an IF statement to show completed or in progress and uses conditional formatting with data bars to visualize progress.

Learn how to protect and unprotect a worksheet in Excel, set passwords, and customize permissions to insert or delete rows or columns, and protect the workbook.

Discover how to lock and unlock cells in Microsoft Excel, protect a worksheet with a password, and keep formulas safe while allowing edits only in designated ranges.

Explore how to import and export data in Microsoft Excel, using text files and other sources, with the text import wizard, delimiters, data formatting and validations, and exporting to text.

Learn to automate repetitive tasks in Excel by recording and running macros, enabling the Developer tab, and generating reports and charts within a workbook.

Learn to collaborate in real-time by sharing Excel workbooks online with Google Sheets, inviting teammates as editors, viewers, or commenters, and managing access across devices.

Learn to use Excel shortcut keys to work faster, including creating new workbooks with Ctrl N, opening with Ctrl O, and editing with copy, paste, and format shortcuts.

Learn to extract text in Excel using the Ctrl e shortcut to split a list into first and last names. This lesson demonstrates practical steps for pulling information from text.

Learn to split a single cell (B2) into multiple fields in Excel using the text split function, specifying the comma delimiter, then copy results for many records.

Discover a quick Excel trick to generate days 1 through 365 using the sequence function, specifying 365 rows in column a and then populate all days.