This Microsoft Access course is for delegates who have sound skills in the use of MS Access and are now ready to expand their knowledge into some of the more specialised and advanced features of the software. This course will provide delegates with the skills needed to create complex queries, create macros to automate tasks, enhance forms and reports and use the Access programming language Visual Basic for Applications (VBA), enabling delegates to really take control of their databases.
Business Intelligence - Manage and Present Data Courses
- Filter activated Remove filter
- Showing favourite courses only Remove filterGo to favourites
-
-
Private Courses Ask a question about this course -
Access Essentials An Introduction to Database Design Course
-
- 2 Days
- Private courses available
View Full CourseThis Access course enables delegates to progress from the one level databases associated with holding data in Microsoft Excel, to multiple table relational databases, covering all the basics including the advantages and disadvantages. This course is a perfect starting point for a future in data manipulation.
Private Courses Ask a question about this course -
-
Crystal Reports Level 1 Course
-
- 2 Days
- Private courses available
View Full CourseDuring this Crystal Reports course, delegates will learn the basics of report creation, from linking the report to the requisite data source, to distributing the report to others. Delegates will also learn about sorting, grouping, linking, basic formula creation and working with Crystal Report experts.Private Courses Ask a question about this course -
-
Private Courses Ask a question about this course -
Excel Analysing and Presenting Data with Dashboards and Pivot Tables Course
-
- 1 Day
- Private courses available
View Full CourseThis outline below contains an overview of a wide range of features within Excel that when used together can be used to create interactive visual reports and dashboards. The course will show delegates how these features can be used individually to present data but can also be used in combination to make powerful and insightful reports.
The course content has been pulled from a mix of our Excel courses, some content will be recapped to ensure all delegates are at the same level as they are used in conjunction with each other to effectively present data and build reports.Private Courses Ask a question about this course -
-
Excel Level 1 Course
-
- 1 Day
- Private courses available
View Full CourseMicrosoft Excel is a spreadsheet program that can be used for storing, organising and manipulating data.
This Excel introductory course will enable delegates to gain a good general understanding of the main features of Microsoft Excel, giving them the ability to produce standard spreadsheets, create formulae and format and print spreadsheets.Private Courses Ask a question about this course -
-
Excel Level 2 Course
-
- 1 Day
- Private courses available
View Full CourseIn Microsoft Office Excel Level 1, delegates created, edited, formatted, and printed basic spreadsheets. This course will enable delegates to streamline repetitive tasks and display spreadsheet data in more visually effective ways. The target students for this course are students who desire to gain the skills necessary to create spreadsheets from scratch using more advanced functions and formulas, sort and filter data, analyse data and present data in visual and vibrant ways.Private Courses Ask a question about this course -
-
Excel Level 3 Course
-
- 1 Day
- Private courses available
View Full CourseThis course will benefit those who are already up to speed with Microsoft Excel but would now like to automate some common tasks and apply advanced analysis techniques to more complex data sets. This Excel course is aimed at anyone desiring to gain the skills necessary to create macros, audit and analyse worksheet data, create Excel PivotTables and Excel PivotCharts, use lookup tables and import and export data.Private Courses Ask a question about this course -
-
Microsoft Power BI Desktop Course
-
- 2 Days
- Private courses available
View Full CoursePower BI Desktop is part of the suite of tools from Microsoft which enable data to be analysed and published from a variety of sources.
With Power BI Desktop, you get a report authoring tool that enables you to connect to and query data from different sources using the Query Editor. From the datasets you build with Query Editor you can create Reports and Visualizations or dashboards within Power BI Desktop. Reports can then be published.
This course covers the use of Power BI Desktop to connect to data, create Visualizations, query the data and publish reports.
This course does not cover MS Power BI Pro, Power BI accessed via Office 365 or SharePoint Services.
Private Courses Ask a question about this course -
-
Private Courses Ask a question about this course -
You don't seem to have any favourites stored yet.
To add a favourite, please click on the heart next to any course in the course lists or in the right menu on a course page.
Please note if you delete your cookies, your favourites will disappear.
We are here to help you find the right training for you, please click here to contact us online or give us a call on 0191 377 8377
-
No results found on this page, searching our other courses
"Thoroughly enjoyed this course!"
J.M. LSL Property Services, Excel Level 2
"Thank you very much very helpful training. Great environment and lovely lunch."
S. DTV CRC, Microsoft Project Essentials
Which part of the course did you find particularly valuable
"That it is important to not be as strict on the rules and regulations and to also use rapport. To review experience personally to learn from them."
M.W. Murray Plate Group Ltd, Stepping up to Management
"Brilliant from start to finish."
E.D. Wave, Adobe InDesign Level 1
Which part of the course did you find particularly valuable
"All useful particularly graphs, making tables and copying formula"
G.H. Capstone Foster Care, Excel Level 1
Are there any aspects of the course which you feel require improvement
"I think the course was filled with great content and the trainer was very good. Extremely engaging."
S.O. Egger UK, Excel Level 2
"All aspects of the training were valuable"
D.T. Watmos, Outlook Overview and MS Teams for Hosts
Following this training what are you going to do differently
"I will be using excel in a completely different way. But data validation is going to really improve my efficiency. And then conditional formatting is something I think I will be able to use in all parts of my life."
N.B. Public scheduled, Excel Level 2
Which part of the course did you find particularly valuable
"Picture insertion repositioning with text"
A.P. Teesworks SC, Word Essentials
Are there any aspects of the course which you feel require improvement
"No, excellent pace and plenty of hands on experience"
J.H. Breedon Northern Ltd, Crystal Reports Level 1
Following this training what are you going to do differently
"Lots! Lots of little shortcuts to remember and use, I will definitely apply all that I've learnt, I knew the basics of many of the functions but great to get more training on them from a pro because I am mainly self taught."
V.K. , Excel Level 3
Any other comments or recommendations
"Being able to do this course remotely was a huge advantage"
J.H. NHSBSA, Microsoft Power BI Desktop
"Covered at an appropriate pace to accommodate all learners in the group"
G.T. Public course, Microsoft Power BI Desktop
"Went away with a good understanding of the software as I have never used it before"
T.O. Cyclife Groupe EDF, Microsoft Project Essentials
"Great trainer learned a lot that I will be sure to remember"
S.W. Great North Air Ambulance Service, Time Management
Find your courses and tailor it to you. We are here to help you find the right courses for your needs. courses in : with private and/or public scheduled courses, you can attend your courses in .