In the course MS Excel 2016/2019: Intermediate, the presented interactive lessons focus mainly on performing various calculations. You will broaden your basic knowledge by the application of logical and text functions. You will get acquainted with the principles of referencing to the values in other cells. You will learn to fill cells with series of data. You will familiarise yourself with the advanced options of sorting and filtering data or searching for specific values in extensive tables. You will also examine how to split longer text entries in tables into individual data placed into several columns.
OVERVIEW
REQUIREMENTS
- Persons who have some experience of the basics of Microsoft Excel and needs to up their game to intermediate leave – which most administrators have working in offices and managing day to day Office productivity.
- Make sure you have completed the beginners’ course first or make sure you understand how to complete all elements. (see other courses to consider under the progression section).
CONTENT
INDICATIVE CONTENT
- Customisation of the Quick Access Toolbar
- Customising the Ribbon
- Manipulation with sheets of multiple workbooks
- Advanced paste options
- Copying multiple items
- Pasting external data into Excel
- Advanced number formats
- Custom number format
- Worksheet protection
- Advanced work with Excel tables
- Using references in formulas
- Comparing and connecting values using operators
- Cell and range references
- Conditional formatting rules
- Conditional formatting based on a formula.
- Function library
- Text functions
- Advanced text functions
- Math functions
- Statistical functions
- Date and time functions
- Logical functions and conditional calculations
- Nested functions
- Errors in cells and their checking
- Naming cell ranges
- Data validation
- Advanced fill series
- Advanced sorting
- Data filtering
- Using slicers to filter data
- Finding and replacing specific values
- Removing duplicate data
- Splitting text into columns
- Flash Fill
- Outline
METHOD OF DELIVERY/DURATION
- Online and Customised for Organisations
CERTIFICATION
Personalised Certificate of Completion or option to complete QQI accredited course at level 3, 4, 5 and 6, ECDL, MOS
ASSESSMENT
- Online assessment
COST
€29.95 for one single module. Check out the great deals on completing more than one course.
PROGRESSION
This course is for those that have some Microsoft Excel experience but are still learning – intermediate users.
There is the option to purchase.