Balujalabs also called Baluja Institute of Technology & Management since 1997.
Balujalabs.in provides Excel Course in Advance to the student to prepare them for job in any field as- Business Analysts, Project Managers, Data Journalists etc.
COURSE DETAILS:-
Course Duration – 1.5 month
ADVANCE EXCEL
Section 1 – Formatting
• Freeze titles
• Conditional formatting
• Auto format
Section 2 – Protection
• Worksheet and cell protection
• Hiding rows and columns
• Workbook protection
• Hiding worksheets & workbooks
Section 3 – Cell comments
• Display comments
• Create, edit & delete comments
Section 4 – 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
• Creating links
• Linking between workbooks
• Linking to a word document
Section 9 – Sorting
• Multiple column sorts
• Custom sorts
Section 10 – Lists
• Creating a list
• Filtering lists
• Autofilter
• Custom autofilter
• Advanced filtering
• Extracting filtered data
• Adding subtotals
Section 11 Pivot tables
• Grouping data in pivot tables
Section 12 – 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– Macros
• Recording macro
• Running a macro
• Assigning a macro to a toolbar button
For more details contact us :-
9015596280, 9313565406, 9212129290