Microsoft Excel Training Course
Training Duration
12 Training Hours
Course Overview
Microsoft Excel Training Course enables the participant to organize data and perform operations on it for giving visualization effect and deriving results. This training delivers the knowledge and skills to input data and organize in order to facilitate decision making and further reference. The participants learn MS-Excel and easily perform tasks such as how to apply functions, build charts, create dynamic worksheets by using PivotTables, automate tasks using macros, and collaborate on worksheets and workbooks.
Other than Microsoft Excel Training Course , there is :
Microsoft Excel Advance ( MOS Excel Expert ) Training Course and
Microsoft Word Training Course
Microsoft Access Training Course
Microsoft Outlook Training Course
are also the most popular courses under the Computer and IT domain.
Target Audience
- Accountant
- Projects Planners
- there is basics level for General employees
Course Contents
Detailed Course TopicsBy going through this training, the candidates will exhibit the following capabilities:
- Create workbook with multiple worksheets and modify their content.
- Customize Ribbon and Quick Access Toolbar.
- Move data within a workbook.
- Find and Replace data.
- Define Excel table and apply themes to table and workbook.
- Add images, charts, header and footer to worksheets and print them.
- Create formulas and use available functions to calculate data.
- Manipulate data and organize into levels.
- Group multiple sets of data and define alternative data sets.
- Use Goal Seek to get a desired result, Solver to get optimal solutions, and descriptive statistics to analyze data.
- Use Pivot Tables to analyze data dynamically.
- Use Sparklines, Pivot Charts and SmartArt.
- Use macros to automate repetitive tasks.
- Track and protect the workbooks and worksheets.