Get Microsoft Help: Get a Smarter Solution. The Microsoft Excel, Power Query, Access, SQL Experts. Help for Business, Government, Education & Non-Profits.
Joined June 2009
- Tweets 1,725
- Following 52
- Followers 2,117
- Likes 78
40 Photos and videos
10 May 2024
Automated Excel Solutions for Business
~ Dynamic Excel Development; Optimized Excel Solutions for Business ~
excelandaccess.com/blog/auto…
1
183
2 May 2024
Dynamic Excel 365 Development: Step-by-Step
Excel 365 is dynamic, and here we teach you how to develop dynamic solutions in Excel 365.
excelandaccess.com/blog/exce…
1
208
12 Apr 2024
The Microsoft Excel VLookup is the most searched, and most used Excel function of all time. This function is the backbone of many Excel workbooks.
excelandaccess.com/blog/prog…
168
7 Apr 2024
How to Program Excel’s Dynamic Array Functions
– You can make almost any function a dynamic function, a function that Spills –
excelandaccess.com/blog/prog…
1
194
22 Mar 2024
For Range-Based Excel Programming use the #.
Our top Excel consultants leverage the power of the # in Excel functions. We will teach you what this is all about, why you should know it, and best of all, how to use it.
excelandaccess.com/blog/ment…
1
142
6 Mar 2024
One of the most used and respected tools used by leading Excel experts is Power Query.
excelandaccess.com/blog/exce…
123
13 Feb 2024
Excel TablesExcel Table Lists
Power QueryParameters
Data ModelPivot Tables
Pivot Charts
PowerPivot
Slicers
Dashboards
Dynamic Array FunctionsDAF Reports
VBA With Dynamic Excel you can use less VBA code.
excelandaccess.com/blog/dyna…
1
134
9 Feb 2024
Excel Tables versus Access Database, Excel as an alternative to a database.
Recent Microsoft Excel Tables Project, Where we used Excel Tables instead of an Access Database
lnkd.in/g3-Pz7Yh
#excelautomation
1
141
8 Feb 2024
Excel Tables versus Access Database.
This new Dynamic Excel is becoming more Access-like.
Excel is becoming a database replacement tool.
excelandaccess.com/blog/exce…
106
6 Feb 2024
Power Query allows you to use fewer formulas in your Excel files. Furthermore, Power Query also allows you to manipulate data, without the use of Visual Basic for Applications, aka, VBA, ( macros ).
excelandaccess.com/excel/pow…
#excelautomation
111
4 Feb 2024
Join the Dynamic Excel Revolution #excelautomation
Everything in Excel is changing. It is changing fast, so fast, in an entirely new direction. It is a revolution, a dynamic Excel revolution.
excelandaccess.com/blog/dyna…
102
20 Jul 2023
One of the most underutilized advanced features of Microsoft Excel is Named Ranges. Properly using Named Ranges makes programming Microsoft Excel much easier.
excelandaccess.com/blog/name…
1
197
8 Jul 2023
DYNAMIC XLookups & SumIfs
New Method The # Symbol tells the function to grow and shrink with the adjacent dataset.
You point the function to the first cell in the Dynamic Array and add the # symbol.
Your Xlookup, SumIf, etc., are now dynamic.
excelandaccess.com/blog/exce…
2
185
8 Jul 2023
Everyone reading this has most likely heard of Excel Dashboards.
If you are an Excel programmer, you should have heard of the new Dynamic Array Functions.
If you are not using the "=NamedCell#", then you need to read this.…lnkd.in/guqSZGYz lnkd.in/g2gW6dzp
125
7 Jul 2023
Everyone reading this has most likely heard of Excel Dashboards.
If you are an Excel programmer, you should have heard of the new Dynamic Array Functions.
Knowing how to properly leverage these functions will greatly simplify your Excel programming.
excelandaccess.com/blog/exce…
161
1 Jul 2023
Came across this video today. If you are into the new functions and what they can do, this is a must-see.
One of the better videos on how to use these new dynamic array functions.
I love her work. lnkd.in/gXC96rgj
103
28 Jun 2023
Came across this old post:
Running Total in an Excel Table.
We refreshed it for 2023. Take a look.
excelandaccess.com/blog/runn…
135