Combine multiple excel workbooks into one workbook We might need to combine multiple excel workbooks into one workbook in order to analyse or present the information better. Though this can Read more
18
Jun
A Gantt style chart can be a great project management tool to help you keep your projects on track and to easily visualize your task schedule. Excel doesn’t come with Read more
We all know how to split comma separated values using delimiter. What if we need to sum, count or average the comma separated values? Follow the steps: (1) Select cell Read more
26
Mar
The most used functions in Excel are the ones that sum and count. You can sum and count based on a single or multiple criteria. This lesson covers: SUM, SUMIF, Read more
Use the following VBA code to convert numbers to text strings. Steps: Hold ALT + F11 keys to open the Microsoft Visual Basic for Applications window. Click Insert > Module, Read more
15
Feb
18
Dec
We know what a Named Range is and how it works. Now we’ll see what is a DYNAMIC named range in Excel. A dynamic named range expands automatically when you Read more
17
Nov
7 Excel Tips to Impress your BOSS Excel is a standout amongst the most prevalent software programs for organizations. It’s used extensively by representatives and managers in a variety of Read more
03
Oct
Microsoft Office is one of the most popular office suites out there. It’s used by businesses both large and small. Despite many programs, Microsoft Word remains one of the most Read more
19
Sep
If some cells, rows, or columns on your worksheet are not displayed, you have the option of copying all cells or only the visible cells. By default, Excel copies hidden Read more