Microsoft Excel: Beginner To Expert Course
Master pivot tables, formulas, macros, vba, data analysis and learn how to land your first job as an Excel expert!
Office Productivity,Microsoft,Excel
Lectures -155
Resources -1
Duration -13 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
Welcome to the Learn Microsoft Excel from A-Z: Beginner To Expert Course
In this practical, hands-on course our main objective is to give you the education not just to understand the ins and outs of Microsoft Excel, but also to learn exactly how to master pivot tables, formulas, macros, vba, data analysis, and how to land your first job as an Excel expert!
This course will fully prepare you for virtually any Excel related career path, including those that require advanced skills with this software. Once you complete the course, you’ll have access to the full functionality of Excel, and will know how to use all formulas, functions, and capabilities.
You’ll also learn about calculating depreciation, calculating interest, and even calculating EMI for loans, all by using Excel functions. The course also features information on INDEX and MATCH functions as well as using the CHOOSE formula, and how to create special charts.
Whether you are brand new to the world of Excel, or you have training and knowledge of the software and are looking to improve your skills, this masterclass will take you to the next level. By the time you finish the beginner, intermediate and advanced portions, you too will be an expert in Excel.
We understand that theory is important to build a solid foundation, we understand that theory alone isn’t going to get the job done so that’s why this course is packed with practical hands-on examples that you can follow step by step. Even if you already have some experience, or want to learn about the advanced features of Excel, this course is for you!
Together we’re going to give you the foundational education that you need to know not just on how to use Excel at an expert level, but also how to get paid for your newly developed skills.
The course covers 4 main areas:
1: INTRO TO EXCEL
This intro section gives you a full introduction to 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 full 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 gives you a full introduction to the 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 full 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.
Who this course is for:
- Students who want to learn and master microsoft excel
Goals
- Learn to master Excel from A-Z
- How to become a professional Data Analyst
- How to be a better, faster, stronger Excel user
- How to land your first job as an Excel Expert
- How to save hours of time 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
Prerequisites
- basic computer skills
![Microsoft Excel: Beginner To Expert Course Microsoft Excel: Beginner To Expert Course](https://d3mxt5v3yxgcsr.cloudfront.net/courses/5074/course_5074_image.jpg)
Curriculum
Check out the detailed breakdown of what’s inside the course
Excel from A-Z Course Introduction
6 Lectures
-
Excel from A-Z Course Section Overview 03:20 03:20
-
What is Microsoft Excel? 04:16 04:16
-
Who This Course is For 03:30 03:30
-
Microsoft Excel Marketplace 04:08 04:08
-
Microsoft Excel Job Opportunities 02:43 02:43
-
Microsoft Excel Job Types 03:51 03:51
Getting Started with Excel
9 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Values, Referencing and Formulas
6 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Intro to Excel Functions
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Adjusting Excel Worksheets
8 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Visually Pleasing Cell Formatting
7 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
How to Insert Images and Shapes!
3 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Visualize Data with Charts
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Excel's Printing Options
4 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Benefits of Using Excel Templates
2 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Working with Excel Datasets
8 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Excel Database Functions
4 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Excel Data Validation
6 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Excel PivotTables
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Excel's PowerPivot Add-In
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Excel's Conditional Functions
6 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Excel's Lookup Functions
7 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Text Based Functions in Excel
4 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Auditing Formulas & Custom Views in Excel
6 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Excel’s “What If?” Tools
4 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Welcome to Excel VBA!
4 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
The VBA Language
3 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Excel VBA Variables
7 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Important VBA Tools and Logic
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Excel VBA Loops
3 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Triggering Macros
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Excel User Forms
9 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Starting a Career in Excel
9 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Instructor Details
![Juan Galvan](https://www.tutorialspoint.com/assets/profiles/204006/profile/200_167918-1607788661.jpg)
Juan Galvan
Hi I'm Juan. I've been an Entrepreneur since grade school. My background is in the tech space from Digital Marketing, E-commerce, Web Development to Programming. I believe in continuous education with the best of a University Degree without all the downsides of burdensome costs and inefficient methods. I look forward to helping you expand your skillsets.
Course Certificate
Use your certificate to make a career change or to advance in your current career.
![sample Tutorialspoint certificate](/market/public/assets/newDesign/img/primePacks/V-certificate.png)
Our students work
with the Best
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfc bank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfcbank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now![Annual Membership Annual Membership](/market/public/assets/newDesign/img/membership-large-small.jpg)
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now![Online Certifications Online Certifications](/market/public/assets/newDesign/img/traning-for-a-team.png)