NICE COURSE
Excel - Microsoft Excel Beginner To Advanced
Learn Microsoft Excel From Beginner to Advanced and learn MS Excel Formulas & Charts in Excel 2019/2021/Office 365
Excel,Microsoft Office,Excel Formulas and Functions,Office Productivity,Microsoft
Lectures -25
Resources -25
Duration -5.5 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
Microsoft Excel is one of the most popular and widely used spreadsheet software programs in the world. It is used by people from all walks of life, from students and businesses to scientists and engineers.
This online video course will teach you everything you need to know about Excel, from the basics to advanced topics. You will learn about the different Excel data types, formulas, functions, and charts. You will also learn about more advanced Excel concepts, such as pivot tables, macros, and VBA.
Excel - Microsoft Excel Beginner To Advanced Course Overview
Excel - Microsoft Excel Beginner to Advanced course will help you learn the most important features of Excel focusing on data visualization and productivity. I'm using the version Microsoft Excel 2019 which is similar to Office 365 Excel, but the course is 90-95% compatible with MS Excel 2010, 2013, 2016, 2021, and 2022 versions.
If you're a beginner, in the first section you can learn Excel basics from scratch in 30 minutes.
Topics covered in the 30-min Getting Started With Excel lecture:
- Quick overview of the user interface
- How to save your Excel worksheet
- Drag & drop gesture
- Excel rows, columns, cells
- How to move between cells quickly
- Excel data entry
- Excel data types
- Excel formulas & references
- Excel operators
- How to select cells, ranges, columns, and rows in Excel
- Copy & paste data
- AutoComplete feature
- AutoFill feature
- What is function
- Define Name
- How to sort & filter your data in Excel
- How to create a simple chart with a few clicks
- Multiple worksheets
- Zoom function
Then we're going to go through several data visualization techniques that you can use to create Excel charts and impress your audience.
Projects covered:
- Highlight the max value dynamically on an Excel chart
- Discover Excel's conditional formatting feature to highlight key data in your table
- How to create a map chart that reads well by the viewer
- How to use icons in your bar charts to make it exciting
- How to create a progress chart in an infographic style
I dedicated an entire section to Excel shortcut keys showing you over 100 keyboard shortcuts. The more keyboard shortcuts you know the faster you can work in Excel and the more productive you can be.
Shortcuts covered in seven categories:
- General shortcuts
- Shortcuts for navigation
- Shortcuts for data entry
- Excel formatting shortcuts
- Selection shortcuts
- Shortcuts for formulas
- Miscellaneous shortcut keys
I created a section for the most frequently used Excel formulas/functions with lots of real-world examples in these topics:
- Relative vs. Absolute cell references explained
- working with date functions
- SUM(), SUMIF(), SUMIFS() functions
- MIN(), MAX(), AVERAGE(), COUNT() functions
- VLOOKUP(), HLOOKUP() functions examples
- INDEX(), MATCH(), XLOOKUP() functions to search data
We will discuss an advanced Excel topic in the final segment. I describe the operation of the PivotTable, one of Excel's most useful features. Many people are reluctant to utilize it, but I'll explain how to do it to you. We'll construct numerous reports as well as a PivotChart. I'll also discuss the fundamentals of database design. I will demonstrate how to utilize PivotTable with several tables after we develop a data model. Hence, Excel will function as a true database.
By taking this course you can really take your Excel skills to way above the average.
Don't worry if you're an absolute beginner. I'll explain everything step by step.
If you're already familiar with Excel, this course is a great refreshing session, and I'm pretty sure I will be able to show you new, interesting things.
Please watch the Intro video to see what you can expect from this course. Enjoy learning!
Goals
What will you learn in this course:
- Microsoft Excel - Excel From Beginner to Advanced 5.5-hour course
- Excel basics & advanced features
- Focusing on Data Visualization techniques you can stand out with
- Over 100 keyboard shortcuts to speed up your work
- Most frequently used Excel functions with examples
- PivotTable made easy
- Database design principles
- PivotTable advanced (Using Multiple Tables)
Prerequisites
What are the prerequisites for this course?
- The course was recorded with Microsoft Excel 2019 which is similar to Office 365 Excel version
- Most features work in Excel 2010/2013/2016 or I show you an alternative
- no previous Excel knowledge is necessary - you can even be an absolute beginner in Excel
Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction
4 Lectures
- Preview Video 02:53 02:53
- Get the Most Out of This Course 02:45 02:45
- How To Set The English Display Language 02:48 02:48
- Getting Started With Excel 30:22 30:22
Data Visualizations - Out of the Ordinary
5 Lectures
Over 100 Keyboard Shortcuts for Fast Productivity
7 Lectures
Most Frequently Used Excel Functions With Examples
6 Lectures
Understanstand the PivotTable
2 Lectures
Congratulations
1 Lectures
Instructor Details
Tamas Benko
I love to teach new skills to students.
Course Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Feedbacks
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 nowOnline Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now