Microsoft Power Bi – Advanced

This advanced-level Excel workshop is designed for individuals who are already proficient in the basics of Microsoft Excel and want to take their skills to the next level. This course can also be offered as a cohort (group) booking, if interested in a cohort booking to contact training@forthvalley.ac.uk

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 visualize 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.

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.

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. This course can also be offered as a cohort (group) booking, if interested in a cohort booking to contact training@forthvalley.ac.uk

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. Note: Our advanced Excel courses are regularly updated to include the latest AI releases and best practice.

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.

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.

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