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”
Category Archives: Excel
NEW: How to Insert Images in Cells with 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”
SUMIF Function in Excel Tutorial
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”
How to Print Excel Sheet
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”
Excel Tips and Tricks
In this step-by-step tutorial, learn the best 11 Microsoft Excel Tips and Tricks that are sure to make your work easier and more efficient. As a few examples, with these hacks, you can move columns with just a simple drag and drop, sum up all the values with just a simple shortcut key, and pickContinue reading “Excel Tips and Tricks”
Excel Formulas and Functions | Full Course
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”
How to Get Microsoft Excel for FREE (download and web versions)
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)”
XLOOKUP in Excel – Tutorial for Beginners
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”
Excel Macros & VBA – Beginners Tutorial
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”
How to Build Search Box in Excel
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”