1384888
Excel with this A-Z Microsoft Excel Course. Microsoft Excel 2010, 2013, 2016, Excel 2019, and Microsoft/Office 365/2023
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
-
- 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
- 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
- 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
- 67. Excel 101 – Practice What You’ve Learned67. Details 00:01:00
- 69. Excel 102 Course Exercise Files — DOWNLOAD Details 00:01: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
- 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
- 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
- 121. Excel 102 – Practice What You’ve Learned Details 00:01:00
- 123. Excel 103 Course Exercise Files Details 00:01: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
- 162. Microsoft Excel Adv. Functions and Formulas Quick Guide Details 00:01: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
- 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