Unlock MICROSOFT EXCEL: Excel Basics, Charts & Functions

Master how to select cells and ranges in Excel using the name box, shift-click to extend selections, ctrl+a for data ranges, and ctrl-click to pick noncontiguous areas, then apply color.

Explore advanced cell selection in Excel by using shift with arrow keys to highlight ranges, control shift to extend selections, and naming selections in the name box for quick recall.

Learn to select columns and rows in Excel using mouse and shortcuts (control+space for a column, shift+space for a row), and drag to resize or highlight ranges.

Insert rows and columns in Excel by right-clicking and choosing insert, then shift cells right or down to create blank spaces; apply to entire rows or columns.

Explore the Excel status bar, customize items like count, average, sum, min/max, and navigate page break preview, page layout, backstage view, and zoom for print readiness.

Master Excel navigation by double-clicking the top, bottom, left, or right edges of a highlighted cell to jump to the corresponding edge of your data set.

Discover how the tell me what you want to do feature in Excel 2016 guides you to bold text, apply color, insert sheets, delete or merge cells, and locate formulas.

Explore how to use Excel's search to find and apply tools like font changes, sorting, justification, and date formatting, and to locate functions and shortcuts quickly.

Sort and filter data in the data tab, including custom sorts by department, job type, and date, with text and date filters such as begins with and ends with.

Sort and filter in Excel by cell color, combine multiple filters across columns, and use text filters (contains, ends with, equals) for refined, color-based data organization.

Learn to convert text to columns in Excel using delimited and fixed width options, with delimiters like comma, tab, or semicolon, and preview results before finishing.

Split names and surnames in Excel using flash fill (Ctrl+E) or text to columns with a comma delimiter, inserting new columns as needed.

Set data validation rules in Excel to restrict inputs by number, date, time, text length, and custom formulas, and customize input and error messages.

Create and apply data lists with data validation using a source range or typed values, then apply the list across a range and circle invalid data to flag errors.

Learn how to group and ungroup rows and columns in Excel, collapse and expand groups, hide and reveal data, and use show details to organize your data efficiently.

Learn to subtotal and grand total in Excel by sorting data and applying sum, average, max, and other functions within department groups for quick insights.

Learn to apply conditional formatting in Excel with greater than, between, and text contains rules, then customize formats with colors, borders, fonts, and patterns.

Explore how to apply conditional formatting in Excel to highlight text, dates, duplicates, and top or bottom percentages, including top 10% and bottom 10% rules.

Apply conditional formatting to flag above and below average data in Excel, using the average function and visual tools like data bars, scales, and icon sets.

Discover how conditional formatting interacts with number formats in Excel, including currency and colors, and how to use custom formats with rules like less than or between while preserving colors.

Demonstrates advanced conditional formatting in Excel, including value-based formatting, text and error handling, blanks, and formulas, with color scales, data bars, and icon sets.

Explore advanced conditional formatting options, including top/bottom values by rank or percent, above/below average and standard deviation rules, and unique or duplicate value highlights.

Learn to apply conditional formatting data bars in Excel, choosing gradient or solid fills, customizing colors and borders, handling negative values and axis, and tweaking min, max, percent, percentile settings.

learn to apply color scales, color skills, icon sets, and advanced conditional formatting in Excel, including managing rules, editing color scales, and combining formats.

Master quick analysis in Excel to apply conditional formatting, data bars, colors, icon sets, and charts, then explore insert tab tools like pivot tables and spark lines.

Explore creating and customizing charts in Excel by selecting data, switching row and column, adding and editing series, and adjusting colors and chart styles.

Explore how to customize chart elements in Excel, including axes, labels, category number, intervals, and axis titles, to enhance readability of your data.

Learn how to customize Excel charts by adding chart titles and data labels. Explore data tables, legend placement, colors, borders, error bars, gridlines, trend lines, and moving averages.

Learn to apply chart styles and colors, filter data by geometry and statistics, and switch chart types using quick layout to adjust legends, data labels, and grids.

Move charts between worksheets, print them separately, and customize chart elements, including axis titles, chart title, data labels, grid lines, legend, and trend lines in Excel basics.

Format chart elements in Excel by selecting individual parts and applying colors, fills, outlines, font colors, and effects; adjust legends, gridlines, and titles for customized charts.

Explore advanced chart formatting in Excel by applying gradients, textures, borders, shadows, and glow; adjust chart area size and lock aspect ratio to customize chart styles.

Format a 3D bar chart by selecting the 3D type, locking the aspect ratio, and exploring 3D rotation, depth, and series options to customize shapes and fills.

Format and customize 3D pie charts in Excel by selecting data, rotating in 3D, adjusting perspective and explosion, and applying colors and bevels.

Explore manipulating 3D charts in Excel, including 3D line, area, and bubbles; adjust rotations on the x and y axes, perspective, field of view, and gap depth, and apply material.

Explore how to use Excel's recommended charts to compare subjects and names, switching between clustered and stacked visuals, reading values, and choosing one-versus-one formats like scatter and funnel.

Learn to create stacked and 100% stacked charts in Excel, compare values across categories, adjust gap width and series overlap, and customize colors on primary and secondary axes.

Learn how to create and customize 3-D column charts in Excel, including clustered, stacked, and 100% stacked types, with horizontal or vertical layouts, gap width, and individual series control.

Explore line charts and area charts to visualize trends over time, compare multiple data series, customize primary and secondary axes, colors, and 3D effects.

Explore area charts in excel, comparing line charts to area charts, including stacked, percent stacked, and 3d area; learn how shading and gaps illustrate data across multiple series.

Discover how to use area charts effectively in Excel, emphasizing 1 to 1 comparisons for clear data storytelling, with tips on color, transparency, borders, and showing data levels.

Explore box and whisker and scatter charts in Excel, learn how to plot data with x and y values, and interpret whiskers, data points, and overlapping series.

Explore box and whisker plots in Excel, showing how grouped data forms the box and whiskers, identify outliers, and interpret the mean and median.

Learn to read and plot box and whisker charts in Excel, interpreting Q1, Q2 (median), Q3, min, max, and mean, with inclusive vs exclusive median and handling outliers in data.

Understand how bubble charts compare two numerical variables using the third variable for size. See how x and y coordinates form the plot while the bubble size conveys additional data.

Learn to create stock charts by ordering data as price, low price, then closing price, and plot high, low, and closing lines with markers.

Learn to build and customize a stock chart with open, high, low, and close prices in Excel, including style changes, data series, and marker formatting.

Create a stock chart showing volume traded, price, low, and closing values for Amazon, Google, Microsoft, and Apple. Identify peaks and compare volumes by coloring the lines to analyze trends.

Learn to create and customize a doughnut chart in Excel, compare 1-to-1 and one-to-many displays, and adjust data series, size, the angle of the first slice, colors, and legends.

Learn how to create 3D doughnut charts in Excel, applying top and bottom bevels, and adjusting width, height, material, and lighting for a 3D look.

Master how to plot a tree map with one data versus one data, using the insert tab, and see it arrange values from highest to lowest.

Explore how to create and format sunburst charts in Excel, compare one-to-one data with donuts and pie charts, and customize colors and chart styles.

Learn how to create and interpret an Excel waterfall chart, starting from the initial value and letting each bar begin at the prior end, with negative values causing downward movement.

Explore how funnel charts visualize data in a one-to-one relationship in Excel, and learn to adjust gap width, fill colors, borders, and shadows.

Explore how Excel histogram charts show the distribution of data in bins, with real-time updates as you insert or edit data. Learn about bins, baseline, and counts per bin.

Adjust bin width and overflow bin to control histogram grouping in Excel. Format the horizontal axis and apply tick marks to clarify data distribution.

Learn to create and interpret a Pareto chart in Excel, using the 80/20 rule to identify the most influential factors by plotting bar values against a cumulative percentage line.

Create combo charts by combining two data series, using options like clustered column or line on a secondary axis, and learn when pie or donut charts lock the axis.

Discover the interactivity of charts in Excel, watching line charts auto-update as data changes and exploring pie charts and sunburst designs.

Convert data to a table, create a chart, and insert slicers to enable interactive filtering that updates the chart as you select salaries.

Combine multiple charts with the same table using slicer tools to drive interactivity. Plot company salaries with a sunburst and filter across charts by selecting items like Amazon and Udemy.

Learn to create map charts in Excel to plot country data on a world map, format data series, show regions, adjust labels and colors, and edit individual countries.

Learn how to customize a map chart in Excel: adjust chart elements and design, title, legend placement, apply styles and color schemes, manage layouts, add data, and switch chart types.

Learn to create and customize map charts in Excel, focusing on African countries and their populations. Adjust data series, colors, labels, shadows, and map projections to visualize regional data.

Learn to create map charts in Excel that show multiple geographic levels by separating country and states with colons, and customize colors and labels.

Create sparklines in cells to visualize data trends with line and win/loss options. Edit data ranges, adjust colors and markers, and compare first, last, high, and low points.

Explore creating and customizing sparklines in Excel, including line and column sparklines, adjusting colors, markers, and points, and grouping multiple sparklines into a single interactive set.

Explore sparklines in Excel, learning to insert a win/loss sparkline, select data range, place it in a cell, and visualize positive versus negative trends with eye points and low points.

Learn to access and customize 3D maps in Excel, using Power Pivot, set location and population categories, adjust colors and heights, apply filters, and create scenes.

Explore interactive 3d map labels and a flat map to reveal sales by region, zoom and rotate, and locate places like India, Mexico, and Canada with a Google map-style search.

Learn to create 3D maps in Excel with a timeline, add country and population data, and visualize and export animated time-based insights.

Learn how to create a pivot table from a data range in Excel, assign fields to rows, columns, values, and filters, and understand default sum calculations and grand totals.

Explore how to customize pivot tables with the design tab: apply styles, enable banded rows and columns, manage headers and grand totals, and switch among compact, outline, and tabular layouts.

Learn to customize pivot table fields by switching between field and area sections, arranging fields side by side or in two-by-two grids, and adjusting sorting and layout with drag actions.

Learn to use analyze tab in pivot tables to manage fields, hide and show lists, clear filters, move pivot table, change data sources, and refresh to update the grand total.

Create and use a timeline filter in Excel with the date of exam to filter data by months, quarters, and years, and customize its style.

Learn to group pivot table data by date components, quarters, months, and time intervals such as hours and minutes, and customize groupings with collapse and expand controls.

Master pivot table field settings by changing aggregations to average or max, adjusting grand totals, and refining display options like indentation, auto fit, tooltips, and sorting.

Learn to insert and configure slicers in Excel to filter data by month and names, use multi-select with click or the control key, and clear filters for easy analysis.

Explore recommended pivot tables and use the interactive slider to adjust filters for January, August, and September, instantly refining charts and layouts for quick, accurate data insights.

Learn to create and customize pivot charts in Excel, choose chart types, filter by names and dates, switch values and axes, and interactively analyze pivot data.

Learn to apply conditional formatting to a pivot table, format sums with color scales, and highlight top ten values or values above or below the average for clearer insights.

Practice creating and customizing pivot tables with months, region, and size data; arrange fields in rows, columns, and values, apply filters, switch layouts, and adjust field settings.

Reinforce pivot table techniques by moving fields between columns and values, toggling months and region, and counting sizes, while exploring pivot charts like pie, area, and radar.

Create a pivot chart directly from the insert tab, with the pivot table appearing in a new worksheet, then swap rows and columns and apply filters to refine regions.

Drill down into pivot tables to reveal the source data behind a value, showing the central region, February metrics, size cg, and sold items through double-clicks.

Learn to create pivot tables and pivot charts in Office 365, filter with slicers by region and size, and refresh data for dynamic insights.