Learn Excel from Scratch and become more CONFIDENT.
Looking to learn Excel but don't know where to start?
OR, you've been using Excel for a while but don't feel 100% confident?
I have picked out the Excel Essential skills a Data Analyst needs and packaged them in a structured course.
In fact, I collected the most common Excel problems faced by my clients. I added in my 10+ years' experience in finance and project management. I included all the hidden tips and tricks I came to learn as an Excel course. I also made sure it covers the absolute Excel beginners.
These practical, real-world examples help you understand the full potential of each feature. You'll learn how to use Excel for quick and painless data analysis.
There are many helpful and time-saving Excel formulas and features. We tend to forget what these are if we don't use them. This Excel Essentials Course will give you the practice you need to be able to apply the best solution for the task at hand. This way you can do more in less time.
Topics covered:
1 Basic Structure
2 cell properties, autofill and cell reference type
3 equation in excel
4 text function1
5 Text function2
6 If Function
7 AND OR logical function
8 math and logical function
9 FILTER
10 conditional formatting
11 define name
12 hyperlink in excel
13 Goal Seek
14 scenario manager
15 PMT and Data table
16 text to column
17 pivot Table
18 Pivot table Advance
19 Chart preperation
20 data validation
21 Vlookup and hlookup Function
22 Match and index offset
23 vlookup true
24 Lookup and Reference Tricks
25 lookup function
*** You are having the option to download the video in app and can be watched offline as well.
*** This is not a Microsoft Application. This is just an Excel Course
9Apps 4.9
