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

3512 Dash courses delivered Online

Excel Pivot Tables, Pivot Charts, Slicers, and Timelines

4.5(3)

By Studyhub UK

Dive deep into the realm of Excel with our meticulously designed course on 'Excel Pivot Tables, Pivot Charts, Slicers, and Timelines'. Unlock the secrets of powerful data visualisation tools like Dashboards, Slicers, and Timelines, while mastering the art of reporting by varying time intervals. Whether you wish to streamline your reporting tasks or augment your analytical capabilities, this course will provide you with the tools and techniques to extract insights from data seamlessly. Highlights of the Dynamic Excel Gantt Chart and Timelines : Discover the secrets of finding the key to doing your best work Understand how to reach your most productive level based on scientific research and principles Explore the hidden productivity recipes of professionals and the most successful people in the world Develop a routine for greater productivity both at home and at work Understand the time management strategies for managing your time when dealing with multiple urgent tasks Discover how to achieve higher productivity by making just a few simple changes Learn simple yet highly effective productivity hacks that you can apply in minutes or less Explore science-backed advice for developing a 'Productivity Mindset' and beat procrastination Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Who is this Course for? Data analysts aiming to bolster their data visualisation techniques. Professionals in finance, sales, and marketing looking to generate detailed reports. Researchers keen on presenting data in an insightful manner. Students aspiring to enhance their data representation and analysis skills. Project managers wanting to make data-driven decisions How is the course assessed? To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion. Will I receive a certificate of completion? Upon successful completion, you will qualify for the UK and internationally-recognised certification and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15. Requirements The Dynamic Excel Gantt Chart and Timelines is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16. Career Path Data Analyst: £30,000 - £50,000 Financial Analyst: £35,000 - £55,000 Sales Analyst: £28,000 - £47,000 Market Researcher: £24,000 - £45,000 Data Visualization Specialist: £32,000 - £52,000 Business Intelligence Analyst: £38,000 - £60,000 Course Curriculum Excel Pivot Tables, Pivot Charts, Slicers, and Timelines Getting started with your Pivot Table 00:04:00 Drill Down 00:01:00 Managing the Field List 00:02:00 Changing the Calculation type with Value Field Settings 00:06:00 Growing your Pivot Table with Multiple Fields 00:04:00 Formatting the Pivot Table 00:05:00 Sorting and Filtering the Pivot Table 00:03:00 Creating a Dashboard with Slicers, Timelines and Pivot Charts 00:09:00 Reporting by day, month, qtr, or year within the Pivot Table 00:04:00 Refreshing the Pivot Data with new data 00:03:00 Adding your own calculations into the Pivot Table 00:03:00 The power of the Filter Section in the Pivot Table 00:04:00 PowerQuery 00:12:00 PowerPivot 00:21:00 Assignment Assignment - Excel Pivot Tables, Pivot Charts, Slicers, and Timelines 00:00:00

Excel Pivot Tables, Pivot Charts, Slicers, and Timelines
Delivered Online On Demand1 hour 21 minutes
£10.99

Adobe InDesign CC Advanced

5.0(1)

By Course Gate

Learn how to create posters, newspapers design, magazines design, brochures, presentation, books, and ebooks through our Adobe InDesign CC Advanced course to pursue the best position in this role. The contents of the course instruct you to learn all these aforementioned aspects exponentially and easily. The course teaches you how to use InDesign scripts to create multiple designs using color, inserting images and videos, changing forms of letters and many more things. It also guides you on how to create image girds, large table based design, and illustration using theme and color mode. Furthermore, it teaches you different types of styles so that you can distinguish the pros and cons in order to teach you the easiest way of graphic design However, learning this course, you can start your career as a design master effectively. Who is this course for? Adobe InDesign CC Advanced is suitable for anyone who wants to gain extensive knowledge, potential experience and professional skills in the related field. This course is CPD accredited so you don't have to worry about the quality. Requirements Our Adobe InDesign CC Advanced is open to all from all academic backgrounds and there is no specific requirements to attend this course. It is compatible and accessible from any device including Windows, Mac, Android, iOS, Tablets etc. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Introduction Introduction 00:04:00 Advanced Document Setup Saving to Previous Versions 00:02:00 Saving Templates 00:03:00 Using Different Page Sizes 00:03:00 Sectioning for Page Numbering 00:07:00 Working with Text Flow Using Breaks 00:06:00 Working with Tabs 00:05:00 Creating Jump Lines 00:05:00 Auto-sizing Text Frames 00:00:00 Using Text on a Path 00:08:00 Working with Text Outlines 00:03:00 Advanced Text Options Replacing Fonts 00:04:00 Changing Text Formatting 00:04:00 Applying Character Formatting 00:00:00 Using Bullets and Numbering 00:04:00 Understanding Types of Spaces 00:05:00 Understanding Types of Dashes 00:06:00 Using Grep 00:04:00 Editing AutoCorrect 00:03:00 Beyond the Basics - Text Styles Loading Styles 00:03:00 Redefining Styles 00:03:00 Creating Group Styles 00:03:00 Using Nested Styles 00:05:00 Using Hyphenation and Justification 00:05:00 Understanding Keep Options 00:02:00 Breaking a Link to a Style 00:02:00 Advanced Place Options Using Place Text Options 00:06:00 Using Place Image Options 00:10:00 Placing Adobe Illustrator Files 00:03:00 Using Metadata Caption 00:06:00 Placing InCopy Documents 00:05:00 Using Anchored Objects 00:05:00 Illustration in InDesign Using the Pen Tool 00:08:00 Using the Direct Selection Tool 00:02:00 Understanding Pathfinder Panel Basics 00:07:00 Using Advanced Alignment 00:04:00 Organizing Swatches Using Color Groups 00:03:00 Loading Swatches 00:01:00 Loading the CC Libraries 00:05:00 Converting Tables Converting a Table to Text 00:02:00 Converting Text to a Table 00:02:00 Working with Headers and Footers 00:04:00 Embedding Cell Styles into Table Styles 00:05:00 Working with Long Documents Creating Books 00:04:00 Developing a Table of Contents and Bookmarks 00:09:00 Creating Interactive Elements Inserting QR Codes 00:05:00 Creating Bookmarks 00:04:00 Using Hyperlinks 00:05:00 Applying Page Transitions and Exporting to PDFs 00:05:00 Conclusion Course Recap 00:03:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Adobe InDesign CC Advanced
Delivered Online On Demand3 hours 32 minutes
£11.99

Microsoft Power BI - Master Power BI in 90 Minutes!

4.5(3)

By Studyhub UK

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special Microsoft Power BI - Master Power BI in 90 Minutes! Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The Microsoft Power BI - Master Power BI in 90 Minutes! Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Microsoft Power BI - Master Power BI in 90 Minutes! Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Microsoft Power BI - Master Power BI in 90 Minutes! Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Microsoft Power BI - Master Power BI in 90 Minutes!? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Microsoft Power BI - Master Power BI in 90 Minutes! there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Microsoft Power BI - Master Power BI in 90 Minutes! course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Microsoft Power BI - Master Power BI in 90 Minutes! does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Microsoft Power BI - Master Power BI in 90 Minutes! was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Microsoft Power BI - Master Power BI in 90 Minutes! is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Power BI - Introduction Overview of Power BI Course 00:02:00 Power BI Intro 00:03:00 Power BI High Level Flow 00:02:00 Install and Sign Up 00:03:00 Power Query Intro 00:05:00 Power Pivot Intro 00:01:00 Power View Intro 00:02:00 Your First Power BI Dashboard Big Picture 00:02:00 Get Data 00:13:00 How to Get More Data 00:01:00 Modelling Data 00:05:00 Adding Relationships Manually 00:02:00 Visualization 00:05:00 Visualization Customization 00:01:00 More Visualizations 00:02:00 Visualization Format and Analytics 00:03:00 Ask a Question 00:02:00 Your Advanced Power BI Dashboard with Real Live Data Real World Example 00:06:00 Get Data 00:13:00 Modelling Data 00:05:00 Visualization with multiple charts 00:11:00 Publishing 00:05:00 Power BI Website 00:08:00 Course Bounses FINAL 00:01:00 Resources Resources - Microsoft Power BI - Master Power BI in 90 Minutes!@ 00:00:00

Microsoft Power BI - Master Power BI in 90 Minutes!
Delivered Online On Demand1 hour 43 minutes
£10.99

Enterprise Resource Planning (ERP) Training

4.7(26)

By Academy for Health and Fitness

Deal Price is Active; Offer Ends Soon; Hurry Up!! Are you looking to improve your current abilities or make a career move? Our unique Enterprise Resource Planning (ERP) Course might help you get there! Expand your expertise with high-quality training - study the Enterprise Resource Planning (ERP) and get an expertly designed, great value training experience. Learn from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career through the Enterprise Resource Planning (ERP) online training course. This Award in Enterprise Resource Planning (ERP) at QLS Level 2 course is endorsed by The Quality Licence Scheme and accredited by CPDQS (with 60 CPD points) to make your skill development & career progression more accessible than ever! Why Prefer This Enterprise Resource Planning (ERP) Course? Opportunity to earn certificate a certificate endorsed by the Quality Licence Scheme & another accredited by CPDQS after completing the Enterprise Resource Planning (ERP) course Get a free student ID card! (£10 postal charge will be applicable for international delivery) Innovative and engaging content. Free assessments 24/7 tutor support. The Enterprise Resource Planning (ERP) course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the Enterprise Resource Planning (ERP) course, you will receive an instant e-certificate as proof of the comprehensive skill development and competency. Add these amazing new skills to your resume and boost your employability by simply enrolling on this Enterprise Resource Planning (ERP) course. With this comprehensive Enterprise Resource Planning (ERP) course, you can achieve your dreams and train for your ideal career. The Enterprise Resource Planning (ERP) course provides students with an in-depth learning experience that they can work through at their own pace to enhance their professional development. You'll get a Free Student ID card by enrolling in this Enterprise Resource Planning (ERP) course. This ID card entitles you to discounts on bus tickets, movie tickets, and library cards. Enrolling on the Enterprise Resource Planning (ERP) course will ensure that you land your dream career faster than you thought possible. Stand out from the crowd and train for the job you want with the Enterprise Resource Planning (ERP) program. Experts created the Enterprise Resource Planning (ERP) course to provide a rich and in-depth training experience for all students who enrol in it. Enrol in the course right now and you'll have immediate access to all of the Enterprise Resource Planning (ERP) course materials. Then, from any internet-enabled device, access the Enterprise Resource Planning (ERP) course materials and learn when it's convenient for you. Start your learning journey straight away with this Enterprise Resource Planning (ERP) course and take a step toward a brighter future! *** Course Curriculum *** Here is the curriculum breakdown of Enterprise Resource Planning (ERP) course: Enterprise Resource Planning (ERP) Course Section 01: Operations of an Economic Entity: Enterprise Resource Planning Operations of an Economic Entity: Enterprise Resource Planning The Hierarchical Perspective Enterprise Resource Planning ERP Technology's Role in Business Types of Information Systems Interrelations between Systems Functional IT Systems Section 02: Entrepreneurship Creativity & Innovation Enterprise Resource Planning: External Priorities Why ERP? Overall Implementation Requisites for ERP Challenges of ERP Implementation in Business Senior and Project Management Critical Factors for Successful ERP Implementation Implementation Steps ERP: Integration and Supply Chain Support Web Services Integration Options Market Information and Sales Orders Benefits of the Marketing Information System Customer Relationship Management Customer Relationship Management Functions Section 03: Enterprise Resource Planning: Internal Priorities ERP: HR Planning and Utilization What is an HRIS? ERP: Electronic Commerce - Accounting System Interface E-Commerce Supply Chain Management Solutions Problems in ERP and E-Commerce Integration Section 04: Operational Indicator, KPI's & Metrics Operational Indicator, KPI's and Metrics What is Metrics? Need for Metrics in Testing and Quality Analysis Metrics Continued What are Quality Metrics? Tips of Selection of Quality Metrics Lead, Spot & Lagged Indicators - Drive, Monitor & Report Indicators Lean Manufacturing and Agility Quantitative vs. Qualitative Indicators and Measurement Scope Section 05: Measurement and Presentation Tools Measurement and Presentation Tools Mechanisms of Success Monitoring, Evaluation and Reporting Balanced Scorecard Perspectives Strategy Mapping Balanced Scorecards vs. Dashboards Metrics Measurements: IT Systems in ERP Assessment Process You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam.Our expert trainers will assess your assignment and give you feedback after you submit the assignment. After passing the Award in Enterprise Resource Planning (ERP) at QLS Level 2 course exam, you will be able to request a certificate at an additional cost that has been endorsed by the Quality Licence Scheme. CPD 60 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Is This Enterprise Resource Planning (ERP) Course Right for You? Anyone interested in learning more about this subject should take this Enterprise Resource Planning (ERP) course. This Enterprise Resource Planning (ERP) will help you grasp the basic concepts as well as develop a thorough understanding of the subject. All are welcome to take this Enterprise Resource Planning (ERP) course. There are no prerequisites for enrolment, and you can access the course materials from any location in the world. Requirements The Enterprise Resource Planning (ERP) program does not require any prior knowledge; everyone may participate! This Enterprise Resource Planning (ERP) course is open to anyone interested in learning from anywhere in the world. Every student must be over the age of 16 and have a passion for learning and literacy. This 100% online course can be accessed from any internet-connected device, such as a computer, tablet, or smartphone. This Enterprise Resource Planning (ERP) course allows you to study at your speed and grow a quality skillset. Career path After completing this Enterprise Resource Planning (ERP) Course, you are to start your career or begin the next phase of your career in this field. Our entire Enterprise Resource Planning (ERP) course will help you to gain a position of respect and dignity over your competitors. The certificate enhances your CV and helps you find work in the field concerned. Certificates Certificate of completion Digital certificate - £10 Award in Enterprise Resource Planning (ERP) at QLS Level 2 Hard copy certificate - £79 Show off Your New Skills with a Certificate of Completion After successfully completing the Award in Enterprise Resource Planning (ERP) at QLS Level 2, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with a pricing scheme of - 79 GBP inside the UK 89 GBP (including postal fees) for International Delivery Certificate Accredited by CPDQS 29 GBP for Printed Hardcopy Certificate inside the UK 39 GBP for Printed Hardcopy Certificate outside the UK (International Delivery)

Enterprise Resource Planning (ERP) Training
Delivered Online On Demand3 days
£12

Car Maintenance and Safety Training

4.5(3)

By Studyhub UK

Overview Kickstart a successful career in the auto repair industry and learn how to service, maintain and repair vehicles, with this professional training course. The Car Maintenance and Safety Training has been designed by experts in the industry to provide learners with the best learning experience. You will gain valuable insight into the role and responsibilities of the role of a Car Mechanic, as well as the practical and theoretical knowledge you need to kickstart your career. Learn from the experts and save on car maintenance costs with this practical training qualification! Why buy this Car Maintenance and Safety Training? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Car Maintenance and Safety Training you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Car Maintenance and Safety Training does not require you to have any prior qualifications or experience. You can just enrol and start learning.  Prerequisites This Car Maintenance and Safety Training was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Car Maintenance and Safety Training is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Car Maintenance and Safety Training Module 1 Chapter 1: Safety Rules & Introduction to Tools 01:00:00 Chapter 2: General Maintenance 01:00:00 Chapter 3: Dashboard Indicator Lights 00:30:00 Chapter 4: Tires 01:00:00 Chapter 5: Internal Combustion Engines & Engine Oil 01:00:00 Chapter 6: The Cooling System 00:30:00 Module 2 Chapter 7: The Fuel System 00:30:00 Chapter 8: The Electrical System 00:30:00 Chapter 9: The Drive Train 00:30:00 Chapter 10: Brakes 00:30:00 Chapter 11: The Auto Repair Industry 00:30:00 Mock Exam Mock Exam - Car Maintenance and Safety Training 00:20:00 Final Exam Final Exam - Car Maintenance and Safety Training 00:20:00

Car Maintenance and Safety Training
Delivered Online On Demand8 hours 10 minutes
£10.99

Power Query and Power Pivot in Microsoft Excel: A Quickstart Guide

By Ideas Into Action

Power Query and Power Pivot in Microsoft Excel:  A Quickstart Guide   Course Description   Copyright Ross Maynard 2022   Course Description Power Query and Power Pivot are two tools available in Microsoft Excel. If you are serious about data analysis, then you need to know how to use these tools. This Quickstart guide will give you the skills you need to get started with these powerful features. The Power Query tool allows you to import external data and then modify it to meet your needs, before loading it into Excel. These editing tasks are all things you can do manually in Excel, but Power Query greatly speeds things up when you have a large volume of data. The Power Pivot tool allows you to connect multiple data tables in an extended pivot table. Power Pivot also introduces new analysis and query tools to further enhance data analysis. If data analysis is your thing, then this course will help you get up to speed with these feature-filled tools. Through screen-capture video, the course provides a step-by-step guide to the foundation skills needed to use both Power Query and Power Pivot effectively. The course is designed to make your first steps into Power Query easy and to build your confidence to use them on your own. Both Power Query and Power Pivot are also available in Microsoft Power BI – the data visualisation suite. Once you have learned how to use Power Query and Power Pivot in Excel with this course, you’ll have a head start in getting to grips with Power BI Get up to speed with Power Query and Power Pivot in Microsoft Excel with this Quickstart guide.     Key Learning Points  On completion of the course, delegates will be able to: Use Power Query to load data from an external source into Microsoft Excel Clean and manipulate external data before loading it into Excel Consolidate separate files with Power Query Update Excel tables with new data in the same format Use Power Query to “unpivot” report tables to prepare the data for analysis Explain the core functionality of Power Pivot Link data tables together in the Power Pivot data model Create pivot tables that draw data from several source data tables Create performance measures and new analysis in the Power Pivot data model Use the most popular DAX query language functions in Power Pivot     Curriculum Lesson 1: Power Query Quickstart Lesson 2: Consolidating Files with Power Query Lesson 3: Unpivoting a Table Lesson 4: Power Pivot Quickstart Lesson 5: Power Pivot – Adding Data and Functionality Lesson 6: Key DAX Functions for Power Pivot Lesson 7: The DAX CALCULATE Function Lesson 8: Key Learning Points     Pre-Course Requirements There are no pre-course requirements     Additional Resources Starter spreadsheets for each lesson are provided so that learners can follow the steps presented.     Course Tutor Your tutor is Ross Maynard. Ross is a Fellow of the Chartered Institute of Management Accountants in the UK and has 30 years’ experience as a process improvement consultant specialising in business processes and organisation development. Ross is also a professional author of online training courses. Ross lives in Scotland with his wife, daughter and Cocker Spaniel     Questions What is the main feature of Power Query? The ability to link data tables together to create pivot tables that allow data to be drawn from any and all of the source tables The ability to clean and manipulate large volumes of external data efficiently and to load the result into Microsoft Excel The removal of Microsoft Excel’s restrictions on file sizes and the number of rows of data allowed The ability to visualise data in dashboards and management reports     What is the main feature of Power Pivot? The ability to link data tables together to create pivot tables that allow data to be drawn from any and all of the source tables The ability to clean and manipulate large volumes of external data efficiently and to load the result into Microsoft Excel The removal of Microsoft Excel’s restrictions on file sizes and the number of rows of data allowed The ability to visualise data in dashboards and management reports     Which of the following actions cannot be performed within Power Query? Split text into multiple columns Trimming text and removing spaces Creating calculated columns using DAX functions Make date based calculations   Which of the following statements is true? You can use Power Query to combine files that have the same format and open them all in the same spreadsheet You can use Power Query to link data tables and create pivot tables that pull data items from all the linked tables You can use Power Query to create interactive dashboard reports You can use Power Query to export data files to Microsoft Access and other databases     Which of the following provides a compelling case to use Power Pivot in Microsoft Excel? The data visualisation and presentation features of Power Pivot are much more powerful than those in Excel Power Pivot offers the ability to clean large files of data imported from other systems quickly Existing reports and tables can be “reverse engineered” (unpivoted) to create data tables for more advanced analysis Files sizes in Power Pivot are smaller than in Excel and there is no limit on the number of rows of data that can be stored. This makes it much faster and more efficient to use Power Pivot for large data sets     Power Pivot uses analysis functions from the DAX formula language. What does “DAX” stand for? Digital Architecture Extraction Data Arbitrage Extrapolation Display Analytics Extension Data Analysis Expressions Deeply Annoying Exercise   The DAX CALCULATE function is one of the most powerful and useful functions available in Power Pivot. Which statement best describes it? It performs row by row calculations defined by the user and adds the total of them all together for a specified table It performs row by row calculations defined by the user and displays the maximum result for a specified table It performs a defined calculation and then applies filters specified by the user It filters the data in a specified table according to criteria set by the user   As well as in Power Pivot in Microsoft Excel, in what application are DAX functions also available? Microsoft PowerPoint Microsoft Forms Microsoft Teams Microsoft Power BI   How do DAX functions differ from Microsoft Excel functions? DAX functions are designed specifically for use with SQL based data sources DAX functions are completely new and provide additional functionality within Microsoft Excel DAX functions never take a cell reference or a range as reference, but instead take a column or table as reference DAX date and time functions return a date as a serial number, whereas Excel date and time functions return a datetime data type  

Power Query and Power Pivot in Microsoft Excel: 
A Quickstart Guide
Delivered Online On Demand
£9.99

AWS Solutions Architect & SysOps Administrator

5.0(1)

By Course Gate

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This AWS Solutions Architect & SysOps Administrator will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The AWS Solutions Architect & SysOps Administrator will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to AWS Solutions Architect & SysOps Administrator and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited AWS Solutions Architect & SysOps Administrator is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this AWS Solutions Architect & SysOps Administrator. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path The AWS Solutions Architect & SysOps Administrator will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum AWS Tutorial | Course Introduction AWS Tutorial Introduction 00:02:00 What You Will Become 00:01:00 Cloud Computing Basics - Introducing IaaS, PaaS & SaaS Service Models Cloud Computing Introduction 00:07:00 Cloud service models 00:10:00 Cloud Deployment Models 00:05:00 Pre-Requisites - Key Skills Required Before Get Started with AWS Linux Basics 00:02:00 AWS Free Tier Account 00:01:00 Desire to adopt Cloud Model 00:01:00 AWS Global Infrastructure AWS Regions 00:03:00 Availability Zones 00:06:00 EC2 Basics- Virtual Servers in AWS Cloud What is Amazon EC2? 00:03:00 How to Create EC2 Instance - Linux 00:13:00 How to Create EC2 Instance - Windows 00:06:00 How to configure EC2 Instance? 00:15:00 Instance States 00:05:00 EC2 Instance Types 00:08:00 EC2 Pricing Models 00:17:00 Networking Basics - Basics of Network Topology and IP address classes Know Networking Terms - IP, Port, Protocol, Service, Daemon 00:15:00 Apache HTTP Server 00:19:00 VPC - Configure Custom Virtual Private Cloud in the AWS Cloud Build Your Own Datacenter 00:04:00 What is AWS VPC? 00:04:00 Create Custom VPC 00:07:00 Create Custom VPC - LAB 00:17:00 Private Subnet Vs Public Subnet 00:08:00 Private Subnet Vs Public Subnet - LAB 00:15:00 VPC Peering Connections 00:04:00 VPC Peering Connections - LAB 00:11:00 Network ACLs Vs Security Groups 00:09:00 Virtual Private Network (VPN) 00:03:00 EC2 Advanced - Virtual Servers in AWS Cloud EC2 Instance Meta Data 00:03:00 How to Manage Instance Settings 00:07:00 BootStrap EC2 instances 00:05:00 AMI - Create, Copy & Manage Permissions 00:10:00 EC2 Placement Groups 00:05:00 Public IP Vs. Elastic IP 00:03:00 EC2 Summary 00:05:00 Introduction to Elastic Block Store - EBS 00:06:00 Instance Store Volumes 00:06:00 EBS Snapshots 00:03:00 Cloud Watch Basics - Monitor AWS Resources & Applications Performance Cloud Watch Metrics 00:04:00 Cloud Watch Dashboards 00:03:00 Cloud Watch Alarms 00:05:00 Simple Notification Service SNS Introduction 00:03:00 Create Topic & Subscriptions to the Topic 00:03:00 Cloud Watch Alarms - LAB 00:11:00 Certificate Manager - Provision, Manage & Deploy SSL/TLS Certificates Data Encryption Introduction & Types 00:04:00 Create SSL/TLS Certificates - LAB 00:05:00 Route 53 - Scalable DNS and Domain Registration What is Route 53? | How DNS works? 00:06:00 How to Create Hosted Zone 00:07:00 DNS Record Types 00:07:00 Route53 Health Checks 00:03:00 Load Balancing - High Availability Solution for the Applications & Servers High Availability & Load Balancer - Architecture 00:16:00 Classic Load Balancer 00:08:00 Application Load Balancer 00:15:00 Network Load Balancer 00:06:00 Auto Scaling - Scale EC2 instances Proportion to Application Load What is Auto Scaling? 00:08:00 Auto Scaling Group - Architecture 00:08:00 Auto Scaling Group with ELB Association 00:08:00 Create launch Configuration 00:03:00 Create Auto Scaling group 00:16:00 S3 - Scalable Object Storage in the AWS Cloud What is S3? 00:08:00 Create First S3 Bucket 00:03:00 Create First S3 Object 00:04:00 S3 Storage Classes 00:06:00 S3 Versioning 00:10:00 S3 Life Cycle Management 00:08:00 IAM - Manage User Access and Encryption Keys What is IAM ? | IAM Architecture 00:12:00 IAM User, IAM Group - LAB 00:11:00 IAM Policy - LAB 00:07:00 IAM Role - LAB 00:04:00 S3 Cross-Region Replication - LAB 00:10:00 IAM MFA & Security Best Practices 00:07:00 AWS CLI - Manage AWS Services & Resources through AWS CLI How to Install AWS CLI on Windows Systems 00:05:00 How to Install AWS CLI on Linux 00:03:00 Explore AWS CLI Real-time Use Cases 00:07:00 Key Management Service - Generate & Manage AWS Encryption Keys KMS Architecture 00:05:00 Key Management Service (LAB) 00:05:00 EBS Volume Encryption 00:02:00 S3 Encryption 00:02:00 EFS - Managed Network File Storage for EC2 EFS Architecture 00:04:00 Create EFS 00:05:00 Mount on EC2 Instances 00:04:00 S3 Glacier - Data Archival Solution in the AWS Cloud What is S3 Glacier? 00:02:00 Create Vault 00:02:00 Retrieval Policies 00:03:00 Cloud Watch Advanced - Monitor AWS Resources & Applications Performance Cloud Watch Logs 00:13:00 Cloud Watch Custom Metrics 00:04:00 Cloud Watch Events 00:07:00 Cloud Front - Global Content Delivery Network Cloud Front Architecture 00:05:00 Create Cloud Front Distribution - LAB 00:05:00 Cloud Trail - Track IAM user activity & API Usage What is Cloud Trail 00:02:00 Create Trail - LAB 00:05:00 Lambda - Run Code without Thinking About Code | Serverless Architecture What is AWS Lambda? 00:06:00 Getting started with AWS Lambda - LAB 00:08:00 RDS RDS Introduction 00:05:00 Get started with RDS - LAB 00:07:00 DynamoDB Create DynamoDB Table 00:02:00 API Gateway - Build, Deploy & Manage APIs API Gateway Architecture 00:06:00 Create an API - LAB 00:06:00 API Gateway Realtime Use Case 00:03:00 Elastic Beanstalk What is Elastic Beanstalk? 00:06:00 Create a web app - LAB 00:06:00 Cloud Formation - Create & Manager resources with Cloud Formation Templates What is Cloud Formation? 00:06:00 Create Stack - LAB 00:11:00 Cloud Formation Designer - LAB 00:07:00 Systems Manager - Session Manager, Run Command, Parameter Store, Patch Manager What is a Systems Manager? 00:09:00 Session Manager 00:03:00 Run Command 00:06:00 Patch Manager 00:03:00 Secrets Manager - Rotate, Manage & Retrieve Secret through their life cycle What is Secrets Manager? 00:03:00 Store a new secret in Secrets Manager - LAB 00:03:00 Secrets Manager Use Cases 00:02:00 Inspector - Analyze Application Security & Report Inspector Architecture 00:05:00 Inspector Install Run Analyze - LAB 00:06:00 LightSail - Launch & Manage Virtual Private Servers LightSail Architecture 00:05:00 Get Started with LightSail! 00:04:00 AWS Limitations AWS Free Tier Limitations 00:04:00 AWS Service Limits 00:04:00 AWS Cost Explorer What is AWS Cost Explorer? How to Analyze Cost Report? 00:04:00 AWS Support AWS Support Plans 00:04:00 How to raise support tickets with AWS? 00:03:00 AWS Trusted Advisor What is AWS Trusted Advisor? 00:06:00 AWS Project - Realtime 3-Tier Architecture AWS Project - 3-Tier Architecture Deep Drive 00:11:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

AWS Solutions Architect & SysOps Administrator
Delivered Online On Demand12 hours 47 minutes
£11.99

Engineering Management

4.5(3)

By Studyhub UK

Is your dashboard glowing with the dreaded engine management light? No, we're not talking about your car. Imagine that light representing a stalled engineering project, missed deadlines, or disengaged team. The solution? Engineering Management. This comprehensive course equips you with the skills to navigate the dynamic world between engineers and business, transforming frustration into high-performance teams and successful projects. In just 12 modules, you'll master the tools and techniques to become an indispensable leader in the engineering field.  Learning Outcomes Gain a strategic understanding of engineering management principles. Develop analytical skills for effective decision-making. Master project planning and risk mitigation strategies. Cultivate strong leadership and team management capabilities. Navigate the financial and legal aspects of engineering manager jobs. Why buy this Engineering Management Course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Certification After studying the course materials of the Engineering Management there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this Engineering Management course for? Engineers seeking career progression into management roles. Professionals seeking to bridge the gap between technical and business aspects. Individuals aiming to strengthen their project management expertise. Those seeking to develop strong leadership and communication skills. Anyone interested in a stimulating career in engineering management. Prerequisites This Engineering Management does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Engineering Management was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Project Manager - £45,000 - £65,000 Annually Engineering Operations Manager - £50,000 - £70,000 Annually Programme Manager - £55,000 - £80,000 Annually Engineering Consultant - £50,000 - £75,000 Annually Contract Manager - £48,000 - £68,000 Annually Business Development Manager - £52,000 - £78,000 Annually Course Curriculum Module 01: Introduction to Engineering Management Introduction to Engineering Management 00:16:00 Module 02: Engineering Management Career Engineering Management Career 00:16:00 Module 03: Decision Analysis Decision Analysis 00:16:00 Module 04: Strategic Planning Strategic Planning 00:14:00 Module 05: Cost Accounting and Risk Management Cost Accounting and Risk Management 00:12:00 Module 06: Operations and Supply Chain Management Operations and Supply Chain Management 00:18:00 Module 07: Financial Accounting and Management Financial Accounting and Management 00:20:00 Module 08: Marketing Management Marketing Management 00:18:00 Module 09: Management and Technology Management and Technology 00:16:00 Module 10: The Spirit of Entrepreneurship The Spirit of Entrepreneurship 00:16:00 Module 11: Business Law Business Law 00:18:00 Module 12: Systems Engineering Systems Engineering 00:14:00

Engineering Management
Delivered Online On Demand3 hours 14 minutes
£10.99

Wordpress Course for Beginner

4.5(3)

By Studyhub UK

Embark on your journey into the world of WordPress with the Beginner's WordPress Course. Discover the essentials of WordPress, from an introduction to the platform and a walkthrough of its features, to exploring website themes, editing your website's content, and optimizing it for search engines. This course provides a solid foundation for individuals new to WordPress, empowering them to create and manage their own websites. Learning Outcomes: Understand the fundamentals of the WordPress platform and its user interface. Navigate through the WordPress dashboard and key features. Explore various WordPress themes and their customization options. Edit and manage website content, including text, images, and media. Implement basic SEO techniques to optimize their WordPress websites. Create and publish new web pages and posts using WordPress. Familiarize themselves with essential plugins and their functionalities. Troubleshoot common issues and perform basic maintenance tasks. Why buy this WordPress Course for Beginner?  Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the WordPress Course for Beginner you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This WordPress Course for Beginner course is ideal for Individuals new to website creation and WordPress. Bloggers, freelancers, and small business owners aiming to build a web presence. Creative professionals seeking to manage their portfolio using WordPress. Aspiring web developers looking to learn the basics of WordPress. Prerequisites This WordPress Course for Beginner was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Freelance Web Designer (with WordPress expertise): £20,000 - £40,000 Content Creator/Blogger (with self-managed WordPress site): Earnings may vary Small Business Owner (with WordPress-based website): Earnings may vary Digital Marketing Assistant (with WordPress skills): £22,000 - £30,000. Course Curriculum Wordpress Course Introduction WordPress Course Overview 00:03:00 Buying Domain 00:01:00 Where To Get Web Hosting 00:01:00 Setup Hosting Nameservers 00:01:00 Wordpress Platform Walkthrough How To Install WordPress 00:01:00 WordPress Settings Optimization 00:03:00 WordPress Widgets Walkthrough 00:01:00 WordPress Posts and Media Walkthrough 00:01:00 Wordpress Website Themes Walkthrough Marketing Agency WordPress Theme Example 00:06:00 Local Business Theme Install 00:01:00 Install Free Website Builder 00:01:00 WordPress Plumber Business Theme Walkthrough 00:02:00 Update Homepage Setting 00:01:00 How To Setup WordPress Menu 00:02:00 Wordpress Website Editing Walkthrough Edit Your Website With Elementor 00:04:00 Elementor Elements Walkthrough 00:02:00 How To Create a Contact Form 00:01:00 Create Terms of Service and Privacy Policy Pages 00:02:00 How To Setup Footer Menu 00:01:00 Wordpress Website SEO Optimization Yoast SEO Plugin Setup 00:01:00 Yoast SEO On-Page Optimization 00:02:00 WordPress Page Title Optimization 00:04:00 Advanced WordPress SEO 00:20:00 Advanced WordPress On-Page SEO 00:17:00 BONUS WordPress Course Sales Video 00:01:00 Assignment Assignment - WordPress Course for Beginner 00:00:00

Wordpress Course for Beginner
Delivered Online On Demand1 hour 20 minutes
£10.99

WordPress Training for Everyone

4.5(3)

By Studyhub UK

Welcome to 'WordPress Training for Everyone'! This course is your ticket to mastering WordPress, the go-to platform for building websites. We'll start with the basics, like getting your domain and hosting, and then quickly move on to the fun stuff - setting up and running your site. Whether you're planning to launch a blog, or a business site, or just want to learn a new skill, this course has you covered. Ever wondered how to make a website that looks great and works smoothly? That's what you'll learn here. We'll show you how to install WordPress, add cool posts, and use themes to make your site look professional. It's not just about making a website - it's about making it awesome. And the best part? You don't need to be a tech whiz to do it! By the end of this course, you'll be all set to create and manage your website. It's perfect for boosting your career, showing off your hobbies, or even starting an online business. We make learning WordPress easy and fun, so you can build a site that you're proud of. Dive in and let's start building something amazing together! Learning Outcomes Understand the process of purchasing and setting up a domain. Learn to acquire and manage web hosting services effectively. Gain proficiency in using cPanel for website administration. Master the installation and customization of WordPress. Develop skills in creating and editing posts and pages. Explore the functionality of WordPress themes and plugins. Enhance website interactivity through media, menus, and widgets. Acquire knowledge in managing users, tools, and settings in WordPress. Learn to integrate essential tools like Google Analytics and contact forms. Why choose this WordPress Training for Everyone? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this WordPress Training for Everyone for? Individuals seeking to build and manage their own websites. Entrepreneurs aiming to establish an online presence. Digital marketers looking to expand their skillset. Bloggers and content creators desiring a robust platform. Professionals in any field needing website management skills. Career path Web Developer: £25,000 - £50,000 Digital Marketer: £20,000 - £40,000 Content Manager: £22,000 - £35,000 SEO Specialist: £20,000 - £30,000 Freelance WordPress Consultant: Varies based on projects and experience Prerequisites This WordPress Training for Everyone does not require you to have any prior qualifications or experience. You can just enrol and start learning.This WordPress Training for Everyone was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum WordPress Training for Everyone Module 01: How to Buy a Domain Part 1 00:07:00 Module 02: How to Buy a Domain Part 2 00:02:00 Module 03: How to Buy Hosting 00:05:00 Module 04: Site Redirection 00:03:00 Module 05: Change the Nameserver 00:02:00 Module 06: Introduction to cPanel 00:03:00 Module 07: Creating Email Accounts in cPanel 00:02:00 Module 08: Installing WordPress Manually 00:05:00 Module 09: Install WP in cPanel 00:02:00 Module 10: How to Make and Edit a Post 00:03:00 Module 11: Make and Edit Content 00:04:00 Module 12: WordPress Dashboard Overview 00:02:00 Module 13: Tags and Categories 00:05:00 Module 14: Adding Media 00:05:00 Module 15: Add and Edit Pages 00:02:00 Module 16: WordPress Comments 00:03:00 Module 17: WordPress Themes 00:04:00 Module 18: Theme Customisation 00:03:00 Module 19: Theme Editor 00:03:00 Module 20: Plugins 00:02:00 Module 21: Menus 00:05:00 Module 22: Widgets 00:04:00 Module 23: Users 00:04:00 Module 24: Tools 00:04:00 Module 25: Settings 00:08:00 Module 26: Contact Form 00:04:00 Module 27: How to Use Gravatar 00:03:00 Module 28: Adding Images and Video 00:03:00 Module 29: Static Page 00:02:00 Module 30: Favicon 00:03:00 Module 31: Installing Google Analytics 00:04:00 Additional Materials Resource - WordPress Training for Everyone 00:00:00

WordPress Training for Everyone
Delivered Online On Demand1 hour 51 minutes
£10.99