Course Features

  • Lectures 0
  • Quizzes 0
  • Duration 16 hour
  • Skill level Advanced
  • Language English, Hindi, Marathi
  • Students 1120
  • Assessments Yes

Categorires

0 Review
1120 students

MS Excel allows to organize, manipulate, analyse and manage data which in turn helps in decision making. It increases efficiency and effectiveness in the work.

Duration: 16 hours

We customize the course duration and syllabus as per the organisation’s requirement

Why Excel? MS Excel allows to organize, manipulate, analyse and manage data which in turn helps in decision making. It increases efficiency and effectiveness in the work. Excel helps in creating powerful visual aids like charts, tables. Excel helps in generating useful reports. Who should know Excel? Anyone and everyone-Bankers, Accountants, Teachers, Business Owners, Students, HR people, Marketing and Sales personnel etc. One should know Excel not just to generate reports or to work on Excel, but also to understand capabilities of this tool and understand the information given by Excel. People who are looking for job change (Excel is a functional tool required for all departments), people who want to start their career afresh (Excel provides solid foundation in analysis, reporting tool), people who are already working on Excel can attend this workshop to polish their skills.

Course contents

Day 1:

  • Organizing beyond simple formats- Conditional formatting
    • Do formatting based on the values, color code the values as per requirement
  • Advanced chart techniques
    • Make chart templates, use trend lines on the charts
  • Using advanced and powerful Functions
    • Use logical functions to work on conditions, use text functions to do mathematical calculations, use statistical functions to perform statistical analysis.
  • Sorting Data- Simple and custom sorting
    • Put data in organized manner before you generate reports, use simple to advanced sorting features

Day 2:

  • Using Subtotals to generate report
    • Finding sum, average for different groups, generating reports for specific part of the data can be done using subtotals
  • Tracking invalid entries using Data Validation
    • Invalid data in the report makes the report unusable, to keep a track of unacceptable values, audit feature of Excel is used.
  • Make reporting easy by using Filters – Auto and advanced filter
    • The essence of Excel is to be able to generate reports, filtering features help us to generate report for the required criteria.
  • Create, manage and format PivotTables
    • This is the most powerful feature in Excel. It allows us to organize and summarize data.
  • Working with Dashboards
    • Dashboards provide quick, visual way to updates for the work.
  • New features of Excel- Slicer, Sparklines
    • These are the new features of Excel.
Curriculum is empty

User Avatar

Mrs. Harshal V. is an avid blogger and reader. She has vast experience (15+ years) of training in the field of IT and soft skills. Harshal owns an institute HV Training in Pune. HV could be “High Voltage” but here it stands for “Harshal Varkhedkar”. HV Training is a brainchild of Harshal. (BE, MBA, Six Sigma Green Belt, Certified Digital Marketer, PMP, Prince 2, Microsoft Office Specialist, NLP Practitioner).Empower yourself: Don’t wait around, TAKE ACTION!! Take responsibilities for your own improvements! Set the right kind of goals!! We bridge the gap between the skills required for doing a job and the skills that you currently possess. Learn the skills that will increase your efficiency and effectiveness.We provide effective training/ workshops for MS Excel, MS Word, MS PowerPoint, MS Project, PMP, Presentation skills, Public speaking skills, Leadership etc. HV Training (IT, Project Management and soft skills training) carries 15+ years of experience. The main focus of our training is to empower you.

0.00 average based on 0 ratings

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%

Enquire Now