Category Archives: Excel

AI IN EXCEL In this step-by-step tutorial, learn how to use Artificial Intelligence or A.I. in Microsoft Excel to easily and to quickly analyze your data. Analyze Data in Excel enables you to ask questions about your data with natural language without having to write complicated formulas or code. It provides visual summaries, trends, and patterns for aContinue reading “How to Unlock the Power of AI in 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 import data from an image or picture into data in Microsoft Excel. With the new Data from Picture feature in Excel for Windows, you can insert data from a picture on your clipboard or an image file from your computer. There’s no need to type all the data.Continue reading “NEW: How to Convert Picture to 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”