Upskill Office
LightNews LightNews
banner
upskilloffice.bsky.social
Upskill Office
@upskilloffice.bsky.social
24 followers 12 following 38 posts
✨ Transform your work! Subscribe for video tutorials on data analysis, creating eye-catching and informative presentations, and software tips and tricks. ✨

https://youtube.com/@upskilloffice
https://linktr.ee/upskilloffice
Posts Replies Media Videos
upskilloffice.bsky.social
Some of the essential functions that every finance professional should master. Whether you're forecasting cash flows, building budgets, or analysing scenarios, these will help save you time and make your models robust. youtu.be/sK6SzyvssMg

#excel #exceltips #exceltutorial #xlookup #xmatch #msoffice
November 10, 2025 at 7:58 PM
upskilloffice.bsky.social
Excel’s new =Copilot() function promises to revolutionise how we work with data — but is it really the solution for every spreadsheet task?

youtu.be/lTGvUs6y6Cg

#excel #exceltips #exceltutorial #ai #copilot #copilotfunction #msoffice #office
October 10, 2025 at 10:52 AM
upskilloffice.bsky.social
Excel automatically calculates stats like Sum, Average and Count in its taskbar which can quickly be copied and pasted elsewhere with just one click!

youtube.com/shorts/9UPgA...

#excel #exceltips #exceltutorial #ms365 #msoffice #office
September 23, 2025 at 6:20 PM
upskilloffice.bsky.social
Stop struggling with Excel formulas, trace and fix those errors fast! Whether you're dealing with #! errors or formulas returning unexpected results, here's how to trace and fix the problems using Excel’s built-in tools.

youtu.be/Aeq2lg7fOCk

#excel #exceltips #exceltutorial #formulaerrors #ms365
August 17, 2025 at 7:26 AM
upskilloffice.bsky.social
Five steps for getting the most out of Excel if you work with it every day

youtu.be/HB6XSJjLK3A

#microsoft #windows #ms365 #msoffice #office #excel #spreadsheet #workflow #productivity
June 10, 2025 at 9:45 PM
upskilloffice.bsky.social
A critical part of building robust and reliable spreadsheet models is to incorporate error-checking formula. Here's how to do it using data verification and validation techniques in Excel

youtu.be/X2GhuEAWSWA

#ms365 #msoffice #office #excel #spreadsheet #workbook #data #validation #verification
May 18, 2025 at 7:04 PM
upskilloffice.bsky.social
500 YouTube subscribers! Thanks to everyone supporting Upskill Office, more content will be coming soon! 🎉
February 14, 2025 at 7:51 AM
upskilloffice.bsky.social
From optimising your setup to keyboard shortcuts, this bite-size video contains a collection of tips and tricks to help improve your work with Excel 😊.
youtu.be/725d4FzKHXA

#microsoft #office #ms365 #excel #productivity #lifehacks #shortcuts #workflow
--------------
January 28, 2025 at 7:42 PM
upskilloffice.bsky.social
This short video demonstrates, with the help of two statistical data sets (one containing a dinosaur!), why you should chart your data whenever possible to identify outlying items that may be distorting your analysis.
youtu.be/k50ZvDoEGP8

#excel #data #charts #graphs #anscombesquarter #datasaurus
January 6, 2025 at 10:58 PM
upskilloffice.bsky.social
Excel GROUPBY and PIVOTBY functions: What you need to know to use them effectively, pros and cons versus Pivot Tables, and how I managed to crash Excel with PIVOTBY!
youtu.be/eykj3O4XCiQ

#microsoft #ms365 #msoffice #office #excel #groupby #pivotby #pivottables #dynamicarrays
December 16, 2024 at 8:05 PM
upskilloffice.bsky.social
In an upcoming video, an in-depth look at GROUPBY and PIVOTBY, I managed to get one of these functions to repeatedly crash Excel. Something to watch out for!

#microsoft #ms365 #msoffice #office #excel #groupby #pivotby #dynamicarrays
December 14, 2024 at 1:02 PM
upskilloffice.bsky.social
Copy text from images in Microsoft Windows with software you may already have! Even if you don't have MS365 / Office installed, the Snipping Tool is part of Windows 11 and PowerToys is free software.
youtu.be/KSS6-YrY0hs

#microsoft #ms365 #word #onenote #powertoys #snippingtool #imagetotext #ocr
November 27, 2024 at 5:06 PM
upskilloffice.bsky.social
Looking to transform your data into meaningful insights? Apply these eight Gestalt principles when designing your visualisations, dashboards and infographics!

youtu.be/Gc_lMk6ehFs

#microsoft #ms365 #msoffice #office #excel #powerpoint #powerbi #chart #dashboard #gestalt #design
November 21, 2024 at 1:09 PM
upskilloffice.bsky.social
Word's 'Shrink to Fit' command will try and reduce your multi-page document to just one page.

youtube.com/shorts/-whRf...

#microsoft #ms365 #msoffice #office #word #shrinktofit #fitonepage
November 16, 2024 at 6:15 PM
upskilloffice.bsky.social
Make alignment of multiple charts in an Excel workbook quicker and easier by using the "Snap to Grid" feature. This also works with other Excel objects such as shapes.

youtube.com/shorts/5Fa9v...

#microsoft #ms365 #msoffice #office #excel #charts #snaptogrid
November 16, 2024 at 6:11 PM
upskilloffice.bsky.social
I've been working with Excel for THIRTY YEARS! These are my ten steps for building great spreadsheet models.

youtu.be/YYwdn2iePkM

#microsoft #ms365 #msoffice #office #excel #spreadsheet #workbook #financialmodelling
November 16, 2024 at 6:09 PM
upskilloffice.bsky.social
Ensure team members know who should be providing input and where in a collaborative slide deck by using name markers that can be checked off once work is complete.

youtube.com/shorts/5eRjN...

#microsoft #ms365 #msoffice #office #powerpoint #teamwork #slidedeck #presentation
November 16, 2024 at 6:02 PM
upskilloffice.bsky.social
If you need to add information to your slide deck without displaying it in the presentation, and don't want to bury it in the notes section of each slide, try adding 'virtual sticky notes' using PowerPoint shapes.

youtube.com/shorts/lgRHA...

#microsoft #ms365 #msoffice #powerpoint
November 16, 2024 at 6:01 PM
upskilloffice.bsky.social
Excel's Checkbox feature: Now available for all MS365 subscribers on the Current channel. It provides in-cell checkboxes that can be clicked by users, or have their status controlled by a formula in the cell itself.

youtu.be/iIM8EQsDMQM

#ms365 #msoffice #excel #checkboxes
November 16, 2024 at 5:56 PM
upskilloffice.bsky.social
PowerToys New+: Use your own templates to create new files from the windows context menu. Add files of any type, and even create new folders of files at the click of a button.

www.youtube.com/watch?v=FwYZ...

#microsoft #windows #powertoys #newplus #files #templates #productivity
November 16, 2024 at 5:17 PM
upskilloffice.bsky.social
Use standard & custom keyboard shortcuts to level up your productivity skills! If you're constantly reaching for the mouse or trackpad to find and click the same command options, follow the steps in this video to save time.

www.youtube.com/watch?v=eI4O...

#shortcuts #autohotkey #elgato #streamdeck
November 16, 2024 at 5:15 PM
upskilloffice.bsky.social
If you need to distribute an Excel-based Gantt chart within your project team, here's one more useful than most of the basic templates available.

youtu.be/5dGEiWbaHYM

#microsoft #ms365 #msoffice #office #excel #gantt #project #projectplan #dynamicarrays
November 16, 2024 at 4:50 PM
upskilloffice.bsky.social
Use the Workspaces feature in Microsoft's PowerToys software to capture the size and position of open application windows, and relaunch them with one-click.

youtu.be/I1gn6qsBdIY

#microsoft #powertoys #workspaces #desktopmanagement #opensource
November 16, 2024 at 4:48 PM
upskilloffice.bsky.social
Use Excel's new TRIMRANGE function and Trim References to remove leading and trailing blank rows and columns from a data range.

youtu.be/ufGJjtsXRZs

#ms365 #msoffice #office #excel #trimrange #trimrefs
November 16, 2024 at 4:47 PM
upskilloffice.bsky.social
Whilst you can use theme font styles in Office / MS365 to standardise fonts in your documents, what if you've inherited documents containing a mess of fonts which need to changed? This video will help!

youtu.be/jmM9onnBGgQ

#ms365 #msoffice #office #excel #word #powerpoint #fonts
November 16, 2024 at 4:26 PM