| COURSE : CERTIFIED ADVANCED EXCEL EXPERT - CAEE | |
|---|---|
| Course Overview | This specialization is intended for anyone who seeks to develop one of the most critical and fundamental digital skills today. Spreadsheet software remains one of the most ubiquitous pieces of software used in workplaces across the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio. In the United States alone, millions of job advertisements requiring Excel skills are posted every day. Research by Burning Glass Technologies and Capital One shows that digital skills lead to higher income and better employment opportunities. At a time when digital skills jobs are growing much faster than non-digital jobs, completing this specialization will position you way ahead of others. The best way to learn Excel is to use Excel. In this specialization, learners will solve a broad range of business problems as they apply the Excel skills and techniques they learn along the way. Excel workbooks, quizzes, and challenges provide countless opportunities to practice and use spreadsheet software in a variety of business contexts |
| Training Duration | Total Training Hours : 30 Hours Training Duration : 1 Week Total Training Days : 5 Working Days |
| Training Schedules | Weekdays (Sunday to Thursday) Regular Sessions : 6 Hrs Per day (9am to 2pm or 3.00pm to 9.00 pm) Food & refreshments Included WeekEnds (Friday & Saturday) Fast Track Sessions: 8 Hours per day (9am to 5pm) Food & refreshments Included |
| Certifications: | 1) Certificate from Laurels Training Institute, Attested by Knowledge & Human Development Authority (KHDA) government of Dubai, UAE OPTIONAL 2) Certificate from American Institute of Professional Studies (AIPS) from USA (After 15 Days of course Completion which will couriered to the attendees office address) |
| Tests | Yes |
| Learning Aids | Yes |
| Course Material | Hard & Soft Copies of Study Material |
| Language of Instruction | English |
| Instructor Helpline | Yes 1. Email 2. Social Media (For Emergency requirements) |
| Registration Requirements | 1. Passport Copy 2. Curriculum Vitae 3. Passport size photographs 4. Course Fee |
| Mode of Payment: | Cash / Cheque / Credit Card / Bank Transfer. |
| Eligibility Criteria (Who should attend this training) | This course is designed for delegates who desire to gain the necessary skills to create, edit, format, and print basic Microsoft Office Excel worksheets. Business Analysts All Analysts Accountants and officers MIS officers Admin and support staff" |
| Course Benefits | Create a basic worksheet by using Microsoft Office Excel 2010. Perform calculations in an Excel worksheet. Modify an Excel worksheet. Format a worksheet. Print the content of an Excel workbook. Manage an Excel workbook. |
| Course Contents / Outline | Getting Started with Excel Identify the Elements of the Excel Interface Navigate and Select Cells in Worksheets Customize the Excel Interface Create a Basic Worksheet Performing Calculations in an Excel Worksheet Create Formulas in a Worksheet Insert Functions in a Worksheet Reuse Formulas Modifying a Worksheet
Edit Worksheet Data Find and Replace Data Manipulate Worksheet Elements Modifying the Appearance of a Worksheet
Apply Font Properties Add Borders and Colors to Cells Align Content in a Cell Apply Number Formatting Apply Cell Styles Managing an Excel Workbook
Manage Worksheets View Worksheets and Workbooks Printing Excel Workbooks
Define the Page Layout Print a Workbook
Formulas: V lookup H lookup Pivot Conditional Formatting If Conditions Macros Master Macros Formula Mix Database building" |