Master Microsoft Excel: From Beginner to Pro!

Navigate the Excel home screen to create or open documents, use templates, access recent and pinned files, and manage your Office 365 account.

Explore the Excel interface, including the Quick Access toolbar, the ribbon with tabs, and the formula toolbar. Learn tips to hide the ribbon and customize the toolbar.

Explore how a workbook holds multiple worksheets for entering formulas and data, enabling cross-sheet calculations, and learn to customize the status bar and page break preview.

Explore essential Excel shortcuts and quick access toolbar customization to speed up your workflow. Master shortcuts like Ctrl+C, Ctrl+V, Ctrl+X, Ctrl+B, Ctrl+N, Ctrl+O, and Ctrl+S across Windows and Mac.

Build a monthly budget report in Excel, format titles, use numeric and date values, apply cell references across January to December to compute monthly and yearly totals.

Learn to work with numeric values in Excel by building a monthly budget, using fill to populate data, and formatting currency with proper alignment. Identify text versus numbers, handle leading zeros, and convert text to numbers, with a look at custom date formats in the next lecture.

Learn to work with date values in Excel and format them for display using built-in date formats or custom month-year formats aligned to your locale.

Learn cell references in Excel as the foundation for formulas, using single cells or ranges like C4 to C8 to support calculating averages and counts.

Master Excel formulas to perform quick calculations, format cells as currency with two decimals, and learn how relative and absolute references are used in formulas.

Explore absolute and relative references in Excel, and learn how copying formulas adjusts references while using absolute references to lock totals and compute each month's percentage.

Master the sum function in Excel to automatically total monthly and yearly figures by selecting cells, then copying, pasting, or dragging formulas.

Explore how to use min, max, and average functions in Excel to analyze data, find the smallest and largest values, and compute averages using the formulas tab and search.

Explore adjacent cell errors in Excel caused by dates treated as text, and learn to ignore the error and update the formula to keep dates formatted.

Explore the count, floor, and ceiling functions in Excel to count numbers, round down or up to a chosen significance, and format results for clear presentation.

Learn how to use AutoSum in Excel to quickly total ranges, override its default cell choices, and understand when manual adjustment improves accuracy.

Learn autofill in Microsoft Excel, copying and adapting formulas by dragging the fill handle and using the alt plus equal sign shortcut to auto sum rows.

Apply font formatting in excel to highlight data with bold, size, color, italic, and underline. Explore theme colors, fonts, and effects, and try changing themes like berlin or circuit.

Master Excel background colors by using the paint bucket tool, applying theme and standard colors, adjusting font color to white, and creating distinct sections with green and blue highlights.

Learn to apply borders in excel, including bottom and double borders, adjust thickness and color, apply to headings, remove background colors, and explore line styles.

Learn to display currency in Excel by selecting a currency symbol, apply comma formatting for thousand separators, and remove the dollar signs to create breathing room.

Format numbers as percentages in Excel by applying the percentage style on the home tab, which converts decimals to percent, then revert to comma style to restore decimals.

Use the format painter to quickly copy formatting, font size, and background color to other cells or worksheets, keep it active with a double click, and exit with escape.

Create and apply a custom cell style in Excel, using home and styles to define fonts, borders, colors, and number formats, then modify once to update the whole workbook.

Apply conditional formatting in Excel to highlight values across B4:M8 with rules for greater than or equal to 1000 in dark red and less than 1000 in green.

Learn how to merge cells in Excel to create a single cell for titles, use merge and center, and apply styling such as background and text colors.

Move data inside a worksheet by selecting cells and dragging, and copy or move it between worksheets and workbooks using ctrl x, ctrl c, and ctrl v.

Adjust column width and row height in Excel by dragging between edges or using auto fit, and apply to multiple columns or rows.

learn to add and remove rows and columns in excel using the ctrl + plus shortcut and right-click insert. drag to fill and watch totals update automatically.

Hide and unhide rows or columns in Excel to control visible data without changing totals. Use right-click to hide or unhide and note that hidden data still contributes to totals.

Move and copy worksheets in a workbook using drag-and-drop, and copy with Ctrl A, Ctrl C, and Ctrl V, or by holding Ctrl while dragging for instant duplicates.

Rename worksheets by double-clicking the sheet name or right-clicking to rename. Delete worksheets with a warning prompt, noting that deletion is permanent.

Discover how to insert shapes, images, and diagrams in Excel to visualize data, then customize fill colors, outlines, sizes, and arrows to highlight key figures like rent percentage.

Insert images into Excel using the insert tab from local files, stock images, or online pictures. Place them inside a cell or over cells to illustrate a monthly budget.

Explore how to insert and customize smart art in Excel, create a pyramid to visualize expenses, adjust text, color, and layout, and compare with chart options for data visualization.

Master Microsoft Excel by creating a line chart from data, using the insert chart options, customizing colors, and exploring the chart ribbon and Office 365 features to visualize monthly budgets.

Learn to adjust a line chart’s data in Excel by displaying only selected months. Move the chart to a dedicated chart sheet linked to the monthly budget data.

Learn to change the chart type in Excel, switch between bar and pie charts, adjust formatting and layout, and set a chart title like monthly budget 2024.

Explore how to use and create Excel templates, transforming a monthly budget report into a reusable template and choosing pre-made or custom templates via file new.

Create and use premade and custom templates in Excel to streamline budgeting and data work. Save and adapt templates for a new year, updating inputs and chart as needed.

Review Excel basics, formulas, and text editing while exploring sum, min, max, average, count, ceiling, floor, and autosum to build a solid foundation for the next section.

Explore the structure of an Excel list, including headers, breaks, and converting data to a table. Learn to filter, sort, remove duplicates, and manage list integrity.

Explore how to sort lists in Excel using the data tab, performing single-level and multi-level sorts by first name, last name, and department, while handling headers.

Learn to sort a list by custom month order and apply filters to isolate records in Excel, using the data tab, with practical steps for sorting, filtering, and pre-filtered sharing.

Identify duplicates in an Excel list with conditional formatting, then remove them using the data tools remove duplicates, keeping a single entry per ID column.

Convert a list to an Excel table to enable quick filtering, automatic row counting, and in-table functions. Learn to add rows, remove duplicates, and use pivot tables for data summaries.