Microsoft Excel - Excel Beginner to Pro fast

Explore the Excel go to special function to quickly select cells by type, such as formulas and constants. See how data validation and conditional formatting highlight values and adjust prices.

Learn to convert text or csv data into a clean Excel table using text to columns, choosing delimited or fixed, and applying comma delimiter and header names.

Explore how to customize headers and footers in Excel using the page layout view, including adding header text, page numbers, current date and time, and file path or name.

Create drop-down menus in Excel using data validation to let users choose from predefined options, like 5%, 10%, 15%, or 25%, and see calculations update in real time.

Use autofill to generate date-derived values and flash fill to extract usernames or IDs from emails, enabling fast, pattern-based data entry.

Learn essential Excel shortcuts to speed data work: apply filters with keyboard, copy-paste values, use alt-key commands for formatting, create pivot tables, and format as tables.

Compare data across two workbooks with synchronous scrolling using the view side by side feature, enabling horizontal and vertical synchronized scrolling for analysis.

Explore using named ranges and table references to write readable Excel formulas, create a holiday lookup table, and automatically populate holidays as new entries are added.

Discover multilevel row and multilevel column sorting in Excel, using the data option to add levels and sort by country, then province, then points, with ascending or descending options.

Explore advanced filter criteria in Excel by using a criteria range to filter data by text that starts with a term and by numeric thresholds, across multiple columns.

Master essential Excel formatting shortcuts using the control keys to quickly apply date, number, currency, and percentage formats, set two decimal places, and revert changes to boost productivity.

Master spell checking in Excel using the review spell check and autocorrect option to identify, correct, or ignore misspellings, and manage dictionary terms and language settings.

Learn how to use snap to grid in Excel to align charts and shapes to the cell grid or to other objects, ensuring consistent layout and visuals.

Apply color-coding and borders to differentiate sections in Excel, remove gridlines, and use shading and thicker borders to highlight critical data for clear, professional worksheets.

Learn how to center text across a selection without merging cells using center across selection, and why it avoids the limitations of merge and center.

Learn to format zip codes and phone numbers in Excel using format cells, special, and locale options to preserve leading zeros and apply country-specific patterns.

Explore relative references in Excel by calculating profit as cell differences from cost and automatically applying the formula across columns with drag fill.

Explore grouping worksheet columns and rows in Excel to create high-level summaries that hide or reveal detail with collapse and expand controls, without deleting data.

Learn to handle Excel calculation errors using the iferror function, replacing divide by zero and other hash errors with dash or zero, and apply across formulas like averages and percentages.

apply custom number formats in excel to display currency with symbols, use million or thousand suffixes, color-code positives and negatives, and reuse formats across sheets.

Learn to switch between automatic and manual calculation modes in Excel via calculation options in formula menu. Discover when manual mode boosts performance on large data sets, while automatic recalculates.

Learn to add line breaks in Excel formulas to improve readability in the formula bar, using plus enter to separate conditions and make complex calculations clearer and more user friendly.

Learn how to use Excel's convert function to quickly switch between units, such as Fahrenheit to Celsius, meters to centimeters, and grams to pounds, without a calculator.

Explore Excel formula auditing tools to trace precedence and dependencies, evaluate formulas step by step, and diagnose errors such as hash values, enabling precise corrections.

Learn to design pivot-style reports in Excel using formulas alongside pivot tables, building count, sum, and average calculations with multiple criteria for clean dashboards and unstructured data.

Learn to count words in Excel using LEN and SUBSTITUTE by removing extra spaces, measuring string lengths, and calculating words per cell for quick text analytics.

Replace vlookups with index and match for two-way lookups across many columns. Fetch city, state, and country with a single index-match formula from a reference table.

Learn how to handle many-to-many lookups in Excel by using index and match to fetch the correct related value, and count duplicates to identify and return the correct instance.

Explore Excel's advanced functions and practical formula building, including sum and nested if statements, with ranges, referencing other sheets, and error handling.

Explore how to access and use Excel formulas from the functions library, including categories like financial, logical, text, date/time, and statistics, and learn to calculate standard deviation with proper syntax.

Learn to build a goal progress gauge in Excel using a donut chart, with data setup, formulas, data labels, and formatting to show progress toward targets.

Boost Excel interactivity by using form controls like a list box to drive averages and charts. Learn to link input ranges with vlookup for dynamic calculations based on selections.

Explore working with tables in Excel, using built-in features to analyze data, and show how table-driven insights help businesses make informed decisions.

Customize the pivot table field list by filtering, sorting, and dragging fields to rows and columns, with stacked or side-by-side layouts and show/hide options; move across worksheets.

Learn how to autofit column width in pivot tables by using the layout and format tab in pivot table options to display data neatly and improve readability.

Learn how to use pivot table views and report layouts to filter country and province data, switch between compact, outline, and tabular formats, and show totals.

Count non-numerical fields in pivots in Excel by using the count function to tally text values, and learn to display these text counts in the values area.

Group numeric values in pivot tables by creating custom buckets, such as 0–99 and 100–199, to reveal product counts per price range and support histogram-like distributions.

Explore value calculations in pivot tables, including percent of grand total, percent of column or row total, running total, differences, and ranking to analyze data quickly.

Learn to add slicers and timelines in Excel, connect them to pivot tables and charts, and control single or multi-select filters for interactive data exploration.

Explore advanced pivot table conditional formatting with color scales and data bars, applying rules to highlight average price and rating across countries and products.

delete and revive pivot table source data in Excel to improve performance by managing cached file data; learn to use show details and recover original data when needed.

Explore advanced analytics, data cubes modeling, and powerful visualizations to deepen data analysis and build robust analytics applications.

Use Excel's goal seek to find the quantity needed to reach a target profit by adjusting the input in the profit formula, considering unit price, unit cost, and fixed cost.

Using Excel's basic forecast tool, extract and index historical data, and generate a forecast sheet with a line chart, forecast statistics, and upper and lower bounds.

Load data from a CSV file using Power Query, transform and clean it in the editor, and load the result into Excel as a table from multiple sources.