Category: Advanced

Advanced Excel Tips and Tutorials – Advanced Excel Features and Hacks Explained with Examples

Pivot Table Field Name Is Not Valid

(adsbygoogle = window.adsbygoogle || []).push({}); If you are receiving the message “ Pivot table field name is not valid ” when you are trying to...

Ungroup Pivot Table Fields

Excel pivot table groups your dates into years, quarters and months by itself when you drag them into a rows or columns. Many users don’t...

Get Rid of GetPivotData

Almost everybody I know wants to get rid of GetPivotData function. Because when you are writing a formula and use a cell reference from a...

Don’t Count Columns for Vlookup

If you are using Vlookup function like everybody, you are likely to count columns while writing your formula. Don’t count columns for Vlookup anymore, because...

virus detection

How to Repair a Virus Infected Excel File?

Microsoft Excel, a spreadsheet application, offers Calculation, Graphing tools, Pivot tables, Macro programming language called Visual Basic for Applications (VBA), etc. it has become an...

Task Manager with Conditional Formatting

This task manager with conditional formatting will show you practical ways of using conditional formatting other than comparing numbers, etc. It is lightweight and very...