Microsoft Excel Introduction with CPD Certificate - Nottingham

This intensive 1 day, hands-on course Microsoft Excel Introduction course is fully Accredited by CPD and helps you gain comprehensive, practical understanding of Excel.

You will use Microsoft Office Excel to create spreadsheets and workbooks that you can use to store, manipulate, and share your data.

This course is suitable for anybody wanting to learn 2016, 2013, 2010 or 2007, as it covers all the aspects and differences between the versions.

Benefits of Studying Excel with Infero Training:

• Instructor-Led course in a small group for maximum knowledge retention
• Comfortable Premises with the latest technology
• Microsoft Official Curriculum (optional)
• Free 12 Months Post Course Support
• Certificate of Completion
• CPD Points
• Refreshments

Certification:

Upon completion of the course, you will receive CPD Points.

This course is also one of a series of courses that addresses Microsoft Certified Application Specialist (Microsoft Business Certification) skill sets. The Microsoft Certified Application Specialist program is for individuals who use Microsoft's business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Microsoft Certified Application Specialist certification.

Course Content

Lesson 1: Getting Started with Microsoft Excel

Topic 1A: Navigate the Excel User Interface

Topic 1B: Use Excel Commands

Topic 1C: Create and Save a Basic Workbook

Topic 1D: Enter Cell Data

Topic 1E: Use Excel Help

Lesson 2: Performing Calculations

Topic 2A: Create Formulas in a Worksheet

Topic 2B: Insert Functions in a Worksheet

Topic 2C: Reuse Formulas

Lesson 3: Modifying a Worksheet

Topic 3A: Insert, Delete, and Adjust Cells, Columns, and Rows

Topic 3B: Search for and Replace Data

Topic 3C: Use Proofing and Research Tools

Lesson 4: Formatting a Worksheet

Topic 4A: Modify Fonts

Topic 4B: Add Borders and Colour to Cells

Topic 4C: Apply Number Formats

Topic 4D: Align Cell Contents

Topic 4E: Apply Styles and Themes

Topic 4F: Apply Basic Conditional Formatting

Topic 4G: Create and Use Templates

Lesson 5: Printing Workbook Contents

Topic 5A: Preview and Print a Workbook

Topic 5B: Define the Page Layout

Lesson 6: Managing Large Workbooks

Topic 6A: Manage Worksheets

Topic 6B: Manage Workbook and Worksheet Views

Topic 6C: Manage Workbook Properties

Course Objectives

Upon successful completion of this course, students will be able to:

• Perform calculations.
• Modify a worksheet.
• Format a worksheet.
• Print workbook contents.
• Manage large workbooks.

This course is designed for students who desire to gain the necessary skills to create, edit, format, and print basic Microsoft Office Excel worksheets.

To be successful in this course, you should be familiar with using personal computers and have used the mouse and keyboard. You should be comfortable in the Windows environment and be able to use Windows to manage information on the computer. Specifically, you should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders.

Being proficient in Excel can open the door to many career opportunities such as:

• Administrative Assistant
• Data Analyst
• Accountants
• Financial Analyst
• Retail Store Manager
• Project Manager
• Business Analyst