Advance EXCEL with AI - Contents
Excel with Ai training in West Delhi
Module 1
Excel with Ai training in West Delhi
Introduction to Excel and AI Integration
- Overview of Excel and its applications
- Introduction to AI and its capabilities
- How AI can enhance Excel functionalities
Module 2
Excel training
Excel Basics & Foundation
- Navigating the Excel interface
- Basic data entry and formatting
- Introduction to formulas and functions
Advanced Mathematical & Statical Excel Functions with AI
- Using AI to automate repetitive tasks
- Sum
- Product
- Average
- Ceiling
- Floor
- Round
- Round Up
- Round Down
- Power
- Count
- Counta
- Maximum
- Minimum
- Mode
- Median
- Log
- Dollar
- Average A
- Mina
- Maxa
- Large
- Sqrt
- Mod
- Roman
- Rank
- Rank Average
- Rand
- Rand Between
Advanced Logical Functions with AI
- If
- Nested if
- SumIf
- Sumifs
- Averageif
- Averageifs
- Countif
- Countifs
- Or
- Not
- And
- If error
- If Function & Nested If Statements And
& Or Functions - Maxifs
- Minifseen
Advanced Text Functions
with AI
- Upper
- Lower
- Left
- Right
- Exact
- Len
- Mid
- Concatenate
- Proper
- Trim
- Substitute
- Search
- Find
Advanced Date & Time
Functions with AI
- Days360
- Date
- Network days
- Now
- Today
- Weekday
- Effect
- Eomonth
- Edate
- Workdays
Advanced Lookup & Reference Functions with AI
- Index
- Match
- Lookup
- Choose
- Offset
- Offset with Match
- Xlookup
- Transpose
- Hlookup For Single Worksheet
- Vlookup For Single Worksheet
- Hlookup & Vlookup For Multiple Sheet
- Match and Find Record by Vlookup And
Hlookup - Approximate Match with Vlookup
- Exact Match with Vlookup
- Nesting Lookup Function
- Show Formula
- Choose Function with Vlookup
- Indirect
Advanced Financial
Functions with AI
- Pmt
- Rate
- Ppmt
- Ipmt
- Fv
- Pv
- Coupdays
- Coupnum
- Ispmt
- Sln
- Cumprinc
- Cumipmt
- Ddb
- Db
- Received
Advanced Database Functions with AI
- Daverage
- Dproduct
- Dmin
- Dmax
- Dcount
- Dsum
- Dget
Working with Charts
- Creating a Chart with the 2D or 3D
- Create Column Chart, Pie Chart
- Create Pateros Charts
- Create Speed- O-Meter Chart
- Moving a Chart One to another Sheet
- Resizing a Chart, Changing a Chart Type
- Editing Chart Text, Modifying Chart Options
- Formatting Category & Value Axis Data
- Formatting a Data Series
- Changing a Chart’s Source Data
Data Visualization and Reporting
- Creating charts and graphs in Excel
- Integrating AI for interactive reporting
- Advanced visualization techniques with Excel
Format Cells
- Cell Format.
- Data Bars, Color Scales & Icon Sets
- Sorting basic
- Sorting based on Customized List
- Customized Sorting (Advanced)
Conditional Formatting with Rules & Color Scale with AI
- Using Conditional Formatting
- Removing Conditional Formatting
- Format As table
- Create our Styles
- Conditional formatting with formulas
- Conditional formatting with Form
Controls
Excel Tips & Tricks with AI
- Hidden Excel features and shortcuts
- AI tips for Excel power users
- Troubleshooting and support using AI
Data Management with Data Validation
- Data Validation and dealing with Invalid Data
- Group and Outline Data
- Data Consolidation
- Data text to column
- Custom Views
Data Analysis with AI
- Tracing Formula Precedents
- Tracing Cell Dependents
- Error Checking
Summarizing Data by Subtotal With grouping
- Adding Subtotals to a List
- Nesting Subtotals
- Adding Group & Outline Criteria to Ranges
- Using Data Validation
- Text to Column
WHAT IF – DATA ANALYSIS
- Using Goal Seek
- Using Data Table
- Creating & Displaying Scenarios
Sorting & Filtering
- Sorting Records in a List
- Using AutoFilter in a List
- Filter & Advance Filter
- Applying Advance Filters
Protecting Excel Workbook & Sheet
- Locking/Unlocking Cells in a worksheet
• Protecting a Worksheet
• Protecting a Workbook
• Creating a Shared Workbook
• Tracking Changes to a Workbook
• Accepting & Rejecting Changes to a
Workbook
• Password Protecting a Workbook
• Merging Workbooks
Workgroup Collaboration with AI
- Web Page Preview
- Workflow optimization tips with Excel and AI
- Converting Worksheets into Web Pages
- Inserting Hyperlinks
- Viewing & Editing Comments
Customizing Macro by Action Button
- Creating a Macro with Condition
- Running a Macro, Editing a Macro
- Adding a menu to the Menu Bar
- Adding a Commands to a Menu
- Adding Buttons to a Toolbar
Working with Pivot Table & Pivot Chart
- Creating a Pivot Table
- Rearranging a Pivot Table
- Filtering Pivot Table Data
- Creating a Pivot Chart
Reporting with Payroll Statement AI
- MIS Report
- Profit & Loss a/c statement
- Balance sheet
- Worker contribution statement
- Cash flow statement
- Debtor’s & Creditors statement
- Inventory statement
- BRS Statement
- Fixed Assets & fund statement
- Payroll Report
- P.F & E.S.I Report
Special Operation
- Find record by drop down list according To condition
- Dash Board
- Working with the Web and External Data
- Inserting a Hyperlink
- Importing Data from an Access Database or Text File
- Importing Data from the Web and Other Sources
- Working with Existing Data Connections
- Speed o Meter
