Advance Excel

Rs. 430.00

Colour: White

Description :

1. Introduction to MS-Excel

Microsoft Excel
Why Should I Learn Microsoft Excel?
Basic Terms in Excel
Microsoft Excel Window Components

2. Data Formatting

Format Column Headings and Totals
Bold Format
Data alignment
Wrap Text
Merge & Center
Borders
Autosum
Quick Insert

3. Basic Excel Formulas

Insert Data into Excel
Simple insertion
SUM
AVERAGE
COUNT
COUNTA
IF
TRIM
MAX & MIN

4. List Sort & Filter

Create a Custom List of Items in Excel
Import a List of Items From Cells
Use Your Custom List
Edit or Delete a Custom List
Create Custom Lists in Excel
Quick sort
Multi-Level Sorting
Custom Sort Order
SUBTOTAL Function
Advanced filter
Filter Data From One Worksheet To Another Excel

5. Bill Invoice Creation

Search and Select an Invoice Template
Edit and Customize the Excel Invoice Template
GST Bill Calculation
What is GST?
Page Layout and Printing

6. Lookups & Function

LOOKUP Function
VLOOKUP function
HLOOKUP function
Nested lookups

7. Advanced & Logical Function

Logical Functions
Cell reference
Income tax calculation

8. Forms & Data

Data Validation
Developer tab
Merge Sheets Remove Duplicates

9. Protection Workbook

Protect a workbook
Record and Run Macro

Assignments

Assignment 1: Basic Spreadsheet Skills

Assignment 2: Arithmetic Formulas

Assignment 3: Basic Formulas and Functions

Assignment 4: Percentage Calculations

Assignment 5: Date Calculations

Assignment 6: Basic Data Sorting

Assignment 7: Data Sorting and Filtering

Assignment 8: Advanced Data Sorting

Assignment 9: Data Filtering

Assignment 10 : Create a Bill Invoice

Assignment 11 : Lookup and Function

Assignment 12: VLOOKUP function

Assignment 13: HLOOKUP Function

Assignment 14: Nested Lookup Function

Assignment 15: Logical Function

Assignment 16: Advanced Logical Function

Assignment 17: Income Tax Calculation

Assignment 18: GST Bill Calculation

Assignment 19: Data Validation

Assignment 20: Protecting a Worksheet

Assignment 21: Analyzing Sales Data and Creating Dynamic Dashboards

Assignment 22: Building a Financial Model for Investment Analysis

Assignment 23: Analyzing Marketing Campaign Performance and Creating Visualizations

Assignment 24: Optimizing Inventory Control and Analysis

Assignment 25: Personal Budgeting and Expense Analysis

Advance Excel

Colour: White

Description :

CONTENTS

Assignments

CONTENTS

Assignments

About

My Account

Follow Us

Download Apps

You have not login now!

Advance Excel

Colour: White

Share product:

Description :

CONTENTS

Assignments

CONTENTS

Assignments

Related products

Offer Description