Excel Pro Tips
How to Calculate Total Hours in Excel (3 Suitable Ways)
Learn how to calculate total hours in Excel using correct time formats, MOD, TEXT, and conditional formulas for regular and overnight shifts.
Read article
Blog
1285 articles
Excel Pro Tips
How to Calculate 90 Days From Date in Excel (4 Easy Ways)
Learn how to calculate 90 days from a date in Excel using simple addition, DATE, EDATE for months, and WORKDAY to exclude weekends.
Read article
Excel Pro Tips
How to Create an Organizational Chart in Excel from a List
Learn how to create an organizational chart in Excel from a list using SmartArt, TAB for hierarchy, and the Visio Data Visualizer Add-in.
Read article
Excel VBA
How to Sort Multiple Columns in Excel Using VBA
Learn how to sort multiple columns in Excel using VBA, including sorting by a single column or applying multi-level sorting.
Read article
Excel VBA
How to Copy Range to Another Sheet Using Excel VBA
Learn how to copy a range to another sheet in Excel using VBA, including fixed ranges, filtered data, user-specified sheets, and used ranges.
Read article
Google Sheets Basics
How to Change the Number Format in Google Sheets
Learn how to change number formats in Google Sheets, including text conversion, time, duration, decimals, and custom formatting examples.
Read article
Google Sheets Formulas
How to Merge Cells in Google Sheets Without Losing Data
Learn how to merge cells in Google Sheets without losing data using CONCATENATE, JOIN, TEXTJOIN, ampersand (&), CHAR(10), and Apps Script.
Read article
Excel VBA
How to Change Column Width in Excel VBA (3 Simple Methods)
Learn how to change column width in Excel using VBA to adjust single or multiple columns and auto-fit widths based on cell content.
Read article
Excel VBA
How to Delete Empty Rows in Excel Using VBA (3 Suitable Ways)
Learn how to delete empty rows in Excel using VBA by targeting user-selected ranges, defined areas, or removing all blank rows in one go.
Read article
Excel VBA
How to Delete Rows Based on Criteria Using VBA Macro
Learn how to delete rows based on criteria using VBA in Excel—remove by keyword, blanks, errors, duplicates, or user-defined conditions.
Read article
Excel VBA
How to Count Rows with Data in Excel Using VBA (4 Ways)
Learn how to count rows with data in Excel using VBA by applying CountA, looping through rows, using criteria, and targeting specific ranges.
Read article
Excel VBA
How to Find Color Index Numbers in Excel (4 Effective Ways)
Learn how to find Color Index numbers in Excel using ColorIndex, Color & DisplayFormat properties to identify cell background & RGB values.
Read article