MS Excel Toronto Meetup - How to make ready to use Excel templates - Danuta Pezda
437 بار بازدید -
پارسال
-
Learn how to AUTOMATE YOUR
Learn how to AUTOMATE YOUR EXCEL REPORTS in minutes instead of hours without copy-paste or coding: https://snapreportschamp.com/course
Get this ready-to-use Excel solution for 2 and 3 columns of Dependent Dropdown Lists:
https://solveandexcel.ca/dynamic-depe...
_______________________________________________________
Session recorded live on May 24, 2023
All pro tricks about building a template from scratch. From research to workflow, from navigation to other design tips. You'll master your dashboard skills.
---------------------
About the Speaker: Danuta Pezda
Danuta Pezda, Excel specialist. Head of Development at Someka, brings experience from a previous role as an RPA developer at IBM. Currently leading the team in creating business solutions mainly in Excel and Google Sheets at Someka.
--------------
Find more about Danuta Pezda's work and connect with her:
LinkedIn: LinkedIn: danuta-pezda
Website: www.someka.net
YouTube: somekaexcelsolutions
Use this promo code: TORONTO15 and enjoy of %15 off for all ready-to-use templates
-----------------------------------------------------------------------------------------------
Timestamps
00:00:00 - Celia Alves MS Excel Toronto news and upcoming events
00:07:10 - Celia Introduces Danuta Pezda
00:08:00 - Danuta introduces herself and the presentation
00:13:55 - The subject of the template; how to approach building a template; draft stage
00:18:35 - Technical Part; Best Practices; Problems with Macros in templates; differences with using Mac; Template examples; Excel version compatibility
00:28:00 - Examples using Conditional Formatting; drop down lists; slicers; dynamic charts
00:43:20 – Mac Examples; differences for templates between Windows and Mac
00:51:40 – Questions
01:04:10 – Data validation; message boxes; issues with dates; system and language settings; csv file differences
01:28:05 – Visualization best practices; chart type; fonts and formatting; chart property settings
01:37:15 – Best practices continued; array formulas; consider user adds or remove rows/columns; Test your files/template ‘checklist’
01:48:45 – Questions
01:58:00 – Wrap up by Danuta and Celia
Get this ready-to-use Excel solution for 2 and 3 columns of Dependent Dropdown Lists:
https://solveandexcel.ca/dynamic-depe...
_______________________________________________________
Session recorded live on May 24, 2023
All pro tricks about building a template from scratch. From research to workflow, from navigation to other design tips. You'll master your dashboard skills.
---------------------
About the Speaker: Danuta Pezda
Danuta Pezda, Excel specialist. Head of Development at Someka, brings experience from a previous role as an RPA developer at IBM. Currently leading the team in creating business solutions mainly in Excel and Google Sheets at Someka.
--------------
Find more about Danuta Pezda's work and connect with her:
LinkedIn: LinkedIn: danuta-pezda
Website: www.someka.net
YouTube: somekaexcelsolutions
Use this promo code: TORONTO15 and enjoy of %15 off for all ready-to-use templates
-----------------------------------------------------------------------------------------------
Timestamps
00:00:00 - Celia Alves MS Excel Toronto news and upcoming events
00:07:10 - Celia Introduces Danuta Pezda
00:08:00 - Danuta introduces herself and the presentation
00:13:55 - The subject of the template; how to approach building a template; draft stage
00:18:35 - Technical Part; Best Practices; Problems with Macros in templates; differences with using Mac; Template examples; Excel version compatibility
00:28:00 - Examples using Conditional Formatting; drop down lists; slicers; dynamic charts
00:43:20 – Mac Examples; differences for templates between Windows and Mac
00:51:40 – Questions
01:04:10 – Data validation; message boxes; issues with dates; system and language settings; csv file differences
01:28:05 – Visualization best practices; chart type; fonts and formatting; chart property settings
01:37:15 – Best practices continued; array formulas; consider user adds or remove rows/columns; Test your files/template ‘checklist’
01:48:45 – Questions
01:58:00 – Wrap up by Danuta and Celia
پارسال
در تاریخ 1402/03/05 منتشر شده
است.
437
بـار بازدید شده