Excel Tips

Troubleshooting Excel Files with unjustified size or opening/loading time

CA, CS, CMA - 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

95 Timesaver Excel basic & advanced excel shortcuts

CA, CS, CMA - 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

Use Flash Fill In Excel and Feel Fresh

CA, CS, CMA - 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

Some Useful Excel Functions for Chartered Accountants

CA, CS, CMA - 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

Excel With Excel! Chapter 2: GOAL SEEK

CA, CS, CMA - Another week has passed by and it’s time to get the hang of another feature in Excel. ‘It takes time to save time’ and When we invest time to learn Excel, we are actually saving our time. ♦ Background: You need to borrow some money – – You know how much you want (the amount […]...

Read More

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

CA, CS, CMA - 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"

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 |

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

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
Posted Under: Finance |

Excel With Excel! Chapter 2: GOAL SEEK

Another week has passed by and it’s time to get the hang of another feature in Excel. ‘It takes time to save time’ and When we invest time to learn Excel, we are actually saving our time. ♦ Background: You need to borrow some money – – You know how much you want (the amount […]...

Read More
Posted Under: Finance |

Excel with Excel – Explaining Excel from a CA viewpoint

Excel's ‘Consolidate’ feature helps in consolidating data in worksheets (located in one workbook or multiple workbooks) into one worksheet. Even though this is predominantly used at the managerial level (say, for aggregating various financial figures from multiple branches), it can come handy to the Chartered Accountants as well....

Read More
Posted Under: Finance |

Use of SUMIF function in excel

Writing an article to appraise readers, how they can use SUMIF in analyzing the financial data. Use of SUMIF in excel: ♠ SUMIF is used to sum up the values of a given range as per the specified criteria. ♠ For example: You are working on GST liability computation and analyzing your ITC register to […]...

Read More
Posted Under: Finance |

A Very Useful Online Tool for Budgeting and Tax Returns

Managing your personal finances and tax returns can be quite tedious, but many people have turned to themselves in order to avoid spending unnecessary funds. The majority of documents needed for such tasks can be created using Microsoft’s Excel, because of its resourceful and versatile nature. ...

Read More
Posted Under: Finance |

How to Get Latest Stock Price in Microsoft Excel

Have you ever wanted to have live stock up dates in Microsoft Excel? You might interested to watch Share Market to know current value of your portfolio ...

Read More
Posted Under: Finance | ,

Browse All Categories

CA, CS, CMA (5,224)
Company Law (6,944)
Custom Duty (8,314)
DGFT (4,461)
Excise Duty (4,442)
Fema / RBI (4,563)
Finance (4,799)
Income Tax (36,051)
SEBI (3,842)
Service Tax (3,679)

Search Posts by Date

March 2021
M T W T F S S
1234567
891011121314
15161718192021
22232425262728
293031