LEVEL 2: Microsoft Excel (Intermediate) (2 days)

Objectives

The Level 2: Microsoft Excel (Intermediate) program aims to provide participants with an in-depth understanding of intermediate Excel functionalities. The primary objectives include advancing participants’ proficiency in data analysis, enhancing spreadsheet management skills, and introducing them to more complex features of Microsoft Excel. Emphasis is placed on practical application, enabling participants to use Excel as a powerful tool for data manipulation, analysis, and visualization in professional settings.

Target Audience

This training is designed for individuals with a basic understanding of Microsoft Excel or those who have completed a beginner-level course. It caters to professionals, analysts, managers, and anyone looking to elevate their Excel skills to an intermediate level. The program is suitable for participants at various career stages, providing valuable insights and hands-on experience to enhance their spreadsheet capabilities.

Learning Outcomes 

• Acquire advanced skills in data organization, analysis, and visualization.
• Learn to manage larger datasets and create dynamic reports.
• Utilize Excel’s powerful features for enhanced productivity.
• Empower participants to leverage Excel as a strategic tool for decision-making and data-driven insights in professional roles.
  

Course Outlines:

Day 1:

Module 1: Introduction to Excel 2016 Interface

• Starting Excel
• The Excel Interface
• Changing Excel’s View
• Working with Existing Workbook

Module 2: Working with Microsoft Excel 2016

• Creating Workbooks
• Saving Workbooks
• Input Basic Data
• Using Data Types
• Cutting, Copying and Pasting Data
• Editing Workbook’s Properties

Module 3: Using Basic Formulas

• Building Basic Formulas
• Using Cell References
• Using Cell Ranges

Module 4: Formatting Cells and Ranges

• Inserting and Deleting Cells
• Manually Formatting Cell Contents
• Using Format Painter
• Paste Special Options
• Formatting Cells with Styles
• Hyperlink Data

Day 2:

Module 5: Formatting Worksheets

• Working with Rows and Columns
• Using Themes
• Modifying Worksheet’s Appearance
• Inserting Headers and Footers

Module 6: Adding Pictures and Shapes to a Worksheet

• Inserting Pictures
• Adding Shapes and WordArt
• Deleting, Copying and Moving Graphics
• Formatting Graphics
• Using SmartArt Graphics

Module 7: Printing Worksheets

• Preparing a Document for Printing
• Printing with Backstage

Join Today!