Overview
-
Learn Excel Formulas And Functions, Pivot Table, Excel Tools , Charts
What you'll learn:- Master all the basics of excel even if you have never seen a spreadsheet.
- Access to a professional from industry with 7+ years of experience as a DATA ANALYST / MIS ANALYST
- Build your own spreadsheet from scratch and actually understand how they work
- Learn the most important excel formula and functions used in the office
- Build solid foundation for advance excel learning
- All Basic Formulas, Pivot table , Chart , Conditional Formatting ,Sorting and Filtering
This Course Is Design For Some One Having Zero OR Some knowledge About Excel.
This course will give you Strong foundation in excel
This is MUST DO course before learning advance excel
What Student Will Learn:
CELL REFERENCING WITH BEST PRACTICE FOR CREATING STRONG FORMULA WRITING SKILLS.
FORMULAS 1: ARITHMETIC OPERATORS , SUM, AVERAGE, COUNT etc.
TEXT SERIES FORMULAS: CONCATENATE ,UPPER, LOWER, PROPER, LEFT, RIGHT, TRIM, EXACT etc.
DATE & TIME SERIES FORMULAS : TODAY,NOW,DAY,MONTH,YEAR,HOUR etc.
IMPORTANT TOOLS IN EXCEL: FILTER, SORT, FREEZE,REMOVE DUPLICATES, CONDITIONAL FORMATTING.
PIVOTE TABLE.
CHARTS.
