Solve and Excel Consulting

Did you ask for a class on what you need to know to get started with Power Query? This is it!! :) #Excel #powerquery #masterclass #businessintelligence

YOU ARE INVITED! Join us to celebrate Spreadsheets as a tool. We will hear from people who had been involved in building Excel along the time. Lots of surprises in this session!! Check the event page to learn about our guest speakers:... Bill Jelen Daniel Fylstra Rob Collie David Monroy FREE ONLINE event. REGISTER to attend live: https://www.meetup.com/MSExcelToronto/events/273242966/ #excel #excelhistory #spreadsheets #spreadsheetday #microsoft #microsoftexcel

Expreso #coffee halfway through the morning to get these #Excel #spreadsheets super awesome! Are you an expreso person too?

How error-proof are your #Excel Workbooks? Join us tomorrow to learn from Paula Guilfoyle how you can make sure your spreadsheets are producing the correct results. FREE Online session. Register at:... https://www.meetup.com/MSExcelToronto/events/272758617/ See more

Happy customers make my day! Note from Doug Murphy: "Celia, A huge and heartfelt thank you for the massively heavy lift you and the CEWS Team has successfully concluded to enable Corus to file the application today!... Not only was this a totally new program with new rules, it was also incredibly detailed and complicated. Your dedication to figure this out was wonderful. Making it Happen for sure! Best Doug" I recently received an appreciation note from the CEO of one of the companies I work with. It came after the completion of the first and critical milestone of a complex project. I was responsible to combine several pieces of data to determine which portion of each salary or wage was eligible for a claim to the Government of Canada, in the scope of a program to support businesses during the COVID-19 pandemic. determine which portion of each salary or wage was eligible for a claim to the Government of Canada, in the scope of a program to support businesses during the COVID-19 pandemic. #employeerecognition #corus #corusstar #torontobusiness #Toronto

Last Thursday, the MS Excel Toronto members had a fantastic opportunity to learn from George Mount how #statistical concepts can be "seen" in #Excel. If you are interested in joining the next sessions live, register as a member of the MS Excel Toronto Meetup group here: https://www.meetup.com/MSExcelToronto Thank you, George, for sharing your knowledge with us! ... Thank you to all the attendees for offering your time and all your questions and comments. Thank you, Dick Moffat and Vivek Patel for helping prepare and run this session. #excel #msexcel #meetup #toronto #torontobusiness #businessintelligence

The Excel world is on ! What have you missed? - https://mailchi.mp/d5c8a4b7f994/solveandexcel-world_20200906 Excels awesome new features and tools, amazing learning content and funny tech news. Make sure you stay in the game.

This video is about the "Enable Background Refresh Property" in Power Query in Excel. I will go through a couple of examples to demonstrate what this property does to the query refreshing behaviour and to explain why it is important to pay attention to how we choose to set this property in our Power Query projects. #Excel #msexcel #PowerQuery #vba #PivotTable #businessintelligence #toronto #canada

This video is about the "Enable Background Refresh" property in Power Query in Excel. I will go through a couple of examples to demonstrate what this property does to the query refreshing behaviour and to explain why it is important to pay attention to how we choose to set this property in our Power Query projects.

Are you ready to actually SEE Statistical Concepts? George Mount will bring a few to live in #Excel. Join us this Thursday at the next session of the MS Excel Toronto Meetup group.... ONLINE FREE SESSION registration at: https://www.meetup.com/MSExcelToronto/events/271905609/ Organized with Vivek Patel and Dick Moffat #statistics #meetup #sharingknowledge #toronto

How about CTRL+M as a shortcut to OPEN POWER QUERY in Excel? The idea is up for voting! https://excel.uservoice.com//39775549-ctrl-m-to-launch-pow... #powerquery #excel

#Excel is a powerful tool for #business and many companies rely on it to run their procedures and make #decisions. How risky can that be and how can we mitigate that #risk? Join us on September 16, 2020 to learn from Paula Guilfoyle about this topic and share your thoughts with MS Excel #Toronto #meetup community. The session is FREE. Register on the link below.... https://www.meetup.com/MSExcelToronto/events/272758617/ Organized with Dick Moffat and Vivek Patel.

The MS Excel Toronto held a fantastic session on August 20th with Danielle Stein Fairhurst presenting about Financial Modelling in Excel. If you are interested in joining the next sessions live, register as a member of the MS Excel Toronto Meetup group here: https://www.meetup.com/MSExcelToronto Thank you, Danielle Stein Fairhurst, for sharing your knowledge with us! ... Thank you to all the attendees for offering your time and all your questions and comments. Thank you, Dick Moffat and Vivek Patel for helping prepare and run this session. #excel #msexcel #meetup #toronto #torontobusiness #businessintelligence #financialmodelling #dashboards

The MS Excel Toronto Meetup group passed the 1,000 member mark today! Credits go out to: - all the PRESENTERS, who generously have been offering their time ...and knowledge to the Excel community, - to the group MEMBERS who participate in the sessions, provide valuable and interesting questions and comments and - all who spread the word about the sessions with their network. We never know when a presentation can make a difference to someones professional lives. I have a collection of presentations that impacted greatly my professional path. And to those who presented and organized those talks, my very special thank you too. https://www.meetup.com/MSExcelToronto/ #excel #msexcel #microsoft #meetup #community #learning #sharingknowledge #toronto #businessintelligence #1000members

What is a FINANCIAL MODEL and how to build one in EXCEL? Join us on August 20th to learn from Danielle Stein Fairhurst from presenting to the MS Excel Toronto meetup group. FREE ONLINE SESSION - Register to get the access link:... http://meetu.ps/e/J9MjR/GxkjN/d See more

GET DATA FROM A PDF FILE into Excel - the #PDF connector in #PowerQuery is now available in #Excel for #Microsoft365. https://techcommunity.microsoft.com//announci/ba-p/1569202

On July 30th, OFFICE SCRIPTS was the topic of the presentation and conversation at the MS Excel Toronto meetup group. Paul Kelly demonstrated how creating a Sc...ript in Excel online looks like, and at the end of the session, we had time to exchange some thoughts about what the challenges and benefits of programming with this new language might be. If you are interested in joining the next sessions live, register as a member of the MS Excel Toronto Meetup group here: https://www.meetup.com/MSExcelToronto Thank you, Paul Kelly, for sharing your knowledge with us! Thank you, Sudhi Ramamurthy for attending the session and addressing some of the questions in the chat area of the meeting. Thank you to all the attendees for offering your time and all your questions and comments. Thank you, Dick Moffat and Vivek Patel for helping prepare and run this session. #excel #msexcel #meetup #toronto #torontobusiness #businessintelligence #officescripts

Whats happening in my Excel World? - https://mailchi.mp/84a0ba6399ce/solveandexcel-world_20200725

A cell in #Excel is the smallest range. Knowing how to refer properly and efficiently to a range or how to get a range as a result of a process gives you extra ...power when working with formulas, VBA or Power Query in your Excel projects. Do not miss this presentation by Mark Proctor to the MS Excel Toronto Meetup Group. Youll be surprised by how much there is to learn about Ranges in Excel. Registration Link: https://www.meetup.com/MSExcelToronto/events/272020474/ Organized by the MS Excel Toronto Meetup Group (Dick Moffat, Vivek Patel and Celia Alves) #toronto #torontobusiness #businessintelligence #meetup

How well do you understand the core concepts in #Statistics? George Mount finds #Excel the perfect tool to play with those concepts and visualize their meanin...g by plotting the results of the experiments with different sets of data. Join the MS Excel Toronto Meetup Group for a lesson about Statistics and Data Analysis fundamentals: Organized by Vivek Patel and Dick Moffat. https://lnkd.in/eaDsD-p #dataanalytics #businessintelligence #torontobusiness

What is a #Financial #Model, what makes it a good one and how can we build one in #Excel? Join us in this session of the MS Excel Toronto to learn the answers f...rom those questions and more from Danielle Stein Fairhurst. Registration link: https://www.meetup.com/MSExcelToronto/events/271904300/ Organized by the MS Excel Toronto Meetup group (Vivek Patel, Dick Moffat and Celia Alves.) #financialmodelling

On a recent project related to #CEWS (Canada Emergency Wage Subsidy,) one of the pieces involved figuring out the longest period an employee had been absent from work during a specific range of dates. This video shows how I tackled that challenge with Power Query in #Excel. #PowerQuery #COVID19 #mcode https://www.youtube.com/watch?v=X1z3mC8v5BU

If you have been wanting to start with Power Query in Excel but keep procrastinating, consider enrolling in the masterclass that I am teaching on July 29th in partnership with DATEL Productions. After that one day, you will be able to use Power Query for your work and save lots of time on recurring tasks. Register here: https://lnkd.in/e_W3avU... In the comments, you will find links to presentations that I have done recently about Power Query. #PowerQuery #Excel @Tea Kuseva

The MS Excel Toronto held a fantastic session last week with Vivek Patel who showed us a few ways we can integrate #Excel with #PowerBI and take advantage of th...e best in both worlds. If you are interested in joining the next sessions live, register as a member of the MS Excel Toronto Meetup group at https://www.meetup.com/MSExcelToronto and stay tuned for the next sessions to be announced soon. Thank you, Vivek, for sharing your knowledge with us! Thank you to all the attendees for offering your time and all your questions and comments and Dick Moffat for helping with running the session. #excel #msexcel #meetup #toronto #torontobusiness #businessintelligence #powerbi

And so it happened! Just because Vivek Patel saw the value and potential of what I have been doing for fun! Thank you, Vivek, for nominating me for this award a...nd providing your mentorship. I hope I can continue to live up to this recognition and keep contributing to the fantastic community of professionals who generously share their knowledge every day. A special thank you to my husband and our kids, for their daily support. Thank you also to all of those who, in many different ways, offered their support during the application process. #microsoftmvp #mvp

Since we still cannot enjoy #summer the way we used to, how about dedicating some of the free time to #learning new skills? Check the list of #masterclasses below. Theres something for everyone! And everyone uses #Excel! ;-) https://www.datelproductions.com/summer-masterclass-sessions... #msexcel #powerquery #businessintelligence

I learned a lot of new things in #Excel a few days ago, at the MS Excel Toronto meetup group session presented by Rahim Zulfiqar Ali about Predictive Analytics ...in Microsoft Excel (Forecasting & Regression.) Thank you, Rahim, for sharing your time and knowledge with us! What a fantastic presentation! Thank you to all the participants for joining us! To attend the MS Excel Toronto sessions live register at https://www.meetup.com/MSExcelToronto #excelcommunity #meetup #businessintelligence #dataanalysis

Register for the next MS Excel Toronto Session: Presentation by Vivek Patel. https://www.meetup.com/MSExcelToronto/events/271421097/

Later tonight. Are you coming? #Excel for productive #analytics presented by Rahim Zulfiqar Ali to the MS Excel Toronto meetup group. Organized with Vivek Patel and Dick Moffat.

You are invited to join us at the MS Excel Meetup Group session where we will learn from Vivek Patel about how to combine the capabilities of #PowerBI and #Excel for better #dataanalysis. Register at the link below. Organized with Dick Moffat and Vivek Patel. #meetup #torontobusiness #toronto #businessintelligence

You are invited to join us at the MS Excel Meetup Group session where we will learn from Paul Kelly how to create an #OfficeScript for #Microsoft #Excel. Register at the link below. Organized with Dick Moffat and Vivek Patel. #meetup #torontobusiness #toronto #businessapplications

You are invited to join us at the next MS Excel Meetup Group session where we will learn from Rahim Zulfiqar Ali about #Predictive #Analytics in #Microsoft #Excel. Register at the link below. https://www.meetup.com/MSExcelToronto/events/271411754/ Organized with Dick Moffat and Vivek Patel.... #meetup #torontobusiness #toronto #businessintelligence

The Global Excel Summit was rescheduled and the event already grew, even before its first edition! More speakers, more masterclasses, more exhibitors, more days. Organized with mastery by Tea Kuseva and her team. #globalexcelsummit #excel

(POR) Orgulhosa de ser convidada como membro da MTAC Brasil, cuja misso reduzir a desigualdade social atravs da inovao, pois acreditamos que o conhecimento pode transformar a vida das pessoas. #GoMTACs #MTAC #MTACBrasil (ENG) Proud to have been invited as a member of MTAC Brasil, whose mission is to reduce social inequality through innovation, as we believe that knowledge can transform peoples lives. #knowledgeispower Thank you, Joo Benito Savastano and Heber Lopes, ...for trusting that I can be a valuable member of this community. https://verify.mtac.org.br/Home/Badge

Happening tomorrow this session with Abdelrahman Abdou presenting to the MS Excel Toronto meetup group. If you work with #Excel and dont know what #PowerPivot or #DAX is, you dont want to miss it. Register in the link below.... Dick Moffat Vivek Patel

Two incredible resources for those wanting to improve their #PowerQuery skills: https://bengribaudo.com//power-query-m-primer-part1-introd and https://blog.crossjoin.co.uk/ ... #businessintelligence #bi #dataanalysis