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

576 Money Management Tools courses in Cardiff delivered On Demand

Microsoft Excel Beginner to Intermediate

By Compete High

Overview   With the ever-increasing demand for MS Excel in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in MS Excel may be.   Learning about MS Excel or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in MS Excel. That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on MS Excel is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates.   The self-paced online learning methodology by compete high in this Microsoft Excel Beginner to Intermediate course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course!   Instead of searching for hours, enrol right away on this Microsoft Excel Beginner to Intermediate course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run.   Who is this course for?   While we refrain from discouraging anyone wanting to do this Microsoft Excel Beginner to Intermediate course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of MS Excel, Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in MS Excel, Anyone looking for a certificate of completion on doing an online training on this topic, Students of MS Excel, or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity   Career Path   This Microsoft Excel Beginner to Intermediate course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams.  Course Curriculum Module 01-Excel Interface Module 01-Excel Interface 00:00 Module-02-Basic Functions Module-02-Basic Functions 00:00 Module-03-Working With Worksheet Module 03-Working With Worksheet 00:00 Module-04-Work with Data and Excel tables Module-04-Work with Data and Excel tables 00:00 Module-05-Basic Calculations Module-05-Basic Calculations 00:00 Module-06-Shortcuts in Excels Module-06-Shortcuts in Excels 00:00

Microsoft Excel Beginner to Intermediate
Delivered Online On Demand6 hours
£4.99

Microsoft Excel Crash Course 2024: Masterclass for Weekend

By Compete High

🚀 Unlock Your Excel Potential with the Microsoft Excel Crash Course 2024: Masterclass for Weekend! 🚀 Are you tired of spending endless hours trying to figure out Microsoft Excel on your own? Do you want to boost your skills and become an Excel pro without sacrificing your entire weekend? Look no further - our Microsoft Excel Crash Course 2024 is here to revolutionize the way you work with spreadsheets!   🔥 Why Excel Matters: In today's data-driven world, Excel proficiency is a non-negotiable skill. Whether you're a student, a professional, or someone looking to enhance your productivity, mastering Excel can open doors to new opportunities.   💡 What Sets Our Masterclass Apart: ✅ Weekend-Friendly Format: We get it - your time is precious! That's why our course is designed to be completed over a weekend, giving you the skills you need without disrupting your busy schedule. ✅ Hands-On Learning: Forget boring lectures! Dive straight into hands-on, practical exercises that reinforce your learning. Our step-by-step approach ensures you grasp each concept thoroughly. ✅ Up-to-Date Content: Excel evolves, and so do we! Our 2024 edition is packed with the latest features and best practices, ensuring you're on the cutting edge of spreadsheet mastery. ✅ Expert Guidance: Learn from seasoned Excel experts who've cracked the code to efficient and effective spreadsheet use. Benefit from their real-world insights and insider tips that go beyond basic functions. ✅ Lifetime Access: Purchase once, benefit forever! Gain access to our course materials, updates, and a supportive community, ensuring you stay on top of your Excel game for years to come.   📚 Course Highlights: 👉 Essential Excel Functions: From basic formulas to advanced functions, we cover it all. 👉 Data Visualization: Transform your data into impactful charts and graphs. 👉 Pivot Tables Mastery: Unlock the power of data analysis with Pivot Tables. 👉 Time-Saving Shortcuts: Work smarter, not harder, with keyboard shortcuts. 👉 Advanced Formulas: Impress your colleagues with advanced calculations. 👉 Automation with Macros: Streamline your tasks with Excel automation. 👉 Error Handling: Learn how to troubleshoot and avoid common mistakes.   🎓 Who Should Enroll: Professionals looking to enhance their spreadsheet skills. Students aiming to boost their academic performance. Entrepreneurs and business owners seeking data-driven insights. Anyone wanting to save time and increase productivity.   🌟 Get Ready to Excel! Don't miss out on this opportunity to become an Excel maestro in just one weekend! Enroll now in the Microsoft Excel Crash Course 2024: Masterclass for Weekend and empower yourself with the skills that will set you apart. 👉 Limited seats available. Secure your spot now! 👈 Disclaimer: Results may vary based on individual commitment and practice. Course Curriculum Module- 1 Introduction 00:00 Getting started on Windows, macOS, Android, and IOS 00:00 How to ask great questions 00:00 FAQ 00:00 Start Excel 00:00 Module- 2 Overview of top Excel tips 00:00 Add numbers like a pro 00:00 Save time by filling cells automatically 00:00 Did data enter into one column - Split it 00:00 Switch data around by transposing it 00:00 Sort and filter for quick results 00:00 Create a data table for tasks to make it easy 00:00 Make drop-down list 00:00 Quick Data Analysis 00:00 Great charts for your visualization 00:00 Pivot Tables for Data Analytics 00:00 Module- 3 Introduction 00:00 Basic formula operations 00:00 Mathematical functions level1 00:00 Mathematical functions level2 00:00 Text functions level1 00:00 Text functions level2 00:00 Logical functions 00:00 Date time functions 00:00 V Lookup formula 00:00 HLookup formula 00:00 HLookup Match formula 00:00 Match Index formula 00:00 Module- 4 Introduction 00:00 XLookup 00:00 Handling NA and Approximates match in XLookup 00:00 Wildcard matching in XLookup 00:00 Module- 5 Introduction 00:00 Split Text into columns 00:00 Flash Fill 00:00 Remove Duplicates 00:00 Data Validation 00:00 Get - import Data from Text 00:00 Get - import Data from CSV 00:00 Module- 6 Introduction 00:00 Creating Pivot Table 00:00 Value field settings 00:00 Number format 00:00 Pivot Table Design 00:00 Excel Exercise 00:00 Solution for Excel Exercise 00:00 Module- 7 Introduction 00:00 Excel Charts - Categories 00:00 Elements of a chart 00:00 Easy way to create charts 00:00 Column or Bar charts 00:00 Formatting charts 00:00 Line charts 00:00 Area charts 00:00 Pie and Doughnut charts 00:00 Format Area Plot or XY chart 00:00 Scatter or bubble charts 00:00

Microsoft Excel Crash Course 2024: Masterclass for Weekend
Delivered Online On Demand5 hours 15 minutes
£4.99

Upgrade Excel Skill: 50 Best Tips

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

Upgrade Excel Skill: 50 Best Tips
Delivered Online On Demand2 hours 57 minutes
£25

Market Research Analyst Advanced Diploma - 8 Courses Bundle

By NextGen Learning

Are you ready to embark on an enlightening journey of wisdom with the Market Research Analyst bundle and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our course bundle - Market Research Analyst Advanced Diploma. Delve into eight immersive CPD Accredited courses, each a standalone course: Course 01: Marketing Principles Course 02: Marketing Secrets for High Sales Course 03: Marketing Strategies for Business Course 04: Learn with Case Study - Market Research Course 05: Research Methods in Business Course 06: Business Intelligence Analyst Course Course 07: Excel at Marketing Through a Well-Defined Marketing Strategy Course 08: Sales Analysis in Excel Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the Market Research Analyst Advanced Diploma bundle illuminate your path to wisdom. The Market Research Analyst Advanced Diploma 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 Market Research Analyst Advanced Diploma 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 Market Research Analyst 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 Market Research Analyst Advanced Diploma community today and let your voyage of discovery begin! Learning Outcomes: Attain a holistic understanding in the designated areas of study with the Market Research Analyst bundle. Establish robust bases across each course nestled within the Market Research Analyst bundle. Decipher intricate concepts through the articulate content of the Market Research Analyst 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 Market Research Analyst 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 Market Research Analyst 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 Market Research Analyst bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The Market Research Analyst 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 Market Research Analyst bundle allows learners to make meaningful contributions to their chosen fields. Embark on the Market Research Analyst 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. Career path Armed with the Market Research Analyst 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 Market Research Analyst 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

Market Research Analyst Advanced Diploma - 8 Courses Bundle
Delivered Online On Demand31 hours
£39

Data Analysis in Microsoft Excel Complete Training

4.9(27)

By Apex Learning

Overview We live in an era where data, data and data surround us. You need to share something one way or another to use most of the services around you; just name it. Whether it is about reading a blog post, visiting a website, surveying for a service, seeing any social media post, or looking for offers, you must share some data, if not anything, and your email, at least.But do you ever realise why, in all these situations, you need to share your data? Because your data is oxygen in this world. Companies want to know what you are thinking or what you are about to do before you even think or are about to do it. Sounds crazy, right? Don't be.It is a new branch of knowledge and profession. A data analyst gathers, cleans, and evaluates data sets to find an explanation or resolve an issue. The most common tool for doing these is Microsoft Excel. Our Data Analysis in Microsoft Excel Complete Training course will prepare you to use Microsft Excel in data analysis. What Can You Expect To Achieve By Completing This Course? Proficiency in modifying and organising data within Excel worksheets. Skills in working with lists and effectively analysing data. Ability to create visual representations of data using charts and graphs. Competence in using PivotTables and PivotCharts for data summarisation and analysis. Command in managing multiple worksheets, workbooks, and advanced Excel functions for data manipulation and forecasting. 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 in Microsoft Excel Complete Training. It is available to all students, of all academic backgrounds. Requirements Our Data Analysis in Microsoft Excel Complete Training 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 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 11 sections • 31 lectures • 04:46: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:10:00 •Use Lookup Functions: 00:12:00 •Trace Cells: 00:05:00 •Watch and Evaluate Formulas: 00:10: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 in Microsoft Excel Complete Training
Delivered Online On Demand4 hours 46 minutes
£12

Level 2 Microsoft Office Essentials

4.9(27)

By Apex Learning

Level 2 Microsoft Office Essentials

Level 2 Microsoft Office Essentials
Delivered Online On Demand5 hours
£12

Introduction to FinTech Using R

By Packt

This course provides basic introductory guidance to FinTech. You will be using an easy programming language R to learn some basic statistics in money management. You will also understand how to time the stock market and build tradeable factor-based algorithms from scratch. This course provides some of the most basic rules of thumb and intuition that every successful trader should know.

Introduction to FinTech Using R
Delivered Online On Demand2 hours 14 minutes
£41.99

Financial Modelling & Valuation Analyst (FMVA) Essentials - CPD Certified

4.5(3)

By Studyhub UK

24 Hour Flash Deal **40-in-1 Financial Modelling & Valuation Analyst (FMVA) Essentials Mega Bundle** Financial Modelling & Valuation Analyst (FMVA) Essentials Enrolment Gifts **FREE PDF Certificate**FREE PDF Transcript ** FREE Exam** FREE Student ID ** Lifetime Access **FREE Enrolment Letter ** Take the initial steps towards a successful long-term career by studying the Financial Modelling & Valuation Analyst (FMVA) Essentials package online with Studyhub through our online learning platform. The Financial Modelling & Valuation Analyst (FMVA) Essentials bundle can help you improve your CV, wow potential employers, and differentiate yourself from the mass. This Financial Modelling & Valuation Analyst (FMVA) Essentials course provides complete 360-degree training on Financial Modelling & Valuation Analyst (FMVA) Essentials. You'll get not one, not two, not three, but forty Financial Modelling & Valuation Analyst (FMVA) Essentials courses included in this course. Plus Studyhub's signature Forever Access is given as always, meaning these Financial Modelling & Valuation Analyst (FMVA) Essentials courses are yours for as long as you want them once you enrol in this course. This Financial Modelling & Valuation Analyst (FMVA) Essentials Bundle consists the following career oriented courses: Course 01: Financial Modelling Course 02: Financial Modelling Course for a Non-Finance Background Course 03: Make Business Plans: Forecasting and Budgeting Course 04: Managing Budget: Financial Statements and Money Management Course 05: Capital Budgeting & Investment Decision Rules Course 06: Raise Money and Valuation for Business Course 07: Microsoft Excel Complete Course 2019 Course 08: VLOOKUP: Master Excel Formula VLOOKUP in 60 minutes! Course 09: Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Course 10: SQL for Data Science, Data Analytics and Data Visualization Course 11: Microsoft PowerPoint for Beginners Course 12: Accounting Fundamentals Diploma Course 13: Understanding Financial Statements and Analysis Course 14: Fundamentals of Corporate Finance Course 15: Investment Banking Operations Professional Course 16: Fundamentals of Business Analysis Course 17: Finance: Financial Risk Management Course 18: Credit Control and Compliance Training Course 19: AutoCAD VBA Programming - Beginner course Course 20: Python Basic Programming for Absolute Beginners Course 21: Financial Planning Course 22: Cost Control Process and Management Course 23: Economics Level 2 Diploma Course 24: Actuary Certification: Navigating the Complex World of Risk and Finance Course 25: Finance Law Fundamentals: Legal Aspects of Financial Transactions Course 26: Accounts Receivable Management: Optimising Financial Processes Course 27: Efficient Accounts Payable Processing: Streamlining Financial Transactions Course 28: Demystifying Depreciation Accounting: Financial Insights Course 29: Mastering Partnership Accounting: Financial Strategies and Reporting Course 30: Finance for Non-finance Managers Certification Course 31: Corporate Finance: Profitability in a Financial Downturn Course 32: Business Strategy Planning Course 33: Debt Management, Assessment, Financing & Counselling Course 34: Machine Learning Basics Course 35: CompTIA CySA+ Cybersecurity Analyst Course Course 36: Business Finance Course 37: Financial Investigator Course 38: Financial Analysis Methods Course 39: Personal Financial Management & Wellness Course 40: Tax Strategy and Financial Planning for Beginners In this exclusive Financial Modelling & Valuation Analyst (FMVA) Essentials bundle, you really hit the jackpot. Here's what you get: Step by step Financial Modelling & Valuation Analyst (FMVA) Essentials lessons One to one assistance from Financial Modelling & Valuation Analyst (FMVA) Essentials professionals if you need it Innovative exams to test your knowledge after the Financial Modelling & Valuation Analyst (FMVA) Essentials course 24/7 customer support should you encounter any hiccups Top-class learning portal Unlimited lifetime access to all forty Financial Modelling & Valuation Analyst (FMVA) Essentials courses Digital Certificate, Transcript and student ID are all included in the price PDF certificate immediately after passing Original copies of your Financial Modelling & Valuation Analyst (FMVA) Essentials certificate and transcript on the next working day Easily learn the Financial Modelling & Valuation Analyst (FMVA) Essentials skills and knowledge you want from the comfort of your home The Financial Modelling & Valuation Analyst (FMVA) Essentials course has been prepared by focusing largely on Financial Modelling & Valuation Analyst (FMVA) Essentials career readiness. It has been designed by our Financial Modelling & Valuation Analyst (FMVA) Essentials specialists in a manner that you will be likely to find yourself head and shoulders above the others. For better learning, one to one assistance will also be provided if it's required by any learners. The Financial Modelling & Valuation Analyst (FMVA) Essentials Bundle is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Financial Modelling & Valuation Analyst (FMVA) Essentials bundle course has been created with forty premium courses to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Financial Modelling & Valuation Analyst (FMVA) Essentials Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into Financial Modelling & Valuation Analyst (FMVA) Essentials Elementary modules, allowing our students to grasp each lesson quickly. The Financial Modelling & Valuation Analyst (FMVA) Essentials course is self-paced and can be taken from the comfort of your home, office, or on the go! With our Student ID card you will get discounts on things like music, food, travel and clothes etc. CPD 400 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Financial Modelling & Valuation Analyst (FMVA) Essentials training is suitable for - Students Recent graduates Job Seekers Individuals who are already employed in the relevant sectors and wish to enhance their knowledge and expertise in Financial Modelling & Valuation Analyst (FMVA) Essentials. Requirements To participate in this Financial Modelling & Valuation Analyst (FMVA) Essentials course, all you need is - A smart device A secure internet connection And a keen interest in Financial Modelling & Valuation Analyst (FMVA) Essentials. Career path You will be able to kickstart your Financial Modelling & Valuation Analyst (FMVA) Essentials career because this course includes various courses as a bonus. This bundle is an excellent opportunity for you to learn multiple skills from the convenience of your own home and explore Financial Modelling & Valuation Analyst (FMVA) Essentials career opportunities. Certificates CPD Accredited Certificate Digital certificate - Included CPD Accredited e-Certificate - Free CPD Accredited Hardcopy Certificate - Free Enrolment Letter - Free Student ID Card - Free Quality Licence Scheme Endorsed Certificate of Achievement Hard copy certificate - Included Upon successful completion of the course, you will be eligible to order QLS Endorsed Hardcopy Certificate titled 'Financial Modelling at QLS Level 3' Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses.

Financial Modelling & Valuation Analyst (FMVA) Essentials - CPD Certified
Delivered Online On Demand9 days
£399

Microsoft Office 2016 Excel PowerPivot

By iStudy UK

The Microsoft Office 2016 Excel PowerPivot is designed for new PowerPivot users to get up to speed on how it works and its feature set. The course covers different features of the interface, techniques for manipulating PowerPivot data, how to create PowerPivot reports, the structure of DAX functions, and ways to distribute PowerPivot data. You will learn how to enable and navigate Power Pivot, how to manage data relationships, how to visualize Power Pivot data, how to create a Power Pivot report, and more. You will also learn some commonly used DAX functions. Prerequisite Course: Excel Level 3 or equivalent. Course Highlights Microsoft Office 2016 Excel PowerPivot is an award-winning and the best selling course that has been given the CPD Qualification Standards & 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 Microsoft Office 2016 Excel PowerPivot into 19 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 12 hours, 30 minutes 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 Microsoft Office 2016 Excel PowerPivot Lifetime access to the course No hidden fees or exam charges CPD Qualification Standards 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? Microsoft Office 2016 Excel PowerPivot is CPD Qualification Standards 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 Microsoft Office 2016 Excel PowerPivot 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 Qualification Standards and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Microsoft Office 2016 Excel PowerPivot Enable and Navigate 00:30:00 Import Data from Various Data Sources 01:00:00 Refresh Data from a Data Source 00:30:00 Create Linked Tables 00:30:00 Organize and Format Tables 00:30:00 Create Calculated Columns 00:30:00 Sort and Filter PowerPivot Data 00:30:00 Create and Manage Table Relationships 01:00:00 Create PivotTables 01:00:00 Create PivotCharts 00:30:00 Create Power Views 01:00:00 Filter Data Using Slicers 00:30:00 Present PivotTable Data Visually 01:00:00 Manipulate PowerPivot Data Using DAX Functions 01:00:00 Extract Data from Tables Using Functions 00:30:00 Save Reports in Different File Formats 01:00:00 Work with Time Dependent Data 00:30:00 Protect Reports 00:30:00 Activities and Exercise Files - Microsoft Office 2016 Excel PowerPivot 00:00:00

Microsoft Office 2016 Excel PowerPivot
Delivered Online On Demand12 hours 30 minutes
£25

Microsoft Excel for Beginners

5.0(1)

By Course Gate

Almost every business, organization, companies, and individual owner need Microsoft Excel to record finances, hours, data, and to perform many other activities at once. It is widely used software that assists to analyze data, send invoices, share works with different people at a time, and function many more activities. Are you looking fresher? Don't you have any training and knowledge about this software? Are you interested to improve your skills to pursue the best position in any organization? if so, the ultimate Microsoft Excel for Beginners course assists you to learn further all you need in your quest. As the course is online based, you can complete it from any part of the world at any time at your own pace. The course is accessible through an internet connection from any Computer, Laptop, Mac, smartphones, or any electronic devices that support MS Excel software. The course contents require a few minutes for each. So, it is convenient for you to start or stop at any time as you want. It entertains you, though you have less than 20 minutes to go through this course. Who is this Course for? Microsoft Excel for Beginners is 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. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of the English language, numeracy and ICT are required to attend this course CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £4.99 and the hard copy for £9.99. Also, you can order both PDF and hardcopy certificates for £12.99 Course Curriculum Excel Beginners Identify the Elements of the Excel Interface 00:30:00 Activity - Identify the Elements of the Excel Interface 00:05:00 Create a Basic Worksheet 01:00:00 Activity - Create a Basic Worksheet 00:05:00 Use the Help System 00:30:00 Activity - Use the Help System 00:05:00 Create Formulas in a Worksheet 01:00:00 Activity - Create Formulas in a Worksheet 00:05:00 Insert Functions in a Worksheet 00:30:00 Activity - Insert Functions in a Worksheet 00:05:00 Reuse Formulas 00:30:00 Activity - Reuse Formulas 00:05:00 Manipulate Data 00:30:00 Activity - Manipulate Data 00:05:00 Insert, Manipulate, and Delete Cells, Columns, and Rows 00:30:00 Activity - Insert, Manipulate, and Delete Cells, Columns, and Rows 00:05:00 Search For and Replace Data 00:30:00 Activity - Search For and Replace Data 00:05:00 Spell Check a Worksheet 00:30:00 Activity - Spell Check a Worksheet 00:05:00 Modify Fonts 00:30:00 Activity - Modify Fonts 00:05:00 Add Borders and Colors to Cells 01:00:00 Activity - Add Borders and Colors to Cells 00:05:00 Apply Number Formats 00:30:00 Activity - Apply Number Formats 00:05:00 Align Cell Contents 00:30:00 Activity - Align Cell Contents 00:05:00 Apply Cell Styles 00:30:00 Activity - Apply Cell Styles 00:05:00 Define the Basic Page Layout for a Workbook 01:00:00 Activity - Define the Basic Page Layout for a Workbook 00:05:00 Refine the Page Layout and Apply Print Options 00:30:00 Activity - Refine the Page Layout and Apply Print Options 00:05:00 Format Worksheet Tabs 00:30:00 Activity - Format Worksheet Tabs 00:05:00 Manage Worksheets 00:30:00 Activity - Manage Worksheets 00:05:00 Manage the View of Worksheets and Workbooks 00:30:00 Activity - Manage the View of Worksheets and Workbooks 00:05:00 Customize General and Language Options 00:30:00 Activity - Customize General and Language Options 00:05:00 Customize Formula Options 00:30:00 Activity - Customize Formula Options 00:05:00 Customize Proofing and Save Options 01:00:00 Activity - Customize Proofing and Save Options 00:05:00 Customize the Ribbon and Quick Access Toolbar 00:30:00 Activity - Customize the Ribbon and Quick Access Toolbar 00:05:00 Customize the Functionality of Excel by Enabling Add-Ins 00:30:00 Activity - Customize the Functionality of Excel by Enabling Add-Ins 00:05:00 Customize Advanced and Trust Center Options 00:30:00 Activity - Customize Advanced and Trust Center Options 00:05:00 Activities and Exercise Files - Microsoft Excel 2016 for Beginners 00:00:00 Mock Exam Mock Exam- Microsoft Excel for Beginners 00:20:00 Final Exam Final Exam- Microsoft Excel for Beginners 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Microsoft Excel for Beginners
Delivered Online On Demand18 hours 20 minutes
£11.99