Essential Microsoft Excel from Beginner to Advance level

Format data in Excel with font size, font type, color, bold, italics, and underline to improve readability, then apply cell styles, borders, fill colors, and alignment to distinguish headers.

Master data handling in Excel by learning cut, copy, and paste methods, keyboard shortcuts, paste options, and clipboard use to move and transform data efficiently.

Learn to print and save in Excel using the backstage view, with options for printing entire workbook, active sheets, or selection, plus print area, orientation, and print titles.

Master basic Excel formulas and functions, from arithmetic (add, subtract, multiply, divide) to aggregates (sum, average, min, max, count, median), plus concatenation, conditional logic, lookups, and time.

Explore Excel mathematical functions for addition, sum, division, and multiplication. Use equal signs, parentheses, and the formula bar, plus the handle for totals and dynamic updates.

Learn how to calculate averages, count numerical values, and find maximum and minimum values in a data set using Excel functions.

Discover textual functions in excel, using trim to remove extra spaces and preserve single spaces, and concatenate to join text strings; learn paste values for static results.

Master textual functions in Excel, including uppercase and lowercase conversion, the length function, and left, right, and mid extractions, with practical steps and examples.

Learn how to rank data in Excel with rank, rank.avg, and rank IQ, including how duplicates yield the same rank and how average ranks are computed.

Explore Excel's logical functions to test conditions, compare values, and drive decisions using IF, AND, OR, and nested IF statements with true/false results.

Explore date and time functions in Excel, including date, day name, month name, year, weekday, weekend checks, and building dates and times from components to manage deadlines and schedules.

Learn to handle #N/A and not applicable errors with xlookup using if_not_found, and apply approximate match via the match mode options to find next smaller or larger items.

Learn how to use X lookup as a replacement for Vlookup to find prices across vertical and horizontal tables. Handle not found cases and perform multi-criteria lookups across sheets.

Master pivot tables in Excel to quickly analyze car inventory, count by make and color, compute profit margins with calculated fields, and sort, average, and show values as percentages.

Learn to choose the right Excel charts for your data, conveying comparisons, relationships, distributions, compositions, flows, and locations with bar, line, pie, donut, histogram, scatter, and map visuals.

Explore essential Excel chart elements, including chart area, axes, data series, category names, plot area, legend, chart title, and grid lines, and learn to create a two-column chart.

Create bar and column charts in Microsoft Excel using shortcut Alt+F1 or the Insert menu. Learn chart elements, styles, filters, and formatting to present store sales data clearly.

Format and customize Excel charts by selecting data, inserting a column chart, and adjusting axes, titles, data labels, legend, gridlines, colors, and layouts.

Learn how to use the search mode in Excel XLOOKUP, including default top-to-bottom searches, reverse lookups (-1), and binary searches (-2) for ascending or descending data.

Learn to create line charts in Excel using the insert tab and recommended charts, then customize axes and titles for clear visualization of data over years.

Learn to visualize trends over time with area charts in Excel, using stacked and 100% stacked area charts to show cumulative totals, and how to create and adjust them.

Master creating pie and donut charts in Excel by selecting data, inserting charts, adding data labels, legends, and titles, and customizing colors, sorting, and highlighting segments for clear data visualization.

Learn why pie charts in Excel are best avoided with large data sets and how a column chart offers a clearer visualization of sales by individuals.

Create a scatter plot (xy chart) in Excel by selecting two numeric columns and inserting a basic chart to visualize the relationship between cost and profit.

Learn to create a frequency distribution table in Excel using countifs to group scores into ranges, then build and customize a histogram that updates dynamically with data.

Master how to create a waterfall chart in Microsoft Excel from a monthly sales table using a dummy column, converting to a stacked column chart, and adding data labels.

Learn to create sunburst and tree map charts in Excel from a data table, move and resize the charts, customize colors, and sort data to address legend issues.

Learn to create a combination chart in Excel by combining clustered column with a line, assign a secondary axis for precipitation, add data labels, and format colors and chart title.

Learn how spark lines compress large data into small charts within single cells, insert via the home ribbon, select data, edit spark line data, group, and delete spark lines.

Learn to create a pivot chart from a data table by selecting fields, placing it on the existing worksheet, and configuring date and amount fields with design and color options.

Create an Excel map chart from states, population, and GDP data by using recommended charts or the field map option, then customize labels and colors.

Learn to create candlestick or open-high-low-close stock charts in Microsoft Excel, label data correctly, include volume, and use four data series to show stock performance over time.

Learn essential Microsoft Excel shortcuts to navigate tabs, save, copy and paste, undo, apply bold and center alignment, add borders and fill color for faster workbook workflows.

Explore Excel from basic to advanced levels as the instructor introduces the course, outlines topics, and invites online and offline learners to build practical skills.

Create an automatic monthly salary slip in Excel from scratch, using an employer ID to dynamically update designation, employer name, earnings, deductions, and net salary.

Learn to design a monthly salary slip in Excel by configuring page layout, margins, borders, and columns, then organize fields for employee details, earnings, deductions, and net salary.

Build an automatic monthly salary slip in Excel using formulas for total earnings, total deductions, and net salary. Use data validation and vlookup to pull employee details.

Master essential Excel fundamentals by navigating the ribbon and file menus, formatting cells, and applying formulas, pivot tables, charts, and vlookup, xlookup, and hlookup lookups.