Sunil Kumar

Years of Experience in Microsoft Excel Training classes

10

Teaching Experience in detail in Microsoft Excel Training classes

Beginner-Level Excel Core Concepts: I introduce learners to the fundamental layout of Excel, including ribbons, worksheets, and cells. Data Entry and Formatting: I teach efficient data entry techniques, along with essential formatting skills like applying cell styles, number formats, and creating tables. Basic Formulas and Functions: My training covers foundational formulas such as SUM, AVERAGE, COUNT, and MIN/MAX. I also introduce the concept of cell referencing (absolute vs. relative) to build a strong foundation for more complex calculations. Intermediate-Level Excel Logical and Text Functions: I guide students through using IF, AND, OR statements to create conditional logic. I also cover text functions like LEFT, RIGHT, MID, and CONCATENATE for data manipulation. Data Analysis Tools: I teach how to use PivotTables and PivotCharts to summarize and analyze large datasets. I also provide instruction on sorting, filtering, and using data validation to maintain data integrity. Lookup Functions: A key component of my intermediate training is mastering lookup functions. I provide in-depth instruction on VLOOKUP and HLOOKUP, and more recently, the more powerful XLOOKUP, to help learners retrieve specific data from tables. Advanced-Level Excel Complex Functions and Formulas: I dive into advanced functions like INDEX/MATCH, SUMIFS, and COUNTIFS. I also teach how to nest functions to create sophisticated formulas that solve complex problems. Macros and VBA: For those needing automation, I provide training on recording and editing macros. I also offer an introduction to Visual Basic for Applications (VBA), empowering users to write simple scripts to automate repetitive tasks and create custom functions. Data Visualization and Dashboards: My advanced courses focus on creating impactful data visualizations. I teach how to design dynamic charts, use conditional formatting for visual cues, and build interactive dashboards that provide clear insights from complex data.

Years of Experience in Microsoft Power BI classes

5

Teaching Experience in detail in Microsoft Power BI classes

Key teaching areas and skills covered include: Data Acquisition and Transformation: Connecting to various data sources: I have guided students in connecting Power BI to a wide array of sources, including Excel files, CSVs, SQL databases (e.g., SQL Server, MySQL), cloud services (e.g., Azure SQL Database, SharePoint), and web APIs. Power Query Editor: I provide detailed instruction on using the Power Query Editor to clean, shape, and transform data. This includes practical exercises on removing rows/columns, unpivoting data, merging and appending queries, and using M-language for custom transformations. Data Modeling: Relational Data Concepts: I teach fundamental data modeling principles, explaining concepts like star schemas and snowflake schemas. Creating and Managing Relationships: I demonstrate how to establish and manage relationships between tables, emphasizing the importance of cardinality (one-to-one, one-to-many) and cross-filter direction. DAX (Data Analysis Expressions): This is a core component of my teaching. I break down DAX into manageable lessons, starting with simple calculated columns and measures (e.g., SUM, COUNT, AVERAGE). I then progress to more complex functions and concepts, such as: CALCULATE and ALL/ALLEXCEPT for context modification. Time intelligence functions (TOTALYTD, DATEADD). Iterators (SUMX, AVERAGEX). Creating and using variables. Report and Dashboard Design: Visualization Best Practices: I emphasize the importance of choosing the right visualization for the data, explaining the strengths of different chart types (bar charts, line charts, pie charts, scatter plots, etc.). Interactive Reports: I teach students how to create dynamic and interactive reports using slicers, filters, and drill-through functionality. User-Centric Design: I guide learners in designing dashboards that are intuitive, aesthetically pleasing, and tell a clear story, focusing on key performance indicators (KPIs). Custom Visuals: I introduce students to the use of custom visuals from the AppSource marketplace to extend the functionality of Power BI. Power BI Service and Administration: Publishing Reports: I walk students through the process of publishing their reports from Power BI Desktop to the Power BI Service. Creating Dashboards: I demonstrate how to pin visuals to dashboards and create a consolidated view of key metrics. Data Refresh: I explain the different methods for refreshing data (on-premises data gateways, scheduled refresh) and how to configure them. Sharing and Collaboration: I cover the various methods of sharing reports and dashboards, including sharing links, workspaces, and apps, and discuss the implications of different access levels.

Years of Experience in SQL Server Training

5