If you're already familiar with the basics of Excel, then our Improver course will introduce you to some of the more advanced functions in Excel.
We cover the key functions and techniques that you can apply to your business spreadsheets, and create fully productive automated spreadsheets.
- By the end of the session you will be able to:-
- Import data from external Files - Apply data validation settings to cells - Apply conditional formatting - Apply, use and remove auto filters - Use named cells and ranges - Calculate across worksheets - Protect worksheets from editing - Use advanced Functions including (IF, AND, OR, VLOOKUP, HLOOKUP, CONCATENATE etc) - Create and edit pivot tables - Create pivot table charts and more..........
Training is delivered using clients laptops, or desktop PC's. External venues & laptop hire can be arranged at an additional cost Accomodation & Travel are NOT included in price listing Certificate of attendance issued at the end of the day. Pre-requisites: Students should be using Excel on a daily basis, and be compfortable using basic functions.