From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 23,200 courses taught by industry experts.

Create formulas rapidly with these shortcuts

Create formulas rapidly with these shortcuts - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Create formulas rapidly with these shortcuts

“

- [Instructor] Because writing formulas 2 is so helpful to so many Excel users, 3 it's worth pointing out some of the shortcuts, 4 some of the faster ways to write formulas. 5 On this worksheet, probably a lot of you would know 6 that if you wanted to total and sell G2, what do we do? 7 Well, the AutoSum button comes to mind. 8 You'll find it in two places. 9 It's on the left side of the Formulas tab, 10 you see it out there, far left, 11 or on the Home tab it's off to the right, much smaller. 12 But in both cases, what do we do? 13 We click, it looks good, we press Enter. 14 But many people quickly realize 15 that you don't have to pause each time. 16 Once you're confident in how you use the feature, 17 why not just double click it? 18 Click, click. There we go. 19 Same thing in cell B8, we want a total here. 20 What do we do? 21 Double click AutoSum in either of its locations. 22 There's a keystroke shortcut for…

Contents