microsoft excel 2016 training online free

Watch this Tutorial to Master the VLOOKUP function and use it with confidence! Enter the column number containing the result.In this tutorial, we will cover how to use VLOOKUP in Excel using 4 easy steps! It can be used to extract values from a table and use them in your custom reports and analysis. Lesson 4: Learn VLOOKUP formula in 4 easy stepsĮxcel`s VLOOKUP function is arguably the most used function and the most talked-about function in Excel. 3 TIPS that the Excel experts & MVPS use that will enhance your Formula knowledge!ġ01 Advanced Excel Formulas & Functions Examples.The limitations of using a VLOOKUP and why INDEX & MATCH is better!.A proven step-by-step guide to creating Excel Formulas in SECONDS!.Lesson 3: MOST POPULAR Excel Formulas and FunctionsĮxcel Formulas & Functions will allow you to quickly analyze your data in many forms and will increase your Excel skill exponentially.Īfter completing this tutorial, you will Master the Most POPULAR Excel Formulas and Functions: VLOOKUP, INDEX, MATCH, SUMIF, & IF in only 1 HOUR! You will also learn: In this video, we have compiled an exhaustive list for you so you can apply it to your Excel worksheet straight away:įrequent Keyboard Shortcuts Inside the Ribbon Shortcuts Cell Navigation Shortcuts Formatting Cell Shortcuts Making Selection Shortcuts Working with Formula Shortcuts Ribbon Tab Shortcuts Power Pivot Shortcuts Function Key Shortcuts Drag and Drop Shortcuts Macros and VBA Shortcuts Pivot Table Shortcuts Power BI Shortcuts Other Shortcutsīelow we have created a FREE downloadable PDF cheat sheet and a fully searchable list of the 333 Excel Shortcuts for both Windows and Mac for you!ĭOWNLOAD THE 333 EXCEL SHORTCUTS PDF CHEAT SHEET How to Use Excel for Dummies 141 Free Excel Templates and SpreadsheetsĮxcel keyboard shortcuts are extremely useful as they can make you faster and more efficient while working on Excel.

Microsoft excel 2016 training online free