Change the name of items in a Pivot

Adrian Miric Adrian Miric

Adrian Miric

Owner, AuditExcel.co.za & Excel-Skills-Assessment.com

发布日期: 2021年5月11日
+ 关注

Do you need to change the name of items directly in the Pivot Table? When working in Pivot Tables you sometimes get data which uses inconvenient names for items e.g. you can have the day of the week shown as 1,2,3 etc instead of Monday, Tuesday etc. If you cannot change the underlying database, it is useful to realise that you can change the name of items directly in the Pivot Table and it will remember your preference from then on. Watch the video for more….

#excel#exceltutorial#exceltips#exceltraining#msexcel#msexceltutorial#msexceltips#msexceltraining#excelconsultant#excelonlinetraining#excelvirtualtraining#excelskillsassessment#advancedExcel

要查看或添加评论，请登录

Adrian Miric的更多文章

  • Excel Automation with Power Query Course - 02 December 2021
    2021年11月18日

    Excel Automation with Power Query Course - 02 December 2021

    If you spend hours getting data and then cleaning it up (every month) then this course is for you. It will teach you…

  • Spell Check Excel Documents
    2021年8月17日

    Spell Check Excel Documents

    You can spell check Excel documents but there are a couple of tips and tricks you need to use to make it act more like…

  • Start Of Month Formula in Excel
    2021年7月27日

    Start Of Month Formula in Excel

    Surprisingly, there is no start of month formula in Excel. There is an end of month formula (EOMONTH) but no formula…

  • Stop Users From Inserting/ Deleting Rows - 2 Ways
    2021年7月15日

    Stop Users From Inserting/ Deleting Rows - 2 Ways

    A common requirement is how to stop Excel users from inserting or deleting rows. Typically a template is set up and the…

  • IF Function Not Working With Numbers
    2021年7月7日

    IF Function Not Working With Numbers

    Your IF function not working with numbers? A recent question from a client, it is important to understand what a number…

  • Improve Dashboards with Stock Images
    2021年6月29日

    Improve Dashboards with Stock Images

    With a recent addition in Excel , it is now possible to access and include stock images into your Excel spreadsheet…

  • Sum All Negative Numbers
    2021年6月1日

    Sum All Negative Numbers

    If you need to sum all the negative numbers in Excel, a good function to know is the SUMIFS function. It has multiple…

  • Average Excluding Outliers in Excel
    2021年5月18日

    Average Excluding Outliers in Excel

    Your average not making sense? Perhaps you need to average excluding outliers in MS Excel to get a more realistic…

  • Add Happy Face Emoji
    2021年5月4日

    Add Happy Face Emoji

    If you want to, you can add the happy face emoji into Excel. There is an easy way to do it 2 simple steps.

  • Line break within a cell as the delimiter
    2021年4月20日

    Line break within a cell as the delimiter

    You may come across situations where you need to use a line break as the delimiter in Text to Columns in Excel. A line…

社区洞察

其他会员也浏览了