Excel Shortcuts for navigating within Sheet

Faced problems in navigating in Excel?

Have you ever noticed when you are navigating in your excel sheet and the excel sheet has a lot of data, it becomes very cumbersome to navigate in excel sheet?

For example, in my models, I have data which runs across multiple years. We would typically have 5 years historical data and I would create 5 years projections. That means, if I am navigating from first year/ month to last year or month, I have to press the right key 10 times. That takes a lot of time!


Why do you encounter it a lot of times?

Now for all the line items in my model, I have to typically go from the first year to the last year. If there are 500 line items in my model (typically there are more!), and I am going to visit/ revisit each of the items 3 times during the life of the model, then

Total Right keystrokes: 500 x 3 x 10 = whooping 15K keystrokes just for navigation!!

That is a lot of pain and the sure shot way to carpal tunnel syndrome!

⌃ + → key excel shortcut to navigate faster

Would you not want to reduce this pain? I would surely.

Excel shortcut, ⌃ + → key comes in handy!

Cell Navigation in Excel

What benefits do you get?

Now instead of 15K keystrokes, all I need is: 500 x 3 x 1 = 1500.

That is 90% keystrokes saved while navigating the model!

I am greatly impressed by the quality of your training. In fact it is the reason I am going to take the exam this time as I had previously decided not to take it because the quality of the training I had purchased was not what I had expected. All the best to you and everyone at Edupristine.
I am very pleased to have found these courses offered by a recognized, reputable training firm at a great value! Thank you!

Global Association of Risk Professionals, Inc. (GARP®) does not endorse, promote, review or warrant the accuracy of the products or services offered by Edu for FRM® related information, nor does it endorse any pass rates claimed by the provider. Further, GARP is not responsible for any fees or costs paid by the user to Edu nor is GARP responsible for any fees or costs of any person or entity providing any services to Edu Study Program. FRM®, GARP® and Global Association of Risk Professionals®, are trademarks owned by the Global Association of Risk Professionals, Inc

CFA Institute does not endorse, promote, or warrant the accuracy or quality of the products or services offered by EduPristine. CFA Institute, CFA®, Claritas®, and Chartered Financial Analyst® are trademarks owned by CFA Institute.

Utmost care has been taken to ensure that there is no copyright violation or infringement in any of our content. Still, in case you feel that there is any copyright violation of any kind please send a mail to legal@edupristine.com and we will rectify it.

Popular Blogs: Whatsapp Revenue Model | CFA vs CPA | CMA vs CPA | ACCA vs CPA | CFA vs FRM

2015 © Edupristine. ALL Rights Reserved.

tick_classroom_city.php Post ID = 57181