Microsoft Excel 2016 Beginner Level Course

Meet George, a certified Microsoft Office Specialist in Excel with eight years of experience, who guides you through budgeting, financial modeling, and MOS exam prep.

Enter and organize data, format cells, and perform basic calculations while learning saving and printing options. Build familiarity and confidence to use Excel daily with professionalism.

This beginner course targets people who have never used Excel, including first year business or finance students. It suits users upgrading from older Excel versions and highlights 2016 features.

Discover what Excel 2016 can do for you, from keeping accurate data records and filtering large data sets to creating charts, sales forecasts, 3-D maps, and sharing work.

Explore the Excel interface essentials, including the title bar and active workbook name. Navigate the Quick Access Toolbar and ribbon options, adjusting visibility of tabs and commands.

Explore the excel ribbon and default tabs like home, insert, and page layout. Discover formulas tab functions, defined name options, formula auditing tools, calculation options, and sharing via OneDrive.

Learn how a cell sits at intersection of a row and a column, defined by numbers and letters, and how active or selected cells show values in the formula bar.

Identify a range as a block of cells and learn to select, manipulate, name, or format it as a group; recognize cell, range, chart, shape, or word as an object.

Explore the formula bar and name box at the top of the Excel worksheet, and understand how cell addresses are defined by column letters and row numbers.

Navigate to each worksheet using its sheet tab, rename and color-code tabs, and customize tabs to organize spreadsheets.

Navigate Excel's ribbon to access tabs, including Home, Insert, Page Layout, Formula, Data, Review, and View, with groups like Clipboard and Fonts and options for charts, what-if analysis, and macros.

Create a workbook from scratch and explore the Excel interface, including the ribbon and quick access toolbar with save, undo, and redo. Learn how to customize commands for quick access.

Navigate Excel workbooks by adding worksheets with the plus sign, switch sheets using Ctrl+Page Up/Down, and distinguish active cells from selections while using A1 and R1C1 reference styles.

Open the Excel options dialog box to explore general options, enable the mini toolbar and quick analysis, manage the quick access toolbar, live preview, and screen tips.

Explore new workbooks options, including setting Calibri as the default font (size 11), selecting the default view for sheets (page break preview or page layout) and the launch range (1–255).

Personalize Excel 2016 by setting a default author username and initials, adjust the title bar background and office theme, and manage start screen and file associations with tooltips.

Explore Excel general options, including formula tab recalculation and iterative settings for cyclical references; adjust reference styles, auto complete, and languages and toolbar customization.

Explore Excel general options – part 5, and learn to manage add-ins to customize your Excel environment for beginner users.

Learn to add up to 255 worksheets with the plus button, rename sheets, and group or ungroup selections using the ctrl key to edit them together.

Discover how to add, rename, delete, and color worksheets, insert chart or template sheets, and hide or unhide sheets in Excel 2016.

Learn how to add, copy, and move worksheets across workbooks and within the same workbook, including using move or copy, choosing before sheet, and renaming sheets.

Move or copy a worksheet using the move or copy dialog, create a copy in the test workbook, and drag sheets within the active workbook; hidden sheets cannot be moved.

Select individual cells and ranges in Excel, and see the active cell in the name box. Enter text, numbers, and dates, and apply formatting, comments, formulas, and functions.

Edit cells by typing new values or using the formula bar in Excel 2016. Clear, delete, or remove cells to see how data shifts, and learn delete versus backspace behavior.

Master cut, copy, and paste across cells using the Home tab, keyboard shortcuts, right-click menus, and drag-and-drop, with advanced options for formulas, validation, and formatting.

Insert a new column in the sales table by selecting the column to the right and clicking insert on the Home tab; ensure you select the entire row when inserting.

Resize columns and rows by dragging headers or using the format options; auto fit adjusts columns and rows to the longest cell contents.

Learn to wrap text to display long cell contents across multiple lines, auto-adjust cell height, and merge cells to center titles using the merge across and merge cells options.