Excel In Depth -- Formula Entry: Episode 1228
504 views · Published 23 August 2010 · 2:49 · Indexed 30 October 2026
Channel: MrExcel.com · 2010 · Education
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
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920