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

How To Output Positive Values From A Column Of Data

April 16, 2021 by Barbara —Leave a Comment

Hello Excellers, welcome to another #Excel #FormulaFriday blog post in my 2021 series.  Today let’s explore the Filter function in Excel. We can output only the positive values from a column of data using this function. This newly released function is part of the DYNAMIC Array functions announced by Microsoft back in 2018.  At that time these array functions were only beta release available to a portion of Office insiders. Microsoft announced … [Read more...]

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

Compare Two Ranges With Conditional Formatting.

April 9, 2021 by Barbara —Leave a Comment

Hello, Excellers. Welcome to another #Exceltips #FormulaFriday blog post in my Excel 2021 series. The comparison of two Excel ranges for any differences is a common task.  One way to do this to use conditional formatting to highlight differences between the two ranges. Take a look at my two lists below. I have an original list and a new list. Let's go ahead and make the differences in these two lists stand out with conditional formatting. First I want to create named ranges … [Read more...]

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

Find The Last Value In An Excel Column.

April 2, 2021 by Barbara —Leave a Comment

Hello, Excellers. Welcome back to another #Excel #FormulaFriday blog post in my Excel 2021 series. Today I will answer a question that was left on one of my YouTube Videos. The question left was the same multiple times. How do I find the last value in an Excel column?. My video actually walks you through how to find the last value in an Excel row using the Index and Count Function. I have put a link below that video. https://youtu.be/n6odmvo0srY So, here is how to find the last … [Read more...]

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

A Paste Special Trick To Convert A Number To A Percentage.

March 31, 2021 by Barbara —Leave a Comment

Hello, Excellers welcome back to another #Exceltips blog post in my 2021 series. Today let's look at using the Paste Special Function in Excel. Have you a worksheet with the % (percentage) formatting missing?.  If you ever have tried to correct this then you know you could try to adjust the formatting of the cell.  But, that just ends up looking like the screenshot below right?.   Who wants to edit each cell with %?. Well, by using Paste Special we can … [Read more...]

Filed Under: Blog, Excel Tip Category, Excel Tips& Tricks Tagged With: Excel, Excel Tips, excel tutorials

Find Your Cells that Contain Formulas- Quickly

March 26, 2021 by Barbara —1 Comment

Hello, Excellers. Welcome back to another #FormulaFriday #ExcelTips blog post in my 2021 Excel series. Today let's take a look at how to quickly find your cells that contain formulas. Have you ever inherited a workbook? Have you ever been asked to update an Excel workbook?. Do you need to see which cells contain Excel formulas?. Also, do you need to quickly check the referencing of your formulas to ensure they are correct?. So, I would say that no-one wants to manually check each … [Read more...]

Filed Under: Blog, Excel Tips& Tricks, Formulas Tagged With: Excel Tips, Formula, Worksheets

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

Navigation

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

Follow Us

Search

© howtoexcelatexcel.com. All rights reserved.

  • Privacy Policy