We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. Read more…
Monday
16
APR

Advance Business Excel ( 10 Days Training)

18:30
20:00
BITECH Solutions
Event organized by BITECH Solutions

Get Directions

Category
#var:page_name# cover

This course will help to master you on all the essential features and functions of Microsoft Excel which you can engage during your CBE's Exam.
This course is specially designed for ACCA's, CA, MBA or other professionals who want to enhance their skills in Excel.

For online registration please fill the form below:
http://www.bitechsolutions.org/advance-excel-training/

1. For Complete course outline please click below.
http://www.bitechsolutions.org/advance-excel-training-in-l…/
2. Practical class Assignments.
3. Course Fee Rs. 6,000/-
4. First orientation class is free but registration is compulsory.

Training Includes:
Module 1: Getting Started with Spreadsheets
•Workings and navigations
•Selection, Drag and Move
•Paste Special and Transpose
•Cell References and Ranges
•Formatting and Sorting
•Fill Sequence Lists
•Row and Column Operations
•Arithmetic Operations
•Subtotals, Grand total, Grouping
•Mod, Int, Ceiling
•Filters and Basic Conditional Formatting
•Counting and Conditional Counting
•Relative and Absolute Cell References
•Named Ranges and Name Manager

Module 2: Conditional & Logical Operations
•If, Nested If,
•Sumif, Sumifs,
•Countifs,
•And, Or, Not
•IsBlank, Iferror
•Randbetween
•Choose
•Cell Linking
•Advance Conditional Formatting
•Working with spreadsheets
•Data Validations
•Custom Data Validations

Module 3: Time, Date & Text Functions
•Today, Now, Hour, Minute, Month, Year
•Day, Len, Right, Left, Substitute,
•Upper, Lower, Proper, Concatenate
•EOMonth, Datedif, WorkingDays, Text, &

Module 4: Data Visualization
• Data Handling & Building Charts
• Column & Bar Charts
• Line Charts & Pie Charts
• Area Charts & Doughnut Charts
• Chart Formatting, design & layouts

Module 5: Data Lookup Functions
• Index & Match
• Vlookup & Hlookup
• Lookup Vector
• Exact Match & Approximate Match

Module 6: Dashboards & Business Intelligence
• Pivot Tables & Pivot Charts
• Slicers & Time Series
• Calculated Fields & Group Selection
• Pivot Refresh & Getpivot
• Sparkline Chart
• Macros, Command Buttons, ScrollBar, List Boxes
• Advance Filters, Dsum, Dcount

Module 7: Forecasting & Budgeting
• What-if Analysis
• Goal Seek
• Data Tables
• Scenario Manager
• Scenario Summary
• Forecast Function
• Breakeven Analy

Duration 10 classes
Charges Rs. 6,000/- After discount.
Note: First demo class is free but registration is compulsory.

For more info call:
office: 042-35941627 | Mobile: 0306-4203686
Website: www.bitechsolutions.org | Email: info@bitechsolutions.org
Address: 12 Aibak block new Garden Town Lahore