Advanced Spreadsheets (Using Excel)


In our advanced Microsoft Excel course, we will build on your knowledge and will be taught how to construct a clear, concise, and informative expert spreadsheet that can be a turning factor for any business, club, or personal use. You will be introduced to some of the more complex operations within the program, and follow our step-by-step instructions as we produce a multi-sheet workbook that will be used to record a real-life activity before we look at performing a range of complex analysis actions on the results. Join us as we create it by using the following principles whilst you gain understanding through practice and gain a certificate to show your current employer, put on your CV, or show your family.
- Document setup and styles.
- Creating headers and footers.
- Advanced formula and functions including Count, CountIF, and CountA.
- Understand and use Vlookup.
- Introduce pivot tables.
- Use multiple worksheets in a spreadsheet workbook.
- Use graphs to present your data in a visually appealing way.
Including exercises to practice your new skills and aid understanding.
This course will take 2 hours.