-------------------------------------------------------------- 🛒 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
Write formulas with STYLE with Excel Advanced Formula Environment (Mac & Windows)Faraz Shaikh2022-03-16 | In this video, we will learn how to formulas with Style using Excel Advanced Formula Environment
-------------------------------------------------------------- 🛒 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 #ExcelTricksUnlock The Power Of Data Tables In Microsoft Excel! 📊Faraz Shaikh2024-06-29 | I'm thrilled to have met my fellow Excel MVP 🏆 from Australia Danielle Stein Fairhurst here in Riyadh. We had an amazing time sharing insights, exchanging tips, and discussing the latest Excel innovations. It's always great to meet another MVP 🏆 and connect with such talented professionals from around the globe 🌍.
⏱ 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 #datatablePower BI Integrations and My Favorite Excel Secrets with Belinda AllenFaraz Shaikh2024-03-20 | Join us at this Excel Meetup to hear from Belinda Allen from United States 🇺🇸 about see the power of Power BI Integrations and My Favorite Excel Secrets. For many years, Belinda Allen presented at a variety of Microsoft and User Group events with several other people in a contest called “The Excel Shootout.” Basically, it was a competition to see who could “WOW” the audience more with cool Excel Features. As a result, Belinda learned a lot of secrets.
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.”
----------------------------------------------------- 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).TOP 20 NOT discovered tips in Excel with Nurana NovruzovaFaraz Shaikh2024-02-10 | Join us at this Excel Meetup to hear from Nurana Novruzova from Azerbaijan 🇦🇿 about See the power of TOP 20 NOT discovered tips in Excel
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.
----------------------------------------------------- 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 & Power Automate (Work Best Together) with Faraz ShaikhFaraz Shaikh2024-02-03 | Join us at this Excel Meetup to hear from Faraz Shaikh from Saudi Arabia 🇸🇦 about Excel & Power Automate (Work Best Together)
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.
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).See the power of Power BI in 90 minutes: Marketing Dashboard with Power BI with Nurana NovruzovaFaraz Shaikh2023-11-19 | Join us at this Excel Meetup to hear from Nurana Novruzova from Azerbaijan 🇦🇿 about See the power of Power BI in 90 minutes: Marketing Dashboard with Power BI
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.
----------------------------------------------------- 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).Python in Excel | Ndeyanta Jallow, Chris Gross and Keyur PatelFaraz Shaikh2023-10-26 | Welcome to a new season of Excel meetups for our meetup group!
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)Excel-ing Beyond Limits: A Business Birthed from Spreadsheets with Traci WilliamsFaraz Shaikh2023-09-21 | Join us at this Excel Meetup to hear from Traci Williams from United Kingdom 🇬🇧 about Excel-ing Beyond Limits: A Business Birthed from Spreadsheets
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.
----------------------------------------------------- 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).Source control and version control for Power BI. Who should use what, when, where and how! SoheilFaraz Shaikh2023-08-26 | Join us at this Excel Meetup to hear from Soheil Bakhshi from New Zeland 🇳🇿 about Source control and version control for Power BI. Who should use what, when, where and how!
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.
----------------------------------------------------- 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).Excels Most Annoying Features (And What I Did To Fix Them) with Erik OehmFaraz Shaikh2023-07-18 | Join us at this Excel Meetup to hear from Erik Oehm from USA 🇺🇸 about Excel's Most Annoying Features (And What I Did To Fix Them)
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.
----------------------------------------------------- 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).How to create Actionable reports in Excel with Tine OzimicFaraz Shaikh2023-06-16 | Join us at this Excel Meetup to hear from Tine Ozimic from Slovenia 🇸🇮 about How to create Actionable reports in Excel
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.
----------------------------------------------------- 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).How to Add Totals to a Clustered Column Chart in Excel [Step-by-Step Tutorial]Faraz Shaikh2023-06-07 | Learn how to enhance your clustered column charts by adding totals with this easy-to-follow tutorial. Discover the simple steps to calculate and display totals in your Excel or PowerPoint clustered column charts.
⏱ 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
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 #excelchartsAI in Power BI with Liji ThomasFaraz Shaikh2023-05-26 | Join us at this Excel Meetup to hear from Liji Thomas from United States 🇺🇸 about AI in PowerBI
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).Change Mouse Pointer Color & Size In Microsoft Windows 11 - #Shorts 0011Faraz Shaikh2023-04-24 | In this video, we will learn a simple way to change your mouse color and size on Windows 11
-------------------------------------------------------------- 🛒 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
*********************************************************** #Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks #WindowsThe lesser known parts of Excel with David StavegårdFaraz Shaikh2023-04-20 | Join us at this Excel Meetup to hear from David Stavegård from Sweden 🇸🇪 about The lesser known parts of Excel
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.
----------------------------------------------------- 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).Highlight the Highest value row-wise by comparing two columns in ExcelFaraz Shaikh2023-04-15 | In this video, we will learn how to Highlight the Max value row-wise by comparing two columns in Microsoft Excel
⏱ 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 #ExcelTricksInsert Euro € symbol on Excel for Mac - #Shorts 0010Faraz Shaikh2023-03-31 | In this video, we will learn how to Insert Euro € symbol on Excel for Mac
-------------------------------------------------------------- 🛒 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 #ExcelTricksIntroducing the Measure Killer with Gregor BrunnerFaraz Shaikh2023-03-16 | Join us at this Excel Meetup to hear from Gregor Brunner from Switzerland 🇨🇭 about Introducing the ""Measure Killer""
""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.
--------------------------- 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.
----------------------------------------------------- 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).Remove VLOOKUP ERROR #N/A - #Shorts 0009Faraz Shaikh2023-02-28 | In this video we will learn how to remove vlookup error -------------------------------------------------------------- 🛒 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 #xlookupLAMBDA : Robustness and Reusability with Owen PriceFaraz Shaikh2023-02-16 | Join us at this Excel Meetup to hear from Owen Price from United States 🇺🇸 about LAMBDA: Robustness and Reusability
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
----------------------------------------------------- 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).How to use Excel Function TIMEVALUE - #Shorts 0008Faraz Shaikh2023-02-10 | In summary, the Excel TIMEVALUE function is a useful tool for working with time data in spreadsheets. It converts text strings that represent times into serial numbers that can be used in calculations. To use the function, enter the text string into the function's parentheses and make sure the string is formatted correctly
-------------------------------------------------------------- 🌎 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 #excelformulaExcel Formula Value Tooltip (New Feature) #Shorts - 0007Faraz Shaikh2023-02-01 | In this video, we will learn how to use excel Formula Value Tooltip new feature Complete Video : youtu.be/_wtptGCwBQc
*********************************************************** #Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks #excelshorts #excelshortsvideoGet Instant Formula Results with the New Value Tooltip Feature (English)Faraz Shaikh2023-01-28 | Are you tired of debugging your excel formulas by pressing F9 & CTRL+Z? Look no further! In this video, we will be introducing you to the new Formula Value Tooltip feature in Excel.
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!
⏱ 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
*********************************************************** #Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricksChat GPT + Excel: How AI is writing Excel Formulas and VBA Code 🤖Faraz Shaikh2023-01-23 | In this video, we have a competition with ChatGPT Open AI vs AI (Artificial Intelligence vs Actual Intelligence). Chat GPT AI is a tool that can be used to automate certain tasks and make them more efficient, but it does not have the ability to take control of its own.
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 #ExcelTricksLearn to Visualise using DAX Tricks in Power BI with Pragati JainFaraz Shaikh2023-01-19 | Join us at this Excel Meetup to hear from Pragati Jain from United Kingdom 🇬🇧 about Learn to Visualise using DAX Tricks in Power BI
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.
----------------------------------------------------- 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.
#powerbi #excelexciting #powerbiproExcel Flash Fill Trick By Oz (Excel On Fire) with Faraz Shaikh Excel ExcitingFaraz Shaikh2022-12-20 | I was in Bulgaria and got a change to make a trick video with Oz Du Soleil from @OzduSoleilDATA , Thank for such lovely Excel Trick Oz Ji.. Thank your for always guiding and mentoring me..
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 #ExcelTricksFIFA 2022 winning goal 🥅 Argentina 🇦🇷Faraz Shaikh2022-12-18 | ...FIFA winning goal ArgentinaFaraz Shaikh2022-12-18 | ...Cube Functions - Where the Worksheet Meets the Data Model with Mike ThomasFaraz Shaikh2022-12-15 | Join us at this Excel Meetup to hear from Mike Thomas from United Kingdom 🇬🇧 about Cube Functions - Where the Worksheet Meets the Data Model
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.
----------------------------------------------------- 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)."Find your lost iPhoneFaraz Shaikh2022-12-09 | In this video we will see how to find your lost iPhone at home, Office anywhere. -------------------------------------------------------------- 🛒 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 #ExcelTricksSuper Cool FILTER Excel Tip Chandeep (Goodly) with Faraz Shaikh (ExcelExciting.com)Faraz Shaikh2022-12-08 | In this video, my friend @GoodlyChandeep demonstrating a SUPER COOL Excel Filter Trick that will blow up your mind. Let us know in the comment session have you seen this trick before?
⏱ 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🔮 Excel Trick By Chandoo with Faraz Shaikh - ExcelExciting.comFaraz Shaikh2022-11-27 | In this video, we will learn simple excel tip by one and only @chandoo_, lets hear from him what he have to say.
⏱ 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 #bulgariaHow Power Query has transformed my routine at work! with Alejandra HorvathFaraz Shaikh2022-10-11 | Join us at this Excel Meetup to hear from Alejandra Horvath from Canada 🇨🇦 about How Power Query has transformed my routine at work!
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.
----------------------------------------------------- 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)."International Networking with Alan Murray (@Computergaga)Faraz Shaikh2022-10-06 | Join us at this Excel Meetup to hear from Alan Murray about the "International Networking with computer gaga".
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).Pivot Tables simplicity or CUBE Functions flexibility? You decide with Bernard Obeng BoatengFaraz Shaikh2022-08-15 | Join us at this Excel Meetup to hear from Bernard Obeng Boateng from Ghana 🇬🇭 about Pivot Table's simplicity or CUBE Function's flexibility? You decide
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.
----------------------------------------------------- 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)."Power Query - Move the Grand Total to the left or to the first column in Excel PivotTableFaraz Shaikh2022-08-13 | In this video, we will learn how to Move the Grand Total to the left or to the first column in Excel PivotTable by building a power query solution in Excel for Mac and windows. Currently, Mac doesn't support loading it as a PivotTable report, for that you need to load the data on the worksheet and then create Pivot Report
⏱ 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 #ExcelTricksMove the Grand Total to the left or to the first column in Excel PivotTableFaraz Shaikh2022-07-29 | In this video, we will learn, how to Move the Grand Total to the left or to the first column in Excel PivotTable. While we are working with PivotTable in Microsoft Excel the Grand Total columns always appear on the right side and at the end of the records. One of my friends ask me if it could be possible to move the Grand Total column to the beginning of records as it would help to see the totals first and then the rest of the value.
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
📣 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
Create Organizational & Business Flowcharts Linked to Excel youtu.be/Cor1mixgotY
*********************************************************** #Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricksPython for Excel with Felix ZumsteinFaraz Shaikh2022-07-06 | www.mydatasummit.com 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).
----------------------------------------------------- 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 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.
----------------------------------------------------- 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)."Discover DAX Fundamentals Through Common Mistakes with Fowmy AbdulmuttalibFaraz Shaikh2022-05-18 | Join us at this Excel Meetup to hear from Fowmy Abdulmuttalib from Saudi Arabia 🇸🇦 about Discover DAX Fundamentals Through Common Mistakes
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.
----------------------------------------------------- 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)."Microsoft Excel Power Query Editor for Mac 💻 is finally here !!Faraz Shaikh2022-04-24 | In this video, I'll walk through you the new editor release from Microsoft Excel Power Query for Mac. It was one of the most requested features for Excel for Mac and the wait is over finally, the Microsoft team did a great job by adding this editor for Excel for Mac users. This is currently in beta version (Office Insider) which means you need to enroll in the Office Insider program to get this editor.
⏱ 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
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 #ExcelTricksCreating your first report in Power BI Report Server with Harshavardhan TamminaFaraz Shaikh2022-04-16 | Join us at this Excel Meetup to hear from Harshavardhan Tammina from New Zealand 🇳🇿 about Creating your first report in Power BI Report Server
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.
----------------------------------------------------- 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).Excel Charts with Dynamic Arrays with Carlos BarbozaFaraz Shaikh2022-03-16 | Join us at this Excel Meetup to hear from Carlos Barboza from Peru 🇵🇪 about Excel Charts with Dynamic Arrays
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.
----------------------------------------------------- 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).Stack Data In Excel Using Dynamic Arrays (Excel for Mac & Windows)Faraz Shaikh2022-03-10 | In this video, we will learn how to Stack Data In Excel Using Dynamic Arrays (Excel for Mac & Windows), with a few simple steps and your data is stacked in Excel
⏱ 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
*********************************************************** #Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks #StackDataMicrosoft Excel NEW Advanced Formula Environment (AFE) - (Mac & Windows)Faraz Shaikh2022-02-26 | In this video, we will learn how to use the Microsoft Excel NEW Advanced Formula Environment (AFE). The new AFE is rich and advanced formula writing experience in Excel. It has made it easy to share and import Lambdas in Excel so we don't need to re-invent the wheel.
⏱ 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
*********************************************************** #Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricks #AFEI Automated 🤖 my Meetup Event with Power Automate Desktop & ExcelFaraz Shaikh2022-02-17 | In this video, we will be showing you the automation project which I have been working a couple of days & I successfully managed to organize my Saudi Arabia Meetup event by automating the task. This real business scenario. I took the help of Power Automate & Excel to make it possible.
⏱ 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 #ExcelTricksThe Versatile Lookup Functions with Victor MomohFaraz Shaikh2022-02-17 | Join us at this Excel Meetup to hear from Victor Momoh from Nigeria 🇳🇬 about "The versatile Lookup Functions". The place of the lookup functions in Excel cannot be overemphasized. They help to lookup a value, range, array, and return a result of your choosing. That a function does not have the text "LOOKUP" in it does not mean it can't perform the lookup function. In this session, we will explore some creative uses of these functions and show their versatility. A little of LOOKUP, VLOOKUP, XLOOKUP... let's keep the others a secret. This would be exciting.
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.
----------------------------------------------------- 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).Convert Numbers to Percentage [Part 02] - #Shorts 0006Faraz Shaikh2022-02-11 | In this video, we will learn how to convert numbers to percentage values in Microsoft Excel -------------------------------------------------------------- 🛒 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
*********************************************************** #Excel #FarazShaikh #ExcelExciting #MicrosoftCreators #ExcelTips #ProductivityHack #MadeWithCamtasia #ExcelForMac #ExcelForWindows #ExcelTricksHow to Install Microsoft Office 365 On Apple M1 Pro/Max Macbook (2021)Faraz Shaikh2022-02-02 | In this video, we will learn how to install Microsoft office 365 on Apple Silicon M1 Pro/Max Macbook's. I would strongly recommend you to download Microsoft Office from Microsoft website via Office.com rather than Apple Stores. Downloading Microsoft Office from Microsoft allows you to enroll in an insider program. In this video, we will also test the performance of Microsoft Office on the Apple M1 Pro Macbook
⏱ 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 #ExcelTricksHow to Install Windows 11 on Apple M1 Pro/Max (Non-Insider & Insider)Faraz Shaikh2022-01-25 | In this video, with simple and easy steps we will learn how to install windows 11 on apple macOS Monterey, Big Sur using a virtual machine. We will be using parallels to do the step on apple mac M1 Pro/Max Macbooks. Note that this installation demo is applicable only for that MacBook with an Apple Silicon M1 Pro/Max ARM64 chipset. The steps to install windows 11 insider on M1 Pro/Max machine are easy steps.
⏱ 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