2581 Courses

Course Objectives At the end of this course you will be able to: Do advance Table design Do advance Query design and Action Querys Do advance Form design with the use of macros and buttons Export and import data to and from different sources. 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Advanced Table Design Advanced Field Properties Table Properties Advanced Query Design Advanced Naming Conventions Join Tables in Queries Manage Query Joins Use Self-Joins in Queries Summarise Data in Queries Parameter Queries Action Queries Crosstab Queries Advanced Form Design Create Subforms and Linked Forms Form Controls Command Buttons Form Properties Interface, Start-Up and Navigations Forms Working with Macros Create Single Macros Run Macros Work with Sub Macros Use Conditional Macros Run Macros from Buttons Assign Macros to Events Extending Data Reach Import Data Export Data Work with Linked Tables Managing Databases Object Dependencies Database Documenter Performance Analyzers Regular Management of a Database Access Database Security Who is this course for? Who is this course for? The course is aimed at all users who would like to obtain the necessary skills to create advanced table, query, form and reports as well as to automate tasks with the use of macros. Career path Career path Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

This course will allow you to explore the potential of self-service business intelligence using Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, to create Visualizations, and publish Reports to different platforms . Course Objectives At the end of this course you will be able to: Connect to data from different sources. Use the Query Editor Perform Power BI desktop data Shaping and Transformation. Create Power BI desktop Modelling. Create Power BI desktop Visualizations and Reports. ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level and Business Intelligence. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Introduction to Power BI Power BI Jargon explained A quick look at Power BI Desktop A quick look at the Power BI service Helpful resources Power BI and Excel Introduction to using Excel data in Power BI Upload Excel data to Power BI Import Power View and Power Pivot to Power BI Getting started with Power BI Desktop Overview of Power BI Desktop Accessing Help and Helpful resources Connect to data sources in Power BI Desktop Shaping and Transforming Data with Query Editor Introduction to the Query Editor Data Sources Power BI Desktop can Connect to Introduction to Steps and M code Combining Data Using Merge and Append Queries Data Type Properties Working with Delimiters Clean and transform your data with the Query Editor Text Specific Transformation Tools Number Specific Transformation Tools Date Specific Transformation Tools Split and Merge columns Creating an Index Column Adding Conditional Columns Columns From Examples Grouping and Aggregating data Pivoting and Unpivoting Using filters Modeling the data Introduction to modeling your data How to manage your data relationships Create calculated columns Optimizing data models Create calculated measures Show Values As and Quick Measures Create calculated tables Explore your time-based data Introduction to DAX DAX calculation types DAX functions Visualizations Introduction to visuals in Power BI Create and customize simple visualizations Modify colors in charts and visuals Shapes, text boxes, and images Page layout and formatting Group interactions among visualizations Visual hierarchies and drill-down Using custom visualizations Create a KPI Visualization Geo-Data and Maps Reports, Publishing and Sharing Introduction to the Power BI service Quick insights in Power BI Create and configure a dashboard Ask questions of your data with natural language Create custom Q&A suggestions Share dashboards with your organization Introduction to content packs, security, and groups Publish Power BI Desktop reports Print and export dashboards and reports Create groups in Power BI Use content packs Update content packs Publish to web Who is this course for? Who is this course for? This course facilitates you with knowledge on the potential for Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, and to create Visualizations, and publish Reports to different platforms. Requirements Requirements Before attending this course, delegates should have: - A general knowledge of database concepts (fields, records and relationships) - Familiarity with Excel. Career path Career path Business Intelligence Data Analysis ETL & Data Warehousing

Customer Service - Getting it Right - 1 day training course delivered in Nottingham Enables participants to review and explore the true meaning of “excellent customer service”. It focuses on the challenges – and rewards of managing both internal and external customers effectively face to face and over the telephone.

From Friend to Supervisor – establishing authority 1 day training course delivered in Nottingham Designed to provide participants with the techniques and tactics to establish authority within the supervisory role whilst maintaining good relationships with those you manage, making it easier to clarify expectations and manage performance.

Pedicure putting your best foot forward. Pedicures are not just for beautiful coloured nails, they are a full foot service for everyone.

Overcome social awkwardness and social anxiety the fast, fun and easier way. DO YOU find yourself drying up or going blank when under pressure, or get tongue-tied when someone makes a smart remark? One of the reasons that you dry up or get tongue-tied – is because you are programmed to go into your head and try to think of something to say. Most of us have become left-brain dominant because of the way we’ve been educated and we don’t know how to activate our powerful and more creative right-brain. This is why the "I Don't Know what to Say" Improvisation Course is so effective at overcoming social difficulties. It gives you access to your spontaneous right-brain, and in fact, enables you to operate from both right and left-brain together. It is probably one of the fastest and most effective ways of building verbal confidence as well as liberating you on all sorts of levels.

Time Management - 1 day training course delivered in Nottingham This course examines how time is used at work and identifies good practice to get your role under control! It helps delegates to identify “lost” time at work and to plan and prioritise tasks to make best use of time and enhance productivity.

Harness the Power of your People – Appraisal Skills for Managers 1 day training course delivered in Nottingham Covers the core skills for conducting staff appraisals. Suitable for those who may be new to appraising staff performance, or for those who are more experienced but feel they would like a refresher to update their skills and knowledge of current techniques.

Recruitment & Selection – how to recruit the right staff 1 day training course delivered in Nottingham suitable for those embarking upon recruitment for the first time, and for more experienced recruiters who wish to update their skills and knowledge of current good practice. For business owners, managers and those who are required to recruit and select staff into their organisation.

Managing Poor Performance 1 day training course delivered in Nottingham Designed for managers, team leaders & Supervisors who have had little or no formal training in employment law or performance management. It is also a helpful refresher for more experienced managers to bring them up to date on legislation and procedural changes, and to check their methods against best practice.