Excel Basics and General Knowledge
How to Count Number of Cells in Excel
Learn how to easily count the number of cells in Excel with this step-by-step guide. Discover tips and shortcuts to efficiently analyze your data.
May 20, 2023
All Excel Guides
Every tutorial, formula reference, and how-to guide on the site, newest first.
Page 45 of 111
Excel Formulas and Functions
How to Count Unique Values in Excel
Learn how to count unique values in Excel with our comprehensive guide. Discover simple and efficient methods to extract distinct values from your data sets.
May 20, 2023
Excel Formulas and Functions
How to COUNTIF in Excel
Learn how to use the COUNTIF function in Microsoft Excel with this easy-to-follow tutorial. Improve your data analysis skills and simplify your work today!
May 20, 2023
Excel Formatting and Visual Adjustments
How to Create a Border in Excel
Learn how to create a border in Excel with our step-by-step guide. Add a professional touch to your spreadsheet and make it stand out.
May 20, 2023
How To
How to Create a Contact List in Excel
Learn how to easily create a contact list in Microsoft Excel. Our step-by-step guide will show you how to organize and manage your contacts efficiently in Excel.
May 20, 2023
How To
How to Create a Custom Autofill List in Excel
Learn how to create a custom autofill list in Excel with our step-by-step guide. Make data entry faster and more accurate by adding your own frequently used words or phrases to the list.
May 20, 2023
How To
How to Create a Drop-Down Menu in Excel
Learn how to create a drop-down menu in Excel with step-by-step instructions. Easily organize and speed up your data entry using this useful feature.
May 20, 2023
How To
How to Create Dropdown in Excel
Learn how to create dropdown lists in Microsoft Excel with this easy step-by-step guide. Improve data accuracy and visualization with dropdowns.
May 20, 2023
Excel Date and Time Functions
How to Create Dummy Variables in Excel
Learn how to create dummy variables in Excel with this step-by-step guide. Dummy variables are essential for data analysis and can help you make informed business decisions.
May 20, 2023
Excel Data Manipulation and Transformation
How to Create Filter in Excel
Learn how to create a filter in Excel with this step-by-step guide. Streamline your data analysis by mastering Excel’s powerful filtering capabilities.
May 20, 2023
Form Controls and User Interaction
How to Create Formulas in Excel
Learn how to create formulas in Excel with our step-by-step guide. Improve your spreadsheet skills and efficiently calculate complex data with ease.
May 20, 2023
How To
How to Create a Heat Map in Excel
Learn how to create a heat map in Excel to visually display data and patterns in your spreadsheet. Follow our step-by-step guide and use conditional formatting to make your data pop.
May 20, 2023
How To
How to Create a Heatmap in Excel
Learn how to create a heatmap in Excel with this step-by-step guide. Use color scales to visualize data patterns, trends, and correlations in one glance.
May 20, 2023
How To
How to Create an Index in Excel
Learn how to create an index in Excel with our step-by-step guide. Organize your data efficiently and make it easier to search for specific information within your spreadsheets.
May 20, 2023
Excel Macros and VBA
How to Create Macros in Excel
Learn how to create macros in Excel with our step-by-step guide. Increase your efficiency and automate repetitive tasks with this powerful feature.
May 20, 2023