Microsoft Excel–Beginner to Advanced | Formulas | Dashboards

Explore functions in Excel, the formula library that saves time and enables complex calculations. Learn direct entry, insert function, argument structure, and keyboard shortcuts like Autosum to master data analysis.

Explore the sum function in Excel, including how to insert it, define ranges (vertical, horizontal, rectangular), and use shortcuts like Alt+= and Autosum to sum values quickly.

Master copying formulas in Excel with right-click, ribbon, and keyboard shortcuts, including paste special, fill down with Ctrl+D, and drag-fill for large data sets.

Master count, average, min, max, and round in Excel with step-by-step guidance on Autosum, selecting ranges (D4:D13, E4:E13, F4:F13), and rounding values for precise reports.

Learn how named ranges in Excel assign meaningful names to cells, improving readability and simplifying formulas. Define ranges like first names, last names, and Q1 sales, then use total sales.

Excel shortcut keys boost productivity and efficiency by letting you perform tasks quickly without menus or a mouse, especially on repetitive tasks and large data sets.

Master font formatting in Excel by selecting fonts and adjusting size, applying bold, italic, and underline, choosing color, and using advanced options like strikethrough, superscript, and subscript.

Master horizontal and vertical alignment, wrap text, and center across selection to create clear, professional spreadsheets. Use merge and center, unmerge, and center across selection.

Master border formatting in Excel by selecting ranges, applying predefined or custom borders, drawing grids, erasing borders, and using the Format Cells border tab to tailor color and style.

Master number formatting in Excel by applying accounting, currency, percentages, and standard number formats; use the Home tab, Number group, and ctrl+1 for customization via the format cells dialog box.

Master Excel conditional formatting to automatically highlight values with colors, data bars, and icons, create heat maps, and customize rules from the ribbon for dynamic spreadsheets.

Master conditional formatting in Excel with formulas and rules to highlight data by custom conditions across ranges, including highlights for car makes, models, and gradients.

Learn to insert pictures from device, stock images, or online pictures, shapes, icons, and 3D models, resize and crop, add text, apply formatting, and manage alignment and layering.

Explore excel's page layout tab to adjust margins, orientation, paper size, print area, page breaks, and print titles for precise printing.

Master headers and footers in Excel to display page numbers, dates, times, file paths, and sheet names for professional printouts; access them via insert tab or page layout view.

Explore Excel printing settings to tailor worksheets on paper, covering printer selection, copies, PDF or fax options, page range, orientation, paper size, margins, scaling, and headers and footers.

Sort data in Excel by values, colors, and custom lists, then apply multi-level sorting using the data tab and sort dialog to organize records efficiently.

Learn to apply Excel filters to display laptop sales, high-value transactions over 1000, and East region orders. Filter by date ranges and color to highlight urgent tasks.

Learn how to create and use Excel tables to transform data into a structured, filterable, and analyzable set with automatic formatting, formulas, total row, slicers, and conversion back to ranges.

Split one column into multiple columns using the text to columns wizard, choosing delimited or fixed width, setting delimiters like comma or space, previewing results, and selecting a destination.

Use Flash Fill in Excel to automatically complete patterns, such as splitting names into first and last columns, or forming emails by combining names, via the data tab.

Master Excel data validation to ensure data consistency, using whole numbers, decimals, dates, and custom rules, with dropdown lists, error alerts, dependent dropdowns, and multi-sheet validation.

Explore how to group and outline in Excel to collapse and expand rows or columns, hide or show details, auto outline subtotals, and keep large sheets suitable for financial reports.

Master freeze panes in Excel to keep headers and key columns visible while scrolling large data sets, with options for the top row, first column, or both.

Discover how relative and absolute referencing in Excel works when copying formulas. Use dollar signs to fix cells like the tax rate in G2 for accurate formulas.

Master VLOOKUP in Excel to search the first column of a table and return related data from another column, using exact match and absolute references.

Index and match combine to create a flexible alternative to vlookup, enabling horizontal and vertical lookups and leftward searches, even when columns move, with accuracy for dynamic data.

Explore how the if function in Excel evaluates a condition, returning a bonus if sales exceed 1500 and no bonus otherwise, with a step-by-step formula and autofill.

Combine the if function with or to grant bonuses based on sales greater than 1500 or two years of service, then apply the formula to all employees.

Use the if with and logic in Excel to determine pass status: attendance at least 75% and exam score at least 50. Drag the formula down to all students.

Master nested if logic in Excel to assign grades: a for 80 marks and above, b 70–79, c 60–69, d 50–59, f below 50; apply to all students.

Learn to use countif and countifs to count data that meet conditions, with examples like scores above 80 and orders from New York, plus wildcards for partial text.

Learn to sum sales by region and product using sumif and sumifs, apply wildcards for partial matches, and practice building conditional totals in Excel.

Master the Len function to count characters, including spaces and punctuation, and handle empty cells. Combine Len with left, if, and substitute for data cleaning in Excel.

Master extracting text in Excel with right, left, and mid functions to clean and organize data. Use left for initials, right for code digits, and mid to pull email domains.

Learn to use the search function in Excel to find the position of a word within text and filter customer feedback for refunds.

Explore division by zero, value, and name errors in Excel and how they arise. Learn fixes like correcting the denominator, using iferror, and data validation to prevent future issues.

Identify ref errors from deleted rows, columns, or sheets and fix by updating formulas. Explain na and num errors with match and iferror to display not found messages.

Create charts in Excel to visualize your data clearly and effectively. Customize design, axis titles, and chart types to tell the story of your data.

Learn to create and customize column charts in Excel, labeling axes for months and sales, adding data labels, and choosing styles and layouts for a clear data story.

Explore how bar charts and pie charts in Excel reveal insights by comparing many categories, including long category names, and showing parts of a whole from rankings to proportions.

Create composite charts in Excel by turning a simple column chart into a combo chart with sales and profit data, then add data labels and format axes.

Power Query connects Excel to multiple external data sources with point-and-click relationships. It creates a dynamic data model, enables live connections, and automates data import without coding.

Consolidate three identical Excel tables into one with Power Query, using a blank query and Excel.CurrentWorkbook(), then load as a static copy and set dates to short date.

Master Power Query in Excel to connect, transform, and combine data from multiple sources, clean and consolidate into a master table, add custom columns, and refresh automatically for analysis.

Explore pivot tables in Excel to quickly summarize, analyze, and visualize data, then create a pivot table from a data range and add a pivot chart.

Master setting up pivot tables in Excel: select data and insert a pivot table, assign fields to rows and values, filter by department, and manually refresh or delete as needed.

Learn to customize pivot table field settings in Excel, switching between sum and count, display values as percentages, apply number formats, refresh data, and configure subtotals and styles.

Explore calculated fields in a pivot table to create custom metrics like quantity × 120% within the values area, noting you cannot reference outside data or use Excel functions.

Explore grouping in pivot tables to summarize data by date ranges and numeric intervals, using group selection to apply days, months, quarters, years, and custom starting points and intervals.

Enhance pivot tables with slicers and timelines for interactive filtering and enhanced data visualization, including grouping dates by months and quarters.

Build interactive Excel dashboards with pivot tables and pivot charts, synchronized via slicers for quick, compelling insights from large datasets; learn limitations and fast setup in 15–30 minutes.

Create an interactive Excel dashboard using pivot charts and pivot tables, with slicers and a timeline, linked report connections, and drill-down details.