Excel Microsoft Office 365 Beginner course

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

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.

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.

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.

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 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.

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 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.

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.