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-11(Nov) – Topics:
The following is a summary of the November 2022 newsletter, the original newsletter can be opened “here”
- GUEST PRESENTER:
- The Global Excel Summit is an award-winning Microsoft Excel virtual conference for professionals and enthusiasts, bringing together 30 of the brightest minds from the world of Excel on Feb 6th to Feb 8th, 2023. I will be one of the speakers presenting about “The magic of NAMES in Excel” and would love to see you there. Get 10% OFF your ticket with code CELIA10
- Excel Improvements and New features:
- You can find here a summary of what was announced as new for Excel in October. Below are more details about some of the features.
- Find the command you need [Windows Current Channel] [Web].
The shortcut menus are now searchable! This works in Word, Excel, and PowerPoint. - Navigation pane [Windows Current Channel]
This new feature makes it easy to find tables, charts, shapes and more in your workbook. Check it out! - New DAX Functions in Excel Data Models and Power Pivot [Insiders Beta]
Microsoft brought out 92 new DAX functions into Excel Insiders Beta – That is not a typo! - New keyboard shortcut for Pasting as Values [Insiders Beta]
Show Changes See what other users modified in a spreadsheet. [Windows Current Channel]
- Automate Tasks with Office Scripts (Insiders) [Mac Insiders]
Office Scripts enables you to automate repetitive tasks in your spreadsheet workflows, helping you save time by increasing efficiency and reducing errors in your workflow.
- New Web.Headers M function [Power Query Online] [Power Query Desktop]
This function allows you to make HEAD requests to web services – the existing Web. - Check if a specific feature is in your version of Excel
Check out this spreadsheet with a matrix showing features available for each version of Excel.
- Excel Events:
-
- NEXT – DEC 7 – Exploring Excel’s new Text and Array Functions + LET |Victor Momoh In this session, we will consider some of the 14 new array and Text functions and how to creatively use them to solve our daily problems.
- PAST – OCT 19 – Advanced Excel Skills for Financial Modeling | Ian Schnoor During this webinar, Ian covered some critical Excel skills that are helpful in the construction of financial models.
- PAST – Nov 16- The Magic of Filters in Power Query | Alejandra Horvath Alejandra presented examples on how to filter through one or several conditions, using parameters, a list, or cells in excel, By specific text or range of numbers before expanding tables
-
- Recommended Books:
- Power BI for the Excel Data Analyst e-Book by Wyn Hopkins.
- Advanced Excel Formulas: Unleashing Brilliance with Excel Formulas Alan Murray (also available on Amazon)
- Microsoft 365 Excel: The Only App That Matters by Mike Girvin.
- Guerrilla Data Analysis 3rd Edition by Oz du Soliel and Bill Jelen.
2022-10(Oct) – Topics:
The following is a summary of the October 2022 newsletter, the original newsletter can be opened “here”
- FREE CLASSES online about Excel/VBA/Power Query on my YouTube channel:
Combining text from cells in the same column in Power Query without combining the whole rows - GUEST PRESENTER:
- Presented at the first edition of My Data Summit in September along with more than 30 other MVPs and Excel experts from around the world. My presentation was on the topic “The Excel features and skills you need to automate a reporting procedure.” My Data Summit was a very successful event. I recommend that we keep an eye on it for the next editions.
- Excel Improvements and New features:
- Excel for the Web
–New Excel Functions – 14 functions to manipulate text and arrays including TEXTBEFORE / TEXTAFTER, VSTACK / HSTACK, CHOOSEROWS / CHOOSECOLS
-Power Query Group operations
–Improvements to the connected Power BI experience – for when you notice Excel lagging too much.
-Add and edit rich text formatting - Rich text formatting allows the user to add formatting to only part of the text within a cell. You can use the ribbon or shortcuts to add the formatting.
-Sort by color or icon from auto filter menu
-Edit files with legacy data connections
-Edit files with legacy Shared Workbook feature
-Delete chart elements
-Multiline formula bar
–Check performance
-Sharing a section of Excel workbook
–
- Excel for the Web