+91 80170 49042 [email protected]

Top 5 MS Excel Tips for Faster Reporting

by | Updated on: Nov 3, 2019 | How-To Guides, Tech Tips & Tech News | 0 comments

ms excel tips Everyone who is in the business of SEO knows the value of time. The internet is a vast pool of resources and opportunities, with new avenues opening up even as this is being written. You need to manage time and touch as many points as you possibly can. Reporting on MS Excel is a major time killer in this regard. Many with incomplete knowledge of the software find it really cumbersome to compile reports without wasting much time in the process. Here we will look at the top 5 ways to save time on MS Excel while preparing reports:

 

  • Adding Up: The most irksome problem is probably that of adding up rows and columns of numbers. You can do it instantly by using the Alt key followed by the = key. Simply click on the blank field where you want the total and hit these two keys for the summative result.
  • Decoding Formulas: Excel is notorious for confusing unsuspecting users into using formulas that often take you into mazes. You might find a number result behaving oddly as you change the factors producing the result. Decode the underlying formula quickly by hitting the Ctrl key with the ` key (left of 1).
  • Jump to Start/Finish: You often have to use a series of rows and columns, scrolling over endlessly. How do you get to the start or finish without having to plod through all that data? Simply use Ctrl along with upper-arrow key (to reach the first row/column) and Ctrl and down-arrow key (to reach the last row/column)
  • Replicating Formulas: Never waste time recreating the same formula for a series of rows or columns. Save time by creating the formula only on the first cell in the series. Then double-click on the cell and when a + sign shows up on taking the mouse pointer to the edge of the cell, click and drag it over cells you want to have the same formula.
  • Logic of Short-cuts: MS Excel has a method to the madness of short-cuts. For example, the quick way to get a currency conversion formula is to use Ctrl along with Shift and 4. Now, Shift and 4 gives $! You are actually hitting Ctrl and $ for the currency conversion formula which explains the short-cut.
Debajyoti Banerjee is the Founder, Director & CEO of Seven Boats - A leading digital marketing agency & digital marketing training institute in India since 2011. He is a Google & LinkedIn Certified Digital Marketer & Trainer, Brand Strategist, Consultant & Entrepreneur. B. Tech in computer engineering & post graduate diploma in Marketing, Debajyoti has 18+ years of domain experience and successful track records in digital marketing services & digital marketing training with 500+ clients & 100K+ students in 165+ countries. He has been invited & felicitated by 25+ Top B Schools & universities including London Business School, AICTE ATAL FDP, UGC-HRDC, IIM Shillong, IIM ROHTAK, IIT KGP, IIT Guwahati, Calcutta University, Ranchi University, St. Xavier’s, Brainware, Techno India, JIS Group, Jaypee Group, Shikshayatan Foundation, IIEST Shibpur, Bhavan’s, ICFAI Business School, GITAM Deemed University, Swami Vivekananda Group of Institutions & many more. He has been awarded with more than 20 national awards and he has received notable media coverage. Learn more

 

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

Get a call back
Download Brochure
WhatsApp Chat