Microsoft Excel – Beginner

Categories: Computer Applications

Wishlist

Course Content

1. Excel Basics

1. File Menu
11:03
2. Home
09:36
3. Font
12:24
4. Styles
02:57
5. Conditional Formatting
06:58
6. Cells
11:30
7. Inserting Images
02:02
8. Smart Art
07:11

2. Pivot Table

3. Formulae

4. Lookups

5. Advanced Formulae

6. Data Functions

7. View Menu

8. Income Tax Calculation in Excel

Student Ratings & Reviews

No Review Yet

Course Content

1. Excel Basics

1. File Menu

2. Home

3. Font

4. Styles

5. Conditional Formatting

6. Cells

7. Inserting Images

8. Smart Art

2. Pivot Table

1. Pivot Tables Intro

2. PT Custom options

3. Pivot chart Custom Options

4. PC Column charts Intro

5. PC Pie Doughnut and Lines chart

6. PT Change source

3. Formulae

1. Autosum

2. Date and Time

3. If and If error

4. Multiple IFS

4. Lookups

1. V Lookup

2. H Lookup

3. Limitations of Vlookup and Hlookup

4. Vlookup Practice

5. Index and Match

5. Advanced Formulae

1. Right, Left, Mid and Length

2. Sub Totals

3. Text Cases

4. Trim and Concatenate

5. Round and Ceiling

6. And OR Conditions

7. HyperLinks

6. Data Functions

1. Import Data

2. Remove duplicates

3. Data Validation

4. Scenario Manager

5. Data Table

7. View Menu

1. View Menu

8. Income Tax Calculation in Excel

1. Intro to Tax Calculation

2. Income Tax Solution

Student Ratings & Reviews