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

7837 Courses in Cardiff delivered Online

Linear Regression Analysis in Microsoft Excel

By Study Plex

Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Getting Data Ready for Regression Model Transportation Problem in Excel using Goal Seek 00:12:00 Gathering Business Knowledge 00:03:00 Data Exploration 00:03:00 The Data and the Data Dictionary 00:07:00 Univariate analysis and EDD 00:03:00 Discriptive Data Analytics in Excel 00:10:00 Outlier Treatment 00:04:00 Identifying and Treating Outliers in Excel 00:04:00 Missing Value Imputation 00:03:00 Identifying and Treating missing values in Excel 00:04:00 Variable Transformation in Excel 00:03:00 Dummy variable creation: Handling qualitative data 00:04:00 Dummy Variable Creation in Excel 00:07:00 Correlation Analysis 00:09:00 Creating Correlation Matrix in Excel 00:08:00 Creating Regression Model The Problem Statement 00:01:00 Basic Equations and Ordinary Least Squares (OLS) method 00:08:00 Assessing accuracy of predicted coefficients 00:14:00 Assessing Model Accuracy: RSE and R squared 00:07:00 Creating Simple Linear Regression model 00:02:00 Multiple Linear Regression 00:05:00 The F - statistic 00:08:00 Interpreting results of Categorical variables 00:05:00 Creating Multiple Linear Regression model 00:07:00 What-if analysis Excel: Running Linear Regression using Solver 00:08:00 Assessment Assessment - Linear Regression Analysis In MS Excel 00:10:00 Certificate of Achievement Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Linear Regression Analysis in Microsoft Excel
Delivered Online On Demand
£19

Microsoft Office 2019: Word, Excel, PowerPoint and Access - Masterclass Bundle

4.7(160)

By Janets

Learning Outcomes Learn how to perform calculations in MS Excel Understand the process of formatting and managing Worksheets Get introduced to the tools and features of MS Word Pick up the skills to create excellent presentations with PowerPoint Know the techniques for modifying data in Access Develop the skills to work with queries and Access forms Description Whether you want to work in a school or a multinational company, one skill is required in almost every industry, and that is MS Office. So, if you want to land a good job, first develop a solid foundation in MS Office and create an attractive CV. The Microsoft Office 2019: Word, Excel, PowerPoint And Access - Masterclass Bundle can help you. This bundle is developed to provide detailed lessons in MS Word, Excel, PowerPoint, and Access. The course will introduce you to the features of Microsoft Word and show you how to insert tables, add graphic objects and more. Here, you can develop the skills for managing and formatting Workbooks in Excel. In addition, you will get to learn the strategies to create presentations in PowerPoint. Furthermore, you will be able to learn the essentials of MS Access. The course will teach you a wide range of MS Office skills. It will also help you elevate your resume with a valuable certificate of achievement. Join now and start learning! Certificate of Achievement After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for 9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for 15.99, which will reach your doorsteps by post.  Method of Assessment At the end of the course, there will be an online MCQ assessment. In order to pass this exam, you must score at least 60%. When you submit the assessment, our team will examine it and deliver you feedback.  Career path This course will help you develop a clear understanding of this area. After completing the course, you will be able to explore career options such as Data Analyst Manager Data Entry Officer Office Admin

Microsoft Office 2019: Word, Excel, PowerPoint and Access - Masterclass Bundle
Delivered Online On Demand18 hours 27 minutes
£9.99

Clustering and Classification with Machine Learning in R

By Packt

The underlying patterns in your data hold vital insights; unearth them with cutting-edge clustering and classification techniques in R

Clustering and Classification with Machine Learning in R
Delivered Online On Demand7 hours 42 minutes
£134.99

Access 365 Intermediate

By iStudy UK

Learning Objectives Introduction , Designing Tables for Better Data Entry , Sharing Data with Other Applications , Working with Action Queries , Advanced Query Techniques , Automating Processes with Macros , Advanced Form Techniques , Advanced Report Techniques , Conclusion   Pre-Requisites Access 365 Beginner or equivalent experience.   Description This course is designed to teach students intermediate level skills in Microsoft Access 365. In this course, students will learn to design tables for improved accuracy in data entry, review the various options to share data with other applications, learn about action queries, and review various advanced query techniques. Students will also learn how to automate processes with Macros, advanced form techniques, and advanced report techniques. This course prepares students for the Access 365 Advanced course.   Module 1: Design Tables for Better Data Entry Reviewing Table Design Principles 00:11:00 Setting Field Size, Formats, and Captions 00:11:00 Setting Default Values and Required Fields 00:05:00 Restricting Data Entry-Validation Rules 00:07:00 Restricting Data Entry-Input Masks 00:09:00 Module 2: Share Data with Other Apps Exporting Tables and Queries to Excel 00:05:00 Exporting Data to a SharePoint List 00:02:00 Importing Data from Excel 00:06:00 Importing Data from a SharePoint List 00:02:00 Linking External Data Sources 00:05:00 Using Word Merge 00:06:00 Module 3: Work with Action Queries What are Action Queries 00:04:00 Creating an Update Query 00:06:00 Creating an Append Query 00:04:00 Creating a Delete Query 00:04:00 Creating a Make Table Query 00:04:00 Changing Start Number of an Auto Number Field 00:04:00 Module 4: Advanced Query Techniques Modifying Query Joins 00:06:00 Using Self Joins to Combine Data 00:06:00 Creating Find Unmatched and Find Duplicate Queries 00:09:00 Creating Parameter Queries 00:05:00 Creating a Top X Query 00:02:00 Reviewing Calculated Query Fields 00:06:00 Summarizing Query Data with Totals 00:04:00 Creating Crosstab Queries 00:06:00 Module 5: Automate Processes with Macros Understanding Macro Basics 00:14:00 Creating Macros to Open Forms by Record 00:09:00 Validating Data Entry with Macros 00:10:00 Creating a Macro to Automate Data Entry 00:08:00 Advanced Data Entry Using Macros and DLOOKUP 00:11:00 Module 6: Advanced Form Techniques Using Conditional Formatting 00:04:00 Working with the New Label Name Property 00:03:00 Organizing Form Fields with Tab Controls 00:09:00 Creating an Option Group Control 00:06:00 Creating a Combo Box Control 00:04:00 Configuring a Combo Box Control to Show Search Results 00:04:00 Using a Subform to Show Data From a Related Table 00:06:00 Module 7: Advanced Report Techniques Inserting a Chart on a Report 00:07:00 Showing Data in Columns 00:07:00 Inserting a Subreport 00:05:00 Configuring Reports with Parameter Queries 00:03:00 Sending Reports 00:03:00 Resource Resource - Access 365 Intermediate 00:00:00 Final Exam Final Exam - Access 365 Intermediate 00:20:00

Access 365 Intermediate
Delivered Online On Demand4 hours 32 minutes
£25

Sage 50 / Payroll Management / Excel / Xero Training

4.9(27)

By Apex Learning

Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Sage 50 Payroll Bundle Now Become an invaluable asset to your company's future and take charge of its finances almost immediately by learning to use Sage 50. Sage 50 Payroll is today's trusted benchmark in money handling, and we can train you to use it without any prior experience. No matter whether you are starting as an accountant in a large company, or having to pay salaries in a private firm, this learning experience can take your career and business to the next level. With a single payment you will gain access to Sage 50 Payroll Advanced Diploma including 10 Career development courses, original hardcopy certificate, transcript and a student ID card. Courses are included with this Sage 50 Payroll Advanced Diploma: Course 01: Sage 50 Training Course 02: Payroll Management Course Course 03: Level 3 Xero Training Course 04: Financial Management Course 05: Accounting and Bookkeeping Level 2 Course 06: Applied Business Analysis Diploma Course 07: Data Analysis in Excel Level 3 Course Course 08: Office Skills Course 09: Effective Communication Skills Course 10: Performance Management Course 11: New Functions in Microsoft Excel 2021 This Sage 50 Payroll Advanced Diploma offers you all the training you will need to take a Payroll Administrator's role and establish your skills with Sage software. Benefits you'll get choosing Apex Learning for this Sage 50: One payment, but lifetime access to 11 CPD courses Learn at your ease - anytime, from anywhere Study the Sage 50 course from your computer, tablet or mobile device CPD accredited Sage 50 course - improve the chance of gaining professional skills Gain valuable experience of Sage 50 without leaving your home Curriculum **Sage 50 Payroll for Beginners** Module 1: Payroll Basics Module 2: Company Settings Module 3: Legislation Settings Module 4: Pension Scheme Basics Module 5: Pay Elements Module 6: The Processing Date Module 7: Adding Existing Employees Module 8: Adding New Employees Module 9: Payroll Processing Basics Module 10: Entering Payments Module 11: Pre-Update Reports Module 12: Updating Records Module 13: e-Submissions Basics Module 14: Process Payroll (November) Module 15: Employee Records and Reports Module 16: Editing Employee Records Module 17: Process Payroll (December) Module 18: Resetting Payments Module 19: Quick SSP Module 20: An Employee Leaves Module 21: Final Payroll Run Module 22: Reports and Historical Data Module 23: Year-End Procedures more............. How will I get my Certificate? After successfully completing the Sage 50 Payroll course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £10 * 11 = £110) Hard Copy Certificate: Free (For The Title Course) CPD 115 CPD hours / points Accredited by CPD Quality Standards Who is this course for? There is no experience or previous qualifications required for enrolment on this Sage 50 Payroll Advanced Diploma. It is available to all students, of all academic backgrounds. Requirements Our Sage 50 Payroll Advanced Diploma is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 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 This Sage 50 Training will help you stand out from the competition and will help you in procuring jobs like: Bookkeeper Accounts Executive Auditor Staff Accountant Tax Accountant Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Sage 50 Training) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Sage 50 /  Payroll Management / Excel / Xero Training
Delivered Online On Demand
£45

Sales Analysis in Excel

4.8(9)

By Skill Up

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Sales Analysis in Excel
Delivered Online On Demand6 hours 26 minutes
£25

Accounting For Depreciation with Advanced Excel Model

By iStudy UK

Description Depreciation Accounting for Fixed assets is usual activity and process for any accountant in his/her job, but things can get really tricky and difficult when there are numbers of assets and there are transactions like disposal, sale and purchase in mid-month/mid-year.  This course is designed to help you understand the concept of depreciation through practical situations and examples It is very important to have a robust Fixed assets and depreciation model in place which calculates accurate depreciation monthly, helps you in budgeting and forecasting depreciation costs for next year (years to come). Also when there are assets sale/disposal you need to figure out exact profit or loss on such sale/disposal (especially when it takes place on old days in the month/year) I will guide you through practical accounting issues and situations while accounting for depreciation, forecasting depreciation costs, impact of sale of an assets (profit and loss) on your profit and loss statement and Balance sheet  Depreciation model which I have prepared for the course is quite robust and takes care of any practical scenario in dealing with situations At end of his course, you will have hands-on experience in dealing with any challenging depreciation and fixed assets accounting situation and its financial impact (which your manager would want to know accurately). You will also receipt free copy of the template used in the course !! So let's dive into it ! What Will I Learn? Hands on knowledge on how depreciation and fixed assets accounting works Fixed assets and depreciation forecasting in Business budgeting The impact of the sale of assets prematurely on your profit and loss for the period Requirements Basic to Intermediate knowledge of Microsoft Excel Basic to Intermediate knowledge of Accounting (Practical Accounting) Accounting terms for Fixed Assets and Depreciation (briefly explained in introduction section of this course) Who is the target audience? Accountants who want to sharpen their practical accounting Knowledge for Fixed Assets and depreciation Accounting Auditors who want to audit effectively for Fixed assets and depreciation for their clients Non-Accounting professional/Entrepreneurs who wants to estimate impact of depreciation on their investment and Profit and Loss over fixed term (usually assets useful life) Introduction Accounting For Depreciation with Advanced Excel Model Introduction 00:03:00 Minimum requirements before taking the course 00:01:00 What is Depreciation? What is amortization? And related terms What is Depreciation 00:02:00 What is Amortization? 00:02:00 What Are The Related Terms 00:02:00 Various methods of depreciation and Depreciation Accounting Most common methods of Depreciation 00:09:00 Depreciation Accounting 00:05:00 Depreciation and Taxation Depreciation Tax Shield 00:04:00 Depreciation Tax Shield Under Various Depreciation Methods 00:03:00 Master Depreciation Model (how to use) Introduction and basics of Depreciation Model in Excel 00:01:00 Deep Dive into Depreciation Model 00:07:00 How to use the model with Example 00:10:00 Advanced functionalities of the Model 00:11:00 Conclusion (Thank you) Conclusion 00:01:00

Accounting For Depreciation with Advanced Excel Model
Delivered Online On Demand1 hour 1 minutes
£25

Excel at Marketing Through a Well Defined Marketing Strategy

By The Teachers Training

Overview Excel at Marketing Through a Well Defined Marketing Strategy Course is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Excel at Marketing Through a Well Defined Marketing Strategy Course and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 05 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Excel at Marketing Through a Well-Defined Marketing Strategy Section 01: Create Well-Defined Marketing Objectives Marketing Plan Objectives 00:07:00 Aligning Your Marketing Objectives 00:06:00 Guidelines for Creating Marketing Objectives 00:02:00 Types of Objectives 00:08:00 Workshop - Create Your Marketing Objectives 00:02:00 Section 02: Marketing Programs that Power Customer Acquisition Marketing Programs Explained 00:01:00 What types of marketing programs are best for your business? 00:03:00 Your Website 00:05:00 SEO 00:05:00 Advertising Online 00:09:00 Print Advertising 00:03:00 Press Relations 00:06:00 Social Media 00:05:00 Email 00:06:00 Content Marketing 00:06:00 Trade Shows 00:06:00 Retention Marketing 00:05:00 Additional Marketing Programs 00:04:00 Section 03: Thought Leadership That Drives Customer Acquisition Thought Leadership Explained 00:02:00 Stand Out with Thought Leadership 00:01:00 Why Thought Leadership Matters 00:05:00 Thought Leadership Programs 00:10:00 Workshop: Create Your Thought Leadership Strategy 00:02:00 Section 04: Create a Strategic Marketing Plan That Drives Action Strategic Marketing Plan Explained 00:01:00 Choosing a Marketing Program 00:13:00 Case Study: Product and Services Businesses 00:05:00 Evaluate Your Marketing Mix 00:05:00 Objectives, Tactics, and Assumptions about your marketing program 00:09:00 Common Mistakes 00:03:00 Workshop: Create Your Marketing Action Plan 00:04:00 Support Materials Resource - Excel at Marketing Through a Well Defined Marketing Strategy 00:00:00

Excel at Marketing Through a Well Defined Marketing Strategy
Delivered Online On Demand2 hours 29 minutes
£27.99

Complete QuickBooks Bookkeeping with Excel and Xero Accounting

4.5(3)

By Studyhub UK

Master Quickbooks for all your accounting and bookkeeping needs with this step-by-step training course! The Complete QuickBooks Bookkeeping with Excel and Xero Accounting will build your proficiency in Quickbooks in no time, with instructor-led guidance taking you through fundamental procedures. You will also develop your accounting knowledge, gaining in-demand skills to work for the finance department of top organisations. This practical training course includes up-to-date knowledge, shortcuts and tips for faster, more efficient accounting and bookkeeping. Kickstart your career today and go from beginner to expert in no time! Why buy this Complete QuickBooks Bookkeeping with Excel and Xero Accounting? 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 Complete QuickBooks Bookkeeping with Excel and Xero Accounting 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 Complete QuickBooks Bookkeeping with Excel and Xero Accounting does not require you to have any prior qualifications or experience. You can just enrol and start learning. Prerequisites This Complete QuickBooks Bookkeeping with Excel and Xero Accounting 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 Complete QuickBooks Bookkeeping with Excel and Xero Accounting is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Getting prepared - access the software and course materials The structure of the course - first things first! 00:05:00 Set up free trial 00:03:00 Getting started Starting A New Company File 00:11:00 Setting up the system Enter opening balances 00:02:00 Reverse opening balances - accruals and prepayments 00:06:00 Report Journal 00:05:00 Nominal ledger Amend The Nominal Ledger 00:07:00 Report listing the nominal ledgers 00:02:00 Customers Enter customers 00:09:00 Report on customer contact information 00:01:00 Suppliers Enter Suppliers 00:05:00 Supplier Contact List 00:02:00 Sales ledger Enter Invoices 00:09:00 Invoice Entering 00:03:00 Invoice batch 00:06:00 Post Sales Credit Notes 00:08:00 Report showing Customer Activity 00:03:00 Aged Debtors 00:02:00 Purchases ledger Post Supplier Invoices 00:03:00 Entering a Batch of Supplier Bills 00:09:00 Credit Notes Suppliers 00:05:00 Reclassify Supplier Bills - Flash Bulbs Purchased 00:04:00 Supplier Account Activity Report 00:04:00 Sundry payments Post Cheques 00:07:00 Reports showing supplier payments 00:01:00 Sundry receipts Receipts from customers 00:07:00 Report showing customer receipts 00:02:00 Petty cash Post Petty Cash Transactions and Report 00:04:00 Post cash payments to ledgers 00:02:00 Enter petty cash items 00:14:00 Report on Petty Cash Payments Proper 00:05:00 Post Sundry Payments 00:05:00 Report Bank Payments 00:03:00 VAT - Value Added Tax VAT Return 00:03:00 Bank reconciliation Reconcile The Bank 00:10:00 Provide A Report Showing Any Unreconnciled Transaction 00:02:00 Payroll / Wages Post the Wages Journal 00:08:00 Posting Journal Adjustments 00:02:00 Reports Month end adjustments 00:03:00 Month end reports 00:06:00 Tasks Task- Clearing the accounts 00:06:00 Task - Customer report 00:01:00 Additional Resources Course Paper 00:00:00

Complete QuickBooks Bookkeeping with Excel and Xero Accounting
Delivered Online On Demand3 hours 25 minutes
£10.99

Data Analyst: Data Analysis in Excel

By IOMH - Institute of Mental Health

Overview of Data Analyst: Data Analysis in Excel Join our Data Analyst: Data Analysis in Excel course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The Data Analyst: Data Analysis in Excel course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Data Analyst: Data Analysis in Excel course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now! Get a Quick Look at The Course Content: This Data Analyst: Data Analysis in Excel Course will help you to learn: Learn strategies to boost your workplace efficiency. Hone your skills to help you advance your career. Acquire a comprehensive understanding of various topics and tips. Learn in-demand skills that are in high demand among UK employers This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Data Analyst: Data Analysis in Excel. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-To-One Support from a Dedicated Tutor Throughout Your Course. Study Online - Whenever and Wherever You Want. Instant Digital/ PDF Certificate. 100% Money Back Guarantee. 12 Months Access. Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion - Digital / PDF Certificate After completing the Data Analyst: Data Analysis in Excel course, you can order your CPD Accredited Digital / PDF Certificate for £5.99.  Certificate of Completion - Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? This Data Analyst: Data Analysis in Excel is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand.  On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  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 You don't need any educational qualification or experience to enrol in the Data Analyst: Data Analysis in Excel 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 course. Career Path The certification and skills you get from this Data Analyst: Data Analysis in Excel Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Course Curriculum Modifying a Worksheet 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 Working with Lists 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 Analyzing Data Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts 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 Working with Multiple Worksheets and Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data 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 Analyst: Data Analysis in Excel
Delivered Online On Demand4 hours 43 minutes
£11