Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
16 Hour(s) 53 Minute(s)
Language
English
Taught by
Vnnergy LLC
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
Course Overview
Summer 2023 Revision | FREE PDF Certificate | Accredited 25 CPD Hours | Lifetime Access
Excel is the most in commonly used and in-demand tool for making sense of data. When you can harness that power, you will be a sought after employee and YOU CAN EARN MORE MONEY!.
If you run a business, being proficient in Excel can help you see your business in a completely different light.
Congratulations!
If you are reading this, you have already taken your first important step. You want to learn Excel from the ground up, and go from a complete beginner, to a super user, to being part of the few Excel Elite, and being able to program your very own full blown applications.
This complete course contains all the lectures, quizzes, projects, and downloadable resources. In fact, everything you will need to go from novice to coder! There's no need to buy one course after another to become an Excel master...it's all here!
Enroll now to go through a deep dive of the most popular spreadsheet tool on the market, Microsoft Excel. As your instructor, I will use my 15+ years of Excel training to guide you step by step through the beginner to advanced level and beyond.
As you participate in the course 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 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
So, what are you waiting for, enroll now and take the next step in mastering Excel and go from Excel Newbie to Excel Guru!
Course Content
- 17 section(s)
- 122 lecture(s)
- Section 1 Introduction
- Section 2 Excel Basic Skills
- Section 3 Creating Your First Excel Spreadsheet
- Section 4 Introduction to Excel Formulas and Functions
- Section 5 Named Ranges
- Section 6 Formatting Numbers, Cells and Worksheets
- Section 7 Working with Excel Lists
- Section 8 Moving and Linking to Data
- Section 9 Useful Functions
- Section 10 Analyzing Data with Charts
- Section 11 Sorting and Filtering Data
- Section 12 Conditional Formatting
- Section 13 Inserting Items into a Spreadsheet
- Section 14 Working with Views and Zoom
- Section 15 Page Layout and Printing Options
- Section 16 Finalizing your Spreadsheet
- Section 17 Course Close
What You’ll Learn
- This Excel course is created on latest version Office 365 however it covers all functions of Excel 2013, 2016 and 2019.
- Access to a Professional Trainer with 15+ years of Excel Training experience.
- Gain a comprehensive understanding of MS Excel best practices.
- Apply your knowledge post every module with exercises.
- Managing large sets of data
- Creating effective spreadsheets
- Mastering the use of some of Excel's most popular and highly sought-after functions (SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH and many more...)
- Format and make your data more presentable
- Audit Excel Worksheet formulas to ensure clean formulas
- Use Charts and Tables - make your reports and dashboard visually appealing
Skills covered in this course
Reviews
-
RRamiza Jannif
Really good content.
-
BBrian Macri
Great overall introduction to Excel. I stared using some of the concepts learned in my current job right away. I now have much more confidence creating useful tools in Excel.
-
MMelia Pitts
Course material is very comprehensive, but most if not every single exercise given to download and complete is already completed. In order for me to practice what I learn, I need to figure out how to 'undo' all the correct answers and formatting, then go back and re do them due to the worksheets being completed already. This is frustrating as someone who learns best by doing, and the instructions are geared to completing the exercises rather than un-finishing them....I am going to need to find other sources for 'homework' to ensure I understand how to do what I am learning here.
-
BBikram Rana Tharu
Refreshed many basic essential skills, the host is amazing to explain bits and pieces.
