Tanya Pemberton - Excel Consultant, Bespoke Trainer & Admin Support

  • Home
  • Tanya Pemberton - Excel Consultant, Bespoke Trainer & Admin Support

Tanya Pemberton - Excel Consultant, Bespoke Trainer & Admin Support Contact information, map and directions, contact form, opening hours, services, ratings, photos, videos and announcements from Tanya Pemberton - Excel Consultant, Bespoke Trainer & Admin Support, Information Technology Company, .

Excel Consultant, Bespoke Trainer & Admin Support
โ€ข In-office usage assessments carried out.
โ€ข Bespoke training offered to all levels and abilities.
โ€ข Admin support available for all your Excel needs.

Accessibility Text:๐Ÿ“Š ๐Œ๐ฒ ๐…๐š๐ฏ๐จ๐ฎ๐ซ๐ข๐ญ๐ž ๐…๐จ๐ซ๐ฆ๐ฎ๐ฅ๐š ๐…๐ข๐ง๐ ๐จ๐Ÿ ๐ญ๐ก๐ž ๐ƒ๐š๐ฒ: ๐Ÿ† ๐Œ๐€๐—๐ˆ๐…๐’ ๐Ÿ† Iโ€™m currently using it to create motivational stat...
13/05/2026

Accessibility Text:
๐Ÿ“Š ๐Œ๐ฒ ๐…๐š๐ฏ๐จ๐ฎ๐ซ๐ข๐ญ๐ž ๐…๐จ๐ซ๐ฆ๐ฎ๐ฅ๐š ๐…๐ข๐ง๐ ๐จ๐Ÿ ๐ญ๐ก๐ž ๐ƒ๐š๐ฒ:

๐Ÿ† ๐Œ๐€๐—๐ˆ๐…๐’ ๐Ÿ†

Iโ€™m currently using it to create motivational stats for lifting weights at the gym. ๐Ÿ˜Š

โœจ ๐–๐ก๐š๐ญ ๐ข๐ญ ๐๐จ๐ž๐ฌ:
MAXIFS returns the largest value that matches one or more conditions.

๐Ÿงฎ ๐’๐ฒ๐ง๐ญ๐š๐ฑ:
=MAXIFS(max_range, criteria_range1, criteria1, [criteria_range2, criteria2]โ€ฆ)

Example query -
Return my largest weight lifted for a specific activity and date

=MAXIFS(Weights_lifted_range, Date_range, Date, Activity_range, Activity)

๐Ÿ’ก ๐Ž๐ญ๐ก๐ž๐ซ ๐ฎ๐ฌ๐ž๐ฌ:
Find the highest sales amount for a specific region, employee, or product without needing filters or pivot tables.

๐Ÿ™Œ ๐–๐ก๐ฒ ๐ˆ ๐ฅ๐จ๐ฏ๐ž ๐ข๐ญ:
I didn't know this one existed until I went looking for a way to quickly return the highest value based on certain criteria - such as date, and exercise type. It's exactly what I needed.

๐ˆ๐Ÿ ๐ฒ๐จ๐ฎ ๐ฐ๐จ๐ฎ๐ฅ๐ ๐ฅ๐ข๐ค๐ž ๐ก๐ž๐ฅ๐ฉ ๐ฐ๐ข๐ญ๐ก ๐ญ๐ก๐ข๐ฌ ๐Ÿ๐จ๐ซ๐ฆ๐ฎ๐ฅ๐š ๐จ๐ซ ๐š๐ง๐ฒ ๐จ๐ญ๐ก๐ž๐ซ๐ฌ, ๐ฉ๐ฅ๐ž๐š๐ฌ๐ž ๐๐จ ๐ซ๐ž๐ฉ๐ฅ๐ฒ ๐ญ๐จ ๐ญ๐ก๐ข๐ฌ ๐ฉ๐จ๐ฌ๐ญ, ๐จ๐ซ ๐ฌ๐ž๐ง๐ ๐ฆ๐ž ๐š ๐ฆ๐ž๐ฌ๐ฌ๐š๐ ๐ž.

Address


Website

Alerts

Be the first to know and let us send you an email when Tanya Pemberton - Excel Consultant, Bespoke Trainer & Admin Support posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Contact The Business

Send a message to Tanya Pemberton - Excel Consultant, Bespoke Trainer & Admin Support:

Shortcuts

Share