With the huge amount of data that must be handled and analyzed every day, it is imperative that you learn how to use a flexible tool to handle equations and statistics professionally, and Microsoft Excel is the most popular tool for doing so. This training program is designed to provide participants with the knowledge and skills needed to organize, analyze and present data, by learning how to perform calculations, use functions, and manage workbooks efficiently and effectively.
At the end of the training program, the participant should be able to:
1 Navigate the Excel User Interface
2 Create and Save a Basic Workbook
3 Enter Cell Data
4 Use Excel Help
1 Create Worksheet Formulas
2 Insert Functions
3 Reuse Formulas and Functions
1 Organize Worksheets
2 Manage Workbook and Worksheet Views
3 Manage Workbook Properties
1 Insert, Delete, and Adjust Cells.
2 Insert, Delete, and Adjust Columns and Rows.
3 Search for and Replace Data.
4 Use Proofing and Research Tools
1 Text Formats
2 Number Formats
3 Align Cell Contents
4 Apply Styles and Themes
5 Apply Basic Conditional Formatting
6 Create and Use Templates
1 Preview and Print a Workbook
2 Set Up the Page Layout
3 Configure Header and Footer
Not Available
Names of the training programs that are integrated (enriched) with the training program:
Names of the training programs that after the training program:
virginia Institute of Finance
Add Comment