Advanced Excel

Advanced Excel

Advanced Excel

Fees : Rs. 1499/-

  • 4.50
Do you have an intermediate understanding of Excel but are keen to break through to real mastery? Want to finally use the excel programme.


Full Courses Idea

Module 1

  •    Introduction to MS Excel, Quick review on MS Excel Options, Ribbon, Sheets and
  •    Difference between Excel 2003, 2007, 2010 and 2013
  •    Saving Excel File as PDF, CSV and Older versions
  •    Using Excel Shortcuts with Full List of Shortcuts
  •    Copy, Cut, Paste, Hide, Unhide, and Link the Data in Rows, Columns and Sheet
  •    Using Paste Special Options
  •    Formatting Cells, Rows, Columns and Sheets
  •    Protecting & Unprotecting Cells, Rows, Columns and Sheets with or without Password
  •    Page Layout and Printer Properties
  •    Inserting Pictures and other objects in Worksheets
  •    Lookup and Reference Functions: VLOOKUP, HLOOKUP, INDEX, MATCH, etc
  •    Logical Function: IF / ELSE, AND, OR, NOT, TRUE, NESTED IF/ELSE etc
  •    Database Functions
  •    Date and Time Functions: DATE, DATEVALUE, DAY, DAY360, SECOND, MINUTES, HOURS, NOW, TODAY, MONTH, YEAR, YEARFRAC, TIME, WEEKDAY, WORKDAY etc
  •    Information Functions :
  •    Math and Trigonometry Functions: RAND, ROUND, CEILING, FLOOR, INT, LCM, MOD, EVEN, SUMIF, SUMIFS etc
  •    Statistical Functions: AVEDEV, AVERAGE, AVERAGEA, AVERAGEIF, COUNT, COUNTA, COUNTBLANK, COUNTIF,FORECAST, MAX, MAXA,MIN, MINA, STDEVA etc
  •    Text Functions: LEFT, RIGHT, TEXT, TRIM, MID, LOWER, UPPER, PROPER, REPLACE, REPT, FIND, SEARCH, SUBSTITUTE, TRIM, TRUNC, CONVERT, CONCATENATE, DOLLAR etc
  •    And More
  •    Using Conditional Formatting
  •    Using Conditional Formatting with Multiple Cell Rules
  •    Using Color Scales and Icon Sets in Conditional Formatting
  •    Creating New Rules and Managing Existing Rules
  •    Sorting Data A-Z and Z-A
  •    Using Filters to Sort Data
  •    Advance Filtering Options
  •    Creating Pivot Tables
  •    Using Pivot Table Options
  •    Changing and Updating Data Range
  •    Formatting Pivot Table and Making Dynamic Pivot Tables
  •    Creating Pivot Charts
  •    Types of Pivot Charts and Their Usage
  •    Formatting Pivot Charts and Making Dynamic Pivot Charts
  •    Advanced Filtering
  •    Data validation
  •    Consolidation
  •    Groups
  •    Subtotal
  •    What is Excel Macro ?
  •    How to Record / Run Excel Macro ?
  •    How Add Developer’s Tab in Excel 2007 / 2010
  •    How to add different types of controls like Text Box, Radio button, button etc. in Excel
  • Module 2
  •    Visual Basic Editor in Excel
  •    VBA Control Property
  •    How to write Excel Macro – Your First Excel Macro
  •    Excel Macro Tutorial : Excel User Form
  •    VBA Spin Button
  •    Toggle Button in Excel
  •    ComboBox / Drop Down List In Excel
  •    ListBox In Excel
  •    How to Open Excel Workbook using Excel Macro
  •    Using RANGE Object in Excel Macro
  •    What is difference between CELLS() and RANGE()
  •    Excel Macros, Excel Terms, Macro comments
  •    Userforms
  •    Variables in Excel VBA
  •    Implicit and Explicit declaration of variables in Excel Macro
  •    Important : Declaring multiple Variables with one Dim Statement
  •    For Next Loop in Excel Macro
  •    While Loop and Do While Loop in Excel VBA
  •    VBA Programming : If Then Statements / If else Statements
  •    VBA Programming : Decision – Select Case in Excel VBA
  •    Variables in Excel VBA
  •    Implicit and Explicit declaration of variables in Excel Macro
  •    Important : Declaring multiple Variables with one Dim Statement
  •    For Next Loop in Excel Macro
  •    While Loop and Do While Loop in Excel VBA
  •    VBA Programming : If Then Statements / If else Statements
  •    VBA Programming : Decision – Select Case in Excel VBA
  •    Events, Error Handling
  •    Excel Objects, Programming Charts
  •    Message box, Input box
  •    Introduction to SQL
  •    Creating New Tables
  •    SQL SELECT Statements
  •    Manipulating Data(Insert, Delete, Update)
  •    Distinct, Order By, Join clauses and Aggregate Functions
  •    Using Primary keys, Foreign keys
  •    Get Data from Multiple Tables
  •    Using DDL Statements
  •    Restricting and Sorting Data
  •    Using Single-row Functions
  •    Conversion Functions
  •    Conditional Expressions
  •    Using the Group Functions
  •    Subqueries to solve queries