Your cart is empty.
Keep shopping
Teach on Udemy
Turn what you know into an opportunity and reach millions around the world.
Learn MoreMaster Microsoft Excel - Excel from Beginner to Advanced
Rating: 4.4 out of 54.4(926 ratings)
3,833 students
Master Microsoft Excel - Excel from Beginner to Advanced
Become an Excel Expert in this Microsoft Excel A-Z Course (Microsoft Excel 2010, 2013, 2016, 2019 and 365).
Created byKirt Kershaw
Last updated 4/2021
English
What you'll learn
- Build a solid understanding on the Basics of Microsoft Excel
- Master Microsoft Excel from Beginner to Advanced
- Writing Formulas and performing Calculations
- Create charts with Trend Lines, and Dual Axis
- Use Excel as a Database with Sort and Filter options
- How to avoid the most common Database Design flaws
- Increase productivity with functions: IF, PMT, VLOOKUP, FIND, SEARCH, MATCH, INDEX and much more...
- Taught by Certified Microsoft Office Excel 2000, 2002, 2003, 2007, 2010, 2013 & 2016 Specialist and Expert with over 17 years of Excel training!
Explore related topics
Course content
22 sections • 158 lectures • 15h 39m total length
- Excel Introduction - First Look8:54
Excel introduction for beginners who want to get started with the first look at Excel, by Microsoft Certified Trainer, and Microsoft Excel Specialist and Expert.
- Exercise Files, Instructor's Notes, Quiz and Answers5:58
- 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 the instructor uses in the video
- 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
- Quiz & Answers - there are two separate .pdf files: Quiz and Answers. The Quiz has one question for each video to test yourself on what was presented, and of course the answers to compare
- Themes, Save Location, Back Stage & Fonts12:39
Learn how to set default options for: Office Theme, Save Location, Backstage , Font, Body Font, Theme Fonts and Excel 2016 Startup Screen.
- Quick Access Toolbar5:03
Excel 2016 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 2016 training video.
- Ribbon7:09
Excel 2016 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 2016 training on the Ribbon!
- Navigating Shortcuts, Tips, Tricks & Selecting Cells5:05
Excel 2016 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.
- Data Entry & Basic Worksheet5:26Excel 2016 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!
- Save, Save As & Backup Copy7:39
Excel 2016 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.
- Convert To 20163:45Excel 2016 tutorial on how to convert older versions of Excel to Excel 2016.
- Compatibility Checker6:05Excel 2016 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 2016 may not appear, or function in earlier version of Excel, and the Compatibility feature will check to see what current Excel 2016 features won't convert.
- Tell Me What You Want To Do - The New Help Feature4:52Excel 2016 tutorial on the new Excel 2016 feature, "Tell Me What You Want To Do", or the newest version of accessing Help in Excel 2016.
- Basics Quiz
- Basic Formulas14:20Excel 2016 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 2016 tutorial.
- SUM & AVERAGE15:43Excel 2016 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 2016 tutorial on SUM and AVERAGE functions!
- MIN & MAX6:08
Excel 2016 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!
- COUNT & COUNTA3:58Excel 2016 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.
- Move, Copy, Cut, & Paste Data into Cells11:59Excel 2016 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 2016 training video.
- Absolute & Relative References6:05Excel 2016 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.
- Mixed References8:43Excel 2016 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.
- AutoFill7:42Excel 2016 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.
- FlashFill6:06Excel 2016 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.
- Converting Text into Columns4:43Excel 2016 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.
- Functions & Formulas Quiz
- Editing Cell Data4:51
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.
- Insert & Delete Cells, Columns and Rows5:09Excel 2016 tutorial on how to insert and delete cells, columns, rows in this Excel training video.
- Find & Replace Data6:11Excel 2016 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.
- GoTo3:57Excel 2016 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.
- Transpose or Flip a Range of Data2:38Excel 2016 tutorial on how to Transpose data, or switching column labels into rows labels, and row labels in to column labels in this Excel Transpose data training video.
- Change Height, Width, & Hide Rows and Columns4:19
Excel 2016 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.
- Check Worksheet or Workbook Spelling with Spell Check2:01
- Smart Lookup & Thesaurus2:54Excel 2016 tutorial on how to explore the internet for definitions of the content of a cell using Excel 2016 Smart Lookup, and finding different words that mean the same thing, or synonyms using Excel 2016 Thesaurus in this Excel 2016 training video.
- Editing Worksheets Quiz
- Formatting Text3:52
Excel 2016 tutorial on how to apply formatting like bold, italics and text alignment to a cell containing text as you'll see in this Excel 2016 training video on formatting.
- Basic Number Formats5:14
Excel 2016 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 2016 training video on basic number formats!
- Basic Custom Number Format4:53
Excel 2016 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 2016 training video on custom number formats.
- Adding Borders & Colors to Cells7:16
Excel 2016 tutorial on how to add and remove borders and colors or shading to your cell or range of cells in this Excel 2016 training video on borders and colors!
- Formatting Shortcuts3:13Excel 2016 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!
- Adding Background1:19Excel 2016 tutorial on how to add a background image to your worksheet in this Excel 2016 training video.
- Align, Merge & Wrap Cell Data6:05Excel 2016 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 2016 training video.
- Cell Styles5:33Excel 2016 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 2016 training video on Cell Styles.
- AutoFormat1:52Excel 2016 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 2016 training video.
- Applying Themes8:18
Excel 2016 tutorial on Themes which is a collection of complementary colors, fonts and effects you can apply to your entire work book in a single click as you'll see in this Excel 2016 training video on Themes.
- Basic Conditional Formatting3:26
Excel 2016 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 2016 training video.
- Conditional Formatting Manager2:15Excel 2016 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 2016 training video.
- Formatting Quiz
- Print Page Breaks, Grildines & Headlines2:55
Excel 2016 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 2016 training video.
- Page Orientation2:02Excel 2016 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 2016 training video.
- Print Rows at the Top of Each Page - Repeat Column Headers7:18Excel 2016 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 2016 Specialist and Expert.
- Headers & Footers9:25Excel 2016 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 2016 training video on a couple of ways of how to insert a header or footer into your spreadsheets.
- Editing Page Margins & Center on Page4:19Excel 2016 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.
- Page Breaks10:28Excel 2016 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.
- Setting Print Range & Scaling8:19Excel 2016 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 2016 training video.
- Print Quiz
- Name, Move, Copy, Color, Link Worksheets in Workbook9:18Excel 2016 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 2016 training video.
- Hide Worksheets & Workbooks4:45Excel 2016 tutorial on how to hide and unhide spreadsheets and workbooks.
- Split Worksheet2:26
Excel 2016 tutorial on how to divide the worksheet window into different panes that each scroll separately by using the Split feature.
- Freeze Panes4:31Excel 2016 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).
- New Windows - Multiple Workbook Views2:45Excel 2016 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.
- Customize Formula Options2:44Excel 2016 tutorial on how to customize formula options including how to disable background error checking.
- Speak Cells1:32Excel 2016 tutorial on how to turn on the Speak Cells feature that has Microsoft Excel speak back through your speakers the contents of your cells.
- Modifying Worksheet Appearance Quiz
- Exercise Files, Instructor's Notes, Quiz & Answers5:58
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 the instructor uses in the video
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
Quiz & Answers - there are two separate .pdf files: Quiz and Answers. The Quiz has one question for each video to test yourself on what was presented, and of course the answers to compare
- Named Ranges9:07
Excel 2016 tutorial on how to assign your own name to a cell, or range of cells. This can be very helpful when using a familiar name of a cell, or range of cells instead of Excel's default names, and also these names are links that when selected will take you right to that named cell, or range of cells; additionally these names you assign can also be used in formulas too!
- Auto-Save Version Control1:35
Excel 2016 tutorial on the Auto-Save Version Control feature that can be used to protect your workbook if you closed out of it without saving it; and by default it's turned on, and by default will automatically save your workbook every 10 minutes of any additional unsaved changes, and you can change that time.
- Linking Data From One Cell, or Range into Another3:58Excel 2016 tutorial on how to link data from one cell(s) into another, as in adding up a bunch of cells from different worksheets into a cell; and when any changes are made in those other cells, that cell is automatically updated.
- Convert Text to Upper, Lower, or Proper Case using Formulas3:36
Excel 2016 tutorial on how to convert your text to upper, lower or even proper case. Proper case being able to convert the first letter to upper case or being capitalized. Training done by Microsoft Certified Trainer and Excel 2016 Specialist and Expert.
- CONCATENATE3:52Excel 2016 tutorial on how to use the CONCATENATE function to combine two or more columns of data into one
- LEFT, SEARCH & FIND Functions7:14Excel 2016 tutorial on LEFT function that returns the number of characters at the start, or "left" side of the cell, and the SEARCH and FIND functions that are used to find the text like a space delimiter within a cell, and when these two are combined Excel will count from "left" to right the minimum number specified in the "search", up unto and including the delimiter, as you'll see in this Excel 2016 training video on LEFT, SEARCH and FIND functions.
- RIGHT, FIND & LEN Functions5:01Excel 2016 tutorial on RIGHT function that returns the number of characters beginning at the end, or "right" side of the cell, and the FIND function is used the find the text like a space delimiter with a cell, and the LEN function is used to count each characters in the cell, and when these three are combined, Excel will return the exact number of characters from the right most part of the cell, as you'll see in this Excel 2016 training video on RIGHT, FIND and LEN functions.
- MID1:16Excel 2016 tutorial on the MID function which is used to return the characters from the middle of a text string, given a starting position and length.
- AND & OR3:56Excel 2016 tutorial on the AND function where the logical tests has to meet all conditions, and the OR function where it only needs to meet one condition, or criteria.
- IF3:20Excel 2016 tutorial on how to use the IF function, where based upon a logical test, like if once cell is greater or equal another, then enter another function or statement if true, and if false then another.
- Combining & Nesting Functions AND & IF5:34Excel 2016 tutorial how to combine and nest functions including the AND and IF functions.
- IFERROR3:32
Excel 2016 tutorial on the IFERROR function which is used to replace Excel's default error expressions with one of your choice that is more readily understandable for other users.
- PMT or Payment1:57Excel 2016 tutorial on the PMT or Payment function that is used to calculate the monthly payment amount on a loan like a car or house using the three variables in the syntax including: interest rate, number of payments and the principle amount.
- Display & Print Formulas1:54Excel 2016 tutorial on how to show, or display and print formulas or functions instead of their resultant values.
- SUMIFS, COUNTIFS & AVERAGEIFS6:01Excel 2016 tutorial on how to place conditions, or criteria on what you want to sum or add up, count up, or average out by using the SUMIF, COUNTIF and AVERAGEIF as well as the plural SUMIFs, COUNTIFs and AVERAGEIFs functions respectively.
- CONVERT0:58Excel 2016 tutorial on the CONVERT function that will convert one unit of measurement into another like liters to gallons.
- MATCH & INDEX3:57
Excel 2016 tutorial on the MATCH function which will return a numerical representation of a value's place in a single row or column, or vector; and is often used to return an item's row number for the use in another lookup function like the INDEX function. The INDEX function returns the value in a row and/or column of a cell range.
- LOOKUP3:55Excel 2016 tutorial on the LOOKUP function that will look in one row, or column range, or vector range, for a value and a return value from the same position in one row or column.
- VLOOKUP8:17
Excel 2016 tutorial on the Vertical Look Up or VLOOKUP function that allows you to look up a value, in a table, and compares the look up value to the values listed in the left most column of the table, and then returns the value from the row you specify as you'll see in this Excel 2016 training video on the VLOOKUP function.
- HLOOKUP9:08Excel 2016 tutorial on the Horizontal Look Up or HLOOKUP function that allows you to look up a value, in a table, and compares the look up value to the values listed in the top most row of the table, and then returns the value from the column you specify as you'll see in this Excel 2016 training video on the HLOOKUP function.
- Single & Multicell Array Formulas3:47Excel 2016 tutorial how to work with single and multi-cell arrays, and they're used to do multiple calculations on cells in a group, known as an array, simultaneously.
- Advanced Formulas & Functions Quiz
Requirements
- You will need Microsoft Excel installed on your computer to follow along and complete the exercise files
- This course was created with Excel 2016. But all features will work in Excel 2010, 2013, 2016, 2019, 365 and most in 2007
Description
Microsoft Excel All-In-One Training
This Microsoft Excel course includes all three Levels from Beginner to Advanced
Microsoft Excel Level 1 – Beginner
Microsoft Excel Level 2 – Intermediate
Microsoft Excel Level 3 – Advanced
Material recorded with Excel 2016 but works in 2010, 2013, 2016, 2019 and 365. MAC users, since the videos are recorded with the Windows version of Microsoft Excel, the interface will be a bit different.
As your instructor I will use my 17+ years of Excel training and certifications including: Microsoft Office Specialist, Expert and Master Instructor: 2000, XP (2002), 2003, 2007, 2010, 2013 and 2016, Microsoft Certified Trainer (MCT), Microsoft Certified Professional (MCP) to guide you step by step through Beginner, Intermediate and Advanced Levels of Excel.
At completion of this course you will master Excel skills that will alleviate the discomfort of uncertainty and reduce time working through your daily tasks, as well have all the training you need to help pass both Microsoft's Excel Core and Excel Expert Exams and become certified, like me. Below are just a few of the topics that you will master:
Creating effective worksheets
Writing and editing formulas and calculations
Use sorting and filtering options
Build a database right the first time and avoid common design flaws
Creating informative and captivating Charts
Eliminate repetitive tasks instantly using Macros
Create many scenarios with varying groups of data
Manage large ranges of data in a List or Table
Increase productivity with functions: IF, PMT, VLOOKUP, FIND, SEARCH, MATCH and much more...
Who this course is for:
- This Microsoft Excel course contains all three levels of learning for the: Beginner, Intermediate and Advanced users
- Includes all the training you need to help you pass both the Excel 2016 Core (77-727) and Excel Expert (77-728) Exams and become certified!