Category Archives: Excel

In this step-by-step tutorial for beginners, learn how to create a pivot table in Microsoft Excel. With an Excel Pivot Table, you can very quickly and easily analyze data without needing to use any formulas or functions. You can generate insights just by dragging and dropping fields. We start with how to prep your dataContinue reading “How to Create Pivot Tables in Excel”

In this step-by-step tutorial, learn how to insert images directly into cells in Microsoft Excel. Your images can now be part of the worksheet, instead of floating on top. You can move and resize cells, sort and filter, and work with images within an Excel table. This improvement unlocks and facilitates many new scenarios, suchContinue reading “NEW: How to Insert Images in Cells with Excel”

In this step-by-step tutorial, learn how to use the SUMIF Function in Microsoft Excel. With sumif, you can sum cells that meet a certain criteria. Along with SUMIF, we also look at how to use the SUMIFS function, which allows you to sum based on multiple criteria. Additional resources Sample workbook to follow along TimestampsContinue reading “SUMIF Function in Excel Tutorial”

In this step-by-step tutorial, learn how use Excel page setup and print. We cover how to print to one page, how to print your Excel sheet in A4 size full page, how to include table lines / gridlines, and more. By the end of this video, you’ll know how to customize how your Excel sheetContinue reading “How to Print Excel Sheet”

In this step-by-step Microsoft Excel tutorial, learn how to use Formulas and Functions. We start with the fundamentals of entering formulas into Excel. Then we advance to the most common formulas and functions that you’ll encounter in Excel. This video is perfect for beginners who are new to formulas and functions, and even more advancedContinue reading “Excel Formulas and Functions | Full Course”

In this short step-by-step tutorial, learn how you can get Microsoft Excel for free on both the web and desktop. Additional resources Start a new Excel spreadsheet: https://excel.new Launch Excel start page: https://excel.office.com Get all free Office apps (including Word, Excel & PowerPoint): https://www.office.com Free Excel desktop for education: https://www.microsoft.com/en-us/educa… Microsoft Rewards: https://rewards.microsoft.com/ Timestamps 0:00Continue reading “How to Get Microsoft Excel for FREE (download and web versions)”

In this step-by-step beginner’s tutorial, learn how to use the XLOOKUP function in Microsoft Excel. With Excel XLOOKUP formula, you can look up values on the same worksheet or between multiple worksheets. For example, let’s say I have a cookie name, chocolate chip, my favorite, and I want to know the price. I have anotherContinue reading “XLOOKUP in Excel – Tutorial for Beginners”

In this step-by-step overview, learn how you can eliminate repetitive and boring tasks in Microsoft Excel using something called macros and VBA, or Visual Basic for Applications. With macros, you can automate your work in Excel, which will help you save time and effort. Macros are an extremely powerful tool that will take your usageContinue reading “Excel Macros & VBA – Beginners Tutorial”

In this step-by-step overview, learn how to add an advanced search box to your Excel workbook. You can insert a search box with no knowledge of VBA or coding. Imagine you have a cookie customer list, and you want to find the chocolate chip cookies, you can insert a search box to find that. We’llContinue reading “How to Build Search Box in Excel”