Description
Curriculum
Instructor
Do you struggle with Excel formulas? Do calculations take a long time, and you know there must be a better way to accomplish things in Excel, but you don’t know where to turn? Then this course is for you. This course will show you the most popular functions and formulas in Excel and how to use them very efficiently.
On Completion of this course, you’ll be a pro in the following concepts & processes:
- Building basic math formulas
- Autosum and Relative references
- Absolute references
- Named Ranges
- Linking sheets and workbooks
- Vlookup and Hlookup functions
- Match and Index functions
- Date and time formulas and functions
- Tracing formulas
Some exceptional benefits associated with this course enrolment are:
- Quality course material on MS Excel formulas and functions
- Lifetime access to the course
- Instant & free course updates
- Access to all Questions & Answers initiated by other students as well
- Personalized support from the instructor’s end on any issue related to the course
- Few free lectures for a quick overview
It’s time for you to grab the opportunity and make the most out of this course.
Enroll today!!
Curriculum
- 1 Section
- 13 Lessons
- 2 Hours
Expand all sectionsCollapse all sections
- Excel - Formulas and Functions13
- 2.1Basic Maths2 Minutes
- 2.2Excel Must-Know Formulas and Functions – 1 – Building basic math formulas8 Minutes
- 2.3Excel Must-Know Formulas and Functions – 2 – Autosum and Relative references9 Minutes
- 2.4Excel Must-Know Formulas and Functions – 3 – Absolute references6 Minutes
- 2.5Excel Must-Know Formulas and Functions – 4 – Named Ranges6 Minutes
- 2.6Excel Must-Know Formulas and Functions – 5 – Linking sheets and workbooks6 Minutes
- 2.7Excel Must-Know Formulas and Functions – 6 – If, And, Or, and the nested If functions16 Minutes
- 2.8Excel Must-Know Formulas and Functions – 7 – Countif, Sumif, Averageif, Sumifs, and Countifs functions9 Minutes
- 2.9Excel Must-Know Formulas and Functions – 8 – Vlookup and Hlookup functions15 Minutes
- 2.10Excel Must-Know Formulas and Functions – 9 – Match and Index functions7 Minutes
- 2.11Excel Must-Know Formulas and Functions – 10 – Date and time formulas and functions13 Minutes
- 2.12Excel Must-Know Formulas and Functions – 11 – Text functions11 Minutes
- 2.13Excel Must-Know Formulas and Functions – 12 – Tracing formulas8 Minutes
Tom Fragale
0 Students14 Courses
I am a Microsoft Certified Trainer with over 35 years of professional IT experience, and my passion is teaching people how to get the most out of their computer.
₹299.00
₹269.00
100% positive reviews
0 student
13 lessons
Language: English
0 quiz
Assessments: Yes
Available on the app
Unlimited access forever
Skill level All levels
Courses you might be interested in
The ability to study each potential buyer and respond immediately and appropriately to their verbal and physical cues. In this course, you” go through the history of psychology in...
-
15 Lessons
₹449.00
Discover The Hidden Secrets Of Beating Anxiety! On Completion of this course, you’ll be able to: Discover How To Banish Worry & Live An Anxiety Free Life! Learn How...
-
10 Lessons
₹599.00
Secrets They NEVER Taught You In School Or Life! On Completion of this course, you’ll be: Talking In A Way That Your Children Will Listen & Change! Knowing The...
-
13 Lessons
₹599.00
Using the Power of Social Media to Attract a Crowd of Loyal Customers. On Completion of this course, you’ll be: In no longer need to “run an ad” and...
-
39 Lessons
₹449.00