Microsoft Excel: Formulas & Functions with Charts & Graphs

Use if, and, or in Excel to perform conditional actions, categorize data as pass or fail, and evaluate multiple conditions for streamlined data analysis.

Master nesting functions to tackle complex Excel calculations, from averaging top five numbers with large to nested if for commissions, and combining Vlookup with Iferror for student grades.

Master VLOOKUP to search the first column of a range and return the corresponding value from another column, using exact match and handling errors with IFERROR for no data found.

Master hlookup to perform horizontal lookups by searching the first row and returning the corresponding value from a specified row, with tips on locking ranges and using named ranges.

Master the index function to retrieve values from tables or ranges, using row and column arguments to perform one- and two-dimensional lookups across product and month sales data.

Master the match function in Excel to locate an item's position in a range and power dynamic lookups with index or vlookup, illustrated with fruit lists and monthly sales.

Master date and time functions in Excel to generate today’s date, construct precise times, perform date calculations like the last day of the month, workdays, and date value conversions.

Explore essential text manipulation functions in Excel, such as concatenate, left, right, mid, and substitute, to combine names, extract characters, and replace text for data cleanup.

Master absolute and relative cell references in Excel by using dollar signs, copying formulas, and combining references for powerful spreadsheet manipulation.

Master named ranges in Excel to simplify formulas, improve readability, and auto-update as data grows, using the name manager to create, edit, and expand range references.

Explore dynamic data analysis in Excel by building formulas for sum, vlookup, if, and sumif, plus data validation and pivot tables for insightful analysis.

Explore Excel chart types, including column, line, pie, bar, and scatter plots. Learn how to select data, use the insert tab, and choose the right chart to clarify your message.

Learn to insert and customize charts in Excel by selecting data and choosing chart types, then adjust colors, fonts, titles, data labels, axes, and legends for clear visuals.

Learn to choose the right Excel chart types for numerical, categorical, and time-series data. Explore column, line, bar, pie, area, and scatter charts to communicate data clearly.

Format chart elements to improve clarity and appeal, including the title, axis labels, and data series. Learn to apply axis options, display units, and color styles to create informative visualizations.

Add trendlines and error bars to Excel charts to visualize trends and data variability. Learn step-by-step how to customize line styles, colors, and error bar options to enhance data visualization.

Learn to transform data into eye-catching charts in Excel by customizing styles and colors, using the insert tab to create column or pie charts with clear titles and axis labels.

Link Excel formulas with chart data to create dynamic charts that update automatically as your data changes, using the data source and series values.

Create dynamic charts in Excel that update automatically as data changes. Learn to set up data, insert a line chart, and adjust the data range to reflect new figures.

Analyze sales data in excel using formulas for revenue, average, max, min, and count; visualize trends with line charts, pivot tables, and pivot charts.

Explore data visualization techniques in Excel to transform presentations and reports. Learn to choose and customize charts, use pivot charts, sparklines, and conditional formatting to highlight trends and improve readability.

Organize and structure data in Excel with clear headers, proper formatting, and named ranges; use tables, filtering, and VLOOKUP, plus conditional formatting to visualize trends in charts.

master best practices for visually appealing excel charts and reports by selecting the right chart types, keeping a clean layout, clear labels, consistent colors, annotations, and exporting insights.

Automate repetitive tasks in Excel using the if function and dynamic named ranges to drive charts, and use tables and pivot tables with refreshing data for streamlined analysis.