Call: 011-41668088, 9313565406
SMS: 'BALHELP' to 9015596280
E-mail: contactus@balujalabs.in

intership, 6 week intership, 6 month intership
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


    Section 1 – Formatting
  • Freeze titles
  • Conditional formatting
  • Auto format
  • Section 2 – Protection
  • Protection
  • Worksheet and cell protection
  • Hiding rows and columns
  • Workbook protection
  • Hiding worksheets & workbooks
  • Section 3 – Cell comments
  • Cell comments
  • Display comments
  • Create, edit & delete comments
  • Section 4 – Names
  • Names
  • Using names in formulas
  • Using to with names
  • Section 5 Templates
  • Creating a template
  • Using a template
  • Editing a template
  • Deleting a template
  • Section 6 – Formulas
  • Display formulas
  • Formulas that produce errors
  • Custom number formats
  • Section 7 – Scenarios
  • Creating scenarios
  • Using and editing scenarios
  • Scenario summary report
  • Section 8 – Linking
  • Linking
  • Creating links
  • Linking between workbooks
  • Linking to a word document
  • Section 9 – Sorting
  • Sorting
  • Multiple column sorts
  • Custom sorts
    Section 10 – Lists
  • Lists
  • Creating a list
  • Filtering lists
  • Autofilter
  • Custom autofilter
  • Advanced filtering
  • Extracting filtered data
  • Adding subtotals
  • Section 11 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
  • Section 12 – functions
  • Functions
  • Logical functions
  • Date and time functions
  • Lookup functions
  • Maths and statistical functions
  • Text functions
  • Financial functions
  • Database functions
  • Nested functions
  • Section 13 – Charts
  • Formatting charts
  • Modifying charts
  • Insert image in 2d chart
  • Section 14 – Data tables
  • One input data table
  • Two input data table
  • Section 15 – Macros
  • Macros
  • Recording macro
  • Running a macro
  • Assigning a macro to a toolbar butto
  • Section 16 – Auditing
  • Auditing
  • Trace precedents
  • Trace dependents

Copyright © 2015 Baluja Labs All Right Reserved.