PPC LMS
Soft Skills Office Productivity Microsoft Excel

Mastering Excel Fundamentals – Excel Beginner Course

4.9

94

330

PPCLMS Instructor

Excel with this A-Z Microsoft Excel Course. Microsoft Excel 2010, 2013, 2016, Excel 2019, and Microsoft/Office 365/2023

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

Excel with this A-Z Microsoft Excel Course. 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

  • Build a solid understanding of the Basics of Microsoft Excel
  • Learn some of the common basic Excel functions used in the Office
  • Learn how to format Data in an Excel Worksheet
  • Create Basic Charts in Excel
  • Learn how to work with Excel Templates
  • Access to a Professional Trainer with 10+ years of Excel Training

Who this course is for:

  • This Microsoft Excel course will take you through 4 levels of Microsoft Excel topics (Beginner, Intermediate, Advanced, and Macros/VBA).
  • If you're looking to take your Excel skills from beginner to advanced level and beyond, then this course is for you.

This course includes:

  • 21 hours of on-demand video
  • 15 articles
  • 54 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

This Microsoft Excel course combines 4 different courses.

  • Microsoft Excel 101 - An Introduction to Excel
  • Microsoft Excel 102 - Intermediate Level Excel
  • Microsoft Excel 103 - Advanced Level Excel
  • Master Microsoft Excel Macros and VBA in 6 Simple Projects

Enroll now to go through a deep dive of 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.

At the completion of this course, you will have mastered the most popular Excel tools and come out with confidence to complete any Excel tasks with efficiency and grace. Below are just a few of the topics that you will master:

  • Creating effective spreadsheets
  • Managing large sets of data
  • Mastering the use of some of Excel's most popular and highly sought-after functions (SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH, and many more...)
  • Create dynamic report with Excel PivotTables
  • Unlock the power and versatility of Microsoft Excel's Add-In, PowerPivot
  • Audit Excel Worksheet formulas to ensure clean formulas
  • Automate your day-to-day Excel tasks by mastering the power of Macros and VBA

What's Included?

  • 21+ 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 (101, 102, 103, and VBA) that you can download and practice the skills you've learned
  • Section Quizzes to Test Your Knowledge of the Lecture Topics
  • 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

    • 1. Ask Questions Details 00:02:00
    • 2. Course Exercise Files Details 00:01:00
    • 3. Certificate of Completion Details 00:01:00
    • 4. Launching Excel Details 00:02:00
    • 5. Microsoft Excel Startup Screen Details 00:03:00
    • 6. Introduction to the Excel Interface Details 00:07:00
    • 7. Customizing the Excel Quick Access Toolbar Details 00:03:00
    • 8. More on the Excel Interface Details 00:04:00
    • 9. Understanding the Structure of an Excel Workbook Details 00:04:00
    • 10. Saving an Excel Document Details 00:04:00
    • 11. Opening an Existing Excel Document Details 00:02:00
    • 12. Common Excel Shortcut Keys Details 00:03:00
    • Quiz 1: Excel Fundamentals 00:08:00
    • 13. Entering Text to Create Spreadsheet Titles Details 00:08:00
    • 14. Working with Numeric Data in Excel Details 00:08:00
    • 15. Entering Date Values in Excel Details 00:09:00
    • 16. Working with Cell References Details 00:06:00
    • 17. Creating Basic Formulas in Excel Details 00:09:00
    • 18. Relative Versus Absolute Cell References in Formulas Details 00:13:00
    • 19. Understanding the Order of Operation Details 00:11:00
    • Quiz 2: Entering and Editing Text and Formulas 00:08:00
    • 20. The structure of an Excel Function Details 00:10:00
    • 21. Working with the SUM() Function Details 00:07:00
    • 22. Working with the MIN() and MAX() Functions Details 00:06:00
    • 23. Working with the AVERAGE() Function Details 00:03:00
    • 24. Working with the COUNT() Function Details 00:03:00
    • 25. Adjacent Cells Error in Excel Calculations Details 00:04:00
    • 26. Using the AutoSum Command Details 00:07:00
    • 27. Excel’s AutoSum Shortcut Key Details 00:02:00
    • 28. Using the AutoFill Command to Copy Formulas Details 00:04:00
    • Quiz 3: Basic Excel Functions 00:08:00
    • 29. Moving and Copying Data in an Excel Worksheet Details 00:07:00
    • 30. Inserting and Deleting Rows and Columns Details 00:07:00
    • 31. Changing the Width and Height of Cells Details 00:05:00
    • 32. Hiding and Unhiding Excel Rows and Columns Details 00:05:00
    • 33. Renaming an Excel Worksheet Details 00:03:00
    • 34. Deleting an Excel Worksheet Details 00:05:00
    • 35. Moving and Copying an Excel Worksheet Details 00:00:00
    • Quiz 4: Modifying Worksheets Quiz 00:08:00
    • 36. Working with Font Formatting Commands Details 00:07:00
    • 37. Changing the Background Color of a Cell Details 00:03:00
    • 38. Adding Borders to Cells Details 00:02:00
    • 39. Excel Cell Borders Continued Details 00:03:00
    • 40. Formatting Data as Currency Values Details 00:04:00
    • 41. Formatting Percentages Details 00:03:00
    • 42. Using Excel’s Format Painter Details 00:04:00
    • 43. Creating Styles to Format Data Details 00:07:00
    • 44. Merging and Centering Cells Details 00:03:00
    • 45. Using Conditional Formatting Details 00:04:00
    • 46. Editing Excel Conditional Formatting Details 00:02:00
    • Quiz 5: Formatting Data 00:08:00
    • 47. Inserting Images Details 00:04:00
    • 48. Inserting Excel Shapes Details 00:00:00
    • 49. Formatting Excel Shapes Details 00:04:00
    • 50. Working with Excel SmartArt Details 00:08:00
    • 51. Creating an Excel Column Chart Details 00:01:00
    • 52. Working with the Excel Chart Ribbon Details 00:03:00
    • 53. Adding and Modifying Data on an Excel Chart Details 00:05:00
    • 54. Formatting an Excel Chart Details 00:07:00
    • 55. Moving a Chart to another Worksheet Details 00:00:00
    • 56. Working with Excel Pie Charts Details 00:07:00
    • 57. Microsoft Excel Charts Quick Guide Details 00:01:00
    • Quiz 6: Working With Excel Charts Quiz 00:08:00
    • 58. Viewing your Document in Print Preview Details 00:04:00
    • 59. Changing the Margins, Scaling and Orientation Details 00:08:00
    • 60. Excel Worksheet Margins Details 00:03:00
    • 61. Working with Page Layout View Details 00:03:00
    • 62. Adding Header and Footer Content Details 00:06:00
    • 63. Printing a Specific Range of Cells Details 00:03:00
    • Quiz 7: Printing an Excel Worksheet 00:08:00
    • 64. Intro to Excel Templates Details 00:03:00
    • 65. Opening an Existing Template Details 00:09:00
    • 66. Creating a Custom Template Details 00:06:00
    • Quiz 8: Excel Templates 00:03:00
    • 67. Excel 101 – Practice What You’ve Learned67. Details 00:01:00
    • 68. Congratulations! – Excel 101 Completed Details 00:02:00

Course Reviews

4.9

4.9
94 ratings
  • 5 stars81
  • 4 stars13
  • 3 stars0
  • 2 stars0
  • 1 stars0
  1. Mohammed AbdulaiFebruary 1, 2025 at 5:10 pm
    good job
    5

    I have learned a lot that I will be applying to my job from now on. Really appreciate your efforts to make us understand

  2. Emmanuel AntwiJanuary 30, 2025 at 4:34 am
    Excel review
    5

    This course was helpful and has really improved my Excel skills

  3. Mercy Gyankoma BoatengJanuary 29, 2025 at 1:01 pm
    Microsoft Excel 101
    5

    It was a very educative and insightful course.I enjoyed it!

  4. Jennifer AcheampongDecember 2, 2024 at 3:52 pm
    EXCELLENT
    5

    I love every single bit of this.

  5. Ohene Kwaku TwumNovember 25, 2024 at 2:11 am
    Excel 101
    5

    This has been very educative and convenient … thank you.

Related Courses