
Master the essentials of Excel 2016 with a beginner-friendly introduction that builds a foundation in basic functions for confident office use.
Explore Excel 2016 help and getting started basics, from autofill and save and share to print, using tell me what you want to do to format currencies.
Master selection techniques in Excel by learning to select single cells, continuous and noncontiguous ranges, entire rows and columns, and apply formatting across selected data.
Learn how to insert and delete rows and columns in Excel 2016, adjust column widths and row heights, and use drag and double-click to resize data for a clean spreadsheet.
Learn to manipulate cells in Excel by copying, moving, and pasting ranges, using autofill for sequences, resizing columns, and performing sort, find, and replace operations.
Learn to manipulate cells and content in Excel by copying and pasting across ranges and worksheets, using drag-and-drop with Ctrl, and applying autofill, sort, and find and replace.
Explore how to manage worksheets in Excel 2016 foundation: rename, insert, delete, move, copy, and transfer worksheets between workbooks.
Explore font formatting in Excel by selecting ranges, changing font type and size, applying bold or color, adjusting borders and fills, and using format painter to copy formatting across cells.
Master alignment in Excel, from left, center, and right to merge and center across selected cells, format painter, text orientation, and wrap text.
Explore how to format numbers in Excel, applying currency, date, time, and percentage formats; adjust decimals, add thousands separators, and switch between accounting and currency styles.
Microsoft Excel 2016 (365) Foundation Training Course
Microsoft Excel 2016 is included with Microsoft Office 365
This course is for Excel beginners. We start by looking at the various Excel Selection Techniques and then see how to use these techniques for Manipulating Rows and Columns and also for Manipulating Cells and Cell Content
Next we look at how to use Microsoft Excel 2016 Worksheets.
The next few chapter cover things such as Font Formatting , Alignment Formatting, Number Formatting and Freezing Row and Column Titles
Then then examine Formulas and Functions. Next we see how to create and format Charts within Excel 2016
Finally we have a look at options for customizing Microsoft Excel 2016