www.myonlinetraininghub.com Open in urlscan Pro
192.124.249.160 Public Scan

Back to summary

URL:
https://www.myonlinetraininghub.com/conditional-formatting-pivottables?awt_a=f2Zj&awt_l=HtX3S&awt_m=hUmT2Lyv.vVR.Zj
Submission: On September 10 via api (September 10th 2024, 2:15:14 pm UTC) from US — Scanned from DE

Form analysis
5 forms found in the DOM

GET https://www.myonlinetraininghub.com/

<form class="search-form" method="get" action="https://www.myonlinetraininghub.com/" role="search"><label class="search-form-label screen-reader-text" for="searchform-1">Search site</label><input class="search-form-input" type="search" name="s"
    id="searchform-1" placeholder="Search..." required=""><button class="search-form-submit button-secondary" type="submit" value="Search"><span class="screen-reader-text">Submit search</span><svg xmlns="http://www.w3.org/2000/svg"
      viewBox="0 0 512 512" class="search-form-submit-icon" width="24" height="24"><!-- Font Awesome Pro 5.15.3 by @fontawesome - https://fontawesome.com License - https://fontawesome.com/license (Commercial License) -->
      <path
        d="M508.5 468.9L387.1 347.5c-2.3-2.3-5.3-3.5-8.5-3.5h-13.2c31.5-36.5 50.6-84 50.6-136C416 93.1 322.9 0 208 0S0 93.1 0 208s93.1 208 208 208c52 0 99.5-19.1 136-50.6v13.2c0 3.2 1.3 6.2 3.5 8.5l121.4 121.4c4.7 4.7 12.3 4.7 17 0l22.6-22.6c4.7-4.7 4.7-12.3 0-17zM208 368c-88.4 0-160-71.6-160-160S119.6 48 208 48s160 71.6 160 160-71.6 160-160 160z">
      </path>
    </svg></button>
  <meta content="https://www.myonlinetraininghub.com/?s={s}">
</form>

POST https://www.myonlinetraininghub.com/wp-comments-post.php

<form action="https://www.myonlinetraininghub.com/wp-comments-post.php" method="post" id="commentform" class="comment-form" novalidate="">
  <p class="comment-notes"><span id="email-notes">Your email address will not be published.</span> <span class="required-field-message">Required fields are marked <span class="required">*</span></span></p>
  <p class="comment-form-comment"><label for="comment">Comment <span class="required">*</span></label> <textarea id="comment" name="comment" cols="45" rows="8" maxlength="65525" required=""></textarea></p>
  <p class="comment-form-author"><label for="author">Name <span class="required">*</span></label> <input id="author" name="author" type="text" value="" size="30" maxlength="245" autocomplete="name" required=""></p>
  <p class="comment-form-email"><label for="email">Email <span class="required">*</span></label> <input id="email" name="email" type="email" value="" size="30" maxlength="100" aria-describedby="email-notes" autocomplete="email" required=""></p>
  <p class="comment-form-url"><label for="url">Website</label> <input id="url" name="url" type="url" value="" size="30" maxlength="200" autocomplete="url"></p>
  <p class="comment-form-cookies-consent"><input id="wp-comment-cookies-consent" name="wp-comment-cookies-consent" type="checkbox" value="yes"> <label for="wp-comment-cookies-consent">Save my name, email, and website in this browser for the next time
      I comment.</label></p>
  <p class="form-submit"><input name="submit" type="submit" id="submit" class="submit" value="Post Comment"> <input type="hidden" name="comment_post_ID" value="16577" id="comment_post_ID">
    <input type="hidden" name="comment_parent" id="comment_parent" value="0">
  </p>
  <p class="comment-form-ant-spm" style="clear: both; display: none;">
    <strong>Current ye@r</strong> <span class="required">*</span>
    <input type="hidden" name="ant-spm-a" id="ant-spm-a" value="2024">
    <input type="text" name="ant-spm-q" id="ant-spm-q" size="30" value="2.2">
  </p>
  <p class="comment-form-ant-spm-2" style="display:none;">
    <strong>Leave this field empty</strong>
    <input type="text" name="ant-spm-e-email-url" id="ant-spm-e-email-url" size="30" value="">
  </p>
</form>

#

<form role="search" action="#" autocomplete="off" aria-label="Search form">
  <input type="search" class="orig" placeholder="Search 500+ posts here..." name="phrase" value="" aria-label="Search input" autocomplete="off">
  <input type="text" class="autocomplete" name="phrase" value="" aria-label="Search autocomplete input" aria-hidden="true" tabindex="-1" autocomplete="off" disabled="">
</form>

Name: options —

<form name="options" class="asp-fss-flex" aria-label="Search settings form" autocomplete="off">
  <input type="hidden" name="current_page_id" value="16577">
  <input type="hidden" name="woo_currency" value="USD">
  <input type="hidden" name="qtranslate_lang" value="0">
  <input type="hidden" name="filters_changed" value="0">
  <input type="hidden" name="filters_initial" value="1">
  <div style="clear:both;"></div>
</form>

POST #

<form action="#" method="post" novalidate="novalidate" autocomplete="new-password">
  <div class="tve_lead_generated_inputs_container tve_clearfix tve_empty_dropzone">
    <div class="tve_lg_input_container tve_lg_input" data-css="tve-u-11644b189fa4afe">
      <input type="email" data-field="email" data-required="1" data-validation="email" name="email" placeholder="Type Your Email Here" data-placeholder="Type Your Email Here" class="">
    </div>
    <div class="tve_lg_input_container tve_submit_container tve_lg_submit" data-css="tve-u-12644b189fa4aff">
      <button type="submit" class="" style=""><span class=""><strong>Download My eBook</strong></span></button>
    </div>
  </div>
  <input id="_submit_option" type="hidden" name="_submit_option" value="redirect"><input id="_back_url" type="hidden" name="_back_url" value="https://www.myonlinetraininghub.com/exit-thank-you"><input id="_autofill" type="hidden" name="_autofill"
    value=""><input id="_sendParams" type="hidden" name="_sendParams" value=""><input id="_api_custom_fields" type="hidden" name="_api_custom_fields"
    value="YToxMDp7aTowO2E6Mjp7czoyOiJpZCI7czo0OiJuYW1lIjtzOjExOiJwbGFjZWhvbGRlciI7czo0OiJOYW1lIjt9aToxO2E6Mjp7czoyOiJpZCI7czo1OiJwaG9uZSI7czoxMToicGxhY2Vob2xkZXIiO3M6NToiUGhvbmUiO31pOjI7YToyOntzOjI6ImlkIjtzOjEyOiJtYXBwaW5nX3RleHQiO3M6MTE6InBsYWNlaG9sZGVyIjtzOjQ6IlRleHQiO31pOjM7YToyOntzOjI6ImlkIjtzOjExOiJtYXBwaW5nX3VybCI7czoxMToicGxhY2Vob2xkZXIiO3M6MzoiVVJMIjt9aTo0O2E6Mjp7czoyOiJpZCI7czoxMzoibWFwcGluZ19yYWRpbyI7czoxMToicGxhY2Vob2xkZXIiO3M6NToiUmFkaW8iO31pOjU7YToyOntzOjI6ImlkIjtzOjE0OiJtYXBwaW5nX3NlbGVjdCI7czoxMToicGxhY2Vob2xkZXIiO3M6ODoiRHJvcGRvd24iO31pOjY7YToyOntzOjI6ImlkIjtzOjE2OiJtYXBwaW5nX2NoZWNrYm94IjtzOjExOiJwbGFjZWhvbGRlciI7czo4OiJDaGVja2JveCI7fWk6NzthOjI6e3M6MjoiaWQiO3M6MTY6Im1hcHBpbmdfdGV4dGFyZWEiO3M6MTE6InBsYWNlaG9sZGVyIjtzOjg6IlRleHRhcmVhIjt9aTo4O2E6Mjp7czoyOiJpZCI7czoxMjoibWFwcGluZ19maWxlIjtzOjExOiJwbGFjZWhvbGRlciI7czoxMToiRmlsZSB1cGxvYWQiO31pOjk7YToyOntzOjI6ImlkIjtzOjE0OiJtYXBwaW5nX2hpZGRlbiI7czoxMToicGxhY2Vob2xkZXIiO3M6NjoiSGlkZGVuIjt9fQ=="><input
    type="hidden" id="tve_mapping" name="tve_mapping" value="YTowOnt9"><input type="hidden" id="tve_labels" name="tve_labels" value="YToxOntzOjU6ImVtYWlsIjtzOjIwOiJUeXBlIFlvdXIgRW1haWwgSGVyZSI7fQ==">
</form>

Text Content

 * Skip to main content
 * Skip to header right navigation
 * Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

Menu
 * Courses
 * Pricing
   * Free Courses
   * Business Intelligence & Data Analysis
     * Power BI Course
     * Excel Dashboard Course
     * Excel Power Query Course
     * Power Pivot and DAX Course
     * Excel PivotTable Course – Quick Start
     * Excel PivotTable Course
     * Financial Modelling Course
   * Microsoft Office
     * Excel Expert Advanced Excel Training
     * Advanced Excel Formulas Course
     * Excel, Word, PowerPoint
     * Microsoft Word Course
     * Microsoft PowerPoint Course
     * Excel Tables Course
   * Excel Specialist Courses
     * Excel for Customer Service Professionals
     * Excel for Operations Management Course
     * Excel for Decision Making Under Uncertainty Course
     * Excel for Finance Course
     * Excel Analysis ToolPak Course
   * Multi-User Pricing
 * Resources
   * Free Downloads
   * Excel Functions Explained
   * Excel Formulas
   * Excel Add-ins
   * IF Function
     * Excel IF Statement Explained
     * Excel IF AND OR Functions
     * IF Formula Builder
   * Time & Dates in Excel
     * Excel Date & Time
     * Calculating Time in Excel
     * Excel Time Calculation Tricks
     * Excel Date and Time Formatting
   * Excel Keyboard Shortcuts
   * Excel Custom Number Format Guide
   * Pivot Tables Guide
   * VLOOKUP Guide
   * ALT Codes
   * Excel VBA & Macros
   * Excel User Forms
   * VBA String Functions
 * Blog
 * Excel Webinars
 * Excel Forum
   * Forum Login
   * Register as Forum Member
 * Members
   * My Courses
   * Support
   * Sign Out
 * Search
   Search siteSubmit search
 * 0
   $0

 * Courses
 * Pricing Sub Menu
   * Free Courses
   * Business Intelligence & Data Analysis Sub Menu
     * Power BI Course
     * Excel Dashboard Course
     * Excel Power Query Course
     * Power Pivot and DAX Course
     * Excel PivotTable Course – Quick Start
     * Excel PivotTable Course
     * Financial Modelling Course
   * Microsoft Office Sub Menu
     * Excel Expert Advanced Excel Training
     * Advanced Excel Formulas Course
     * Excel, Word, PowerPoint
     * Microsoft Word Course
     * Microsoft PowerPoint Course
     * Excel Tables Course
   * Excel Specialist Courses Sub Menu
     * Excel for Customer Service Professionals
     * Excel for Operations Management Course
     * Excel for Decision Making Under Uncertainty Course
     * Excel for Finance Course
     * Excel Analysis ToolPak Course
   * Multi-User Pricing
 * Resources Sub Menu
   * Free Downloads
   * Excel Functions Explained
   * Excel Formulas
   * Excel Add-ins
   * IF Function Sub Menu
     * Excel IF Statement Explained
     * Excel IF AND OR Functions
     * IF Formula Builder
   * Time & Dates in Excel Sub Menu
     * Excel Date & Time
     * Calculating Time in Excel
     * Excel Time Calculation Tricks
     * Excel Date and Time Formatting
   * Excel Keyboard Shortcuts
   * Excel Custom Number Format Guide
   * Pivot Tables Guide
   * VLOOKUP Guide
   * ALT Codes
   * Excel VBA & Macros
   * Excel User Forms
   * VBA String Functions
 * Blog
 * Excel Webinars
 * Excel Forum Sub Menu
   * Forum Login
   * Register as Forum Member
 * Members Sub Menu
   * My Courses
   * Support
   * Sign Out
 * 0
   $0


CONDITIONAL FORMATTING PIVOTTABLES

You are here: Home / Excel PivotTables / Conditional Formatting PivotTables
April 29, 2014 by Mynda Treacy

Conditional Formatting in PivotTables has its ups and downs. Unfortunately I
find them mostly ‘downs’ but let’s not dwell on the negative as the few ‘ups’
might still make it worthwhile depending on your needs.


THE UPSIDE OF CONDITIONAL FORMATTING PIVOTTABLES

When you apply Conditional Formatting to the Values area of your PivotTable the
formatting will automatically expand/contract as you add new data or make
changes to the filters, rows or columns.

In other words, the Values area becomes a dynamic range for the Conditional
Format without you having to do any extra work. Nice....and just as it should
be.

Here’s a little diagram so you know what I mean by ‘the values area’ etc.:



In the above PivotTable I have applied Conditional Formatting to highlight the
top month for each column (except the Grand Total… in some instances that’s a
downside since you might want the top month overall highlighted too).


HERE’S A STEP BY STEP HOW TO:

1. Select any cell in the values area of your PivotTable

2. On the Home tab of the Ribbon select Conditional Formatting > Top/Bottom
Rules > Top 10 Items:



3. Set the value to 1 and choose your format:



4. You will now have an icon beside the cell that you have applied the
formatting to. Click on it and select ‘All cells showing “Sum of Sales “ values
for “Month” and “Category”:



5. Then click on the Conditional Formatting button on the Home tab of the Ribbon
and select Manage Rules. This will open the Rules Manager dialog box:



Notes on the image above:

a) Notice how the rule has a PivotTable icon at the far left. This is an
indicator to let you know that this rule is applied to a PivotTable. If you’re
familiar with Conditional Formatting you’ll know that rules applied to regular
cells don’t have this icon.

b) The other thing to note is the ‘Applies to’ is a list of the PivotTable
fields as opposed to a range of cells. When you see this you know that the range
will dynamically update with any changes you make to the PivotTable.

6. Ok, moving on, click on the rule and then click the ‘Edit Rule’ button
(labelled 'c' in the image above) which opens the dialog box below:



Tip: here you can also change the ‘Apply Rule to…’ we did back in step 4.

7. Click on the down arrow beside ‘all values’ and choose ‘each Row group’ >
click OK > click OK again.

This will result in the top sales for each column (except the Grand Total) of
your PivotTable being highlighted like so:



Now when you change the filters, add new data, or move the column/row fields
around, the Conditional Formatting follows.

For example, changing the PivotTable Date Grouping to include Quarters results
in the Top 1 result for each column per quarter being highlighted, without me
changing the Conditional Formatting rules at all:



Why stop there? Actually you should stop but this is an example of what you can
do, not what you should do so I’m going to make it a bit gaudier and apply
formatting to the top 3 quarters next:



Now I have 2 rules in my CF manager; one for the top 3 quarters and one for the
top 1 result for each column every quarter:




WANT MORE?

Ok, I’ll give you more, but be warned the overuse of formatting might burn your
audience’s retinas so proceed with caution.

You can actually use any of the built in Conditional Formatting rules covered
here, except these ones you can see greyed out in the menu below:




THE DOWN SIDE OF CONDITIONAL FORMATTING PIVOTTABLES

What say I want to highlight the ‘Sum of Sales’ amount for all instances of Qtr2
in the Row Labels, as I have done below:



My rule for the above formatting looks like this =$A3=”Qtr2” as you can see
below in the CF Rules Manager:



a) Notice the absence of the PivotTable icon in the far left. This is the first
indication that Excel doesn’t recognise this as being applied to a PivotTable
and,

b) The ‘Applies to’ range doesn’t have the PivotTable fields listed. Instead it
is an absolute cell range. So as you change the PivotTable layout or add new
data, this range is likely to become fragmented and you may get inconsistent
results.


THE BOTTOM LINE

If you want to use any logic rules that rely on the Row or Column labels be
prepared to update the ‘Applies to’ range each time you refresh the PivotTable
or make any changes that alter the size.

This is a pretty big downside since some of the most useful Conditional Formats
are applied based on the TRUE/FALSE outcome of formulas. Sure the built in rules
are ok, but I mostly tend to use formulas to define my formats.

Side note: You might be thinking that you can just set up a dynamic named range
to use in your ‘Applies to’ criteria for the Conditional Format however, as soon
as you enter a dynamic named range in the ‘Applies to’ field and press ok, Excel
converts the range to cell references rendering it non-dynamic (is that a
word?). Ugh! Frustrating, yes, and a pretty big downside.

The only way I know of to get around this is with VBA, but it’s complicated and
I’ve run out of time to cover it here. I’ll try to persuade Phil to address this
in one of his future VBA posts.



AUTHOR Mynda Treacy Co-Founder / Owner at My Online Training Hub

CIMA qualified Accountant with over 25 years experience in roles such as Global
IT Financial Controller for investment banking firms Barclays Capital and
NatWest Markets.

Mynda has been awarded Microsoft MVP status every year since 2014 for her
expertise and contributions to educating people about Microsoft Excel.

Mynda teaches several courses here at MOTH including Excel Expert, Excel
Dashboards, Power BI, Power Query and Power Pivot.




MORE CONDITIONAL FORMATTING POSTS


CONDITIONAL FORMATTING IN POWER BI TABLES AND MATRICES

How to apply conditional formatting to tables and matrices in Power BI. Use
color, icons, data bars and URL's.


EXCEL PROJECT MANAGEMENT DASHBOARD

Excel project management dashboard video tutorial covering various techniques
including conditional formatting, PivotTables, Slicers, charts and more.


HIGHLIGHT SELECTED CELLS IN EXCEL AND PRESERVE CELL FORMATTING

Use shapes to highlight the selected cells in Excel & preserve cell formatting.
Won't affect conditional formatting, borders, colors etc.


EXCEL CONDITIONAL FORMATTING GANTT CHART

You can build a Conditional Formatting Excel Gantt Chart easily with just a few
WORKDAY.INTL formulas and relative references.


EXCEL CONDITIONAL FORMATTING WITH FORMULAS

Excel conditional formatting with formulas can be super confusing when you don't
follow these three simple rules that ensure they work everytime.


EXCEL FACTOR 10 CONDITIONAL FORMATTING PAINTING BY NUMBERS




EXCEL FACTOR 8 HIGHLIGHT CELLS CONTAINING FORMULAS

Automatically highlight cells containing formulas in Excel to reduce the chance
of them being deleted or over-written


HOW TO USE EXCEL CONDITIONAL FORMATTING

Excel Conditional Formatting examples and workbook.


MORE EXCEL PIVOTTABLE POSTS


SHOW REPORT FILTER PAGES FOR POWER PIVOT PIVOTTABLES

PivotTables created from Power Pivot can't use the 'Show Report Filter Pages'
option. But this piece of VBA allows you to do just that.


AUTOMATING AND EMAILING PIVOT TABLE REPORTS

Automate the creation and distribution of pivot table reports with some VBA.
Send reports to multiple email recipients using Outlook.


HIDE BLANKS IN EXCEL PIVOTTABLES

Hide blanks in Excel PivotTables caused by empty cells in your source data. I’m
talking about PivotTable cells containing the (blank) placeholder.


DISPLAY MISSING DATES IN EXCEL PIVOTTABLES




FILTER EXCEL PIVOT TABLES BY VALUES




EXCEL PIVOTTABLE MONTH COMPARISON [VIDEO]

Excel PivotTable Month Comparison is easy with the Show Values As tool.


EXCEL PIVOTTABLE ADD PERCENTAGE OF TOTAL COLUMN [VIDEO]

Excel PivotTable Add Percentage of Total Column is easy via the Show Values As
settings.


EXCEL FACTOR 6 AUTO REFRESH PIVOTTABLES




EXCEL FACTOR ENTRY 1 – REVERSE PIVOTTABLE




MORE EXCEL PIVOTTABLES POSTS


CUSTOM SORT EXCEL SLICERS

Use these tricks to custom sort Excel Slicer buttons enabling them appear in a
specific order that suits your needs.


12 PIVOTTABLE FORMATTING TIPS

Create PivotTables that don’t look like PivotTables with these really easy
PivotTable Formatting tips and tricks.


IMAGES IN EXCEL PIVOTTABLES

Include images in Excel PivotTables, combined with some slick formatting, and
create dynamic and visually rich PivotTables like never before.


AUTO REFRESH PIVOTTABLES

Auto Refresh PivotTables isn’t on by default, and the process differs depending
on if your PivotTables is loaded to the data model or not.


SHOW ITEMS WITH NO DATA IN PIVOTTABLES

Show Items with no Data in PivotTables allows you to maintain a constant
structure to your PivotTable or Pivot Chart axis when filtering.


FORCE EXCEL SLICERS TO SINGLE SELECT

There's no build in way to force Excel Slicers to single select but we can use
these clever warnings to persuade your users.


EXCEL PIVOTTABLE PROFIT AND LOSS

Creating an Excel PivotTable Profit and Loss Statement means you can use Slicers
and Conditional Formatting and have the P&L automatically update.


EXCEL PIVOTTABLE FIELD LIST TIPS

Customize the Excel PivotTable Field List to suit your needs. Find how to turn
the PivotTable Field List on and off and other handy tips.


HIDE BLANKS IN EXCEL PIVOTTABLES

Hide blanks in Excel PivotTables caused by empty cells in your source data. I’m
talking about PivotTable cells containing the (blank) placeholder.


EXCEL SLICER FORMATTING

Excel Slicer Formatting is essential because they’re big and chunky. In this
tutorial I show you the tricks to make Excel Slicers small.


Category: Excel PivotTablesTag: conditional formatting, Excel PivotTable
Previous Post:Excel Chart Templates
Next Post:Is Your Line Chart Lying?


READER INTERACTIONS


COMMENTS

 1. Martin Nolan
    
    May 1, 2014 at 10:03 am
    
    Although you cannot use a dynamic range in the “Applies to” field, you can
    use one in the “Rule” formula. This allows one to use a small bit of VBA in
    the form of a UDF to check for a range intercept to turn on the conditional
    formatting. The same trick can be used with pivot table fields if one
    doesn’t mind using additional VBA to set the dynamic ranges. The down side
    is that the conditional formatting area has to be set as large as the
    largest expected area of the dynamic ranges. I’ll forward an example
    separately. The alternative, of course, is to use VBA to both set the
    dynamic ranges and to apply the conditional formatting to the ranges after
    each update.
    
    Reply
    
    * Mynda Treacy
      
      May 1, 2014 at 12:41 pm
      
      Thanks for sharing, Martin. I’ve attached your file here if anyone wants
      to see what you’ve done.
      
      Cheers,
      
      Mynda.
      
      Reply
      
    

 2. Bryan
    
    April 30, 2014 at 8:46 pm
    
    It’s a shame that PivotTables are so easy to work with and yet… so hard to
    work with! I love the quick work they make of data summaries, but then
    trying to visualize that data becomes a pain at best.
    
    Reply
    
    * Mynda Treacy
      
      April 30, 2014 at 8:52 pm
      
      I know! It feels like when they give with one hand they take with the
      other 🙂
      
      That’s when GETPIVOTDATA is your friend cause you can take that ugly
      PivotTable and make it presentable.
      
      Mynda.
      
      Reply
      
    
    * Saad
      
      July 24, 2024 at 12:02 am
      
      Very fruitful vedio
      
      Reply
      
      * Mynda Treacy
        
        July 24, 2024 at 10:04 am
        
        Great to hear, Saad!
        
        Reply
        
      
    

 3. Jeff
    
    April 30, 2014 at 3:13 pm
    
    That’s a nice simple tip to quickly create that kind of formatting. Thanks
    for sharing.
    
    Reply
    
    * Mynda Treacy
      
      April 30, 2014 at 3:16 pm
      
      Cheers, Jeff 🙂
      
      Reply
      
    


LEAVE A REPLY CANCEL REPLY

Your email address will not be published. Required fields are marked *

Comment *

Name *

Email *

Website

Save my name, email, and website in this browser for the next time I comment.



Current ye@r *

Leave this field empty


SIDEBAR


Search




More results...






POPULAR CONTENT

 * 10 Common Excel Mistakes to Avoid
 * Top Excel Functions for Data Analysts
 * Secrets to Building Excel Dashboards in Less Than 15 Minutes
 * Pro Excel Formula Writing Tips
 * Hidden Excel Double-Click Shortcuts
 * Top 10 Intermediate Excel Functions
 * 5 Pro Excel Dashboard Design Tips
 * 5 Excel SUM Function Tricks
 * 239 Excel Keyboard Shortcuts

Download Free Tips & Tricks

Download Free PDF

Hi, I'm Mynda Treacy and I run MOTH with my husband, Phil. Through our blog,
webinars, YouTube channel and courses we hope we can help you learn Excel, Power
Pivot and DAX, Power Query, Power BI, and Excel Dashboards.

BLOG CATEGORIES

 * AI in Excel
 * Excel
 * Excel Charts
 * Excel Dashboard
 * Excel Formulas
 * Excel Office Scripts
 * Excel PivotTables
 * Excel Shortcuts
 * Excel VBA
 * General Tips
 * Online Training
 * Outlook
 * Power Apps
 * Power Automate
 * Power BI
 * Power Pivot
 * Power Query
 * Word

Sign up to our newsletter and join over 400,000
others who learn Excel and Power BI with us.

 

COMPANY

 * About My Online Training Hub
 * Disclosure Statement
 * Frequently Asked Questions
 * Guarantee
 * Privacy Policy
 * Terms & Conditions
 * Testimonials
 * Become an Affiliate
 * Sponsor Our Newsletter


SUPPORT

 * Contact
 * Forum
 * Helpdesk – For Technical Issues

Copyright © 2024 · My Online Training Hub · All Rights Reserved. Microsoft and
the Microsoft Office logo are trademarks or registered trademarks of Microsoft
Corporation in the United States and/or other countries. Product names, logos,
brands, and other trademarks featured or referred to within this website are the
property of their respective trademark holders.




Download A Free Copy of 100 Excel Tips & Tricks

Download My eBook

We respect your privacy. We won’t spam you.

x
My Online Training Hub
Daten- und Cookie-Einwilligung
Um eine persönlichere Benutzererfahrung zu bieten, verwenden wir und unsere
217 Partner
Technologien wie Cookies, um Geräteinformationen zu speichern und/oder darauf
zuzugreifen. Indem Sie auf „Akzeptieren“ klicken, stimmen Sie der Verwendung
dieser Technologien zu, die es uns und
unseren Partnern
ermöglichen, personenbezogene Daten wie IP-Adresse, eindeutige ID und
Browsing-Daten auf dieser Website zu verarbeiten.
Um Ihre Einwilligungseinstellungen zu verwalten, klicken Sie bitte auf die
Schaltfläche "Einstellungen verwalten". Sie können Ihre
Einwilligungseinstellungen jederzeit widerrufen oder aktualisieren, indem Sie
unten auf der Website auf den Link „Datenschutzeinstellungen aktualisieren“
klicken.
Wir verwenden Ihre Daten, um: Auf einem Gerät auf Informationen zuzugreifen
und/oder zu speichern; Begrenzte Daten zur Auswahl von Werbung zu verwenden;
Profile für personalisierte Werbung zu erstellen; Profile zur Auswahl von
personalisierter Werbung zu verwenden; Profile zur Personalisierung von Inhalten
zu erstellen; Profile zu verwenden und personalisierte Inhalte auszuwählen; Die
Werbeleistung zu verbessern; Die Leistung von Inhalten zu messen; Zielgruppen
durch Statistiken oder Kombinationen von Daten aus verschiedenen Quellen zu
verstehen; Services zu entwickeln und zu verbessern; Begrenzte Daten zur Auswahl
von Inhalten zu verwenden; Für Sicherheit zu sorgen, Betrug zu erkennen und zu
verhindern und Fehler zu erkennen; Werbung und Inhalte bereitzustellen und zu
präsentieren; Datenschutzoptionen zu kommunizieren und zu speichern.
Einstellungen verwalten
Akzeptieren

Aktualisieren Sie die Datenschutzeinstellungen
0
Review Your Cart

Your Cart is Empty

Find a course

Got a discount code?

Apply

Subtotal
$0
Taxes may be re-calculated at checkout


Pay with
Checkout
$0
Continue Shopping

Select options





76 Shares
Share
Tweet
Pin
Share
Share
Print
Share
Email
Share

www.myonlinetraininghub.com Open in urlscan Pro 192.124.249.160 Public Scan

Form analysis 5 forms found in the DOM