Microsoft Excel is the most commonly used spreadsheet application. Learning how to use Excel is an investment in both your personal and professional life. Excel makes it easy to monitor financial performance, such as business profit or loss, calculate payments on large purchases, plan a budget, or stay organised with checklists. This course will give a full introduction to Excel, and them moves on to the more advanced functions, so whether you’re a beginner or have some experience, you’ll become an expert.
Our online courses offer you the opportunity to study 24/7 wherever you are in the world. These intensive on line courses are open to anyone with an interest in the topic and give you access to world-class learning led by IAP.
If you pass the exam successfully then you will be awarded a Microsoft Excel 2013 Basic to Advanced Training Certificate.
Microsoft Excel 2013 - Beginner | |||
Identify the Elements of the Excel Interface | |||
Create a Basic Worksheet & Use the Help System | |||
Create Formulas in a Worksheet | |||
Insert Functions in a Worksheet | |||
Insert, Manipulate, and Delete Cells, Columns, & Rows | |||
Search, Replace Data & Spell Check a Worksheet | |||
Modify Fonts, Add Borders and Color to Cells | |||
Align Cell Contents & Apply Cell Styles | |||
Printing Workbook Contents | |||
Format and Manage Worksheet | |||
Manage the View of Worksheets and Workbooks | |||
Customize General and Language Options | |||
Customize Formula | |||
Customize Proofing and Save Options | |||
Customizing Other of Excel Functions | |||
Microsoft Excel 2013 - Intermediate | |||
Apply Range Names | |||
Use Specialized Functions | |||
Analyzing Data with Logical and Lookup Functions | |||
Insert and Modify Graphic Objects | |||
Layer and Group Graphic Objects | |||
Customizing Workbooks | |||
Manage Themes | |||
Create and Use Templates | |||
Protect Files | |||
Microsoft Excel 2013 - Advanced | |||
Apply Conditional Formatting | |||
Trace Cells | |||
Troubleshoot Invalid Data and Formula Errors | |||
Watch and Evaluate Formulas | |||
Create a Data List Outline | |||
Create Sparklines and Scenarios | |||
Perform a Statistical Analysis with the Analysis ToolPak | |||
Create Interactive Data with Power View | |||
Consolidate Data | |||
Link Cells in Different Workbooks | |||
erge Workbooks | |||
Export and Import Excel Data | |||
Integrate Excel Data with the Web | |||
Create a Web Query | |||
EXCERCISE FILES | |||
EXCERCISE FILES | |||
Mock Exam | |||
Mock Exam: Microsoft Excel 2013 – Beginner to Advanced | |||
Final Exam | |||
Exam: Microsoft Excel 2013 – Beginner to Advanced |