Microsoft Excel - Advanced

Microsoft Power BI is a data analytics and visualization tool that allows you to easily build reports and dashboards with interactive visualizations. Connect to and visualise any data using the unified, scalable platform for self-service and enterprise business intelligence (BI) that’s easy to use and helps you gain deeper data insight.

This 1-Day course is designed to help attendees understand and use Microsoft Power BI in a practical and hands-on way, performing learning exercises to help prepare them to develop and style their own Power BI dashboards.

Microsoft Power BI is a powerful data visualization tool that allows users to connect to, visualize and share any data, gaining deeper insights. This 2-day advanced course is designed to help attendees become expert users in Power BI.

A course that will provide you with what you need to consider when setting up a new business.

In this course, participants will be introduced to Excel macros and then develop a deeper understanding of advanced and custom macros including an introduction to VB coding for macros. Excel macros allow you to automate repetitive tasks and streamline your work processes.

This course enables delegates to identify signs of stress in their team members; discuss the employee’s stress triggers with them; and agree individual strategies to be reviewed at a later date.

This course introduces the essential principles and practices of effective project management. This course can also be offered as a cohort (group) booking, if interested in a cohort booking to contact training@forthvalley.ac.uk

The goal of this course is to teach participants how to build advanced charts in Microsoft Excel that are easy to read, interactive, and dynamic. The focus will be on creating charts that effectively tell a story about the data and provide additional insights to the reader. This course can also be offered as a cohort (group) booking, if interested in a cohort booking to contact training@forthvalley.ac.uk

Microsoft Excel is a spreadsheet application developed by Microsoft that is widely used for data analysis, calculation, and visual representation. This introductory course will cover the basics of Microsoft Excel and help you to get started with the programme.

In this course, participants will delve into the powerful features of Microsoft Excel pivot tables. From the basics of pivot tables to advanced features such as custom groupings and calculated fields, participants will learn how to effectively analyse and visualize their data. The course will also introduce Microsoft Power Pivot, offering even more options for data analysis. Note: Our advanced Excel courses are regularly updated to include the latest AI releases and best practice.

Microsoft Excel is a powerful tool for data analysis that is widely used in many industries. In this course, you will learn how to use Excel to organize and analyse data, create reports, design charts, and make data-driven decisions. You will also learn how to use Excel's built-in features to manipulate data in Power Query

This intermediate-level workshop is designed to help participants take their Excel skills to the next level. The course will focus on shortcuts for navigation, selection, and commands, as well as the application of exciting formulas to save time and improve efficiency. Participants will also learn how to protect their worksheets and workbooks, apply data validation techniques, manipulate text data through formula, and link cells, worksheets, and workbooks for dynamic automatic reporting.

Mental health is a vital part of overall wellbeing and plays a central role in how we live and work. This one-day workshop provides practical knowledge and tools to help you better understand mental health, recognise the signs of common issues, and respond appropriately in the workplace.

This course is for whole teams to learn together what is needed to collectively build their resilience. There is no one blueprint… teams are as individual as…well individuals! In a relaxed, fun and informal environment participants will hear the latest research on this topic.

With Power Query and Power Pivot in Excel, you'll spend less time manipulating data, and more time driving impact. Whether it's small data sets or large ones with up to millions of rows, in this course you will learn how you can connect, clean, analyse, and share your data faster using Power Query and Power Pivot. Note: This course is regularly updated to include the latest relevant AI releases and best practice.

Conflict is a natural part of working life, but when left unresolved it can damage relationships, lower morale, and impact performance. This one-day workshop equips you with the insight and practical tools to better understand the roots of conflict, recognise your own response style, and apply effective strategies to manage and resolve disagreements constructively.

This course provides an in-depth exploration of the principles and practices involved in managing supply chains effectively. Students will learn about the end-to-end process of sourcing, production, logistics, and distribution of goods and services. This course can also be offered as a cohort (group) booking, if interested in a cohort booking to contact training@forthvalley.ac.uk

This course explores the principles and practices of innovation and entrepreneurship, equipping students with the tools to identify opportunities, develop innovative solutions, and launch successful ventures.

This practical one-day workshop helps managers develop the skills and confidence to balance their dual roles as both leaders and mentors. Participants will learn how to listen and question effectively, set meaningful goals, and apply proven coaching and mentoring techniques to support team members’ growth.

This one-day workshop equips participants with the skills and confidence to effectively manage challenging people, situations, and conversations in the workplace. You will explore why difficult interactions arise, how to understand both what is being said and what is left unsaid, and how to approach these moments with clarity and professionalism.

Get an overview of popular social media tools – and how best to capitalise on their reach.

It's the most important job for any leader: managing your people and helping them develop and thrive. But how do you create a positive culture that encourages growth and positive behaviour? And what do you do if - despite all your best efforts - an employee just isn't performing well or whose behaviour is not in alignment to company policy?