Microsoft Excel for Beginners Certificate
- Offered bySkill Academy
Microsoft Excel for Beginners Certificate at Skill Academy Overview
Duration | 15 hours |
Total fee | ₹8,181 |
Mode of learning | Online |
Difficulty level | Beginner |
Credential | Certificate |
Microsoft Excel for Beginners Certificate at Skill Academy Highlights
- Earn a certificate of completion
Microsoft Excel for Beginners Certificate at Skill Academy Course details
- Students will know:
- A basic overview of Excel
- Calculating sums, averages, and totals
- Counting cells
- Learning formulas, such as IF, COUNTIF, SUMIF, VLOOKUP, HLOOKUP, and AVERAGEIF
- Pivot tables
- Inserting, editing, and deleting comments
- Creating borders
- Wrapping text
- Merging cells
- Pasting, sorting, and converting columns to rows
- Creating graphs and charts
- Using the dictionary
- The course begins with explaining concepts, such as ‘What is a cell?’ and how to tell the difference between a column and a row
- The course continues by explaining basic Excel concepts such as how to create, copy, delete, and cut information from Excel cells
- Learner will also learn how to edit information that is put into a cell and how to insert and edit comments when using Excel
Microsoft Excel for Beginners Certificate at Skill Academy Curriculum
Module 1 : Introduction to Excel
Module 2 : Add
Module 3 : Multiply
Module 4 : Subtraction in Excel
Module 5 : Dividing
Module 6 : Sort
Module 7 : Percentage
Module 8 : Running Totals
Module 9 : Print
Module 10 : Paste Special
Module 11 : Merge
Module 12 : Filter
Module 13 : AVERAGE
Module 14 : AVERAGEIF
Module 15 : SUMIF Formula
Module 16 : IF Formula
Module 17 : VLOOKUP
Module 18 : HLOOKUP
Module 19 : COUNTIF Formula
Module 20 : COUNTBLANK
Module 21 : COUNTA Formula
Module 22 : COUNT Formula
Module 23 : CONCATENATE
Module 24 : TRANSPOSE
Module 25 : DATE Formula
Module 26 : MONTH Formula
Module 27 : Pivot Tables
Module 28 : Pie Charts
Module 29 : Doughnut Charts
Module 30 : Line Charts
Module 31 : Column Charts
Module 32 : Bar Charts
Module 33 : Number Formatting
Module 34 : Create Borders
Module 35 : Conditional Formatting
Module 36: Comments
Other courses offered by Skill Academy
Student Forum
Anything you would want to ask experts?