Sponsored
    Follow Us:

Excel Tips

Latest Articles


Excel Formulas & Shortcuts: Bank Reconciliation, EMI Calculation, Pivot Tables

Finance : Learn Excel basic formulas, shortcut keys, and important functions. Get guides for bank reconciliation, loan EMI calculation, pivo...

April 9, 2024 153720 Views 1 comment Print

Efficient Client Management: Excel Proforma for CA/CS/CMA

CA, CS, CMA : Enhance client management for professionals like Chartered Accountants, Company Secretaries, and Cost Accountants using Excel-base...

August 16, 2023 5832 Views 0 comment Print

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 disc...

January 14, 2023 6654 Views 0 comment Print

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,...

June 28, 2022 8592 Views 0 comment Print

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...

June 18, 2021 2697 Views 0 comment Print


Latest News


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

Goods and Services Tax : Join Certification Course on GST Compliances, Excel For professionals, Income Tax and Customs, Import & Export by TaxGuru Edu at ...

August 27, 2022 921015 Views 150 comments Print

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 wo...

April 15, 2020 819 Views 0 comment Print


Excel Tips – How to Create Shortcuts for commonly used words or phrases?

March 11, 2012 10102 Views 0 comment Print

Create Shortcuts for commonly used words or phrases? Use the AutoCorrect feature. It creates shortcuts for commonly used words or phrases.Click – Files →Options → proofing → AutoCorrect Options. On the [AutoCorrect] tab check the option ‘Replace Text As You Type’

Sponsored
Search Post by Date
July 2024
M T W T F S S
1234567
891011121314
15161718192021
22232425262728
293031