Data Analytics Course in chennai

Basic Excel Course in chennai

Topic 1: Excel Introduction

            An overview of the screen, navigation and basic spreadsheet concepts

            Various selection techniques

            Shortcut keys

Topic 2: Customizing Excel

            Customizing the Ribbon

            Using and Customizing AutoCorrect

            Changing Excel’s Default Options

Topic 3: Using Basic Functions

Using Functions- Sum, Average, Max, Min, Count, Counta

            Absolute, Mixed and Relative Referencing

Topic 4: Formatting and Proofing

            Currency Format

            Format Painter

            Formatting Dates

            Custom and Special Formats

            Formatting Cells With Number formats, Font formats, Alignment, Borders , etc

            Basic conditional formatting

Topic 5: Mathematical Functions

Sumlf, Sumlfs Countlf, Countlfs Averagelf, Averagelfs, Nested IF, IFERROR Statement, AND, OR, NOT.

Topic 6: Protecting Excel

            File Level Protection

            Workbook, Worksheet Protection

Topic 7: Text Functions

            Upper, Lower, Proper

            Left, Mid, Right

            Trim, Len, Exact

            Concatenate

Topic 8: Date and Time Functions

            Today, Now

            Day, Month, Year

            Date, Date if, DateAdd

            EOMonth, Weekday

Topic 9: Advanced Paste Special Techniques

            Paste Formulas, Paste Formats

            Paste Validations

            Transpose Tables

Topic 10: New in Excel 2013/2016 & 365

            Sunburst, Box and whisker Charts

            Adding Slicers Tool in Pivot & Tables

            Forecast Sheet

Topic 11: Data Validation

            Number, Date & Time Validation

            Text and List Validation

            Custom Validations based on Formula for a cell

Topic 12: Lookup Functions

            Vlookup /Hlookup

Topic 13: Pivot Tables

            Classic Pivot table

            Filtering Pivot Tables

Topic 14: Charts and Slicers

            Various Charts i.e. Bar Charts/Pie Charts/ Line Charts

            Using SLICERS, Filter data with Slicers

            Manage Primary and /secondary Axis

Topic 15: Excel Dashboard

            Sparklines- line, Column & Win/ Loss

            Using 3- D Map

            Auto complete a data range and list

            Quick Analysis Tool

            Smart Lookup and manage Store

Topic 16: Sorting and Filtering

            Filtering on Text, numbers &  colors

            Sorting Options

            Advanced Filters on 15-20 different criteria(s)

Topic 17: Printing Workbooks

            Setting Up Print Area

            Customizing Headers & Footers

            Designing the structure of a template

            Print Titles- Repeat Rows/columns

Advanced Excel Course in chennai

Topic 18: What If Analysis

            Goal Seek

            Scenario Analysis

            Data Tables (PMT Function)

            Solver Tool

Topic 19: Logical Functions

            If Function

            How to Fix Errors- If error

            Nested If

            Complex if and or functions

VBA Macro Course in chennai

Topic 20: Introduction to VBA

What is VBA?

            What Can You Do with VBA?

            Recording a Macro

            Procedure and functions in VBA

Topic 21: Variables in VBA

            What is Variables?

            Using Non-Declared Variables

            Variable Data Types

            Using Const variables

Topic 22: If and Select statements

            Simple if Statements

            The Elseif  Statements

            Defining select case statements

Topic 23: Looping in VBA

            Introduction to Loops and its Types

            The Basic Do and For Loop

            Exiting from a Loop

            Advanced Loop Examples

Power BI Course in chennai

Topic 1: Power guery Editor

            Data types

            Column Tracking

            Split columns

            Choose column Keep/Remove Rows

            Append Queries

            Duplicates Queries

            Creating Dim Table

            Join Kind

            Merge Queries

            Join

            Extract

            Format

            Functions

            Data Modeling

Topic 2: DAX Functions

            Data Types

            Basic Functions

            Date Function

            Aggregation Functions

            Logical Function

            Filter Function

            Time Intelligence Function

            Information Function

Topic 3: POWER BI VISUALAZATION

            Dashboards

            Formatting

            POWER BI SERVICE