Microsoft Excel 2019 Level 1 - Beginner Excel 2019

1. Exercise Files  - the exercise files are provided for you to practice what you've  learned after watching the training videos. The exercise files are numbered, and are the exact same as what the instructor uses in the video   

2. Instructor Notes - are quick notes about the  main points covered in the training videos, and are typically used to reference a point quickly without having to watch the entire training  video over again

Excel 2019 introduction for beginners who want to get started with the first look at Excel 2019, by Microsoft Certified Trainer, Excel Specialist and Expert.

Learn how to set default options for: Office Background, Office Theme, Save Location, Backstage , Font, Body Font, Theme Fonts and Excel Startup Screen.

Excel training video on how to customize the Quick Access Toolbar, by adding and removing commands from the toolbar that you can then access from it in a single click! Excel training video.

Excel training video on how to customize the Ribbon including: adding Tabs, Groups and Commands, as well as hiding, deleting or resetting it. Watch my Excel training on the Ribbon!

Excel tutorial on how to navigate the cells in your spreadsheet with some great tips, tricks and shortcuts. Also learn how to select cells either separately, as a group, or non-linearly.

Excel tutorial on the basics of entering data into a cell, on a spreadsheet! And then how to create your own first mini database, or table of data!

Excel tutorial on how to save your workbook, and the difference between "Save" and "Save As"; where you can use the "Save As" feature to save a copy of your workbook. However, the first time you save any Excel workbook it will force you to "Save As" and I explain why in the Excel tutorial.

Excel tutorial on how to convert older versions of Excel to Excel 2019.

Excel Tutorial on how to check the compatibility of the current version of Excel when converting it to an earlier version of Excel. For example, some features in Excel may not appear, or function in earlier version of Excel, and the Compatibility feature will check to see what current Excel features won't convert.

Excel tutorial on the "Tell Me What You Want To Do", or accessing Help in Excel.

Excel tutorial on how to create basic formulas in Excel. Also, some simple tricks, tips and shortcuts to adding additional formulas into other cells like copy and pasting, or using the AutoFill feature. There's more than one way to enter a formula, and depending upon your work you may find it necessary to learn all in this basic formulas Excel tutorial.

Excel tutorial on how to sum, or add up a range of cells by using the SUM function, or average a range of cells by using the AVERAGE function. As well as other tips, tricks and shortcuts like: how to show and hide functions, calculation options, error check and more in the Excel tutorial on SUM and AVERAGE functions!

Excel tutorial on how to find the minimum or lowest (smallest) value in a range of cells using the MIN function, or the maximum, or highest (largest) value in a range using the MAX function. Please let me know what you think after watching my MIN and MAX functions Excel training video!

Excel tutorial on how to count the number of cells in a range that contain numbers using the COUNT function, and how to count the number of cells in a range that are not empty using the COUNTA function in this Excel training video.

Excel tutorial on how to work with your data from one cell to another in your workbook, on a worksheet by moving, copying, cutting and pasting your data. I'll show you the many ways that can increase your efficiency when it comes time to move, copy, cut and paste your data in this free Excel training video.

Excel tutorial on how to create a cell reference that remains the same when the formula is copied, or autofilled to other cells, known as an Absolute Reference, as opposed to a reference that always changes when the formula is copied to another cell known as a Relative Reference in this Excel training video.

Excel tutorial on cell references that contain both an absolute and relative reference known as a mixed reference. Remember, an absolute reference is when a formula remains the same when it has been copied to other cells, and relative is where the formula changes when copied to another cell; and when a formula contains both it is known as a mixed reference.

Excel tutorial on how to quickly copy the contents of a cell or range of cells to adjacent cells using the AutoFill feature, in this free Excel training video.

Excel tutorial on FlashFill, which is part of the AutoFill feature. To use the FlashFill, you need to be next to a column of data you want to change, or actually even several columns away, as long as it's within the same database range; then when FlashFill recognizes a pattern after you type in a few, it will fill in a preview of what it thinks is a pattern, and then you can hit Enter to accept, or continue giving the FlashFill more examples, in this free Excel training video.

Excel tutorial on how to break up phrases, or groups of words or data into cells of their own by using the Text to Column feature in the free Excel training video.

Excel how to edit data within a cell that includes tips, tricks and shortcuts in the Excel training video on editing the contents of a cell.

Excel tutorial on how to insert and delete cells, columns, rows in this Excel training video.

Excel tutorial on how to find data like text, or numbers and also formats within your spreadsheet and workbook, and also to replace those instances in a single click in this Excel training video on finding and replacing data.

Excel tutorial on how to use the GoTo feature in Excel. This GoTo feature is used to go to a referenced cell, or named range quickly, and will remember the last cell you were, when after advancing to another cell in this Excel training video.

Excel tutorial on how to Transpose data, or switching column labels into rows labels, and row labels in to column labels by using a Paste Special feature, or the TRANSPOSE function.

Excel tutorial on how to adjust the size, height, width of your columns or rows, as well as how to hide and unhide them in this Excel training video.

Excel tutorial on how to explore the internet for definitions of the content of a cell using Excel Smart Lookup, and finding different words that mean the same thing, or synonyms using Excel Thesaurus in this Excel training video.

Excel tutorial on how to apply formatting like bold, italics and text alignment to a cell containing text as you'll see in this Excel training video on formatting.

Excel tutorial on how to apply different number formats like: currency, including various currencies around the world and their symbols and variation of date and time. Watch this Excel training video on basic number formats

Excel tutorial on how to create a basic custom number format. Learn how to create a custom number format like Social Security field that adds text to the number, but without actually being part of the number as you'll see in this Excel training video on custom number formats.

Excel tutorial on how to add and remove borders and colors or shading to your cell or range of cells in this Excel training video on borders and colors!

Excel tutorial on how to use formatting shortcuts like the: Format Painter that will copy all the formats of a selected cell (or range of cells) that you can then apply to another in a single click. Also, the secret behind the F4 key and how not only to apply the most recent format, but a combination of many formats as you'll see in this Excel training video on formatting shortcuts, tips and tricks!

Excel tutorial on how to add a background image to your worksheet in this Excel training video.

Excel tutorial on how to align the contents of a cell, left, right, or centered, merge two or more cells together as well as how to unmerge, and wrapping the data within a cell so the cells grows vertically to accommodate the text that doesn't display width wise in the cell as you'll see in this Excel training video.

Excel tutorial on Cell Styles which is a collection of formats you can apply to a cell, or range in a single click like: number, alignment, font, border, fill and protection as you see in this Excel training video on Cell Styles.

Excel tutorial on how apply a predefined selection of colors, fonts and number formats by using the AutoFormat feature in a single click as you'll see in this Excel training video.

Excel tutorial on how to apply a format to a cell when a criteria has been met, or conditional formatting.  You'll see the top 5 most popular conditional formats used including: highlight, top and bottom values, data bars, color scales and icon sets in this Excel training video.

Excel tutorial on how to use the Conditional Formatting Manager to edit, or delete your conditional formats of a selected range or worksheet as you'll learn in this Excel training video.

Excel tutorial on how to display or hide gridlines and headlines in the spreadsheet as well as from printing. Also, I'll cover the page break line that appears after you come out of the Print Preview as you'll see in this Excel training video.

Excel tutorial on how to use Portrait or Landscape as the Page Orientation to view more data vertically, or horizontally respectively when you print out your spreadsheet as you'll learn in this Excel training video.

Excel tutorial on how to print and have repeated at the top of each printable page your column headers, or on the left your row headers. Training done by Microsoft Certified Trainer and Excel Specialist and Expert.

Excel tutorial on how to have data, or images repeated at the top, or bottom of every printed page known as headers and footers; like title, name, logo, date, or page number. Watch this Excel training video on a couple of ways of how to insert a header or footer into your spreadsheets.

Excel tutorial on how to edit your margins prior to printing your spreadsheet, as well as how to center on page your data either horizontally or vertically.

Excel tutorial on how to control the amount of data printed on a page by using page breaks. You'll learn how to view, insert and remove them in the Page Break Preview workbook view.

Excel tutorial on how to set a cell, or range of cells as a print area that will be the only part of your spreadsheet that prints, and how to scale down you font size to allow more to fit onto your printed page prior to printing in this Excel training video.

Excel tutorial on how to name and add color to the worksheets tab, as well as how to, move, or copy worksheets within workbook, or into another.  Also, learn how to data on one worksheet into another, or another workbook in this Excel training video.

Excel tutorial on how to hide and unhide spreadsheets and workbooks.

Excel tutorial on how to divide the worksheet window into different panes that each scroll separately by using the Split feature.

Excel training video on how to freeze panes which will keep rows and columns visible while the rest of the spreadsheet scrolls (and is based upon current selection).

Excel tutorial on the New Windows feature that allows you to open up the same workbook so you can work in different places at the same time.

Excel tutorial on how to customize formula options including how to disable background error checking.

Excel tutorial on how to turn on the Speak Cells feature that has Microsoft Excel speak back through your speakers the contents of your cells.

Excel 2019 now has sound effects that can enhance your productivity in Excel by providing audio cues.     

Excel 2019 Accessibility Checker has a new "one-click-fix!" feature - which checks the workbook for content that people with disabilities might find difficult to read.

New to Excel 2019 is the Translate feature, which translates selected text from one language into another!