Mastering Excel Fundamentals - Excel Beginner Course

Explore the Excel ribbon and its tabs, groups, and commands, plus the quick access toolbar. Learn to customize, hide, move, and use dialog launchers for deeper options.

Master Excel basics by understanding workbooks, worksheets, and the terminology of books and sheets. Navigate cells, columns, and rows, and learn how to create new workbooks and use templates.

Explore the formula bar and status bar, using dragging to select cells and view counts, sums, averages, minimums and maximums with page layout and zoom.

Explore Excel navigation, shortcut menus, and the mini toolbar to move between worksheets and workbooks, insert rows and columns, and access context-aware commands.

Master data entry techniques in Excel and learn to edit cells with the formula bar or double-click. Use the waterfall autofill to populate months, days, and dates.

Enter dates with slashes or dashes and times with colons; Excel converts them to numbers. Understand regional date formats, two-digit year interpretation, and date and time functions.

Master undo and redo in Excel with ctrl z and ctrl y, manage comments with insert and show comments, and save workbooks safely using save as and save.

Learn how to create simple formulas and use functions in Excel, referencing cells and calculating totals, averages, and basic operations by typing, arrow keys, or mouse.

Learn how to copy formulas across worksheets in Excel using the fill handle and autofill, with relative references adapting across columns and rows, and tips for minimum, maximum, and sums.

Master the year-to-date profits concept in Excel by building a dynamic formula that adds the previous months' totals with the current month and copying it across.

Explore calculating percentage change in Excel by applying the hierarchy of operations, using parentheses to control evaluation, and avoiding common formula errors across month-to-month or year-on-year profits.

Learn how absolute references fix formulas in excel as you copy and apply rent escalations. Use the dollar sign and F4 to keep key references constant.

Explore Excel's built-in function library of over 450 functions, including ranking, counta, median, large, small, and standard deviation, and learn to apply these common data analysis tools.

Explore fonts and borders in Excel basics, adjust font size and style in the Home tab, compare Caliber 11 with Arial ten, and apply borders and colors.

Learn to adjust row heights and column widths in excel using drag, best fit, and all-sheet adjustments, ensuring consistent display and understanding how merged cells and zoom affect layout.

Master alignment, wrap text, and merge cells in Excel, applying left, center, or right alignment, wrapping long text, and using merge center to create centered titles across ranges.

Explore how to format currency and special numbers in Excel, including social security numbers, phone numbers, and accounting versus currency formats, using format cells and number formatting.

Learn how to format dates and times in Excel by regional settings, choose short or long date formats, use two- or four-digit years, and apply time formats with shortcuts ctrl+shift+3.

Learn to use conditional formatting on the home tab to highlight data with rules, color scales, data bars, and icon sets, manage rules, and apply dynamic visuals.

Mastering Excel fundamentals shows how to convert data ranges into tables, apply styles and banded rows, and use slicers for dynamic filtering and analysis.

Learn to add shapes, arrows, and pictures in Excel from the insert tab, use smart art and organizational charts, insert logos, and customize shape text and styles to enhance worksheets.

Insert or delete rows and columns, or shift cells using the right-click contextual menu or keyboard shortcuts. Excel automatically updates formulas when layout changes, and you can undo with ease.

Learn how to hide and unhide rows and columns in Excel to preserve data while printing, use multiple selections, and restore original widths with unhide and best-fit techniques.

Learn to move, copy, and insert data in Excel using drag-and-drop, shortcut keys, and the right-click shortcut menu, while preserving original data and updating formulas.

Learn to use Excel's find and replace to search within a selected range or column, refine results with match case or find all, and replace data and formatting.

Master the page layout tab and view to perform print preview, adjust orientation, set print area, and manage headers, footers, and print titles in Excel.

Explore how to use Excel's page break preview to control printed output by adjusting column widths, dragging borders, and selecting print settings for single pages or selections.

Master Excel page setup and printing by using the page layout tab and page setup dialog, adjusting margins and scaling, adding headers and footers, and repeating titles in print preview.

Master five methods to create charts in Excel. Learn quick charting with Alt+F1, F11, quick analysis, and moving charts between sheets, plus data selection tips.

Explore how to choose and switch chart types in Excel, from column and line charts to pie charts, and learn when to switch rows and columns.

Learn to format and edit charts in Excel by creating a clustered column chart, adding dynamic titles from worksheet data, applying quick layouts and styles, and fine-tuning axis labels.

Create in-cell spark lines in Excel to visualize data without full charts. Choose line, column, or win/loss styles and adjust color, width, and markers.

Learn how to freeze panes in Excel to keep the top row or first column visible as you scroll, unfreeze when needed, and freeze multiple columns for better data navigation.

Learn to use Excel's split view to see two parts of a worksheet at once, with horizontal and vertical splits, independent scrolling, and how to remove splits.

Master the outlining feature in Excel to collapse and expand data views, using auto outline, outlining numbers, and hide or show quarterly and monthly totals for focused presentations.

Mastering Excel fundamentals teaches you to display multiple worksheets and workbooks side by side by using the view tab, switch windows, and arrange all for tiled, horizontal, or vertical layouts.

Master renaming, inserting, and deleting worksheets in Excel, using double-click or right-click to rename, and insert with shift+11 or the plus button, and hide sheets.

Learn to move, copy, and group worksheets in a workbook by dragging sheet tabs, using copy options and control-key techniques, and grouping multiple sheets for synchronized edits.

Learn to link data across multiple worksheets and workbooks using formulas, auto sum, and cell references, including handling spaces in sheet names and cross-file links.