Upskill Office
banner
upskilloffice.bsky.social
Upskill Office
@upskilloffice.bsky.social
24 followers 12 following 37 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 Media Videos Starter Packs
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
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
Do you want to make the sheet tabs in your Excel workbooks a little more expressive? Adding emojis to your sheet tab names can make navigation more intuitive and give your workbooks a touch of personality! youtube.com/shorts/oNo6g...

#excel #exceltips #exceltutorial #emojis #ms365 #msoffice #office
Emojis in Excel sheet names
YouTube video by Upskill Office
youtube.com
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
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
ZoomIt is now part of the free Microsoft Powertoys product, and provides a range of features to enhance your presentations and software demonstrations.

youtu.be/3AwfTJ60AeU

#microsoft #windows #office #ms365 #powerpoint #teams #presentations #powertoys
---------------------------
ZoomIt is now part of Microsoft Powertoys, with features to enhance presentations and software demos
YouTube video by Upskill Office
youtu.be
500 YouTube subscribers! Thanks to everyone supporting Upskill Office, more content will be coming soon! 🎉
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
--------------
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
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
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
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
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
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
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
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
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
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
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
See how Microsoft Word paragraphs and tables can easily be sorted regardless of whether they contain text, numbers or dates. Tables can be sorted by one or more columns.

youtube.com/shorts/iRqnL...

#microsoft #windows #ms365 #msoffice #office #word #paragraphs #tables #sorting
Sort Paragraphs and Tables in Microsoft Word
YouTube video by Upskill Office
youtube.com
Simple reordering of paragraphs and lists in PowerPoint and Word. Use keyboard shortcuts to quickly and easily reorder paragraphs and bulleted / numbered lists in PowerPoint and Word. It also work for tables in Word.

www.youtube.com/shorts/4XQlY...

#microsoft #ms365 #office #word #powerpoint
Simple reordering of paragraphs and lists in PowerPoint and Word
YouTube video by Upskill Office
www.youtube.com