Ms Excel
Introduction
Microsoft Excel is one of the most popular tools for managing, analyzing, and reporting data. Whether you are organizing simple lists or handling complex data sets, Excel provides powerful features to simplify your work. This course is tailored for beginners with little or no prior experience, focusing on the basic skills you need to get started with Excel.
In this course, you will learn key concepts and techniques, including:
- What is MS Excel?
- Why is Excel important in the corporate world?
- How to easily learn and navigate Excel
- Understanding Workbooks, Worksheets, Cells, Ribbons, Rows, Columns, and Tabs
- Entering and formatting data (Font, Borders, Colors, Alignment)
- Using tools like Format Painter and essential keyboard shortcuts
- Sorting and filtering data
- Using functions like NOW, LEN, SUM, AVERAGE, MIN, MAX, COUNT, COUNTA
- Working with CONCATENATE, VLOOKUP, and Pivot Tables
By the end of this course, you will be able to create and manage basic spreadsheets with ease. Whether you are a student, professional, or simply looking to boost your productivity, this course will give you a solid foundation in Excel and prepare you for more advanced skills.
Course Description
Course Captain: Irshad Banu - irshad@desicrew.in
🕕Course Duration: 3 Hours
👍Learning Outcome
Basic Excel Formulas and Pivot Table
Course Curriculum
- Introduction to ExcelPreview
- Key Components of Ms Excel
- Font
- Border
- Color and Shading
- Alignment
- Format Painter
- Keyboard Shortcuts
- Data Sorting
- Data Filtering
- NOW Function
- LEN Function
- MIN Function
- MAX Function
- COUNT Function
- COUNTA Function
- SUM Function
- AVERAGE Function
- CONCATENATE Function
- VLOOKUP Function
- Pivot Table
Course includes:
-
Level
101
-
Duration 01:14:00
-
Lessons
21
-
Certifications
Yes
-
Enrolled
0
-
Available seats
0
