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-08 (Aug) – Topics:

  • FREE CLASSES online about Excel/VBA/Power Query on my YouTube channel:
    • M Language Tips to achieve more with Power Query.
    • How to make Table.Combine include extra column from the previous query step.   
    • Two automations to share Power Query results without allowing to refresh the query.
  • Excel – improvements and new features:
    • New Navigation Pane In Excel provides a vertical list of your sheets and other objects like tables, charts, shapes, etc.
    • Import data from local files with Power Query in Excel for Mac.
    • New Name Manager in Excel for Mac with same capabilities as in Excel for Windows.
    • Wolfram data types now available to Enterprises.
  • Tech News:
    • Wall Street’s Hottest Commodity: College Grads With Excel Skills.
    • Microsoft is looking for your input to help them define the future of automation in Excel. Can you offer 2 minutes to fill in this survey? Thank you in advance for your collaboration.
  •  Recommended Books:

2021-07 (Jul) – Topics:

  • FREE CLASSES online about Excel/VBA/Power Query on my YouTube channel:
    • How to import and clean data from a web page with Power Query into Excel.
    • How to combine pairs of rows in Power Query with different criteria per column.   
    • How to add a File Picker in Excel to select the data source file for Power Query.
  • Excel – improvements and new features:
    • LAMBDA HELPER FUNCTIONS – Microsoft announced the release of seven (wow!!) new functions.
    • Restrict usage of Excel 4.0 (XLM) macros with new macro settings control.
    • New Name Manager in Excel for Mac.
    • Export from Power BI to Excel – improvements for table and matrix visuals.
  • Content you do not want to miss:
    • The Orca Template – Introducing middle-school students to Wolfram Data Types in Excel.
    • Generating Excel Reports Using Power BI, Cube Formulas, Office Scripts And Power Automate.
    • Excel Office Scrips Basics.
  •  Events:
    • MS Excel Toronto Meetup sessions

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.

Ron Gad, Bervely Hills Therapy Group - Executive Director, Clinical Supervisor

Celia was a brilliant contractor; she completed her tasking well in advance of schedule to a high standard. Her level of communication was high and her pricing was fair. I would highly recommend her services.

Chris Hoffman, Cowichan Valley Computer Services - Operator

I had to create a very complex financial spreadsheet that required understanding of mathematics and high-level Excel expertise. There is a lot of complexity to my model and Celia delivered a fantastic job. She was prompt, dedicated, detailed and one week ahead of time. This is a person that I hire again.

Riccardo Ferrari, Bitcoin Cryptocurrency Training - Cryptocurrency Entrepreneur
Project: our complete system data entry, invoicing , accounts payable , accounts receivable

Outcomes and advantages: It is time-saving, It simplifies our workflow, It is easy to use, It avoids data entry errors, It produces professional and accurate reports/documents, It provides me with fundamental insights about my business KPIs

The speed in which this project was accomplished was amazing, the overall results outstanding, the time saving was significant . Would highly recommend Celia’s services.

John Chimuk, Big Dog Containers, Inc - President, Owner
John Cotter - Solve & Excel
The work you did for me is paying off in spades.
So easy now to run all my volume and commission reports.
Wonderful!

I met Celia Alves from watching a youtube video on Excel programming. I saw from her video t