Setup Menus in Admin Panel

  • No products in the basket.
Office Productivity

Microsoft Excel Masterclass

Microsoft Excel from A-Z: Beginner To Expert Course to master pivot tables, formulas, macros, vba, data analysis and learn how to land your first job as an Excel expert! This course comes with 14 CPD points accredited by the CPD group.

Course Instructor

Juan E. Galvan

Duration

13 hours, 20 minutes

Last updated

November 1, 2023

4.8
Students

917

£39.99 inc. VAT

More about the course

Microsoft Excel is a versatile and powerful spreadsheet software used worldwide for various tasks, from data analysis and financial modelling to project management and reporting. It offers many features and functionalities that can significantly boost productivity and efficiency in almost any industry.
In Juan Galvan's comprehensive course, you'll learn how to navigate Excel and discover this remarkable tool's true potential. Whether you're a beginner seeking to grasp the basics or an experienced user aiming to enhance your skills, this course covers everything. Microsoft Excel is renowned for its ability to handle large datasets, perform complex calculations, and generate insightful visualizations. With the course's guidance, you'll gain a deep understanding of formulas, functions, and capabilities that enable you to manipulate data, automate tasks, and make informed decisions. You’ll also learn about calculating depreciation, interest, and loan EMI using Excel functions. The course also features information on INDEX and MATCH functions, using the CHOOSE formula, and how to create unique charts. The software is invaluable in financial analysis, budgeting, and forecasting, allowing professionals in finance and accounting to streamline processes and provide accurate insights. It is also an essential tool for data analysts, enabling them to extract meaningful patterns, trends, and correlations from vast amounts of information. Project managers benefit from Excel's features for tracking progress, managing resources, and creating reports. By mastering Excel through this course, you'll acquire the skills to effectively plan, execute, and monitor projects, ensuring their success. Furthermore, Excel's versatility extends to industries such as sales, marketing, human resources, and education. It facilitates tasks like creating sales reports, analyzing marketing data, managing employee information, and organizing educational materials.

The course covers 4 main areas:

1: INTRO TO EXCEL

This intro section fully introduces Microsoft Excel, the data analyst industry and marketplace, job opportunities and salaries, and the various Excel-related job roles.
  • Intro to Microsoft Excel
  • Excel Industry and Marketplace
  • Excel Job Opportunities
  • Getting Started with Excel
  • Excel Functions

2: INTERMEDIATE EXCEL

This section gives you a complete introduction to the Intermediate Excel functions with hands-on, step-by-step training.
  • Data Visualization
  • Datasets
  • Databases
  • Data Validation
  • PivotTables
  • Conditional Functions
  • Lookup Functions
  • Formulas, + more!

3: EXCEL MACROS & VBA

This section introduces you to Excel Macros and VBA with hands-on, step-by-step training.
  • VBA Language
  • VBA Code
  • VBA Loops
  • Macros
  • User Forms

4: STARTING AN EXCEL CAREER

This section gives you a complete introduction to starting a career as an Excel Programmer with hands-on, step-by-step training.
  • Creating a Resume
  • Freelancing + Freelance websites
  • How To Get Your 1st Client
  • Personal Branding
  • Importance of Having a Website
  • Networking
By the end of the course, you’ll be a professional Excel programmer and confidently apply for jobs and feel good knowing that you have the skills and knowledge to back it up.
  Additionally, this course is accredited by the CPD group and will earn you the essential 14 CPD points for your Continuous Professional Development.

You will be able to do the following after completing this course:

  • Learn to master Excel from A-Z
  • How to Become a Professional Data Analyst
  • How to be a better, faster, more robust Excel user
  • How to land your first job as an Excel Expert
  • How to save hours and boost your productivity in Excel
  • How to find a value with VLOOKUP, HLOOKUP, INDEX, MATCH
  • How to use math, statistical, logic and text functions
  • How to use VBA and Macros
  • How to use VLOOKUP/HLOOKUP in formulas
  • How to create basic and advanced formulas
  • Mastering Pivot Tables
  • Creating Charts from your data

Who is this course beneficial for?

The Microsoft Excel Masterclass course offers specific benefits to individuals at different skill levels, including beginners, intermediate learners, and advanced users. Here's a breakdown of the benefits for each skill level: Beginner Level:
  1. Beginners: If you are new to Excel or have limited experience with spreadsheets, this course provides a solid foundation. It covers essential Excel functions, formulas, and features, allowing beginners to gain confidence and navigate Excel effectively.
  2. Office Administrators: For office administrators, the course equips them with the necessary skills to streamline administrative tasks, such as data entry, organizing information, and creating basic reports. It improves their efficiency and accuracy in handling Excel-related duties.
Intermediate Level:
  1. Data Analysts: Intermediate learners can enhance their data analysis capabilities through advanced Excel techniques covered in the course. They learn to manipulate data, perform complex calculations, and create insightful visualizations, enabling them to extract meaningful insights from datasets.
  2. Financial Professionals: Intermediate learners in finance-related roles benefit from the course by acquiring advanced financial modeling skills, budgeting techniques, and data analysis capabilities. They can effectively manage financial data, analyze trends, and make informed decisions based on accurate financial information.
  3. Business Professionals: Intermediate-level business professionals, such as sales or marketing specialists, gain practical skills in data manipulation, formula usage, and report generation. This empowers them to analyze data, track performance, and make data-driven decisions to drive business growth.
Advanced Level:
  1. Advanced Data Analysts: Advanced users can further refine their data analysis skills by mastering complex Excel functions, advanced formulas, and pivot tables covered in the course. They gain expertise in data modelling, statistical analysis, and advanced data visualization techniques.
  2. Financial Experts: Advanced learners in finance-related roles, such as financial analysts or controllers, can leverage the course to expand their knowledge in financial forecasting, advanced financial modelling, and scenario analysis. This enables them to make sophisticated financial decisions and provide strategic insights to stakeholders.
  3. Business Intelligence Professionals: Advanced Excel users can utilize the course to enhance their data cleansing, data transformation, and advanced data visualization skills. They learn how to create dynamic dashboards and interactive reports, enabling them to deliver valuable business insights.

Why Choose this course?

  • Developed and delivered by Microsoft Excel Expert
  • 14 CPD points accredited by the CPD group
  • Get Instant E-certificate
  • Fully online
  • Self-paced learning and laptop, tablet, and smartphone-friendly
  • 24/7 Support

Career prospect of this course on Microsoft Excel:

The Microsoft Excel Masterclass course offers a wide range of career prospects for both beginner and expert learners. Whether just starting your Excel journey or aiming to enhance your existing skills, this course can open up numerous opportunities in various industries. Here are the potential career prospects at different skill levels: Beginner Level:
  1. Administrative Assistant: Many administrative roles require basic Excel skills for data entry, organizing information, and creating simple spreadsheets. The Microsoft Excel Masterclass course will provide a solid foundation, enabling you to excel in administrative positions relying on Excel.
  2. Data Entry Clerk: As a data entry clerk, you will be responsible for accurately inputting and managing data in Excel spreadsheets. The course will teach you essential Excel functions and shortcuts, allowing you to work more efficiently and accurately in this role.
  3. Customer Support Specialist: Excel skills can be valuable in customer support positions where you may need to analyze data, track customer information, or create reports. You will gain the necessary skills to handle Excel-related tasks confidently by completing the course.
Intermediate Level:
  1. Financial Assistant: With intermediate Excel skills, you can pursue roles such as financial assistant, where you'll be involved in budgeting, financial analysis, and reporting. The Microsoft Excel Masterclass course will enhance your financial modelling capabilities and enable you to work with complex financial data.
  2. Sales Analyst: Sales analysts often utilize Excel for data analysis, forecasting, and generating sales reports. By advancing your Excel proficiency through the course, you can excel in sales analysis roles, providing valuable insights to drive business growth.
  3. Project Coordinator: As a project coordinator, you must track project progress, manage resources, and create project reports. The course will equip you with advanced Excel techniques, enabling you to handle project-related tasks and data analysis efficiently.
Expert Level:
  1. Data Scientist: With expert-level Excel skills, you can pursue a career as a data scientist, utilizing Excel for data manipulation, analysis, and modelling. The Microsoft Excel Masterclass course will enhance your data analysis capabilities and provide a solid foundation for advanced data science techniques.
  2. Business Consultant: Excel expertise is highly sought-after in the consulting field. As a business consultant, you can leverage advanced Excel skills to analyze business data, identify trends, and provide strategic recommendations. The course will sharpen your analytical abilities and make you an asset in consulting engagements.
  3. Financial Controller: Advanced Excel proficiency is essential for financial controllers overseeing financial operations, budgeting, and reporting. By mastering Excel through the course, you can handle complex financial analyses and contribute to strategic financial decision-making.
The Microsoft Excel Masterclass course offers something, no matter your skill level. It will empower you with the necessary skills and knowledge to pursue a successful career in various fields where Excel expertise is in high demand. Invest in your future and take the next step towards Excel mastery!

Industry Expert Instructor

Profile Photo

Juan E. Galvan

4.77 4.771428571428571
Digital Entrepreneur | Marketer | Visionary

Preview Certificate

Rated Excellent on Trustpilot

Try Course Central Business

Course Content

    • Excel from A-Z Course Section Overview FREE 00:03:00
    • What is Microsoft Excel? 00:04:00
    • Who This Course is For 00:04:00
    • Microsoft Excel Marketplace 00:04:00
    • Microsoft Excel Job Opportunities 00:03:00
    • Microsoft Excel Job Types 00:04:00
    • Resources 00:10:00
    • Finding & Opening Microsoft Excel 00:01:00
    • Excel’s Start Screen 00:03:00
    • Explaining the Excel Interface 00:03:00
    • Excel Interface Continued 00:01:00
    • Excel Workbook vs Excel Worksheet 00:02:00
    • Saving & Opening Excel Documents 00:04:00
    • Customizing the Excel Quick Access Toolbar 00:02:00
    • Customizing the Excel Ribbon 00:03:00
    • Excel Shortcut Keys 00:02:00
    • Creating Excel Labels 00:03:00
    • Entering Numeric Values in Excel 00:03:00
    • Formatting Date Values in Excel 00:05:00
    • Building Basic Formulas in Excel 00:05:00
    • Order of Operations 00:06:00
    • Relative vs Absolute Cell References 00:07:00
    • Excel Functions Explained 00:03:00
    • The SUM() Function 00:08:00
    • The MIN() & MAX() Function 00:04:00
    • The AVERAGE() Function 00:02:00
    • COUNT() Functions 00:05:00
    • Moving & Copying Data 00:07:00
    • Insert & Delete Rows/Columns 00:05:00
    • Adjusting the Width & Height of Cells 00:05:00
    • Hiding and Unhiding Excel Rows and Columns 00:04:00
    • Renaming, Moving & Deleting Excel Worksheets 00:05:00
    • Adding Protection to Specific Cells 00:04:00
    • Protecting the Structure of a Workbook 00:02:00
    • Adding a Workbook Password to Open File 00:02:00
    • Formatting Fonts and Cell Background Color 00:05:00
    • Adding Cell Borders 00:05:00
    • Formatting Data Appropriately 00:05:00
    • The Magic behind Excel’s Format Painter 00:04:00
    • Creating Styles for Formatting Efficiency 00:06:00
    • Merging Cells for a Cleaner Look 00:03:00
    • The Power of Conditional Formatting 00:06:00
    • Grab User’s Attention using Illustrations 00:09:00
    • Customizing Icons 00:05:00
    • Create Compelling Graphics with SmartArt 00:06:00
    • The Commonly used Column Chart 00:03:00
    • Changing the Chart Design 00:02:00
    • Formatting Elements of a Chart 00:06:00
    • Modifying the Data, Type & Location of a Chart 00:06:00
    • Little Slice of Pie Charts 00:05:00
    • Print Preview Options 00:04:00
    • Excel’s Page Layout View 00:07:00
    • Printing a Specific Range of Cells 00:03:00
    • Converting Spreadsheets to PDF Files 00:02:00
    • Why Create an Excel Template 00:01:00
    • How to Create an Excel Template 00:05:00
    • How to Prepare Data for Analysis 00:04:00
    • How to Sort Data in Excel 00:03:00
    • Multi-Level Sorting 00:03:00
    • Custom Sorting Datasets in Excel 00:02:00
    • Applying Filters to Datasets 00:05:00
    • Creating Subtotals within a Dataset 00:06:00
    • Converting Datasets into Tables 00:06:00
    • Finding & Removing Duplicate Values 00:07:00
    • The SUMIF() Function 00:09:00
    • The DSUM() Function 00:08:00
    • DSUM() Function Cont. 00:07:00
    • The SUBTOTAL() Function 00:06:00
    • What is Excel Data Validation? 00:02:00
    • Creating a Drop Down List with Data Validation 00:07:00
    • Different Types of Excel Data Validation 00:06:00
    • Adding Custom Alerts to Data Validation 00:07:00
    • Creating a Dynamic Drop Down List 00:03:00
    • Complex Validation: Dependent Drop Down List! 00:09:00
    • Creating an Excel Pivot Table 00:06:00
    • Modifying Excel PivotTables 00:06:00
    • Grouping & Filtering PivotTable Data 00:07:00
    • Drilling Down into PivotTable Data 00:02:00
    • Creating Pivot Charts & Utilizing Slicers 00:08:00
    • What is PowerPivot? 00:04:00
    • Activating the Excel PowerPivot Add-In 00:02:00
    • Creating Relationships between Data Tables 00:06:00
    • Using Data Models to Create PivotTables 00:05:00
    • How to Create PowerPivot KPI’s 00:08:00
    • Excel’s IF() Function 00:05:00
    • IF() Function with AND() Criteria 00:05:00
    • IF() Function with OR() Criteria 00:05:00
    • Nesting Multiple IF() Functions 00:07:00
    • The COUNTIF() Function 00:04:00
    • Key Benefits of Named Ranges 00:04:00
    • VLOOKUP() Function 00:09:00
    • The Beauty of Excel’s IFERROR() Function 00:04:00
    • HLOOKUP() Function 00:06:00
    • INDEX() Function 00:05:00
    • MATCH() Function 00:05:00
    • INDEX() and MATCH() Combined 00:05:00
    • Two-Way Lookup with INDEX() and MATCH() 00:04:00
    • Two-Way Lookup with INDEX() and MATCH() 00:04:00
    • LEFT(), RIGHT() and MID() Function 00:07:00
    • Extracting Specific Text using LEN() & SEARCH() 00:13:00
    • Combining Text with CONCATENATE() 00:06:00
    • Quick Tips & Other Text Based Functions 00:06:00
    • Tracing Precedents & Dependents in Formulas 00:04:00
    • Showing Formulas 00:02:00
    • Grouping Data 00:03:00
    • 3D Referencing in Formulas 00:05:00
    • Utilizing the Watch Window in Excel 00:03:00
    • How to Freeze Panes in Excel 00:03:00
    • Excel’s Scenario Manager Tool 00:06:00
    • Goal Seek in Excel 00:06:00
    • Compare Results with Excel Data Tables 00:04:00
    • Solver Tool 00:11:00
    • The Power Behind Excel VBA 00:03:00
    • A Look Inside the Visual Basic Editor (VBE) 00:04:00
    • Recording a Macro 00:09:00
    • Saving & Opening a Macro-Enabled Workbook 00:02:00
    • Modules and Procedures 00:07:00
    • Objects, Methods and Properties 00:06:00
    • Excel VBA Variables 00:05:00
    • Referencing a Range 00:14:00
    • InputBox & MsgBox 00:06:00
    • Using Variables in VBA Code 00:05:00
    • If Then Else Statement 00:10:00
    • Worksheet Functions inside VBA 00:08:00
    • Creating User Defined Functions 00:09:00
    • User Defined Functions within VBA Scripts 00:06:00
    • Find Last Row of Data 00:06:00
    • Find Last Column of Data 00:03:00
    • With Statement 00:05:00
    • Debugging & Error Handling 00:07:00
    • Debugging & Error Handling Cont. 00:07:00
    • For Next Loop 00:09:00
    • Do Until Loop 00:06:00
    • For Each Loop 00:04:00
    • Assigning Macros to Shapes 00:04:00
    • Form Controls vs ActiveX Controls 00:08:00
    • Worksheet Events 00:04:00
    • Workbook Events 00:03:00
    • Fun with VBA Events! 00:07:00
    • Creating an Excel User Form 00:03:00
    • Adding Controls to User Forms 00:10:00
    • How to Show an User Form 00:03:00
    • Passing Text Box Values to Desired Cells 00:07:00
    • Passing Option Buttons to Desired Cells 00:07:00
    • User Form Combo Boxes 00:08:00
    • Clearing Values from User Form Controls 00:03:00
    • How to Close an User Form 00:02:00
    • User Forms and Protected Sheets 00:05:00
    • Creating an Excel Resume 00:05:00
    • Getting Started with Freelancing 00:06:00
    • How to Become an Excel Freelancer 00:05:00
    • Top Freelance Websites 00:05:00
    • How to Get Your First Client 00:08:00
    • Personal Branding 00:07:00
    • Networking Do’s and Don’ts 00:04:00
    • Importance of Having a Website 00:04:00
    • Get Your Certificate & Transcript 00:00:00

Course Reviews

4.8

4.8
15 ratings
  • 5 stars13
  • 4 stars1
  • 3 stars1
  • 2 stars0
  • 1 stars0
  1. Samantha StevensMarch 20, 2022 at 10:45 pm

    Informative

    5

    Great course, learnt allot. 🙂

  2. Allan PoileMarch 18, 2022 at 4:02 pm

    Great Course

    5

    Great course, very well put together. Very easy to fit in round day to day life. Would Recommend.

  3. Agnieszka CzerniejewskaFebruary 9, 2022 at 3:42 pm

    Good

    5

    Really good quality

  4. Jennifer Hall-ManchesterDecember 27, 2021 at 5:08 pm

    Microsoft Excel Masterclass

    5

    I enjoyed doing this course because the tutor spoke calmly and clearly easy to follow instructions. The only problem I had was locating the work sheet that the tutor was working from and for you to do what he was doing. However it was an excellence course ,and there was great customer service backup to help when I had problems, locating the work sheet for this course. I sent an email/made a phone call and had help straight away. Nice to know that there’s help at hand when needed. Value for money course and I would recommend it to friends and family,

  5. Ateka BloochDecember 24, 2021 at 1:10 pm

    Very Helpful and Useful Course

    5

    This course was excellent for a beginner all the way to an expert level teaching you so many different aspects of the power of Excel

© 2024 Course Central | website design & Maintenance by: menulane

Setup Menus in Admin Panel