Tech & IT
Business
Coding & Developer
Finance & Accounting
Academics
Office Applications
Art & Design
Marketing
Health & Wellness
Sounds & Music
Lifestyle
Photography
This plan includes
- Limitedfree coursesaccess
- Play & PauseCourse Videos
- VideoRecorded Lectures
- Learn onMobile/PC/Tablet
- Quizzes andReal Projects
- Lifetime CourseCertificate
- Email & ChatSupport
This plan includes
- Access to11,000+Courses
- Adsfree experienceCourses
- Play & PauseCourse Videos
HD VideoRecorded Lectures- Learn onMobile/PC/Tablet
- Quizzes andReal Projects
- Lifetime CourseCertificate
- InstructorDirect Support
- Email & ChatSupport
- Cancel Anytime
What you'll learn?
- Gain a deep understanding of Excel's capabilities for calculations and data manipulation
- Master a wide range of Excel functions, including mathematical, logical, text, date and time, lookup and reference, statistical, financial, database, array, engineering, information, math and trigonometry functions
- Learn advanced Excel techniques, such as creating custom functions with VBA, generating dynamic ranges, and optimizing formulas for performance.
- Apply your newfound knowledge and skills to real-world scenarios, enabling you to become proficient in Excel and your professional endeavors.
Course Overview
Unlock the full potential of Excel with our comprehensive Beginner to Advanced Excel Formulas and Functions course! Whether you're just starting out or looking to deepen your expertise, this course is designed to guide you through every step of Excel mastery. Starting with the basics, we'll build a strong foundation in essential formulas, moving steadily into powerful, advanced functions like VLOOKUP, INDEX-MATCH, and nested IFs. As we progress, you'll learn to harness dynamic array formulas, pivot tables, and data visualization tools to organize, analyze, and present your data with precision. By the end, you'll be able to automate tasks, create insightful dashboards, and tackle complex data challenges with confidence. Perfect for professionals, students, or anyone looking to elevate their Excel skills, this course will turn you into a true Excel power user!
Pre-requisites
- Access to a computer with Microsoft Excel installed (preferably Excel 2016 or later)
- Basic familiarity with Excel navigation, such as entering data, selecting cells, and navigating worksheets
- A willingness to learn and practice regularly, as Excel proficiency comes with hands-on experience and experimentation
Target Audience
- Beginners who want to learn the fundamentals of Excel Formulas and Functions
- Intermediate users seeking to enhance their proficiency and efficiency in Excel
- Professionals who rely on excel for data analysis, reporting, and decision-making.
Curriculum 20 Lectures 02:06:58
Section 1 : Introduction to Advanced Excel Formulas and Functions Mastery
Section 2 : Module One: Introduction to Excel Formulas and Functions
- Lecture 1 :
- Excel Formulas and Functions
Section 3 : Module Two: Basic Mathematical Functions
- Lecture 1 :
- Basic Mathematical Functions.
Section 4 : Module Three: Logical Functions
- Lecture 1 :
- Logical Functions
Section 5 : Module Four: Text Functions
- Lecture 1 :
- Text Functions
Section 6 : Module Five: Date and Time Functions
- Lecture 1 :
- Date and Time Functions
Section 7 : Module Six: Lookup and Reference Functions
- Lecture 1 :
- Lookup and Reference Functions
Section 8 : Module Seven: Statistical Functions
- Lecture 1 :
- Statistical Functions
Section 9 : Module Eight: Financial Functions
- Lecture 1 :
- Financial Functions.
Section 10 : Module Nine: Database Functions
- Lecture 1 :
- Database Functions
Section 11 : Module Ten: Array Formulas
- Lecture 1 :
- Understanding Array Formulas
Section 12 : Module Eleven: Engineering Functions
- Lecture 1 :
- Introduction to Engineering Functions
Section 13 : Module Twelve: Information Functions
- Lecture 1 :
- Introduction to Information Functions
Section 14 : Module Thirteen: Math and Trigonometry Functions
- Lecture 1 :
- Introduction to Math Functions.
- Lecture 2 :
- Trigonometry Functions
Section 15 : Module Fourteen: Error Handling
- Lecture 1 :
- Understanding Excel Error Types
Section 16 : Module Fifteen: Advanced Excel Techniques
- Lecture 1 :
- Custom Functions with VBA
- Lecture 2 :
- Tips and Tricks for Excel Optimization
Our learners work at
Frequently Asked Questions
How do i access the course after purchase?
It's simple. When you sign up, you'll immediately have unlimited viewing of thousands of expert courses, paths to guide your learning, tools to measure your skills and hands-on resources like exercise files. There’s no limit on what you can learn and you can cancel at any time.Are these video based online self-learning courses?
Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic.Can i play & pause the course as per my convenience?
Yes absolutely & thats one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos mulitple times & so on.How do i contact the instructor for any doubts or questions?
Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want.Do i need a pc to access the course or can i do it on mobile & tablet as well?
Brilliant question? Isn't it? You can access the courses on any device like PC, Mobile, Tablet & even on a smart tv. For mobile & a tablet you can download the Learnfly android or an iOS app. If mobile app is not available in your country, you can access the course directly by visting our website, its fully mobile friendly.Do i get any certificate for the courses?
Yes. Once you complete any course on our platform along with provided assessments by the instructor, you will be eligble to get certificate of course completion.For how long can i access my course on the platform?
You require an active subscription to access courses on our platform. If your subscription is active, you can access any course on our platform with no restrictions.Is there any free trial?
Currently, we do not offer any free trial.Can i cancel anytime?
Yes, you can cancel your subscription at any time. Your subscription will auto-renew until you cancel, but why would you want to?
Instructor
16 Course Views
1 Courses
With over a decade of experience in Computer Science, Artificial Intelligence, and Information & Communication Technology (ICT), I am dedicated to empowering others to harness the potential of technology for real-world applications. Holding a master’s degree in Computer Science and specialized certifications in AI and data science, I have worked extensively in both academia and industry, focusing on machine learning, data analytics, and advanced Excel for business solutions. My passion for teaching has led me to design and deliver courses that make complex technical concepts accessible and practical, equipping students and professionals with the tools they need to succeed in an increasingly digital world.
