Excel Microsoft Office 365 Beginner course

Explore how Excel 365 differs from earlier versions, discover new features, learn how updates are added, and view a sample worksheet.

Explore how Office 365 and Excel 365 run in the cloud, with sign in, online access, OneDrive storage, and templates accessible from any computer.

Explore example Excel 365 workbooks and worksheets, including a monthly budget with income and expenses charts, a loan schedule, project planner, and an inventory list with quantities, prices, and discounts.

Learn the basics of starting up Excel 365, open a workbook and worksheet, enter data in cells, explore toolbars, and apply tips for working with data.

Learn to open a workbook in Excel 365, create a blank workbook, or use templates from the home screen. A workbook contains a worksheet.

Explore how Excel organizes data into cells, grids, worksheets, and workbooks, enter text and numbers, manage multiple sheets, and print with or without gridlines.

Explore the backstage and mini toolbar in Excel, use the file tab to save and print, adjust account options, and format numbers with general, two decimal points, and currency.

Master the Excel ribbon and tabs, learn to customize a new tab with commands like create a chart and brightness, and use keyboard tips to run actions without the mouse.

Learn to insert and delete rows, columns, and cells in a spreadsheet, use right-click or quick access tools, adjust column width, and manage layout for clear data visibility.

Autofill speeds up data entry by recognizing patterns and extending sequences across rows and columns, with examples like numbers 1 to 20, dates, days of the week, even numbers.

Master font styles and zoom in Excel with the zoom slider, font type, size, color, bold, italics, and underlines, and apply zoom to selection for precise worksheet viewing.

Learn to enter text, numbers, and dates, edit data, and style worksheets with borders and backgrounds. Save and open workbooks, explore Excel file formats, and apply conditional formatting.

Learn how to enter text, numbers, and dates and edit data in Excel using edit mode, the formula bar, and cell formats like General, Number, Currency, Accounting, and Date.

Learn to edit and delete data in Excel by using backspace and delete keys, entering and escaping edit modes, and removing rows, columns, or cells via keyboard or right-click.

Design backgrounds and borders to make worksheets stand out and organize information, using fill colors, font colors, and borders to emphasize columns, and varied line styles to differentiate regions.

Open a workbook from recent, shared, or local drives and save changes, using save or save as to choose formats like xlsx, xls, or macro-enabled.

Explore freezing panes and split panes, hiding rows, columns, and windows, use format painter for alignment and number/date formatting, and master copying and navigating worksheets in chapter four.

Learn to freeze panes in Excel 365 to keep headers visible while you scroll. Freeze the top row or first column, then unfreeze.

Learn to add, rename, hide, and unhide worksheets in a workbook, manage visibility with right-click, use the plus sign to create new sheets, and drag sheets to arrange their order.

Learn to use the format painter to copy font and number formatting between cells, apply formatting to multiple selections, and quickly standardize currency styles across a worksheet.

Explore aligning text and numbers, wrapping long text across cells, and merging and centering cells to create a clean, centered worksheet layout.

Learn to apply Excel's number and date formats, including general, currency, accounting, decimals, negative numbers, percentages, fractions, scientific formats, and short or long date styles for different locales.

Learn how to create basic Excel formulas with the equal sign, cell references, and operators, and master the order of operations with parentheses, exponents, multiplication, division, addition, and subtraction.

Learn to sum a column in Excel using autosum and a formula, with cell references like E4:E18, and explore averaging data for quick insights.

Master copying formulas in Excel using copy-paste, relative references, and autofill to apply calculations across rows and columns. Use paste special to paste values when needed.

Master Excel formula syntax by learning the required order of operations, how to write equals, cell references, and functions like average, and why spaces break syntax.

Learn how auto calculate works in Excel, with automatic recalculation of changes in numbers across worksheets, workbooks, and formulas, and how to switch between automatic and manual calculation.

Learn to add, subtract, multiply, and divide cells in Excel using cell references and formulas on a worksheet.

learn to edit a range of cells by moving, copying, and pasting data, choosing options like keep source formatting, paste values, and transpose, while understanding formulas and formatting transfer.

Explore chapter six of Excel 365 by creating workbook and worksheet templates, applying styles, and implementing themes to customize and standardize your spreadsheets.

Discover how to create and use premade templates in Excel, with built-in functions, formulas, formatting, colors, styles, and charts to standardize workflows across departments.

Explore how to apply themes and styles to customize templates in Excel 365, adjusting colors, fonts, and effects with the ribbon and page layout for a consistent look.

Review the beginner Excel 365 course, covering overview and new features, creating workbooks, organizing worksheets, basic formulas, and using templates, styles, and themes.