Excel Essentials: Master the Fundamentals

discover the difference between count and counta in excel, where count counts only numbers and counta handles both numbers and text, demonstrated with numeric and text columns.

Explore how to use the sum and subtotal functions in Excel, compare their behavior with and without filters, and compute sums for visible data.

Learn to create a full name by joining first and last names in Excel, using the concatenate formula and the ampersand operator, with a space between names.

Master paste special value in Excel to paste only the final result, removing formulas, using Ctrl+C, Alt E S V, or the right-click paste special value option.

Learn how to use the Vlookup vertical lookup to extract data from a table based on a lookup value, with four arguments, exact match, and left-to-right table rules.

Master the if function in Excel, its three arguments and logical test with true/false outcomes, and apply it to award a 10% bonus when sales exceed 5000.

Learn to use text to column in data tools to split a full name into first and last names, using space as a delimiter and a separate destination cell.

Learn how flash fill uses pattern-based extraction to split full names into first and last names, using Ctrl+E and optional case changes for unstructured data preparation.

Explore data validation in Excel to enforce specific values with a drop-down list, ensuring clean data by selecting the range and applying a list of morning and evening.

Learn to create a data validation list from an Excel range using the ldl shortcut, connect it to a range (J1–J5), and manage hiding the source.

Discover how to protect an Excel sheet to prevent edits while sharing data for viewing, using the review tab and optional password, and how to unprotect with shortcuts.

Create sheet hyperlinks in excel to jump from summary sheet to Jan, Feb, and March sheets, using Ctrl K and place in this document, then add back links with shapes.

learn to create a pivot table from a clean data set using the insert tab or alt d p, and analyze total sales by city and gender with drag-and-drop fields.

Learn pivot table structure with filter, row, column, value. Move fields to row for vertical data, to column for horizontal data; count text, sum numeric.

Create and configure a pivot table to summarize data by moving fields to rows, columns, and values, and interpret counts, sums, and averages across gender and city.

Learn to analyze sales by role with pivot tables: show contribution as a percentage of grand total, switch between sum and average, and enhance readability with design options.