Apr 7, 2020 11 min read Multi-Input Functions in Excel In this video tutorial, we'll cover multi-input functions in Excel including SUMPRODUCT, ROUND, and more with step-by-step exercises.
Apr 7, 2020 9 min read Absolute Cell References In this video tutorial, we'll walk through why cell referencing is important and how to use it properly with various step-by-step examples.
Apr 6, 2020 7 min read Excel Text Functions Practice PROPER, UPPER, LOWER, and TRIM to change letter case and remove extra spaces in Excel.
Apr 1, 2020 8 min read Excel Interface Learn the basics of the user interface in Excel in the video tutorial - how to use the toolbar, zoom in and out of the sheet, and more.
Jan 24, 2025 7 min read Automating Excel Tasks with Macros Improve your productivity in Excel by mastering macros, automating repetitive tasks effortlessly. Discover how to create, run, and conveniently access macros to… Garfield Stinvil
Feb 21, 2025 4 min read Multi-Sheet Excel: Formatting and Summarizing Techniques Boost your spreadsheet skills by learning how to quickly format data across multiple sheets. Discover simple methods to effortlessly summarize information from… Garfield Stinvil
Feb 9, 2025 5 min read Index Double Match for Dynamic Table Lookups Combine INDEX with two MATCH functions to retrieve the value where a selected row and column meet. Practice a two-way lookup using a parts table. Garfield Stinvil
Dec 25, 2024 6 min read Data Retrieval with the Index Match Function Unlock Excel's full lookup potential by mastering Index Match, a powerful blend of two essential functions. Say goodbye to VLOOKUP's limitations and learn to… Garfield Stinvil
Mar 17, 2025 8 min read Excel: Calculated Fields and Items in Pivot Tables Unlock the full potential of your Excel pivot tables by mastering calculated fields and items. Learn how to effortlessly perform complex calculations without… Garfield Stinvil
Mar 5, 2025 5 min read Creating Pivot Tables to Highlight Sales Variances Unlock the secrets of pivot tables by mastering advanced calculations like "Difference From" and "Percentage Difference From." Follow along step-by-step to… Garfield Stinvil
Jan 7, 2025 6 min read Exploring One and Two Variable Data Tables in Excel Want to explore different loan scenarios or project your investment returns quickly? Discover how Excel's data tables simplify decision-making by analyzing… Garfield Stinvil
Feb 21, 2025 4 min read Goal Seek: Solving for Unknowns in Excel Calculations Want to quickly solve complex calculations in Excel without the algebra headache? Discover how Goal Seek easily finds the unknown variable you need to reach… Garfield Stinvil
Mar 21, 2025 6 min read Logic with IF, AND, OR Functions in Excel Want to expand your Excel skills and create powerful logical tests using IF combined with AND or OR functions? Learn how to easily determine approvals or… Garfield Stinvil
Feb 11, 2025 7 min read Exploring Nested If Statements Want to master Excel's logical power? Discover how nesting multiple IF statements lets you easily manage complex scenarios—from revenue taxes to inventory… Garfield Stinvil
Dec 10, 2024 7 min read Navigating Excel with Go To Special Features Discover how Excel's Go To Special feature can simplify your workflow by quickly selecting formulas, constants, blanks, and visible cells. Save time and boost… Garfield Stinvil
