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

7085 Courses

Microsoft Office 2007 Excel Advanced - Complete Video Course

4.3(43)

By John Academy

Description: This Microsoft Office 2007 Excel Advanced - Complete Video Course builds on knowledge gained in the Introduction and Intermediate courses. In Advanced Microsoft Office Excel 2007, you will explore the many data analysis tools available in Excel, such as formula auditing, goal seek, Scenario Manager and subtotals. Additionally, during this course you will use advanced functions, learn how to apply conditional formatting, filter and manage your data lists, create and manipulate PivotTables and PivotCharts and record basic macros. You will also learn to use key advanced financial, logical, text, statistical and math, and lookup functions, audit formulas for errors, analyze data using subtotals, goal seek and the scenario manager, use custom and conditional formatting, manage data with tables, filtering and sorting, create, edit and format PivotTables and PivotCharts, import and export date to and from a workbook, create and use macros. So, by taking this course you will have a complete understanding of the higher functions of Excel. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2007 Excel Advanced - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2007 Excel Advanced - Complete Video 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 Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Advanced Functions Logical Functions FREE 00:08:00 Math and Statistical Functions 00:06:00 Financial Functions 00:03:00 Displaying and Printing Formulas 00:02:00 Lookups and Data Tables Using Lookup Functions 00:03:00 Using MATCH and INDEX 00:01:00 Creating Data Tables 00:03:00 Advanced List Management Validating Cell Entries 00:01:00 Exploring Database Functions 00:01:00 PivotTables and PivotCharts Working with PivotTables 00:04:00 Rearranging PivotTables 00:02:00 Formatting PivotTables 00:02:00 PivotCharts 00:01:00 Exporting and Importing Exporting and Importing Text Files 00:07:00 Exporting and Importing XML Data 00:02:00 Querying External Databases 00:03:00 Analytical Options Goal Seek and Solver 00:05:00 The Analysis ToolPak 00:01:00 Scenarios 00:02:00 Views 00:01:00 Macros and Custom Functions Running and Recording a Macro 00:02:00 Working with VBA Code 00:01:00 Creating Functions 00:05:00 Conditional Formatting and SmartArt Conditional Formatting with Graphics 00:03:00 SmartArt Graphics 00:02:00 Mock Exam Mock Exam- Microsoft Office 2007 Excel Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2007 Excel Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Office 2007 Excel Advanced - Complete Video Course
Delivered Online On Demand1 hour 51 minutes
£21

Data Analyst (Data Analytics) Training

4.7(26)

By Academy for Health and Fitness

24 Hours Left! Don't Let the Winter Deals Slip Away - Enrol Now in this Data Analyst Course! Unlock the power of Data Analysis and become a master of insights with our Data Analyst (Data Analytics) course. Gain the Data Analyst skills to decipher complex datasets, extract valuable information, and make data-driven decisions that drive success as a Data Analyst. Join us on this Data Analyst (Data Analytics) course and embark on a journey to transform raw data into actionable intelligence, empowering businesses to thrive in the digital age with Data Analyst (Data Analytics) Courses Included in This Data Analyst (Data Analytics) Training: Course 01: Diploma in Data Analysis at QLS Level 5 Course 02: Diploma in Business Data Analysis at QLS Level 5 Course 03: SQL Masterclass: SQL For Data Analytics Learning outcome of this Data Analyst (Data Analytics) course: Master retail Data analytics for data-driven decisions. Uncover consumer behavior with retail psychology. Enhance retail performance through data analytics. Apply data-driven strategies for retail planning. Optimise inventory and product assortment in retail. Why Prefer This Data Analysis at QLS Level 5 Course? Opportunity to earn a certificate endorsed by the Quality Licence Scheme. Get a free student ID card! (£10 postal charge will be applicable for international delivery) Get instant access to this Data Analyst (Data Analytics) course. Learn Data Analyst (Data Analytics) from anywhere in the world Data Analyst (Data Analytics) is affordable and simple to understand Data Analyst (Data Analytics) is entirely online, interactive lesson with voiceover audio Lifetime access to the Data Analyst (Data Analytics) course materials Data Analyst (Data Analytics) comes with 24/7 tutor support Start your learning journey straight away with this Data Analyst (Data Analytics) course and take a step toward a brighter future! Why Prefer This Data Analyst (Data Analytics) Course? FREE certificate on Data Analyst (Data Analytics) accredited by CPDQS Get instant access to this Data Analyst (Data Analytics) course. Learn Data Analyst (Data Analytics) from anywhere in the world Data Analyst (Data Analytics) is affordable and simple to understand Data Analyst (Data Analytics) is entirely online, interactive lesson with voiceover audio Lifetime Access to the Data Analyst (Data Analytics) course materials Data Analyst (Data Analytics) comes with Data Analysis Assessment Process of Data Analyst(Data Analytics) QLS Course: Assignment & MCQ Based 60% Marks to pass Instant Assessment Certificate of Data Analyst QLS Endorsed Certificate (additional cost) CPD Approved Certificate CPD 150 CPD hours / points Accredited by CPD Quality Standards Course 01- Data Analysis: Modifying a Worksheet 25:59 1: Insert, Delete, and Adjust Cells, Columns, and Rows Preview 10:08 2: Search for and Replace Data 08:38 3: Use Proofing and Research Tools 07:13 Working with Lists 37:47 4: Sort Data 10:03 5: Filter Data 09:49 6: Query Data with Database Functions 09:02 7: Outline and Subtotal Data 08:53 Analyzing Data 12:33 8: Apply Intermediate Conditional Formatting 06:50 9: Apply Advanced Conditional Formatting 05:43 Visualizing Data with Charts 38:03 10: Create Charts 13:18 11: Modify and Format Charts 12:16 12: Use Advanced Chart Features 12:29 Using PivotTables and PivotCharts 44:25 13: Create a PivotTable 13:28 14: Analyze PivotTable Data 12:00 15: Present Data with PivotCharts 07:35 16: Filter Data by Using Timelines and Slicers 11:22 Working with Multiple Worksheets and Workbooks 24:00 17: Use Links and External References 12:24 18: Use 3-D References 05:51 19: Consolidate Data 05:45 Using Lookup Functions and Formula Auditing 30:28 20: Use Lookup Functions 12:45 21: Trace Cells 09:05 22: Watch and Evaluate Formulas 08:38 Automating Workbook Functionality 35:27 23: Apply Data Validation 13:28 24: Search for Invalid Data and Formulas with Errors 04:06 25: Work with Macros 17:53 Creating Sparklines and Mapping Data 07:19 26: MapData 07:19 Forecasting Data 27:54 27: Determine Potential Outcomes Using Data Tables 08:47 28: Determine Potential Outcomes Using Scenarios 09:16 29: Use the Goal Seek Feature 04:16 30: Forecasting Data Trends 05:35 Course 02- Module 1: Introduction to Retail Analytics 32:03 31: Introduction to Retail Analytics Preview 32:03 Module 2: Retail Psychology 07:06 32: Retail Psychology 07:06 Module 3: Retail and Data Analytics 12:00 33: Retail and Data Analytics 12:00 Module 4: Benefits of Retail Analytics 16:26 34: Benefits of Retail Analytics 16:26 Module 5: Retail Strategy 09:44 35: Retail Strategy 09:44 Module 6: Retail Buying and Merchandising 11:27 36: Retail Buying and Merchandising 11:27 Module 7: Forecasting 23:27 37: Forecasting 23:27 Module 8: Retail Pricing 16:30 38: Retail Pricing 16:30 Module 9: Analytics Software 19:37 39: Analytics Software 19:37 Module 10: Supply Chain Management in Retailing 07:37 40: Supply Chain Management in Retailing 07:37 Module 11: The Sales Process and Dealing with Customers at the Checkout 04:57 41: The Sales Process and Dealing with Customers at the Checkout 04:57 Module 12: Selling in Multiple Channels 12:40 42: Selling in Multiple Channels 12:40 Module 13: Taking Trends and Targeting Customers Effectively 05:38 43: Taking Trends and Targeting Customers Effectively 05:38 Assessment (Optional) 12:00 44: MCQ Question 12:00 Order Your Certificate 02:00 45: Order Your CPD Certificate 01:00 46: Order Your QLS Endorsed Certificate 01:00 Who is this course for? Data Analyst (Data Analytics) Training This course is for people who want to quickly and easily learn about Data Analyst (Data Analytics). Requirements Data Analyst (Data Analytics) Training You will not need any prior background or expertise to enrol in this Data Analyst (Data Analytics) course. Career path Data Analyst: £25,000 - £50,000 Junior Data Scientist: £30,000 - £60,000 Senior Data Analyst/Scientist: £50,000 - £100,000 Data Analytics Manager: £60,000 - £120,000 Certificates Cademy certificate of completion Digital certificate - Included Will be downloadable when all lectures have been completed Certificate of completion Digital certificate - £10 Diploma in Retail And Data Analytics at QLS Level 5 Hard copy certificate - £119 Show off Your New Skills with a Certificate of Completion After successfully completing the Diploma in Retail And Data Analytics at QLS Level 5, 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 - 119 GBP inside the UK 129 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)

Data Analyst (Data Analytics) Training
Delivered Online On Demand8 hours
£12

Investment Level 1 Diploma

5.0(1)

By Empower UK Employment Training

Master the intricacies of Investment with a focus on time management, from understanding the success formula to harnessing productivity tools. This course guides you through managing distractions, enhancing focus, and optimizing energy for investment success.

Investment Level 1 Diploma
Delivered Online On Demand1 hour 12 minutes
£5

Microsoft Excel beginner to advanced

By IT's Easy Training

Full Excel Course Beginner to Advanced 6hrs

Microsoft Excel beginner to advanced
Delivered Online On Demand6 hours
£19.99

Life Coach Training - Guideline For The Startup

5.0(10)

By Apex Learning

Overview This comprehensive course on Life Coach Training - Guideline For The Startup will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Life Coach Training - Guideline For The Startup comes with accredited certification, 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 Life Coach Training - Guideline For The Startup. It is available to all students, of all academic backgrounds. Requirements Our Life Coach Training - Guideline For The Startup 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 Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 27 sections • 165 lectures • 10:06:00 total length •What You Will Learn: 00:06:00 •Get To Know Your Instructor: 00:02:00 •How To Get Your CPD Certificates: 00:01:00 •What Is Life Coaching: 00:05:00 •The Benefits Of Becoming A Life Coach: 00:04:00 •The Difference Between Coaching, Therapy, Mentoring & Training: 00:03:00 •The Responsibilities Of A Life Coach: 00:03:00 •Coaching Fundamentals Overview: 00:02:00 •Listening Introduction: 00:02:00 •The 3 Kinds Of Listening As A Coach: 00:05:00 •Your Listening Template: 00:11:00 •Questioning Introduction: 00:01:00 •Questioning & Coaching: 00:03:00 •How Coaching Questions Are Different From Normal Questions: 00:02:00 •The Different Types Of Coaching Questions: 00:12:00 •Questions Summary: 00:03:00 •Building Trust Introduction: 00:01:00 •The Trust Checklist Exercise: 00:03:00 •How To Build Trust As A Coach: 00:08:00 •More Trust Building Strategies: 00:05:00 •Understanding Personalities Overview: 00:03:00 •Big Five Personality Model: 00:02:00 •Myers Briggs Personality Model: 00:04:00 •Your Personality Model: 00:09:00 •How To Bring Out Your Strengths With This Model: 00:10:00 •Coaching Models Introduction: 00:02:00 •GROW Model Explained: 00:05:00 •STEPPPA Model Explained: 00:08:00 •FUEL Model Explained: 00:03:00 •CLEAR Model Explained: 00:04:00 •Why We Will Use The GROW Model: 00:01:00 •Step 1 Introduction: 00:03:00 •Why Defining Your Values Is Important: 00:03:00 •How To Define Your Personal Values: 00:06:00 •What Does Your Ideal Life Look Like?: 00:04:00 •The 4 Biggest Goal Setting Mistakes To Avoid: 00:06:00 •Stretch Goals Explained: 00:03:00 •Why You Should Start With Long Term Goals: 00:05:00 •Setting Your First Long Term Goal: 00:06:00 •Turning Long Term Goals Into Short Term Goals: 00:05:00 •Next Steps: 00:01:00 •Step 2 Introduction: 00:01:00 •Status Quo Explained: 00:06:00 •Wheel Of Life Excercise Explained: 00:06:00 •Big Rocks Exercise Explained: 00:05:00 •Coaching Example Step 2: 00:05:00 •Step 3 Introduction: 00:01:00 •How To Brainstorm With Your Client(s): 00:05:00 •How To Evaluate Your Brainstorming Ideas: 00:05:00 •'Spheres Of Influence' Excerise Explained: 00:03:00 •'Not To Do List' Exercise Explained: 00:04:00 •Coaching Example Step 3: 00:07:00 •Step 4 Introduction: 00:01:00 •The 80/20 Rule Applied To Coaching: 00:04:00 •How To Design An Action Plan: 00:03:00 •Coaching Example Step 4: 00:05:00 •GROW Model Recap: 00:03:00 •Structuring Your Sessions Introduction: 00:01:00 •How To Define Your Coaching Ground Rules: 00:03:00 •How Much Should You Charge: 00:05:00 •The Pre Coaching Call: 00:03:00 •Your First Coaching Session: 00:03:00 •Progress Evaluation Sessions: 00:05:00 •My Recommended Coaching Timeline: 00:03:00 •Client Coach Relationship Intro: 00:01:00 •What Clients Expect From Their Coaches: 00:04:00 •Why Clients Choose One Coach Over Another: 00:02:00 •Client Coach Boundaries: 00:03:00 •How To Retain Clients Long Term: 00:05:00 •Advanced Coaching Strategies Introduction: 00:01:00 •Reframing Explained: 00:07:00 •Managing Emotional States: 00:07:00 •Understanding Representational Systems: 00:08:00 •Personal SWOT Analysis: 00:06:00 •Johari Window - Developing Self Awareness: 00:05:00 •Giving Good Feedback As A Coach: 00:05:00 •Part 2 Introduction: 00:03:00 •What It Means To Be Healthy: 00:04:00 •What Does A Health Coach Do?: 00:03:00 •How Can You Combine Life Coaching & Health Coaching: 00:02:00 •Diet Introduction: 00:01:00 •Your Health & Diet: How They Are Linked: 00:04:00 •The Consequences Of Following A Bad Diet: 00:04:00 •How To Eat For Longevity: 00:02:00 •What Are Calories? Explained: 00:04:00 •The Relationship Between Bodyweight And Health: 00:05:00 •Calories & Bodyweight In A Healthy Diet: 00:02:00 •The Surprising Results Of The Twinkie Diet: 00:02:00 •The Relationship Between Weight Loss And Health: 00:03:00 •Figuring Out How Many Daily Calories You Need: 00:02:00 •Calculating Your Total Daily Calories: 00:03:00 •Healthy Weight Ranges: 00:02:00 •The Best Foods For A Healthier Life: 00:02:00 •Best Protein Foods: 00:01:00 •Best Carbohydrate Foods: 00:01:00 •Best Dietary Fat Foods: 00:01:00 •How Much Of Each (Protein, Carbs, Fat)?: 00:04:00 •What About The Remaining Calories: 00:01:00 •Client Assessment Introduction: 00:01:00 •Client Interview: 00:04:00 •How To Create A Diet Plan For Clients: 00:09:00 •Calculating BMI: 00:03:00 •Cardio Introduction: 00:01:00 •The Different Types Of Cardio: 00:02:00 •Creating A Cardio Workout For A Client: 00:04:00 •How To Monitor Your Heart Rate During A Workout: 00:02:00 •Cardio vs Weigh Training - Which Is Better For Weight Loss: 00:07:00 •Weight Training Introduction: 00:01:00 •Muscle Building Formula: 00:07:00 •The Science Behind Muscle Growth: 00:04:00 •Weight Training vs Bodyweight Training: 00:02:00 •How To Create A Beginner Workout Plan: 00:09:00 •5 Most Important Aspects Of Lifting Form: 00:03:00 •Progressive Overload: 00:03:00 •Hormones Introduction: 00:02:00 •The 3 Types Of Hormones: 00:03:00 •The Endocrine System Explained: 00:04:00 •Hormones & Heart Disease: 00:04:00 •Anabolic Steroids: Why They Are So Dangerous: 00:04:00 •: 00:00:00 •: 00:00:00 •Glucagon: 00:02:00 •Adrenaline: 00:03:00 •Cortisol: 00:04:00 •Ghrelin: 00:02:00 •Leptin: 00:03:00 •Thyroid Hormones: 00:02:00 •Estrogen: 00:03:00 •Growth Hormone: 00:01:00 •Testosterone: 00:03:00 •How To Build Your Own Supplement Stack: 00:09:00 •Top 3 Beginner Supplements For Muscle Growth: 00:04:00 •The Best Supplements To Boost Immunity: 00:04:00 •The Best Supplements For Vegans & Vegetarians: 00:02:00 •The Best Supplements For Joint & Bone Health: 00:02:00 •The Best Supplements For Fat Loss: 00:04:00 •Apex Learning Motivation Introduction: 00:02:00 •How To Get Out Of A Workout Rut: 00:09:00 •What Is Nutrient Density: 00:04:00 •Is Brown Sugar Better Than White Sugar: 00:03:00 •What Should You Train On Your First Day At The Gym?: 00:07:00 •Are Microwaves Harmful?: 00:05:00 •Fresh vs Frozen Food: Which Is Healthier: 00:04:00 •Part 3 Introdudction: 00:02:00 •The Difference Between Stress & Anxiety: 00:03:00 •Short vs Long Term Stress: 00:02:00 •The Effects Of Stress & Anxiety On Your Body: 00:05:00 •Proven Stress Management Strategies & Techniques: 00:03:00 •The Benefits Of Calm Breathing: 00:03:00 •Breathing Exercise #1 - Three Part Breath: 00:02:00 •Breathing Exercise #2 - Bellows Breath: 00:02:00 •Progressive Muscle Relaxation: 00:03:00 •Complete PMR Routine: 00:07:00 •Sleeping For A Longer Life: 00:04:00 •Tips To Fall Asleep Faster: 00:03:00 •Supplements For Improved Sleep: 00:02:00 •What Is Emotional Self Care: 00:05:00 •How To Accept Yourself: 00:03:00 •Taming Your Inner Critic: 00:06:00 •Getting A Different Perspecitive: 00:04:00 •Acknowledging Your Qualities: 00:03:00 •Getting Rid Of Time Consuming Commitments: 00:06:00 •How To Say 'No' To Others: 00:05:00 •Resources - Life Coach Training - Guideline For The Startup: 00:00:00 •Assignment - Life Coach Training - Guideline For The Startup: 00:00:00

Life Coach Training - Guideline For The Startup
Delivered Online On Demand10 hours 6 minutes
£12

Move up a Grade Revision Guide

By Ideas Into Action

Move up a Grade A Revision guide for students in all subjects at school, university and professional levels Course Information   Description Exams are a difficult time. Studying can be tedious and frustrating, but you have to put in the hours in to get the marks. There are no quick fixes, but you can get a better grade with a good revision strategy. This course presents the revision strategy I used to get the second highest mark in the finals of my accountancy qualifications and 10 A’s out of 11 exams through three years of accountancy study. The revision strategy is not complicated, and you still have to do the work – it’s not a magic solution – but it guides you through each phase of revision, and the exam itself, to help you get the best possible marks. I firmly believe that this revision strategy will get you a better mark than you would have without it. Thank you for your interest in this course. I hope this course will help you prepare for your exams   Course Pre-Requisites There are no pre-course requirements.   What Students will Learn How to structure your days and weeks during the revision period How to plan your revision An effective way to learn your material The importance of giving your mind a break – every day The importance of exam practice How to allocate the exam time over the questions How exam marks work To go for the marks, rather than for perfection What to do (and what not to do) on the day of the exam Tips for the exam A simple technique to reduce stress and boost learning     Curriculum SS1 Introduction and Agenda 3 mins SS2 Structure your Week 7 mins SS3 Start Each Day on a Positive Note 2 mins SS4 Revision Phase 1 2 mins SS5 Revision Phase 2 2 mins SS6 Give your Mind a Break 2 mins SS7 Revision Phase 3 5 mins SS8 Revision Phase 4 2 mins SS9 Exam Preparation 1 2 mins SS10 Exam Preparation 2 5 mins SS11 Emotional Freedom Technique 9 mins SS12 The Exam 5 mins SS13 Final Thoughts on Revision 6 mins SS14 Test your Knowledge 8 mins   Total time 1 hour    Additional Resources None     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 finance processes. Ross is also a professional author of online training courses for accountants. Ross lives in Scotland with his wife, daughter and Cocker Spaniel

Move up a Grade Revision Guide
Delivered Online On Demand
£3.65

Excel Spreadsheet for Beginner

5.0(10)

By Apex Learning

Overview This comprehensive course on Excel spreadsheet for Beginner will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Excel spreadsheet for Beginner 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 Excel spreadsheet for Beginner. It is available to all students, of all academic backgrounds. Requirements Our Excel spreadsheet for Beginner 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 2 sections • 14 lectures • 01:29:00 total length •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 - Excel spreadsheet for Beginner: 00:00:00

Excel Spreadsheet for Beginner
Delivered Online On Demand1 hour 29 minutes
£12

Know Your Client (KYC)

5.0(1)

By LearnDrive UK

Master the critical domain of Know Your Client (KYC) practices with this in-depth course. Gain a comprehensive understanding of KYC regulations, client due diligence, anti-money laundering, and more. Elevate your compliance acumen and set a new standard in client onboarding and risk assessment.

Know Your Client (KYC)
Delivered Online On Demand1 hour
£5

Certified Diploma in Microsoft Excel

By iStudy UK

Whether you use excel for work or study, this online course covers beginner, intermediate and advanced lessons in excel. This course is designed to enable you to analyse lots of data and tell a story quickly and interactively. Explore various time-saving Formulas, create automated reports with the press of a button, amaze your manager with professional Excel Charts and get noticed by top management & prospective employers. Course Highlights Certified Diploma in Microsoft Excel is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Certified Diploma in Microsoft Excel into 39 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 1 day, 9 hours hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Certified Diploma in Microsoft Excel Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Certified Diploma in Microsoft Excel is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Certified Diploma in Microsoft Excel 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 Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Microsoft Excel for Beginners Module One - Getting Started FREE 00:30:00 Module Two - Opening Excel FREE 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Worksheet 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Building Formulas 01:00:00 Module Seven - Using Excel Functions 01:00:00 Module Eight - Using Quick Analysis 01:00:00 Module Nine - Formatting Your Data 01:00:00 Module Ten - Using Styles, Themes, and Effects 01:00:00 Module Eleven - Printing and Sharing Your Workbook 01:00:00 Module Twelve - Wrapping Up 01:00:00 Activities - Microsoft Excel for Beginners CPD & IAO Accredited 00:00:00 Microsoft Excel - Intermediate Level Module One - Getting Started 00:30:00 Module Two - Working with Permissions and Options 00:30:00 Module Three - Sharing Workbooks 00:30:00 Module Four - Performing Advanced Formula and Function Tasks 00:30:00 Module Five - Working with Array Formulas 01:00:00 Module Six - Working With Macros 00:30:00 Module Seven - Working With Forms 00:30:00 Module Eight - Applying Advanced Chart Features 01:00:00 Module Nine - Working With Slicers and Timelines 00:30:00 Module Ten - Working With Multiple Tables, Relationships and External Data 00:30:00 Module Eleven - Working With PowerView 00:30:00 Module Twelve - Wrapping Up 01:00:00 Activities- Microsoft Excel Intermediate Level CPD & IAO Accredited 00:00:00 Microsoft Excel - Advanced Level Module One - Getting Started FREE 01:00:00 Module Two - SmartArt and Objects FREE 01:00:00 Module Three - Auditing 01:00:00 Module Four - Creating Charts 01:00:00 Module Five - Working with Charts 01:30:00 Module Six - Creating Pivot Tables and Pivot Charts 01:00:00 Module Seven - Macros 01:00:00 Module Eight - Solving Formula Errors 01:00:00 Module Nine - Using What If Analysis 01:00:00 Module Ten - Managing Your Data 02:00:00 Module Eleven - Grouping and Outlining Data 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Excel Advanced CPD & IAO Accredited 00:00:00 Mock Exam Mock Exam- Certified Diploma in Microsoft Excel 00:30:00 Final Exam Final Exam- Certified Diploma in Microsoft Excel 00:30:00

Certified Diploma in Microsoft Excel
Delivered Online On Demand33 hours
£25

Data Analysis with SQL & Tableau for Data Analytics - 8 Courses Bundle

By NextGen Learning

Are you ready to embark on an enlightening journey of wisdom with the Data Analysis bundle, and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our bundle - Data Analysis with SQL & Tableau for Data Analytics. Delve into eight immersive CPD Accredited courses, each a simple course: Course 1: Introduction to Data Analytics with Tableau Course 2: Big Data Analytics with PySpark Tableau Desktop and MongoDB Course 3: Big Data Analytics with PySpark Power BI and MongoDB Course 4: Google Data Studio: Data Analytics Course 5: SQL for Data Science, Data Analytics and Data Visualization Course 6: Business Analysis Course Level 5 Course 7: Financial Analysis Course 8: Data Analysis and Forecasting in Excel Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the Data Analysis with SQL & Tableau for Data Analytics bundle illuminate your path to wisdom. The Data Analysis with SQL & Tableau for Data Analytics bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across eight carefully curated courses. The journey is designed to enhance your understanding and critical thinking skills. Each course within the bundle provides a deep-dive into complex theories, principles, and frameworks, allowing you to delve into the nuances of the subject matter at your own pace. In the framework of the Data Analysis with SQL & Tableau for Data Analytics package, you are bestowed with complimentary PDF certificates for all the courses included in this bundle, all without any additional charge. Adorn yourself with the Data Analysis bundle, empowering you to traverse your career trajectory or personal growth journey with self-assurance. Register today and ignite the spark of your professional advancement! So, don't wait further and join the Data Analysis with SQL & Tableau for Data Analytics community today and let your voyage of discovery begin! Learning Outcomes: Upon completion of the Data Analysis with SQL & Tableau for Data Analytics Bundle, you will be able to: Attain a holistic understanding in the designated areas of study with the Data Analysis bundle. Establish robust bases across each course nestled within the Data Analysis bundle. Decipher intricate concepts through the articulate content of the Data Analysis bundle. Amplify your prowess in interpreting, scrutinising, and implementing theories. Procure the capacity to engage with the course material on an intellectual and profound level. Become proficient in the art of problem-solving across various disciplines. Stepping into the Data Analysis with SQL & Tableau for Data Analytics bundle is akin to entering a world overflowing with deep theoretical wisdom. Each course within this distinctive bundle is an individual journey, meticulously crafted to untangle the complex web of theories, principles, and frameworks. Learners are inspired to explore, question, and absorb, thus enhancing their understanding and honing their critical thinking skills. Each course invites a personal and profoundly enlightening interaction with knowledge. The Data Analysis bundle shines in its capacity to cater to a wide range of learning needs and lifestyles. It gives learners the freedom to learn at their own pace, forging a unique path of discovery. More than just an educational journey, the Data Analysis with SQL & Tableau for Data Analytics bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The Data Analysis bundle also illuminates the route to a rewarding career. The theoretical insight acquired through this bundle forms a strong foundation for various career opportunities, from academia and research to consultancy and programme management. The profound understanding fostered by the Data Analysis bundle allows learners to make meaningful contributions to their chosen fields. Embark on the Data Analysis journey and let knowledge guide you towards a brighter future. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on deepening their firm understanding in the respective fields. Students pursuing higher education looking for comprehensive theory modules. Professionals seeking to refresh or enhance their knowledge. Anyone with a thirst for knowledge and a passion for continuous learning. Requirements Without any formal requirements, you can delightfully enrol in this Data Analysis with SQL & Tableau for Data Analytics Bundle. Career path Armed with the Data Analysis with SQL & Tableau for Data Analytics bundle, your professional journey can reach new heights. The comprehensive theoretical knowledge from this bundle can unlock diverse career opportunities across several fields. Whether it's academic research, consultancy, or programme management, the Data Analysis bundle lays a solid groundwork. Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hardcopy Transcript: £9.99

Data Analysis with SQL & Tableau for Data Analytics - 8 Courses Bundle
Delivered Online On Demand32 hours
£39