MS-Excel Mastery
Menu
- 60 DAYS MS-Excel
MS-Excel Mastery: Basics to Advanced
Unlock Your Potential: Excel Data Manipulation and Analysis
Play Video
DATE
15 August 2024
TIME
7 pm - 8 pm
LANGUAGE
Marathi + English
DURATION
60 Days
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 The Course?
- Data formatting and alignment, Sorting, filtering, and conditional formatting for data organization
- Utilization of Excel functions and formulas for complex calculations and data manipulation
- Visual representation of data – Creation and customization of charts and pivot tables for data visualization
- Insightful what-if analysis and solver techniques for strategic decision-making
- Implementation of macros for task automation
- Harnessing the power of AI tools for data analysis
Course Highlights
- 100% Live Sessions
- Expert Trainers
- 1:1 Doubt Clearing
- 12 Industry Oriented Case Studies
- 6 Months Access to Course Content
- Course Completion Certificate
Who Can Enroll For This Course
Small Business Owners
Coaches & Consultants
Working Professionals
Anyone who want to upskill
School/College Teachers
Solopreneurs / Self-employed
Curriculum
Introduction To 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
- AI in Excel
Capstone Project
- Capstone Project
Our Trainers
Deepak P
CORPORATE TRAINER
Vishwas P
CORPORATE TRAINER
Ashok S
CORPORATE TRAINER
Aarthi P
CORPORATE TRAINER
