CoursesIntermediate Excel

CEC 503

Intermediate Excel

The Intermediate Excel course builds upon basic skills, covering more advanced features such as data analysis, advanced formulas, pivot tables, charts, and conditional formatting. It aims to enhance proficiency in data manipulation, visualization, and productivity within Microsoft Excel.

Talk to us

duration

30 null

NEXT BATCH

mode

payment options

Overview

Eligibility

Highlights

Job Roles

Syllabus

Certification

Batches

Admission

Testimonials

Financing

FAQ

Program Overview

Advance Excel skills with our Intermediate Excel course! Explore data analysis, pivot tables, dynamic charts. Essential for students, professionals, entrepreneurs. Join us to master Excel!

Enhanced data analysis skills for informed decision-making

Improved efficiency in report creation and data visualization

Increased job opportunities in roles requiring Excel proficiency

Streamlined workflows through automation of repetitive tasks

Eligiblility

Why should you learn?

Possible Job Roles

Salary Range

Course Modules

30 null COURSE

1 hour

Excel Introduction

The Date and Time Functions module covers essential Excel functions like Today, Now, Day, Month, Year, Date, DateIf, DateAdd, EOMonth, and Weekday for efficient temporal data management.

Overview of the screen, navigation, and basic spreadsheet concepts
20 M
Various selection techniques
20 M
Shortcut Keys
20 M

1 hour

Customizing Excel

The Customizing Excel module teaches participants to personalize Excel by customizing the Ribbon, using AutoCorrect, and adjusting default options.

Customizing the Ribbon
20 M
Using and Customizing AutoCorrect
20 M
Changing Excel’s Default Options
20 M

2 hours

Using Basic Functions

The Using Basic Functions module covers essential Excel functions such as Sum, Average, Max, Min, Count, and Counta, alongside referencing techniques like Absolute, Mixed, and Relative referencing.

Using Functions – Sum, Average, Max, Min, Count, Counta
1 H
Absolute, Mixed, and Relative Referencing
1 H

2 hours

Formatting and Proofing

The Formatting and Proofing module encompasses various Excel formatting techniques such as currency, dates, custom formats, and conditional formatting, ensuring participants master cell formatting for effective data presentation and analysis.

Currency Format
20 M
Format Painter
20 M
Formatting Dates
20 M
Custom and Special Formats
20 M
Formatting Cells with Number formats, Font formats, Alignment, Borders, etc
20 M
Basic conditional formatting
20 M

2 hours

Mathematical Functions

The Mathematical Functions module covers advanced Excel functions like SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF, AVERAGEIFS, nested IF, IFERROR, and logical functions (AND, OR, NOT) for complex calculations and logical operations.

SumIf, SumIfs CountIf, CountIfs AverageIf, AverageIfs, Nested IF, IFERROR Statement, AND, OR, NOT
2 H

1 hour

Protecting Excel

The Protecting Excel module teaches file-level protection and workbook/worksheet protection techniques, ensuring data integrity and confidentiality by preventing unauthorized access or modification within Excel workbooks and sheets.

File Level Protection
30 M
Workbook, Worksheet Protection
30 M

2 hours

Text Functions

The Text Functions module in Excel covers functions for altering text cases, extracting substrings, removing spaces, calculating lengths, comparing strings, combining text, finding positions, and substituting text segments.

Upper, Lower, Proper
20 M
Left, Mid, Right
20 M
Trim, Len, Exact
30 M
Concatenate
20 M
Find, Substitute
30 M

2 hours

Date and Time Functions

The Date and Time Functions module covers essential Excel functions like Today, Now, Day, Month, Year, Date, DateIf, DateAdd, EOMonth, and Weekday for efficient temporal data management.

Today, Now
30 M
Day, Month, Year
30 M
Date, Date if, DateAdd
30 M
EOMonth, Weekday
30 M

1 hour

Advanced Paste Special Techniques

The Advanced Paste Special Techniques module in Excel covers diverse ways to paste data, including formulas, formats, validations, and transposing tables, enhancing data manipulation efficiency.

Paste Formulas, Paste Formats
20 M
Paste Validations
20 M
Transpose Tables
20 M

2 hours

New in Excel 365 & 2016 / 2013

The "New in Excel 365 & 2016 / 2013" module introduces recent features enhancing data visualization, analysis, and usability in Excel.

New Charts – Tree map & Waterfall
10 M
Sunburst, Box and whisker Charts
10 M
Combo Charts – Secondary Axis
10 M
Adding Slicers Tool in Pivot & Tables
10 M
Using Power Map and Power View
10 M
Forecast Sheet
5 M
Sparklines -Line, Column & Win/ Loss
10 M
Using 3-D Map
5 M
New Controls in Pivot Table – Field, Items and Sets
10 M
Various Time Lines in Pivot Table
10 M
Auto complete a data range and list
10 M
Quick Analysis Tool
10 M
Smart Lookup and manage Store
10 M

1 hour

Printing Workbooks

The Printing Workbooks module covers essential aspects of printing in Excel, including setting print areas, customizing headers and footers, and utilizing print titles for efficient printing.

Setting Up Print Area
10 M
Customizing Headers & Footers
10 M
Designing the structure of a template
20 M
Print Titles –Repeat Rows / Columns
20 M

2 hours

What If Analysis

The What If Analysis module in Excel explores techniques for predictive modeling and decision-making, including Goal Seek, Scenario Analysis, Data Tables, and the Solver Tool.

Goal Seek
30 M
Scenario Analysis
30 M
Data Tables (PMT Function)
30 M
Solver Tool
30 M

2 hours

Logical Functions

The Logical Functions module in Excel covers IF function for conditional logic, IFERROR for error handling, nested IF statements, and logical operators (AND/OR) for complex conditions.

If Function
30 M
How to Fix Errors – if error
30 M
Nested If
30 M
Complex if and or functions
30 M

2 hours

Data Validation

The Data Validation module in Excel covers enforcing data accuracy and consistency with validation rules, custom validations, and dynamic dropdown lists.

Number, Date & Time Validation
30 M
Text and List Validation
30 M
Custom validations based on formula for a cell
30 M
Dynamic Dropdown List Creation using Data Validation – Dependency List
30 M

2 hours

Lookup Functions

The Lookup Functions module covers VLOOKUP, HLOOKUP, INDEX, MATCH, nested VLOOKUP, reverse lookup, linking worksheets, and VLOOKUP with helper columns..

Vlookup / HLookup
20 M
Index and Match
10 M
Creating Smooth User Interface Using Lookup
20 M
Nested VLookup
10 M
Reverse Lookup using Choose Function
20 M
Worksheet linking using Indirect
20 M
Vlookup with Helper Column
20 M

3 hours, 20 minutes

Pivot Tables

The Pivot Tables module covers creating and customizing pivot tables, basic and advanced value field settings, data filtering, and grouping.

Creating Simple Pivot Tables
20 M
Basic and Advanced Value Field Setting
20 M
Classic Pivot table
10 M
Choosing Field
10 M
Filtering PivotTables
20 M
Modifying PivotTable Data
20 M
Grouping based on numbers and Dates
20 M
Calculated Field & Calculated Items
20 M
Arrays Functions
10 M
What are the Array Formulas, Use of the Array Formulas?
10 M
Basic Examples of Arrays (Using ctrl+shift+enter)
10 M
Array with if, len and mid functions formulas
10 M
Array with Lookup functions
10 M
Advanced Use of formulas with Array
10 M

3 hours

Charts and Slicers

The Charts and Slicers module covers creating various charts and using slicers for interactive data filtering, enhancing data visualization.

Various Charts i.e. Bar Charts / Pie Charts / Line Charts
1 H
Using SLICERS, Filter data with Slicers
1 H
Manage Primary and Secondary Axis
1 H

2 hours

Excel Dashboard

The Excel Dashboard module covers planning and creating effective dashboards with tables, charts, and dynamic content for streamlined data presentation.

Planning a Dashboard
40 M
Adding Tables and Charts to Dashboard
40 M
Adding Dynamic Contents to Dashboard
40 M

1 hour

Sorting and Filtering

The Sorting and Filtering module in Excel covers organizing and analyzing data with text, number, color filters, and advanced sorting, enhancing data management and analysis.

Filtering on Text, Numbers & Colors
20 M
Sorting Options
20 M
Advanced Filters on 20-15 different criteria(s)
20 M

BROCHURE

Get Brochure

Enquire this Program

Name*

Email*

Phone number*

Microsoft Office Specialist

Demonstrate that you have the skills needed to get the most out of Excel 2019 by earning the Microsoft Office Specialist (MOS) Expert certification.

Program Cohorts

Can't find the batch you're looking for?

Enquire Batches

Admission Process at Cokonet

The course admission process at Cokonet involves streamlined procedures ensuring efficient enrollment for prospective students.

Step 1

Speak With our Career Counselor

Our career counselor will help you identify the suitable course for you.

Step 2

Complete Payment

Finalize the transaction securely, using the provided payment methods.

Step 3

Get Enrolled

Enroll in the chosen course, providing personal details and payment information.

Aswathy A

VP, Product

Companies that our Alumni work in

Join Cokonet

Identify your suitable courses in a few clicks

Find from a list of 60+ courses to launch your career.

Hire Train Transfer Model

Our Hire-Train-Transfer model revolutionises corporate talent acquisition by seamlessly connecting businesses with skilled professionals through customised training programs.

Know more

Corporate Training

Readily Deployable Resources

Financing & Support

0% Interest Loans

Access 0% interest loans (6/9/12 Months EMI) for your education, ensuring affordability while you pursue your dreams.

Pay in Installments

Ease your financial burden with our convenient installment payment options.

Scholarships

We believe in supporting aspiring learners by providing financial aid to help them pursue their dreams.

Laptop Support

Seamless assistance with our comprehensive laptop support services.

Course Suggestor

Intermediate Excel

Program Overview

Eligiblility

Why should you learn?

Possible Job Roles

Course Modules

Excel Introduction

Overview of the screen, navigation, and basic spreadsheet concepts

Various selection techniques

Shortcut Keys

Customizing Excel

Customizing the Ribbon

Using and Customizing AutoCorrect

Changing Excel’s Default Options

Using Basic Functions

Using Functions – Sum, Average, Max, Min, Count, Counta

Absolute, Mixed, and Relative Referencing

Formatting and Proofing

Currency Format

Format Painter

Formatting Dates

Custom and Special Formats

Formatting Cells with Number formats, Font formats, Alignment, Borders, etc

Basic conditional formatting

Mathematical Functions

SumIf, SumIfs CountIf, CountIfs AverageIf, AverageIfs, Nested IF, IFERROR Statement, AND, OR, NOT

Protecting Excel

File Level Protection

Workbook, Worksheet Protection

Text Functions

Upper, Lower, Proper

Left, Mid, Right

Trim, Len, Exact

Concatenate

Find, Substitute

Date and Time Functions

Today, Now

Day, Month, Year

Date, Date if, DateAdd

EOMonth, Weekday

Advanced Paste Special Techniques

Paste Formulas, Paste Formats

Paste Validations

Transpose Tables

New in Excel 365 & 2016 / 2013

New Charts – Tree map & Waterfall

Sunburst, Box and whisker Charts

Combo Charts – Secondary Axis

Adding Slicers Tool in Pivot & Tables

Using Power Map and Power View

Forecast Sheet

Sparklines -Line, Column & Win/ Loss

Using 3-D Map

New Controls in Pivot Table – Field, Items and Sets

Various Time Lines in Pivot Table

Auto complete a data range and list

Quick Analysis Tool

Smart Lookup and manage Store

Printing Workbooks

Setting Up Print Area

Customizing Headers & Footers

Designing the structure of a template

Print Titles –Repeat Rows / Columns

What If Analysis

Goal Seek

Scenario Analysis

Data Tables (PMT Function)

Solver Tool

Logical Functions

If Function

How to Fix Errors – if error

Nested If

Complex if and or functions

Data Validation

Number, Date & Time Validation

Text and List Validation

Custom validations based on formula for a cell

Dynamic Dropdown List Creation using Data Validation – Dependency List

Lookup Functions

Vlookup / HLookup