Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Support forum, Jens, Instructor's MS office tips, forum answers

Forum home » Posts by Jens (Trainer)

Posts by Jens (Trainer)

1 active questions allocated to this trainer

RepliesDateAppTitle
12026 May 28Numeric ID (so never "sum", always "count") and LookUp Tags for
This may sound basic so be patient with me! My dataset has unique num

Latest 50 posts

diamond contributer[1838 posts]

DateTitle
29 May 2026RE: transpose linking sheets updating data
28 May 2026RE: Numeric ID (so never "sum", always "count") and LookUp Tags
13 May 2026RE: Data Validation Lists from Tables
28 Apr 2026RE: Single wide extract vs multiple tables
26 Apr 2026RE: First meeting with the person I'm line managing
21 Apr 2026RE: Clearing some character from one column only
15 Apr 2026RE: Last Twelve Months Actuals v Budget
15 Apr 2026RE: DAX formula ignoring blank dates
1 Apr 2026RE: highlighting if text is the same
24 Mar 2026RE: Xlookups
19 Mar 2026RE: Power Query
4 Mar 2026RE: VBA / Macros
3 Mar 2026RE: PowerBi Merging/Relationships
23 Feb 2026RE: Word, .xsl, Style formatting, bibliography
19 Feb 2026RE: DAX formula ignoring blank dates
16 Feb 2026RE: POwer BI scheduled refresh from SharePoint folder - service
12 Jan 2026RE: For Jens re course on 8/9 Jan
18 Dec 2025RE: Locking a formula
17 Dec 2025RE: IF formulas, wildcards
17 Dec 2025RE: YoY charts using measures
8 Dec 2025RE: Creating a histogram
2 Dec 2025RE: Getting unique records
7 Nov 2025RE: Using =WORKDAY.INTL to specify non-working days
20 Aug 2025RE: Countif and sumif
29 Jul 2025RE: Using a DAX query in Power BI report view
27 Jul 2025RE: Using a DAX query in Power BI report view
21 Jul 2025RE: Power query
16 Jul 2025RE: Filtering a document
10 Jul 2025RE: Power Query - Download failed
8 Jul 2025RE: Calculating "clear days"
3 Jul 2025RE: Power automate convert excel attachment to csv before saving
3 Jul 2025RE: Power automate convert excel attachment to csv before saving
2 Jul 2025RE: Excel
26 Jun 2025RE: Show 2 values from a table without showing the same value tw
26 Jun 2025RE: Pivot table. How to make the time line header in range , not
26 Jun 2025RE: Show 2 values from a table without showing the same value tw
26 Jun 2025RE: Card (New)
24 Jun 2025RE: Date format - Desktop v Workspace
13 Jun 2025RE: Future trend forecasting
13 Jun 2025RE: Freezing a format
13 Jun 2025RE: CSV files integrating to Indesign
5 Jun 2025RE: Power BI set Variable
3 Jun 2025RE: Personal reports
3 Jun 2025RE: Power BI Gateway
3 Jun 2025RE: Cypher cvs in excel
3 Jun 2025RE: Cypher cvs in excel
3 Jun 2025RE: Data preparation and analysis
3 Jun 2025RE: Personal reports
23 May 2025RE: Personal reports
16 May 2025RE: Changing a Measure we have in a data set to a unique value w

 

Training courses

98.4 % recommend us

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

See also:
Hints and tips
Forum topics

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

TrustPilot
TrustScore 4.9 / 5       2457 reviews

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

STL training logo

Formerly Best Training
© 2026 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE

Software Training London Ltd. t/a STL
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.

Registered in England and Wales.

Verified by Visa
Security verified
Microsoft Partner
Terms & Conditions Privacy & Cookie Policy Consent preferences
Server loaded in 0.48 secs.