There are no items in your cart
Add More
Add More
Item Details | Price |
---|
Description:
Advanced Excel skills encompass a wide range of techniques, including complex formulas (like INDEX/MATCH, array formulas), pivot tables for data analysis, creating dynamic charts, utilizing Power Query for data transformation, automating tasks with VBA macros, and applying conditional formatting to highlight trends, helping users manage and interpret large datasets efficiently.
Key Highlights:
What you will learn:
Understanding the Excel Interface | |
Workbook, Worksheets, Rows, Columns, and Cells | |
Data Entry, Editing, and Formatting | |
Keyboard Shortcuts for Efficiency | |
Saving, Opening, and Printing Excel Files |
Cell Formatting (Fonts, Colors, Borders, Alignment) | |
Conditional Formatting (Color Scales, Data Bars, Custom Rules) | |
Applying and Customizing Themes | |
Working with Tables (Table Styles, Quick Formatting) |
Sorting and Filtering Data | |
Data Validation (Creating Drop-Down Lists) | |
Removing Duplicates | |
Grouping and Subtotaling Data | |
Custom Number Formatting |
Mathematical and Statistical Functions (SUM, AVERAGE, COUNT, COUNTA, etc.) | |
Logical Functions (IF, AND, OR, NOT) | |
Lookup and Reference Functions (VLOOKUP, HLOOKUP, INDEX, MATCH) | |
Text Functions (CONCATENATE, LEFT, RIGHT, MID, TRIM, LEN) | |
Date and Time Functions (TODAY, NOW, DATEDIF, EDATE) |
Creating and Customizing PivotTables | |
Using Filters, Slicers, and Timelines in PivotTables | |
Grouping Data in PivotTables | |
PivotCharts: Visualization of PivotTable Data | |
Calculated Fields in PivotTables |
Creating and Customizing Charts (Bar, Line, Pie, Combo) | |
Sparklines and Mini Charts | |
Creating Heat Maps and Data Bars | |
Advanced Chart Techniques (Dual-Axis Charts, Customizing Labels) | |
Dynamic Charts Using Data Validation Lists |
Advanced Lookup (XLOOKUP, INDIRECT, OFFSET) | |
Array Formulas and Dynamic Arrays (FILTER, SORT, UNIQUE) | |
Financial Functions (NPV, IRR, PMT) | |
Error Handling Functions (IFERROR, ISERROR, IFNA) |
What-If Analysis (Goal Seek, Data Tables, Scenario Manager) | |
Solver Tool (Optimization) | |
Descriptive Statistics Using Data Analysis Toolpak | |
Using Power Query for Data Import and Transformation |
Introduction to Macros and VBA (Recording Macros) | |
Editing and Customizing Macros (Basic VBA Code) | |
Creating Buttons and Assigning Macros | |
Automating Repetitive Tasks with Macros |
Protecting Worksheets and Workbooks (Password Protection) | |
Sharing and Collaborating on Excel Workbooks | |
Track Changes and Version History | |
Co-authoring in Excel |
Introduction to PowerPivot | |
Creating Data Models with PowerPivot | |
DAX (Data Analysis Expressions) Functions | |
Excel to Power BI Integration |
Topic |
---|
Practice on Realtime Project-1 |
Practice on Realtime Project-2 |
Practice on Realtime Project-3 |
Practice on Realtime Project-4 |
Practice on Realtime Project-5 |
After successful purchase, this item would be added to your Library.
You can access the library in the following ways :
We have been in the IT industry since last 18 years and having expertise in all the Market Leading Technologies.
OUR LOCATION