Newsletter

“You never know when a piece of information can impact someone’s life!”

SUBSCRIBE

to Receive our Newsletter to keep on top of the latest additions in Excel

Check the Newsletter Past Issues:

2021-06 (Jun) – Topics:

• FREE CLASSES online about Excel/VBA/Power Query on my YouTube channel and blog:
  • How to import and clean data from a web page with Power Query into Excel.
  •  Dealing with dates prior to 1900 in Excel with Power Query.   
• Participation in the Excel Weekend 7
• Participation in A Bit of Excel – Power Query _The tool that can save you Hours of WORK in Excel
• Participation in Excel Office Hour: Tips for more productivity with Power Query in Excel
• Excel – improvements and new features:
  • Office Scripts allows users with all levels of programming experience to automate their repetitive workflows.
  • Excel for the Web.Several improvements and new features available, including Text to Columns and enhanced Pivot Table settings.
  • Office Add-ins. Add custom keyboard shortcuts to your Office Add-ins in Excel.
• Content you do not want to miss:
  • Convert VBA user-defined functions to LAMBDA functions by Jan Karel Pieterse
•  Events:
  • MS Excel Toronto Meetup sessions
  • Financial Modeling World Cup

2021-05 (May) – Topics:

• FREE CLASSES online about Excel/VBA/Power Query on my YouTube channel:
  • Learn how to build a Timesheet System – Exclusive access to this playlist to readers of the newsletter.
  • Importing multiple Google Sheets files with Power Query in Excel – Claudia Roxo.
  • How to get the data from the 1st of the current month onwards with Power Query
• Excel – improvements and new features:
  • New data types and smart templates powered by Wolfram are now generally available.
  • Make your Excel documents accessible to people with disabilities
  • Add custom keyboard shortcuts to your Office Add-ins in Excel Power BI connected PivotTables in Excel for the web
  • Collaborate with confidence: Introducing Show Changes for Excel on the Web
• Content you do not want to miss:
  • If you use Excel for Mac, you may want to add Ron de Bruin’s website to your favorites. Mac Excel Automation
  • Import data from local files using Power Query in Excel for Mac
  • Power BI, Excel Organisation Data Types And Images article by Chris Webb.
  • Get Power BI data in Excel without Pivot Tables | Excel Data Types video by Ruth Pozuelo, Curbal channel.
•  Events:
  • MS Excel Toronto Meetup sessions
  • Excel Weekend 7 – FREE ONLINE

2021-04 (April) – Topics:

• FREE CLASSES online about Excel/VBA/Power Query on my YouTube channel
• Participation on Bill Jelen’s channel (MrExcel) talking about Rounding methods in Excel and Power Query.
• Participation on Ruth Pozuelo’s channel (Curbal) talking about best practices when building charts in Excel.
• Excel – improvements and new features:
  • POWER QUERY NEW OFFICIAL ICON, WEBSITE, BLOG AND TWITTER
  • Tracking changes in Excel Online workbook
• Content you do not want to miss:
  • How to embed Excel file on a website
  • LAMBDA function
• Tech News:
  • Microsoft is retiring USERVOICE
• Events:
  • MS Excel Toronto Meetup sessions

2020-09 (September) – Topics:

• Video Tutorial: Enable Background Refresh property in Power Query in Excel
• Training offer: Power Query Fundamentals in Excel
• Excel – improvements and new features:
  • PDF Connector for Power Query
  • Natural Language in Excel
  • Excel Online
  • Date Picker Add-In
  • Excel and Power BI
  • Office Scripts
  • Excel Uservoice
• Content you do not want to miss:
  • Microsoft’s updated documentation for Power Query
  • API’s in Power Query
  • Power Query Geography And Geometry Functions In Power BI And Excel
• News:
  • Scientists rename human genes to stop Microsoft Excel from misreading them as dates
  • Researchers bring Google Sheets and Microsoft Excel into VR
  • Excel Virtually Global Summit Raises $15,000 For Charities
• Events:
  • Microsoft Ignite 2020
  • MS Excel Toronto sessions & October SPECIAL EVENT

2020-07 (July) – Topics:

• Excel dynamic array functions – SORT, SORTBY, SEQUENCE, FILTER, UNIQUE and RANDARRAY
• Other new Excel formulas – XLOOKUP, XMATCH and LET
• Excel new features – Sheet View
• Excel new collection of Data Types
• Excel mobile version – Insert data from picture
• Office Scripts – the new programming language that allows the user to create scripts that will run the same way in Excel for Windows, Excel for Mac, and Online.
• Training offer: Power Query Fundamentals in Excel
• Video Tutorial: The Longest Absence with Power Query and M Code in Excel
• Presentation Sessions in English:
  • Fundamentals with Tips & Tricks of POWER QUERY (ETL Tool) in Microsoft Excel
  • Power Query Tips and Tricks
  • Speed up your reporting processes with Advanced Filters and VBA
• Presentation Sessions in Portuguese:
  • Conceitos Básicos de Power Query no Excel
  • Pontos de Atenção ao Unificar Dados no Power Query
• Excel Events – MS Excel Toronto meetup group next sessions