This course is ideal for delegates wishing to gain knowledge of some of the advanced features and formulae within Microsoft Excel.
This course is ideal for delegates wishing to gain knowledge of some of the advanced features and formulae within Microsoft Excel. Delegates attending should be already at a competent level of Excel and have good experience with the software. Ideally delegates would have already completed the Excel Intermediate course.
Delegates will cover the following topics:
> Auditing
> Look up tables
> Macros and Assigning Code to Buttons
> IF Revisited
> AND Function
> Text Functions
> Goal Seeking
> Scenarios
> Consolidation of Data
> Working with Fractions
> Sub Totals
> Pivot Tables
Please note: A minimum of 4 delegates are required to run this course. If this is not met then this course may be rescheduled.
Learning to use Excel offers numerous benefits for both personal and professional life. It's a versatile tool that can help with organisation, data management, automation, and creating insightful dashboards.
Excel training courses are a great way to build these skills, providing hands-on experience in a business context. Given its widespread use in various industries, Excel proficiency is highly valued and can open many career opportunities.
Whether you're automating tasks, linking systems, or managing databases, Excel's formulas and macros make it a powerful tool for efficiency and productivity.
Digital Skills Trainer, Chichester College Group
Skill Set and Expertise: Excel, PowerPoint, Word
Education: PGCE Education, BSc (Hons) Combined Science – Management Science and Computer Science