12 Top Speakers and 5 Masterclasses - in the event program The international conference "Bulgaria Excel Days 2022 - The Most Recent Trends in Excel for Business, Data Analysis and Visualisation, Power
The Most Recent Trends in Excel for Business, Data Analysis and Visualisation, Power BI Solutions, Financial Modelling, VBA Best Practices, and many more…
Bulgaria Excel Days 2022 is organized by ITraining, with the kind support of Microsoft Bulgaria.
9, 10, 11, 12 November
Bulgaria Excel Days 2022
Inspirational speakers, master classes, new knowledge, important information from leading world experts
The event focuses mainly on corporate participants - business representatives from leading Bulgarian companies and large foreign companies in Bulgaria, as well to professionals from abroad dealing with Microsoft Excel, Power BI, Data Visualization, VBA, Financial Modelling and Analysis. The participants in Bulgaria Excel Days 2017, 2018, and 2019 were representatives of various corporate and business sectors (most of the middle and high-level managers).
Any business manager or business professional, in any field of business, whether sales, marketing, finance, logistics, statistics, analysis, market research, sociological research, accounting and auditing, online or offline business, traditional or internet advertising, CRM, Project management, B2B or B2C, will gain a lot of valuable new knowledge and receive useful, important and relevant information from leading global experts in the field of Microsoft Excel, Power BI, Power Query, Power Pivot (DAX), Data Visualization, VBA, Financial Modeling and Analysis with Excel and their use for business purposes.
11 lectures by leading world experts in Microsoft Excel, Power BI, Power Query, Power Pivot (DAX), Data Visualization, VBA, Financial Modelling and Analysis with Excel,, all of them – awarded by Microsoft's most prestigious award - Microsoft Most Valuable Professional (MVP); 5 Masterclassес of the world-known Excel, Power BI and Data Analysis experts; Opportunity for business networking and personal communication with the lecturers of the conference; 2 coffee breaks and an official cocktail for the conference participants; Certificate of attendance of the Conference / participation in masterclasses.
The conference visitors will be pleased to meet the exceptional Chandoo (Purna Chandra Rao Duggirala) - one of the legends in the global Excel community. As well with internationally recognized authorities in the industry such as Jon Peltier, Cristiano Galvão, Jordan Goldmeier, Tim Heng, Alan Murray, OZ du Soleil, Gasper Kamensek, Tony de Jonker, Charles Williams, Faraz Shaikh.
This new edition of Bulgaria Excel Days will review the latest news and current trends in Microsoft Excel, Power BI, Power Query, Power Pivot (DAX), Data Visualization, VBA, Financial Modeling, and Analysis with Excel and their use for business purposes.
14 x Microsoft MVP
Chandoo (New Zealand) also known as Purnachandra Rao Duggirala, is the real guru and legend in the Microsoft Excel world. He is also extremely colorful and funny as a person.
His site Chandoo.org is read by millions every year. It has over 500,000 monthly views and about 200,000 regular readers from all over the world. Chandoo YouTube channel has more than 230 000 subscribers
His life mission is "to make you awesome in Excel".
Chandoo has authored over 700 articles, 3 books and trained more than 20,000 individuals in different courses on Excel, Power Query, Power Pivot, and VBA. He is passionate about Data Analytics and Visualization as well. Chandoo has regular engagements as a speaker, course facilitator, and business consultant all around the world.
Chandoo has an MBA from the Indian Institute of Management in Indore and a Computer Science Degree from Andhra University - Vizag, India.
Now he lives with his family in New Zealand.
The topic of his lecture at the conference is: "Automate boring data tasks with Power Query: How to use "Functions" in Power Query to automate repetitive tasks easily"
And the topic of his Мasterclass is:
“Dynamic Arrays in Excel - a Deep-dive”
20 x Microsoft MVP
Jon Peltier (USA) is the president and owner of Peltier Technical Services. The company produces commercial and custom programs for information visualization and productivity improvement, primarily as Microsoft Excel add-ins.
He also provides training in advanced Excel topics related to charting, VBA programmability., and interaction with other applications.
The PeltierTech blog and website feature excellent in-depth charting tutorials dealing predominantly with Excel charts and
Jon holds a Doctor of Science degree from MIT and has over 20 years of experience in R&D, manufacturing, and production support, in the aerospace, automotive, and industrial parts industries. Jon’s background includes Statistics, Total Quality, and Six Sigma.
.Jon Peltier is also a writer and is one of the authors of the book “Excel Insights- A Microsoft MVP Guide To The Best Parts Of Excel”.
The topic of his lecture at the conference is: "The best Excel Charting Tips and Tricks"
Description:
Some practical ways to make Excel’s capabilities work for you while you are visualizing data, including data arrangements, formulas, formatting, and maybe some neat new Microsoft 365 features. These techniques may seem like tricks until you know how they work.
And the topic of his Мasterclass is:
“Advanced Charting in Microsoft Excel”
7 x Microsoft MVP
Oz (USA) is Excel Trainer & Instructor, Data Management Consultant for more than 15 years. Excel developer, blogger, speaker, trainer, videographer, YouTube and social media star, raconteur, patient mentor, funny and quirky guy…
He has developed a passion for clean data and reliable reporting. An even greater passion - of teaching, sharing knowledge, and empowering people to do handle their data more efficiently and with greater skill to turn their data into useful information.
Oz teaches public and private Excel workshops in the Chicago area, leads workshops at the University of Illinois-Chicago and Northwestern University, speaker at Microsoft Ignite Chicago; author of the book, Guerrilla Data Analysis 2nd Ed., co-written with Mr. Excel - Bill Jelen.
His blog, DataScopic.net focuses mainly on aspects of data literacy that keep people from making the most effective use of Excel and getting what they need from their data.
Oz is US Navy Veteran, graduated BA in Philosophy from the University of IL-Chicago and the Kennedy School of Government at Harvard University.
Microsoft Excel MVP since 2015.
The topic of his lecture at the conference is:
"New, Sexy & Dangerous: Catching up on Excel latest features"
3 x Microsoft MVP
Cristiano Galvao (Brazil) is a Data Analyst and Instructor with a strong background in Excel, VBA, and Power Query and two decades of working experience in IT and Office software. His mission is to help people organize data and translate it into meaningful and useful information
Cristiano Galvao is the founder and organizer of the Excel Weekend, a conference that started locally and became one of the major annual and global events about Microsoft Excel and data analysis. In Latin America.
Currently studying an MBA in Data Science & Analytics, being involved with Machine Learning, Spatial Analysis, Python, and R Language.
Cristiano shares interesting ideas and tutorials on YouTube, LinkedIn, Facebook, Instagram, Twitter, and TikTok.
The topic of his lecture at the conference is: "Building the custom functions, demystifying LAMBDA"
4 x Microsoft MVP
Tim Heng (Australia) has over 15 years of experience in developing and reviewing financial models across a range of industries and sectors, throughout Australia and internationally. He works to develop bespoke modeling solutions for business challenges, using a combination of Excel, VBA, Power BI, and database analytics.
He has worked across the world, with big corporate clients and financial institutions in Australia, Canada, Hong Kong, Indonesia, Japan, Malaysia, New Zealand, Singapore, United Kingdom, United States, and Vietnam, as well as numerous projects based throughout Africa.
Tim has been a regular presenter at conferences, training courses, and webinars for Certified Practising Accountants Australia (CPAA) and Chartered Accountants Australia New Zealand (CAANZ). He is a frequent host of the Financial Modelling World Cup live competitions.
Currently, he is a Director of the Australian consulting firm SumProduct.
The topic of his lecture at the conference is: "Developing Financial Models in Power BI"
Description:
If you’ve been paying attention to the world of reporting, you will have seen many people start using Power BI for all manner of reporting – both operational and financial. While operational reporting is frequently connected directly to source systems and data presented live and in real-time, financial reporting beyond single-statement (i.e. just P&L or just cash flow) is usually done by developing your financial statements in Excel, and loading the summary of those into Power BI in order to provide charts and create dashboards.
Imagine being able to take your base financial statements, and reproduce them by product, by the customer, by geography, etc. Your limitations are restricted to the granularity of your underlying data. If you build your statements elsewhere and import them in, how can you drill down to that level of detail? In what we believe is a world first, we are rewriting the process. Come join us on the journey.
And the topic of his Мasterclass is:
“Financial Modelling and Analysis with Microsoft Excel”
9 x MVP
Jordan Goldmeier is one of the leading global minds on data science. He is an entrepreneur, author and speaker., owner of „ Anarchy Data“, a data consulting agency.
He is the author of popular books including Dashboards for Excel, Advanced Excel Essentials, Becoming a Data Head, and Data Smart
His work has been cited by and quoted in the Associated Press, Bloomberg BusinessWeek, Dice News, and American Express OPEN Forum.
Jordan has served as a volunteer Emergency Medical Technician and is an adjunct instructor at Wake Forest University.
The topic of his lecture at the conference is: “Amazing Dashboards with Excel and VBA”
5 x Microsoft MVP
Gasper Kamenšek (Slovenia) is BI Consultant, Trainer, Excel and Power BI expert, and owner of Excel Olympics. Speaker at more than 50 conferences and events, Trainer with more than 900 courses and seminars. When he is not lecturing Excel, Gasper works into various BI projects consisting either of PowerPivot and SQL with Excel or VBA. His passion in Excel made him start an Excel blog in 2014. It’s called Excel Unplugged. Microsoft MVP since 2015.
Gasper’s hobbies are music and photography.
The topic of his lecture at the conference is: "The perfect Calendar Table for Power BI reporting (The how and the why)"
Description:
In the process of building Power BI reports and Dashboards, there are quite a few limitations we must be aware of. These are usually game stoppers once you run into them. But what if we thought of them ahead of time?
In this session, we will create a calendar table that will enable us to build a perfect Power BI report in mind.
And the topic of his Мasterclass is:
“Advanced DAX (become a filter context ninja)”
14 x Microsoft MVP
Charles (UK) is an Excel expert who specializes in performance — he is a world leader at making Excel go faster. One of his specialties is making your VBA UDFs (User Defined Functions) more efficient. After leaving IBM in 1996, he founded a Microsoft Office consultancy and software development company - Decision Models. His particular interest areas are: Excel Calculation performance, VBA UDFs & VBA Performance, Excel JS API, Large Excel model, Excel Defined Names, Excel as frontend to Relational Databases, C++ XLLs.
Charles is co-author with Jan Karel Pieterse of Name Manager, a widely-used utility for managing Excel defined names, and author of FastExcel, a commercial product to help optimize Excel calculation speed.
He is the developer of Lambda Explorer, the FastExcel Addin Family, and others.
Microsoft MVP for Excel since 2009.
The topic of his lecture at the conference is: "Developing and Debugging Lambdas and Lets"
And the topic of his Мasterclass:
Excel Hackaton: "Developing Excel VBA Addins: the LET Wizard addin"
2 x Microsoft MVP
Alan Murrey (UK) is an Excel Expert, Microsoft Trainer, and business consultant for over 20 years. He runs his own site and YouTube channel named Computergaga. Also, he is an organizer of the monthly Excel meetup in London.
Alan is an author of the popular book "Advanced Excel Success: A Practical Guide to Mastering Excel " showing how to get to the next level in your Excel journey. In addition, he also contributes regularly writing articles for the How-To Geek, Go Skills, Career Foundry, and running courses on Udemy.
The topic of his lecture at the conference is "Functions 2.0 – the Awakening of the Sleeping Giants"
Description:
The introduction of the Dynamic Array engine is one of the greatest updates in Excel history. The function family was bolstered by the birth of UNIQUE, XLOOKUP, STOCKHISTORY, VSTACK and others, but existing functions also rejoiced.
You see, some functions were waiting for this day, the day that they were no longer constrained by Excel’s inability to natively handle arrays.
In this session, we focus on these functions. We will see multiple examples to showcase some of the key functions that were rejuvenated by the dynamic array engine. Welcome to functions 2.0.
2 x Microsoft MVP
Faraz (Saudi Arabia) is Microsoft MVP, Microsoft Certified Trainer, Microsoft Office Master, Certified Excel Expert, Microsoft Innovative Educator.
His mission is to help the community by providing the easiest exciting solutions with Microsoft Applications which can make their daily task Quicker & Easier.
He is the founder of Saudi Arabia's Microsoft Excel & Power Platform Meetup and organizer (together with Ilgar Zarbaliyev) of the My Data Summit international conference.
The topic of his lecture at the conference is: "Report Automation with Office Scripts & Power Automate"
Description:
Automation is the future of the workplace. In our daily routine tasks, we do a lot of repetitive tasks which can be easily handled by the system. I strongly believe that systems are made for humans, not humans are made for the system. In my presentation, we will see how Office Scripts can help us ease without having knowledge of coding. Once click record office script can do a lot of magic to your Excel Workbook and make it more powerful. We will also, integrate the office scripts to power automate which is another Microsoft Office Application.
10 x Microsoft MVP, Microsoft Regional Director
Mihail Mateev is a Member of the Microsoft Regional Director Program, Microsoft Certified Trainer, Microsoft MVP - Data Platform & Microsoft Azure.
Strong professional skilled in .Net, C#, JavaScript, Visual Basic, Cloud Computing, Microsoft Azure, Microsoft Data Platform, GIS, and Computer-Aided Design (CAD), PASS CEE Mentor. Senior Solutions Architect & Senior Technical Evangelist @ EPAM Systems, Chairman of the Board of Bulgarian Software Community Association.
Mihail Mateev has Ph.D. in Cloud Computing, he is the administrator of many events like SQLSaturday Sofia, SQLSaturday Plovdiv, Azure Bootcamp Bulgaria, IoT Summit Bulgaria, JSTalks Bulgaria, JS Saturday Bulgaria, SharePoint Saturday Bulgaria, UXify Bulgaria, and jQuery Bulgaria.
The topic of his lecture is "Creating O365 Office Scripts with TypeScript in a Nutshell".
7 x Microsoft MVP
Microsoft Certified Trainer with more than 15 years experience as an IT instructor and Consultant.
Certifications she has: Місrоѕоft Оffісе Ѕресіаlіѕt Маѕtеr (МОЅ Маѕtеr), Місrоѕоft Сеrtіfіеd ІТ Рrоfеѕѕіоnаl (МСІТР), Місrоѕоft Сеrtіfіеd Тесhnісаl Ѕресіаlіѕt fоr Місrоѕоft Рrојесt Ѕеrvеr (МСТЅ), Місrоѕоft Сеrtіfіеd Тесhnісаl Ѕресіаlіѕt fоr Місrоѕоft Рrојесt (МСТЅ).
Five years Microsoft MVP for Excel.
In 2008 she is awarded among the TOP 25 of the best instructors in Microsoft World Company business evaluation and measurement - Knowledge Advisors.
Speaker of at numerous Мicrosoft events in Bulgaria, USA, Spain, Nederland, Australia, United Kingdom.
Founder and administrator of the user group Microsoft Office Bulgaria for Microsoft Bulgaria.
Founder and organizer of “Bulgaria Excel Days” – one of the biggest global events dedicated to Microsoft Excel.
Owner and CEO of the company for Microsoft Training and IT business consulting - ITraining Ltd.
The topic of hеr lecture at the conference is:
"Parameters or custom functions in Power Query"
The Most Recent Trends in Excel for Business, Data Analysis and Visualisation, Power BI Solutions, Financial Modelling, VBA Best Practices, and many more…
12 Top Speakers and 5 Masterclasses - in the event program The international conference "Bulgaria Excel Days 2022 - The Most Recent Trends in Excel for Business, Data Analysis and Visualisation, Power
Master up your Excel skills Chandоо, John Peltier, Tim Heng, Gasper Kamenschek and Charles Williams will hold Мasterclasses at the Bulgaria Excel Days 2022. Masterclasses are full-day practical advanced Excel seminars, for
The Central Military Club is a multifunctional building in the center of Sofia. It is located at the crossroads of two main roads in Sofia - Rakovski Street and Tsar Osvoboditel Blvd.
Trolleybus № 9, stop "Alexander Nevski Square", № 1, 2, 5, 8, Sofia University "St. Kliment Ohridski" stop
Bus № 84,94, 184, Sofia University "St. Kliment Ohridski" stop
Metro, lines M1, M4, Sofia University "St. Kliment Ohridski" staion.
9, 10, 11, 12 November 2022
Central Military club, Sofia