Microsoft Excel Fundamentals: A Beginners Guide

Explore the basics of Excel: quick access toolbar, tabs and ribbon, name box, formula bar, and sheet navigation with zoom and scroll controls.

Learn to create a new Excel file or template, using blank workbooks or built-in templates, and observe a live expense chart. Close the workbook, choosing to save or discard changes.

Learn to customize the Excel ribbon by creating a new tab and groups, renaming them, adding options such as font, font color, and font size, or hiding and removing tabs.

Learn to edit data in Excel using find and replace, modify text and formulas, and undo redo, then navigate with go to and go to special.

master excel formatting by adjusting font styles (bold, italic, underline), alignment, borders, colors, and size; apply wrap text, merge cells, and set numbers, dates, and currency via format cells.

Identify cell data types in Excel, including text, numbers, boolean expressions, and error formulas, and learn how each type aligns (text left, numbers right, booleans and errors center).

Learn to use relative, absolute, and mixed cell references in Excel, create net income formulas, and copy them with drag or Ctrl+Enter while locking references with F4.

Explore speak cells in Excel by adding pixel options to the quick access toolbar, then read text by row or column, or on enter, in horizontal or vertical modes.

Learn to insert, edit, and delete comments in Excel, and to show all comments using the review tab and keyboard shortcuts like shift+f2 and f2.

Explore fill series in Excel, including copying formatting, values, and text, and using options like fill without formatting, fill formatting only, and fill weekdays.

Learn to use Excel's advanced fill to drag numbers with intervals, fill months and days, and create or use custom lists.

Discover how flash fill uses ctrl e to extract digits and letters, train for accuracy, and apply to first four digits, last three digits, and first letters.

Explore how to view a worksheet by hiding and unhiding columns and rows. Use the view tab to freeze panes, unfreeze panes, and split panes for comparison.

Learn to create and use custom views in Excel to quickly hide or show specific columns for different audiences, such as clients and managers.

Learn to compare two sheets side by side in one workbook by opening duplicate windows, viewing side by side, arranging them vertically, and using synchronous scrolling.

Learn how to compare Excel files by viewing them side by side, using view side by side, synchronous scrolling, and tile or cascade layouts to arrange multiple workbooks efficiently.

Explore how to use logical functions in Excel to compare numbers with operators such as equal to, not equal, greater than, and less than in a logical test.

Master the if function to perform a logical test yielding true or false, or 1 or 0, and optionally text such as pass or fail, including nested functions.

Explore how to build a nested if in Microsoft Excel to classify scores as distinction, pass, or fail using a second if inside the first.

Explore how to use the not function to invert booleans and the iferror function to display custom messages for errors, with practical examples and filtering tips.

Learn how to use the logical and function in excel to validate marks between zero and 100, and apply if statements to label results as pass, fail, distinction, or invalid.

Use the date difference function to compute age in years, months, and days by supplying start and end dates. Use 'y', 'm', and 'd' to designate each unit.

Learn to create, rename, and delete named ranges in Excel, and use the name box for quick navigation across worksheets. Explore create from selection and scope to manage ranges.

Learn to create and use name ranges in excel, apply sum, min, max, average, count, counta, count blank, and small and large functions across sheets.

Learn to use ace lookup to retrieve prices from a horizontal table by specifying the row index number, not a column. Apply using lookup value, table array, and row index.

Learn to retrieve a full record with Vlookup using the mass function to get the product code position, lock references with F4, and drag to fill.

Learn to protect an Excel workbook with a password, encrypt the file, and remove the password by using the Info tab and encrypt with password options.

Protect the workbook structure in Excel by using the Protect Workbook option on the Review tab with a password (1234), preventing others from moving, deleting, or renaming sheets.

Learn to create hyperlinks that navigate to other sheets in Excel, linking text from D4 to a target sheet and cell E5 using right-click, Ctrl shortcut, or the Insert tab.

Create a hyperlink in Excel to an existing file using Ctrl+K, attach it to text such as 'click here', and open the linked PDF on desktop or network.

Learn how to create a hyperlink in Excel that opens and updates external documents, using Ctrl+K to link to a text, Word, or Excel file on the desktop.

Sort the data by region or sales rep, use the data tab to apply subtotal with sum, and toggle details to show or hide subtotals, then remove all.