Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
If you want a career change to more analytical role, if you want to be an analyst, this course is the fastest way for you to learn Excel.
Here in this course, I only teach things that you will apply in your work as an analyst. There are thousands of functions in Excel, what analyst use on daily basis is within 20. Among thousands of shortcuts in Excel. What an analyst need is under 30. I am going to save your time and only teach the things that are important, from the start. That's why it's a jump-start.
The analysts I am referring to are financial analysts, budget analysts,and research analysts. Because I've been working in all of these positions from start-up to Fortune 500 companies. I know at this point your job is somewhat about digging in numbers and impress your boss with what you find. I am here to help you to impress your boss, get promoted, get hired, and become one of the best.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Course Overview|
Watch this before you startPreview
DOWNLOAD WORK FILE HEREPreview
Join BestAnalyst.org email list to get exclusive contents, career tips, Excel tips for free! Here is the link: http://eepurl.com/bIENWv. I don't bother you very often, but when I do, I hope you can benefit from it the next day.
1. What do I mean by basic excel or advanced excel, where are you at?
2. How and What you will learn?
Navigate through the layout of Excel. Skip this if you have worked with Excel before
|Section 2: Excel formula hack|
See how Excel calculates
Relative and Absolute Reference
Even if you've been using excel for a while you may not have known that.
Basic Excel Formulas
When to use which function and how to learn
|Section 3: Excel Functions Hack|
Best practice from experience
Group & Freeze Panes - From Basic to Fancy way to use itPreview
Format as Table Basic and Why Use itPreview
Filter in table and in range, Pros&Cons
INCLUDE ONE BONUS
Format Painter- the Right WayPreview
Comment- Best PracticePreview
Creative way to entry data
Check in with you
|Section 4: 8 Formulas Analysts must MASTER|
Analyst most favorite: IF formula
SUMIF(s) This is more important than you think
How to add labels based on conditions: LOOKUP
Upgrade from LOOKUP: VLOOKUP
How to make a Dynamic Table in 2 min
HLOOKUP to the rescue
Upgrade from VLOOKUP: INDEX&MATCH
How to stop making mistakes in ExcelPreview
|Section 5: Mysterious Pivot Table|
Pivot Table mystery revealed
Subtotal in Pivot Table
Calculated Column Part 1
Calculated Column Part 2
Slicer and Timeline
Dashboard Design Principals
Dashboard using Pivot Table
|Section 6: BONUS: Data Analysis Series|
How to interpret sensitivity analysis
Sensitivity Analysis Table
Jason has worked as a financial analyst, business analyst, and research analyst from start-up to fortune 500 companies. He holds a Master Degree in Finance from the Johns Hopkins University. He passed CFA level 3 exam.
Jason dedicates his time to help analysts get promoted, get better job and better life, starting from having outstanding Excel skills.
Excel is a powerful tool. It's like golf. You can learn it within several hours, but improve it for the rest of your life. There are tons of free materials out there. But you need structured lectures to build a good mindset in order to reach your goal, which is getting the job done beautifully. So that you can ask for raise, for promotion, even your dream job.