Lookup Functions, Advanced Charts and Pivot tables

Explore the line chart, an advanced Excel course tool to show trends over time, and review basic chart types for comparing revenues across regions over five years.

Explore stacked column charts to compare items within a value range and reveal how each region's revenue contributes to the whole, year by year.

Explore how scatter charts display numeric values and plot two datasets with an x y scatter plot to reveal relationships.

Explore regression analysis in Excel, examining the relationship between data sets to determine association, such as advertising expenditures with sales and exercise with lifespan, using an x y scatter chart.

Create a scatter chart to analyze how advertisements relate to sales, selecting data and choosing the scatter x and y option (or bubble chart).

Use trend lines to reveal relationship between fads and sales, add a linear trend line via chart tools, and display the equation Y = 8x + b on the chart.

Compare line charts and scatter charts, highlighting axis representations, data categories, and trends; learn when scatter plots reveal associations better than line graphs.

Compare actual temperatures with predicted temperatures using a scatter chart with lines and markers, and switch chart types to show smooth lines that connect data points.

Stock charts plot data arranged in columns or rows on a worksheet, showing fluctuations in values like stock prices, scores, rainfall, and temperatures.

Explore stock charts, including candlestick charts, and learn the four types of stock charts, with key terms such as open, high, low, close, and volume.

Format a stock chart to improve readability by adjusting marker styles and colors using the design tab and chart style options.

Explore using area, scatter, stock, and bubble charts, differentiate chart subtypes, convert between types, compare chart types, organize data to create trendlines and regression analyses.

Explore contour charts that present surface data from above, using color bands to show value ranges and contour lines that connect points of equal value.

Create a radar chart to compare toy sales by item, using the insert tab and radar option. The chart highlights peaks like dolls in March and teddy bears in October.

Explore combination charts that blend multiple chart types, such as column and line charts, to emphasize diverse data and handle varying city value ranges with dual axis capabilities.

Learn how to change chart type to a combo chart by using the design tab, preview different chart types, and adjust the second axis for a clearer visualization.

Define chart templates and their utility, explain chart customization, and outline how to save and apply templates to new and existing charts, including moving or deleting templates.

Enable option 2 in the hidden and empty cell settings, set missing values to zero, and observe spark lines in cells x4 and x6 with six data points each.

Use a pivot table to count how many months each male and female employee has solved by placing gender and months in the fields and using count instead of sum.

Add and use data slicers to filter a data table by fields such as program name, show the count of employees and the program code, and reset the view.

Learn how to create pivot tables and pivot charts, analyze data using tables and charts, and use slices and timelines to explore data.