Manorama Horizon is organising an online certification course on beginner-level MS Excel from December 10 to 12. The classes will be held from 8.00 pm to 9.30 pm. Following the completion of the course, candidates will receive an e-certificate. Students will also be given access to recorded classes, following registeration.
The registration fee for the course is Rs 700.
Areas to be covered
Day 1
• Introduction to Excel
» Basics of Excel – Data Entry, Cell References etc.
» Excel Ribbon – Familiarisation
» Worksheet Navigation and Copying – Copy and Move Worksheet, Copying and Pasting Data
» Hide and Unhide Columns and Rows
» Formatting Tips – Alignment, Borders etc.
» Conditional Formatting
» Data Cleaning and Management- Sorting, Filtering and Replacement, Deleting Rows and Removing Duplicates
Day 2
• Calculations in Excel - Formulas and Functions
• Combine Values From Two or More Cells to One Cell
• Data Visualisation – Charts
Day 3
• Data Analysis Using Excel- Pivot Table Creation, Basic Functions for Data Analysis, Descriptive Statistics
• Printing Excel Files and Saving as PDF
Eligibility
Candidates with basic computer proficiency.
Visit www.manoramahorizon.com to register