- Видео 22
- Просмотров 11 861
Upskill Office
Великобритания
Добавлен 7 май 2024
✨ Transform your work! Subscribe for tutorials on data analysis, creating eye-catching and informative presentations, and software tips and tricks. ✨
Create amazing Excel, PowerPoint and Power BI data visualisations with Gestalt design principles
Gestalt psychology is a theory of perception that emphasises the processing of entire patterns and configurations, not just individual components.
Apply the principles discussed in this video to communicate messages quickly and clearly in your visualisations, dashboards and infographics.
00:00 - Intro
01:11 - Proximity
01:31 - Similarity
02:21 - Enclosure
02:48 - Closure
03:14 - Figure Ground
04:36 - Continuation
05:12 - Connection
05:34 - Common Fate
Intro music: "Pitbull" by Michael Ramir C.
mixkit.co/
#microsoft #ms365 #msoffice #office #excel #powerpoint #powerbi #chart #dashboard #gestalt #design
Apply the principles discussed in this video to communicate messages quickly and clearly in your visualisations, dashboards and infographics.
00:00 - Intro
01:11 - Proximity
01:31 - Similarity
02:21 - Enclosure
02:48 - Closure
03:14 - Figure Ground
04:36 - Continuation
05:12 - Connection
05:34 - Common Fate
Intro music: "Pitbull" by Michael Ramir C.
mixkit.co/
#microsoft #ms365 #msoffice #office #excel #powerpoint #powerbi #chart #dashboard #gestalt #design
Просмотров: 151
Видео
I've been working with Excel for 30 YEARS. Here are my 10 steps for building great spreadsheets
Просмотров 8 тыс.14 дней назад
It's coming up to 30 years since I first used Excel, and both it and I have developed a lot since then! In this video I go through: * Why you need good quality workbooks, and some horror stories from the press! * Some good sources for background reading on best practices in spreadsheet development. * Ten steps which, based on my learning and experiences, will provide a good foundation for devel...
Excel's Checkboxes: Best use cases for Excel models
Просмотров 259Месяц назад
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. I'll walk you through the basics, including formatting options, then dive into three examples of how the checkboxes can be used within more complex Excel models. Please check the co...
PowerToys New+: Use your own templates to create new files from the windows context menu
Просмотров 429Месяц назад
The 'New ' module introduced to Microsoft PowerToys in v0.85.0 allows you to add your own custom templates to a new menu option in the Windows context (right-click) menu. Add files of any type, and even create new folders of files at the click of a button. You even add digits / dots / spaces to the start of your filenames, to control the order of templates in your New menu, then choose not to d...
Use standard and custom keyboard shortcuts to level up your productivity skills!
Просмотров 102Месяц назад
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 and maybe even automate some tasks with the press of a key! Although the video focuses on Windows software and shortcuts, similar principles apply for Mac/Linux. 00:00 - Intro 00:28 - Step 1 00:48 - Step 2 02:02 - Step 3 04:17 - Step 4 07:04 - Step 5 10...
Excel Gantt Chart with milestones and moving timeline, using standard or Dynamic Array formula
Просмотров 1272 месяца назад
My longest video to date! If you need to distribute an Excel-based Gantt chart within your project team, consider creating one more useful than some of the basic templates available. This video shows you how to include: * Two-colour task bars indicating the percentage complete/incomplete of each task * In-cell data bars for the percentage complete column, so you can visualise in one column the ...
Launch applications to custom positions and configurations with Microsoft PowerToys Workspaces
Просмотров 1,3 тыс.2 месяца назад
Use the new Workspaces feature in Microsoft's open source PowerToys software to capture the size and position of open application windows, and relaunch them with one-click. Microsoft PowerToys is a suite of powerful utilities designed to streamline productivity for business users on Windows. It offers advanced customization tools that improve workflow efficiency, from managing windows and remap...
Excel's new TRIMRANGE function and Trim References will remove leading and trailing blanks from data
Просмотров 3472 месяца назад
Excel's new TRIMRANGE function and Trim References will remove leading and trailing blanks from data
Find and replace fonts in Excel, Word and Powerpoint
Просмотров 272 месяца назад
Find and replace fonts in Excel, Word and Powerpoint
Apply easily changeable font styles to your Excel, Word and PowerPoint documents using Theme Fonts
Просмотров 372 месяца назад
Apply easily changeable font styles to your Excel, Word and PowerPoint documents using Theme Fonts
How to embed PDF files into MS Office documents and ensure others can successfully open them
Просмотров 483 месяца назад
How to embed PDF files into MS Office documents and ensure others can successfully open them
How I batch converted 100+ Word documents to the latest file format without third party tools
Просмотров 373 месяца назад
How I batch converted 100 Word documents to the latest file format without third party tools
Make your Excel, Word & PowerPoint documents stand out with custom colour palettes
Просмотров 394 месяца назад
Make your Excel, Word & PowerPoint documents stand out with custom colour palettes
Create dynamic KPI graphics in PowerPoint slide decks using Excel charts
Просмотров 815 месяцев назад
Create dynamic KPI graphics in PowerPoint slide decks using Excel charts