Microsoft Excel Introduction with CPD Certificate - Nationwide

Infero Training Ltd

Microsoft Excel Certificate of completion

Digital certificate - Included

Microsoft Excel Introduction Course Content

Lesson 1: Getting Started with Microsoft Excel

• Navigate the Excel User Interface
• Use Excel Commands
• Create and save a basic Excel workbook
• Enter cell data in Excel
• Use Excel Help

Lesson 2: Performing Calculations with Microsoft Excel

• Create formulas in an Excel worksheet
• Insert functions in an Excel worksheet
• Reuse Excel formulas

Lesson 3: Modifying a Worksheet with Microsoft Excel

• Insert, delete, and adjust cells, columns, and rows in Excel
• Search for and replace data in Excel
• Use Excel proofing and research tools

Lesson 4: Formatting a Worksheet with Microsoft Excel

• Apply Excel Text Formats
• Apply Number Formats in Excel
• Align Excel Cell Contents
• Apply Styles and Themes in Excel
• Apply Basic Conditional Formatting in Excel
• Create and Use Excel Templates

Lesson 5: Printing Workbook Contents with Microsoft Excel

• Preview and Print an Excel Workbook
• Setup the Page Layout in Excel
• Configure Headers and Footers

Lesson 6: Managing Large Workbooks with Microsoft Excel

• Manage Excel Worksheets
• Manage Excel Workbook and Worksheet Views
• Manage Excel Workbook Properties

.

Microsoft Excel Introduction Course Objectives

Upon successful completion of this Microsoft Excel Introduction course, you will have gained the skills necessary to:

• Perform calculations in Excel
• Modify an Excel worksheet
• Format an Excel worksheet
• Print Excel workbook contents
• Manage large Excel workbooks

.

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

Microsoft Excel Course Testimonials from our Website and Google Reviews

I was absolutely delighted with the Excel courses that Infero delivered which more than exceeded my expectation. I learnt new ways of using Excel that I can now use in my day to day work to make my work more efficient. Pivot tables were always a mystery to me but now I use them regularly to display HR and Payrol data.

Lisa Dunstan (Payroll Manager) from Decathlon UK

.

The day after taking the Microsoft Excel Intermediate Course, I created two pivot tables and used several advanced formulas to do, in ten minutes, tasks that would previously have taken me hours. The teaching at Infero is easy to follow, the lessons are brilliantly delivered and the instructors are experts in their field, extremely friendly and endlessly patient. There are just the right number of breaks between concise, targeted modules to make learning as near effortless as possible. The ‘aftercare’ element - a tutor will usually answer your queries within hours - is particularly valuable. A great lunch, too.

Harry Frost (Marketing Assistant) from Babcock International Group

.

Had Excel training with Infero last week, I must say it was a good day, I am not the most gifted on excel, but after spending the day with our tutor Martin I came away with a lot more confidence and knowledge, and i will be back for more at a later date, Martin paced the course excellently so no one got left behind or not understanding how to do something. We had good rapport with Martin, even though he forgot how to spell his name :) must be an age thing Lol

Martin Pountney

.

I attended the level 3b training course offered by Infero Training and, like with many similar courses I have attended, was initially worried that it would be too much information to take in at once. However, the manuals and exercises provided along with the guidance and experience of our trainer Martin made the course interactive, concise and, dare i say it, enjoyable. I would highly recommend.

Michael Sexton

.

I attended the Microsoft Excel Basic and Excel Intermediate course which I found very useful. Martin is an excellent trainer, made you feel at ease, he is very helpful and patient. I wish I had undertaken the training ages ago as would have been very beneficial in my previous role.

Leela Patel

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

.

Suggested Learning Path:

• Start with Microsoft Excel Introduction to learn the basic Excel functions and interface
• Move onto Microsoft Excel Intermediate once you're comfortable with Excel basic operations, focusing on more advanced Excel formulas and data manipulation
• Progress to Microsoft Excel Advanced if you need to handle large datasets, automation, and complex Excel analysis tasks.

To be successful in this Microsoft Excel Introduction course, you should be familiar with using personal computers and have used the mouse and keyboard. No prior knowledge of Microsoft Excel is necessary.

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
• Manage files and folders

Being proficient in Microsoft 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