Excel In Depth -- Formula Entry: Episode 1228

504 views · Published 23 August 2010 · 2:49 · Indexed 30 October 2026

Channel: MrExcel.com · 2010 · Education

Watch on YouTube

Microsoft Excel Tutorial: Entering Formulas 3 Ways in Excel | MrExcel Podcast | Tips & Tricks for Formula Entry.

Welcome to the MrExcel podcast. In this episode, we will be diving into chapter 8 of Excel 2010 in Depth, where we will be discussing formulas in three different ways. I'm your host, Bill Jelen, and I'm excited to share some valuable tips and tricks with you.

Firstly, we will cover the most common method of entering formulas, which is simply typing them out. For example, if we want to calculate the gross profit percent in column 'I', we can type in the formula =H2/F2. Surprisingly, only about 10% of people use this method, but it can be a quick and easy way to enter formulas.

Next, we will explore the method preferred by many Excel users - using the mouse. This involves typing the equal sign (=) and then clicking on the cells or ranges you want to include in your formula. For our example, we would click on the cell containing profit, followed by the divide sign (/), and then the cell containing revenue. This method can be useful for those who are more comfortable using the mouse to navigate in Excel.

For those who have been using Excel since the days of Lotus 1-2-3, you may be familiar with the third method - using the arrow keys. This involves typing the equal sign (=) and then using the left arrow key to navigate to the desired cell or range. For our example, we would type =, press the left arrow key three times to reach column F, and then press enter. This method may take a bit longer, but it can be a useful skill to have in your Excel arsenal.

If you're a fan of using the mouse, here's a handy tip for you. You can customize your quick access toolbar to include icons for commonly used mathematical operations, such as plus, minus, multiply, and divide. This way, you can simply click on the icons to start your formula, without having to reach for the keyboard. This can be a faster way to enter formulas, especially if you're participating in the "Excel Olympics" and need to enter them quickly.

Thank you for tuning in to this episode of the MrExcel podcast. We hope you found these tips on formula entry helpful. Be sure to join us next time for more Excel insights and tricks. Don't forget to subscribe to our channel and hit the notification bell to stay updated on our latest videos. See you next time!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Table of Contents:
(00:00) Entering Formulas 3 Ways
(00:13) Three ways to enter formulas
(00:23) Method 1: Typing the formula
(00:33) Method 2: Using the mouse
(01:01) Method 3: Using the arrow keys
(01:27) Tip for mouse users: Customize quick access toolbar
(02:32) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial


This video answers these common search terms:
Chapter 8
Customize quick access toolbar
Excel 2010 in Depth
Excel Olympics
Formulas 3 Ways
Gross profit percent
Navigating with arrow keys
Typing formulas
Using icons for mathematical operations in Excel
Using the mouse to enter formulas


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152909/


There is more than one way to enter a formula in Excel. Episode #1228 shows three (3) ways to successfully enter a formula in Excel.

...This episode is the video podcast companion to the book, "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel.

More from this channel