Microsoft Excel Bootcamp - Learn to Master Excel in 3hrs!

Customize the quick access toolbar by removing default items and adding your most-used commands, then master keyboard shortcuts to use borders and pivot tables efficiently.

Master keyboard shortcuts in Excel by using ctrl and arrows to navigate data, plus shift to select blocks, and combine control and shift for efficient data selection across large datasets.

Learn how to use sumifs in Excel to sum sales by multiple criteria, building on the sum and countifs basics with clear criteria and ranges.

Master the vlookup function by treating it like a phone book: find the item in the first column of a master lookup table and retrieve its corresponding value.

Learn to avoid vlookup pitfalls by locking down the table and using false for exact matches, since the lookup value must be in the first column of data.

In this case study, learn to use sumifs with multiple criteria and fixed references, divide results by 1000, and troubleshoot variances caused by the other category.

Extract year, month, and day from dates using Excel's year, month, and day formulas to consolidate data by year or month for pivot tables and charts.

Use the trim function to strip leading spaces from text in Excel, preventing formula errors in IF and VLOOKUP; convert text numbers to actual numbers by multiplying by one.

Discover how to split data with Excel's text to columns, using delimited vs. fixed width options, and apply a comma as the delimiter while choosing a safe destination.

Explore conditional formatting in excel with data bars and color scales, create a heat map, and manage rules across a sheet while understanding legends and overwriting behavior.

Pivot tables are easy and powerful; insert them, place region in rows and sales in values, and experiment to see changes, using the analyze tab and field list.

Explore how to drill down data with pivot tables to show total sales by region, then by product and quarter by dragging fields into rows and columns.

Discover how to use slicers with pivot tables to filter data, create pivot charts, and manage field headers and data sources, while refreshing updates for accurate dashboards.