Microsoft Excel - Excel Beginner to Pro fast

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.

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.

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 center text across a selection without merging cells using center across selection, and why it avoids the limitations of merge and center.

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

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 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.

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.

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.

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.

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.