• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

61 Courses in Cardiff

Power BI - advanced (1 day) (In-House)

By The In House Training Company

This course starts with data transformation strategies, exploring capabilities in the Power Query Editor, and data-cleansing practices. It looks at the Advanced Query Editor to view the M language code. This course focuses on advanced DAX measures that include filtering conditions, with a deep dive into time intelligence measures. Like the M query language, DAX is a rich functional language that supports variables and expression references. This course also looks at the creation of dynamic dashboards and incorporates a range of visualisations available in Power BI Desktop and online in the AppSource. The course finishes with a look at setting up end user level security in tables. 1 The query editor Split by row delimiter AddDays to determine deadlines Advanced query editor 2 Fuzzy matching joins Matching inconsistencies by percentage Matching with transformation table 3 Logical column functions Logical functions IF, AND, OR Using multiple conditions Including FIND in functions 4 Editing DAX measures Make DAX easier to read Add comments to a measure Using quick measures 5 The anatomy of CALCULATE Understanding CALCULATE context filters Adding context to CALCULATE with FILTER Using CALCULATE with a threshold 6 The ALL measure Anatomy of ALL Create an ALL measure Using ALL as a filter Use ALL for percentage 7 DAX iterators Anatomy of iterators A closer look at SUMX Using RELATED in SUMX Create a RANKX RANKX with ALL 8 Date and time functions Overview of functions Create a DATEDIFF function 9 Time intelligent measures Compare historical monthly data Create a DATEADD measure Creating cumulative totals Creating cumulative measures Visualising cumulative totals 10 Visualisations in-depth Utilising report themes Create a heatmap Comparing proportions View trends with sparklines Group numbers using bins Setting up a histogram 11 Comparing variables Visualising trendlines as KPI Forecasting with trendlines Creating a scatter plot Creating dynamic labels Customised visualisation tooltips Export reports to SharePoint 12 User level security Setting up row level security Testing user security

Power BI - advanced (1 day) (In-House)
Delivered in Harpenden or UK Wide or OnlineFlexible Dates
Price on Enquiry

Online Options

Show all 7523

Rally Navigation - Regularity for Improvers

By Rally Navigation Training Services

Historic Road Rallying training webinar on Regularity focusing on Average Speed Table style regularities.

Rally Navigation - Regularity for Improvers
Delivered Online + more
£30

Real Estate Analyst (Investment Cash Flow Modelling in Excel)

4.3(5)

By Bayfield Training

The Real Estate Analyst course has been taught non-stop to global real estate firms over the last 25 years, and is without doubt the core financial modelling training in your career portfolio. Whether you have an upcoming financial modelling test for a new job or an APC exam, the Real Estate Analyst course is the choice for you.

Real Estate Analyst (Investment Cash Flow Modelling in Excel)
Delivered in person or Online + more
£1,750

Quarterly Mental health First Aider Facilitated Forum

By Mindmaps Wellbeing

Providing Guidance & Support for MHFAiders: giving reassurance they are not alone. Our MHFAider guidance & support forums are tailored to provide MHFAiders with the clarity they need to excel in their role. We believe it's important to offer a safe space for MHFAiders to discuss their role, while staying up to date with the latest best practices and information. Mental Health First-Aiders and Champions forum for open discussions, guidance, support, and focus topic learning with a registered Mental Health Nurse.

Quarterly Mental health First Aider Facilitated Forum
Delivered Online + more
£40

Power Excel 1 (the essentials)

4.3(6)

By dbrownconsulting

Master Excel to catapult your productivity skills with this online course. Go from Beginner to Pro in Excel

Power Excel 1 (the essentials)
Delivered OnlineJoin Waitlist
£600

Excel - Excel Essentials and Formulas

By Nexus Human

Duration 1 Days 6 CPD hours This course is intended for To ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should also be comfortable working in the Windows environment and be able to manage information on their computers. Overview Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyse the data that is critical to the success of your organisation. This course is intended for those who wish to gain the foundational understanding of Excel that is necessary to create and work with electronic spreadsheets. Excel can help you organise, calculate, analyse, revise, update, and present your data. Getting Started with Excel Navigate the Excel User Interface Use Excel Commands Create and Save a Basic Workbook Enter and Edit Cell Data Fill Cells with Series of Data (AutoFill and Flash Fill) Use Excel Help Performing Calculations Create Worksheet Formulas Insert Functions and use Autocomplete Reuse Formulas and Functions Create an Absolute Reference Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows Move and Copy Data between Cells Search for and Replace Data Use Spellcheck and Proofing Formatting a Worksheet Apply Text Formats Apply Number Formats Align Cell Contents Apply and Copy Cell Styles Apply Basic Conditional Formatting Printing Workbooks Preview and Print a Workbook Controlling Page Layout Adding Headers and Footers Set Print Titles and Print Ranges Managing Workbooks Manage Worksheets Insert and Delete Worksheets Manage Workbook and Worksheet Views Manage Workbook Properties

Excel - Excel Essentials and Formulas
Delivered OnlineFlexible Dates
£197

77-727 Microsoft Excel Certification - MOS Excel Core Exam

By Packt

MOS Core Excel - 77-727 : Complete Techniques for Exam Success

77-727 Microsoft Excel Certification - MOS Excel Core Exam
Delivered Online On Demand6 hours 15 minutes
£87.99

Mastering Excel

4.9(9)

By Sterling Training

Performance and efficiency-enhancing Excel skills for everyday users.

Mastering Excel
Delivered OnlineJoin Waitlist
£275

Microsoft Excel Advanced 2019

By Packt

Learn and master Excel 2019 by learning advanced functions and formulas

Microsoft Excel Advanced 2019
Delivered Online On Demand8 hours 5 minutes
£69.99

Microsoft Excel in Depth (Virtual)

By IIL Europe Ltd

Microsoft Excel® in Depth (Virtual) This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses.This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables

Microsoft Excel in Depth (Virtual)
Delivered OnlineFlexible Dates
£850

Microsoft Excel Beginners 2019

By Packt

Discover Excel 2019 and become confident in using spreadsheets

Microsoft Excel Beginners 2019
Delivered Online On Demand7 hours 29 minutes
£74.99
1...567

Educators matching "Excel "

Show all 5
Safety Solutions Training Ltd.

safety solutions training ltd.

5.0(58)

Cardiff

Welcome to Safety Solutions Training Ltd., your trusted partner in comprehensive training programmes that prioritise safety in today’s dynamic world. Our team consists of highly experienced trainers, many of whom are recently retired police officers with extensive first-hand expertise. This exceptional background enables us to excel in Conflict Management, Lone Worker Personal Safety Training, County Lines, Gangs, and Knife Crime Safeguarding, Safeguarding Individuals Vulnerable to Violent Extremism, Dangerous Dogs Awareness, Safeguarding Vulnerable Children and Adults, and Managing Anti-Social Behaviour. We take immense pride in delivering top-notch, practical training solutions customised to meet the unique requirements of our valued clients. Our programmes are designed to empower individuals and organisations by identifying potential risks and implementing effective strategies to mitigate them. We strongly believe in a collaborative training approach, actively collaborating with our clients to ensure the delivery of the most impactful and relevant training possible. Committed to excellence, Safety Solutions Training Ltd. is dedicated to offering high-quality, practical, and cost-effective training solutions. Reach out to us today to discuss your training needs. Let our expertise assist you in maintaining safety and security amidst the challenges of our ever-changing environment. Stay safe and secure with Safety Solutions Training Ltd.