How to Convert PDF to Excel using Excel Power Query
Wondering how to convert PDF to Excel format for further analysis? This could be financials for a given company, your [...]
Your Ultimate Guide to Send Outlook Emails using Excel VBA in 2020
Send Outlook Emails using Excel Add Attachments Send same attachments to multiple recipients or different attachments per recipient -all automated! [...]
Ignite your Excel skills for speed and productivity [How to work faster in Excel]
Are you working for Excel or is Excel working for you?If you’re like most working professionals involved in creating reports, [...]
Power BI DAX Measure [Crack the Challenge]
Power BI / Power Pivot DAX Challenge Compute number of active staff sliced by various parameters [...]
Highlight High and Low Points in an Excel Chart [The Right Way]
Highlight High and Low Points in an Excel Chart Dynamically Creating a chart is an easy task. [...]
Creating Interactive Charts in Excel Using Dropdown Lists
Creating Interactive Charts in Excel Using Dropdown Lists Charts are very central [...]
Using Excel Power Query to Unpivot Data [Extremely Easy That It Will Shock You]
Most times when data is organized in Excel, it is done in a report format (cross tabulation) since it is [...]
How to convert dates formatted as text in Excel
One of the key processes as an analyst while creating reports is to cleanse data from inconsistencies. Sometimes it [...]
4 ways to calculate the duration between two dates
In any working environment, there are various instances where you would be required to calculate the duration between two dates. [...]
8 cool ways to identify and remove duplicates in Excel
When working with data in Excel, it is very likely you will encounter duplication. How do you deal with duplicates [...]