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

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

Create A Yes No Message Box Before Running An Excel Macro.

April 12, 2021 by Barbara —Leave a Comment

Welcome back to another blog post in my #ExcelTips #MacroMonday Excel 2021 series. There a few ways to run an Excel macro. Hit the F5 key or the Run button while in the VBA window. But, sometimes a giving the user a warning before the macro is run, or ask if they are sure they want to run it the macro is a good safety net. The Yes No message box is a really good way to do this. The logic is simple. Hit Yes and the code or macro runs. Hit No, the code stops running. You are asking are you … [Read more...]

Filed Under: Blog, Macro Mondays, Macros, VBA Tagged With: Blog, Macro Mondays, Macros

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

Convert All Formulas Into Values Excel Macro.

April 5, 2021 by Barbara —Leave a Comment

Hello Excellers and welcome back to another #MacroMonday blog post in my #Excel 2020 Excel tips series. Today we will write an Excel macro that will very quickly convert all of your formulas into values. Yes, that is correct, this macro will convert all Excel formulas into absolute values with one click of the mouse. Prepare To Write The Macro. First, open the Visual Basic Editor.  There are two ways to do this.  Hit ALT +F11 orSelect the Developer Tab | Code … [Read more...]

Filed Under: Blog, Macro Mondays, Macros, VBA Tagged With: Blog, Macro Mondays, Macros

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

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

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

Popular Pages

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