MS Excel Course

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

    Please fill this form to send your query and we will get back to you soon



    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