Excel Solutions Team

Excel Solutions Team is located in Houston, Texas, and we provide expert training and consulting for Microsoft Office, VBA & Macros, & Adobe Suite Applications.

[Excel Solutions Team @ExcelSTHouston]

Sick of Conditional Formatting slowing you down? Let numbers color themselves.

Use the custom format [Black]0;[Red]-0 to show positives in black and negatives in red.

Learn more Excel skills at https://t.co/4tZi9VxtxK
#msexcel #excel365 #training

[Excel Solutions Team @ExcelSTHouston]

Still copying the same formula to get sequential numbers?

Try SEQUENCE. It spills a Dynamic Array that grows as your data changes.

Learn more at Excel Solutions Team: https://t.co/BR9aHCrEH5

#Microsoft365 #exceltraining #exceltips

[Excel Solutions Team @ExcelSTHouston]

Can’t tell which cell you clicked in Excel? Enable Focus Cell on the View tab.

It highlights your row and column for clearer navigation and Find results.

Register for training today at: https://t.co/4tZi9VxtxK

#msexcel #msexceltips #Microsoft365 #excel365 #training #webinar

[Excel Solutions Team @ExcelSTHouston]

Tired of merging text with “&” or CONCATENATE? Use TEXTJOIN.

Pick a delimiter, choose TRUE to ignore blanks, select your range. Done.

Learn more with Excel Solutions Team:
https://t.co/jCJlfa0Kf3
#Microsoft365 #exceltraining #exceltips #Excel365 #training #tipsandtricks

[Excel Solutions Team @ExcelSTHouston]

Need to open a dropdown list fast, without Data Validation? Press Alt and the down arrow.

Excel pops the list open so you can pick a value instantly.

Learn more at https://t.co/Lejz0uCHpw.

#msexcel #msexceltips #Microsoft365 #excel365 #training #webinar

[Excel Solutions Team @ExcelSTHouston]

Count text in a PivotTable by dragging the field into the Values area.
Excel switches it to Count and totals any text or dates.
Learn more at https://t.co/Lejz0uCHpw.
#msexcel #msexceltips #Microsoft365 #excel365 #training #webinar

[Excel Solutions Team @ExcelSTHouston]

Wish your lists worked more like checkboxes in Excel?

Add them from the Insert tab. When checked = TRUE, unchecked = FALSE

Once added, use COUNTIFS to track either value.

To learn more, attend training at: https://t.co/5QwVZZ4HmA

#Excel #Microsoft365 #ExcelTips

[Excel Solutions Team @ExcelSTHouston]

Still copying formulas to create sequential numbers?

Try SEQUENCE instead. It’s quick, flexible, and spills as your data grows.

Level up your Excel skills with Excel Solutions Team:

https://t.co/5QwVZZ4HmA
#Microsoft365 #exceltraining #exceltips #Excel365

[Excel Solutions Team @ExcelSTHouston]

Stop wasting time typing dates and times. Use these shortcuts instead:
• Current Date: CTRL + ;
• Current Time: CTRL + SHIFT + ;
• Date & Time (Now): Press them back-to-back with a space between.
Ready to level up? https://t.co/5QwVZZ4HmA.
#exceltips #exceltraining

[Excel Solutions Team @ExcelSTHouston]

Spaces wrecking your lookups? Fix it instantly with XLOOKUP Wildcard Match Mode.

It really is that simple. Learn XLOOKUP the right way in our Excel Level 2 class.
https://t.co/5QwVZZ4HmA.
#Microsoft365 #exceltraining #exceltips #Excel365 #Webinars #training

[Excel Solutions Team @ExcelSTHouston]

In Excel 365, you can scroll horizontally by holding CTRL+Shift, and then use the scroll wheel on the mouse. You can go right or left by scrolling up or down.

Learn more about Excel today at https://t.co/4tZi9Vy1ni.

#msexcel, #Microsoft365, #tipsandtricks, #onlinetraining

[Excel Solutions Team @ExcelSTHouston]

Tired of repeatedly press the backspace key to delete text?

Instead, try pressing CTRL+Backspace to delete the entire word before the cursor.

Learn more about Microsoft Word when you attend training. Register today at https://t.co/4tZi9VxtxK.

#Microsoft365, #webinars, #Tips

[Excel Solutions Team @ExcelSTHouston]

Create bullets quickly in Word or Outlook by typing an asterisk (*), and then a space. Bullets are turned on, and you can continue typing.

Learn more about Microsoft Word when you register for training at https://t.co/4tZi9VxtxK.

#Microsoft, #Microsoft365, #training, #webinars

[Excel Solutions Team @ExcelSTHouston]

When working in Excel, wouldn't it be great to ask your data questions?

With the Analyze Data Pane, you can simply ask Excel what you want to know, as well as how to present the data. Easy!

Learn more at https://t.co/4tZi9VxtxK
#msexcel, #microsoft365, #exceltips, #training

[Excel Solutions Team @ExcelSTHouston]

In Excel 365, there is a new dialog box for chart formatting from the right+click menu.

Want to change the color of columns, or the chart area? You can just right+click on the column or chart!

Learn more at https://t.co/4tZi9VxtxK

#Microsoft, #Excel, #Office365, #Training

[Excel Solutions Team @ExcelSTHouston]

@msexcel Question for you. We have been looking forward to the new data types by Wolfram for months, and it is still not available on our business 365 subscription, yet it shows available for home/personal 365 on the website.

When will this be available for business 365 Excel?

[Excel Solutions Team @ExcelSTHouston]

@resplendentmoi @InfosecMiles Wow. That was some time ago!

[Excel Solutions Team @ExcelSTHouston]

@resplendentmoi @InfosecMiles Excel has only continued to get better and add more features. If you are using Office 365 and NOT using XLOOKUP, you're just wrong. It's the superior lookup function. Let me know if either of you have any questions about Excel 365 new functions.

Thanks!

[Excel Solutions Team @ExcelSTHouston]

@DMaslyuk Did I miss an update? Where is the feature summary page like Microsoft normally releases? Thanks!

[Excel Solutions Team @ExcelSTHouston]

@msexcel The ability to switch between the PowerQuery window and Excel just like we can with the VBA window.