Upskill Office

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

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

YouTube video by Upskill Office PowerToys New+ now lets you use variables to customise filenames

A wishlist item in my previous New+ video, as of PowerToys v0.90 this tool now lets you use variables to customise the names of new files!

youtu.be/CeqpTG9WGtc

#microsoft #windows #powertoys #newplus #ms365 #msoffice #office #excel #word #powerpoint #contextmenu #files #templates #productivity

YouTube video by Upskill Office Use Excel's XLOOKUP to return a specific value or cumulative total from a grid with two criteria

How to use Excel's XLOOKUP function to return a specific value, or cumulative total, using two criteria from a grid of data.

youtu.be/vTdPzrx7Tk8

#microsoft #windows #office #ms365 #excel #xlookup #sumif #data #grid

YouTube video by Upskill Office ZoomIt is now part of Microsoft Powertoys, with features to enhance presentations and software demos

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
---------------------------

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

Spreadsheet errors can have disastrous consequences – yet we keep making the same mistakes Spreadsheet-related errors can have serious consequences in the private and public sector. But what can we do to overcome them?

This article that I wrote on #spreadsheet #error in Jan 2024 has had about 140K reads. When you google spreadsheet error, it is the 2nd hit! Sounds like success and impact to me! theconversation.com/spreadsheet-... #excel #risk

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

YouTube video by Upskill Office Sort Paragraphs and Tables in Microsoft Word

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

YouTube video by Upskill Office Simple reordering of paragraphs and lists in PowerPoint and Word

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

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

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

YouTube video by Upskill Office Restore document properties & personal info in #excel , #word and #powerpoint files #msoffice

Remove and reinstate document properties and personal information in Excel, Word and PowerPoint

youtube.com/shorts/go-N5...

#microsoft #ms365 #msoffice #office #excel #word #powerpoint #documentproperties #privacy

YouTube video by Upskill Office Excel's New Focus Cell Feature

Currently available in MS365's Beta Channel, the Focus Cell feature will highlight the active cell's row and column in a user-customisable colour.

youtube.com/shorts/Z1l0m...

#microsoft #ms365 #msoffice #office #excel #focuscell

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

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

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

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

Apply a consistent font theme to your documents with header & body fonts that can be easily changed. Using fonts this way also allows you to quickly customise a template for clients with different font branding.

youtu.be/qjIPNNQk48I

#ms365 #msoffice #office #excel #word #powerpoint #font #themes