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:

2022-11(Nov) – Topics:
The following is a summary of the November 2022 newsletter, the original newsletter can be opened “here

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