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

Calculate The Percentage Discount In Excel.

January 15, 2021 by Barbara —Leave a Comment

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

Extract Initials From Data No Formulas – Flash Fill.

January 8, 2021 by Barbara —Leave a Comment

Hello Excellers welcome back to another #Excel #FormulaFriday in my 2021 series. Today I want to show you how to extract the first letter of a first and second name without using Excel formulas. We can use the Excel Flash Fill feature to do this for us. So, yes Excel will do this for you without a formula or function in sight.  Here is a sample of my data set.  I have highlighted the column I want to populate with the Sales Person's initials. To get Excel to populate … [Read more...]

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

How To Use The Excel GETPIVOTDATA Function.

January 1, 2021 by Barbara —Leave a Comment

Hello Excellers, welcome back to another #Excel #FormulaFriday blog post in my 2021 series of Excel formula tips. So, due to a colleague asking about the GETPIVOTDATA function (which seemed to cause some confusion) I thought it was time to walk through GETPIVOTADATA . I therefore will use a sample Excel Pivot Table. So, read on to solve the GETPIVOTDATA issue. What Is The GETPIVOTDATA Function?. Have you heard of the GETPIVOTDATA function in Excel?. If you look up the Function in the … [Read more...]

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

Formula Friday – 3 Ways To Protect Your Excel Formulas

December 18, 2020 by Barbara

Hi Excellers, this is a different #formulafriday in my Excel 2020 series.  I want to share with you 3 ways to protect your Excel formulas. So, you have spent a long time preparing your Excel spreadsheet solution, and I bet you don't want anyone to mess up it up.  So there are a few ways to protect some of those most vulnerable parts of your Excel spreadsheet. Here are my top 3 ways to protect your Excel Formulas!! Hide themLock CellsHide The Formula Bar With Some Simple … [Read more...]

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

Show Value And Percent In Same Report- No Formulas!

December 11, 2020 by Barbara

Hello, Excellers. Welcome back to one of the last #FormulaFriday Excel blog posts of 2020. Often you will need to display a value as well as percent in the same report. So, more formula (or no formula in this blog post) fun. Today I will show you how to avoid using formulas to do this! Yes, that is right it's not formula Friday really. We go back to one of the best tools in our Excel took kit, the Pivot Table. So, let's quickly build a Pivot Table using a sample data set. A … [Read more...]

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

  • 1
  • 2
  • 3
  • …
  • 40
  • 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

 


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

 

Search

Navigation

  • Formulas
  • Excel Tips & Tricks
  • Excel Charting
  • Tutorials
  • VBA
  • Book Store
  • Top Menu

Social

  • Twitter
  • Facebook
© 2021 howtoexcelatexcel.com. All rights reserved.
  • Privacy Policy