Learn how to use the features and functions of Microsoft Excel 2016 with this unique online course. This course is suitable for beginner to intermediate level and will teach you how to create and format worksheets, use functions, tables, formulas and more.
Quick EnquiryThe course is for anyone wanting to learn how to utilise the latest 2016 version of this powerful spreadsheet programme. As Excel is widely used in a variety of job roles such as finance and accounting, management and office administration roles, it is suitable for a wide audience.
The full course is suitable for both beginners and for those with intermediate level skills; it will help you learn some of the fundamental actions you can carry out in Excel before advancing your knowledge to more in-depth features.
Start Date
Study Type
Training Type
Duration
I chose this course as I wanted a qualification which would allow me to work in an office environment. Pitman offered affordable courses which were flexible enough to allow me to retrain while working. The Learning Coaches were extremely helpful and understanding. My experience with Pitman was stress-free and smooth and I’m very happy with the whole experience.
This course offers an exciting, innovative approach to online Microsoft Excel training and focuses on the latest release of this popular spreadsheet application, from the Microsoft Office 2016 suite, and is suitable for those at beginner to intermediate level. There are 26 modules in total in this course.
• Introduction Module: Welcome and course information
• Starting Excel
• Opening & closing Excel, Using SUM and Navigating Excel
• Formatting
• Number Formats and Different File Types
• Autofill, Formulas and Inserting/Deleting Columns & Rows
• Hiding & Un-hiding and Aligning & Formatting Cells
• Cut, Copy & Paste, Drag & Drop, Format Painter and Auto Complete
• Text Orientation, Non-Adjacent Data, Freeze & Unfreeze, Zoom and Worksheets
• Styles and Themes
• Configure Worksheets and Workbooks
• Using Functions, Quick Analysis and Sort
• Headers and Footers
• Create and Manage Tables
• Worksheets and Viewing Workbooks
• Introduction to Charts
• Complex Formulas
• Now, Count, Today and If Functions
• Format and Modify Text Using Functions
• Perform Logical Operations Using Functions
• Hidden Worksheets and Financial Functions
• Using Formulas in Grouped Worksheets
• Charts
• Sparklines and Inserting Images
• Spell Check, Filter and Find & Replace
• Web Pages, Hyperlinks and Conditional Formatting
• Importing a Text File, Customising the Ribbon & the Quick Access Toolbar and Tell Me What You Want To Do
The course will take around 24 hours to complete, with each module taking 30-45 minutes individually.
At the end of each module you’ll complete a consolidation exercise which will help you to summarise what you have learned and appraise your understanding.
At the end of the course, you’ll take a validation test which, on successful completion, means you will receive a Pitman Training certificate to verify your achievement.
To discuss this training and how it can be adapted to your individual or business needs, speak to a Course Advisor in your nearest centre or enquire online and we’ll get back to you. Students in Ireland can call us for free on 1800 532632.
Request more details or call the team on 1800 532632
Simply enter your details below and we'll email you a copy of all the course details straightaway. One of our friendly course advisors will be in touch to see how we can help and answer all your questions.
We offer a range of training packages in a range of subject areas and can offer blended learning opportunities to best meet your needs.
Our courses are practical in nature and focus on a single subject and can last anywhere from a few hours to a few days.
Diplomas are designed to give you a complete skillset mapped to a specific career path and contain a number of core and elective courses.
Click below for more details or call us on 1800 532632.
