Contact
0509249945
Created by
Vision Institute
Real Estate, Car Dealer, Car Hire & Leasing, 3D Printing, Accountants, Advertising, Air Cargo & Shipping Services, Air Conditioning, Air Conditioning, Airlines & Service Providers, Alternative Medicine, Amusement Parks & Arcades, Artificial Intelligence, Arts & Crafts Retailer, Associations & Unions, Audio & Video Production, Auto Services & Workshop, Auto Spare Parts & Accessories, Bakeries & Cake Shop, Bike Shop, Boat Charters, Boat Dealer, Boats & Watercraft, Bookstores, Business Consultancy, Business Services, Car Dealers, Car Hire & Leasing, Car Parts & Accessories, Car Wash, Celebrity Management & Casting, Cinema, Clothing Retailer, Coffee & Tea shop, Colleges & University, Computers Retailer, Construction & Renovation, Cosmetic Surgeons, Cosmetics & Beauty Retailer, Counselling & Mental Health, Courier & Delivery Services, Crypto & Blockchain, Cybersecurity, Ecommerce, Employment Agency, Engineering, Environmental Consultancy, Events & Festivals, Expat Services, Fabric Stores, Factory Outlets, Fashion, Fast Food & Takeaways, Florists, Food Equipment, Freight Transportation, Furniture Stores, Garden & Outdoor, Gardening & Cleaning, General Retailers, Graphic Design, Gyms & Fitness Centres, Hardware Stores, Heavy Vehicles, Hobby Shop, Home Decor Retailers, Home Entertainment Retailers, Home Furniture & Appliances, Hotels & Resorts, House Maid, Household Appliances Retailers, Ice Cream & Frozen, Immigration & Visas, Import & Export Agents, Industrial Machinery, Interior Design, Internet Services, Interpreting & Translating, ISO Certification, IT Services, Jewellery & Watch Retailers, Kids activities, Kindergarten & Preschools, Kitchen & Bath Retailer, Landscape & Outdoor Living, Laundry, Lawyers & Legal Services, Leather Goods Retailer, Local Tours & Activities, Logistics, Marketing, Medical Centres & Healthcare , Mobile Phones Retailers, Mobility Aids, Motor sports, Motorcycles Dealers, Moving Company, Museums, Office Supplies, Oil & Gas, Opticians, Outsourcing, Pest Control, Pest Control & Disinfection, Pet Clinics & Vets, Pet Grooming Centres, Pharma & Biotech, Photographer, Photography Store, Plants & Gardening Stores, Ports & Harbours, Printing, Professional Services, Property Management, Public Relations, Radio Stations, Recruitment, Removals & Relocation, Renovations & Repair, Restaurant, Robotics, Safety & Security, School, Security Services, Shoe Store, Shopping Centre, Souvenirs & Gifts, Space Tech, Special Number Trading, Special Schools, Sporting Goods Retailer, Sports Medicine, Start-Up, Stationery Retailers, Supermarket & Grocery, Sustainable Energy, Tailoring, Telecommunication, Toys & Games, Training & Learning Centres, Transportation & Logistics, Travel Agents, Tuning, University, Used Goods Retailers, Vehicle Repair & Maintenance, Venues & Event Space, Water sports, Web & App Development, Wedding, Appliance Repair, Wholesalers
Company Name
Vision Institute
Tel
067453323
Mobile
0509249945
Description
Preparing excel MIS reports at your job must be your common and routine work, Companies wants from their employees to have these reports regularly on time basis. If you are one of them, then you must consider undergoing the Advance Excel Training. We offers professional advance excel training
Microsoft Excel workbook is one of the most commonly used tools to summarize and present data - When you know all advance excel techniques, this tool can perform that work with ultimate efficiency. Vision Institute is an excellent and top advance excel training institute in Ajman, You can learn all about Advance excel like Macros, MIS, Pivot Table, Advance Dashboard, Lookup Functions, Filters from Vision and start doing it yourself as an expert. Our Advance Excel Training includes lab assignment and projects for better understanding, Our expert advance excel trainer and contents makes us premium advance excel training institute in UAE.
Learning Objectives:
- To prepare students to demonstrate understanding and ability to use the Excel in the following areas:
- Creating data boxes for financial accounting
- Using multiple sheets in a workbook to prepare financial reports
- Preparing professional quality statements for external reporting
- Creating graphing to interpret business results
- Using Excel functions to evaluate accounting data
SYLLABUS:
CONDITIONAL FORMATTING:
- Formatting data on Conditions
- Finding top 5 / 10 items in the Data
- Clearing & Managing Rules
- Adding data based on two attributes
- Highlight Duplicate & Unique Values
- Formatting data using Data Bars & Icons
- Summarizing a data based on single attribute
- Nested loops
SUMMAIZING & CONSOLIDATING DATA:
- Creating Sub Totals
- Advance Filtering
- Sorting data with Multiple Level Sorts
- Extracting Unique Values with filtering
PIVOT TABLE & SLICER:
- Creating Pivot table & analyzing data
- Creating sheets from Pivot table
- Table creation & text to column
- Refreshing & Changing Pivot Table Range
- Calculations & Creating Dynamic Pivot
- Defining Name & work with tables
- Creating more than one Pivot table on one sheet
- Slicer
LOOKUPS AND DATA TABLE:
- Picking data based on row criteria
- Match and indexing
- Data Tables more than one variable
- Excel speech on data entry
- Data Tables single variable
- Data Entry Forms
- Creating Grade sheet/Result sheet for performance Creating data list in excel
CHARTS & VALIDATION:
- Creating Column, Line & Pie Charts
- Changing Chart type
- Method of pasting chart into PowerPoint
- Creating Drop Downs in cell
- Hyperlinking
- Adding Target Line in chart
- Creating two axis chart & advance charting
- Sharing Workbook • Inserting object
DATA MINING:
- Auditing spread sheet
- Identifying source cells
- Tracing dependent cell
MACROS:
- Record macros for automating tasks
- Macro with Keyboard & its benefit
- Creating Button to run a Macro
- Run / Delete a macro
DATA SECURITY IN MS EXCEL:
- File Level Security
- Making the worksheets invisible
- Limiting access to cell
- Sheet Level Security
- Preventing Sheets from Deletion Cell / Row / Column Level Security
FORMULA:
Statistical : Count, CountA, CountIF, CountIFs, & CountBlank
Change Case: Upper, Lower & Proper Trim
AND & OR in IF Condition
& Concatenate, Sum, Sum IF & SumIFs
Logical: If Condition with Multiple IF’s, Using
Lookup: Advance & Multiple Vlookup & Hlookup
Microsoft Excel workbook is one of the most commonly used tools to summarize and present data - When you know all advance excel techniques, this tool can perform that work with ultimate efficiency. Vision Institute is an excellent and top advance excel training institute in Ajman, You can learn all about Advance excel like Macros, MIS, Pivot Table, Advance Dashboard, Lookup Functions, Filters from Vision and start doing it yourself as an expert. Our Advance Excel Training includes lab assignment and projects for better understanding, Our expert advance excel trainer and contents makes us premium advance excel training institute in UAE.
Learning Objectives:
- To prepare students to demonstrate understanding and ability to use the Excel in the following areas:
- Creating data boxes for financial accounting
- Using multiple sheets in a workbook to prepare financial reports
- Preparing professional quality statements for external reporting
- Creating graphing to interpret business results
- Using Excel functions to evaluate accounting data
SYLLABUS:
CONDITIONAL FORMATTING:
- Formatting data on Conditions
- Finding top 5 / 10 items in the Data
- Clearing & Managing Rules
- Adding data based on two attributes
- Highlight Duplicate & Unique Values
- Formatting data using Data Bars & Icons
- Summarizing a data based on single attribute
- Nested loops
SUMMAIZING & CONSOLIDATING DATA:
- Creating Sub Totals
- Advance Filtering
- Sorting data with Multiple Level Sorts
- Extracting Unique Values with filtering
PIVOT TABLE & SLICER:
- Creating Pivot table & analyzing data
- Creating sheets from Pivot table
- Table creation & text to column
- Refreshing & Changing Pivot Table Range
- Calculations & Creating Dynamic Pivot
- Defining Name & work with tables
- Creating more than one Pivot table on one sheet
- Slicer
LOOKUPS AND DATA TABLE:
- Picking data based on row criteria
- Match and indexing
- Data Tables more than one variable
- Excel speech on data entry
- Data Tables single variable
- Data Entry Forms
- Creating Grade sheet/Result sheet for performance Creating data list in excel
CHARTS & VALIDATION:
- Creating Column, Line & Pie Charts
- Changing Chart type
- Method of pasting chart into PowerPoint
- Creating Drop Downs in cell
- Hyperlinking
- Adding Target Line in chart
- Creating two axis chart & advance charting
- Sharing Workbook • Inserting object
DATA MINING:
- Auditing spread sheet
- Identifying source cells
- Tracing dependent cell
MACROS:
- Record macros for automating tasks
- Macro with Keyboard & its benefit
- Creating Button to run a Macro
- Run / Delete a macro
DATA SECURITY IN MS EXCEL:
- File Level Security
- Making the worksheets invisible
- Limiting access to cell
- Sheet Level Security
- Preventing Sheets from Deletion Cell / Row / Column Level Security
FORMULA:
Statistical : Count, CountA, CountIF, CountIFs, & CountBlank
Change Case: Upper, Lower & Proper Trim
AND & OR in IF Condition
& Concatenate, Sum, Sum IF & SumIFs
Logical: If Condition with Multiple IF’s, Using
Lookup: Advance & Multiple Vlookup & Hlookup
IMPORTANT!
Before you contact the advertiser, do a payment or make a deal, please read our SAFETY TIPS.
Help us and report scams, don't forget to read vivaUAE TERMS AND CONDITIONS.
Location
Sheikh Khalifa Bin Zayed Street, Ajman
Vision institute
Vision institute
Advert details
Advert ID
147940
Displayed
82
Added
2020-04-11 17:13:44
Expires
never expire
Category
All others services
UAE FREE CLASSIFIED ADS WEBSITE
vivaUAE provides high-response free classifieds and advertisements. All adverts must conform to our Technical Guidelines. We request all our users to report to us immediately if they come across any miscategorized, fraudulent, or suspicious ad.