Microsoft Office - Microsoft Excel
Developing formulas for calculations you want to make in Excel can be tedious and complicated. Excel has an entire library of functions or predefined formulas that you can use. There are hundreds of functions in Excel that allow you to format text, reference cells, calculate financial rates, look up information and more.
This course allows the user to explore the vast range of Excel functions and gain an understanding of how to apply functions to their own work.
The day commences with a brief review of commands covered in the Level 1 course, followed by an in-depth look at the main types of functions available and how to use them effectively.
This is a one-day course running from 9:30 am - 4:30 pm.
Training is hands-on and tutor-led.
We provide a comprehensive training manual, lunch and certification.
Courses run at both Swansea and Cardiff locations.
This course can be run as a company specific option either at your site or our own.
General review of existing knowledge and the commands covered in the Level 1 course.
Working with text: Preparing text for mail-merge, removing spaces in text, making text change case. Concatenate, Lower, Upper, Proper, Rept, Trim, Text to Columns.
Can you afford that business loan or new credit card? Use financial functions to work out repayments. FV, PMT, NPer.
Use logical functions, such as IF, OR, AND, NOT, TRUE, FALSE, and IFERROR, to find out whether certain conditions are true or false.
Date and Time
Use Date and Time functions to create formulas that display a specific date or time, or that calculate the difference between dates. Networkdays, Now, DateDif.
Lookup and Reference
Excel comes with multiple Lookup and Reference functions that let you find matching values. Hyperlink, Transpose, Lookups, two list data validation.
Create your nown random number generator. Rand, RandBetween, Roman, SumIf, Trunc.
Use functions to return information about your sapreadsheet. Cell, Isblank, IsText.
Attendees will gain the maximum benefit if they have attended our Level 1 course, or are familiar with creating basic spreadsheets and using simple functions.
Computeraid certificate of achievement.
Excel Level 3
Gain an in depth knowledge of data analysis, learn how to audit your spreadsheet and use advanced features such as templates and macros.