Microsoft Excel in 4 hours (In HINDI Language)
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
Requirements
- 1 PC/LAPTOP WITH EXCEL INSTALL ON IT AND A STRONG WILL TO LEARN
Description
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.
Who this course is for:
- ANY ONE WHO WANTS TO LEARN EXCEL AND WANT TO DEVELOP STRONG FOUNDATION FOR ADVANCE EXCEL CONCEPT.
Instructor
More Than 7 Years Of Industry Experience With Leading MNC’s As MIS Executive / Data Analyst.
Having 7+ Years of experience into creation of Business Reports, Interactive Dashboards, Charts, Reports automation, and Data Analysis. By using Microsoft Technologies like POWER-BI, T-SQL (MS-SQL Server), Advance MS-Excel, Visual Basic for Application (VBA).
Love to write TECH Blogs / Tips