- 60 Days MS-Excel
MS-Excel Mastry with AI
Unlock Your Potential: Excel Data Manipulation & Analysis
Overview
- This course is designed to provide a comprehensive understanding of the fundamental concepts and functionalities of Microsoft Excel. Participants will learn how to create, format, and analyze data using Excel’s powerful tools, including formulas, functions, charts, and data manipulation techniques.
- 60 Days MS-Excel
MS-Excel Mastry with AI
Unlock Your Potential: Excel Data Manipulation & Analysis
Overview
- This course is designed to provide a comprehensive understanding of the fundamental concepts and functionalities of Microsoft Excel. Participants will learn how to create, format, and analyze data using Excel’s powerful tools, including formulas, functions, charts, and data manipulation techniques.
What You Will Learn In This Course
- Data Formatting and Alignment
- Sorting, Filtering, and Conditional Formatting
- Creation and Customization of Charts and Pivot Tables
- Implementation of Macros for Task Automation
- Utilization of Excel Functions and Formulas
- Data Organization and Manipulation
- Insightful What-if Analysis and Solver Techniques
- Harnessing the Power of AI Tools For Data Analysis
Key Features
- 100% Live Sessions
- Expert Trainers
- 1:1 Doubt Clearing
- 10+ Industry Oriented Case Studies
- 6 Months Access to Course Content
- Course Completion Certificate
Who Can Enroll For This Course
Small Business Owners
Working Professionals
Anyone who want to upskill
Syllabus
Introduction To MS-Excel
- Introduction to the Excel Interface
- Workbook and Worksheets
- Excel Navigation
- Sheet options
Alignment Of Data And Data Formatting
- Alignments
- Wrap Text, Merge Cells
- Number Formatting
- Changing worksheet structure
Data Formatting
- Number Formatting and Editing
- Format Painter and Paste special
- Custom Formatting
- Table Formatting
- Working with rows and columns
- Auto Fill
- Flash Fill
- Absolute and relative cell references
- Data Transpose
Organizing Data
- Basic Sort
- Custom Sort
- Horizontal Sort
- Filter
- Logical Filters
Conditional Formatting
- Visually highlight, explore and analyze data
- Detect critical issues, and identify patterns and trends
Excel Views
- Worksheet Views
- Printing Preferences
- Freeze Panes
- Cell Comments
- Header and Footer
Excel Functions And Formulas
- Fundamentals of Excel Functions and Formulas
- Basic Functions: I – Sum, Average
- Count, Min, Max
- Text functions: LEN, EXACT, UPPER, LOWER, PROPER, LEFT, RIGHT, MID, CONCATENATE, SUBSTITUTE, REPLACE, SEARCH, FIND
- And , Or
- Math Functions – Rand between, Round
- Logical Functions – If, Nested If (Ifs)
- Count if, Sum if
- Date and Time Functions – Now, Time, Today, Day, Month, Year
- V lookup
H lookup - Match and Index
- Financial Functions – Loan Calculations PMT, PPMT, IPMT
Formula Auditing And Defined Names
- Trace Precedents and
- Dependents
- Error Checking
- Evaluate Formula
- Name Manager
- Define Name
Data Tools
- Text to column
- Remove duplicates
- Data Validation
- Setting for Validation
- Input Message
- Error Alert
- Highlight Invalid Data
Visual Presentation Using Charts
- Chart creation and modification
- Chart elements for enhanced visualization
- Chart designs and layouts
- 3D Charts
- Combo Charts
- Auto updating Charts
- Creating picture charts
- Linking charts with PPTs and Word Docs
Data Protection
- Workbook Level Security
- Worksheet Level Security
Consolidation Of Data
- Consolidating Information
- Consolidation of data from different sheet
- Consolidation with 3D formula
Pivot Table And Pivot Charts Technique
- Creating Pivot Table
- Creating Pivot Charts
- Grouping in Pivot Table
- Filtering in Pivot Table
- Slicers use
- Power Pivot Concept
Macros - Automation In Excel
- Recording a Macro
- Creating and Running a Macro (Sample pre-ready VBA Codes)
What If Analysis And Solver
- Goal Seek
- Scenario Manager
- Solver
Import And Export Of Data
- Importing and exporting data from text file
- Create a web query
- Introduction of Power Query Editor
Bonus: AI In Excel
- Use of AI in Excel
Case Studies & Projects
- Tax Invoice
- Expense Management
- Student Attendance & Fees Management
- Bank Statement
- Organization of Data & Data Alignment
- Create Attractive Charts
- Inventory Management
- Personal Finance Tracker
- Create Interactive Dashboard
- Capstone Project: HR Management System
Our Trainers
Deepak P
Trainer
Vishvas P
Trainer
Ashok S
Trainer
Aarti P
Trainer
