0

  • No products in the cart.

Soft Skills Office Productivity Microsoft Excel

Microsoft Excel: Advanced Excel Training

4.9

7

78

PPCLMS Instructor

Become an advanced Excel user, for users using Microsoft Excel 2010, 2013, 2016, Excel 2019, and Microsoft/Office 365/2023.

Original price was: ₵500.00.Current price is: ₵350.00.

Excel with this A-Z Microsoft Excel Course. Become an advanced Excel user, for users using Microsoft Excel 2010, 2013, 2016, Excel 2019, and Microsoft/Office 365/2023.

Requirements

  • No Prior Excel Knowledge Required
  • Microsoft Excel 2007, 2010, 2013, 2013, 2019 or Microsoft 365 Excel loaded on a computer to follow along with Instructor Lectures is Recommended

What you'll learn

  • Master Microsoft Excel from Beginner to Advanced
  • Learn the most common Excel functions used in the Office
  • Harness the full power of Microsoft Excel by automating your day-to-day tasks through Macros.
  • Maintain large sets of Excel data in a list or table
  • Excel Dashboarding and how to effectively create data visualizations
  • Wow your boss by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions, and many more
  • Start applying Advanced Excel in real-world situations
  • Access to a Professional Trainer with 10+ years of Excel Training

Who this course is for:

  • If you're looking to take your Excel skills from beginner to advanced level and beyond, then this course is for you.
  • Great for students and working professionals who want to learn at their own pace.

This course includes:

  • 4 hours of on-demand video
  • 15 articles
  • 4 downloadable resources
  • Access on PC and mobile
  • Full lifetime access
  • Certificate of completion

Description

Microsoft Excel All-in-one Package

Topics covered in this course apply to Excel 2007, 2010, 2013, 2016, 2019 (Microsoft/Office 365)/2023

Enroll now to go through a deep dive into the most popular spreadsheet tool on the market, Microsoft Excel. As a Microsoft Certified Trainer I will use my 20+ years of Excel training to guide you step by step through the beginner to advanced level and beyond.

As you participate in each of the 4 courses you will master Excel tools that will clear away the pain of stumbling through your daily tasks. You will start with the basics, building a solid foundation that will give you further knowledge as you progress into intermediate and advanced-level topics.

After this course, you will have mastered the most popular Excel tools and come out with the confidence to complete any Excel tasks with efficiency and grace.

What's Included?

  • 4+ Hours of Step by Step Video Lectures by a Microsoft Certified Trainer (MCT)
  • Downloadable Exercise Files to follow along and practice with
  • Additional Exercise Files are provided at the end of each major section that you can download and practice the skills you've learned
  • Forum where you can post questions, and screenshots of your progress and communicate with the instructor and fellow students in the course.

So, what are you waiting for, enroll now and take the next step in mastering Excel and go from Excel Newb to Excel Guru!

Course Currilcum

    • 123. Excel 103 Course Exercise Files Details 00:01:00
    • 124. Working with Excel Name Ranges Details 00:04:00
    • 125. Advantages and Disadvantages of Excel Name Ranges Details 00:06:00
    • 126. Editing an Excel Name Range Details 00:03:00
    • 127. Using Excel’s IF() Function Details 00:05:00
    • 128. Excel’s IF() Function with a Name Range Details 00:05:00
    • 129. Nesting Functions with Excel Details 00:09:00
    • 130. Nesting Excels AND() Function within the IF() Function Details 00:05:00
    • 131. Using Excel’s COUNTIF() Function Details 00:03:00
    • 132. Using Excel’s SUMIF() Function Details 00:07:00
    • 133. Using Excel’s IFERROR() Function Details 00:05:00
    • 134. Microsoft Excel VLOOKUP() Function Details 00:10:00
    • 135. Microsoft Excel HLOOKUP() Function Details 00:05:00
    • 136. Microsoft Excel INDEX() Function Details 00:09:00
    • 137. Microsoft Excel MATCH() Function Details 00:05:00
    • 138. Microsoft Excel INDEX() and MATCH() Function Combined Details 00:07:00
    • 139. Microsoft Excel INDEX() and MATCH() Function Combined Continued Details 00:09:00
    • 140. Creating a Dynamic HLOOKUP() with the MATCH() Function Details 00:07:00
    • 141. Using Excel’s LEFT(), RIGHT() and MID() Functions Details 00:06:00
    • 142. Using Excel’s LEN() Function Details 00:06:00
    • 143. Using Excel’s SEARCH() Function Details 00:12:00
    • 144. Using Excel’s CONCATENATE() Function Details 00:03:00
    • 145. Microsoft Excel Adv. Functions and Formulas Quick Guide Details 00:01:00
    • 146. Tracing Precedents in Excel Formulas Details 00:04:00
    • 147. Tracing Dependents in Excel Formulas Details 00:03:00
    • 148. Working with the Watch Window Details 00:04:00
    • 149. Showing Formulas Details 00:03:00
    • 150. Protecting Specific Cells in a Worksheet Details 00:08:00
    • 151. Protecting the Structure of a Workbook Details 00:04:00
    • 152. Adding a Workbook Password Details 00:03:00
    • 153. Working with Excel’s Goal Seek Tool Details 00:08:00
    • 154. Working with Excel’s Solver Tool Details 00:11:00
    • 155. Building Effective Data Tables in Excel Details 00:06:00
    • 156. Creating Scenarios in Excel Details 00:08:00
    • 157. Understanding Excel Macros Details 00:04:00
    • 158. Activating the Developer Tab in Excel Details 00:02:00
    • 159. Creating a Macro with the Macro Recorder Details 00:08:00
    • 160. Editing a Macro with VBA Details 00:05:00
    • 161. Creating Buttons to Run Macros Details 00:03:00
    • 162. Microsoft Excel Adv. Functions and Formulas Quick Guide Details 00:01:00
    • 163. Congratulations on Completing the Microsoft Excel 103 Details 00:02:00

Course Reviews

4.9

4.9
7 ratings
  • 5 stars6
  • 4 stars1
  • 3 stars0
  • 2 stars0
  • 1 stars0
  1. Prince AdevorMay 26, 2024 at 9:55 am
    ADVANCED EXCEL
    4

    IT WAS FUN

  2. Veronica NyarkoMarch 13, 2024 at 7:28 am
    Microsoft excel advance.
    5

    The steps were clear and easy to follow.

  3. Nancy Appiagyei AbugyansaMarch 8, 2024 at 10:41 pm
    Excel Advance Course
    5

    This course was educative.

  4. Amoabeng Amponsah GordonMarch 6, 2024 at 12:09 pm
    Advanced Course
    5

    interesting and comprehensive

  5. Rufkatu FaisalFebruary 19, 2024 at 10:47 pm
    Excel Advancement Course
    5

    This was really educative.

About

 

At PPC LMS, we believe in the transformative power of online education and our mission is to make it as engaging, interactive, and convenient as possible

 

top
© PPC LMS. All rights reserved.