In the lessons of the presented three courses dedicated to Microsoft Excel, you will familiarise yourself with the tools of the most widely applied spreadsheet program. You will learn how to properly enter values to the cells of future tables and how to set their format. From these input values, you will further derive new data by calculating them through formulas, including the applied functions from various categories. You will learn to manipulate cell ranges and whole worksheets. You will adjust the appearance of created tables by setting the cell properties and by applying cell styles. You will analyse the entered data via charts and conditional formatting. You will learn to set the print properties before printing created tables and charts. You will also learn to sort and filter more extensive data and to calculate their subtotals. You will familiarise yourself with the data validation, the creation of scenarios and with the application of the Solver tool. You will learn to share workbooks and to set various levels of their protection. You will also examine the creation and usage of macros in details.
![](https://midaslearning.ie/wp-content/uploads/2021/07/sgUcHkUw-scaled.jpeg)
OVERVIEW
REQUIREMENTS
- Individuals who want to gain a full knowledge of Microsoft Excel from beginners’ level to advanced level.
- Learn at your own pace.
- 12-month Access duration
- Can upgrade to a customised pack – tutor led training.
- Option to undertake accredited Training
![](https://midaslearning.ie/wp-content/uploads/2021/07/pexels-katerina-holmes-5905709.png)
CONTENT
INDICATIVE CONTENT
- Advanced data validation
- OFFSET function.
- Advanced filter
- Database functions
- SUBTOTAL function
- Advanced IF functions
- VLOOKUP and HLOOKUP functions
- INDEX and MATCH functions
- External data from web
- External data from Access
- Import of data through Microsoft Query
CERTIFICATION
Personalised Certificate of Completion or option to complete QQI accredited course at level 3, 4, 5 and 6, ECDL, MOS
ASSESSMENT
- Online assessment
METHOD OF DELIVERY/DURATION
- Online and Customised for Organisations
COST
€75 for all three courses. Check out the great deals on completing more than one course.
PROGRESSION
Via the interactive lessons, you will get acquainted with the Excel program environment and systematically work levels so that on conclusion you are proficient in using the MS Excel system from beginners to advance.
![](https://midaslearning.ie/wp-content/uploads/2021/07/linkedin-sales-solutions-AhirGl0nhww-unsplash.png)
There is the option to purchase:
- This course – MS Excel 2016/2019: Set of 3 Interactive courses.- Introduction, Intermediate and Advanced
- The Full Microsoft Office 2016: Library of 16 Interactive Courses
- MS Office 365 – 5 in 1 – Tools for online Activity
- MS Access 2016: Set of 3 Interactive courses.- Introduction, Intermediate and Advanced
- MS Word 2016: Set of 3 Interactive courses.- Introduction, Intermediate and Advanced
- MS PowerPoint 2016: Set of 3 Interactive courses.- Introduction, Intermediate and Advanced
- MS Outlook 2016:Set of 3 Interactive courses.- Introduction, Intermediate and Advanced
- MS Excel 2016: Set of 4 Interactive courses.- Introduction, Intermediate, Advanced and Expert