Enjoy studying with us – Basic Computer Course

Dca-Basic Level

1 Introduction To Computer

2 Typing /Ms. Word ( Word processing)

3 Paint, NotePad, WordPad

4 Ms. Office (Ms.Word, Ms.Excel)

5 Internet (Browser, Surfing, Email, Downloading, Form Filling, Ticketing Etc.)

Course Duration: 2 MONTHS

Basic plus advanced computer course

ccc- basic to advance

1 Computer Fundamentals

2 Typing /Ms. Word (Word processing)

3 Paint, NotePad, WordPad

4 Ms. Office (Ms.Word, Ms.Excel, Ms. PowerPoint,Ms.OutLook), Ms.Excel Master Class.

5 Graphic Design(Photoshop,Canva)

6 Video Editing

7 Internet (Browser, Surfing, Email, Downloading, Form Filling, Ticketing Etc.)

Course Duration: 3MONTHS

Advanced Microsoft Excel (Bussiness Executive)

Advanced Excel Course – Overview of the Basics of Excel

• Customizing common options in Excel
• Absolute and relative cells
• Protecting and un-protecting worksheets and cells

Advanced Excel Course – Working with Functions

• Writing conditional expressions (using IF)
• Using logical functions (AND, OR, NOT)
• Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX)
• VlookUP with Exact Match, Approximate Match
• Nested VlookUP with Exact Match
• VlookUP with Tables, Dynamic Ranges
• Nested VlookUP with Exact Match
• Using VLookUP to consolidate Data from Multiple Sheets

Advanced Excel Course – Data Validations

• Specifying a valid range of values for a cell
• Specifying a list of valid values for a cell
• Specifying custom validations based on formula for a cell

Advanced Excel Course – Working with Templates

• Designing the structure of a template
• Using templates for standardization of worksheets

Advanced Excel Course – Sorting and Filtering Data

• Sorting tables
• Using multiple-level sorting
• Using custom sorting
• Filtering data for selected view (AutoFilter)
• Using advanced filter options

Advanced Excel Course – Working with Reports

• Creating subtotals
• Multiple-level subtotals

Creating Pivot tables

• Formatting and customizing Pivot tables
• Using advanced options of Pivot tables
• Pivot charts
• Consolidating data from multiple sheets and files using Pivot tables
• Using external data sources
• Using data consolidation feature to consolidate data
• Show Value As ( % of Row, % of Column, Running Total, Compare with Specific Field)
• Viewing Subtotal under Pivot
• Creating Slicers ( Version 2010 & Above)

Advanced Excel Course – More Functions

• Date and time functions
• Text functions
• Database functions
• Power Functions (CountIf, CountIFS, SumIF, SumIfS)

Advanced Excel Course – Formatting

• Using auto formatting option for worksheets
• Using conditional formatting option for rows, columns and cells

Advanced Excel Course – WhatIf Analysis

• Goal Seek
• Data Tables
• Scenario Manager

Advanced Excel Course – Charts

• Using Charts
• Formatting Charts
• Using 3D Graphs
• Using Bar and Line Chart together
• Using Secondary Axis in Graphs
• Sharing Charts with PowerPoint / MS Word, Dynamically
• (Data Modified in Excel, Chart would automatically get updated)

Advanced Excel Course – New Features Of Excel

 Sparklines, Inline Charts, data Charts Overview of all the new features

Course Duration: 1.5 MONTHS