Newsletter

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

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

Client Reviews

Celia is an amazing contractor. She far exceeded my expectations for the job. I would and will use her again and again for any and all similar needs.