How-to guides and tutorials about the Microsoft Excel spreadsheet application.
Build a PivotTable-style summary with one Excel formula. Use PIVOTBY with a worked example, then add totals, sorting, filters, and percentages. Continue Reading How to Use PIVOTBY in Excel to Summarize Data by Rows and Columns
Use Excel TRIMRANGE to trim empty edges and build dynamic ranges. See examples, named ranges, blank-row limits, and common error fixes. Continue Reading How to Use TRIMRANGE in Excel for Dynamic Ranges
Extract codes and patterned text with Excel REGEXEXTRACT. Learn match modes, capture groups, case options, and fixes with tested examples. Continue Reading How to Use REGEXEXTRACT in Excel (Examples and Fixes)
Summarize Excel data with GROUPBY. Follow a tested example, control headers and totals, filter source rows, and fix common formula errors. Continue Reading How to Use GROUPBY in Excel to Summarize Data
Learn how to create a stacked column chart in Excel with our easy step-by-step guide. Visualize your data efficiently and enhance your presentations today! Continue Reading How to Make Stacked Column Chart in Excel
Learn how to master Excel’s Filter function with our step-by-step guide for beginners. Easily sort and analyze your data like a pro! Continue Reading How to Use Excel Filter Function
Learn how to easily adjust the zoom level in Excel with our step-by-step tutorial, designed to help you view your data just the way you need it. Continue Reading How to Change the Zoom Level in Excel
Learn how to efficiently create a table in Excel with multiple columns and rows. Our guide steps you through setting up, formatting, and optimizing your data. Continue Reading How to Create a Table in Excel with Multiple Columns and Rows
Learn how to effortlessly compute the standard deviation of any data set in Excel with our step-by-step guide, perfect for beginners and experts alike. Continue Reading How to Find the Standard Deviation of a Data Set in Excel
Learn how to effortlessly add serial numbers in Excel with our step-by-step guide. Perfect for beginners looking to organize data efficiently. Continue Reading How to Put Serial Number in Excel
Learn how to efficiently multiply by a percentage in Excel with our step-by-step guide. Master essential formulas for accurate and swift calculations. Continue Reading How to Multiply by a Percentage in Excel
Learn how to effortlessly subtract one column from another in Excel with our simple, step-by-step guide. Perfect for beginners and Excel enthusiasts alike! Continue Reading How to Subtract 2 Columns in Excel
Learn to master Excel’s search function with our step-by-step guide. Quickly locate data within your spreadsheets and boost your productivity. Continue Reading How to Use the Search Function in Excel
Learn how to effortlessly insert data into Excel from a picture with our step-by-step guide. Simplify your data entry process and boost productivity! Continue Reading How to Insert Data in Excel from Picture
Learn how to easily download WhatsApp group contacts into an Excel file with our step-by-step guide. Save time and manage your contacts efficiently! Continue Reading How to Download WhatsApp Group Contacts in Excel
Learn how to effortlessly combine cells in Excel with our easy-to-follow guide. Perfect for beginners looking to enhance their spreadsheet skills. Continue Reading How to Merge Two Cells in Excel
Unlock the power of Excel’s DATE function with our step-by-step guide. Learn how to simplify date entries and enhance your data management skills efficiently. Continue Reading How to Use the Date Function in Excel
Search in Excel with Ctrl+F, list every match with Find All, search the whole workbook, use wildcards, filter rows, or find matches with SEARCH, COUNTIF and FILTER. Continue Reading How to Search for Something in Excel (Find, Filter and Formulas)
Learn how to enhance your Excel experience on a Mac by changing worksheet tab colors with our easy, step-by-step guide. Make your spreadsheets more organized and visually appealing! Continue Reading How to Change Worksheet Tab Color in Excel on Mac
Learn how to sum data effortlessly in Excel with our step-by-step guide. Master techniques like AutoSum, SUM function, and more for quick calculations. Continue Reading How to Do Total in Excel
Excel has no built-in calendar for cells. Add a date drop-down with Data Validation and a list of dates, or use the Date and Time Picker in 32-bit Excel. Continue Reading How to Add a Calendar Drop-Down or Date Picker in Excel
Remove characters from Excel cells with Find and Replace (Ctrl+H) or formulas such as SUBSTITUTE, REPLACE, LEFT, RIGHT and TRIM. Steps and fixes. Continue Reading How to Remove Characters from a Cell in Excel
Learn how to calculate the minutes between two times in Excel with our simple, step-by-step guide. Perfect for beginners and Excel enthusiasts alike! Continue Reading How to Calculate Minutes Between Two Times in Excel
Master the art of forecasting in Excel with our comprehensive guide. Learn step-by-step techniques to predict trends and make informed decisions effortlessly. Continue Reading How to Do a Forecast in Excel
Learn how to easily convert days to years in Excel with our step-by-step guide. Simplify your calculations and improve your efficiency today! Continue Reading How to Convert Days to Years in Excel
Excel drop-down lists allow one choice. Add a short macro to let people pick several items in one cell, or use checkboxes and TEXTJOIN for a no-code version that works in Excel for the web. Continue Reading How to Create a Multi-Select Drop-Down in Excel
Click each sheet’s total with + between them, use a 3D SUM like =SUM(Jan:Dec!B10), or use Consolidate. Here is how, including conditional totals across sheets with VSTACK. Continue Reading How to Add Totals from Different Sheets in Excel
Learn how to effortlessly add multiple data sets to your Excel graphs with our comprehensive, step-by-step guide. Perfect for visualizing complex data! Continue Reading How to Add Multiple Data Sets to a Graph in Excel
Stop Excel showing numbers like 1.23E+11. Apply a Number format, store long numbers as text, turn off automatic data conversion, or import CSV files as text. Continue Reading How to Get Rid of E+ in Excel
Learn how to effortlessly print a selected area in Excel with our step-by-step guide for beginners. Master printing only what you need in just a few clicks! Continue Reading How to Print Selection in Excel
Learn how to efficiently fill in blank cells in Excel with our comprehensive step-by-step guide. Boost your productivity by mastering these essential techniques today! Continue Reading How to Fill in Blank Cells in Excel
Save the workbook to OneDrive, select Share > Copy link, and choose who it works for and whether they can view or edit. Here is how, plus expiry dates, passwords and links to a cell. Continue Reading How to Share an Excel File as a Link
Learn how to create a weekly schedule in Excel with our step-by-step guide. Perfect for beginners, this guide makes organizing your week a breeze! Continue Reading How to Make Weekly Schedule in Excel
Pull a random sample in Excel by adding a RAND helper column, pasting it as values, sorting by it, and keeping the first rows you need. Continue Reading How to Pull a Random Sample in Excel
Learn how to create dependent drop-down lists in Excel with our step-by-step guide. Simplify data entry and ensure accuracy with these easy-to-follow instructions. Continue Reading How to Create Dependent Drop Down List in Excel
To let others edit an Excel workbook, save it to OneDrive or SharePoint, select Share, keep Can edit selected, add their emails, and select Send. Continue Reading How to Share an Excel Spreadsheet for Editing
To view edit history in Excel, select Review > Show Changes to see who changed which cells and when, or use Version History for older versions. Continue Reading How to View Edit History in Excel
Learn how to efficiently copy data in Excel with our beginner-friendly, step-by-step guide. Boost your productivity by mastering this essential skill today! Continue Reading How to Copy Data in Excel
Discover how to easily locate and create Pivot Tables in Excel with our step-by-step guide, transforming your data analysis process into a seamless experience. Continue Reading How to Find Pivot Table in Excel
Learn how to easily add 2 years to a date in Excel using simple formulas and functions. Follow our step-by-step guide to master this essential skill. Continue Reading How to Add 2 Years to a Date in Excel
Learn how to master the NPER function in Excel with our beginner-friendly guide. Follow our step-by-step instructions to calculate the number of periods for any investment. Continue Reading How to Use NPER Function in Excel
Learn how to categorize data in Excel with our step-by-step guide for beginners. Master sorting, filtering, and using functions to make data manageable! Continue Reading How to Categorize Data in Excel
Power Query is built into Excel 2016 and later: open the Data tab and use Get and Transform Data. Excel 2010 and 2013 need Microsoft’s free add-in. Continue Reading How to Find and Enable Power Query in Excel
Press Ctrl+Enter in Excel to confirm an entry and stay in the same cell, turn off “After pressing Enter, move selection”, or use Alt+Enter for a new line inside the cell. Continue Reading How to Press Enter in Excel and Stay in the Same Cell
Learn how to effortlessly convert percentages to numbers in Excel with our step-by-step guide. Enhance your data analysis skills today! Continue Reading How to Convert Percentage to Number in Excel
Link a PDF in Excel with Ctrl+K to create a clickable hyperlink, embed it with Insert > Object > Create from File, or build many links with the HYPERLINK formula. Continue Reading How to Link a PDF in Excel (Hyperlink or Embed)
Learn how to leverage Excel formulas with our step-by-step guide. Master basic functions, cell referencing, and formula creation to boost your productivity! Continue Reading How to Use a Formula in Excel
Learn how to effortlessly add page numbers in Excel with our beginner-friendly guide. Follow these simple steps to enhance your spreadsheets. Continue Reading How to Add Page Numbers to Excel
Learn how to effortlessly merge first and last names in Excel with our step-by-step guide, simplifying data management and enhancing your spreadsheet skills. Continue Reading How to Merge First Name and Last Name in Excel
Learn how to effortlessly add 15 minutes to any time in Excel with this simple, step-by-step guide designed for both beginners and advanced users. Continue Reading How to Add 15 Minutes to Time in Excel