Microsoft Excel - Beginners to Advanced Level
Learn MS Excel from Beginners, Intermediates to Advanced Level
Office Productivity,Microsoft,Excel
Lectures -22
Resources -3
Duration -3.5 hours
Lifetime Access
Lifetime Access
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
Excel is in high demand in most of the organizations. This is a robust tool for your Data Analysis and for carrying out day-to-day business.
So, Let's Learn Excel with Fun!
You will find this course engaging and interesting. This course covers all the features of Excel that you need to know as a Beginner to Advanced level. I have also covered Important Formulas and Functions of the Excel category and you will also have challenging practice files with each chapter.
While covering the topic of each chapter, I have also shared tips and shortcuts to improve your productivity and efficiency in MS Excel.
I will also share with you PDF files of the "Top 10 Excel Tips and Tricks", "Top 45 Excel Functions" and "Excel Shortcut Keys" printable versions.
At the end of this course, you will be able to:
Input data and navigate through large spreadsheets
Excel Tips to get your work done faster
Able to choose the right Excel formula for data analysis
Use Excel features to transform your raw data into meaningful reports
Organize and manage data
Create interesting reports and impress everyone working with you
Excel Tables, Sorting, Filtering, Conditional Formatting, Pivot Tables, Data Validation, Excel protection and many more...
Enroll in this course now and let's learn Excel together. See you inside. :-)
Happy Learning!
Goals
Microsoft Excel Introduction, Complete Layout, Terminologies and Data Input.
Data Entry (Editing and Formatting).
Excel Cells, Ranges and Managing Worksheets.
Excel Tables with all its features
Excel Formula / Functions Basics.
Date and Time, Math, Logical, Lookup and Reference, Statistics and Text Formulas.
Data Sorting and Filtering.
Conditional Formatting (With very interesting features).
Pivot Tables (I call it Excel Superhero).
Excel Charts Basics (Data Visualization).
Data Validation Techniques.
Protect Your Excel (Workbook, worksheet, cells and Ranges).
Additional Content: Excel Shortcut Keys (To Improve Your Productivity).
FREE (PDF files): Excel Tips & Tricks, Top 45 Excel Functions, Top 50 Excel Shortcut Keys.
ALL the Chapters have MS Excel Practice Files.
Prerequisites
This course is demonstrated in Excel 2013, Students can use other versions also like 2010, 2016 and 2019.
Curriculum
Check out the detailed breakdown of what’s inside the course
Microsoft Excel Basics
6 Lectures
- Welcome to the Course 01:17 01:17
- Introduction to Excel 12:49 12:49
- Data Entry (Editing and Formatting) 07:37 07:37
- Working with Excel Cells and Ranges 14:28 14:28
- Managing Worksheets 12:19 12:19
- Excel Tables 08:55 08:55
Excel Formulas and Functions
8 Lectures
Excel Advanced Features
6 Lectures
Additional Content - Just for You
2 Lectures
Instructor Details
Namita Devi
Course Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
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