Faraz Shaikh
🛠 Handling 📅 Date & Time ⏳ In Excel (PART 02) ‼️
updated
⏱ Time Stamp
00:00 Intro
01:27 About the Data Table?
04:15 Highlight the data on the Data Table
05:40 End
Danielle Stein Fairhurst - @plumsolutions
https://plumsolutions.com.au/
--------------------------------------------------------------
🛒 Affiliate links :
- Support me with your Amazon purchases: amzn.to/3tR4AUN
- Buy Office365: bit.ly/3nKcbnk
📣 Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so you're helping me keep my blog up and running and you're helping me provide for my family 👨👩👧👦 so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
--------------------------------------------------------------
🌎 https://www.ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
excelexciting.com/forums
--------------------------------------------------------------
Join our Meetup group, Saudi Arabia, Microsoft Excel & PowerPlatform Meetup
meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------------------------------------------
👍🏻 Like Facebook Page :
facebook.com/ExcelExciting
👥Join The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
You can check the following videos as well
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks #datatable
Join Belinda for this presentation of Cool Power BI Interactions to Excel and super cool Excel Secrets that Belinda still uses to this day.
---------------------------
About the Speaker
---------------------------
Belinda Allen is a Microsoft Most Valuable Professional (MVP) for Power BI. Belinda is also a Microsoft Certified Trainer (MCT), Speaker, and the Co-Author of 2 books on Business Intelligence and Microsoft Dynamics GP. Belinda focuses on Microsoft Fabric, but is still working with the Microsoft Power Platform, happily wearing the title #CitizenDeveloper.
Being the Director of Enablement for iLink Digital, Belinda daily focuses on her personal mission statement, “To Improve the Lives and Success of my customers and partners.”
--------------------------------
Connect with Speaker
--------------------------------
Website : https://www.MsBelindaAllen.com
Blog : ilink-digital.com
LinkedIn : linkedin.com/in/msbelindaallen
YouTube : youtube.com/MsBelindaAllen
Twitter : twitter.com/MsBelindaAllen
Meetup : meetup.com/members/12901251
-----------------------------------------------------
Tentative Agenda (subject to change)
-----------------------------------------------------
- 07:55 pm ZOOM Meeting opens to attendees to begin joining
- 08:00 pm - 08:10 pm Welcome and meeting overview
- 08:10 pm - 09:30 pm Feature Presentation by Speaker
- 09:30 pm - 10:00 pm Meeting Wrap-up (Only Available on ZOOM)
------------------
Registration
------------------
This meet-up will be hosted on ZOOM and will be recorded to share with others who were not able to attend live. You must RSVP for the event in order to access the ZOOM Meeting link.
-------------------------
Joining the event
-------------------------
The link will be visible only if you RSVP beforehand.
**NOTE: As mentioned above, this event will be recorded and shared online, so attendee information may be visible in the recording.
This is an online event and will begin at 08:00 pm (Saudi Arabian Standard Time).
In this session we are going to talk about some of the insightful and still not known commands in Excel. We know that Excel is a spreadsheet program possessing a vast variety of functionalities and let's discover its powerful sides together!
---------------------------
About the Speaker
---------------------------
I am currently working as a Group Financial Reporting and ERP Manager in one of the biggest hospitality companies in Azerbaijan. Before that, I worked in several companies in different positions (Accounts Payable Head, Senior Accountant) in Finance departments.
I am also the creator of the ""ExceLand"" Youtube channel, continuously publishing educational videos there. I am Microsoft Certified Trainer (MCT), MOS Master, expert in Microsoft Office programs (Word Expert, Power Point Expert, Excel Expert, Outlook Expert), and a professional trainer specializing in the private and mostly in corporate sector.
--------------------------------
Connect with Speaker
--------------------------------
Website : https://exceland.az/
LinkedIn : linkedin.com/in/nurana-novruzova-120a5162
YouTube : youtube.com/@ExceLandaz/videos
Facebook : facebook.com/exceland.az
-----------------------------------------------------
Tentative Agenda (subject to change)
-----------------------------------------------------
- 07:55 pm ZOOM Meeting opens to attendees to begin joining
- 08:00 pm - 08:10 pm Welcome and meeting overview
- 08:10 pm - 09:30 pm Feature Presentation by Speaker
- 09:30 pm - 10:00 pm Meeting Wrap-up (Only Available on ZOOM)
------------------
Registration
------------------
This meet-up will be hosted on ZOOM and will be recorded to share with others who were not able to attend live. You must RSVP for the event in order to access the ZOOM Meeting link.
-------------------------
Joining the event
-------------------------
The link will be visible only if you RSVP beforehand.
**NOTE: As mentioned above, this event will be recorded and shared online, so attendee information may be visible in the recording.
--------------------------
Join Meetup : meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------
This is an online event and will begin at 08:00 pm (Saudi Arabian Standard Time).
Unlock the potential of automation in your workflow! In this session, we will delve into the powerful world of Power Automate and Excel integration. Discover how these two dynamic tools can work seamlessly together to streamline tasks, boost productivity, and eliminate manual processes.
Learn the basics of Power Automate, Microsoft's robust automation platform, and explore how it empowers you to create automated workflows without the need for extensive coding knowledge. Dive into Excel, the quintessential spreadsheet software, and uncover its hidden capabilities for data manipulation and reporting.
Key Takeaways:
Understanding the fundamentals of Power Automate.
Integrating Excel with Power Automate for seamless automation.
Hands-on exercises to create your own automated workflows.
Practical tips for optimizing tasks and managing data effectively.
---------------------------
About the Speaker
---------------------------
Faraz Shaikh is a Certificated Supply Chain Professional, Microsoft Certified Trainer, Microsoft Certified Excel Expert, Microsoft Office Master, Microsoft Innovative Educator, and member of the Microsoft Creators. He is well known for his YouTube Channel “Faraz Shaikh” and website ExcelExciting.com, where he frequently writes on his blog. Faraz was the first person to start a Microsoft Excel meetup group in Saudi Arabia with meetings in Al Jubail. He is passionate to help the community discovering exciting solutions with Microsoft applications to handle daily tasks quicker and easier.
--------------------------------
Connect with Speaker
--------------------------------
LinkedIn: linkedin.com/company/ExcelExciting linkedin.com/in/fshaikh7
Website: https://www.ExcelExciting.com
YouTube: youtube.com/ExcelExciting
Twitter: twitter.com/ExcelExciting
Facebook: facebook.com/ExcelExciting
Meetup: meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
-----------------------------------------------------
Tentative Agenda (subject to change)
-----------------------------------------------------
- 07:55 pm ZOOM Meeting opens to attendees to begin joining
- 08:00 pm - 08:10 pm Welcome and meeting overview
- 08:10 pm - 09:30 pm Feature Presentation by Speaker
- 09:30 pm - 10:00 pm Meeting Wrap-up (Only Available on ZOOM)
------------------
Registration
------------------
This meet-up will be hosted on ZOOM and will be recorded to share with others who were not able to attend live. You must RSVP for the event in order to access the ZOOM Meeting link.
-------------------------
Joining the event
-------------------------
The link will be visible only if you RSVP beforehand.
**NOTE: As mentioned above, this event will be recorded and shared online, so attendee information may be visible in the recording.
This is an online event and will begin at 08:00 pm (Saudi Arabian Standard Time).
Let's create an awesome and very simple dashboard with Power BI for marketing specialists. In this session, you will be able to explore the most frequently used features of Power BI, its interaction with Power Query and very interesting visuals.
---------------------------
About the Speaker
---------------------------
I am currently working as a Group Financial Reporting and ERP Manager in one of the biggest hospitality companies in Azerbaijan. Before that, I worked in several companies in different positions (Accounts Payable Head, Senior Accountant) in Finance departments.
I am also the creator of the ""ExceLand"" Youtube channel, continuously publishing educational videos there. I am Microsoft Certified Trainer (MCT), MOS Master, expert in Microsoft Office programs (Word Expert, Power Point Expert, Excel Expert, Outlook Expert), and a professional trainer specializing in the private and mostly in corporate sector.
--------------------------------
Connect with Speaker
--------------------------------
Website : https://exceland.az/
LinkedIn : linkedin.com/in/nurana-novruzova-120a5162
YouTube : youtube.com/@ExceLandaz/videos
Facebook : facebook.com/exceland.az
-----------------------------------------------------
Tentative Agenda (subject to change)
-----------------------------------------------------
- 07:55 pm ZOOM Meeting opens to attendees to begin joining
- 08:00 pm - 08:10 pm Welcome and meeting overview
- 08:10 pm - 09:30 pm Feature Presentation by Speaker
- 09:30 pm - 10:00 pm Meeting Wrap-up (Only Available on ZOOM)
------------------
Registration
------------------
This meet-up will be hosted on ZOOM and will be recorded to share with others who were not able to attend live. You must RSVP for the event in order to access the ZOOM Meeting link.
-------------------------
Joining the event
-------------------------
The link will be visible only if you RSVP beforehand.
**NOTE: As mentioned above, this event will be recorded and shared online, so attendee information may be visible in the recording.
--------------------------
Join Meetup : meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------
This is an online event and will begin at 08:00 pm (Saudi Arabian Standard Time).
I hope you all had a great September month break, and we could not start in a better way than with a presentation by no less than three members of Microsoft's Excel team to tell us all about the new and long-awaited feature in Excel: Python.
While this might not be something for all Excel users, it might become a pivotal point in the work and careers of many professionals.
We are looking forward to meeting you on Wednesday, October 25th, at 08:00 PM AST to learn more about Python in Excel.
Python is one of the most popular programming languages today, loved by business and students alike – used for data analysis, visualization, machine learning and more. Python in Excel makes it possible to natively combine Python and Excel analytics in the same workbook – with no setup required.
With Python in Excel, you can type Python directly into a cell, the Python calculations run in the Microsoft Cloud, and your results are returned to the worksheet, including plots and visualizations.
Python in Excel leverages Anaconda Distribution for Python running in Azure, which includes the most popular Python libraries such as pandas, statsmodels, Matplotlib and seaborn.
---------------------
About the Speakers:
Ndeyanta Jallow - Product Manager
Ndeyanta Jallow is a Product Manager on the Excel team who is passionate about empowering the world to make data-driven decisions. Prior to joining Excel, she worked in financial services and strategic consulting.
Chris Gross - Product Manager
Chris Gross is a Product Manager on Excel who is passionate about combining the principles of programming with the world of Excel. Some highlights include LET, LAMBDAs, Data Types, Excel Labs, and now Python in Excel.
Keyur Patel- Technical Program Manager
Keyur Patel is a Program Manager at Microsoft, and he loves Python and Excel. He's spent his whole career wearing different hats and roles, all centered around making data and logic more accessible to everyone through the magical canvas that is Excel. He's super excited to see what the community will build, now that we have Python *in* Excel!
---------------------
Find more about their work and connect with them:
Website: aka.ms/python-in-excel
Blog: Announcing Python in Excel (microsoft.com)
---------------------
-----------------------------------------------------
Tentative Agenda (subject to change)
-----------------------------------------------------
- 07:55 pm ZOOM Meeting opens to attendees to begin joining
- 08:00 pm - 08:10 pm Welcome and meeting overview
- 08:10 pm - 09:30 pm Feature Presentation by Speaker
- 09:30 pm - 10:00 pm Meeting Wrap-up (Only Available on ZOOM)
In the rapidly evolving world of business, few dare to craft their empire from a tool as simple, yet powerful, as a spreadsheet.
Meet Traci Williams, the ingenious mind behind “Excel Ace"", an exciting venture that began as mere cells, columns, and rows back in 2008.
With a keen eye for data and an unparalleled passion and enthusiasm for Excel, Traci turned the seemingly mundane world of spreadsheets into a thriving business model.
Join Traci as she unravels the journey of her spreadsheet-based business, offering insights, challenges, and the magic behind turning grids into gold.
---------------------------
About the Speaker
---------------------------
I LOVE LOVE LOVE Spreadsheets, and in 2008 I left my career in Accountancy to start Excel Ace. My mission for Excel Ace is to help others to LOVE (or at least LIKE) Spreadsheets too, by showing them how simple it can be.
--------------------------------
Connect with Speaker
--------------------------------
Website : www.excelace.co.uk
Blog : excelace.co.uk/services/articles
LinkedIn : linkedin.com/in/traciawilliams
-----------------------------------------------------
Tentative Agenda (subject to change)
-----------------------------------------------------
- 07:55 pm ZOOM Meeting opens to attendees to begin joining
- 08:00 pm - 08:10 pm Welcome and meeting overview
- 08:10 pm - 09:30 pm Feature Presentation by Speaker
- 09:30 pm - 10:00 pm Meeting Wrap-up (Only Available on ZOOM)
------------------
Registration
------------------
This meet-up will be hosted on ZOOM and will be recorded to share with others who were not able to attend live. You must RSVP for the event in order to access the ZOOM Meeting link.
-------------------------
Joining the event
-------------------------
The link will be visible only if you RSVP beforehand.
**NOTE: As mentioned above, this event will be recorded and shared online, so attendee information may be visible in the recording.
--------------------------
Join Meetup : meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------
This is an online event and will begin at 08:00 pm (Saudi Arabian Standard Time).
Discover the power of source control and version control for Power BI! Whether you're an individual developer or part of a large enterprise team, implementing a robust source control strategy is vital. We have you covered depending on your Power BI licensing plan and your organisation's policies. Join us in this session to learn about the possibilities and options available to you.
---------------------------
About the Speaker
---------------------------
Soheil Bakhshi is an author, trainer, speaker, consultant, and Microsoft Data Platform MVP. In following his desire for simplicity and efficiency, he is behind Power BI community tools and commercial products such as Power BI Exporter and Power BI Documenter. Working in the data and analytics space for more than 20 years, Soheil’s experience lies in Microsoft BI, Data Warehousing, and Power BI platform. He has a passion for sharing knowledge via his website (www.biinsight.com), speaking at conferences and Power BI community events locally and globally.
--------------------------------
Connect with Speaker
--------------------------------
Website : datavizioner.com
Blog : biinsight.com
LinkedIn : linkedin.com/in/bakhshi
Twitter : twitter.com/_SoheilBakhshi
-----------------------------------------------------
Tentative Agenda (subject to change)
-----------------------------------------------------
- 07:55 pm ZOOM Meeting opens to attendees to begin joining
- 08:00 pm - 08:10 pm Welcome and meeting overview
- 08:10 pm - 09:30 pm Feature Presentation by Speaker
- 09:30 pm - 10:00 pm Meeting Wrap-up (Only Available on ZOOM)
------------------
Registration
------------------
This meet-up will be hosted on ZOOM and will be recorded to share with others who were not able to attend live. You must RSVP for the event in order to access the ZOOM Meeting link.
-------------------------
Joining the event
-------------------------
The link will be visible only if you RSVP beforehand.
**NOTE: As mentioned above, this event will be recorded and shared online, so attendee information may be visible in the recording.
--------------------------
Join Meetup : meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------
This is an online event and will begin at 01:00 pm (Saudi Arabian Standard Time).
We all love Excel, but some things about it can drive you NUTS! Erik Oehm will introduce the idea of ""Microautomations"", what makes Excel so great, but also delve into the DARK SIDE of Excel work. We have all experienced moments in Excel where you slap your hand to your forehead and cry ""WHYYYY???"" to the ceiling. Using the powers of automation and his own personal Excel Iron Man suit, he will demonstrate how Excel work can not only be more efficient, but a lot more fun as well.
---------------------------
About the Speaker
---------------------------
Erik Oehm is a self-proclaimed Excel supernerd on a mission to bring joy to the world through Microsoft Excel automation.
--------------------------------
Connect with Speaker
--------------------------------
LinkedIn : linkedin.com/in/excelrobot
YouTube : youtube.com/@ExcelRobot
Twitter : twitter.com/ExcelRobot
GitHub : gist.github.com/ExcelRobot
-----------------------------------------------------
Tentative Agenda (subject to change)
-----------------------------------------------------
- 07:55 pm ZOOM Meeting opens to attendees to begin joining
- 08:00 pm - 08:10 pm Welcome and meeting overview
- 08:10 pm - 09:30 pm Feature Presentation by Speaker
- 09:30 pm - 10:00 pm Meeting Wrap-up (Only Available on ZOOM)
------------------
Registration
------------------
This meet-up will be hosted on ZOOM and will be recorded to share with others who were not able to attend live. You must RSVP for the event in order to access the ZOOM Meeting link.
-------------------------
Joining the event
-------------------------
The link will be visible only if you RSVP beforehand.
**NOTE: As mentioned above, this event will be recorded and shared online, so attendee information may be visible in the recording.
--------------------------
Join Meetup : meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------
This is an online event and will begin at 08:00 pm (Saudi Arabian Standard Time).
Excel is everywhere. Flexibility, ease of use, and low entry barriers are just some of the benefits that are making Excel a ‘here-to-stay’ tool. However, messy spreadsheets with bad visualizations should be a thing of the past. So how do you create an awesome report without wasting tons of time on hacking Excel in order to make your charts look good?
To solve this issue many users are facing daily, Tine will present the latest addition to the Actionable Reporting toolkit for data professionals and enthusiasts who want to take their reports to the next level – Zebra BI for Office. Having a single source of truth across your entire stack (Power BI, Excel, and/or PowerPoint) can save hours of work and advanced visualizations with additional context give you an immediate understanding of the performance.
Join Tine and Faraz and learn how to create eye-catching, easy-to-understand visual reports that unlock invaluable business insights within seconds!
---------------------------
About the Speaker
---------------------------
Tine is an experienced Head of Empowerment at Zebra BI with a demonstrated history of working in Business Intelligence as a Team Lead. Skilled in Management, Business Process, Analytical Skills, Data Visualization and Sales. Also in charge of Zebra BI’s Empowerment team, making sure they have the proper knowledge of business intelligence and provide the highest quality content.
--------------------------------
Connect with Speaker
--------------------------------
Website : zebrabi.com
LinkedIn : linkedin.com/in/ozimic
YouTube : youtube.com/@ZebraBI
-----------------------------------------------------
Tentative Agenda (subject to change)
-----------------------------------------------------
- 07:55 pm ZOOM Meeting opens to attendees to begin joining
- 08:00 pm - 08:10 pm Welcome and meeting overview
- 08:10 pm - 09:30 pm Feature Presentation by Speaker
- 09:30 pm - 10:00 pm Meeting Wrap-up (Only Available on ZOOM)
------------------
Registration
------------------
This meet-up will be hosted on ZOOM and will be recorded to share with others who were not able to attend live. You must RSVP for the event in order to access the ZOOM Meeting link.
-------------------------
Joining the event
-------------------------
The link will be visible only if you RSVP beforehand.
**NOTE: As mentioned above, this event will be recorded and shared online, so attendee information may be visible in the recording.
--------------------------
Join Meetup : meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------
This is an online event and will begin at 08:00 pm (Saudi Arabian Standard Time).
⏱ Time Stamp
00:00 Intro
00:20 Understanding the problem
01:40 Building the Solution
03:25 Warning with this solution
04:30 Feedback
04:50 End
--------------------------------------------------------------
Handle with VBA
- peltiertech.com/chart-udf-control-axis-scale
- exceloffthegrid.com/chart-axis-min-mix
Credits: Jon Peltier and Mark Proctor. Thank you both!
--------------------------------------------------------------
🛒 Affiliate links :
- Support me with your Amazon purchases: amzn.to/3tR4AUN
- Buy Office365: bit.ly/3nKcbnk
📣 Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so you're helping me keep my blog up and running and you're helping me provide for my family 👨👩👧👦 so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
--------------------------------------------------------------
🌎 https://www.ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
excelexciting.com/forums
--------------------------------------------------------------
Join our Meetup group Saudi Arabia, Microsoft Excel & PowerPlatform Meetup
meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------------------------------------------
👍🏻 Like Facebook Page :
facebook.com/ExcelExciting
👥Join The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
You can check the following videos as well
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks #excelchart #excelcharts
Discuss the AI capabilities in PowerBI
---------------------------
About the Speaker
---------------------------
Liji Thomas is an accomplished technologist and leader with over 15 years of experience in building cutting-edge digital experiences. She is a Microsoft MVP in AI, which is a testament to her expertise and contributions to the community in the field of artificial intelligence.
As Manager (Data + AI) at Valorem Reply, Liji Thomas oversees the development of cutting-edge solutions that leverage data and artificial intelligence to drive business value. Her role involves managing a team of talented consultants and collaborating with clients to identify opportunities for leveraging data and AI to improve business processes, increase efficiency, and enhance customer experiences. Her expertise spans a wide range of technologies, including AI, machine learning, natural language processing, and conversational AI.
Liji is passionate about the potential of data and AI to transform businesses and create new opportunities for growth and innovation. She is dedicated to staying at the forefront of the latest developments in the field and is constantly exploring new approaches and technologies to drive business value. She believes that AI can transform how we interact with technology and each other, and she is dedicated to driving innovation and pushing the boundaries of what is possible with AI.
In addition to her work at Valorem Reply, Liji is an active participant in the broader data and AI community. She is a frequent speaker at industry events and conferences and is passionate about sharing her knowledge and insights with others in the field. She frequently shares her insights and expertise through speaking engagements, publications, and community involvement. She is committed to empowering the next generation of technologists and leaders and is an advocate for diversity, equity, and inclusion in the tech industry. She is also involved in mentoring and coaching programs, where she shares her expertise and helps to develop the next generation of data and AI leaders.
--------------------------------
Connect with Speaker
--------------------------------
LinkedIn : linkedin.com/in/liji-thomas
-----------------------------------------------------
Tentative Agenda (subject to change)
-----------------------------------------------------
- 07:55 pm ZOOM Meeting opens to attendees to begin joining
- 08:00 pm - 08:10 pm Welcome and meeting overview
- 08:10 pm - 09:30 pm Feature Presentation by Speaker
- 09:30 pm - 10:00 pm Meeting Wrap-up (Only Available on ZOOM)
------------------
Registration
------------------
This meet-up will be hosted on ZOOM and will be recorded to share with others who were not able to attend live. You must RSVP for the event in order to access the ZOOM Meeting link.
-------------------------
Joining the event
-------------------------
The link will be visible only if you RSVP beforehand.
**NOTE: As mentioned above, this event will be recorded and shared online, so attendee information may be visible in the recording.
--------------------------
Join Meetup : meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------
This is an online event and will begin at 08:00 pm (Saudi Arabian Standard Time).
--------------------------------------------------------------
🛒 Affiliate links :
- Support me with your Amazon purchases: amzn.to/3tR4AUN
- Buy Office365: bit.ly/3nKcbnk
📣 Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so you're helping me keep my blog up and running and you're helping me provide for my family 👨👩👧👦 so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
--------------------------------------------------------------
🌎 https://www.ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
excelexciting.com/forums
--------------------------------------------------------------
Join our Meetup group, Saudi Arabia, Microsoft Excel & PowerPlatform Meetup
meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------------------------------------------
👍🏻 Like Facebook Page :
facebook.com/ExcelExciting
👥Join The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks #Windows
I am going to present a few feature that are not so known about Excel, and mix it up with some thoughts from my latest Excel book about diagrams.
---------------------------
About the Speaker
---------------------------
I think I am the only inspirational Excel speaker in Sweden teaching Excel to companies. Excel nerd and BI-consultant from Sweden helping my customers structure, analyze and interpret their data.
--------------------------------
Connect with Speaker
--------------------------------
Website : https://www.stavegard.se
Blog : https://www.stavegard.se
LinkedIn : linkedin.com/in/davidstavegard
YouTube : youtube.com/davidstavegard
Twitter : twitter.com/DavidStavegard
Facebook : facebook.com/davidstavegard
-----------------------------------------------------
Tentative Agenda (subject to change)
-----------------------------------------------------
- 07:55 pm ZOOM Meeting opens to attendees to begin joining
- 08:00 pm - 08:10 pm Welcome and meeting overview
- 08:10 pm - 09:30 pm Feature Presentation by Speaker
- 09:30 pm - 10:00 pm Meeting Wrap-up (Only Available on ZOOM)
------------------
Registration
------------------
This meet-up will be hosted on ZOOM and will be recorded to share with others who were not able to attend live. You must RSVP for the event in order to access the ZOOM Meeting link.
-------------------------
Joining the event
-------------------------
The link will be visible only if you RSVP beforehand.
**NOTE: As mentioned above, this event will be recorded and shared online, so attendee information may be visible in the recording.
--------------------------
Join Meetup : meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------
This is an online event and will begin at 08:00 pm (Saudi Arabian Standard Time).
⏱ Time Stamp
00:00 Intro
00:43 Constructing the formula & understanding the logic
01:10 Applying the conditional formatting for column 1
01:25 Applying the conditional formatting for column 2
02:25 Testing the working
02:40 End
--------------------------------------------------------------
🛒 Affiliate links :
- Support me with your Amazon purchases: amzn.to/3tR4AUN
- Buy Office365: bit.ly/3nKcbnk
📣 Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so you're helping me keep my blog up and running and you're helping me provide for my family 👨👩👧👦 so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
--------------------------------------------------------------
🌎 https://www.ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
excelexciting.com/forums
--------------------------------------------------------------
Join our Meetup group, Saudi Arabia, Microsoft Excel & PowerPlatform Meetup
meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------------------------------------------
👍🏻 Like Facebook Page :
facebook.com/ExcelExciting
👥Join The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
You can check the following videos as well
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks
--------------------------------------------------------------
🛒 Affiliate links :
- Support me with your Amazon purchases: amzn.to/3tR4AUN
- Buy Office365: bit.ly/3nKcbnk
📣 Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so you're helping me keep my blog up and running and you're helping me provide for my family 👨👩👧👦 so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
--------------------------------------------------------------
🌎 https://www.ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
excelexciting.com/forums
--------------------------------------------------------------
Join our Meetup group Saudi Arabia, Microsoft Excel & PowerPlatform Meetup
meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------------------------------------------
👍🏻 Like Facebook Page :
facebook.com/ExcelExciting
👥Join The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
You can check the following videos as well
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks
""Measure Killer"" is a new External Tool for MS Power BI that helps you clean up your dataset, Power BI tenant and analyze your reports.
In this session we will show you:
-How to use it to reduce your model size for unused columns
-How to ""kill"" unused measures at scale
-Its model and report documentation features
-How to clean your shared/golden datasets (MK can analyze multiple reports connected to one dataset)
-Its XMLA/Rest API capabilities (analyzing artifacts in the Power BI service / running at scale - currently under development)
The XMLA/Rest API features of Measure Killer are a paid upgrade to the free version.
Measure Killer currently has 4,000 downloads and 300 weekly users since its public beta started in Oct 2022
Check it out at measurekiller.com or get it from the Microsoft store apps.microsoft.com/store/detail/XP8JN7N3RG4N6H
---------------------------
About the Speaker
---------------------------
Gregor Brunner is 34 years old, has a background in Economics but moved into Business Intelligence in 2016. Originally from Austria, he moved to Switzerland in 2020 and started Brunner BI, a boutique IT company that specializes in Microsoft Power BI development and consulting.
--------------------------------
Connect with Speaker
--------------------------------
Website : https://www.brunner.bi
Blog : https://en.brunner.bi/blog
LinkedIn : linkedin.com/in/gregorbrunner
YouTube : youtube.com/channel/UCdccefsQ7lj_Lir8Qgg3AMQ
-----------------------------------------------------
Tentative Agenda (subject to change)
-----------------------------------------------------
- 07:55 pm ZOOM Meeting opens to attendees to begin joining
- 08:00 pm - 08:10 pm Welcome and meeting overview
- 08:10 pm - 09:30 pm Feature Presentation by Speaker
- 09:30 pm - 10:00 pm Meeting Wrap-up (Only Available on ZOOM)
------------------
Registration
------------------
This meet-up will be hosted on ZOOM and will be recorded to share with others who were not able to attend live. You must RSVP for the event in order to access the ZOOM Meeting link.
-------------------------
Joining the event
-------------------------
The link will be visible only if you RSVP beforehand.
**NOTE: As mentioned above, this event will be recorded and shared online, so attendee information may be visible in the recording.
--------------------------
Join Meetup : meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------
This is an online event and will begin at 08:00 pm (Saudi Arabian Standard Time).
--------------------------------------------------------------
🛒 Affiliate links :
- Support me with your Amazon purchases: amzn.to/3tR4AUN
- Buy Office365: bit.ly/3nKcbnk
📣 Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so you're helping me keep my blog up and running and you're helping me provide for my family 👨👩👧👦 so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
--------------------------------------------------------------
🌎 https://www.ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
excelexciting.com/forums
--------------------------------------------------------------
Join our Meetup group Saudi Arabia, Microsoft Excel & PowerPlatform Meetup
meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------------------------------------------
👍🏻 Like Facebook Page :
facebook.com/ExcelExciting
👥Join The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks #vlookup #xlookup
We'll delve into some techniques for building connected sets of functions that are robust and easily reused.
---------------------------
About the Speaker
---------------------------
Owen has 20+ years' experience in data including leadership of global teams of data scientists, data analysts, data engineers and software engineers
--------------------------------
Connect with Speaker
--------------------------------
Website : flexyourdata.com
LinkedIn : linkedin.com/in/owenhprice
YouTube : youtube.com/@flexyourdata
GitHub : gist.github.com/ncalm
-----------------------------------------------------
Tentative Agenda (subject to change)
-----------------------------------------------------
- 07:55 pm ZOOM Meeting opens to attendees to begin joining
- 08:00 pm - 08:10 pm Welcome and meeting overview
- 08:10 pm - 09:30 pm Feature Presentation by Speaker
- 09:30 pm - 10:00 pm Meeting Wrap-up (Only Available on ZOOM)
------------------
Registration
------------------
This meet-up will be hosted on ZOOM and will be recorded to share with others who were not able to attend live. You must RSVP for the event in order to access the ZOOM Meeting link.
-------------------------
Joining the event
-------------------------
The link will be visible only if you RSVP beforehand.
**NOTE: As mentioned above, this event will be recorded and shared online, so attendee information may be visible in the recording.
--------------------------
This is an online event and will begin at 08:00 pm (Saudi Arabian Standard Time).
--------------------------------------------------------------
🌎 https://www.ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
excelexciting.com/forums
--------------------------------------------------------------
Join our Meetup group Saudi Arabia, Microsoft Excel & PowerPlatform Meetup
meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------------------------------------------
👍🏻 Like Facebook Page :
facebook.com/ExcelExciting
👥Join The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks #excelshorts #excelshortsvideo #spreadsheet #microsoftexcel #excelformulasandfunctions #excelformula
Complete Video : youtu.be/_wtptGCwBQc
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks #excelshorts #excelshortsvideo
This game-changing feature allows you to instantly see the results of your formulas, saving you time and increasing your efficiency.
We will show you how to use this feature to speed up your data analysis and take your Excel skills to the next level.
Whether you're a beginner or an advanced user, this video will provide you with the knowledge you need to master Excel formulas. So, watch now and unlock the power of Excel with the new Formula Value Tooltip feature!
🗳️ Vote Here: feedbackportal.microsoft.com/feedback/idea/075cb446-389e-ed11-a81b-002248519701
⏱ Time Stamp
00:00 Intro
00:24 Debugging Excel formula by pressing F9 old school method
00:30 New feature Excel tooltip preview to highlight values results
00:53 Excel tooltip preview to highlight values results working with formula bar
01:15 debug formula with value preview tooltip feature
01:50 debug formula with value tooltip feature if a formula is nested
02:30 Disable or turn off the value tooltip preview feature on Windows
02:55 Disable or turn off the value tooltip preview feature on Mac
03:28 Drag the tooltip on the Mac
03:53 Feature request tooltip value to copy
04:45 End Screen
--------------------------------------------------------------
🛒 Affiliate links :
- Support me with your Amazon purchases: amzn.to/3tR4AUN
- Buy Office365: bit.ly/3nKcbnk
📣 Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so you're helping me keep my blog up and running and you're helping me provide for my family 👨👩👧👦 so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
--------------------------------------------------------------
🌎 https://www.ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
excelexciting.com/forums
--------------------------------------------------------------
Join our Meetup group Saudi Arabia, Microsoft Excel & PowerPlatform Meetup
meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------------------------------------------
👍🏻 Like Facebook Page :
facebook.com/ExcelExciting
👥Join The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
You can check the following videos as well
Chat GPT + Excel: How AI is writing Excel Formulas and VBA Code 🤖
youtu.be/-2qyLTAXmtw
Move the Grand Total to the left or to the first column in Excel PivotTable
youtu.be/_GIogEjwAXo
Microsoft Excel NEW Advanced Formula Environment (AFE) - (Mac & Windows)
youtu.be/rn6iJfIE_CA
The right way to ALWAYS download Microsoft Office Mac from Office.com
youtu.be/7UlmxqG66_E
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks
Also, we look into the capabilities of ChatGPT and how it can be used to write VBA code and Excel formulas. We explore how AI can automate the process of writing complex macros and formulas, making it easier for Excel users to analyze and manage.
We also demonstrate how ChatGPT can generate accurate and efficient VBA code and Excel formulas, saving users time and increasing productivity.
Whether you're a business professional, a data analyst, or a developer, this video will provide valuable insights into how ChatGPT can be used to enhance the capabilities of Excel and other spreadsheet software.
We will also discuss what things to be taken care of before you burn your hands.
⏱ Time Stamp
00:00 Intro
00:30 How to register setup Chat GPT?
00:59 Example 01 writing a unique formula asking chat gpt
02:03 Example 02 Real-world example to highlight duplicate with Excel Formula
05:32 Example 03 Real-world example to highlight duplicate with VBA Code
06:51 Example 04 Write XLOOKUP formula with Chat GPT
07:59 Example 04 Take data from an Excel sheet and send it by email outlook with VBA code and attached PDF file
11:00 End
--------------------------------------------------------------
🛒 Affiliate links :
- Support me with your Amazon purchases: amzn.to/3tR4AUN
- Buy Office365: bit.ly/3nKcbnk
📣 Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so you're helping me keep my blog up and running and you're helping me provide for my family 👨👩👧👦 so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
--------------------------------------------------------------
🌎 https://www.ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
excelexciting.com/forums
--------------------------------------------------------------
Join our Meetup group Saudi Arabia, Microsoft Excel & PowerPlatform Meetup
meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------------------------------------------
👍🏻 Like Facebook Page :
facebook.com/ExcelExciting
👥Join The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
You can check the following videos as well
***********************************************************
#chatgpt #Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks
DAX is a language that provides integration of functions and operators to build formulas in Microsoft Power BI tool. It can be specially life-saving when it comes to adding dynamic calculations to your report. It is not easy to master DAX but there could be certain scenarios where DAX calculations can make developer’s life easier.
In today’s session, I will be showing few scenarios where using DAX calculations, has really made my job easy to add a dynamic-level to the insights in a Power BI report.
I will be taking the audience through few different use-cases, where simple DAX tricks can help with adding the next level functionality to visuals in Power BI.
Key Take-aways:
• Learning basic DAX expressions which will be use-case driven
• Adding visualisation capabilities using basic DAX expressions
• Adding formatting tricks to visuals using DAX expressions
• Problem statements to be solved using DAX expressions
• A power BI file in the end to play with
One doesn’t need to be an expert in DAX to attend this session. Anyone willing to learn about few DAX tricks in Power BI, should definitely attend this session.
---------------------------
About the Speaker
---------------------------
Pragati is a Data Platform MVP (Microsoft Most Valuable Professional).
Currently, she is working as a Manager at Avanade in UK and works towards generating and delivering data insights to various customers. She holds a Master’s degree in Data Science and Analytics from Royal Holloway University of London.
She is skilled in various tools and technologies like Microsoft Power BI, Tableau, Microsoft Excel, Azure ML Studio, Azure Databricks Pyspark and SQL.
She has been using Power BI for few years now and is recognised as a Superuser on the Microsoft Power BI Community.
Outside work she enjoys photography, loves hiking, she is a trained Indian classical singer and has a passion for painting. She even has her Instagram page dedicated to painting.
--------------------------------
Connect with Speaker
--------------------------------
Blog : datavibe.co.uk
LinkedIn : linkedin.com/in/pragatijain1187
YouTube : youtube.com/@datavibe
Twitter : twitter.com/pragati1187
GitHub : github.com/Pragati1187
-----------------------------------------------------
Tentative Agenda (subject to change)
-----------------------------------------------------
- 07:55 pm ZOOM Meeting opens to attendees to begin joining
- 08:00 pm - 08:10 pm Welcome and meeting overview
- 08:10 pm - 09:30 pm Feature Presentation by Speaker
- 09:30 pm - 10:00 pm Meeting Wrap-up (Only Available on ZOOM)
------------------
Registration
------------------
This meet-up will be hosted on ZOOM and will be recorded to share with others who were not able to attend live. You must RSVP for the event in order to access the ZOOM Meeting link.
-------------------------
Joining the event
-------------------------
The link will be visible only if you RSVP beforehand.
**NOTE: As mentioned above, this event will be recorded and shared online, so attendee information may be visible in the recording.
--------------------------
Join Meetup : meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------
This is an online event and will begin at 08:00 pm (Saudi Arabian Standard Time).
Get your skills upgrade with PowerBI this year, a Course Crafted by Microsoft MVP Leila Gharani
#PowerBI #microsoftpowerbi #microsoft
courses.xelplus.com/p/fast-track-to-power-bi?affcode=269102_zlbzfbwp
#powerbi #excelexciting #powerbipro
Music by : @CarmenMariaOficial
⏱ Time Stamp
00:00 Intro
01: 06 Excel Trick by Oz Du Soleil
02:25 End
--------------------------------------------------------------
🛒 Affiliate links :
- Support me with your Amazon purchases: amzn.to/3tR4AUN
- Buy Office365: bit.ly/3nKcbnk
📣 Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so you're helping me keep my blog up and running and you're helping me provide for my family 👨👩👧👦 so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
--------------------------------------------------------------
🌎 https://www.ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
excelexciting.com/forums
--------------------------------------------------------------
Join our Meetup group Saudi Arabia, Microsoft Excel & PowerPlatform Meetup
meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------------------------------------------
👍🏻 Like Facebook Page :
facebook.com/ExcelExciting
👥Join The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
You can check the following videos as well
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks
We hear a lot about the benefits of storing your data in Excel's Data Model instead of the worksheet cells. Larger capacity, better performance and the ability to create Pivot Tables from multiple data sources.
But dive a little deeper and you'll find a whole magical world of DAX, Measures and CUBE functions which will help you to take your reporting and data analysis skills to the next level
This session will include...
An overview of the benefits of using The Data Model to store your data
How to create simple Measures using DAX
How to use Excel's family of CUBE functions to pull aggregated values (Sum, Count etc) from the Data Model to the Worksheet
Using CUBE functions to create dynamic Slicers and drop downs
---------------------------
About the Speaker
---------------------------
In a career spanning 30+ years, Mike Thomas, a UK-based IT Trainer, has delivered thousands of courses and produced hundreds of written and video-based tutorials.
He is a subject matter expert in a range of technologies, his primary focus and passion being Microsoft Office (especially Excel) on both the Windows and Mac platforms and Power BI.
Mike is a Fellow of The Learning and Performance Institute and has worked with and for many global and UK-based companies and organisations across a diverse range of industries including healthcare, pharmaceutical and public sector.
In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes.
--------------------------------
Connect with Speaker
--------------------------------
Website : theexceltrainer.co.uk
LinkedIn : linkedin.com/in/thomasmik
YouTube : theexceltrainer.co.uk/youtube
Twitter : twitter.com/thomasmike
-----------------------------------------------------
Tentative Agenda (subject to change)
-----------------------------------------------------
- 07:55 pm ZOOM Meeting opens to attendees to begin joining
- 08:00 pm - 08:10 pm Welcome and meeting overview
- 08:10 pm - 09:30 pm Feature Presentation by Speaker
- 09:30 pm - 10:00 pm Meeting Wrap-up (Only Available on ZOOM)
------------------
Registration
------------------
This meet-up will be hosted on ZOOM and will be recorded to share with others who were not able to attend live. You must RSVP for the event in order to access the ZOOM Meeting link.
-------------------------
Joining the event
-------------------------
The link will be visible only if you RSVP beforehand.
**NOTE: As mentioned above, this event will be recorded and shared online, so attendee information may be visible in the recording.
--------------------------
Join Meetup : meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------
This is an online event and will begin at 08:00 pm (Saudi Arabian Standard Time)."
--------------------------------------------------------------
🛒 Affiliate links :
- Support me with your Amazon purchases: amzn.to/3tR4AUN
- Buy Office365: bit.ly/3nKcbnk
📣 Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so you're helping me keep my blog up and running and you're helping me provide for my family so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
--------------------------------------------------------------
🌎 https://www.ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
excelexciting.com/forums
--------------------------------------------------------------
👍🏻Faraz Shaikh - Excel Master
facebook.com/ExcelExciting
👥Join The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
DISCLAIMER: The Talking Emoji If any resemblance with any person, living or dead, is purely coincidental. There is absolutely no intention to hurt any person or group of persons or any section of society through this video. This video is created to impart my understanding of a particular subject for viewers in an easy and fun way.
***********************************************************
You can check the following videos as well
***********************************************************
#FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks
⏱ Time Stamp
00:00 Intro
00:45 Brief About the trick
01:20 Super Cool Excel Filter Trick
05:00 End
--------------------------------------------------------------
🛒 Affiliate links :
- Support me with your Amazon purchases: amzn.to/3tR4AUN
- Buy Office365: bit.ly/3nKcbnk
📣 Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so you're helping me keep my blog up and running and you're helping me provide for my family 👨👩👧👦 so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
--------------------------------------------------------------
🌎 https://www.ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
excelexciting.com/forums
--------------------------------------------------------------
Join our Meetup group Saudi Arabia, Microsoft Excel & PowerPlatform Meetup
meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------------------------------------------
👍🏻 Like Facebook Page :
facebook.com/ExcelExciting
👥Join The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
You can check the following videos as well
🔮 Excel Trick By Chandoo with Faraz Shaikh - ExcelExciting.com
youtu.be/f3cm1YWYOR4
Power Query - Move the Grand Total to the left or to the first column in Excel PivotTable
youtu.be/-XxZO0zfl3A
Microsoft Excel NEW Advanced Formula Environment (AFE) - (Mac & Windows)
youtu.be/rn6iJfIE_CA
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks #goodly #MicrosoftExcel #sheets #googlesheets #exceltutorial
⏱ Time Stamp
00:00 Intro
00:44 Excel Tip By Chandoo
03:00 End
--------------------------------------------------------------
🛒 Affiliate links :
- Support me with your Amazon purchases: amzn.to/3tR4AUN
- Buy Office365: bit.ly/3nKcbnk
📣 Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so you're helping me keep my blog up and running and you're helping me provide for my family 👨👩👧👦 so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
--------------------------------------------------------------
🌎 https://www.ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
excelexciting.com/forums
--------------------------------------------------------------
Join our Meetup group Saudi Arabia, Microsoft Excel & PowerPlatform Meetup
meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------------------------------------------
👍🏻 Like Facebook Page :
facebook.com/ExcelExciting
👥Join The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
You can check the following videos as well
1️⃣ Extract Multiple Matching Records - youtu.be/pTVxxaZQx24
2️⃣ Learn how to use Microsoft Flow / Power Automate - youtu.be/HQyxnPYW9Jc
3️⃣ Trick to Create A Data Entry Table In Power Query for Excel - youtu.be/bHPrRbcw6f0
4️⃣ Excel Tip by the Excel Queen 👸🏻(Faraz & Leila) - youtu.be/6CEYKRIlppE
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks #chandoo #BulgariaExcelDays #bulgaria
Are you unsure if power query can help you with those repetitive/boring and time-consuming tasks in Excel?
Do you wonder if there is something out there to help you clean that messy data, that takes hours and hours of cleaning and organizing, every week, month, and/or quarter?
If the answer is yes, then this session is for you!!!
I often use Power Query at work because it saves me hours (or even days) of work.
By automating repetitive tasks, connecting reports to one source of data, and updating my information with one click (or two 😉), I can have reliable information in a timely manner, ready for analysis and decision making.
During this session, I will show you how I have automated and optimized some of my reports by using Power Query; hoping that you can find some practical use from this presentation.
Hope to see you there 😊
---------------------------
About the Speaker
---------------------------
CPA in Canada, certified Microsoft Excel expert, working with excel for over 20 years.
Extensive experience empowering organizations & individuals to excel in minimizing the time entering data, automating reports, finding efficiencies, and providing training to optimize existing resources, such as excel.
--------------------------------
Connect with Speaker
--------------------------------
LinkedIn : linkedin.com/in/alejandrahorvath
YouTube : youtube.com/channel/UCFYQr-oZbz_90EWcvc-49XA
Twitter : @alejandrahorv
-----------------------------------------------------
Tentative Agenda (subject to change)
-----------------------------------------------------
- 07:55 pm ZOOM Meeting opens to attendees to begin joining
- 08:00 pm - 08:10 pm Welcome and meeting overview
- 08:10 pm - 09:30 pm Feature Presentation by Speaker
- 09:30 pm - 10:00 pm Meeting Wrap-up (Only Available on ZOOM)
------------------
Registration
------------------
This meet-up will be hosted on ZOOM and will be recorded to share with others who were not able to attend live. You must RSVP for the event in order to access the ZOOM Meeting link.
-------------------------
Joining the event
-------------------------
The link will be visible only if you RSVP beforehand.
**NOTE: As mentioned above, this event will be recorded and shared online, so attendee information may be visible in the recording.
--------------------------
Join Meetup : meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------
This is an online event and will begin at 08:00 pm (Saudi Arabian Standard Time)."
Download Files Here
computergaga.com/_excel/files/event-files/networkdays.intl-sa-meetup.xlsx
computergaga.com/_excel/files/event-files/networkdays.intl-sa-meetup-complete.xlsx
---------------------------
About the Speaker
Alan is an Excel trainer, author of multiple Excel books and Microsoft MVP. He has been helping people in Excel for over 20 years. He loves training and making peoples working lives easier. Alan runs his own blog and YouTube channel - Computergaga. The channel has over 550 videos has received more than 30 million views. He runs a monthly Excel meetup in London where people learn, share, and enjoy each other’s company.
--------------------------------
Connect with Speaker
LinkedIn: linkedin.com/in/alanmurray-computergaga
Website: computergaga.com
YouTube: youtube.com/computergaga
Meetup: meetup.com/London-Excel-Meetup-Group
Advanced Excel Success: A Practical Guide to Mastering Excel
amazon.co.uk/Advanced-Excel-Formulas-Unleashing-Brilliance/dp/1484271246
-----------------------------------------------------
Tentative Agenda (subject to change)
07:55pm ZOOM Meeting opens to attendees to begin joining
08:00pm - 08:10pm Welcome and meeting overview
08:10pm - 09:30pm Feature Presentation by Speaker
09:30pm - 10:00pm Meeting Wrap-up
------------------
Registration
This meet-up will be hosted on ZOOM Teams, and will be recorded to share with others who were not able to attend live. You must RSVP for the event in order to access the ZOOM Meeting link. Joining the event The link will be visible only if you RSVP beforehand.
**NOTE: As mentioned above, this event will be recorded and shared online, so attendee information may be visible in the recording.
This is an online event and will begin at 08:00pm (Saudi Arabian Standard Time).
If you analyze data in Excel, you are probably used to the simplicity of using Pivot Tables to analyze and summarize data. There are situations where using Pivot Tables will not be good enough. In this session, we will explore the strengths and weaknesses of Pivot Tables and Cube Functions in Excel. At the end of the session, you will be equipped with skills that will help you take advantage of both Excel features to analyze and summarize data from the Data Model.
---------------------------
About the Speaker
---------------------------
A Microsoft Excel MVP, Microsoft Certified Trainer, Financial Modeler and Data Analyst with over 10 years work experience in Banking, Insurance and Business Development.
He is founder of Finex Skills Hub (www.finexskillshub.com), Approved Training Provider of the Financial Modeling Institute, Canada. The firm has successfully trained over 30 Advanced Financial Modelers in Ghana.
Finex Skills Hub runs the Finex Project, a pro bono student training outreach program for students in Microsoft Excel, Office Tools and Financial Modeling. The Hub also runs Excel Our Girls, a sponsored training for girls under 25 in Data Analytics and Coding in Ghana.
Bernard also provides consultancy services for SMEs (start-ups and existing) in Financial Management, Business Planning and Research.
He has an active audience online with about 17,000 followers on his LinkedIn Account. (linkedin.com/in/bernardobengboateng) where he share tips and tricks on Microsoft Excel and other Office Apps.
--------------------------------
Connect with Speaker
--------------------------------
Website : finexskillshub.com
LinkedIn : linkedin.com/in/bernardobengboateng
YouTube : youtube.com/c/FinexSkillsHub/featured
Twitter : twitter.com/ObengBoateng57
-----------------------------------------------------
Tentative Agenda (subject to change)
-----------------------------------------------------
- 07:55 pm ZOOM Meeting opens to attendees to begin joining
- 08:00 pm - 08:10 pm Welcome and meeting overview
- 08:10 pm - 09:30 pm Feature Presentation by Speaker
- 09:30 pm - 10:00 pm Meeting Wrap-up (Only Available on ZOOM)
------------------
Registration
------------------
This meet-up will be hosted on ZOOM and will be recorded to share with others who were not able to attend live. You must RSVP for the event in order to access the ZOOM Meeting link.
-------------------------
Joining the event
-------------------------
The link will be visible only if you RSVP beforehand.
**NOTE: As mentioned above, this event will be recorded and shared online, so attendee information may be visible in the recording.
--------------------------
Join Meetup : meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------
This is an online event and will begin at 08:00 pm (Saudi Arabian Standard Time)."
⏱ Time Stamp
00:00 Intro
00:40 Organizing Dataset
01:16 Load your data Power Query & Build Solution
04:00 Loading data as PivotTable Report
05:25 adding new records and testing the solution
05:52 About My Data Summit
06:50 End
--------------------------------------------------------------
🌍 My Data Summit: mydatasummit.com/shop
🎫 Coupon Code: FARAZ-10
--------------------------------------------------------------
⏬ Practice File Download: excelexciting.com/dynamic-solution-with-power-query-to-move-the-grand-total-in-excel-pivottable
--------------------------------------------------------------
🛒 Affiliate links :
- Support me with your Amazon purchases: amzn.to/3tR4AUN
- Buy Office365: bit.ly/3nKcbnk
📣 Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so you're helping me keep my blog up and running and you're helping me provide for my family 👨👩👧👦 so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
--------------------------------------------------------------
🌎 https://www.ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
excelexciting.com/forums
--------------------------------------------------------------
Join our Meetup group Saudi Arabia, Microsoft Excel & PowerPlatform Meetup
meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------------------------------------------
👍🏻 Like Facebook Page :
facebook.com/ExcelExciting
👥Join The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
You can check the following videos as well
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks
Well, it's possible and let's do it !!!
⏱ Time Stamp
00:00 Intro
00:23 Creating PivotTable
00:45 Understanding the data structure
01:01 Building the solution
04:15 Testing data with new records
05:22 About Mega online event "MY DATA SUMMIT"
06:22 End
--------------------------------------------------------------
🌍 My Data Summit: mydatasummit.com/shop
🎫 Coupon Code: FARAZ-10
--------------------------------------------------------------
⏬ Practice File Download: excelexciting.com/move-the-grand-total-to-the-left-or-to-the-first-column-in-excel-pivottable
--------------------------------------------------------------
🛒 Affiliate links :
- Support me with your Amazon purchases: amzn.to/3tR4AUN
- Buy Office365: bit.ly/3nKcbnk
📣 Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so you're helping me keep my blog up and running and you're helping me provide for my family 👨👩👧👦 so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
--------------------------------------------------------------
🌎 https://www.ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
excelexciting.com/forums
--------------------------------------------------------------
Join our Meetup group Saudi Arabia, Microsoft Excel & PowerPlatform Meetup
meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------------------------------------------
👍🏻 Like Facebook Page :
facebook.com/ExcelExciting
👥Join The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
You can check the following videos as well
Microsoft Excel Power Query Editor for Mac 💻 is finally here !!
youtu.be/Ld6g-z_a31E
Learn how to use Microsoft Flow / Power Automate
youtu.be/HQyxnPYW9Jc
Create Dynamics Flowcharts by connecting EXCEL to VISIO
youtu.be/xfIPFiAxQcQ
Create Organizational & Business Flowcharts Linked to Excel
youtu.be/Cor1mixgotY
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks
Faraz-10
Register here to get your special discount code for my data summit event : https://forms.gle/Ur21nmxasdot1XqR8
Join us at this Excel Meetup to hear from Felix Zumstein from Switzerland 🇨🇭 about Python for Excel
Excel and Python are both super popular technologies. In this session, Felix will show you why they are even more powerful when used together: using Python and pandas DataFrames with Excel can replace Excel’s fragmented automation and data analysis languages (VBA, M, and DAX) and opens the door for running things outside of Excel, too.
---------------------------
About the Speaker
---------------------------
Felix is the creator of xlwings, an open-source Python package that allows you to automate Excel with Python. He is also the author of the book “Python for Excel” (O’Reilly 2021).
--------------------------------
Connect with Speaker
--------------------------------
Website : xlwings.org
Blog : xlwings.org/blog
LinkedIn : linkedin.com/in/felix-zumstein
YouTube : youtube.com/channel/UC48ICUFi-12j8ka6AIhsg1Q
Twitter : twitter.com/felixzumstein
GitHub : github.com/fzumstein
-----------------------------------------------------
Tentative Agenda (subject to change)
-----------------------------------------------------
- 07:55 pm ZOOM Meeting opens to attendees to begin joining
- 08:00 pm - 08:10 pm Welcome and meeting overview
- 08:10 pm - 09:30 pm Feature Presentation by Speaker
- 09:30 pm - 10:00 pm Meeting Wrap-up (Only Available on ZOOM)
------------------
Registration
------------------
This meet-up will be hosted on ZOOM and will be recorded to share with others who were not able to attend live. You must RSVP for the event in order to access the ZOOM Meeting link.
-------------------------
Joining the event
-------------------------
The link will be visible only if you RSVP beforehand.
**NOTE: As mentioned above, this event will be recorded and shared online, so attendee information may be visible in the recording.
--------------------------
Join Meetup : meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------
This is an online event and will begin at 08:00 pm (Saudi Arabian Standard Time)."
Budget and forecast modelling in Excel with Danielle Stein Fairhurst : mydatasummit.com/product/budget-and-forecast-modelling-in-excel-with-danielle-stein-fairhurst
Join us at this Excel Meetup to hear from Danielle Stein Fairhurst from Australia 🇦🇺 about Best Practice Financial Modelling
She will give us an overview of the skills needed for financial modelling as well as the key principles and best practice techniques for building accurate, robust and reliable financial models.
If you’ve been using Excel for any period of time in a financial context, chances are you’ve already been working with financial models. Having good Excel modelling skills is incredibly valuable as organizations need good, dynamic financial models to accurately predict business outcomes and forecast volatile economic inputs in times of uncertainty.
---------------------------
About the Speaker
---------------------------
Danielle Stein Fairhurst is the author of “Using Excel for Business and Financial Modelling” (3rd edition, 2019) and “Financial Modeling in Excel For Dummies” (2nd edition, 2022). In 2021 she received the Microsoft Most Valuable Professional (MVP) award. Danielle founded the Financial Modellers’ Meetup groups which attracts participants from all over the world as well as a LinkedIn forum with over 55,000 members. An advocate for women in finance, she was on the Diversity Council for the ModelOff Financial Modeling World Championships and founded the Women in Financial Modelling online community. She is a Chartered Financial Modeler (FMI) and holds a Master of Business Administration (MBA) from Macquarie Graduate School of Management (MGSM) and has taught management accounting subjects at Sydney University.
--------------------------------
Connect with Speaker
--------------------------------
Website : www.plumsolutions.com.au
LinkedIn : linkedin.com/in/daniellesteinfairhurst
YouTube : youtube.com/c/plumsolutions
Twitter : twitter.com/dsteinfairhurst
Facebook : facebook.com/dsteinfairhurst
-----------------------------------------------------
Tentative Agenda (subject to change)
-----------------------------------------------------
- 12:55 pm ZOOM Meeting opens to attendees to begin joining
- 01:00 pm - 01:10 pm Welcome and meeting overview
- 01:10 pm - 02:30 pm Feature Presentation by Speaker
- 02:30 pm - 03:00 pm Meeting Wrap-up (Only Available on ZOOM)
------------------
Registration
------------------
This meet-up will be hosted on ZOOM and will be recorded to share with others who were not able to attend live. You must RSVP for the event in order to access the ZOOM Meeting link.
-------------------------
Joining the event
-------------------------
The link will be visible only if you RSVP beforehand.
**NOTE: As mentioned above, this event will be recorded and shared online, so attendee information may be visible in the recording.
--------------------------
Join Meetup : meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------
This is an online event and will begin at 08:00 pm (Saudi Arabian Standard Time)."
In this session, you will learn how to avoid common pitfalls and mistakes when building calculations using DAX within Power BI. We will explore 10 different DAX calculation examples that return unexpected results and learn how to avoid them, and how to fix them. Through solving these mistakes, you will also learn and brush up on your DAX fundamentals such as Evaluation Context, Iterators, Context Transitions, and Expanded tables.
---------------------------
About the Speaker
---------------------------
Fowmy Abdulmuttalib is a Microsoft-certified business intelligence professional with extensive experience in finance, accounting and data analytics. Currently, he is employed by McDonald's Saudi Arabia as the Head of ERP and Business Intelligence. He founded ExcelFort Consulting Services, which specializes in training, consulting, and building business intelligence solutions using the Microsoft Power Platform. Interested in everything data-related, he would like to share his passion and knowledge with the data community.
--------------------------------
Connect with Speaker
--------------------------------
Website : excelfort.com
Blog : excelfort.com/blog
LinkedIn : linkedin.com/in/fowmy
YouTube : youtube.com/c/excelfort
Twitter : twitter.com/excelfort
Facebook : facebook.com/excelfort
-----------------------------------------------------
Tentative Agenda (subject to change)
-----------------------------------------------------
- 07:55 pm ZOOM Meeting opens to attendees to begin joining
- 08:00 pm - 08:10 pm Welcome and meeting overview
- 08:10 pm - 09:30 pm Feature Presentation by Speaker
- 09:30 pm - 10:00 pm Meeting Wrap-up (Only Available on ZOOM)
------------------
Registration
------------------
This meet-up will be hosted on ZOOM and will be recorded to share with others who were not able to attend live. You must RSVP for the event in order to access the ZOOM Meeting link.
-------------------------
Joining the event
-------------------------
The link will be visible only if you RSVP beforehand.
**NOTE: As mentioned above, this event will be recorded and shared online, so attendee information may be visible in the recording.
--------------------------
Join Meetup : meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------
This is an online event and will begin at 08:00 pm (Saudi Arabian Standard Time)."
Download Microsoft Office Mac from Office.com (Office Insider)
youtu.be/7UlmxqG66_E
⏱ Time Stamp
00:00 Intro
00:18 Subscribe for Office Insider
00:45 Power Query Editor for Mac
01:43 Data Transformation
02:26 Exploring different views
04:29 Performance Check 🔥
04:50 New UI Look for Mac for merge query
05:40 Column Profiling
05:59 Close & Load Data
06:50 Edit Power Queries on Mac
07:20 Report a bug to the Microsoft Excel Team
08:00 End
--------------------------------------------------------------
🛒 Affiliate links :
- Support me with your Amazon purchases: amzn.to/3tR4AUN
- Buy Office365: bit.ly/3nKcbnk
📣 Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so you're helping me keep my blog up and running and you're helping me provide for my family 👨👩👧👦 so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
--------------------------------------------------------------
🌎 https://www.ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
excelexciting.com/forums
--------------------------------------------------------------
Join our Meetup group Saudi Arabia, Microsoft Excel & PowerPlatform Meetup
meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------------------------------------------
👍🏻 Like Facebook Page :
facebook.com/ExcelExciting
👥Join The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
You can check the following videos as well
Download Microsoft Office Mac from Office.com (Office Insider)
youtu.be/7UlmxqG66_E
Stack Data In Excel Using Dynamic Arrays (Excel for Mac & Windows)
youtu.be/LyAY7WNpIKQ
I Automated 🤖 my Meetup Event with Power Automate Desktop & Excel
youtu.be/u5hZ7XxZyhU
How to Install Windows 11 on Apple M1 Pro/Max (Non-Insider & Insider)
youtu.be/H62E173CzBo
***********************************************************
#Excel #FarazShaikh #ExcelExciting #PowerQueryForMac #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks
Creating your first report in Power BI Report Server and publishing it to an On-Prem server and Power BI Service
---------------------------
About the Speaker
---------------------------
Harshavardhan is 14 year old student, and he is very passionate about technology. He have started his technology journey in 2016 and worked on it the most in 2020 and 2021.
--------------------------------
Connect with Speaker
--------------------------------
Website : harshutammina.tech (new website will be soon published as technoharshu.com)
Blog : http://harshutammina.tech/Blogs.html
LinkedIn : linkedin.com/in/vsrharshavardhan
YouTube : youtube.com/channel/UCtphPkqtU3dlLwB3xYU39Xg
GitHub : github.com/hrtacp
-----------------------------------------------------
Tentative Agenda (subject to change)
-----------------------------------------------------
- 01:55 pm ZOOM Meeting opens to attendees to begin joining
- 02:00 pm - 02:10 pm Welcome and meeting overview
- 02:10 pm - 03:30 pm Feature Presentation by Speaker
- 03:30 pm - 04:00 pm Meeting Wrap-up (Only Available on ZOOM)
------------------
Registration
------------------
This meet-up will be hosted on ZOOM and will be recorded to share with others who were not able to attend live. You must RSVP for the event in order to access the ZOOM Meeting link.
-------------------------
Joining the event
-------------------------
The link will be visible only if you RSVP beforehand.
**NOTE: As mentioned above, this event will be recorded and shared online, so attendee information may be visible in the recording.
--------------------------
Join Meetup : meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------
This is an online event and will begin at 02:00 pm (Saudi Arabian Standard Time).
⏱ Time Stamp
00:00 Intro
Download STACKDATA : gist.github.com/ExcelExciting/6790576da8916cbba5ab19675957791e
--------------------------------------------------------------
🛒 Affiliate links :
- Support me with your Amazon purchases: amzn.to/3tR4AUN
- Buy Office365: bit.ly/3nKcbnk
📣 Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so you're helping me keep my blog up and running and you're helping me provide for my family 👨👩👧👦 so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
--------------------------------------------------------------
🌎 https://www.ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
excelexciting.com/forums
--------------------------------------------------------------
Join our Meetup group Saudi Arabia, Microsoft Excel & PowerPlatform Meetup
meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------------------------------------------
👍🏻 Like Facebook Page :
facebook.com/ExcelExciting
👥Join The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
You can check the following videos as well
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks
Learn how to create interactive Excel charts using the Excel's new functions: Dynamic Arrays. With these functions, the implementation to make interactive charts is easier than before. The only thing you must learn is the logic of spilled ranges so you can easily referenced them to your charts. Come and learn on this meetup some charting tricks along with some graphs types and pro tips from a bilingual consultant.
---------------------------
About the Speaker
---------------------------
Carlos Barboza is a bilingual data consultant with 6 years of experience. He started his career in analytics using Microsoft Excel as his swiss army knife. He holds a Bachelor in Economics and Finance from University of Hartford. Currently, as consultant with Microsoft tools, Carlos is interchangeably switching between Power BI and Excel to analyze large volume of data thru data visualization, interaction and exploratory visual analysis. His current main interest today is the science of data visualization for analysis of information.
--------------------------------
Connect with Speaker
--------------------------------
Website : xlorla.thinkific.com
Blog : xlorla.thinkific.com
LinkedIn : linkedin.com/in/merod
YouTube : youtube.com/c/MicrosoftExcelRecalcorDie
Twitter : twitter.com/recalc_or_die
-----------------------------------------------------
Tentative Agenda (subject to change)
-----------------------------------------------------
- 07:55 pm ZOOM Meeting opens to attendees to begin joining
- 08:00 pm - 08:10 pm Welcome and meeting overview
- 08:10 pm - 09:30 pm Feature Presentation by Speaker
- 09:30 pm - 10:00 pm Meeting Wrap-up (Only Available on ZOOM)
------------------
Registration
------------------
This meet-up will be hosted on ZOOM and will be recorded to share with others who were not able to attend live. You must RSVP for the event in order to access the ZOOM Meeting link.
-------------------------
Joining the event
-------------------------
The link will be visible only if you RSVP beforehand.
**NOTE: As mentioned above, this event will be recorded and shared online, so attendee information may be visible in the recording.
--------------------------
Join Meetup : meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------
This is an online event and will begin at 08:00 pm (Saudi Arabian Standard Time).
⏱ Time Stamp
00:00 Intro
00:39 Understanding the logic
01:30 Number Of Columns/Rows Stack Data
02:08 Generate Group Sequence with mod function for Columns
03:44 Generate Group Sequence for Rows
05:00 Wrapping all formulas into Index Function
06:55 End
--------------------------------------------------------------
🛒 Affiliate links :
- Support me with your Amazon purchases: amzn.to/3tR4AUN
- Buy Office365: bit.ly/3nKcbnk
📣 Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so you're helping me keep my blog up and running and you're helping me provide for my family 👨👩👧👦 so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
--------------------------------------------------------------
🌎 https://www.ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
excelexciting.com/forums
--------------------------------------------------------------
Join our Meetup group Saudi Arabia, Microsoft Excel & PowerPlatform Meetup
meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------------------------------------------
👍🏻 Like Facebook Page :
facebook.com/ExcelExciting
👥Join The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
You can check the following videos as well
I Automated 🤖 my Meetup Event with Power Automate Desktop & Excel
youtu.be/u5hZ7XxZyhU
How to Install Windows 11 on Apple M1 Pro/Max (Non-Insider & Insider)
youtu.be/H62E173CzBo
Sort Problem With Numbers As Text SOLVED ✅ (Excel for mac & windows)
youtu.be/7phGPaZ89DQ
How to Calculate Hijri Age In Excel (mac & windows)
youtu.be/Cs0MgpppuPA
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks #StackData
Download Links:
1. Life Saver Lambdas: gist.github.com/ExcelExciting/6adf6a3858300e8e49da16968eb1a82c
2. Example Lambdas by MSFT: gist.github.com/chgrossMSFT/d172fd552cf6893bcdc7942223cb0e55
⏱ Time Stamp
00:00 Intro
01:24 How to Download AFE?
02:00 Expanding the AFE
02:28 Copy & Paste Lambda in AFE
03:08 Sync your formulas in AFE
03:56 Edit Lambda with UI
04:29 Import Lambda from GitHub (import from URL)
06:15 Import Lambda with Name Space
06:55 Rename AFE Name Space
07:26 Delete AFE Name Space
07:54 Testing Imported Lambda
08:30 Exploring the Raw Editor
09:08 Creating Lambda with UI
10:07 Rearranging formulas
10:26 Creating Lambda with Editor
11:10 Rename Lambda with Editor
11:20 Accidentally deleted Lambda from Name Manager (Bonus Trick)
13:40 Hidden worksheet in AFE
14:05 End
--------------------------------------------------------------
🛒 Affiliate links :
- Support me with your Amazon purchases: amzn.to/3tR4AUN
- Buy Office365: bit.ly/3nKcbnk
📣 Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so you're helping me keep my blog up and running and you're helping me provide for my family 👨👩👧👦 so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
--------------------------------------------------------------
🌎 https://www.ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
excelexciting.com/forums
--------------------------------------------------------------
Join our Meetup group Saudi Arabia, Microsoft Excel & PowerPlatform Meetup
meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------------------------------------------
👍🏻 Like Facebook Page :
facebook.com/ExcelExciting
👥Join The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
You can check the following videos as well
I Automated 🤖 my Meetup Event with Power Automate Desktop & Excel
youtu.be/u5hZ7XxZyhU
How to Install Windows 11 on Apple M1 Pro/Max (Non-Insider & Insider)
youtu.be/H62E173CzBo
Sort Problem With Numbers As Text SOLVED ✅ (Excel for mac & windows)
youtu.be/7phGPaZ89DQ
How to Calculate Hijri Age In Excel (mac & windows)
youtu.be/Cs0MgpppuPA
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks #AFE
⏱ Time Stamp
00:00 Intro
01:13 Business case & Understanding the need.
03:21 Running the automation project.
04:06 Scheduling YouTube Live
05:05 Scheduling Meetup on Meetup Page
06:03 Scheduling Event on LinkedIn
06:45 Scheduling Event on Facebook
07:10 Scheduling Outlook Meeting Invite
07:35 Automation completed
--------------------------------------------------------------
🛒 Affiliate links :
- Support me with your Amazon purchases: amzn.to/3tR4AUN
- Buy Office365: bit.ly/3nKcbnk
📣 Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so you're helping me keep my blog up and running and you're helping me provide for my family 👨👩👧👦 so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
--------------------------------------------------------------
🌎 https://www.ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
excelexciting.com/forums
--------------------------------------------------------------
Join our Meetup group Saudi Arabia, Microsoft Excel & Power Platform Meetup
meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------------------------------------------
👍🏻 Like Facebook Page :
facebook.com/ExcelExciting
👥Join The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
You can check the following videos as well
Convert Number to Percentage
youtu.be/c1qa3yeyRts
How to Install Windows 11 on Apple M1 Pro/Max (Non-Insider & Insider)
youtu.be/H62E173CzBo
Sort Problem With Numbers As Text SOLVED ✅ (Excel for mac & windows)
youtu.be/7phGPaZ89DQ
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks
Register Free for the event: meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup/events/282941765
Download Sample File : https://1drv.ms/u/s!AhCxCSOesgK6iytv0pwxLZ_hJv-y?e=5UqYn2
---------------------------
About the Speaker
---------------------------
Victor Momoh is a Petroleum Engineer who has previously worked as an IT Auditor, IT Support Analyst, and Process Engineer. He is passionate about data, automation, and knowledge sharing.
He is a Microsoft Certified Trainer, a certified Microsoft Excel Expert with specialties in Advanced Excel formulas and VBA
A firm believer in the ability of Microsoft Excel to deliver on the most complex tasks, hence his catchphrase “If you can think it, Excel most likely can do it”. When he is not on his day job as an Engineer or Solving Excel problems, he could be found playing the drums or listening to music.
--------------------------------
Connect with Speaker
--------------------------------
LinkedIn: linkedin.com/in/victor-momoh-mct-mos-2186974b
Youtube : youtube.com/channel/UCg9lOzPOQfjs_GoMlzSm_ww
Meetup: meetup.com/Nigerian-Excel-Users-Meetup
-----------------------------------------------------
Tentative Agenda (subject to change)
-----------------------------------------------------
- 07:55 pm ZOOM Meeting opens to attendees to begin joining
- 08:00 pm - 08:10 pm Welcome and meeting overview
- 08:10 pm - 09:30 pm Feature Presentation by Speaker
- 09:30 pm - 10:00 pm Meeting Wrap-up (Only Available on ZOOM)
------------------
Registration
------------------
This meet-up will be hosted on ZOOM and will be recorded to share with others who were not able to attend live. You must RSVP for the event in order to access the ZOOM Meeting link.
-------------------------
Joining the event
-------------------------
The link will be visible only if you RSVP beforehand.
**NOTE: As mentioned above, this event will be recorded and shared online, so attendee information may be visible in the recording.
This is an online event and will begin at 08:00 pm (Saudi Arabian Standard Time).
--------------------------------------------------------------
🛒 Affiliate links :
- Support me with your Amazon purchases: amzn.to/3tR4AUN
- Buy Office365: bit.ly/3nKcbnk
📣 Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so you're helping me keep my blog up and running and you're helping me provide for my family 👨👩👧👦 so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
--------------------------------------------------------------
🌎 https://www.ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
excelexciting.com/forums
--------------------------------------------------------------
Join our Meetup group Saudi Arabia, Microsoft Excel & PowerPlatform Meetup
meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------------------------------------------
👍🏻 Like Facebook Page :
facebook.com/ExcelExciting
👥Join The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks
⏱ Time Stamp
00:00 Intro
00:28 Download & Install Microsoft Office
01:35 Microsoft Office Update
01:55 Login with your subscription
02:31 Check Microsoft Office M1 compatibility
03:00 Testing Microsoft Office startup performance
04:25 Enroll for Microsoft Office Insider Program
04:55 End
--------------------------------------------------------------
🛒 Affiliate links :
- Support me with your Amazon purchases: amzn.to/3tR4AUN
- Buy Office365: bit.ly/3nKcbnk
📣 Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so you're helping me keep my blog up and running and you're helping me provide for my family 👨👩👧👦 so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
--------------------------------------------------------------
🌎 https://www.ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
excelexciting.com/forums
--------------------------------------------------------------
Join our Meetup group Saudi Arabia, Microsoft Excel & PowerPlatform Meetup
meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------------------------------------------
👍🏻 Like Facebook Page :
facebook.com/ExcelExciting
👥Join The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
You can check the following videos as well
***********************************************************
#Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks
⏱ Time Stamp
00:00 Intro
00:20 Install Virtual Machine Apple Mac M1 Pro
01:25 Get Windows 11 (Insider & Non-insider)
02:20 Download Windows 11 Insider for Apple M1 Pro/Max
04:10 Install Windows 11 for Apple M1 Pro/Max
06:09 Working Windows 11 on M1 Pro Macbook
06:45 Add the VM already Installed
07:20 Side by Side View Windows Insider & Non-Insider
07:51 Testing Excel for Windows 11 on M1 Pro Macbook
09:13 End
--------------------------------------------------------------
🛒 Affiliate links :
- Support me with your Amazon purchases: amzn.to/3tR4AUN
- Buy Office365: bit.ly/3nKcbnk
- Resources: excelexciting.com/resources
- Buy Parallels for Mac: https://prf.hn/click/camref:1011lkbW8/creativeref:1100l33242
📣 Disclosure: Affiliate links, which means there is no additional cost to you. I will receive a small commission if you make a purchase using the links. By doing so you're helping me keep my blog up and running and you're helping me provide for my family 👨👩👧👦 so for that I truly thank you for your support. Please only purchase the products if you believe they will add value to you.
--------------------------------------------------------------
Register Windows Insider Program: insider.windows.com/en-us
Download Windows 11 VHDX File: microsoft.com/en-us/software-download/windowsinsiderpreviewARM64
--------------------------------------------------------------
🌎 https://www.ExcelExciting.com
Connect to our forums feel free to ask queries & answer them
excelexciting.com/forums
--------------------------------------------------------------
Join our Meetup group Saudi Arabia, Microsoft Excel & PowerPlatform Meetup
meetup.com/saudi-arabia-microsoft-excel-power-platform-meetup
--------------------------------------------------------------
👍🏻 Like Facebook Page :
facebook.com/ExcelExciting
👥Join The Facebook Group -
facebook.com/groups/ExcelExciting
***********************************************************
You can check the following videos as well
Extract Multiple Matching Records
youtu.be/pTVxxaZQx24
Learn how to use Microsoft Flow / Power Automate
youtu.be/HQyxnPYW9Jc
NON-VBA Solution Convert Number to Words In Microsoft Word [mac & windows]
youtu.be/W1Ghyp6Rla0
Hindi-Convert Number to Words In Microsoft Word [mac & windows]
youtu.be/mWmgbU97ZUs
***********************************************************
#M1PRO #M1MAX #M1 #APPLE #APPLESILICON #ExcelExciting #MicrosoftCreators #ProductivityHack #MadeWithCamtasia


