0

  • No products in the cart.

Office Productivity Microsoft Excel

Microsoft Excel – From Beginner to Advanced and Beyond

1384888

Job Heave

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

₵1,120.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

  • Master Microsoft Excel from Beginner to Advanced
  • Build a solid understanding of the Basics of Microsoft Excel
  • 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 and VBA
  • Maintain large sets of Excel data in a list or table
  • Create dynamic reports by mastering one of the most popular tools, PivotTables
  • Wow your boss by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions, and many more
  • 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
    • 69. Excel 102 Course Exercise Files — DOWNLOAD Details 00:01:00
    • 70. Understanding Excel List Structure Details 00:06:00
    • 71. Sorting a List Using Single Level Sort Details 00:04:00
    • 72. Sorting a List Using Multi-Level Sorts Details 00:04:00
    • 73. Using Custom Sorts in an Excel List Details 00:05:00
    • 74. Filter an Excel List Using the AutoFilter Tool Details 00:05:00
    • 75. Creating Subtotals in a List Details 00:07:00
    • 76. Format a List as a Table Details 00:08:00
    • 77. Using Conditional Formatting to Find Duplicates Details 00:04:00
    • 78. Removing Duplicates Details 00:04:00
    • Quiz 9: Excel List 00:08:00
    • 79. Introduction to Excels Function DSUM() Details 00:06:00
    • 80. Excel DSUM Function Single Criteria Continued Details 00:05:00
    • 81. Excel DSUM Function with OR Criteria Details 00:03:00
    • 82. Excel DSUM Function with AND Criteria Details 00:06:00
    • 83. Excel Function DAVERAGE() Details 00:06:00
    • 84. Excel Function DCOUNT() Details 00:06:00
    • 85. Excel Function SUBTOTAL() Details 00:08:00
    • Quiz 10: List Functions 00:05:00
    • 86. Understanding the Need for Excel Data Validation Details 00:05:00
    • 87. Creating an Excel Data Validation List Details 00:05:00
    • 88. Excel Decimal Data Validation Details 00:04:00
    • 89. Adding a Custom Excel Data Validation Error Details 00:05:00
    • 90. Dynamic Formulas by Using Excel Data Validation Techniques Details 00:05:00
    • Quiz 11: Data Validation 00:05:00
    • 91. Importing Data Into Microsoft Excel Details 00:02:00
    • 92. Importing Data from Text Files Details 00:06:00
    • 93. Importing Data from Microsoft Access Details 00:04:00
    • 94. NEW VERSION — Import Data From Text Files into Excel Details 00:08:00
    • 95. NEW VERSION — Import Data From a Database into Excel Details 00:06:00
    • 96. Microsoft Excel Legacy Import Options for New Excel Versions Details 00:02:00
    • 97. Exporting Data to a Text File Details 00:06:00
    • Quiz 12: Importing and Exporting Data 00:05:00
    • 98. Understanding Excel PivotTables Details 00:04:00
    • 99. Creating an Excel PivotTable Details 00:07:00
    • 100. Modifying Excel PivotTable Calculations Details 00:00:00
    • 101. Grouping PivotTable Data Details 00:08:00
    • 102. Formatting PivotTable Data Details 00:04:00
    • 103. Modifying PivotTable Calculations Details 00:09:00
    • 104. Drilling Down into PivotTable Data Details 00:04:00
    • 105. Creating PivotCharts Details 00:04:00
    • 106. Filtering PivotTable Data Details 00:03:00
    • 107. Filtering with the Slicer Tool Details 00:03:00
    • 108. Introduction to Excel Power Pivot Details 00:05:00
    • 109. Why PowerPivot Details 00:08:00
    • 110. Activating the Excel PowerPivot AddIn Details 00:03:00
    • 111. Creating Data Models with PowerPivot Details 00:05:00
    • 112. Excel Power Pivot Data Model Relationships Details 00:05:00
    • 113. Creating PivotTables based on Data Models Details 00:06:00
    • 114. Excel Power Pivot KPIs Details 00:11:00
    • 115. Using the Freeze Panes Tool Details 00:04:00
    • 116. Grouping Data (Columns and/or Rows) Details 00:04:00
    • 117. Print Options for Large Sets of Data Details 00:08:00
    • 118. Linking Worksheets (3D Formulas) Details 00:04:00
    • 119. Consolidating Data from Multiple Worksheets Details 00:06:00
    • 120. Microsoft Excel Managing Large Excel Datasets Quick Guide Details 00:01:00
    • 121. Excel 102 – Practice What You’ve Learned Details 00:01:00
    • 122. Congratulations! Details 00:02:00
    • 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
    • 164. Welcome to the Course Details 00:06:00
    • 165. Understanding the Why and How Behind Excel Macros Details 00:05:00
    • 166. Introduction to Project #1 Inserting and Formatting Text Details 00:04:00
    • 167. Microsoft Excel Adv. Functions and Formulas Quick Guide Details 00:01:00
    • 168. Activating the Excel Developer Tab Details 00:02:00
    • 169. Project #1 Start Recording! Details 00:11:00
    • 170. Running a Microsoft Excel Macro Details 00:04:00
    • 171. Project #1 Running an Excel Macro with a Button Details 00:06:00
    • 172. BONUS – Create a Custom Button Using Excel Shapes Details 00:04:00
    • 173. Adding the Excel Macro to the Quick Access Toolbar Details 00:04:00
    • 174. Project #1 Editing the VBA Recorded by the Macro Recorder Details 00:12:00
    • 175. Save a Workbook with a MacroVBA Code Details 00:03:00
    • 176. Practical Uses of Excel Macros Details 00:02:00
    • 177. Intro to Excel VBA Concepts Details 00:07:00
    • 178. Intro to Excel VBA Object Oriented Programming Concepts Details 00:05:00
    • 179. Intro to Excel VBA Exercise Files Details 00:01:00
    • 180 The Visual Basic Editor (VBE) Details 00:05:00
    • 181. Introduction to the Excel VBA Immediate Window Details 00:13:00
    • 182. Excel VBA Modules Details 00:04:00
    • 183. Creating an Excel VBA Procedure Details 00:06:00
    • 184. Adding Code to a VBA Procedure Details 00:05:00
    • 185. Including Excel VBA Comments Details 00:03:00
    • 186. Excel VBA MSGBOX Function Details 00:07:00
    • 187. Excel VBA MsgBox Microsoft Help Information Details 00:02:00
    • 188. Understanding and Working with Excel VBA Variables Details 00:16:00
    • 189. REMINDER Saving an Excel Workbook with VBA Code Details 00:02:00
    • 190. Working with Excel VBA Logic Exercise Files Details 00:01:00
    • 191. Building Logic with an Excel VBA IF Statement Details 00:08:00
    • 192 Including an Else Statement in the VBA IF Statement Details 00:02:00
    • 193. Expanding the IF Logic with Multiple ElseIf Statements Details 00:03:00
    • 194. Working with Excel VBA Select Case Statements Details 00:05:00
    • 195. Working with an Excel VBA Do While Loop Details 00:12:00
    • 196. Excel VBA Do While Loop Dynamic Condition Details 00:06:00
    • 197. Working with an Excel VBA For Each Loop Details 00:06:00
    • 198. Working with an Excel VBA For Next Loop Details 00:08:00
    • 199. Introduction to Project #2 Interacting with the User Details 00:02:00
    • 200. Beyond the Basics Sort Project Exercise Files (DOWNLOAD) Details 00:01:00
    • 201. Project #2 Introduction to the Excel VBA RangeSort Method Details 00:05:00
    • 202. Creating the Excel VBA Sort Procedures for this Project Details 00:09:00
    • 203. Project #2 Prompting the User for Information Details 00:10:00
    • 204. Continue Excel VBA InputBox Details 00:09:00
    • 205. Project #2 Building Logic into Your Macros Details 00:04:00
    • 206. Project #2 Alerting the User of Errors Details 00:10:00
    • 207. Using Excel VBA Error Control Statements Details 00:05:00
    • 208. Create a Button to Run the Sort Procedure and Save Details 00:02:00
    • 209. Introduction to Project #3 Cleaning Up and Formatting Data Details 00:03:00
    • 210. Project #3: Exercise Files (DOWNLOAD) Details 00:01:00
    • 211. Project #3 Preparing to Use the Macro Recorder Details 00:03:00
    • 212. Project #3 Inserting the Headers Details 00:05:00
    • 213. Project #3 Formatting the Headers Details 00:04:00
    • 214. Project #3 Testing the Macros Details 00:03:00
    • 215. Project #3 Using an Excel VBA Loop to Loop through all Worksheets Details 00:10:00
    • 216. Project #3 Testing the Excel VBA Loop Details 00:03:00
© JobHeave. All rights reserved.
X