Excel Tips

Benford’s Law Practical Application

Finance - Benford's law describes the relative frequency distribution for leading digits of numbers in datasets. In this article we are discussing the possible ways to implement this theorem with understanding our needs and business practices of record keeping....

Read More

Top 100 Excel Shortcuts to Work Smartly & to Save Time

Finance - Microsoft Excel is extensively used across the globe to store and analyze. Despite various new data analytics tools in the market, Excel remains the go-to product for working with data. It has numerous in-built features, which makes it easier for you to organize your data. In this article, we’ll be discussing the various Excel shortcuts...

Read More

Demystifying Pivot Tables in Excel with Examples – Part II

Finance - Following the previous post, we are here with some unknown yet useful features of Pivot that can enhance our work quality on a day-to-day basis. In this post we will be looking into the Pivot Charts, Filters and Slicers, Timelines and the feature of Calculated Fields in Pivot....

Read More

Demystifying Pivot Tables in Excel with Examples – Part 1

Finance - What is a Pivot table? Table in Excel is a conventional form where we have the rows and columns of the data as in raw form with a little scope such as filter, sort ,etc. There is no scope for turning down the data into meaningful insights and summary. ‘Pivot’ means to turn or change […]...

Read More

How to use Excel flash fill

Finance - We often know so many tools. The big question is when and how do I use the tool? Sharing small snippets on using Excel flash fill along with a few use cases. What is Flash Fill in Excel? Excel Flash Fill is a special tool that analyses the information you are entering and automatically fills […]...

Read More

Join GST, Customs, Excel & Income Tax Courses at 60% Discount

Finance - Join Certification Course on GST Compliances, Excel For professionals, Income Tax and Customs, Import & Export by TaxGuru Edu at 60% discount...

Read More

Best Strategies to Excel in your Microsoft Exam 70-741 and Benefits of Utilizing Practice Tests

Finance - Test anxiety can affect not just the result of your certification exam but also your wellbeing. It may lead to exam failure, or worst, mental breakdown! And if you don’t want to pull a stressful all-nighter, there’s no better way than to have a game plan. For those who plan to take Microsoft exam 70-741, […]...

Read More
Sorry No Post Found
Sorry No Post Found

Recent Posts in "Excel Tips"

Benford’s Law Practical Application

Benford's law describes the relative frequency distribution for leading digits of numbers in datasets. In this article we are discussing the possible ways to implement this theorem with understanding our needs and business practices of record keeping....

Read More
Posted Under: Finance |

Join GST, Customs, Excel & Income Tax Courses at 60% Discount

Join Certification Course on GST Compliances, Excel For professionals, Income Tax and Customs, Import & Export by TaxGuru Edu at 60% discount...

Read More
Posted Under: Finance | ,

Top 100 Excel Shortcuts to Work Smartly & to Save Time

Microsoft Excel is extensively used across the globe to store and analyze. Despite various new data analytics tools in the market, Excel remains the go-to product for working with data. It has numerous in-built features, which makes it easier for you to organize your data. In this article, we’ll be discussing the various Excel shortcuts...

Read More
Posted Under: Finance |

Demystifying Pivot Tables in Excel with Examples – Part II

Following the previous post, we are here with some unknown yet useful features of Pivot that can enhance our work quality on a day-to-day basis. In this post we will be looking into the Pivot Charts, Filters and Slicers, Timelines and the feature of Calculated Fields in Pivot....

Read More
Posted Under: Finance |

Demystifying Pivot Tables in Excel with Examples – Part 1

What is a Pivot table? Table in Excel is a conventional form where we have the rows and columns of the data as in raw form with a little scope such as filter, sort ,etc. There is no scope for turning down the data into meaningful insights and summary. ‘Pivot’ means to turn or change […]...

Read More
Posted Under: Finance |

How to use Excel flash fill

We often know so many tools. The big question is when and how do I use the tool? Sharing small snippets on using Excel flash fill along with a few use cases. What is Flash Fill in Excel? Excel Flash Fill is a special tool that analyses the information you are entering and automatically fills […]...

Read More
Posted Under: Finance |

Troubleshooting Excel Files with unjustified size or opening/loading time

We all have came across than one excel file which does not contain that much information but still taking up a space of several MBs and makes our PC standstill while opening or editing it. You might have wondered what is the extra data that is stored in that file. Here are few tips that […]...

Read More
Posted Under: Finance |

95 Timesaver Excel basic & advanced excel shortcuts

Pre requisites to help understand the file: 1. What is Timesaver Excel Shortcuts? 95 selected basic & advanced excel shortcuts which can simplify work 2. Is there any thing one should know in advance before reading the shortcuts? Yes. Below are the two points which you should know in advance before going through the shortcuts: [&helli...

Read More
Posted Under: Finance |

Use Flash Fill In Excel and Feel Fresh

Microsoft Excel is undoubtedly most user friendly tool and being extensively used all over the world. We might be using it daily or maybe casually, but probably always wished that we knew more about this dynamic program. Most of us don’t use even 5% of its capabilities. While most of us know use of VLOOKUP, […]...

Read More
Posted Under: Finance |

Some Useful Excel Functions for Chartered Accountants

Working as a Chartered Accountant or an Article in any company or firm, it is always expected from us that we are perfect in numbers as far as financial numbers are concerned. The one tool which is very common and useful in every industry and in every country, is MS-Excel. So, in this article we […]...

Read More
Posted Under: Finance |

Browse All Categories

CA, CS, CMA (6,325)
Company Law (9,004)
Corporate Law (11,464)
Custom Duty (9,857)
DGFT (4,949)
Excise Duty (5,077)
Fema / RBI (5,442)
Finance (5,969)
Income Tax (44,859)
SEBI (4,845)
Service Tax (4,250)