Microsoft Excel - Excel for the beginners

Master data entry in Excel and learn editing and AutoFill to quickly populate monthly data, costs, and profits using drag to fill, series, and keyboard shortcuts.

Learn to write simple formulas in Excel to calculate profit (revenue minus cost) with the equals sign and cell references, then copy, sum, and compute averages using the average function.

Learn to use the min and max functions in Excel to find the smallest and largest values in a data range, writing formulas with an equal sign and arguments.

Learn how to use the average function in Excel to compute daily revenue, cost, and profit by selecting data ranges, entering =average, and dragging results across rows and columns.

Learn to create and customize charts in Excel, visualize regional item sales, and keep charts synchronized with data using design options, quick analysis, and dynamic updates.

Explore chart types in Excel, including line, column, stacked column, and 3D charts, and assess readability by changing chart types, switching rows and columns, and using recommended layouts.

Explore Excel's ideas feature to automatically analyze your data, generate intelligent insights, and create charts and pivot tables to reveal patterns across regions and items.

Explore pivot tables to analyze and visualize large data sets in Excel, create charts, and make data-driven decisions.

Create your first pivot table from scratch to quickly summarize and visualize data by state and category, using fields, filters, and values.

Configure a pivot table by managing fields, filters, and values, explore the design and list options, resize and move the layout, and expand or collapse details.

Create a pivot table from an external data source by connecting to another workbook, selecting the source, and placing the result in an existing worksheet.

Learn to manage pivot tables by renaming, clearing data, moving between worksheets, copying and pasting, converting to normal values, and deleting pivot tables for efficient data analysis.

Explore how to display and customize subtotals and grand totals in Excel pivot tables, including placement at top or bottom and show/hide options for clear totals.

Explore how to adjust pivot table summaries from sum to average, count, or percentage using value field settings, including percentage of grand total and per year.

Learn to add multiple data fields to a pivot table in Excel for beginners, such as quantity and total price, and show values as a percentage of the column total.

Extract data into a pivot table and summarize sales by year, quarter, and month using expand and collapse features to drill down into dates.

Create calculated fields in the data table to compute 10 percent growth and total price, using formulas that multiply quantity by unit price within the pivot table.

Explore drilling down data in Excel using pivot tables and filters to reveal detailed order records by category and year, with auto-created detail sheets and summarized totals.

Filter data in Excel by selecting specific categories and years using the field list and filter arrows, including multi-select and exclusion, to focus on targeted sales.

Learn to filter data in Excel using pivot tables with rule-based options, including begins with, contains, and value filters like less than, greater than, plus top three.

Learn to filter data in Excel by search: type letters in the search field to dynamically display matching items, with examples and an option to apply results.

Explore how to use slicers in Excel to filter pivot tables, quickly view selected categories such as batteries, tires, and other items, and combine selections with control or shift keys.

Explore filtering a pivot table with a timeline to view data by months, quarters, or years, and see it update dynamically as you adjust date ranges.

Change pivot table colors and styles using the design tab, apply or clear formats, and tailor headers, banded columns, and branding to match your report.

Learn to change pivot table layouts in Excel using the design tab and report layout options, switching between compact, outline, and tabular forms to adjust rows and columns.

Format numbers in pivot tables using comma separators, adjust decimals, and use value field settings to apply the bottom number format for English, United States currency, dollars.

Learn to use conditional formatting in Excel to highlight data with color. Create pivot tables to summarize large data and apply rules like greater than 500 or between values.

Highlight the top values in a pivot table using conditional formatting for top five, top 10 items, or top 10 percent. Identify top states by sales and colorize results.

Learn to use data bars in conditional formatting for Excel pivot tables to visually compare category totals. Explore gradient and solid fills, and customize colors for clarity.

Apply heat map color scales in conditional formatting to pivot tables, visualizing highest values in green and lowest in red, with customizable two-color and multi-color options.

Apply icon sets in conditional formatting to visualize values with traffic light colors. Adjust rules and thresholds, including more than one million, to update colors.

Learn to modify existing conditional formatting for a pivot table, adjust fill and font colors, apply borders, and tailor rules such as values over one million, then review changes.

Explore how to manage and apply multiple conditional formatting rules to a pivot table, including above average and top four, with editing, duplicating, and clearing rules.

Learn to create pivot charts from a data set to visualize and compare state quantities sold, using direct pivot chart insertion or via a pivot table.

Pivot a pivot chart by selecting and rearranging pivot table fields to visualize states and quantities dynamically, using filters or columns to tailor the chart and reveal insights.

Filter a pivot chart by category and use slicers to dynamically adjust charts and pivot tables. Learn to insert slicers for quick, multi-category dashboard refinements.

Format a pivot chart in Excel by applying its design, colors, and brand fonts to match other documents, then highlight the top sales bar with a distinct color.

Learn to create pivot charts in Excel, add a trendline, and use simple forecasting to project future values, with options to customize line type and formatting.

Learn how to display all formulas in a worksheet and highlight formula cells using two methods: show formulas from the formulas tab, or highlight with find and select; colors persist.

Explore trace dependence and precedence in Excel to audit how formulas relate and identify which cells influence or are influenced by a given cell.

Learn how to copy only values in Excel without formulas using paste special values and Ctrl-Alt-V, and apply operations like multiply or add to selected cells without altering formulas.

Learn to debug Excel formulas by using the F9 key to evaluate components and verify calculations like k4*2 and the average of a range, plus understand the if function.

Learn to name cells in Excel, use those names in formulas, and manage named ranges with the name manager and paste names, using dollar signs to fix references.

Master the if function to perform a logical test with relational operators, returning a bonus when sales exceed 2000. Lock the bonus cell with absolute references and fill down.

Master nested if statements in Excel by building multi-level logical tests to assign bonuses from employee ratings. Learn about brackets, equals, and 'more than' conditions, including the practical 64-ifs limit.

Learn to build compound logical tests in Excel using and/or within if statements to determine bonuses based on rating, status, and years with the company.

Master the IFS function to evaluate multiple conditions, return the first true result, and handle defaults or blanks without writing long nested ifs.

Learn to use maxifs and minifs in Excel to find the highest or lowest bonuses and salaries based on criteria like years of experience, rating, and full-time status.

Apply the Excel subtotal function to sum salaries and bonuses without double counting by marking data with function number nine. Use outline subtotal and ranges to show totals and details.

Learn how Excel treats dates as values and uses date formats across locales. Use date and time calculations to compute elapsed days and time differences, including two-digit year handling.

Learn to combine and split date and time components in Excel using date and time functions, extract year, month, day, and hours, minutes, seconds, and calculate differences between dates.

Learn how to use Excel’s today and now functions to get dynamic current date and time, compute days between dates, and determine ages from birth dates.

Learn how to use the weekday function in Excel to identify the day from a date, and adjust Sundays and Saturdays to Monday or Friday while formatting as day names.

Learn to use Excel's network days and work day functions to count working days, include holidays, and calculate project end dates from a start date.

Apply edate and eomonth to calculate probation end dates and permanent status starts, handling varying month lengths and year changes with end-of-month and next-month logic.