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:

2022-05 (May) – Topics:

2022-03 (Mar) – Topics:

2022-02 (Feb) – Topics:

2022-01 (Jan) – Topics:

  • FREE CLASSES online about Excel/VBA/Power Query on my YouTube channel:
    • How to rename columns in Power Query that change the name on each data update.
    • Ways of recycling work in Power Query and saving time.   
    • How to combine pivoted data from multiple sheets in an Excel file when you are not sure how many sheets your source file will have.
  • Excel – improvements and new features:
    • Excel for Windows Desktop is getting one of the most awaited features for years! Searchable and AutoComplete dropdown lists.
    • Announcing Data Types APIs: Data Types in Excel Add-ins Microsoft has developed a new API which allows developers to create their own custom data types
    •  Excel for the Web is getting better and better and a must-use tool for collaborate work.
    • Conditional Formatting also received significant improvements in Excel online.
    • Excel for the Web can handle more files and larger files
  • Excel Events:
  •  Recommended Books:

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.

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 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 that she had automated some financial statements for other clients.

I realized how powerful her services would be for my company.

Celia understood the challenge immediately and created several solutions that literally reduced the amount of time I spent on creating and disseminating financial information by 10 hours per month.

The work Celia did for me is paying off in spades!
So easy now to run all my volume and commission reports.
Wonderful! I strongly recommend her services. It was a pleasure working with her.

Antonio Carapuço IAF Treasurer Solve & Excel
I decided to work with Celia Alves after looking at the good references about her.

As treasurer of “The International Association for Falconry”, I need an Excel tool to import the income and expense entries from different sources and merge them on a comprehensive scheme to present to our members. The goal was also to facilitate my work and eliminate, as much as possible, the manual work to post all the transactions.

After a short period, I have the right solution. Much easier now!
Many thanks, mission accomplished!

Antonio Carapuço, IAF Treasurer
Francis de La Torre Solve & Excel
Celia is at the top of her game, Excel is a great bit of software but hard to master, and this is where Celia comes in. She really knows her stuff. Very helpful and accommodating, especially as the project grew in complexity.
Francis De La Torre, Certum - Director