Call: 011-41668088, 9313565406
SMS: 'BALHELP' to 9015596280
E-mail: [email protected]

intership, 6 week intership, 6 month intership
php training, php training in delhi, php certification
php training, php training in delhi, php certification
SEO courses, SEO courses institute in delhi, SEO course institute
IT Training, Summer Training, Live project Training, Corporate Training, Android Training

Get In Touch


university admission, bba admission, bca admission


ssc coaching in delhi, bank coaching in delhi, dsssb coaching in delhi, railway exam in delhi, ctet coaching in delhi

it/cs projects, management projects, library science, tourism projects, journalism projects, Synopsis & Projects, Synopsis Sample, Project Sample, it/cs projects sample, management projects sample

it/cs projects, management projects, library science, tourism projects, journalism projects, Synopsis Projects, Synopsis Sample

Baluja Institute of Technology and Management
  • Syllabus

    Advance excel at balujalabs Formatting

  • Freeze titles
  • Conditional formatting
  • Auto format

    • Advance excel at balujalabs Protection
  • Protection
  • Worksheet and cell protection
  • Hiding rows and columns
  • Workbook protection
  • Hiding worksheets & workbooks

    • Advance excel at balujalabs Cell comments
  • Cell comments
  • Display comments
  • Create, edit & delete comments

    • Advance excel at balujalabs  Names
  • Names
  • Using names in formulas
  • Using to with names

    • Advance excel at balujalabs Templates

  • Creating a template
  • Using a template
  • Editing a template
  • Deleting a template

    • Advance excel at balujalabs  Formulas
  • Display formulas
  • Formulas that produce errors
  • Custom number formats

    • Advance excel at balujalabs  Scenarios
  • Creating scenarios
  • Using and editing scenarios
  • Scenario summary report

    • Advance excel at balujalabs Linking

  • Linking
  • Creating links
  • Linking between workbooks
  • Linking to a word document

    • Advance excel at balujalabs  Sorting
  • Sorting
  • Multiple column sorts
  • Custom sorts

    Advance excel at balujalabs  Lists
  • Lists
  • Creating a list
  • Filtering lists
  • Autofilter
  • Custom autofilter
  • Advanced filtering
  • Extracting filtered data
  • Adding subtotals

    • Advance excel at balujalabs  Pivot tables
  • Pivot tables
  • Grouping data in pivot tables
  • S.a.e section 12 – functions
  • Functions
  • Logical functions
  • Date and time functions
  • Lookup functions
  • Maths and statistical functions
  • Text functions
  • Financial functions
  • Database functions
  • Nested functions

    • Advance excel at balujalabs  functions
  • Functions
  • Logical functions
  • Date and time functions
  • Lookup functions
  • Maths and statistical functions
  • Text functions
  • Financial functions
  • Database functions
  • Nested functions

    • Advance excel at balujalabs  Charts

  • Formatting charts
  • Modifying charts
  • Insert image in 2d chart

    • Advance excel at balujalabs  Data tables

  • One input data table
  • Two input data table

    • Advance excel at balujalabs  Macros
  • Macros
  • Recording macro
  • Running a macro
  • Assigning a macro to a toolbar butto

    • Advance excel at balujalabs  Auditing
  • Auditing
  • Trace precedents
  • Trace dependents

Copyright © 2015 Baluja Labs All Right Reserved.