Learn how to use the various options in pivot tables

Learn how to use IFNA formula to handle missing or erroneous data in Excel

Learn how to use the EXACT formula in Excel quickly

Learn TIME function in Excel

Learn how to use TODAY function in Excel

Learn how to use the Ceiling formula in Excel

Learn how to use the ISTEXT formula in Excel

Learn how to use CORREL function in Excel

Learn how to quickly calculate frequency of data in Excel

Learn how to Get data from Pivot tables in Excel

Learn how to create and use PivotCharts in Excel

Learn how to use the auto templates in Excel to quickly create standard documents

Learn how to track changes in a shared Excel

Learn how to apply conditional formatting based on another cell in Excel

Learn how to use the Covariance function in Excel

Learn how to use the ISNONTEXT function in Excel

Learn how to use the FIXED formula in Excel quickly

Learn how to pick up specific rows from your dataset with CHOOSEROWS formula in Excel

Learn how to excerpt particular columns from your dataset with the CHOOSECOLS function in Excel

Learn how to calculate standard deviation in Excel using STDEV, STDEV.P, and STDEV.S functions.

Learn how to use the Excel ARRAYTOTEXT formula

Learn how to find a specific word in text in a case-sensitive way with the FIND function in Excel

Learn how to use the SUBSTITUTE function in Excel quickly

Learn how to generate a random number between 0 and 1 with the RAND formula in Excel

Learn how to generate random integers in a specific range with the RANDBETWEEN formula in Excel

Learn how to use the Goal Seek function to calculate Break-even point in Excel

Learn how to check whether a value is text with the T function in Excel

Learn how to turn a numeric value to text with a currency symbol with the DOLLAR function in Excel

Learn how to extract a part of a data table using the DROP function in Excel

Learn how to extra a part of information in a table with the TAKE function in Excel

Learn how to use the SMALL function in Excel

Learn how to use the LARGE function in Excel

Learn how to use Data Table to perform One-way sensitivity analysis in Excel

Learn how to use the ISREF function in Excel

Learn about the different types of errors in Excel and how to manage them

Learn how to use the CELL function in Excel

Learn how to create checkboxes in Excel

Learn how to quickly update formatting in Excel using Themes

Learn how to quickly calculate Straight-line depreciation in Excel

Learn how to calculate Declining balance depreciation in Excel

Learn how to use the Yield function in Excel

Learn how to use the NOMINAL function in Excel

Learn how to use the DSUM formula in Excel

Learn how to use the Excel DAVERAGE function

Learn how to use the DMIN formula in Excel.

Learn how to use the DMAX formula in Excel.

Learn how to make and use a stacked bar chart step by step

Learn how to use the DCOUNT function in Excel.

Learn how to use the Excel INFO function

Learn how to create and utilize a Clustered Bar Chart in Excel

Learn how to use the ISERR function in Excel to identify errors.

Learn how to create and use a Stacked Column Chart in Excel

Learn how to create and use a clustered column chart in Excel

Learn how to create and utilize a Radar Chart in Excel

Learn how to create and use a Treemap Chart in Excel.

Learn how to use the INDEX function in Excel

Learn how to use the XLOOKUP function in Excel

Learn how to create and use a Funnel Chart in Excel.

Learn how to predict future data with the Excel FORECAST and FORECASTING.LINEAR functions.

Learn how to use the MATCH function in Excel

Learn what a Bubble Chart is and how to use it in Excel.

Learn how to quickly create a Map chart in Excel

Learn how to quickly create and use a Box plot in Excel

Learn how to create and use Named Ranges in Excel

Learn what a Sunburst Chart is and how to create on in Excel.

Learn how to generate series of data using the SEQUENCE function in Excel.

Learn how to use the INDEX & MATCH functions together in Excel

Learn how to use the MOD function in Excel.

Learn how to use the AVERAGEA function in Excel

Learn how to count non-empty cells using the DCOUNTA function in Excel.

Learn how to calculate interest rate using the RATE function in Excel.

Learn what Circular References are in Excel and how to use or avoid them.

Learn how to calculate present values using the PV function in Excel.

Learn how to use the Excel FV function to calculate future values in Excel.

Learn how to use the PMT function in Excel to calculate payments per period.

Learn what Absolute and Relative cell references are in Excel and how to use them.

Learn how to use the XMATCH function in Excel

Learn what the Scenario Manager is in Excel and how to use it.

Learn what Advanced Filtering is and how to use it in Excel.

Learn how to use conditional formatting with formulas in Excel.

Learn the more about the Formula Bar in Excel and how it can help you.

Learn about the Quick Access Toolbar and how to use it to optimize your work in Excel.

Learn how to make changes across multiple tabs at the same time in Excel.

Learn how to use and apply custom number formatting in Excel.

Learn how to use the trigonometric SIN function in Excel.

Learn how to use the trigonometric COS function in Excel.

Learn how to use the DPRODUCT function in Excel.

How to share select tabs of your Google Sheets workbook without sharing every tab

How to guide on creating a calendar in Google Sheets.

How to guide on creating a custom phone number format in Google Sheets.

How to increase the size of a cell in Google Sheets so data/information is more easily read.

How to run a T-Test in Google Sheets with brief explanations of T-Test types

How to insert a checkbox for yes/no in Google Sheets

Combine first and last name in Google Sheets. Teaches concatenate formula with formatting.

Finding the line of best fit on a scatter plot chart in Google Sheets

How to Open a CSV File in Google Sheets

Guide on opening Excel files in Google Sheets using import

Guide on using IFERROR in Google Sheets specifically with VLOOKUP