CoursesAnalytics Intermediate 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.
duration
30 Hours
NEXT BATCH
Nov 04, 2024
mode
Online
payment options
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
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.
Why should you learn?
This course enhances data manipulation and analysis skills, covering advanced formulas, pivot tables, charts, and conditional formatting for dynamic reporting.
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
30 Hours 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
Various selection techniques
Shortcut Keys
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
Using and Customizing AutoCorrect
Changing Excel’s Default Options
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
Absolute, Mixed, and Relative Referencing
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
Format Painter
Formatting Dates
Custom and Special Formats
Formatting Cells with Number formats, Font formats, Alignment, Borders, etc
Basic conditional formatting
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
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
Workbook, Worksheet Protection
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
Left, Mid, Right
Trim, Len, Exact
Concatenate
Find, Substitute
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
Day, Month, Year
Date, Date if, DateAdd
EOMonth, Weekday
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
Paste Validations
Transpose Tables
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
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
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
Customizing Headers & Footers
Designing the structure of a template
Print Titles –Repeat Rows / Columns
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
Scenario Analysis
Data Tables (PMT Function)
Solver Tool
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
How to Fix Errors – if error
Nested If
Complex if and or functions
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
Text and List Validation
Custom validations based on formula for a cell
Dynamic Dropdown List Creation using Data Validation – Dependency List
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
Index and Match
Creating Smooth User Interface Using Lookup
Nested VLookup
Reverse Lookup using Choose Function
Worksheet linking using Indirect
Vlookup with Helper Column
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
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
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
Using SLICERS, Filter data with Slicers
Manage Primary and Secondary Axis
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
Adding Tables and Charts to Dashboard
Adding Dynamic Contents to Dashboard
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
Sorting Options
Advanced Filters on 20-15 different criteria(s)
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.
Admission Process at Cokonet
The course admission process at Cokonet involves streamlined procedures ensuring efficient enrollment for prospective students.
Step 1Speak With our Career Counselor
Our career counselor will help you identify the suitable course for you.
Step 2Complete Payment
Finalize the transaction securely, using the provided payment methods.
Step 3Get 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.
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 moreOur Corporate Training Services, delivered by industry experts, equip employees with the latest skills and certifications, enabling them to meet project demands and excel in cutting-edge domains.
Know moreCokonet's upcoming job portal, SurePool.in, provides top-notch staffing services, connecting businesses with qualified professionals for seamless workforce augmentation.
Know more
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.
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.
Limited Excel experience is acceptable if comfortable with data analysis concepts.
Participants need access to a computer with Microsoft Excel installed.
Cokonet offers genuine placement assistance to the learners. It is imperative to note that getting placed is solely based on the competence of the candidate attending the interview.
