• Formulas
  • Excel Tips & Tricks
  • Excel Charting
  • Tutorials
  • VBA
  • Book Store
  • More
    • Blog
    • Download Area
    • Excel Video Tutorials
Home » formula friday

How To Check Cells Have The Same Excel Formula.

February 19, 2021 by Barbara —Leave a Comment

Hello Excellers, and welcome back to another #FormulaFriday #Excel formula tip in my 2021 Series. Today, I want to show you how to use the FORMULATEXT function to check if your cells contain the same Excel formula. Why would you need to do this?. Well, one of my subscribers needed to do exactly this. They needed an easy way to check formulas on multiple pages were using the same (correct) formula. In particular, the Sales Tax is being calculated correctly. Each of the worksheets in … [Read more...]

Filed Under: Blog, Formula Friday, Formulas Tagged With: Excel Tips, Formula, formula friday, Formulas

Formula Friday – Applying Names To Your Existing Excel Formulas.

February 12, 2021 by Barbara —Leave a Comment

Hi Excellers, #formulafriday time again. Welcome back to another blog post in my 2021 series. Today is a bit different, I want to share with you how to rename or apply names to formulas that you may already have in your Excel worksheet. Let's take a look at an example. So, for example, you have inherited a worksheet that calculates the Sales Tax applicable to your monthly sales. Currently the value for Sales Tax sits in cell G1. Now, I like to use named ranges in my formulas, (if … [Read more...]

Filed Under: Blog, Excel Tip Category, Formula Friday, Formulas Tagged With: Excel Tips, Formula, formula friday, Formulas

2 Ways To Create An Ongoing Count Of Sales Orders – Excel Formula Friday Double Edition

February 5, 2021 by Barbara —Leave a Comment

Hi Excellers, hope you are having an Excellent day.  It is time for some more #formulafriday Excel formula fun.  Today I have a Formula Friday Double edition. That's right. Today I will show you how to create an ongoing count of sales orders we had in 2018.  We will use two methods.  Up to you which one you want to use.  Both work equally well in Excel. So, this tip is based on a question from a subscriber.  They wanted to have an ongoing count of orders … [Read more...]

Filed Under: Blog, Formula Friday, Formulas Tagged With: Blog, Excel Formulas, formula friday

A Formula To Check If You Have Extra Spaces In Your Data – Formula Friday

January 22, 2021 by Barbara

Welcome Excellers to another #FormulaFriday blog post in my 2021 Excel series. Today I am going to show you some Excel formulas. These are a great way to check if you have extra spaces in your Excel data that you need to clean up. Sometimes the data in cells looks identical like my barcodes in my sales extract. But, when you try to analyse the data you do not get the expected results. I  will show you an example.  I have a set of data below that I want to use in a VLOOKUP … [Read more...]

Filed Under: Blog, Formula Friday, Formulas Tagged With: Blog, Excel Formulas, formula friday

Calculate The Percentage Discount In Excel.

January 15, 2021 by Barbara

Hello Excellers, welcome back to another #FormulaFriday #Excel blog post in my Excel 2021 series. Do you need to know how what discount has been applied to a product?. If you need to calculate the percentage discount well it is really easy. Today's Excel excitement is inspired by not only January sales discounts, but a question from a subscriber. Original Price And Discount Price. So, if you know the Original product price and also the Discounted product price, we can get Excel do … [Read more...]

Filed Under: Blog, Formula Friday, Formulas Tagged With: Blog, Excel, Excel Formulas, Formula, formula friday

  • 1
  • 2
  • 3
  • …
  • 33
  • Next Page »

Tags

Blog Cells Excel Excel Charting Excel Excel Tips Excel Formulas excel tip Excel Tip Category Excel Tips Excel Tips& Tricks excel tutorials Excel Videos Excel Video Tutorials formatting Formula formula friday Formulas macro Macro Mondays Macros Pivot Table Pivot Tables Power BI Power Query Tutorials vb VBA Worksheets

Recommended Excel Resources

Free Excel Dashboard Webinar

Copyright © 2021 · Enterprise Pro Theme on Genesis Framework · WordPress · Log in

Search:

Popular Pages

  • Home

More Info

Want FREE Excel Tips?

Click on my FREE eBook, its my bonus for joining thousands of others who receive my 3 xFREE Excel tips every month in my Excel Newsletter. Join Us!.

Need Answers To Excel Questions Like These?

*How Do I Create A Timestamp In Excel?
*I Want To Change The Width Of The bars On My Excel Chart
*How Can I Find Out The Length Of My Text in Excel? Click the link below to receive more Excel tips' and my Free Ebook

New To Excel? This Is A Great Place To Start!!

Learn Excel Dashboard Course Excel Basics
Scrollbars
Colour of Sheet Tabs
Conditional Formatting
Calculations Introduction

Excel Charting

Self Expanding Charts
One Click Charts
Create Quick Dynamic Charts
Easy Combination Charts

Video Tutorials-If You Like To Learn By Watching

Subscribe to YouTube to get notified of of new Excel videos.


Self Expanding Chart
Delete Obsolete Items From A Pivot Table-Excel 2007
What Are Pivot Tables- Create Your First One
Enable The DeveloperTab In Excel

Some Fun Stuff

Pivot Table Song

© howtoexcelatexcel.com. All rights reserved.
  • Privacy Policy