Mastering Microsoft Excel & VBA: Basics to Advanced Skills

Learn MS Excel & VBA from scratch:Formulas, Pivot Tables,Macros, Data Analysis, and more for beginners to advanced users

Created by: Johnnie Walker
Photographer, Cinematographer and Film Maker

What Will I Learn?

• Lecture 1: Introduction Lecture
• Lecture 4: Most Commonly Used Formulas in Excel
• Lecture 5: Pivot Tables Intermediate
• Lecture 6: Introduction to Macros in Microsoft Excel
• Lecture 8: How to Create a Dependent Drop-down in Excel
• Lecture 9: How to Transpose Data in Excel (Vertical and Horizontal)
• Lecture 10: How to Get the Equation of a Slope in Excel
• Lecture 11: How to Find and Replace in Excel
• Lecture 12: How to Calculate the Correlation Coefficient in Excel
• Lecture 13: How to Change from Upper Case to Lower Case to Proper Case in Excel

Requirements

• There are no specific requirements or prerequisites for taking this course. This course is designed to be accessible to beginners and individuals with little to no prior experience with Microsoft Excel. All you need is:
• A computer or device with Microsoft Excel installed (Excel 2010 or later versions recommended).
• Basic computer literacy, including the ability to navigate and use a computer or device.
• An interest in learning how to use Microsoft Excel for various tasks, from basic spreadsheet creation to advanced data analysis.

Target audience

• Beginners and New Users: Individuals who have little to no experience with Microsoft Excel and want to start from the basics.
• Students: Those in school or college who need to use Excel for coursework, projects, and assignments.
• Professionals: Office workers, analysts, and managers who want to enhance their skills in Excel for data analysis, reporting, and day-to-day tasks.
• Job Seekers: Individuals looking to improve their resume by gaining essential Excel skills that are highly valued in many job markets.
• Entrepreneurs and Small Business Owners: Those who need to manage their business data, finances, and operations more effectively using Excel.
• Anyone Interested in Data Management: Individuals who are interested in learning how to use Excel for various data management tasks, from creating spreadsheets to performing complex data analysis.