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

1724 Analytics courses delivered Online

Microsoft Excel: Master Power Query in 120 Minutes!

4.5(3)

By Studyhub UK

Overview Do you face struggle when you open a Power Query seeing the number of things to do then and cannot make good use of your time? Then this Microsoft Excel: Master Power Query in 120 Minutes! Course is just what you need.to break free of your worries. Power Query is a business intelligence tool available in Excel that allows you to import data from many sources and then clean, transform and reshape your data as needed. The course is designed for learners opting to learn Power Query, a feature available in Excel. Power query is a data connection technology that enables you to connect combine refine and discover data from various sources to meet analysis needs.  The course will introduce you to the basic features of Power query and then show how to trim and transform Data in Excel Power Query, Format Dates and Values in Excel Power Query. You will also learn how to extract data from folders and doing auto clean up on Excel Power Query. You will also learn to merge and shape data according to analysis requirements and prepare models by tools such as power pivot. Learning Outcomes: Acquire proficiency in using Excel Power Query for efficient data management. Master the art of transforming raw data into actionable insights. Learn advanced techniques for data manipulation and analysis. Develop the ability to streamline complex data processes. Enhance your analytical thinking and problem-solving skills. 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. Why study this 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. Requirements Our Microsoft Excel: Master Power Query in 120 Minutes! Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career paths Data Analyst: £25,000 - £40,000 Per Annum Business Analyst: £30,000 - £50,000 Per Annum Financial Analyst: £28,000 - £45,000 Per Annum Marketing Analyst: £24,000 - £40,000 Per Annum Operations Analyst: £26,000 - £42,000 Per Annum Management Consultant: £35,000 - £55,000 Per Annum Course Curriculum Microsoft Excel: Master Power Query in 120 Minutes! Power Query Intro and Excel version 00:03:00 Excel Power Query - Introduction 00:03:00 Excel Power Query - Query Editor Ribbon 00:09:00 Transform Data - Trim in Excel Power Query 00:05:00 Transform Data - Format Dates and Values in Excel Power Query 00:02:00 Transform Data - Parsing URLs in Excel Power Query 00:05:00 Transform Data - Split Text Fields in Excel Power Query 00:10:00 Transform Data - Group By in Excel Power Query 00:03:00 Transform Data - Unpivoting Columns in Excel Power Query 00:05:00 Transform Data - Pivoting Columns in Excel Power Query 00:02:00 Transform Data - Split Columns into Other Columns in Excel Power Query 00:04:00 Transform Data - Filtering Rows in Excel Power Query 00:05:00 Transform Data - Sorting Columns in Excel Power Query 00:02:00 Transform Data - Transform and Add Columns in Excel Power Query 00:07:00 From Folder - Import From Folder in Excel Power Query 00:07:00 From Folder - Doing Auto Cleanup in Excel Power Query 00:13:00 From Folder - Extract Data from Forms in Excel Power Query 00:13:00 From Workbook - Extract Multiple Criteria in Excel Power Query 00:05:00 From Workbook - Extract Multiple Worksheets in Excel Power Query 00:04:00 Joins - Intro to Joins 00:04:00 Joins - Merging 00:08:00 Joins - Full Outer Join 00:06:00 Joins - Right Anti Join 00:09:00 Power Query - Convert Reports into Pivot Tables 00:05:00 Modulo 00:06:00

Microsoft Excel: Master Power Query in 120 Minutes!
Delivered Online On Demand2 hours 25 minutes
£10.99

(HR) Human Resources: Workplace Confidentiality Training Level 1

5.0(1)

By Empower UK Employment Training

(HR) Human Resources: Workplace Confidentiality Training Level 1 In "HR: Workplace Confidentiality Training Level 1" become adept at HR protocols for upholding workplace confidentiality. Explore HR-endorsed business etiquette and colleague interactions, vital in maintaining confidentiality. Acquire HR strategies to proactively prevent breaches and safeguard sensitive data in HR operations. Learning Outcomes: Understand HR role in workplace confidentiality. Apply HR guidelines to business etiquette. Maintain HR-driven confidentiality with colleagues. Implement HR-approved breach prevention measures. Recognize HR organizational responsibilities for confidentiality. More Benefits: LIFETIME access Device Compatibility Free Workplace Management Toolkit (HR) Human Resources: Workplace Confidentiality Training Level 1 Course Syllabus HR Protocols for Workplace Confidentiality: Grasp the HR-endorsed policies that uphold confidentiality and protect sensitive workplace data. HR and Business Etiquette: Learn the HR perspective on integrating confidentiality into your professional interactions and adhering to ethical business etiquettes. HR Guidelines for Confidentiality with Colleagues: Familiarize yourself with HR best practices for maintaining confidentiality when interacting with colleagues. HR Strategies for Preventing Confidentiality Breach: Understand HR-approved methods to identify and mitigate the risks associated with breaches of confidentiality. HR Role in Protecting Sensitive Data: Acquire HR-endorsed techniques for safeguarding confidential workplace information. Organizational HR Responsibilities for Confidentiality: Comprehend the organizational responsibilities as mandated by HR policies, ensuring comprehensive confidentiality measures are in place.

(HR) Human Resources: Workplace Confidentiality Training Level 1
Delivered Online On Demand1 hour 18 minutes
£5

Business Process Management (BPM)

By Training Tale

Every successful organisation around the world relies on effective process management. Process managers are responsible for planning, implementing, monitoring, assessing, and optimising a wide range of critical processes, regardless of the size, nature, or objectives of the business. Process management is a position of unique responsibility because it directly contributes to the success or failure of the business as a whole. At the same time, it offers ambitious professionals the opportunity for limitless career advancement. Business process managers with advanced skills and competencies are in high demand worldwide. This BPM - Business Process Management course will give you a thorough understanding of Business Process Management by introducing key concepts, strategies, and in-depth information. This BPM - Business Process Management course will provide real-world knowledge and expertise from industry professionals and practitioners. This exclusive BPM - Business Process Management course is beneficial to both newcomers and existing workforce members. Learning Outcomes After completing BPM - Business Process Management course, the learner will be able to: Understand business process management and related concepts. Understand the evolution of enterprise systems architectures. Understand business process modelling foundation. Have a thorough understanding of process orchestrations and process choreographies. Understand the properties of business processes. Gain in-depth knowledge of architectures and methodologies. Understand business process management methodology. Why Choose Business Process Management Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the course. ***Other Benefits of this Course Free One PDF Certificate Access to Content - Lifetime Exam Fee - Totally Free Free Retake Exam [ Note: Free PDF certificate will provide as soon as completing the Business Process Management (BPM) course ] Course Curriculum *** BPM - Business Process Management *** Module 1: Introduction to Business Process Management Motivation and Definitions Business Process Lifecycle Classification of Business Processes Module 2: Evolution of Enterprise Systems Architectures Traditional Application Development Enterprise Applications and their Integration Enterprise Modelling and Process Orientation Workflow Management Enterprise Services Computing Module 3: Business Process Modelling Foundation Conceptual Model and Terminology Abstraction Concepts From Business Functions to Business Processes Process Models and Process Instances Process Interactions Modelling Process Data Modelling Organisation Modelling Operation Module 4: Process Orchestrations Control-Flow Patterns Petri Nets Event-driven Process Chains Workflow Nets Graph-Based Workflow Language Module 5: Process Choreographies Development Phases Choreography Design Process Choreography Implementation Module 6: Properties of Business Processes Data Dependencies Object Lifecycle Conformance Structural Soundness Soundness Module 7: Architectures and Methodologies Workflow Management Architectures Flexible Workflow Management Web Services and their Composition Module 8: Business Process Management Methodology Methodology Overview Phases in Detail ------------------------- Assessment Method After completing each module of the Business Process Management (BPM), you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Once you complete all the modules in this manner, you will be qualified to request your certification. Certification After completing the MCQ/Assignment assessment for this Business Process Management (BPM), you will be entitled to a Certificate of Completion from Training Tale. It will act as proof of your extensive professional development. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? This Business Process Management (BPM) course is ideal for anyone who desires to enhance their business process management skills. Requirements There are no specific requirements for this Business Process Management (BPM) because it does not require any advanced knowledge or skills. Students who intend to enrol in this course must meet the following requirements: Good command of the English language Must be vivacious and self-driven Basic computer knowledge A minimum of 16 years of age is required Career path After completing this Business Process Management (BPM) course, you will have the knowledge to start a career as: Business Process Manager Business Analyst Entrepreneur Business Owner Certificates Certificate of completion Digital certificate - Included

Business Process Management (BPM)
Delivered Online On Demand6 hours
£12

BPM - Business Process Management

By Training Tale

Every successful organization around the world relies on effective Business Process Management. Are you a working professional with a focus on business processes or management who wants to be at the leading edge of various methods for discovering, modeling, analyzing, measuring, improving, optimizing, and automating business processes? Then our Business Process Management course is perfect for you! This comprehensive and up-to-date Business Process Management course is an excellent way to get started in this field. Process managers are responsible for planning, implementing, monitoring, assessing, and optimizing a wide range of critical processes, regardless of the size, nature, or objectives of the business. Business Process Management is a position of unique responsibility because it directly contributes to the success or failure of the business as a whole. At the same time, it offers ambitious professionals the opportunity for limitless career advancement. Business process managers with advanced skills and competencies are in high demand worldwide. This Business Process Management course will provide you with an in-depth understanding of the evolution of enterprise system architectures, business process-management, and an introduction to the business process life cycle. You will also learn how to map business processes using flow charts and diagrams, create business functions, identify function leaders, and properly plan the modeling, monitoring, and optimizing phases. You will be able to recognize and oversee your growth as well as reflect on your experiences while taking our course in order to gain insightful knowledge about who you are and how your goals are changing. This informative Business Process Management course has been designed to be equally beneficial to both newcomers and existing members of the workforce. Business Process Management allows organizations to successfully achieve their goals by effectively utilizing processes. Once processes have been implemented, they must be monitored, evaluated, and optimized to ensure that they continue to meet the objectives for which they were designed. A company that can successfully manage its processes can maintain a competitive advantage while increasing productivity and efficiency, and lowering costs. Learning Outcomes After completing BPM - Business Process Management Bundle course, the learner will be able to: Understand business process management and related concepts. Understand the evolution of enterprise systems architectures. Understand business process modelling foundation. Have a thorough understanding of process orchestrations and process choreographies. Understand the properties of business processes. Gain in-depth knowledge of architectures and methodologies. Understand business process management methodology. Why Choose Business Process Management Bundle Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the course. ***Courses are included in this BPM - Business Process Management Course Course 01: Business Process Management Course 02: Level 5 Diploma in Risk Management Course Course 03: Level 5 Diploma in Business Analysis ***Other Benefits of this Course Free 3 PDF Certificate Access to Content - Lifetime Exam Fee - Totally Free Free Retake Exam [ Note: Free PDF certificate as soon as completing the course ] Course Curriculum *** BPM - Business Process Management *** Module 1: Introduction to Business Process Management Motivation and Definitions Business Process Lifecycle Classification of Business Processes Module 2: Evolution of Enterprise Systems Architectures Traditional Application Development Enterprise Applications and their Integration Enterprise Modelling and Process Orientation Workflow Management Enterprise Services Computing Module 3: Business Process Modelling Foundation Conceptual Model and Terminology Abstraction Concepts From Business Functions to Business Processes Process Models and Process Instances Process Interactions Modelling Process Data Modelling Organisation Modelling Operation Module 4: Process Orchestrations Control-Flow Patterns Petri Nets Event-driven Process Chains Workflow Nets Graph-Based Workflow Language Module 5: Process Choreographies Development Phases Choreography Design Process Choreography Implementation Module 6: Properties of Business Processes Data Dependencies Object Lifecycle Conformance Structural Soundness Soundness Module 7: Architectures and Methodologies Workflow Management Architectures Flexible Workflow Management Web Services and their Composition Module 8: Business Process Management Methodology Methodology Overview Phases in Detail Assessment Method After completing each module of the BPM - Business Process Management, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Once you complete all the modules in this manner, you will be qualified to request your certification. Certification After completing the MCQ/Assignment assessment for BPM - Business Process Management course, you will be entitled to a Certificate of Completion from Training Tale. It will act as proof of your extensive professional development. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? This BPM - Business Process Management course is ideal for anyone who desires to enhance their business process-management skills. Requirements There are no specific requirements for this BPM - Business Process Management because it does not require any advanced knowledge or skills. Students who intend to enrol in this course must meet the following requirements: Good command of the English language Must be vivacious and self-driven Basic computer knowledge A minimum of 16 years of age is required Career path After completing this BPM - Business Process Management course, you will have the knowledge to start a career as: Business Process Manager Business Analyst Entrepreneur Business Owner Certificates Certificate of completion Digital certificate - Included

BPM - Business Process Management
Delivered Online On Demand6 hours
£12

BPM : Business Process Management

By Training Tale

Every successful organisation around the world relies on effective process management. Process managers are responsible for planning, implementing, monitoring, assessing, and optimising a wide range of critical processes, regardless of the size, nature, or objectives of the business. Process management is a position of unique responsibility because it directly contributes to the success or failure of the business as a whole. At the same time, it offers ambitious professionals the opportunity for limitless career advancement. Business process managers with advanced skills and competencies are in high demand worldwide. This BPM : Business Process Management course will give you a thorough understanding of Business Process Management by introducing key concepts, strategies, and in-depth information. This BPM : Business Process Management course will provide real-world knowledge and expertise from industry professionals and practitioners. This exclusive BPM : Business Process Management course is beneficial to both newcomers and existing workforce members. Learning Outcomes After completing BPM : Business Process Management Bundle course, the learner will be able to: Understand business process management and related concepts. Understand the evolution of enterprise systems architectures. Understand business process modelling foundation. Have a thorough understanding of process orchestrations and process choreographies. Understand the properties of business processes. Gain in-depth knowledge of architectures and methodologies. Understand business process management methodology. Why Choose Business Process Management Bundle Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the course. ***Courses are included in this BPM : Business Process Management Course Course 01: Business Process Management Course 02: Level 4 Copywriting Course 03: Level 1 Business Management ***Other Benefits of this Course Free 3 PDF Certificate Access to Content - Lifetime Exam Fee - Totally Free Free Retake Exam [ Note: Free PDF certificate as soon as completing the BPM : Business Process Management course ] Course Curriculum *** BPM : Business Process Management *** Module 1: Introduction to Business Process Management Motivation and Definitions Business Process Lifecycle Classification of Business Processes Module 2: Evolution of Enterprise Systems Architectures Traditional Application Development Enterprise Applications and their Integration Enterprise Modelling and Process Orientation Workflow Management Enterprise Services Computing Module 3: Business Process Modelling Foundation Conceptual Model and Terminology Abstraction Concepts From Business Functions to Business Processes Process Models and Process Instances Process Interactions Modelling Process Data Modelling Organisation Modelling Operation Module 4: Process Orchestrations Control-Flow Patterns Petri Nets Event-driven Process Chains Workflow Nets Graph-Based Workflow Language Module 5: Process Choreographies Development Phases Choreography Design Process Choreography Implementation Module 6: Properties of Business Processes Data Dependencies Object Lifecycle Conformance Structural Soundness Soundness Module 7: Architectures and Methodologies Workflow Management Architectures Flexible Workflow Management Web Services and their Composition Module 8: Business Process Management Methodology Methodology Overview Phases in Detail ------------------------- Assessment Method After completing each module of the BPM : Business Process Management, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Once you complete all the modules in this manner, you will be qualified to request your certification. Certification After completing the MCQ/Assignment assessment for this BPM : Business Process Management, you will be entitled to a Certificate of Completion from Training Tale. It will act as proof of your extensive professional development. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? This BPM : Business Process Management course is ideal for anyone who desires to enhance their business process management skills. Requirements There are no specific requirements for this BPM : Business Process Management because it does not require any advanced knowledge or skills. Students who intend to enrol in this course must meet the following requirements: Good command of the English language Must be vivacious and self-driven Basic computer knowledge A minimum of 16 years of age is required Career path After completing this BPM : Business Process Management course, you will have the knowledge to start a career as: Business Process Manager Business Analyst Entrepreneur Business Owner Certificates Certificate of completion Digital certificate - Included

BPM : Business Process Management
Delivered Online On Demand6 hours
£12

KM803 IBM Information Analyzer Essentials v11.5

By Nexus Human

Duration 4 Days 24 CPD hours This course is intended for This basic course is for business data analysts who want to profile and assess data using Information Analyzer, also data quality analysts who need to measure data quality. Overview Analyze data structures to determine agreement with documented metadataDiscover data anomaliesIdentify invalid and incomplete data valuesDetermine potential primary keys to table structuresAdd business meaning to dataProduce deliverables that can be used by business users and ETL developersConfigure Information AnalyzerAdminister the Information Analyzer environmentUnderstand security considerations around data analysisUnderstand the methodology supporting data analysisUse Information Analyzer to analyze data content and structureUse Information Analyzer to construct data rules and utilize IBM-supplied data rule templates In this course, you will learn how to use the IBM InfoSphere suite to analyze data and report results to business users. Course Outline Information Analysis concepts Information Server overview Information Analyzer overview Information Analyzer Setup Column analysis Concepts Basic data profiling techniques in practice Data profiling techniques Primary key analysis Concepts Basic data profiling techniques in practice Foreign key and cross domain analysis Concepts Basic data profiling techniques in practice Baseline analysis Reporting and publishing Extending the meta data using Information Governance Catalog and Information Analyzer Data Rules and Metrics Additional course details: Nexus Humans KM803 IBM Information Analyzer Essentials v11.5 training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the KM803 IBM Information Analyzer Essentials v11.5 course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

KM803 IBM Information Analyzer Essentials v11.5
Delivered OnlineFlexible Dates
Price on Enquiry

0G51BG IBM Statistical Analysis Using IBM SPSS Statistics (V26)

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for IBM SPSS Statistics users who want to familiarize themselves with the statistical capabilities of IBM SPSS StatisticsBase. Anyone who wants to refresh their knowledge and statistical experience. Overview Introduction to statistical analysis Describing individual variables Testing hypotheses Testing hypotheses on individual variables Testing on the relationship between categorical variables Testing on the difference between two group means Testing on differences between more than two group means Testing on the relationship between scale variables Predicting a scale variable: Regression Introduction to Bayesian statistics Overview of multivariate procedures This course provides an application-oriented introduction to the statistical component of IBM SPSS Statistics. Students will review several statistical techniques and discuss situations in which they would use each technique, how to set up the analysis, and how to interpret the results. This includes a broad range of techniques for exploring and summarizing data, as well as investigating and testing relationships. Students will gain an understanding of when and why to use these various techniques and how to apply them with confidence, interpret their output, and graphically display the results. Introduction to statistical analysis Identify the steps in the research process Identify measurement levels Describing individual variables Chart individual variables Summarize individual variables Identify the normal distributionIdentify standardized scores Testing hypotheses Principles of statistical testing One-sided versus two-sided testingType I, type II errors and power Testing hypotheses on individual variables Identify population parameters and sample statistics Examine the distribution of the sample mean Test a hypothesis on the population mean Construct confidence intervals Tests on a single variable Testing on the relationship between categorical variables Chart the relationship Describe the relationship Test the hypothesis of independence Assumptions Identify differences between the groups Measure the strength of the association Testing on the difference between two group meansChart the relationship Describe the relationship Test the hypothesis of two equal group means Assumptions Testing on differences between more than two group means Chart the relationship Describe the relationship Test the hypothesis of all group means being equal Assumptions Identify differences between the group means Testing on the relationship between scale variables Chart the relationship Describe the relationship Test the hypothesis of independence Assumptions Treatment of missing values Predicting a scale variable: Regression Explain linear regression Identify unstandardized and standardized coefficients Assess the fit Examine residuals Include 0-1 independent variables Include categorical independent variables Introduction to Bayesian statistics Bayesian statistics and classical test theory The Bayesian approach Evaluate a null hypothesis Overview of Bayesian procedures in IBM SPSS Statistics Overview of multivariate procedures Overview of supervised models Overview of models to create natural groupings

0G51BG IBM Statistical Analysis Using IBM SPSS Statistics (V26)
Delivered OnlineFlexible Dates
Price on Enquiry

Data Analysis and Forecasting in Excel

4.9(27)

By Apex Learning

Overview This comprehensive course on Data Analysis and Forecasting in Excel will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Data Analysis and Forecasting in Excel comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Data Analysis and Forecasting in Excel. It is available to all students, of all academic backgrounds. Requirements Our Data Analysis and Forecasting in Excel is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 10 sections • 31 lectures • 04:43:00 total length •Insert, Delete, and Adjust Cells, Columns, and Rows: 00:10:00 •Search for and Replace Data: 00:09:00 •Use Proofing and Research Tools: 00:07:00 •Sort Data: 00:10:00 •Filter Data: 00:10:00 •Query Data with Database Functions: 00:09:00 •Outline and Subtotal Data: 00:09:00 •Apply Intermediate Conditional Formatting: 00:07:00 •Apply Advanced Conditional Formatting: 00:05:00 •Create Charts: 00:13:00 •Modify and Format Charts: 00:12:00 •Use Advanced Chart Features: 00:12:00 •Create a PivotTable: 00:13:00 •Analyze PivotTable Data: 00:12:00 •Present Data with PivotCharts: 00:07:00 •Filter Data by Using Timelines and Slicers: 00:11:00 •Use Links and External References: 00:12:00 •Use 3-D References: 00:06:00 •Consolidate Data: 00:05:00 •Use Lookup Functions: 00:12:00 •Trace Cells: 00:09:00 •Watch and Evaluate Formulas: 00:08:00 •Apply Data Validation: 00:13:00 •Search for Invalid Data and Formulas with Errors: 00:04:00 •Work with Macros: 00:18:00 •Create Sparklines: 00:07:00 •MapData: 00:07:00 •Determine Potential Outcomes Using Data Tables: 00:08:00 •Determine Potential Outcomes Using Scenarios: 00:09:00 •Use the Goal Seek Feature: 00:04:00 •Forecasting Data Trends: 00:05:00

Data Analysis and Forecasting in Excel
Delivered Online On Demand4 hours 43 minutes
£12

Tableau Advanced v10.3

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for This course is intended for those who need to use Tableau Desktop to build complex visuals and dashboards to present information or to monitor data about their organization. Overview Upon completion of this course, participants will be able to:Select the best method to work with multiple data sourcesCreate complex visuals using calculations and parametersApply best practices to improve the layout and aesthetics of dashboards This course enables participants to create complex visualizations and to combine them into interactive dashboards to share with others using Tableau Desktop. The Data Data Interpreter Data Joins Same Database Cross Databases Spatial Join New! Data Blending New Union Custom SQL Tableau Extract TDE Hyper Clipboard Database Changes Automatic Updates Calculations Regular Calculations Quick Table Calculations Table Calculations Level of Detail (LOD) Expressions Complex Visualizations Custom Background Map Web Map Servers Dual Maps Bar in Bar Graph Bullet Graph Pareto Chart Sparkline Report Top N Within a Category Report Waterfall Chart Funnel Chart Pattern Analysis using the Path Shelf Building Better Dashboards Best Practices for Design Best Practices for Performance Creating a Template Workbook Using Layout Containers Dashboard Extenders New! Generating A Performance Summary Additional course details: Nexus Humans Tableau Advanced v10.3 training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Tableau Advanced v10.3 course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Tableau Advanced v10.3
Delivered OnlineFlexible Dates
Price on Enquiry

Excel spreadsheet for Beginner

By IOMH - Institute of Mental Health

Overview This Excel spreadsheet for Beginner course will unlock your full potential and will show you how to excel in a career in Excel spreadsheet for Beginner. So upskill now and reach your full potential. Everything you need to get started in Excel spreadsheet for Beginner is available in this course. Learning and progressing are the hallmarks of personal development. This Excel spreadsheet for Beginner will quickly teach you the must-have skills needed to start in the relevant industry. In This Mental Health Course, You Will: Learn strategies to boost your workplace efficiency. Hone your Mental Health skills to help you advance your career. Acquire a comprehensive understanding of various Mental Health topics and tips from industry experts. Learn in-demand Mental Health skills that are in high demand among UK employers, which will help you to kickstart your career. This Excel spreadsheet for Beginner course covers everything you must know to stand against the tough competition in the Excel spreadsheet for Beginner field.  The future is truly yours to seize with this Excel spreadsheet for Beginner. Enrol today and complete the course to achieve a Excel spreadsheet for Beginner certificate that can change your professional career forever. Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the Excel spreadsheet for Beginner course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the Excel spreadsheet for Beginner course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.  Certificate of Achievement Upon successfully completing the Excel spreadsheet for Beginner course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This Excel spreadsheet for Beginner is suitable for anyone aspiring to start a career in Excel spreadsheet for Beginner; even if you are new to this and have no prior knowledge on Excel spreadsheet for Beginner, this course is going to be very easy for you to understand.  And if you are already working in the Excel spreadsheet for Beginner field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  Taking this Excel spreadsheet for Beginner course is a win-win for you in all aspects.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements This Excel spreadsheet for Beginner course has no prerequisite.  You don't need any educational qualification or experience to enrol in the Excel spreadsheet for Beginner course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online Excel spreadsheet for Beginner course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Excel spreadsheet for Beginner Tour of the Excel screen 00:10:00 Entering Data 00:13:00 Autofill Speedfill 00:09:00 Saving the file 00:02:00 Autosum 00:04:00 Formula Basics 00:11:00 Copying formulas - Relative Formulas 00:04:00 Totals and Averages 00:04:00 Formatting the Spreadsheet 00:07:00 Managing the Sheets 00:06:00 Copying formulas - absolute formulas 00:08:00 Linking the Sheets together 00:06:00 Introduction to Functions 00:05:00 Assignment Assignment - Excel spreadsheet for Beginner 00:00:00

Excel spreadsheet for Beginner
Delivered Online On Demand1 hour 29 minutes
£11.99