MS-Excel

EXCEL CURRICULUM

Proofing,Comments and Changes

  • Inserting Hyperlinks
  • Linking sheets, Cells, Workbook, Range and Mail
  • Header-Footer, Word Art and Signature Line
  • Inserting Objects
  • Protect Sheet
  • Protect Workbook
  • Hiding Formulas
  • Sharing Workbook
  • Track Changes (Highlight, Accept & Reject Changes)
  • Inserting and Editing Comments

Connections and Data Tools

  • Data Importing (From Access, Web and Text)
  • Other Sources (SQL server and XML)
  • Advance Sorting and Filtering
  • Text to Columns
  • Removing Duplicates
  • Data Validation
  • List box, Formula based restrictions Customization of error alert and Input box Types of Alerts (Stop, Warning and information)
  • Highlighting the Invalid data
  • Pivot Tables
  • Usage of Formulas in Pivot Tables Inserting pictures, Clip art, Text box, Shapes and Smart Art
  • Usage of Charts (Column, Pie, Bar, Line)
  • Usage of Dynamic Charts
  • Activities based on the above functions

Data Tools and Outline

  • Data Consolidation
  • Scenario Manager Goal Seek
  • Data Table
  • Group and Ungroup Adding subtotals to the list
  • Defining name to the range
  • Name manger editing
  • Trace precedents/Trace Dependents
  • Evaluate Formulas

Text,Arithmetical Functions

  • UPPER, LOWER, PROPER, LEN, LEFT, RIGHT, MID,
  • FIND, TRIM, CLEAN, CHAR, CODE, CONCATENATE, SUBSTITUTE, EXACT, REPT, REPLACE, SEARCH, VALUE and TEXT.
  • ABS, ROUND, SUM, SUMIF, SUMIFS, SUMPRODUCT, SUBTOTAL and RANDBETWEEN

Statistical and Information Function

  • AVERAGE, AVERAGEIF, AVERAGEIFS, COUNT,
  • COUNTA, COUNTBLANK, COUNTIF, COUNTIFS,
  • LARGE, SMALL, MAX, MIN, RANK, ROWS, ROW,
  • COLUMN and COLUMNS
  • ISBLANK, ISERROR, ISNUMBER, ISTEXT and ISNA

Activities

  • INDEX and MATCHDynamic Pivot ranges
  • Creation of Dynamic ranges
  • Comparisonofcharts using OFFSET function
  • Dynamic charts using OFFSET and Scroll bar

Summarizing of Excel

  • Activities based on Real Time Scenarios
  • Summarizing of Excel

Date&Time and Logical Functions

  • DATEDIF, DATE, TODAY, NOW, WEEKDAY,
  • MONTH, YEAR, YEARFRAC, NETWORKDAYS, DAYS360,
  • MINUTE, HOUR, SECOND, WEEKNUM, EDATE and EOMONTH.
  • IF, AND, OR, NOT, TRUE, FALSE, IFERROR and Nested Functions.

Lookup and References

  • VLOOKUP, HLOOKUP, INDEX, MATCH, OFFSET, CHOOSE and INDIRECT.
  • VLOOKUP with MATCH, IFERROR, WILDCARD and CHOOSE.
  • Combination of Formulas Array Formulas VLOOKUP and
  • COLUMN VLOOKUP with IF and VLOOKUP
  • And Combinations of Formulas creating dynamic Reports

Activities

  • SUM and CHOOSE
  • sorting the data using formula
  • Multiple VLOOKUP
  • Multiple INDEX Leave Tracker using conditional
  • formatting Using formula in conditional formatting to highlight second repeated value

MACROS (VBA) CURRICULUM

Introduction to Macros

  • Introduction to Macros
  • Introduction to VBA
  • Importance of Developer Tab and VB window
  • Path to get into VB window
  • Introduction to different windows in VB Enabling the Macros to run the program
  • Macro workbook saving
  • Introduction to cell reference

Introduction to Properties

  • Introduction to object model
  • Introduction to property and methods
  • Importance of arguments
  • Usage of different property and methods with
  • cells introduction to sheet reference Usage of different property and methods with sheets

Declaration of Variables

  • Introduction to workbook reference
  • Usage of different property and methods with workbook
  • Introduction of variable declaration
  • Importance of different data types
  • Different levels of declaration of variables Different

Conditional Statements

  • Introduction to conditional statement
  • Introduction to different conditional statement
  • Activity on different conditional statement
  • Activity on different conditional statement with LOOP

Loop Statements

  • Introduction to Message Box
  • Introduction to Input Box
  • Introduction to different
  • Loop statements FOR_NEXTLOOP
  • Activity of FOR_NEXTLOOP

Loops

  • Introduction to TO_DOLOOP
  • DO_WHILE LOOP
  • Activity on DO_WHILE LOOP
  • DO_UNTIL LOOP
  • Activity on DO_UNTIL LOOP
  • Introduction to FOR EACH NEXT LOOP
  • Usage of SET statement
  • Activity on FOR EACH NEXT LOOP

Data Segregation

  • Segregation of data in static way
  • Introduction to Rows count and Columns countSegregation of data in dynamic way

User Defined Functions

TRAINING METHODOLOGY

ENQUIRY NOW

Job Announcement

Job Announcement Content Will Come Here!! Job Announcement Content Will Come Here!! Job Announcement Content Will Come Here!! Job Announcement Content Will Come Here!!Job Announcement Content Will Come Here!!Job Announcement Content Will Come Here!!

Google Map

Contact Us


Address : No. 1190/18, 1st Floor, Anjanadri Avenue,26th Main, Jaya Nagar 9th Block,Bangalore - 560069 Karnataka INDIA

Telephone : 08026633667 / 9739867782

For Courses : +91 7022009946 / 7022009947

For Placement : +91 7022009949 / 7022009950

Email Id : info@startcareer.co.in