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:
- FREE CLASSES online about Excel/VBA/Power Query on my YouTube channel:
- How to combine in a folder multiple files with different column headers
- How to Sum columns by criteria on the column header in Power Query
- Separating text in one cell into multiple columns – Power Query vs Excel Features
- Make your Pivot Tables in Excel update automatically without having to click refresh
- Excel – improvements and new features:
- Excel Events:
- PAST – Dates and Times in Excel – Some cool Tricks Meni Porat explained some features of the dates and times in Excel, some of which aren’t well-known. He also demonstrated some cool tricks and methods to deal more cleverly and effectively with issues related to dates and times.
- MAY 25 – From Data 2 Dashboard in 1 Day! covers everything you need to know to build state-of-the-art dashboards. With Excel and nothing more than Excel. This presentation does not list all kinds of neatly shaped examples but is a project approach to building dashboards in Excel.
- Content you don’t want to miss:
- Recommended Books:
- 2022-04 (Apr) – Topics:
- FREE CLASSES online about Excel/VBA/Power Query on my YouTube channel:
- How to combine in a folder multiple files with different column headers
- Excel – improvements and new features:
- Files with Macros coming from web blocked by default VBA macros are a common and easy way for mal intended hackers to deploy malware and ransomware.
- Power Query updates in Excel for Mac Microsoft continues to enable Power Query functionality inside of Excel for Mac.
- Shape data with Power Query Editor in Excel for Mac Subscribers to the Office Insider Program can clean and shape data from local files, SharePoint, SQL, and tables and ranges with Power Query Editor in Excel for Mac!
- Excel Events:
- PAST – Dates and Times in Excel – Some cool Tricks Meni Porat explained some features of the dates and times in Excel, some of which aren’t well-known. He also demonstrated some cool tricks and methods to deal more cleverly and effectively with issues related to dates and times.
- MAY 25 – From Data 2 Dashboard in 1 Day! covers everything you need to know to build state-of-the-art dashboards. With Excel and nothing more than Excel. This presentation does not list all kinds of neatly shaped examples but is a project approach to building dashboards in Excel.
- Content you don’t want to miss:
- Recommended Books:
- FREE CLASSES online about Excel/VBA/Power Query on my YouTube channel:
2022-03 (Mar) – Topics:
- FREE TUTORIALS online about Excel/VBA/Power Query on my YouTube channel:
- I am converting some of the tutorials into blog posts to help more people find help for common challenges in Excel and Power Query. This is my most recent blog post: How to share workbooks with data resulting from Power Query without allowing other users to refresh the queries
- Excel – improvements and new features:
- Announcing New Text and Array Manipulation Functions in Excel Are you sitting down and holding tightly? Wait for it – Microsoft released 14 new functions in Excel (Office Insider) in the last few days to work magic with text and arrays.
- Better insights from Analyze Data feature. The Analyze Data feature (available for Office Insiders) lets you use natural language to ask for insights into your data.
- Refresh stock quotes automatically in Excel (available for Office Insiders) Excel will update your Stock Data automatically as it now refreshes when you open the file and every 5 minutes while the file is open.
- Copy from status bar Insiders can do more than just look at the summaries in the status bar. You can now select the aggregated value (sum, average, count etc.) and save it temporarily to your clipboard and paste it back to your workbook, an email or anywhere else you’d like.
- New Pivot Tables and Slicer functionalities; Improved Formulas menu and Function library Pivot tables can now be filtered and sorted using the right-click menu.
- Excel Events:
- PAST – Thinking Smart: Process Behavior Charts Tracking your business processes can help with managing and planning.
- APR 20 – Dates and Times in Excel – Some cool Tricks Meni Porat will explain some features of the dates and times in Excel, some of which aren’t well-known.
- Content you don’t want to miss:
- Recommended Books:
2022-02 (Feb) – Topics:
- FREE CLASSES online about Excel/VBA/Power Query on my YouTube channel:
- I have been very busy recording the course lessons for my new training program Excel Snap Reports, and for that reason there have been no new videos on my YouTube channel lately. You can still enjoy the previous content of over 100 videos on a range of topics on Excel, Power Query, VBA, Pivot Tables, Excel features and functions and more.
- GUEST PRESENTER:
- Excel – improvements and new features:
- Run your Office Scripts using a button in Excel for Windows Excel for Windows Desktop is one step closer to making Office Scripts an automation solution that you can use to manage your workflow anytime and anywhere.
- Announcing LAMBDAs to Production and Advanced Formula Environment, A Microsoft Garage Projects. LAMBDA and LAMBDA helper functions are now available in the Current Channel! You are only limited by your imagination for the ways you can use them.
- Did you know that you can use Excel, Word, PowerPoint or more for FREE with Office on the web? All you need is a Microsoft account and log into Office.com
- New Excel for the Web charting features. – now you can use the Format Pane to edit your chart properties including Titles, Legend, Axis, Series etc.
- Microsoft introduced a new Feedback portal for Excel ideas and suggestions to improve Excel and other products. Browse through the current suggestions, add your comments, cast your vote or add your suggestions – Microsoft is listening!
- Excel Events:
- PAST Consolidate, shape, and re-use web data with Power Query in Excel with David Monroy David demonstrated using Power Query in Excel to read and shape a single web page and then moved on to consolidating data from thousands of individual websites.
- MARCH 16 – Thinking Smart: Process Behavior Charts Tracking your business processes can help with managing and planning.
- APR 20 – Dates and Times in Excel – Some cool Tricks Meni Porat will explain some features of the dates and times in Excel, some of which aren’t well-known.
- Recommended Books:
- Master your Data with Power Query in Excel and Power BI by Ken Puls and Miguel Escobar.
- Coming soon (July 2022) – Guerrilla Data Analysis Using Microsoft Excel: Conquering Crap Data and Excel Skirmishes Third edition by Oz du Soleil and Bill Jelen.
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:
- JAN 26 Mark Proctor demonstrates automating processes using Office Scripts and Power Automate. Office Scripts and Power Automate with Mark Proctor
- JAN 27 I am presenting about Parameters and Custom Functions in Power Query in Excel to the Baku Power BI, Excel & Innovative Educators’ Meetup Group. You can register here for free.
- FEB 9 – 11 The Global Excel Summit is a premium global conference bringing together the brightest minds from the world of Excel. Get 10% OFF your ticket with code CELIA10.
- 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.
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.
Project: our complete system data entry, invoicing , accounts payable , accounts receivableOutcomes 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.
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.
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!
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.