-
About The Speaker
Celia Alves is an Excel Business Solutions Developer, certified by Microsoft as Excel Expert. She loves to design and build solutions combining Excel, VBA, Power Query and Power Pivot to automate tasks, analyze data and model business processes.
With an academic background in Mathematics and Education and 20-years of experience as a high school Mathematics teacher, Celia combined her passion for teaching with her experience as Excel Consultant to offer free tutorials on YouTube and a Training Program to help professionals automate their Excel recurring tasks.
She firmly believes that automating routine Excel reporting procedures saves money and resources for companies, improves their workflows and promotes a happier work environment by offering their staff the opportunity to contribute with more valuable and meaningful work to their organizations. Celia is also a speaker and the founder and leader of the MS Excel Toronto Meetup Group. For her contribution to the community, she has been awarded MVP by Microsoft in 2020 and every year after that in the category Office Apps and Services. -
Summit Session
The Excel features and skills you need to automate a reporting procedure
07th September 2022 | 16:05 to 17:00 hrs – Azerbaijan Time (GMT +4)
Routine reporting procedures are part of a business's daily life. Many reporting procedures involve Excel, either from beginning to end of the procedure or when dealing with one or more of the process steps. [Excel can be used for data entry, combining and preparing data coming from different sources, analyzing data and producing the outputs needed. Those outputs can be of various formats and serve a wide variety of multiple purposes. Some output examples are the analysis results presented in one or multiple spreadheads, statements produced in Excel or PDF format that possibly need to be sent by email to stakeholders, CSV files that will be fed to other programs to load batches of information in one go, Excel Dashboards, Power BI Reports and PowerPoint Presentations.]
When dealing with these processes, companies and professionals often realize that the manual work involved in their reporting procedures takes too much time and is prone to errors, all of which are highly costly for the company. So why do companies keep using these procedures? One reason is that they do not know that Excel can solve many of their reporting procedure challenges. Other times, they understand Excel's capability to solve those problems; however, they do not know which Excel features to use and how to combine them to eliminate manual work from their reporting procedures. Celia will reveal her top list of Excel skills and features needed to automate the most common Excel reporting procedures.