Certified Intermediate Excel Specialist (CIES)

Certified Intermediate Excel Specialist (CIES) Certification Course by Tonex

This intermediate-level Excel training course is designed for professionals who want to enhance their proficiency in Excel through practical skills and advanced features. Participants will learn to use Excel functions, create custom templates, manage data with filters and sorting, and apply various techniques to streamline their workflow and improve data management.

Course Duration: 1 Day (Online)

Course Objectives:

• Utilize intermediate Excel functions to enhance data analysis
• Create and manage custom templates and styles
• Effectively use linking and referencing techniques
• Protect and manage data within Excel sheets
• Implement sorting, filtering, and hyperlinking for efficient data handling

Target Audience: Business professionals, data analysts, administrative staff, and others who need to manage and analyze data using Excel at an intermediate level.

Course Content:

1. Using Excel Functions
   • Intermediate functions: COUNTIF, SUMIF, AVERAGEIF
   • Logical functions: IF, AND, OR, NOT
   • Text functions: CONCATENATE, LEFT, RIGHT, MID
   • Date and time functions: DATE, TIME, NETWORKDAYS
2. Creating Custom Templates
   • Designing and saving custom templates
   • Using templates for consistent formatting and data entry
   • Customizing and managing template options
3. Using Styles
   • Applying and modifying cell styles
   • Creating and using custom styles
   • Managing style sets for consistency
4. Linking Formulas
   • Creating and managing links between worksheets and workbooks
   • Using 3-D references for data across multiple sheets
   • Absolute vs. relative references
5. AutoFill and 3-D References
   • Using AutoFill to quickly populate data
   • Working with series, custom lists, and patterns
   • Implementing 3-D references for cross-sheet calculations
6. Protecting Sheets
   • Setting up sheet protection to prevent unauthorized changes
   • Managing protected ranges and cells
   • Creating and managing passwords for sheet protection
7. Filtering and Sorting
   • Applying and managing filters for data analysis
   • Using advanced filter options and criteria
   • Sorting data by multiple criteria and custom lists
8. Hyperlinks
   • Inserting and managing hyperlinks within Excel
   • Linking to other sheets, documents, and web pages
   • Creating hyperlink navigation for easier data access

Exam Domains:

1. Using Excel Functions
   • Intermediate and logical functions
   • Text and date/time functions
2. Creating Custom Templates
   • Designing and managing templates
   • Applying and customizing styles
3. Using Styles
   • Cell and custom styles
   • Style set management
4. Linking Formulas
   • Linking between worksheets and workbooks
   • Understanding absolute and relative references
5. AutoFill and 3-D References
   • Using AutoFill
   • Implementing and managing 3-D references
6. Protecting Sheets
   • Sheet protection setup
   • Managing protected ranges and passwords
7. Filtering and Sorting
   • Applying and managing filters
   • Sorting data by multiple criteria
8. Hyperlinks
   • Inserting and managing hyperlinks
   • Linking to various destinations

Question Types:

• Multiple Choice Questions (MCQs): Assessing knowledge of Excel functions, styles, and data management techniques.
• True/False Questions: Evaluating understanding of Excel features and functionality.
• Practical Exercises: Applying intermediate Excel functions, creating templates, and managing data.
• Scenario-Based Questions: Solving real-world data problems using Excel features.
• Hands-On Tasks: Creating and formatting worksheets, applying styles, and setting up protection.

Certification: Participants who successfully complete the course and pass the examination will receive the Certified Intermediate Excel Specialist (CIES) certification.