Download Brochure
CoursesIntermediate Excel Course in Palakkad
CEC 503

Intermediate Excel Course in Palakkad

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
cover-image
course-dot

duration

30 null

course-dot

NEXT BATCH

Aug 05, 2024

course-dot

mode

course-dot

payment options

pay

Overview
Eligibility
Highlights
Job Roles
Syllabus
Certification
Batches
Admission
Testimonials
Financing
FAQ
Programoverview

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!

check-circle1

Enhanced data analysis skills for informed decision-making

check-circle1

Improved efficiency in report creation and data visualization

check-circle1

Increased job opportunities in roles requiring Excel proficiency

check-circle1

Streamlined workflows through automation of repetitive tasks

eligibility-icon

Eligiblility

This course is tailored for those with basic Excel knowledge, including spreadsheet creation, formatting, data entry, and basic formulas. Suitable for beginners and those seeking skill enhancement.

learn-icon

Why should you learn?

This course enhances data manipulation and analysis skills, covering advanced formulas, pivot tables, charts, and conditional formatting for dynamic reporting.

jobroles-icon

Possible Job Roles

Intermediate Excel skills qualify you for roles like Data Analyst, Financial Analyst, Administrative Assistant, and others involving data analysis and reporting.

Salary Range

2 to 10 Lakhs Per Annum

Course-modules

Course Modules

30 null COURSE

0 minutes

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

  • Various selection techniques

  • Shortcut Keys

0 minutes

Customizing Excel

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

  • Using and Customizing AutoCorrect

  • Changing Excel’s Default Options

0 minutes

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

  • Absolute, Mixed, and Relative Referencing

0 minutes

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

  • Format Painter

  • Formatting Dates

  • Custom and Special Formats

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

  • Basic conditional formatting

0 minutes

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

0 minutes

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

  • Workbook, Worksheet Protection

0 minutes

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

  • Left, Mid, Right

  • Trim, Len, Exact

  • Concatenate

  • Find, Substitute

0 minutes

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

  • Day, Month, Year

  • Date, Date if, DateAdd

  • EOMonth, Weekday

0 minutes

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

  • Paste Validations

  • Transpose Tables

0 minutes

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

  • 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

0 minutes

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

  • Customizing Headers & Footers

  • Designing the structure of a template

  • Print Titles –Repeat Rows / Columns

0 minutes

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

  • Scenario Analysis

  • Data Tables (PMT Function)

  • Solver Tool

0 minutes

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

  • How to Fix Errors – if error

  • Nested If

  • Complex if and or functions

0 minutes

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

  • Text and List Validation

  • Custom validations based on formula for a cell

  • Dynamic Dropdown List Creation using Data Validation – Dependency List

0 minutes

Lookup Functions

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

  • Index and Match

  • Creating Smooth User Interface Using Lookup

  • Nested VLookup

  • Reverse Lookup using Choose Function

  • Worksheet linking using Indirect

  • Vlookup with Helper Column

0 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

  • Basic and Advanced Value Field Setting

  • Classic Pivot table

  • Choosing Field

  • Filtering PivotTables

  • Modifying PivotTable Data

  • Grouping based on numbers and Dates

  • Calculated Field & Calculated Items

  • Arrays Functions

  • What are the Array Formulas, Use of the Array Formulas?

  • Basic Examples of Arrays (Using ctrl+shift+enter)

  • Array with if, len and mid functions formulas

  • Array with Lookup functions

  • Advanced Use of formulas with Array

0 minutes

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

  • Using SLICERS, Filter data with Slicers

  • Manage Primary and Secondary Axis

0 minutes

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

  • Adding Tables and Charts to Dashboard

  • Adding Dynamic Contents to Dashboard

0 minutes

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

  • Sorting Options

  • Advanced Filters on 20-15 different criteria(s)

BROCHURE
Get Brochure
logo
CONTACT US
logo
Enquire this Program

certificate-icon

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.

certificate-image
program-icon

Program Cohorts

Aug 2024 Batch

date

timings

batch type

Join batch

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.

course-imageStep 1

Speak With our Career Counselor

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

course-imageStep 2

Complete Payment

Finalize the transaction securely, using the provided payment methods.

course-imageStep 3

Get Enrolled

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

video-image

Aswathy A

VP, Product

logo-icon

Companies that our Alumni work in

  • Truspeq.png
  • Applexus.png
  • Allianz.png
  • Tcs.png
  • UST.png

Join Cokonet

Identify your suitable courses in a few clicks

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

corporates

Looking to enroll your employees into this program?

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

Know more
home-asset

“Education is one thing no one can take away from you.”

finance-icon

Financing & Support

course-image

0% Interest Loans

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

course-image

Pay in Installments

Ease your financial burden with our convenient installment payment options.

course-image

Scholarships

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

course-image

Laptop Support

Seamless assistance with our comprehensive laptop support services.

Intermediate Excel: Frequently Asked Questions (FAQs)

Common queries addressed for Intermediate Excel course seekers.

The course is applicable across various industries, focusing on data analysis and manipulation skills.