Boost your Digital skills with DGC

You may already be using Excel but at a fairly basic level. It was assumed that you already knew how it worked so you’ve never had any training to structure your knowledge. This course will give you the confidence to explore the many facets of the world's most widely used spreadsheet programme.

This one-day online course aims to give the Excel user all the basic skills that they need to be able to use Excel with confidence.

Tips are included on how to use Excel efficiently, and you will learn how to layout spreadsheets and create charts.

Course Content

This online course is tutor-led will cover the following areas:

• Excel familiarisation;
• Understanding columns, rows and Excel navigation;
• Entering text and numbers;
• How to create formula (includes order of operation);
• How to use autofill;
• Using relative and absolute addressing;
• How to format information in a spreadsheet;
• Using auto sum and aggregate functions;
• How to create charts;
• Chart editing and formatting;
• How to save workbooks and
• Creating PDFs from workbooks.

Microsoft Excel is enormously powerful and flexible and has a reputation as the most widely used spreadsheet application.

Very few users venture beyond the basics and as a result don’t exploit the benefits of this formidable application.

This one-day course seeks to improve proficiency with Microsoft Excel and is suitable for those who can create and format simple worksheets and use basic formulae. It includes working with multiple worksheets, adding database capabilities, split screens and more Excel functions. It also takes charting a step further and introduces passwords to Excel.

Course Content

This online course is tutor-led will cover the following areas:

• Creating, renaming and deleting worksheets;
• Navigating between worksheets;
• Using 3D formulas;
• Using links in Excel;
• How to edit existing charts;
• Select and format chart elements;
• Using chart elements and options;
• Creating sparklines;
• How to use IF function;
• How to use the VLOOKUP and HLOOKUP functions;
• How to name cells and use named cells;
• Sorting and filter tables;
• Introduction to data forms;
• Using database functions and
• An introduction to pivot tables.

This one-day course takes the skills learnt in the Introduction to Excel and Intermediate Excel courses and moves to look at some more advanced Excel tools. It is particularly suited to those who use Excel as a means of modelling data to find solutions to problems.

Course Content

This online course is tutor-led will cover the following areas:

• How to use scenarios;
• How to use the solver tool;
• Using spreadsheet auditing facilities;
• Creating conditional formats;
• Using data validation;
• Using the data analysis tools;
• Saving Excel templates and
• Introduction to creating and running macros.

Data analysis can help businesses change how they promote their products, engage with clients, and manage finances. It not only provides valuable insights into customer behaviour but can assist with reducing costs, driving revenue, and providing a one-of-a-kind customer experience that makes people stay.

This introductory course in data analysis using Excel is designed for those who use Excel regularly but at a peripheral level and wish to enhance their skills.

In this two-hour tutor-led course, you will learn how to perform data analysis using Excel's most popular features.

By the end of this course, you will be able to:

• use Excel tables effectively by filtering data and adding calculations;
• use multiple pivot tables and pivot charts to create a dashboard and
• filter data within pivot tables to drill down on your data to make better decisions

Course Content

This online course is tutor-led will cover the following areas:

•          Learn about Excel tables and their advantage over regular ranges.

•             Use a table to filter, sort and see totals.

•             See how calculations can be used to add columns to existing data in Excel tables.

•             Creation of your first pivot table.

•             Use of multiple pivot tables and pivot charts to create your first dashboard.

•             Connect multiple slicers to the pivot tables.

•             Explore in more depth the full power of pivot tables.

•             See how to filter the data shown in the pivot in many ways to achieve interesting subsets of the data.

This two-hour tutor-led course covers the essential skills in Power BI: extracting; transforming and loading data into a data model, then visualising it with a rich set of graphics, charts and dashboards.

Power BI is an effective business tool for small and medium sized businesses which can help you:

• analyse data so you can see which of your markets are thriving and where sales are sluggish;
• track sales growth in all, or a single market, quarter-wise, if necessary.
• see where expenditure is rising and
• help you figure out which products are selling well, and which ones are not getting a good response from your markets.

Pre-requisites

Attendees should have knowledge of Excel, with some familiarity with Excel Pivot Tables and Excel Functions like SUMIFS and VLOOKUP. People with Database, Programming, or other BI experience will be qualified for the course even if they do not have direct Excel experience.

By the end of this course, you will be able to:

• understand what Microsoft Power BI can do;
• install the Power BI desktop app;
• import data sources into Power BI desktop and connect to Excel and other data locations;
• work with visualisation panes to create reports and
• sort and format data.

Course Content

This online course is tutor-led will cover the following areas:

What is Microsoft Power BI?

• Understanding the Power BI environment.
• Installing Power BI Desktop.

Understanding Data Sources in Power BI Desktop

• Importing a variety of data sources into Power BI Desktop.
• Connecting to Excel workbooks, Access databases, CSV Files and other data locations.

Exploring Power BI Desktop

• Working with the fields and visualisation panes.
• Using report view to create visualisations.
• Using data view to sort and format data.

With cybercrime on the increase and the majority of businesses across the region stating that they do not feel fully equipped to deal with cyber security threats** this course will provide you with an understanding of common cyber security threats and how to mitigate them.

And as almost half of all data breaches involve small and medium sized businesses* it is important to take steps to keep your business and employees safe online.

By the end of the course you will be able to:

• understand and identify threats such as Malware, Phishing, Ransomware, and internal and external threats;
• understand the consequences for your business and

• be able to implement the correct defence and mitigations, such as external defences, perimeter defences, internal defences, reducing attack surfaces, patching and updates, backups, and pen testing.

Course Content

This online course is tutor-led will cover the following areas:

Threats

• Including but not limited to malware, phishing, denial of service, hacking (state and non-state), internal and external threats, ransomware, resource theft

Consequences

• Including but not limited to reputational damage, legal consequences and GDPR.

Defences

• Including but not limited to external defences, perimeter defences, internal defences, the “onion” model and backups.

Mitigations

• Including but not limited to reducing attack surfaces, patching and updates, backups, pen-testing.

Training and education

• Including importance and methods.

The Future

• Where are we going, what may happen and where to learn more?

Q&A

• Questions are taken throughout the course.

* Statistic by Cybersecurity Magazine

Digital tools are progressing at an unprecedented rate both in our personal and business lives, and it’s easy to find ourselves behind the times and using dated methods that no longer achieve the best results.

This is particularly true for managers and leaders, who need to adopt new processes and procedures from a technical aspect, but also in leading the individuals and the team.

This three-hour online course is tutor-led and gives you the opportunity to explore where changes in technology have impacted on your role as a manager and leader, and ensure you utilise the available tools to best advantage. Specific emphasis will be on communicating in a digital world.

By the end of this course you should be better able to:

• establish the digital tools that have impacted your business.
• explore the features, benefits and challenges of these tools for organisation, team and individual.
• consider how digital communication works for you in your role as a leader and manager both externally, and internally.
• appreciate the human impact of digital tools, and how to use these to ensure motivation and engagement for each individual in the team.
• identify other digital tools that may benefit your team.
• create a personal action plan.

This online course is tutor-led and will cover the following areas: 

• how to use a mouse and keyboard;
• how to log onto a computer;
• the Microsoft Windows interface;
• using the internet safely and security issues;
• file management;
• printing;
• sending emails and
• an introduction to Microsoft Word, Excel and PowerPoint.