As an Excel user you’ve probably heard a lot about VLOOKUP and other lookup functions. But what can lookup functions do, why should you use them, and how can they help you?
In essence, lookup functions search through data and return specific values. You may be asking yourself, “Well, why can’t I just do a manual search through my data with ctrl-f and find what I need that way?” And sure, that’s fine if you only need to look up one or two things. But what if you have ten, a hundred, or even thousands of things you have to search for and search through?
That’s where lookup functions come in, they are all about making Excel do the work for you. They can help you to quickly and efficiently retrieve data which saves you time and effort.
This course is a comprehensive deep dive into Excel’s lookup functions including (but certainly not limited to) the ever-popular VLOOKUP, my personal favorite, INDEX-MATCH, and the new function, XLOOKUP. It will give you a solid foundation of lookup function knowledge, but also challenge you to learn about and create nested and two-dimensional lookup functions that can really take your Excel capabilities to the next level.
**********************************************
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
A-H Del Mar, CA - December 05, 2020 Cover Picture for m4b.jpg
113.4 KB
A-H Del Mar, CA - December 05, 2020 Cover Picture.jpg
184.3 KB
A-H Del Mar, CA - December 05, 2020 Full Workshop.m4b
133.8 MB
A-H Del Mar, CA - December 05, 2020 MP3s/01 - Esther Opens the broadcast (0.32).mp3
691.7 KB
A-H Del Mar, CA - December 05, 2020 MP3s/02 - Abraham talks about our power of influence on other people (4.06).mp3
4.1 MB
A-H Del Mar, CA - December 05, 2020 MP3s/03 - I started to own my feelings and my life changed for the better (12.31).mp3
11.9 MB
A-H Del Mar, CA - December 05, 2020 MP3s/04 - I can finally let go and allow, am I on the right-track (12.58).mp3
12.3 MB
A-H Del Mar, CA - December 05, 2020 MP3s/05 - Can you please provide a kinder, more gentle way of describing rejection (31.57).mp3
29.8 MB
A-H Del Mar, CA - December 05, 2020 MP3s/06 - I feel overwhelmed when I am on the path to creating my own reality (4.07).mp3
4.1 MB
A-H Del Mar, CA - December 05, 2020 MP3s/07 - I liked myself, and my life more while on medication (1.33).mp3
1.6 MB
A-H Del Mar, CA - December 05, 2020 MP3s/08 - How do I close the gap between what I want and what I believe I can have (3.01).mp3
3 MB
A-H Del Mar, CA - December 05, 2020 MP3s/09 - I communicate from a place of lack, how can I be more clear and aligned (2.46).mp3
2.7 MB
A-H Del Mar, CA - December 05, 2020 MP3s/10 - Why are so many people not coming to me to learn these guitar skills (3.38).mp3
3.6 MB
A-H Del Mar, CA - December 05, 2020 MP3s/11 - What is the best response to negativity focused at us (1.33).mp3
1.6 MB
A-H Del Mar, CA - December 05, 2020 MP3s/12 - Does Abraham collaborate with other entities to help us (0.24).mp3
580.5 KB
A-H Del Mar, CA - December 05, 2020 MP3s/13 - Maximum time spent on each emotions of the Emotional Guidance Scale (3.13).mp3
3.2 MB
A-H Del Mar, CA - December 05, 2020 MP3s/14 - I want a miracle to end this pain (8.54).mp3
8.4 MB
A-H Del Mar, CA - December 05, 2020 MP3s/15 - I am trying to redefine my whole life (4.32).mp3
4.4 MB
A-H Del Mar, CA - December 05, 2020 MP3s/16 - How can I feel comfortable spending money on myself (2.20).mp3
2.3 MB
A-H Del Mar, CA - December 05, 2020 MP3s/17 - About past trauma and feeling physical fatigue now (3.14).mp3
3.2 MB
A-H Del Mar, CA - December 05, 2020 MP3s/18 - How can I lighten-up in my life (2.53).mp3
2.9 MB
A-H Del Mar, CA - December 05, 2020 MP3s/19 - Appreciation for vision boards and magical creation boxes (1.08).mp3
1.2 MB
A-H Del Mar, CA - December 05, 2020 MP3s/20 - What's the difference between fighting against and working for (5.55).mp3
5.6 MB
A-H Del Mar, CA - December 05, 2020 MP3s/21 - I am still having anxious dreams (2.45).mp3
2.7 MB
A-H Del Mar, CA - December 05, 2020 MP3s/22 - While meditating her neighbour reemerge back into non-physical (0.35).mp3
747.8 KB
A-H Del Mar, CA - December 05, 2020 MP3s/23 - My mother is declining but I don't understand why she is hanging on (2.15).mp3
2.3 MB
A-H Del Mar, CA - December 05, 2020 MP3s/24 - My nursing-home living grandmother wants out of the facility very badly (6.54).mp3
6.5 MB
A-H Del Mar, CA - December 05, 2020 MP3s/25 - Rampage of appreciation for Abraham (1.55).mp3
2 MB
A-H Del Mar, CA - December 05, 2020 MP3s/26 - Abraham closes the broadcast (1.09).mp3
1.2 MB
A-H Del Mar, CA - December 05, 2020 Track Titles.jpg
313.5 KB
A-H Del Mar, CA - December 05, 2020 Track Titles.txt
1.9 KB
A-H Del Mar, CA - December 05, 2020 Video COMPACT part 1.mp4
152.1 MB
A-H Del Mar, CA - December 05, 2020 Video COMPACT part 2.mp4
162.2 MB
A-H Del Mar, CA - December 05, 2020 Video part 1.mp4
431.3 MB
A-H Del Mar, CA - December 05, 2020 Video part 2.mp4
461 MB
A-H Del Mar, CA - December 05, 2020 Video Time Stamp.jpg
269.8 KB
Abraham-Hicks 2020-12-05 Del Mar, CA - Video and CD.txt