Mentoring Dynamic Excel Development w/ Power Query
Mentoring Dynamic Excel Development w/ Power Query is one of the specialized services our company offers.
Here we take an intermediate or advanced Excel programmer, and we take them to the expert level. What you learn here will put you above others who program Microsoft Excel.
With our one-on-one mentoring you learn exactly what you need to know, exactly how to do it, most importantly, why.
The Focus of Mentoring; What to Learn
Canned Excel training comes with an agenda, based on what the trainer wants to teach, not necessarily based on what you need to learn. Think about it.
At Excel and Access, LLC all of our Excel training agendas are 100% custom to the client. That is unique; it also reduces the amount of training needed.
Mentoring is different than training. Mentoring is usually one-on-one. Mentoring is highly personal.
Learn Less: Most of the things you learn in traditional Excel training, you do not need to know, nor should you use. Most Excel trainers teach the old Excel, not the latest and greatest in 365.
( How many teach Tables, Power Query and the Data Model ).
Thought: You only need to learn what you will use.
- Tables, Power Query, DAFs, and Macros, that is pretty much it, for most business users.
Training is showing how something is supposed to work, in theory. Mentoring is demonstrating how things work in real-life scenarios, there is a significant difference in what you learn.
And yes, we do provide one-on-one Excel training.
Learning Advanced Excel Programming is Easy if you have a Mentor
Do you want to improve how you program Microsoft Excel? Do you want to work one-on-one, an hour or so here, an hour or so there, working towards improving your Excel programming skills? Do you want to learn the new, Dynamic Excel, the one based on Office 365, Power Query, Dynamic Array Functions, Pivots, and VBA?
If so, if you want to learn how to properly program custom Microsoft Excel solutions for your business, this might be for you. The easiest way to find out, try us for two hours and see how much you learn.
Note: This is not training, here, you do the heavy lifting, offline, in self-determined after-sessions. Here we show you what you need to know, and more importantly, why you need to learn to do it this way. We explain it and demo it fully, ask all the questions you have, and try it on the call if you want. Then offline, dig in further. Build a model, learn it, know it, own it.
In our one-on-one, remote mentoring sessions, we take you by hand ( remotely ), and we take you where you need to go, into Dynamic Excel Development; and Optimized Excel Solutions.
=XLOOKUP (InputCell, LookupRange, ResultRange) #
Mentoring Dynamic Excel Developers – This is where the Real Learning Happens
Contact us for a Free Consultation Today to Discuss our Mentoring Services.
Contact us for a Free Consultation Today. Operators are standing by to take your call. Get a Smarter Solution.
Toll-Free: 877.392.3539 | Irvine, California: 949.612.3366 | Manhattan, New York: 646.205.3261
Learn how to Program Microsoft Excel the Right Way, with an Excel Mentor:
A mentor can teach you exactly what you need, and nothing more, in very short time. The advantage is that we know what works best, and we know what you do not need to know, hence, you only learn the most powerful, most useful ways to program Microsoft Excel.
Result: Save Time, Save Money, learn in a matter of hours all that you need to learn.
Question: There are multiple ways to do most things in Excel, which are newer, which are easier, and which are right for your Excel file? Let us help you to decide.
Examples: Vlookup, Index/XMatch, XLookup or Filter/Filter, etc. Concatenate, Concat, or TextJoin. Which should you use?
Answer: Depends, do you want to base your work on the new Dynamic Excel, ( post-2018 Calculation Engine Update ), or older Excel ( EBDAF = Excel Before Dynamic Array Functions )? Big difference ( Tesla versus 1963 Bug ).
Excel After DAFs = Dynamic Excel
Problem/Challenge: Once you learn a function to achieve what you want in Excel, you often stop looking, you stop learning, and you may possibly miss a better tool for the task. New tolls are coming out all the time now. What you don’t know can cost you time.
Our Goal: To teach you what works best for what you need to have done. What tools to use. What is the “Optimal Solution“. That you yourself can build.
Note: We tell you how to build it, we show you how to use the tools, then you build it, yes, you, not us, do the Excel programming.
This is not Excel training;
Hire our Team of Excel Mentors
If you need to hire an Excel Mentor to assist you with your Excel programming, please give us a call today.
Toll-Free: 877.392.3539 | Irvine, California: 949.612.3366 | Manhattan, New York: 646.205.3261
Contact us for a Free Consultation Today. Our Top Excel Consultants are Excel Mentors
What is Excel 365 Mentoring?
Excel Mentoring it is the Best Way to Learn to Program Microsoft Excel
Excel mentoring is partially like Excel training, but it is not exactly Excel training, mentoring beyond that. In mentoring we dig in deep to a few advanced topics and concepts, the ones you should be using when you program your excel files. We ignore the rest.
You as the student are expected to take the time to learn. This is not passive Excel training; this is one-on-one Excel mentoring. This is the time for you to be an Excel Sponge.
When it comes to mentoring or training, the knowledge of the person doing the training is the most important ingredient. Why not hire an Excel MVP from 1993? Bob is the Microsoft Excel subject matter expert.
What is Dynamic Excel?
A. Dynamic Excel is available in Excel 365. It is up to you if you take advantage of it or not, it is there, regardless. How hard do you want to work?
B. Dynamic Excel 365 is range-based programming; not cell-based programming. Results “Spill” into the appropriate cells. Your formulas go in the first cell, row, or column, that is it. And that changes everything.
This is why you have to think and program differently in dynamic Excel 365.
C. Programming Dynamic Excel is different, too much to explain here, but there is Excel before dynamic array functions, or after. To make a long story short, if you use Excel 365, and if you leverage the latest, dynamic features and programming methods, you are using the new Excel. Excel post 2018.
See our post on the Changes to Dynamic Excel.
What Does Mentoring Dynamic Excel Development Entail
Simple, it required you to dig in with us, to learn, dig in deep.
It is usually a remote, one-on-one session, via Zoom, where we speak with you, to determine what you already know, what you need to do at work, and thus, which of these tools will work best for your Excel programming needs.
We then discuss the concept, we display it, and you are able to practice, as desired. Ask away. You’re here to learn. Dig in.
This is your time, we make sure you learn Excel programming methods
How Does Remote one-on-one Excel 365 Mentoring Work
It is by the hour, usually in 2-3 hour blocks, based on your needs. We cover concepts, show demos, and answer all of your questions. Most students take between 5-10 hours to get to the advanced level.
Our one-one-one Excel mentoring Servies include:
- Excel Tables w/ Slicers
- Excel Power Query, w/ Slicers
- Excel Pivot Tables, Pivot Charts, and Slicers.
- Excel Dynamic Array Functions.
- Using the #.
- Plus, all of the traditional stuff like:
- Conditional Formatting.
- Legacy Functions.
- SumIfs, Match, VLookup
- Drop-Down Validation Controls.
- Automation is the key.
- Dynamic Excel 365 is the Solution.
Who provides the Mentoring?
- In New York, Bob.
- Else, Christopher or one of the MVP Associates.
- We have a team of expert Microsoft Excel consultants. The best-of-the-best are our Team of Microsoft Excel MVPs. Excel MVPs are certified by Microsoft; they are the Microsoft Excel Subject Matter Experts. We have the best talent, we can teach you all that you need to know.
Ask Bob a question about Excel, and you will get an answer, most likely the best possible answer. Bob’s license plate pretty much says it.
When it comes to Microsoft Excel, and being an Excel MVP, Bob is the Excel MVP of the ages, going back to the first class of 93.
Examples of our Excel Mentoring Projects
Our most common mentoring students would be persons that are already programming Excel at the intermediate level, or higher. They know the VLookup, they know Pivot Tables, and they are usually pretty good. Our one-on-one mentoring takes them up a few notches.
It is time to relearn how to program Microsoft Excel.
Given the recent changes in Excel, Excel consultants are having to relearn how they program Excel. There is lots to learn. The quickest way to learn how to apply it, in real world scenarios, is to work with a mentor.
But with that said, we will mentor anyone, no matter their current skills set. We have a lot of beginners reach out for our mentoring services, Beginner Training. It is the quickest way to learn Microsoft Excel programming.
1. Stock Investor – Advanced Excel programmer
A stock trader reached out to get help with the Excel model he developed. It was one of the most advanced models I have seen. He had talent, serious talent. But there were a few things about Macros and advanced dynamic array functions that he did not understand. So he had thee 1-hour sessions with Bob, and Bob took him to the next level – expert.
You only need to find one Excel expert to work with, so why not work with the absolute best, why not work with the team at Excel and Access, LLC. Our Excel MVPs will take you to the next level.
2. Construction Firm – They want to build an easy to use and automated solution.
But they do not know how to do it.
We worked with two of their estimators that are also intermediate Excel programmers. They have very solid skills, arounds the things they knew how to do, pre-2018. They want to build a new, automated, easy to use estimating application inhouse, and they did not feel they knew all that they needed to, in order to build the solution.
So they sought an Excel mentor to teach them what they needed to learn, nothing more, to accomplish building their solution.
This solution would replace their current solution, and they wanted to make sure that they built their new model, on current design methods and best practices. So far they have learned Power Query, Excel Tables, Dynamic Array functions, and we are not done yet.
Excel Mentor’s Advice: If you only learn one thing, start all of your projects with Excel Tables.
3. An MBA Student from Harvard
This was a challenging one. This was on a Mac, running Excel 2016, and his Excel skills were at the low-intermediate level, at best. So we had to earn our salt on this one. 2016 and the Mac greatly complicate Excel development.
He needed to learn how to analyze large amounts of data, of messy data. We used Excel Tables, Power query, and the DAFs. He was a quick study, super smart. Learned this stuff faster than I did. Harvard and all.
It does not matter who you are, where you work, or what your data is about. It only matters that you know how to use the best tools for the task. In our one-on-one Excel mentoring, we teach you exactly that, what YOU NEED TO LEARN. Nothing more.
Mentoring Dynamic Excel Development – you learn just what you need to learn.
What to Learn, What to Learn, our Excel Mentors will show you
There are multiple ways to do most things in Excel, same basic end results. Which to use, in your Excel files.
- Automated, Manual, Hybrid
- Lookups: XLookup, VLookup, HLookup, Lookup, Index/Match,FILTER, XMatch, etc.
- Tables, Ranges, Power Query
- Data Model
- Dynamic Array Functions or traditional programming methods
- # or no #
- VBA, no VBA.
- Validation Controls, Combo Boxes, ListBoxes, UserForms
- The list goes on and on
Why, why, why, how, how, how, now go do it; This is where the learning begins.
Want to learn more, want to be an Excel Expert?
If so, try our Excel mentoring services.
Try an hour or two of our mentoring services. You should know within the first 25-minutes if this is for you, if you are willing to take the time to learn, to apply, to ask, to advance. We can only guide you, you must do the rest. If it is for you, let’s try 10-hours, on your schedule, and let’s see how far you get.
If you prefer standard training, one-on-one training, or to hire us for our programming services, we can assist you with that instead. We are a full-service operation.
Affordability of our Mentoring Dynamic Excel 365 Services
You will be surprised at the rate, just how little this cost. You are paying us to talk, to teach, to demonstrate, not to spend hours programming. We get you. We will take you to where you want to be, but you need to allow us to lead.
Using Dynamic Excel 365 is the Requirement for our Mentoring Dynamic Excel Development services.
You must be using Excel 365 to tap into our Mentoring services. Excel 2016 is too old, missing too many pieces, time to upgrade. You do want to use the new Calculation Engine in 2018+
Learning Advanced Excel Programming is Easy if you have a Mentor, allow us to Guide You.
Mentoring Dynamic Excel Development is not a service many firms offer.
Why? Do you know how good an Excel consultant needs to be in order to provide mentoring services? You need to be an expert to take those that are intermediate or advanced, and to make them an Excel expert. Our team of Excel experts is Microsoft Certified. We have the goods, we have the talent, we have the affordable pricing. We can help you today. Please, give us a call.
This has been a fantastic solution to help me learn while building my spreadsheet in a timely fashion. I feel equipped to do programming and further development on my own based on Christopher’s mentorship.
Brea, it has been such a joy mentoring you. You learn so fast.