Topics will be covered
• Filter
o AutoFilter
o Text Filter with Condition
o Filter by Color
o Advanced Filter
• Data Validation
o Whole Number, Decimal Number, List, Date, Time, Text length, Custom
o List using cell range and List using direct text
o Circle invalid data and Clear Circle
o Validate Mobile number, Email id, Website, Shipping and Delivery date
o Unique entry restriction in cell
• Conditional Formatting
o Highlight cell rules
o Top and bottom cell rules
o Data bars
o Color scales
o Icon sets
o Use formula in conditional formatting
o Highlight cell range with from and to dates
o Highlight entire row with condition
o Manage Rules, Clear Rules, New Rules
• What-If Analysis
o Scenario Manager
o Goal Seek
o Data Table
• Pivot Table and Pivot Chart
o Variable layout Row, Column, Value, Filter
o Formatting pivot table date
o Calculated field
o Show value As
o Value and Label Filter
o Aggregate function SUM, MIN, MAX, COUNT, AVG, STDV, VARIANT
o Slicer
o Timeline
• Static Charts
o Pie Chart
o Donut Chart
o Bar Chart
o Column Chart
o Stacked Column Chart
o Clustered Chart
o Line
o Scatter Chart
o Pareto Chart
o Stock Chart
• Dynamic Chart
o Using INDEX Function
o Using OFFSET function
• Dashboard
o Dashboard using formula and functions and pivot table, pivot chart
• Protect
o Protect Range
o Protect Sheet
o Protect Worksheet
• Recording Macro
o Record Macro
o Edit Macro
o Assign Button to Macro
o Assign Shortcut to Macro
What is special in this course compare to other trainers?
• 26+ Years real-time experienced Software Professional.
• Teaching from the basic to advanced topic in methodological way.
• Create complex functions with simple steps
• All concepts will be explained with realtime data
• Each complex functions concept will be explained in step by step in depth.
• On the spot practice
• Case Studies and Assignment for each concepts
• Online objective type test to check you knowledge
• Interview tips
Who should take up Excel course?
Software Engineers and Data Analysts
Business Intelligence Professionals
Financial Specialist
Students
Any one who wants learn excel in depth
What are the prerequisites?
Basic computer knowledge and installing software is required.
Participants should aware Basic Excel functionalities like Cut,Copy,Paste,Insert Rows, Delete Rows, Hide Rows, Formating (Font, Color, Alignment, Merge Cells), Sort, Find, Replace, Page Layout