+918017049042 info@7boats.com

Top 5 MS Excel Tips for Faster Reporting

by | 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. Debajyoti has 17+ years of domain expertise & successful track records in Digital Marketing & emerging technologies. Learn more Schedule an appointment with Debajyoti Banerjee

Want to learn Digital Marketing?

Looking for a career change? Then you need Seven Boats Academy – awarded as the best digital marketing institute in India! Our Digital Marketing Courses will help you get ahead in today’s competitive job market. You’ll learn essential skills that will help you grow your business or find a new job.

With our easy-to-follow course materials, you’ll be able to upskill yourself and achieve your goals. If you are looking for digital marketing course in Kolkata, then Seven Boats Academy is the best digital marketing institute in Kolkata since 2011. So what are you waiting for? Enroll today!

Book a call / Schedule a meeting Or

Sign Up for our FREE Digital Marketing Certification Courses →

1. Sign up & start free courses  → 2. Start a blog  → 3. Read Digital Marketing Tutorials  → 4. Check Tools  → 5. Upgrade to Premium Courses

0 Comments

Submit a Comment

Your email address will not be published.