Microsoft Excel - Basic to Advance Level

Learn to apply font formatting in Excel using the Home tab font group: bold, italic, underline, double underline, and font size and family, via mouse or shortcuts.

Learn to change the background color and text color in Excel, applying colors to single or multiple cells via the color dropdown, including default colors, more colors, and custom mixes.

Learn how to format borders in Excel, including underline, box borders, outside and double borders, and using draw borders, with results visible in print preview.

Learn how to align cell content in Excel, selecting top, middle, or bottom vertical alignment, and rotate text at various angles, including 90-degree and 360-degree options.

Learn to wrap text within a single cell, merge selected cells into one, and center content, while exploring alignment, borders, fill and font colors, and sheet protection.

Master formatting numbers in Excel by choosing formats such as general, currency, accounting, date, time, and percentage, and apply symbols for different currencies.

Insert pictures into an Excel sheet from device or online sources, then adjust and arrange them to avoid overlap by using sizing properties and move-and-size-with-cells options.

master inserting and editing shapes in Excel, using the insert tab to draw, resize, rotate, apply fill and outline colors, add effects like 3D, shadow, and reflection, then enter text.

Learn to format Excel shapes using SmartArt, insert illustrations, and create hierarchical layouts. Change text, colors, and 3D effects to design visually engaging diagrams for presentations.

Create and customize an excel column chart for revenue and profit analysis across three years by selecting data and inserting a chart. Explore types, axis titles, data tables, and legends.

Master designing and formatting charts in Excel from the chart ribbon, adjusting colors, styles, data labels, and legends while switching rows and columns to tailor your data visuals.

Explore line, area, bar, pie, and scatter charts to visualize sales and profits. Learn to insert charts, add data labels, analyze trends, and present clear insights to management.

Explore sparklines in Excel to summarize data with line and column charts, applying styles, colors, and formats for quick, compact visual insights of profit and sales.

Learn to print Excel documents using print preview, selecting printers, and configuring copies, one-sided or double-sided printing, collated options, margins, and scaling for accurate page layout.

Adjust margins, orientation, and scaling in Excel print preview to control how data appears on the page. Choose portrait or landscape, apply custom margins, and fit data to one page.

Learn how to insert headers and footers in Excel, customize with page numbers and the sheet name, preview prints, and insert a background picture or logo to enhance presentations.

Learn to print a chosen portion of an Excel sheet by setting the print area, previewing only that region, and printing without changing the original data.

Discover the function library in the formula tab, including recently used formulas, financial formulas, logical functions, and lookups such as index, match, and offset, plus math, statistics, and text conversions.

Explore the AutoSum function in Excel, learn two methods to sum marks across subjects or for a student, and compute average, count, max, and min using formulas.

Learn how to use Excel text formulas to extract and manipulate strings with left, right, mid, and len, trim spaces, and convert case with lower, upper, and proper.

Explore how to use logical formulas in Excel, including and, or, if, iferror, and ifna, to evaluate multiple conditions and produce true/false outcomes.

Explore date and time formulas in excel, including today, now, and date functions, and learn to extract day, month, and year and to add or subtract days, months, and years.

Learn to use lookup formulas in Excel, including VLOOKUP, HLOOKUP, MATCH, and INDEX, to retrieve data from a table using single or dual criteria with exact matches.

Explore how to use sumifs, countifs, and averageifs with multiple criteria, define criteria ranges, and verify results to compute totals, counts, and averages in Excel.

Learn how to use offset and indirect formulas in Microsoft Excel to retrieve data from a specific column and reference cells by name.

Learn how to use array formulas in Excel to calculate totals by multiplying quantity by rate across many items, using Ctrl+Shift+Enter to lock formulas and minimize manual errors.

Explore error checking in Excel by identifying and correcting formula errors, evaluating formulas, and understanding automatic versus manual calculations to ensure accurate results.

Create a pivot table from your data by placing fields such as person, product, and units into rows, columns, and values to analyze sales, subtotals, and grand totals.

Learn how to create and modify pivot charts in Microsoft Excel, modify pivot data, adjust layout, and refresh data to analyze data by person, product, and units.

Consolidate data from multiple sheets into a single pivot table by using the developer tab and multi-consolidation ranges, then arrange fields like East, West, Product, and Unit for analysis.

Learn to filter pivot table data with slicers and timelines, selecting week date ranges to display week-by-week or month views for auditors and management.

Learn how to use data filter to view selective data and import and refresh data from various sources, with sorting, text to column, and advanced filters.

Apply data filters and text filters in Microsoft Excel, sort data by different criteria, filter by color, and use date filters to manage weeks and months.

Identify duplicates with conditional formatting and remove duplicates to keep only unique items. Copy unique records to another location or use advanced filters to extract a separate dataset.

Master grouping and ungrouping of data in Excel and apply subtotals to summarize by groups in rows and columns, creating clear, two-dimensional groupings and a streamlined overview.