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

708 Money Management courses

VLOOKUP: Master Excel Formula VLOOKUP

By IOMH - Institute of Mental Health

Overview of VLOOKUP: Master Excel Formula VLOOKUP Join our VLOOKUP: Master Excel Formula VLOOKUP 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 VLOOKUP: Master Excel Formula VLOOKUP course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The VLOOKUP: Master Excel Formula VLOOKUP 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 VLOOKUP: Master Excel Formula VLOOKUP 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 VLOOKUP: Master Excel Formula VLOOKUP. 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 VLOOKUP: Master Excel Formula VLOOKUP 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 VLOOKUP: Master Excel Formula VLOOKUP 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 VLOOKUP: Master Excel Formula VLOOKUP 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 VLOOKUP: Master Excel Formula VLOOKUP 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 VLOOKUP: Master Excel Formula VLOOKUP Menu Example with Excel Vlookup 00:08:00 Wildcard Search with Excel Vlookup 00:09:00 Looking to the Left with Excel Vlookup 00:17:00 2-Way Lookup 00:14:00 Comparing Lists with Excel Vlookup 00:03:00 Microsoft Excel Vlookup Tips and Tricks 00:14:00

VLOOKUP: Master Excel Formula VLOOKUP
Delivered Online On Demand1 hour 5 minutes
£10.99

Data Analysis In Excel for School Administrators

By The Teachers Training

Data Analysis In Excel for School Administrators 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 Data Analysis In Excel for School Administrators 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 5 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 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 numeracy and IT Desire for entrepreneurship over the age of 16. Assessment The assessment is straightforward, you need to complete the assignment questions that will be provided to you at the end of the course, you can complete the assignment anytime you want. After you complete and submit your assignment, our tutors will assess your assignment and give you feedback if needed.  After your assignment has been assessed and you have passed, you will be qualified and will be able to apply for a course completion certificate. 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. 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:06:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:13:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:08: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:06:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:13:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:09: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:09:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:06:00

Data Analysis In Excel for School Administrators
Delivered Online On Demand4 hours 51 minutes
£27.99

Operations Manager - 8 Courses Bundle

By NextGen Learning

Are you ready to embark on an enlightening journey of wisdom with the Operations Manager 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 - Operations Manager. Delve into eight immersive CPD Accredited courses, each a standalone course: Operations Management Management Skills for New Managers Project Management Operations Management: Enterprise Resource Planning Operations Management: Process Mapping & Supply Chain Operations Management: Resource & Workout Layout Xero Projects & Job Costing Corporate & Strategic Communication Skills for Managers Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the Operations Manager bundle illuminate your path to wisdom. The Operations Manager 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 Operations Manager 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 Operations Manager 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 Operations Manager community today and let your voyage of discovery begin! Learning Outcomes: Attain a holistic understanding in the designated areas of study with the Operations Manager bundle. Establish robust bases across each course nestled within the Operations Manager bundle. Decipher intricate concepts through the articulate content of the Operations Manager 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 Operations Manager 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 Operations Manager 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 Operations Manager bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The Operations Manager 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 Operations Manager bundle allows learners to make meaningful contributions to their chosen fields. Embark on the Operations Manager 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 Operations Manager 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 Operations Manager 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

Operations Manager - 8 Courses Bundle
Delivered Online On Demand32 hours
£39

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

Upgrade Your Excel Skills

By IOMH - Institute of Mental Health

Overview This Upgrade Your Excel Skills course will unlock your full potential and will show you how to excel in a career in Upgrade Your Excel Skills. So upskill now and reach your full potential. Everything you need to get started in Upgrade Your Excel Skills is available in this course. Learning and progressing are the hallmarks of personal development. This Upgrade Your Excel Skills will quickly teach you the must-have skills needed to start in the relevant industry. In This Upgrade Your Excel Skills Course, You Will: Learn strategies to boost your workplace efficiency. Hone your Upgrade Your Excel Skills to help you advance your career. Acquire a comprehensive understanding of various Upgrade Your Excel Skills topics and tips from industry experts. Learn in-demand Upgrade Your Excel Skills that are in high demand among UK employers, which will help you to kickstart your career. This Upgrade Your Excel Skills course covers everything you must know to stand against the tough competition in the Upgrade Your Excel Skills field.  The future is truly yours to seize with this Upgrade Your Excel Skills. Enrol today and complete the course to achieve a Upgrade Your Excel Skills certificate that can change your professional career forever. Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the Upgrade Your Excel Skills course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the Upgrade Your Excel Skills course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.  Certificate of Achievement Upon successfully completing the Upgrade Your Excel Skills course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This Upgrade Your Excel Skills is suitable for anyone aspiring to start a career in Upgrade Your Excel Skills; even if you are new to this and have no prior knowledge on Upgrade Your Excel Skills, this course is going to be very easy for you to understand.  And if you are already working in the Upgrade Your Excel Skills field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  Taking this Upgrade Your Excel Skills course is a win-win for you in all aspects.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements This Upgrade Your Excel Skills course has no prerequisite.  You don't need any educational qualification or experience to enrol in the Upgrade Your Excel Skills 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 Upgrade Your Excel Skills course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Unit 01: Introduction Welcome 00:02:00 Unit 02: Excel Productivity Tips -Part 1 Camera Tool 00:05:00 Add Line Break in Formula Bar 00:03:00 Advanced Copy-Paste using Office Clipboard 00:03:00 Navigation between Worksheets using Shortcut Keys 00:01:00 Flash Fill 00:02:00 Add Multiple Rows and Columns Quickly 00:02:00 Delete Blank Rows 00:03:00 Multi Level Row and Column Sorting 00:04:00 Add Sparklines 00:03:00 Paste Special - Transpose 00:03:00 Unit 03: Excel Productivity Tips - Part 2 Snap to Grid 00:03:00 Create Custom Auto fill List 00:06:00 Absolute Cell Reference 00:03:00 Import Data from Web page 00:04:00 Move Cell Direction 00:03:00 Delete Data using Mouse 00:02:00 Status Bar Quick Calculations 00:03:00 Link Text Boxes to Cell 00:04:00 Phone Number and ZIP Code Format 00:04:00 Speaking Cell 00:05:00 Unit 04: Excel Productivity Tips - Part 3 Invisible Text 00:03:00 Worksheet Grouping 00:04:00 Advanced Transpose 00:04:00 XLStart Folder 00:03:00 Use Slicers 00:05:00 Convert Text to Numbers 00:03:00 Hiding Workbook Elements 00:02:00 Useful Shortcut Keys 00:03:00 Sort data from Left to Right 00:03:00 Advanced Filter (Complex) 00:11:00 Unit 05: Excel Productivity Tips - Part 4 Email as PDF 00:02:00 Synchronous Scrolling 00:03:00 Quick Analysis of data within Excel 00:02:00 Fill blank cells with Value 00:03:00 Hidden Chart Source Data 00:03:00 Two more Shortcuts 00:03:00 Add Blank Rows 00:03:00 Custom views in Excel 00:06:00 EMBED Feature 00:04:00 Adding Country code in Mobile Numbers 00:04:00 Unit 05: Excel Productivity Tips - Part 5 Plot an Average Line to a Chart 00:04:00 3D Referencing 00:04:00 Extract Unique Values 00:03:00 Excel Array Formula 00:04:00 Forecast Sheet 00:04:00 Add Spin Controls in Excel 00:05:00 Move Data using Mouse 00:01:00 Add new entry in Auto Correct to use across Office Applications 00:05:00 Find Differences between Two Lists 00:02:00 Find formulas Quickly 00:02:00 Unit: 06 Wrap Up Thank You 00:01:00

Upgrade Your Excel Skills
Delivered Online On Demand2 hours 57 minutes
£11.99

Financial Modeling Using Excel

5.0(10)

By Apex Learning

Overview This comprehensive course on Financial Modeling Using Excel will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Financial Modeling Using Excel 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 Financial Modeling Using Excel. It is available to all students, of all academic backgrounds. Requirements Our Financial Modeling Using Excel 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 2 sections • 9 lectures • 01:31:00 total length •Welcome to the Course! Get the Overview of What You'll Learn: 00:04:00 •Planning your Financial Model: 00:09:00 •Building a Model Template: 00:12:00 •Projecting the Income Statement: 00:13:00 •Projecting the Balance Sheet: 00:17:00 •Projecting Cash Flows: 00:14:00 •Advanced Financial Modeling: 00:14:00 •BONUS LESSON: Top 5 Excel Features for Financial Modellers: 00:08:00 •Resources - Financial Modeling Using Excel: 00:00:00

Financial Modeling Using Excel
Delivered Online On Demand1 hour 31 minutes
£12

Excel Pivot Tables

5.0(10)

By Apex Learning

Overview This comprehensive course on Excel Pivot Tables will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Excel Pivot Tables 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 Pivot Tables. It is available to all students, of all academic backgrounds. Requirements Our Excel Pivot Tables 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 7 sections • 18 lectures • 00:47:00 total length •Excel Pivot Tables: 00:03:00 •Overview about Store Dataset: 00:02:00 •Data Insights: 00:02:00 •Sales Profit Summary: 00:03:00 •Highlight the Data: 00:01:00 •Unprofitable Products: 00:02:00 •Create Crosstabs: 00:02:00 •Select Regions for Unprofitable Products: 00:04:00 •Real Time Analytics and Insights: 00:02:00 •Search Data for States with Slicers: 00:06:00 •Finding Trends: 00:02:00 •Find Data for Specific Date: 00:04:00 •Reporting Made Easy: 00:02:00 •Generate Reports with Pivot Tables: 00:04:00 •Marketing Analytics: 00:02:00 •Target Your Advertisements: 00:05:00 •Become Analyst: 00:01:00 •Assignment - Excel Pivot Tables: 00:00:00

Excel Pivot Tables
Delivered Online On Demand47 minutes
£12

Microsoft Excel 2016 PowerPivot

4.3(43)

By John Academy

Description: This Microsoft Excel 2016 PowerPivot takes a look at the free PowerPivot add-in for Microsoft Excel 2016. It is a program for all users of PowerPivot to get a good grasp of how its features are set and how it works. It covers interface features, techniques for manipulating PowerPivot data. You will learn how to create PowerPivot reports, the structure of DAX functions, and ways to distribute PowerPivot data. So, if you are interested to develop your skills and knowledge, you shouldn't be late to join this course. Learning Outcomes: Explore PowerPivot applications Importing data from different sources Creating linked tables Organizing and formatting tables Creating calculated columns PowerPivot data filtering and sorting Creating PivotTables and PivotCharts, and filtering data using slicers Presenting Visual data through visual outlets Utilizing DAX functions for manipulating PowerPivot data Extracting data from tables using functions, and working with time dependent data Saving data in different formats and protecting reports 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 Excel 2016 PowerPivot 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 Excel 2016 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 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. Microsoft Excel 2016 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 Excel 2016 PowerPivot 00:00:00 Mock Exam Mock Exam- Microsoft Excel 2016 PowerPivot 00:20:00 Final Exam Final Exam- Microsoft Excel 2016 PowerPivot 00:20:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Microsoft Excel 2016 PowerPivot
Delivered Online On Demand13 hours 10 minutes
£21

Microsoft Excel 2016

By Course Cloud

Course Overview The comprehensive Microsoft Excel 2016 has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the Microsoft Excel 2016 today, and learn from the very best the industry has to offer! This best selling Microsoft Excel 2016 has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Microsoft Excel 2016 is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Microsoft Excel 2016 is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Microsoft Excel 2016 is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Microsoft Excel 2016, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Microsoft Excel 2016 will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Microsoft Excel 2016 to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Microsoft Excel 2016
Delivered Online On Demand
£7.99

Introduction to Excel's Pivot Tables

By IIL Europe Ltd

Introduction to Excel's Pivot Tables This presentation will explore the use of pivot tables, including what they are, what you can do with them, how to create them, and other special features. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

Introduction to Excel's Pivot Tables
Delivered Online On Demand30 minutes
£15