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

Proper Excel Formula

August 28, 2020 by Barbara

Hi Excellers and welcome to another #Excel #FormulaFriday blog post in my 2020 series. Today let's look at how useful the PROPER Excel function. This little formula does what it says. It converts your text to it's 'proper' case. Essentially it will turn the first letter of each string to uppercase and following letters to lowercase. PROPER Function Syntax. =Proper(cell reference) OR =Proper("your text") Let's work through an example. See my sample data in the screen-shot below, "sales … [Read more...]

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

Combine Conditional Formatting With An Excel Formula – Identifying Duplicate Values

November 9, 2018 by Barbara

Hello Excellers, welcome back to another blog in the #formulafriday series. Today let's look at how to combine conditional formatting with an Excel formula. What are we going to achieve with that?. Well, we can easily identify duplicate values using the combination of these features. So let's take the problem that John has. He has two lists of guests to a retirement party. Another colleague of his has also been collating a list and John needs to identify duplicate names quickly and get one … [Read more...]

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

Change Colour Of Worksheet Tabs

November 6, 2018 by Barbara

Hello, Excellers. Today's blog post is a coffee break quick Excel tip for you. So, I was recently asked how to make Excel worksheet tabs stand out by changing their tab colour. In particular, this user wanted to colour code their regional sales areas with different colour worksheet tabs. You can see the requested result in the screenshot below. First of all to note is that the ability to change the colour of worksheet tabs was only introduced in Excel 2002 (Office XP). So if you … [Read more...]

Filed Under: Excel Tips& Tricks, Quickie Tips Tagged With: Excel Tips, formatting

Pivot The UnPivotable In Excel

December 26, 2013 by Barbara

To use a Pivot Table we usually need transactional data or a flat data table containing rows and columns of data, that is not summarised already. In my example below, the data already looks summarized as it contains months across our data set which is always a giveaway! So what can we do about it, can we make this data 'pivotable'???. so we can carry out some analysis on it??? Sure we can, a neat trick is available....to take formatted summary data and transform it into transactional … [Read more...]

Filed Under: Excel Tips& Tricks, Pivot Tables Tagged With: Excel, Excel Tips, formatting, Pivot Tables

Break Your Pivot Table Filters Into Multiple Columns

November 2, 2013 by Barbara

Before I found out about this little tip, the multiple stacked report filters in my Pivot Tables REALLY annoyed me. So, here is how to avoid all of those stacked up messy filters. Yuk. I have used in my example below a standard Pivot Table with filters of Sales Person, Customer and Customer Type. Usually all of the filters are stacked on top of each other just like this..         Let's make it look a lot better!...well I think it looks a lot better when … [Read more...]

Filed Under: Excel Charting, Excel Tips& Tricks, Pivot Tables Tagged With: Excel, Excel Tips, formatting

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