677 Money Management Tools courses delivered Online

A series of hourly small group sessions where we look at different aspects of Excel Duration: 1 hr sessions Alternatively, we can do you one-to-one sessions, either via virtual classroom or in person at our training course. These are £30 per hour, or £125 for 5-hour blocks.

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.

Become an expert in Microsoft Excel with our comprehensive online training program. Learn formulas, charts, pivot tables, data analysis, macros, and more. Develop in-demand Excel skills through hands-on exercises and project work. Gain proficiency in this powerful software to advance your career or improve productivity.

Excel isn’t just about cells and charts—it’s where numbers tell stories. This Excel Data Analysis (Microsoft Office) Course is designed for those who want to make sense of spreadsheets without staring blankly at endless rows. Whether you’re handling budgets, forecasts, or good old-fashioned reports, you’ll explore Excel’s powerful tools that help turn raw data into clear insights. VLOOKUPs, pivot tables, conditional formatting—yes, the good stuff is all here, and it’s less scary than it sounds. No fluff, just focused learning. This course cuts straight to what matters: using Excel as a decision-making companion. From sorting data like a spreadsheet whisperer to creating charts that even your boss might understand, the content is structured to be logical, easy to follow, and surprisingly enjoyable. Whether you’re in finance, admin, marketing, or somewhere in between, this is for anyone who’s had a spreadsheet say, “figure me out,” and needed the right nudge in the right direction. Learning Outcomes: Trace formulas and use Excel's Scenario Manager and Goal Seek Use Solver and Data Tables to analyse data Utilise Data Analysis Tools to draw insights from data sets Create forecasts with Excel's Forecast Sheet Understand popular formulas like Sumif, Countif, and If Apply advanced formula techniques like And, Or, and Nested If. Course Curriculum: Excel Data Analysis for Beginner Tracing Formulas Using the Scenario Manager Goal Seek Solver Data Tables Data Analysis Tools Forecast Sheet Sumif, Countif, Averageif, Sumifs, and Countifs formulas If, And, Or, and Nested If formulas How is the course assessed? Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%. Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of __ GBP. £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The course is ideal for highly motivated individuals or teams who want to enhance their professional skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Data Analyst - £30,000 to £45,000 Financial Analyst - £35,000 to £55,000 Marketing Analyst - £25,000 to £40,000 Business Intelligence Analyst - £35,000 to £60,000 Sales Analyst - £25,000 to £40,000 Project Coordinator - £25,000 to £35,000 Certificates Certificate of completion Digital certificate - £9 You can apply for a CPD Accredited PDF Certificate at the cost of £9. Certificate of completion Hard copy certificate - £15 Hard copy can be sent to you via post at the expense of £15.

Turn Your Dreams into Reality with the Excel Analyst - Excel Data Analysis and Visualisation Course Training course. This comprehensive Excel Analyst - Excel Data Analysis and Visualisation Course online course will equip you with the knowledge and skills you need to succeed in your chosen field. Whether you're a beginner or looking to take your career to the next level, this course has covered you. Key Learning Outcomes: Understanding the core concepts and theories in your field Building your knowledge and skills through practical, hands-on learning Developing the ability to think critically and solve problems effectively Enhancing your communication skills and the ability to work effectively with others Gaining a competitive edge in your career and reaching your full potential With a flexible online format that allows you to learn at your own pace, Excel Analyst - Excel Data Analysis and Visualisation Course training course offers a convenient and accessible way to boost your career prospects. So why wait? Enrol today and take the first step towards success! Vital Component of the Excel Analyst - Excel Data Analysis and Visualisation Course course: CPD Accredited Course Unlimited Retake Exam & Tutor Support Easy Accessibility to the Course Materials 100% Learning Satisfaction Guarantee Lifetime Access & 24/7 Support Self-paced online course Modules Covers to Explore Multiple Job Positions Transform your career with the Excel Analyst - Excel Data Analysis and Visualisation Course Bundle! Perfect your skills and stand out in the employment market with our comprehensive training program. Impress potential employers and add valuable expertise to your resume. Don't wait-enrol in the Excel Analyst - Excel Data Analysis and Visualisation Course Bundle now and take the first step towards a successful and fulfilling career! Course Outline: Modifying a Worksheet Working with Lists Analyzing Data Visualizing Data with Charts Using PivotTables and PivotCharts Working with Multiple Worksheets and Workbooks Using Lookup Functions and Formula Auditing Automating Workbook Functionality Creating Sparklines and Mapping Data Forecasting Data CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is the perfect fit for anyone seeking to start or advance in the Excel Analyst - Excel Data Analysis and Visualisation Course industry. Whether you're a beginner or looking to expand your knowledge, this comprehensive training will provide you with the essential skills and expertise to succeed. Requirements Join the Excitement-With this Excel Analyst - Excel Data Analysis and Visualisation Course course, there's no limit to what you can achieve. From day one, you'll be on your way to building a fulfilling career in this thriving field. No prior experience is required to enrol in this course. Career path Upon completion, you'll have the opportunity to pursue a variety of in-demand Excel Analyst - Excel Data Analysis and Visualisation Course jobs, with endless possibilities for growth and success. Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Microsoft Excel is more than just rows and columns — it's a powerhouse for professionals who know how to make it work for them. This course zeroes in on four of Excel’s most essential lookup functions: VLOOKUP, XLOOKUP, MATCH, and INDEX. Whether you're reconciling data, building dynamic reports, or navigating large spreadsheets, these tools save time, reduce errors, and make you look like you actually enjoy spreadsheets — even if you don’t. You'll learn how each function behaves, when to use one over the other, and how to string them together to achieve powerful results. The course is designed for learners who want to use Excel efficiently, without getting buried in formulas that behave like they’ve had too much coffee. With clear explanations, useful examples, and a touch of logic that even your sleep-deprived Monday brain can follow, this course gets straight to the point. If you've ever stared at a dataset wondering where to begin, you're in the right place — no fluff, just formulas that do the heavy lifting. Learning Outcomes: Utilise Vlookup and Xlookup to retrieve data efficiently Understand how to use Match and Index functions Learn to compare and match large data sets Automate data processing and analysis Improve data accuracy and reliability Increase productivity and save time on manual calculations Course Curriculum: 1.1 Excel vlookup 1.2 Excel xlookup 1.3 Excel vlookup 1.4 Excel vlookup 1.5 Excel vlookup 1.6 Excel vlookup 1.7 Excel vlookup How is the course assessed? Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%. Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of __ GBP. £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The course is ideal for highly motivated individuals or teams who want to enhance their professional skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Data Analyst (£26,000 - £45,000) Financial Analyst (£25,000 - £50,000) Business Analyst (£26,000 - £52,000) Accountant (£22,000 - £48,000) Operations Manager (£24,000 - £61,000) Project Manager (£29,000 - £65,000) Certificates Certificate of completion Digital certificate - £9 You can apply for a CPD Accredited PDF Certificate at the cost of £9. Certificate of completion Hard copy certificate - £15 Hard copy can be sent to you via post at the expense of £15.

Navigating large datasets in Excel can feel like finding a needle in a haystack — until you’ve met Pivot Tables. This Pivot Tables Essentials Course breaks down the complexities and equips learners with the know-how to summarise, organise and interpret data with ease. Whether you're dealing with spreadsheets brimming with figures or just seeking a smarter way to report, this course offers a structured route to clarity using one of Excel’s most powerful tools. You’ll learn how to create, customise and fine-tune Pivot Tables to spot patterns, extract insights and make informed decisions. From filtering data like a pro to arranging fields for meaningful output, this course walks through the essential functions with purpose and precision. It’s ideal for professionals who spend more time than they'd like scrolling through spreadsheets — and prefer letting Excel do the heavy lifting. Ask ChatGPT Learning Outcomes: Gain a solid understanding of pivot tables and their capabilities. Learn how to create and format pivot tables in Excel. Discover how to sort and filter your data, and use the "show field values as" feature to analyze your data in different ways. Understand how to group and summarize your data using pivot tables. Learn how to create pivot charts to visualize your data, and use macros to automate repetitive tasks. The Pivot Tables Essentials course is designed to provide you with the skills and knowledge you need to master pivot tables in Excel. Whether you're a beginner or an experienced Excel user, this course is perfect for anyone who wants to take their data analysis skills to the next level. You'll learn how to create and format pivot tables, sort and filter your data, and use the "show field values as" feature to analyze your data in different ways. You'll also discover how to group and summarize your data, create pivot charts to visualise your data, and use macros to automate repetitive tasks and streamline your workflow. Pivot Tables Essentials Course Curriculum Section 01: Introduction Section 02: Axis and Formatting Section 03: Sorting and Filtering Section 04: Grouping and Analysis Section 05: Show Field Values As Section 06: Pivot Charts Section 07: Macro How is the course assessed? Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%. Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of __ GBP. £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Business professionals who work with data and want to analyze it more efficiently. Analysts who want to take their Excel skills to the next level. Entrepreneurs who want to analyze their business data more effectively. Students who want to enhance their Excel skills and prepare for a career in data analysis. Anyone who wants to develop their skills in data analysis and Excel. Career path Data Analyst: £24,000 - £45,000 Business Analyst: £26,000 - £50,000 Financial Analyst: £28,000 - £60,000 Management Consultant: £35,000 - £95,000 Chief Financial Officer: £90,000 - £250,000 Certificates Certificate of completion Digital certificate - £9 You can apply for a CPD Accredited PDF Certificate at the cost of £9. Certificate of completion Hard copy certificate - £15 Hard copy can be sent to you via post at the expense of £15.

Are you looking for a way to boost your productivity and efficiency with Excel? Do you want to learn how to create, analyze and visualize data in powerful and versatile spreadsheets? If so, then our level 2 online Excel course is perfect for you! This course will teach you how to use advanced functions, formulas, charts, tables, pivot tables and macros in Excel. You will learn how to work with large datasets, automate tasks, perform data analysis and create professional reports and dashboards. You will also get tips and tricks to optimize your workflow and save time. The course is suitable for anyone who has some basic knowledge of Excel and wants to take their skills to the next level. You will have access to video lectures, exercises, quizzes and downloadable resources. You will

Description: This Microsoft Office 2010 Excel Intermediate - Complete Video Course builds on the skills and concepts taught in Excel 2010: Basic. You will learn how to use multiple worksheets and workbooks efficiently, and you will start working with more advanced formatting options including styles, themes, and backgrounds, create informative, eye-catching charts and harness the power of Excel's data analysis and filtering tools, how to create outlines and subtotals, how to create and apply cell names, and how to work with tables. You will save workbooks as Web pages, insert and edit hyperlinks, and learn to share workbooks by email. In addition, you'll find out how easy it is to create macros that let you manipulate data with the push of a button. You'll also discover how to use Goal Seek and Solver and apply them to real-world problems. And you'll set yourself apart from the casual Excel user by adding time-saving functions to your repertoire. 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 2010 Excel Intermediate - 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 2010 Excel Intermediate - 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. Using Multiple Worksheets and Workbooks Using Multiple Workbooks 00:05:00 Linking Worksheets with 3-D Formulas 00:05:00 Linking Workbooks 00:09:00 Managing Workbooks 00:04:00 Advanced Formatting Using Special Number Formats 00:10:00 Using Functions to Format Text 00:09:00 Working with Styles 00:08:00 Working with Themes 00:07:00 Other Advanced Formatting 00:17:00 Outlining and Subtotals Outlining and Consolidating Data 00:13:00 Creating Subtotals 00:06:00 Cell and Range Names Creating and Using Names 00:14:00 Managing Names 00:07:00 Tables Sorting and Filtering Data 00:09:00 Advanced Filtering 00:08:00 Working with Tables 00:10:00 Web and Sharing Features Saving Workbooks as Web Pages 00:05:00 Using Hyperlinks 00:06:00 Sharing Workbooks 00:03:00 Advanced Charting Chart Formatting Options 00:05:00 Combination Charts 00:08:00 Graphical Elements 00:11:00 Documenting and Auditing Auditing Features 00:05:00 Comments in Cells and Workbooks 00:04:00 Protection 00:08:00 Workgroup Collaboration 00:09:00 Templates and Settings Application Settings 00:08:00 Built-in Templates 00:04:00 Creating and Managing Templates 00:05:00 PivotTables and PivotCharts Working with PivotTables 00:14:00 Rearranging PivotTables 00:06:00 Formatting PivotTables 00:03:00 Using PivotCharts 00:04:00 Mock Exam Mock Exam- Microsoft Office 2010 Excel Intermediate - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2010 Excel Intermediate - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: This Microsoft Office 2013 Excel Intermediate - Complete Video Course covers the intermediate functions and features of Excel 2013. You will learn about creating formulas, inserting graphics and enhancing workbooks. You will also learn how to organize worksheet data with tables and charts and how to analyze data using PivotTables, Slicers and PivotCharts. In this course creating advanced formulas, you will learn how to apply range names and how to use specialized functions. Once you are comfortable with the basics, you will be ready for this intermediate level. Here, you will explore more advanced formatting with terms, using Excel provided templates, adding graphics and charts, and using Excel as a database. You finish off with advanced formulas and applying conditional formatting to your worksheet, and more. If you want to take your Microsoft Excel 2013 skills to the next level, you'll learn how to use this program's advanced features to build a fully functional database from scratch. 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 2013 Excel Intermediate - 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 2013 Excel Intermediate - 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. Creating Advanced Formulas Apply Range Names FREE 00:18:00 Use Specialized Functions 00:14:00 Analyzing Data with Logical and Lookup Functions Leverage Questions and Testing to Write Formulas 00:01:00 Use Logical and Lookup Functions to Find Answers to Questions 00:25:00 Organizing Worksheet Data with Tables Create and Modify Tables 00:09:00 Sort and Filter Data 00:27:00 Use Summary and Database Functions to Calculate Data 00:25:00 Visualizing Data with Charts Create Charts 00:05:00 Modify and Format Charts 00:25:00 Create a Trendline 00:10:00 Create Advanced Charts 00:09:00 Analyzing Data with PivotTables, Slicers, and PivotCharts Create a PivotTable 00:24:00 Filter Data by Using Slicers 00:09:00 Analyze Data by Using PivotCharts 00:07:00 Inserting Graphics Insert and Modify Graphic Objects 00:10:00 Layer and Group Graphic Objects 00:12:00 Incorporate SmartArt 00:06:00 Enhancing Workbooks Customizing Workbooks 00:08:00 Manage Themes 00:06:00 Create and Use Templates 00:06:00 Protect Files 00:08:00 Mock Exam Mock Exam- Microsoft Office 2013 Excel Intermediate - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2013 Excel Intermediate - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00