Categories
Badges
User Profile
Sharer Hub
Close
If you are using Excel regularly with a good understanding of its features, formulas and functions this course will help you upskill from Intermediate.
Enquire via the Build Your Skill website.
This course can be delivered face-to-face or online (although not at the same time 🙂). There are Public (open to all) or closed courses (just for your organisation). Please get in touch to find out more. COURSE CONTENT • Summarising Data - Subtotal/Outlines/3D formulas - Consolidate Function - Filter formula • Analysing Data with Pivot Tables - Working with data - Introduction to PowerPivot - Introduction to Power Query • Working with Advanced Formulas and Functions; - Nested IF / IFS function - CountIFS/SUMIFS/MAXIFS/MINIFS - Lookup & Switch functions - Date & Time functions - Year & Year Frac functions • Advanced Conditional Formatting - Highlighting entire row - Using lookups & dropdown lists • Advanced Visualisation (graphs) • Financial Functions • What-if-Analysis • Using Macros • Data Validation (dropdown from a dropdown) • Useful Tips and Other Features; - Protection of workbooks, worksheets and cells - Arrays & Auditing / Formula errors - Input Mask (e.g. hide all but last 4 digits of a credit card)
I am an experienced IT Trainer with over 20 years experience in teaching and tutoring. My speciality is in Microsoft Office software - Excel, Word, PowerPoint, Outlook but I also do training in other aspects of Microsoft such as Teams, SharePoint and Sway. Training is delivered in a friendly and relaxed way either face-to-face or online via Teams. Whether you are a complete beginner or are looking to upskill in Microsoft software, I will be able to help you.
The Women in Agriculture Practical Training Fund has been established by Scottish Government to support the personal development of women, providing them with additional skills to progress their careers and employment opportunities in Scottish agriculture beyond their current role.
The Next Generation Practical Training Fund has been established by Scottish Government with an aim to support those relatively new to agriculture, by providing the opportunity for skills development and training on the practicalities of agricultural practice as well as wider business and sustainability skills, in order to help them secure, sustain and progress their careers.