Microsoft Excel - Beginners to Advanced Level
Learn MS Excel from Beginners, Intermediates to Advanced Level
Updated on Apr, 2024
Language - English
Lectures -22
Resources -3
Duration -3.5 hours
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 of your Data Analysis and to carry 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 Excel category wise and you will also have challenging practice files with each chapter.
With covering the topic of each chapter, I have also shared the tips and shortcuts to improve your productivity and efficiency in MS Excel.
I will also share with you PDF files of "Top 10 Excel Tips and Tricks", "Top 45 Excel Functions" and "Excel Shortcut Keys" printable version.
By 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!
Thanks & Regards,
Namita Devi
Goals
What will you learn in this course:
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
What are the prerequisites for this course?
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
Thank You for reading about me.
My name is Namita Devi and I am a working professional having experience in different industry types (specially Data Analysis).
I love Excel and I enjoy learning new challenges everyday. My reason of joining TutorialsPoint is to share my skill, my knowledge, my learnings and my experience in Excel with all of you. I believe in learning with Fun, so let's learn "Excel with Fun with Me"
I will help you create tools and reports in Excel through my courses. You will find them engaging, interesting and challenging. My courses are for those who want to stand out from the crowd, accelerate the career and achieve more in less time.
I also run a website and an active YouTube channel to create unique and engaging videos on MS Excel.
I welcome you to all my courses. Thank you.
Happy Learning!
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 now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now