MS Excel Essentials - From Basic to Advance

Explore Microsoft Excel fundamentals, from its evolution and interface to key features for data analysis, reporting, and automation, building confidence to launch and use Excel daily.

Explore the basics of Microsoft Excel as an electronic spreadsheet program that stores, organizes, and analyzes data in cells, rows, and columns using text, numbers, formulas, and charts.

Explore the evolution of Microsoft Excel from its 1985 launch to 2021, highlighting key version milestones, VBA, pivot tables, ribbon interface, and Power BI integration with cloud collaboration.

Explore the essential Microsoft Excel features for the MS Excel Essentials course, from a user-friendly interface and data entry to advanced data analysis, formulas, connectivity, charts, automation, and real-time collaboration.

Launch Excel and navigate its interface, from the ribbon and quick access toolbar to templates, new, open, and save options, plus workbook and worksheet basics.

Explore the basic elements of an Excel worksheet: rows, columns, cells, and ranges, and master keyboard shortcuts, while learning to enter and edit data with the tabs and ribbon.

Explore the basic elements of Excel's interface, the workbook and worksheet structure, and master sheet management tasks such as inserting, renaming, moving, copying, hiding, and protecting sheets.

Learn how shortcut keys boost productivity in Excel by performing tasks quickly without the mouse. See examples like summing totals with alt+= and filtering with ctrl+shift+l.

Master navigation shortcuts in Excel, including Ctrl+Down, Ctrl+Up, Ctrl+Right, Ctrl+Left, and Ctrl+Page Up/Page Down, to move, select, and switch sheets efficiently.

Master data entry and editing in Excel by entering text, numbers, dates, and times, and writing formulas. Use shortcuts, formatting, and autofill to streamline data entry and analysis.

Explore advanced ribbon options in Excel, including insert and delete commands, format cell options, wrap text, merge cells, paste options, and data validation.

Learn to format data in Excel with text, numbers, and dates. Apply conditional formatting, use Format Painter, adjust borders and styles, and create custom cell formats for professional sheets.

Master text formatting in Excel by editing cell text with F2 or double-click, applying bold, italic, underline, alignment, wrap text, and themes, plus strikethrough and superscript options.

Learn to format numbers in Excel with general, currency, accounting, decimal, and percentage formats, including thousand separators, fractions, and text conversions for IDs such as 001.

Format dates and times in Excel using standard, long, short, and custom formats. Convert numbers to dates, apply country-specific formats, and use control semicolon for the current date.

Format cells in MS Excel by applying background colors and borders, customizing borders, and adjusting row height and column width with auto fit.

Discover how the format painter copies only the formatting from a source cell to target cells, boosting formatting productivity in Excel and other Microsoft apps.

Create and apply custom cell styles in Excel to maintain formatting consistency and boost productivity, using predefined styles, style creation, and quick modification.

Learn to apply conditional formatting in Excel to dynamically highlight cells based on values, define rules such as greater than, manage rules with top/bottom, data bars, color scales, icons.

Master essential Excel features like sorting, filtering, data validation, text to column feature, duplicates removal, autofill, freeze panes, and grouping with subtotal to analyze data efficiently.

Learn to sort data in Excel by ascending and descending orders for text, numbers, and dates, using the home tab, filter, and color-based or multi-level custom sorting.

Master data filtering in MS Excel by applying text, numeric, and date filters to hide unwanted data, reveal targeted records, and use advanced options like custom filters and top values.

Explore data validation in Excel to ensure accurate data entry by restricting cells to predefined values, with examples like yes/no and ten-digit phone numbers.

Master text to column in Excel to split a column into multiple columns for data cleaning, using delimited or fixed width options and separators like comma, space, and at symbol.

Learn how to remove duplicates in Microsoft Excel to keep only unique records and improve analysis, using the built-in remove duplicates tool to clean data across one or multiple columns.

Master auto fill in Excel to quickly generate numbers, dates, and days, apply custom lists and fill series, and boost data-entry productivity.

Discover how to use freeze panes in Excel to keep headers and the first column visible while scrolling, with options to freeze top row, first column, or both.

Group and ungroup data by country or region, collapse details with outline levels, and add subtotals to view per-country totals and a grand total.

Explore formulas and functions to perform calculations, analyze data, and automate tasks, covering operators, order of operations, relative and absolute references, and key functions like sum, lookup, date, and text.

Master excel formulas by learning to start with the equal sign, perform basic arithmetic, use cell references, and apply built-in functions like sum with proper order of operation.

Learn to write basic Excel formulas and master Bodmas order of operations using cell references vs hard numbers, compute discounts and tax, and use the evaluate formula tool to debug.

Explore how Excel uses relative and absolute cell referencing to build formulas, lock specific cells with F4, and apply these concepts to sums and growth projections.

Master formula functions in Excel by using the equal sign, function name, and arguments with cell ranges, improving accuracy and efficiency over manual sums.

Explore aggregation and statistical functions in MS Excel, such as sum, average, median, mode, min, max, and standard deviation on a sales data example.

Explore Excel's logical functions for data decisions, mastering if, and, or, countif, sumif, and nested if with practical examples like pass/fail and top performers.

Explore lookup functions in Excel, using Vlookup for vertical lookups, Hlookup for horizontal lookups, and Xlookup for advanced retrieval, to populate related data across tables.

Explore date and time functions in Excel to calculate durations between joining and exit dates, determine stays, and format dates for HR analytics.

Learn to clean and transform text data in Excel using text functions such as uppercase, proper, trim, left, right, mid, len, concatenate, and substitute for names, IDs, and codes.

Master common MS Excel errors such as division by zero, hash division, hash name, hash value, reference errors, not available, and fix them using if and iferror formulas.

Master pivot tables in Excel to quickly summarize, analyze, and present large data sets, using tables, calculated fields, filtering, sorting, and grouping.

Discover how pivot tables in Excel automatically summarize and analyze data, enabling quick profit by segment with interactive filters and slicers, drag-and-drop analysis, and dashboards for visuals.

Convert raw data into an Excel table to auto-update formulas and new columns as data grows, and prepare your data for charts and pivot tables.

Convert your data into a standard table, insert a pivot table, and explore its interface with fields, filters, rows, columns, and values, plus slicers and timelines.

Learn to create and modify pivot tables in Excel by dragging fields into rows, columns, values, and filters, and quickly summarize country and segment sales and profits.

Create calculated fields in pivot tables to compute total sales from sales and quantity, without altering source data, then apply aggregations, formatting, and show value as options.

Learn to filter and sort data in pivot tables using label and value filters, multiple filters per field, and sorting by a to z or by highest values.

Group months into quarters in a pivot table to summarize sales trends, renaming groups as quarter 1, quarter 2, quarter 3, and quarter 4, and using ungroup to revert.

Add charts and slicers to pivot tables to create interactive, visually appealing reports that dynamically reflect filters by country or segment.

Format pivot tables and charts to improve readability by applying design styles, banded rows and columns, and value field settings with currency and conditional formatting to highlight insights.

Explore pivot table options, including drill down into country details and percentage of grand total calculations, and manage design and data sources with subtotals, refresh, and change data source.

Turn raw data into visuals in Excel by creating charts that reveal trends, comparisons, and patterns, using chart elements and selecting chart types to tell a clear data story.

Learn to analyze data and apply data visualization in Excel with charts and color coded visuals to reveal trends, support decision making, and build insightful dashboards.

Discover how to create charts in Excel using the insert tab, explore recommended charts, and learn to select data ranges and link charts to source data for dynamic updates.

Explore how to customize charts in Excel by using chart elements, axis titles, data labels, legends, and filters, via the plus icon and design tabs, to create clear, informative visuals.

Learn to create and update charts in Excel by selecting data ranges, adding adjacent columns, choosing non-adjacent columns, filtering rows, switching rows and columns, and moving or changing chart types.

Explore how to create and compare data with bar and column charts in Excel, including clustered, stacked, and 100% stacked types, and learn when to use horizontal versus vertical bars.

Learn how line charts and area charts in Excel visualize time-based temperature data, show trends, emphasize magnitude, and customize labels and legends.

Explore pie and donut charts in Excel, including pie of pie and bar to pie, with guidance on labeling percentages. Learn how treemap charts reveal hierarchical data and category contributions.

Explore how scatter plots in Microsoft Excel reveal relationships between two numeric values, using study hours and exam scores to identify trend lines, correlations, and outliers.

Explore how to create and interpret histograms in Excel to visualize data distribution using bins, revealing frequency patterns across scores or salaries.

Format charts in Microsoft Excel by using chart design and format tabs, applying chart styles, and customizing axes, titles, legends, and data series for clear visual storytelling.

Apply end-to-end data analytics in Excel by building a real-world order data project. Import and prepare data, clean, use formulas and tables, and present insights for your portfolio.

Master an end-to-end portfolio project using Vega stores orders data to clean, model, and analyze with pivot tables, charts, and dashboards for your portfolio or resume.

Master advanced and updated Excel techniques for complex data and dynamic spreadsheets. Learn index switch for advanced lookups, conditional formatting, and custom lists to improve data entry and stay current.

Explore advanced conditional formatting in Excel, including data bars, color scales, and icon sets, and learn to manage and edit rules, format cells by value, and visualize positives and negatives.

Explore advanced sorting in Excel with custom sorting and custom lists, enabling high priority first, multi-column order, and sorting by color, icons, and conditional formats.

Explore advanced filtering in Excel, including custom filters and wildcard filtering with question mark and star, apply multi-criteria in one column, and use data validation and year to date.

Discover how to create and use custom lists with autofill in Excel, add your own lists via options, and apply them to patterns like days, countries, or categories.

Discover how xlookup, introduced in Excel 2019, replaces vlookup and hlookup, explains required and optional arguments, not-found handling, and first-to-last versus last-to-first lookups.

Master two-way lookups in Excel by using index and match to retrieve values across rows and columns, including dynamic counts like promo posts in February or technical posts in March.

Access go to special with F5 or Ctrl G to quickly select blanks, constants, text, or numbers for swift data cleaning and row deletion in large sheets.