Course Description
This basic Excel training course will give you knowledge of Excel and the ability to use this software to do elementary calculations, file manipulation, data manipulation, to create charts, pivot tables and templates.
Learning Objectives
By the end of this course, students should be able to:
Enter data in Excel sheet
Manipulate data using formulas, functions and logical operations
Save files in different formats and create templates
Use different data types and create custom data types
Use names in Excel
Hide cells and sheets and protect them
Sort, filter, group data and do various data manipulation and consolidation
Format cells and use styles
Insert different objects in Excel sheet
Use pivot tables and charts
Print their worksheets in desired format