Tech & IT
Business
Coding & Developer
Finance & Accounting
Academics
Office Applications
Art & Design
Marketing
Health & Wellness
Sounds & Music
Lifestyle
Photography
This plan includes
- Instant access to 11,000+ online courses
- Play & Pause Course Videos
HD Video Recorded Lectures- Learn on Mobile/PC/Tablet
- Quizzes and Real Projects
- Lifetime Course Certificate
- Instructor Chat Support
- Cancel Plan Anytime
This plan includes
- Instant access to 11,000+ online courses
- Play & Pause Course Videos
- HD Video Recorded Lectures
- Learn on Mobile/PC/Tablet
- Quizzes and Real Projects
- Lifetime Course Certificate
- Instructor Chat Support
- Cancel Plan Anytime
What you'll learn?
- Master the Fundamental and Core Excel concepts that Pros know.
- Learn how to use the Most Popular and Powerful Functions you should be aware of.
- Learn to use the Key Features of Pivot Tables to summarize large datasets and extract key insights.
- Save time and money by Automating boring routine tasks using Macros.
- Amaze your Boss by mastering the use of Dynamic Time Saving Functions like VLOOKUP, INDEX MATCH, IF, SUMIFS and more.
- Get my Tips and Best Practices to Fast Track your status to an Advance Excel User.
Course Overview
Master key Excel functions and features that are in demand today. The Microsoft Excel - Rookie to Confident Crash Course is designed to do exactly what it's called, take you from an Excel Rookie to a Confident Excel User fast.
The course will first teach you the fundamental Excel skills you need to learn which will give you the foundation to master Excel. This includes key topics such as:
-
Understanding the Excel Interface
-
Relative and Absolute Cell Referencing
-
Key Excel Terminology You Need to Know
-
The Proper way to Write Functions
Once you have grasped these key topics we will move on to more advance and powerful features. This will include:
-
Using popular and advance dynamic functions like - VLOOKUP, IF, SUMIFS, IFERROR, INDEX MATCH and more to boost your productivity and make your life easier literally x 100.
-
Apply conditional formatting to highlight key data, help viewers to visually interpret your reports and beautify them.
-
Utilize macros to automate repetitive tasks.
-
Use pivot tables to summarize and obtain key insights from large volumes of data.
-
Learn many other key Excel features that are highly sort after.
If you're looking to negotiate a better salary with your Boss or significantly expand your job opportunities this course is great for you. I will use my years of experience as an Excel Solutions Consultant and Corporate Excel Trainer to teach you the key skills and features in Excel you need to know to feel confident.
I not only benefited greatly from this course but I truly enjoyed every minute of it! Kerron did a stellar job in teaching with clarity and simplicity. It's super easy to follow along and he is very motivating! Hands down one of the best instructors I have come across in Microsoft Excel, can't wait for the next course! - David Samaroo
I would 100% recommend this course. Kerron teaches in a clear and easy to follow manner. The course is filled with quizzes and practice exercises and solutions which helps you to be able to apply what you learned in the real world. I am feeling really confident in Excel now! - Kyle Rodrick
Research shows that key Excel skills that you should be aware of which this course covers includes:
-
The Fundamentals of Writing Functions
-
Finding Data with Lookup Functions
-
Using Logical Functions to Perform Actions Based on Conditions
-
Manipulating Text with Text Functions
-
Highlighting Key Data with Conditional Formatting
-
Automating Tasks with Macros
-
Using Pivot Tables
What's Included in the Course:
-
70 plus videos packed with golden nuggets
-
5 Hours of concise and to the point topic coverage
-
Quizzes designed to test your understanding and fill in your gaps
-
Real life practice exercises with solutions so you can take what you learned and apply it today
Still reading? This shows that you believe this course provides the knowledge and skills in Excel you want to learn. Then I recommend you enroll because the course delivers everything you read and more. Looking forward to see you inside.
Best regards,
Kerron Duncan
Founder of Excel Galaxy
Pre-requisites
- Microsoft Excel 2010 or above
Target Audience
- Anyone that wants to learn the key Excel features that are in demand in a reasonably short time frame.
- An individual looking for a job offer that requires fundamental Excel skills.
- Someone looking to negotiate a better pay grade, or expand their opportunities and be in demand by employers.
- Anyone who wants to save time and money by boosting their productivity.
Curriculum 81 Lectures 01:31:20
-
Section 1 : INTRODUCTION
- Lecture 2 :
- Resource - MS Excel Rookie to Confident Slides
- Lecture 3 :
- Resource - Excel Practice Workbooks
- Lecture 4 :
- Resource - Excel Practice Workbooks Completed
- Lecture 5 :
- Resource - Excel Homework Workbooks
-
Section 2 : FUNCTION & FORMULAS FUNDAMENTALS
- Lecture 1 :
- Intro: Functions & Formulas Fundamentals
- Lecture 2 :
- Introduction into the Excel Interface
- Lecture 3 :
- What are Formulas and Functions
- Lecture 4 :
- Writing the Syntax of a Function
- Lecture 5 :
- Key Excel Terms to Remember
- Lecture 6 :
- The 5 Basic Functions You Should Know
- Lecture 7 :
- Relative References - Key Concept
- Lecture 8 :
- Absolute and Mixed Referencing – Key Concept
- Lecture 9 :
- Range Shortcuts for Working with Functions
- Lecture 10 :
- REAL WORLD PRACTICE: Functions & Formulas Fundamentals
- Lecture 11 :
- QUIZ: Functions & Formulas Fundamentals
-
Section 3 : SECTION 3: LOOKUP FUNCTIONS
- Lecture 1 :
- Intro - Lookup Functions
- Lecture 2 :
- Finding Data to the Right with VLOOKUP
- Lecture 3 :
- Finding Data Downwards with HLOOKUP
- Lecture 4 :
- Limitations of VLOOKUP and HLOOKUP
- Lecture 5 :
- INDEX MATCH Explained
- Lecture 6 :
- Finding Data with INDEX MATCH in Any Direction
- Lecture 7 :
- REAL WORLD PRACTICE: Lookup Functions
- Lecture 8 :
- QUIZ: Lookup Functions
-
Section 4 : SECTION 4: LOGICAL FUNCTIONS
- Lecture 1 :
- Intro: Logical Functions
- Lecture 2 :
- Introduction Into using IF
- Lecture 3 :
- Comparative Operators to Remember
- Lecture 4 :
- Performing Actions with IF Based on a Condition
- Lecture 5 :
- Nesting IFs to Test More Than One Condition
- Lecture 6 :
- Introduction into using AND & OR
- Lecture 7 :
- Nesting IF with AND or OR
- Lecture 8 :
- Handling Errors with IFERROR
- Lecture 9 :
- Summing Specific Values with SUMIFS
- Lecture 10 :
- Counting Specific Values with COUNTIFS
- Lecture 11 :
- QUIZ: Logical Functions
- Lecture 12 :
- REAL WORLD PRACTICE: Logical Functions
-
Section 5 : SECTION 5: TEXT FUNCTIONS
- Lecture 1 :
- Intro: Text Functions
- Lecture 2 :
- Extracting Parts of Text with RIGH, LEFT & MID
- Lecture 3 :
- Fixing Text Case with UPPER, LOWER & PROPER
- Lecture 4 :
- Removing Unwanted Spaces in Text Strings with TRIM
- Lecture 5 :
- Joining Text with CONCATENATE
- Lecture 6 :
- Advance Text Functions Intro - LEN, SEARCH & FIND
- Lecture 7 :
- LEN, SEARCH & FIND for Advance Text Manipulation
- Lecture 8 :
- QUIZ: Text Functions
- Lecture 9 :
- REAL WORLD PRACTICE: Text Functions
-
Section 6 : SECTION 6: CONDITIONAL FORMATTING
- Lecture 1 :
- Intro: Conditional Formatting
- Lecture 2 :
- Introduction into Conditional Formatting
- Lecture 3 :
- Using Highlight Cell Rules to Highlight Key Data
- Lecture 4 :
- Highlight Cell Rules - Highlight Cells with Specific Text
- Lecture 5 :
- Using Top Bottom Rules to Highlight Key Data
- Lecture 6 :
- Top/Bottom Rules - Highlighting Values Above Average
- Lecture 7 :
- Data Bars, Color Scales & Icon Sets for Visualizing Data
- Lecture 8 :
- Intro into Using Formulas for Conditional Formatting
- Lecture 9 :
- Example: Using Formulas to Apply Conditional Formatting
- Lecture 10 :
- Example 2: Using Formulas to Apply Conditional Formatting
- Lecture 11 :
- Managing Conditional Formatting Rules
- Lecture 12 :
- QUIZ: Conditional Formatting
- Lecture 13 :
- REAL WORLD PRACTICE: Conditional Formatting
-
Section 7 : SECTIONS 7: MACROS
- Lecture 1 :
- Intro: Macros
- Lecture 2 :
- Introduction into Using Excel Macros
- Lecture 3 :
- Record Your First Excel Macro
- Lecture 4 :
- Saving a Workbook that Contains a Macro
- Lecture 5 :
- Introduction into the VBA and the Visual Basic Editor
- Lecture 6 :
- Relative vs Absolute Macro Recording
- Lecture 7 :
- QUIZ: Macros
- Lecture 8 :
- REAL WORLD PRACTICE: Macros
-
Section 8 : SECTION 4: PIVOT TABLES
- Lecture 1 :
- Intro: Pivot Tables
- Lecture 2 :
- Introduction into Pivot Tables
- Lecture 3 :
- The Right Foundation for a Pivot Table
- Lecture 4 :
- Launching a Pivot Table
- Lecture 5 :
- Building a Pivot Table
- Lecture 6 :
- Filtering Pivot Table & Adding Multiple Value Fields
- Lecture 7 :
- Editing Number Formats, Fonts & Label Headings
- Lecture 8 :
- Creating a Duplicate Pivot Table Report
- Lecture 9 :
- Changing Source Data & Refreshing Pivot Table
- Lecture 10 :
- Include Subtotals & Grand Totals to Pivot Tables
- Lecture 11 :
- Compact, Outline & Tabular Layout
- Lecture 12 :
- Selecting Pivot Table Style Options
- Lecture 13 :
- Filtering Pivot Table Using Slicers & Timelines
- Lecture 14 :
- REAL WORLD PRACTICE: Pivot Tables
-
Section 9 : WHAT'S NEXT
- Lecture 1 :
- Congratulations!!! What's Next?
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
228 Course Views
1 Courses
