All in One Offer! | Access Unlimited Courses in any category starting at just $29. Offer Ends in:

Browse Library

  • Business Solutions
  • Become an Instructor
  • 0
    Shopping Cart

    Your Cart is empty. Keep shopping to find a course!

    Browse Courses
Get Unlimited Learning Access
$29
6 days left at this price!
30-Day Money-Back Guarantee

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
Subscribe to Learnfly’s top courses
Get this course, plus 11,000+ of our top-rated courses for one year with Go Annually Plan.
$348 $244 a year Save 30%
6 days left at this price!
30-Day Money-Back Guarantee

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
$29
$244
  • 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.

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

  • Microsoft Excel 2010 or above
  • 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.
View More...
  • Section 1 : INTRODUCTION 5 Lectures

    • Lecture 1 :
    • 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 11 Lectures 00:21:42

    • 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
    • QUIZ: Functions & Formulas Fundamentals
  • Section 3 : SECTION 3: LOOKUP FUNCTIONS 8 Lectures 00:10:57

    • 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
    • Quiz: Lookup Functions
  • Section 4 : SECTION 4: LOGICAL FUNCTIONS 12 Lectures 00:12:32

    • 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
    • QUIZ: Logical Functions
    • Lecture 12 :
    • REAL WORLD PRACTICE: Logical Functions
  • Section 5 : SECTION 5: TEXT FUNCTIONS 9 Lectures 00:09:15

    • 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
    • QUIZ: Text Functions
    • Lecture 9 :
    • REAL WORLD PRACTICE: Text Functions
  • Section 6 : SECTION 6: CONDITIONAL FORMATTING 13 Lectures 00:11:22

    • 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
    • QUIZ: Conditional Formatting
    • Lecture 13 :
    • REAL WORLD PRACTICE: Conditional Formatting
  • Section 7 : SECTIONS 7: MACROS 8 Lectures 00:02:23

    • 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
    • QUIZ: Macros
    • Lecture 8 :
    • REAL WORLD PRACTICE: Macros
  • Section 8 : SECTION 4: PIVOT TABLES 14 Lectures 00:23:09

    • 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 1 Lectures

    • Lecture 1 :
    • Congratulations!!! What's Next?
  • 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?

149 Course Views

1 Courses

About me I'm Kerron Duncan. I'm an Excel Solutions Consultant and Excel Corporate Trainer. One of my big passions is designing solutions and solving complex problems using Microsoft Excel. Fortunately, I also love to teach so I enjoy sharing my knowledge. I have a background in auditing which allowed me to work in multiple industries while performing audits for several years. I use my experience in working in multiple industries along with my Excel knowledge to provide students with the key skills then need to know in Excel and other technologies today. Ultimately, what makes being an instructor worthwhile for me is to make your life easier by sharing knowledge that will empower you by saving you time, money and so much more. That is my goal in every course I publish. My best wishes to you as you continue to learn. Warm regards Kerron Duncan Excel Galaxy
View More...
  • Unmatched Variety and Value!
    Learnfly's monthly subscription offers unlimited access to a vast range of courses. Affordable pricing, compared to competitors, makes it the ultimate choice for continuous learning.
    Jessica M.

    4.7

    JM
  • Top-Notch Quality, Affordable Rates!
    High-quality courses with certified instructors make Learnfly stand out. The affordable pricing is a game-changer for those seeking premium education.
    Alex P.

    4.5

    AP
  • Certified Excellence Every Time!
    Learnfly's courses, taught by certified instructors, ensure top-notch learning experiences. The course completion certificates add significant value to one's skill set.
    Sarah R.

    4.3

    SR
  • Round-the-Clock Support!
    Learnfly goes the extra mile with 24/7 course support. Their dedication to helping students succeed is commendable.
    Ryan K.

    4.1

    RK
  • Learn Anywhere, Anytime!
    Whether on mobile, PC, or tablet, Learnfly's platform offers flexibility. Learning on the go has never been easier.
    Emily S.

    4.7

    ES
  • Job-Ready Skills!
    Learnfly's job-oriented courses equip learners with practical skills for the workplace. An investment in career growth!
    Jake M.

    4.2

    JM
  • Budget-Friendly Brilliance!
    Learnfly's pricing is a steal for the quality and variety of courses offered. Quality education without breaking the bank.
    Olivia T.

    4.5

    OT
  • Instructor Excellence Unleashed!
    Learn from the best with Learnfly's certified instructors. The platform ensures that knowledge is imparted by industry experts.
    Daniel L.

    4.0

    DL
  • Achievement Unlocked!
    Learnfly not only offers courses but also recognizes your efforts with course completion certificates. A sense of accomplishment with every course finished.
    Maya H.

    4.6

    MH
  • Learning Revolution!
    Learnfly's platform is a revolution in education. Access to unlimited courses at affordable rates is a game-changer.
    Ethan W.

    4.7

    EW
  • principles-of-data-cleaning

    Principles of Data Cleaning

    By : Phikolomzi Gugwana

    Lectures 25 Beginner 0:34:10
  • microsoft-power-bi-a-complete-hands-on-training

    Microsoft Power BI-A Complete Hands...

    By : Deepesh Vashistha

    Lectures 41 Beginner 3:35:28

Students learning on Learnfly works with Fortune 500 companies around the globe.

Sign Up & Start Learning
By signing up, you agree to our Terms of Use and Privacy Policy
Reset Password
Enter your email address and we'll send you a link to reset your password.