MS Excel has become one of the most essential skills which any company searches for. Jupiter Vidya has a great team who are proficient in their core areas.
Course Duration: 20 hours | Mode: Online | Timing: Flexible (Weekdays & Weekends)
What Will I Learn?
Lookup functions, Pivot table, Conditional statements, Charts, etc.
How to analyze data
How to generate reports
Most important Excel formulas
How to design common templates
Important shortcuts and time-saving tools
Who Can Take This Course
Data Analyst
Managers
Bankers
Students
Any office employee
Job aspirants
MS Excel Course Enquiry
MS Excel Course Description
MS Excel is a modified and fast-paced tool which makes day to day tasks easier. Jupiter Vidya provides you complete end to end training which makes you perfect in learning as well as using IF Statements, calculations, charts grouping and outlining data, short cut keys and much more g and many more of such functions. MS Excel is has become one of the most essential skills which any company searches for. Jupiter Vidya has a great team who are proficient in their core areas.
MS Excel Course Curriculum
- Introduction to MS Excel
- Use of MS Excel
- Different Templates
- Sheets in Excel
- Cell in Excel
- Different paste option in Excel
- Merge text with different options
- Conditional formatting
- Table format
- DifferentCell style
- Insert Cell, Sheet, Row, Column
- Delete Cell, Sheet, Row, Column
- Adjusting height and width of cell
- Clear formatting
- Sort and filter
- Find and replace
- Insert Pivot table
- Recommended Pivot tables
- Table in Excel
- Insert pictures and picture tool
- Insert shapes and SmartArt
- Different charts
- Win/Loss
- Slicer
- Hyperlinks
- Text box
- Header and Footer
- Themes, Margin, Size
- Print Area
- Background
- Print Titles
- Gridlines and Headlines
- Arrangement of Objects
- Sum, Average, Count, Max, Min Formulas
- Logical Formulas
- Different Text Formulas
- Maths and Trigonometry
- Lookup and references
- Date and Time
- Information
- Define names
- Trace Precedents
- Evaluate Formulas
- Calculation options
- Fetch data from The Web
- Text to Columns
- Remove duplicates
- Data validation
- Consolidate
- Group and Ungroup
- Solver
- Spelling checker
- Comments
- Formula bar
- Freeze Panes
- Macros
Course Features
Flexible Timing
A student can opt for any time. Our class timing is very flexible
Support
We provide support to help you even after the course is completed.
Lab Facility
Every student will get a laptop for practice. A student can practice even after the class is over.
Evaluation
Regular assignment and test to check your knowledge.
Placement Assistance
We are associated with companies for the placements.
Certification
After successful completion of the MS Excel course, you'll get a certificate.
Study Material
Study material in form of PDF and examples will be provided to the student.
Real-Time Projects
Real-time work on the basis of the skill