This course will help you learn the more advanced workings and features of Microsoft Excel 2016. You will look at functions such as macros, pivot tables, functions in formulas and more.
Quick EnquiryExcel has such wide scope for use, you’ll find it used both personally and professionally by many worldwide.
You will find this online advanced Excel course to be advantageous if you spend a good deal of your time working on Microsoft Excel and want to enhance your abilities and understanding of the programme. It’s also a great follow-on from our Excel 2016 course.
Awarded 18 CPD points upon successful completion
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.
Microsoft Excel is likely the most commonly used spreadsheet programme across the world. Not only can you create simple spreadsheets to hold your data but advanced Excel courses online also offers a wealth of features and functionality that could make you more efficient and productive.
The course is accessible online so you study at a time and place that suits you best. On successful completion of the full course you’ll receive a Pitman Training certificate.
There are 17 modules in this course, below is a breakdown of what each one covers: -
Introduction Module: Welcome and course information
- Data calculations, watermarks, converting text to columns and flash fill.
- Consolidating data, paste special, custom formats and working with ranges.
- Hyperlinks and formatting charts.
- Applying functions in formulas.
- Conditional formatting.
- Sort and filter data, subtotals and database functions.
- Macros.
- Data validation, precedent/dependent cells, tracing errors, evaluating formulas and the watch window.
- Protecting worksheets and workbooks, passwords and file properties.
- Sharing and merging workbooks and grouping and ungrouping data.
- Pivot tables.
- Pivot charts.
- VLOOKUP, HLOOKUP, embedding and linking objects.
- Scenario manager and data tables.
- MATCH and INDEX, NOW and TODAY and COUNTA, COUNTBLANK and COUNTIF functions.
- Using financial, nested and the CONCATENATE functions.
- Create and modify custom workbook elements.
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.
