Course details
Why do I need to learn MS Excel and MS Office Access?
MS Excel is use to create spreadsheets and analyze data with charts and graphs. A "must know" program for anyone in the work force now, or soon to be! MS Access is a powerful program to create and manage your databases. It has many built in features to assist you in constructing and viewing your information. These two platforms when combined can resolve your information management challenges.
Designed For:
For those who would like to know how to manage and store information for reference, reporting and analysis. For those who would like to use Microsoft access to analyze large amounts of information, and manage related data more efficiently than Microsoft excel or other spreadsheet applications.
Course Overview:
MS Excel:
- Simple Functions
- Other advanced functions like: If, VLOOKUP, PMT, and other useful functions
- Managing Charts
- Using Sort and Filter
- Subtotals, custom views, comments
- Data Validation
- Pivot Tables and Pivot Charts
- Chart Tables, Consolidate
- Group and Outline
- Goal Seek, Scenarios
- Outsourcing Data
- Formula Auditing
- Conditional Formatting, Auto Correct Options
- Managing Multiple Documents
- Usage of Freeze Panes and Split
- Managing Tables
- MS Access
- MS Excel Migration
- MS Access Database creation and manipulation
- o Database Fundamentals
- o Tables
- o Queries
- o Forms
Course Location
About Karama Language & Computer Center
ABOUT US
Karama Language and Computer Centre (KLCC) established in 2005, is a highly professional training institute, approved by Knowledge & Human Development Authority (KHDA), U.A.E, offering a wide range of training programs for enhancing skills in diverse fields.
We are based in Dubai, the thriving business hub of the Middle East and it offers a wide scope of activities for the business community in the U.A.E.
Whether your employees need computer training or language training KLCC offers a complete learning experience irrespective of nationality or skill level.
The training offered by us has helped numerous organizations improve their overall work & quality standards.
See all Karama Language & Computer Center courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Microsoft Access 2010 – Intermediate Global EdulinkAED 227Duration: Upto 4 Hours
- Online Microsoft Access 2016 Advanced 1TRAININGAED 180Duration: Upto 15 Hours
