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

856 Microsoft Excel courses delivered Online

Microsoft Office Specialist (MOS) -(30 in 1 Bundle)

By Compliance Central

Feeling Stuck in Your Career? The Microsoft Office Specialist (MOS) -(30 in 1 Bundle) is Your Skill-Building Solution. This exceptional collection of 30 premium courses is designed to encourage growth and improve your career opportunities. Suited to meet different interests and goals, the Microsoft Office Specialist (MOS)bundle provides an engaging learning experience, helping you learn skills across various disciplines. With Microsoft Office Specialist (MOS) -(30 in 1 Bundle) Bundle, you'll have a personalised journey that aligns with your career goals and interests. This comprehensive package helps you confidently tackle new challenges, whether entering a new field or enhancing your existing knowledge. The Microsoft Office Specialist (MOS)bundle is your gateway to expanding your career options, increasing job demand, and enhancing your skill set. By enrolling in this bundle, you'll receive complimentary PDF certificates for all courses, adding value to your resume at no extra cost. Develop key skills and achieve important progress in your career and personal development. Start your journey today and experience the transformative impact of the Microsoft Office Specialist (MOS) -(30 in 1 Bundle) bundle on your job life and career growth! This Microsoft Office Specialist (MOS) -(30 in 1 Bundle) Comprises the Following CPD Accredited Courses: Course 01: Microsoft Word Advanced Course 02: Basic PowerPoint Course 03: Microsoft Excel Course 04: New Functions in Microsoft Excel 2021 Course 05: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query Course 06: Microsoft Excel: Excel Sheet Comparison with VBA Course 07: Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Course 08: Microsoft Excel: Master Power Query in 120 Minutes! Course 09: Excel Pivot Tables Course 10: Data Analysis In Excel Course 11: Excel Must know Formulas and Functions Course 12: Excel spreadsheet for Beginner Course 13: Excel Data Analysis Course 14: Excel Vlookup, Xlookup, Match and Index Course 15: Excel Pivot Tables, Pivot Charts, Slicers, and Timelines Course 16: Outlook Tips and tricks Course 17: PowerBI Formulas Course 18: Excel PowerQuery and PowerPivot Course 19: Microsoft Power BI Course 20: Microsoft Outlook - 25 Must-Know Tips and Tricks Course 21: Microsoft Access for Beginners Course 22: Microsoft Access Tables and Queries Course 23: Microsoft Access Databases Forms and Reports Course 24: Microsoft Teams for Everyone Course 25: Advance Windows 10 Troubleshooting for IT HelpDesk Course 26: Proofreading & Copyediting Course 27: Cyber Security Awareness Training Course 28: Office Skills and Administration Course 29: Admin, Secretarial & PA Course 30: Document Control What will make you stand out? Upon completion of this online Microsoft Office Specialist (MOS) -(30 in 1 Bundle) , you will gain the following: CPD QS Accredited Proficiency with this Microsoft Office Specialist (MOS) Bundle After successfully completing the Microsoft Office Specialist (MOS) bundle, you will receive a FREE PDF Certificate from REED as evidence of your newly acquired abilities. Lifetime access to the whole collection of learning materials of this Microsoft Office Specialist (MOS) Bundle The online test with immediate results You can study and complete the Microsoft Office Specialist (MOS) bundle at your own pace. Study for the Microsoft Office Specialist (MOS) bundle using any internet-connected device, such as a computer, tablet, or mobile device. The Microsoft Office Specialist (MOS) -(30 in 1 Bundle) is a premier learning resource, with each course module holding respected CPD accreditation, symbolising exceptional quality. The content is packed with knowledge and is regularly updated to ensure it remains relevant. This bundle offers not just education but a constantly improving learning experience designed to enrich both your personal and professional development. Advance the future of learning with the Microsoft Office Specialist (MOS) bundle, a comprehensive, complete collection of 30 courses. Each course in the Microsoft Office Specialist (MOS) bundle has been handpicked by our experts to provide a broad range of learning opportunities. Together, these modules form an important and well-rounded learning experience. Our mission is to deliver high-quality, accessible education for everyone. Whether you are starting your career, switching industries, or enhancing your professional skills, the Microsoft Office Specialist (MOS) bundle offers the flexibility and convenience to learn at your own pace. Make the Microsoft Office Specialist (MOS) package your trusted partner in your lifelong learning journey. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Microsoft Office Specialist (MOS) -(30 in 1 Bundle) is perfect for: Expand your knowledge and skillset for a fulfilling career with the Microsoft Office Specialist (MOS) bundle. Become a more valuable professional by earning CPD certification and mastering in-demand skills with the Microsoft Office Specialist (MOS) bundle. Discover your passion or explore new career options with the diverse learning opportunities in the Microsoft Office Specialist (MOS) bundle. Learn on your schedule, in the comfort of your home - the Microsoft Office Specialist (MOS) bundle offers ultimate flexibility for busy individuals. Requirements You are warmly invited to register for this bundle. Please be aware that no formal entry requirements or qualifications are necessary. This curriculum has been crafted to be open to everyone, regardless of previous experience or educational attainment. Career path Gain a wide range of skills across various fields, improve your problem-solving capabilities, and keep current with industry trends. Perfect for those aiming for career advancement, exploring a new professional direction, or pursuing personal growth. Begin your journey with the Microsoft Office Specialist (MOS) bundle. Certificates CPD Certificate Digital certificate - Included

Microsoft Office Specialist (MOS) -(30 in 1 Bundle)
Delivered Online On Demand5 days
£210

Excel Module 1 - Key Skills and Formula Creation

By Underscore Group

Start from the ground up and learn tips, tricks, shortcuts and build confidence in using Excel.

Excel Module 1 - Key Skills and Formula Creation
Delivered OnlineFlexible Dates
£270

Microsoft Office 2016 Excel Beginner to Advanced

4.7(160)

By Janets

Learning Outcomes Familiarise yourself with the basic to advanced level excel tools Learn the process of managing and modifying Workbooks Enrich your knowledge of Pivot Tables and Pivot Charts Develop your skills in data analysis Learn about lookup functions and formula editing Grasp the principles of data mapping and forecasting Microsoft Office 2016 Excel Beginner to Advanced Course Description At this time and age, it is pretty impossible to land a good job without some basic Excel skills. So, if you want to build an impressive resume, it is high time you acquire advanced-level Excel skills. It will uplift your CV and keep you ahead of the competition. The Microsoft Office 2016 Excel Beginner To Advanced course is the perfect place to develop your Excel skills. Here, you will learn basic to advanced-level Excel in no time. In this ultimate course, you will get the opportunity to establish a solid foundation in Excel. The course will first teach you the basic functions and formulas. Gradually, you will learn to work with multiple Worksheets. Furthermore, the course will introduce you to the essentials of Pivot Tables and Pivot Charts. In addition, you will know how to analyse data in Excel. The course will also show you the fundamentals of forecasting data and data mapping. At the end of the course, you will be able to take your Excel skills to the next level. This course will also provide you with a QLS- endorsed certificate and elevate your resume. Join now! Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Upon successful completion of the final assessment, you will be eligible to apply for the Quality Licence Scheme Endorsed Certificate of achievement. This certificate will be delivered to your doorstep through the post for £119. An extra £10 postage charge will be required for students leaving overseas.  CPD Accredited Certificate After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for 9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for 15.99, which will reach your doorsteps by post.  Method of Assessment At the end of the course, there will be an MCQ assessment. In order to pass this exam, you must score at least 60%. When you submit the assessment, it will be examined, and the results will be given to you immediately. Career path This Microsoft Office 2016 Excel Beginner to Advanced course is designed to help you extant your knowledge and understanding of this sector. After completing the course, you will be able to explore career options such as Data Analyst Receptionist Office Admin Data entry Officer Course Contents Microsoft Excel Beginners Getting Started with Microsoft Office Excel 2016 Performing Calculations Modifying a Worksheet Formatting a Worksheet Printing Workbooks Managing Workbooks Microsoft Excel Intermediate Working with Functions Working with Lists Analyzing Data Visualizing Data with Charts Using PivotTables and PivotCharts Microsoft Excel Advanced Working with Multiple Worksheets and Workbooks Using Lookup Functions and Formula Auditing Sharing and Protecting Workbooks Automating Workbook Functionality Creating Sparklines and Mapping Data Forecasting Data Resources

Microsoft Office 2016 Excel Beginner to Advanced
Delivered Online On Demand4 weeks
£9.99

Quantity Surveying, Estimation & Cost Control - CPD Certified

4.7(47)

By Academy for Health and Fitness

FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter

Quantity Surveying, Estimation & Cost Control - CPD Certified
Delivered Online On Demand5 days
£209

Excel 2016 Formulas and Functions

4.5(3)

By Studyhub UK

Welcome to the world of Excel 2016 Formulas and Functions, your key to unlocking the full potential of Microsoft Excel. Whether you're a novice or looking to enhance your spreadsheet skills, this course is your passport to becoming an Excel expert. Get ready to excel in Excel! In this engaging program, you'll embark on a journey through the fundamentals of Excel. You'll learn to navigate Excel commands, create and save workbooks, and enter data efficiently. Dive into the world of formulas and functions, where you'll discover how to create and reuse them effectively. With hands-on activities and customizable options, you'll master Excel like never before, making it an indispensable tool for both personal and professional use. Learning Outcomes Navigate Excel commands with ease. Create and manage basic workbooks. Efficiently enter data into Excel. Harness the power of formulas and functions. Customize Excel to suit your needs. Why choose this Excel 2016 Formulas and Functions course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Excel 2016 Formulas and Functions course for? Beginners looking to master Excel. Professionals seeking to enhance their spreadsheet skills. Students wanting to excel in data management. Individuals aiming to boost their productivity. Anyone eager to unlock the potential of Excel 2016. Career path Data Analyst: £25,000 - £55,000 Financial Analyst: £30,000 - £70,000 Business Analyst: £30,000 - £70,000 Accountant: £25,000 - £60,000 Project Manager: £35,000 - £80,000 Office Manager: £25,000 - £45,000 Prerequisites This Excel 2016 Formulas and Functions does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Getting Started with Microsoft Excel 2016 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Basic Formulas and Functions Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Formulas and Functions Activities 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 Customize Formula Options 00:30:00 Activity - Customize Formula Options 00:05:00 Assignment Assignment - Excel 2016 Formulas and Functions 00:00:00

Excel 2016 Formulas and Functions
Delivered Online On Demand4 hours 25 minutes
£10.99

Microsoft Office Complete Training - Excel, Access, PowerPoint, and Word

5.0(1)

By Course Gate

Master essential Microsoft Office applications, enhance communication, and develop problem-solving skills with the Microsoft Office Complete Training. Suitable for new entrants and professionals alike, gain practical knowledge, expert guidance, and a CPD certificate for career advancement.

Microsoft Office Complete Training - Excel, Access, PowerPoint, and Word
Delivered Online On Demand18 hours 27 minutes
£11.99

Microsoft Office 2016 Excel Beginners - Complete Video Course

4.3(43)

By John Academy

Description: Microsoft Excel, developed by Microsoft Corporation, is world's leading spreadsheet program for Windows, macOS, Android and iOS. The program includes calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications to make your task easy and for saving your precious time. You can hardly find any company where Microsoft Excel is not used. The knowledge of Excel is a must for meeting any career perspective. The course will help you to achieve the goals. Therefore after completing this video course, you will be a prolific user of the program. As the course is sectioned based on the level of difficulty, you will know the basics of Excel at first. You will know how to open an excel program, how to put data or know some simple calculations. After the primary knowledge, you will be introduced to some more features and functions of the program such as analyse massive amounts of data, extract actionable information from it, etc. Finally, you will learn different features of Excel program that allows you take the right business decisions for your company. 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 2016 Excel Beginners - 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 2016 Excel Beginners - 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. Getting Started with Microsoft Office Excel 2016 Navigate the Excel User Interface FREE 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 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 Formatting a Worksheet Apply Text Formats 00:17:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:07:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:08:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:05:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Microsoft Office 2016 Excel Beginners - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2016 Excel Beginners - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Office 2016 Excel Beginners - Complete Video Course
Delivered Online On Demand4 hours 55 minutes
£22

Accountancy, Tax Accounting & Xero Accounting and Bookkeeping

4.7(47)

By Academy for Health and Fitness

***24 Hour Limited Time Flash Sale*** Accountancy, Tax Accounting & Xero Accounting and Bookkeeping Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Welcome to an unparalleled learning experience with our comprehensive 'Accountancy, Tax Accounting & Xero Accounting and Bookkeeping' bundle. This is an exceptional blend of eight theoretical courses tailored for those who aspire to unlock the secrets of the accounting world. Your journey through the labyrinth of numbers begins here! Unearth the treasures of three QLS endorsed courses in Tax Accounting, Xero Accounting and Bookkeeping Online, and a Diploma in Accountancy. Deepen your understanding of these pivotal areas and get a hardcopy certificate upon completion, attesting to your knowledge and dedication. Supplementing these are five CPD QS accredited courses, including an Introduction to Accounting, Managerial Accounting Masterclass, and a complete course on Microsoft Excel 2019. Further specialise with the Theory of Constraints, Throughput Accounting, and Lean Accounting courses. Immerse yourself in the 'Accountancy, Tax Accounting & Xero Accounting and Bookkeeping' bundle. A fulfilling journey of theoretical exploration awaits you! Key Features of the Accountancy, Tax Accounting & Xero Accounting and Bookkeeping Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Accountancy, Tax Accounting & Xero Accounting and Bookkeeping bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Tax Accounting QLS Course 02: Xero Accounting and Bookkeeping Online QLS Course 03: Diploma in Accountancy 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Introduction to Accounting Course 02: Xero Accounting and Bookkeeping Online Course 03: Managerial Accounting Masterclass Course 04: Theory of Constraints, Throughput Accounting and Lean Accounting Course 05: Microsoft Excel Complete Course 2019 In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self-Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our Accountancy, Tax Accounting & Xero Accounting and Bookkeeping courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes of the Accountancy, Tax Accounting & Xero Accounting and Bookkeeping Bundle: By the end of this Accountancy, Tax Accounting & Xero Accounting and Bookkeeping bundle course, learners will be able to: Gain a strong foundational knowledge of accountancy and tax accounting. Understand the nuances of Xero Accounting and Bookkeeping. Enhance your knowledge of managerial accounting practices. Learn the Theory of Constraints, Throughput Accounting and Lean Accounting. Develop skills in using Microsoft Excel for accounting purposes. Obtain a comprehensive introduction to the accounting industry. Be equipped to take on various roles within the accounting sector. The 'Accountancy, Tax Accounting & Xero Accounting and Bookkeeping' bundle brings together eight distinct courses, each designed to provide theoretical insights into different facets of the accounting industry. Each course in this bundle dives into the theoretical aspects of important topics, from Tax Accounting to Managerial Accounting and Xero Bookkeeping. Whether it's comprehending the Theory of Constraints or mastering Microsoft Excel, the courses in this bundle promise a well-rounded understanding of the essentials. Not only do they boost your knowledge, but they also open new avenues of opportunity in your professional journey. Delve into the theoretical complexities of accountancy and let your understanding guide your career. CPD 280 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Accountancy, Tax Accounting & Xero Accounting and Bookkeeping bundle course is ideal for: Aspiring individuals intending to start a career in accountancy or finance. Existing professionals seeking to expand their theoretical knowledge. Students studying accounting or related disciplines. Individuals interested in understanding the theoretical aspects of accounting. Career path Tax Accountant: Approximate Salary -£30,000 to £50,000 per annum Xero Bookkeeper: Approximate Salary -£25,000 to £35,000 per annum Accountant: Approximate Salary -£30,000 to £60,000 per annum Managerial Accountant: Approximate Salary -£40,000 to £60,000 per annum Financial Analyst: Approximate Salary -£30,000 to £55,000 per annum Excel Data Analyst: Approximate Salary -£25,000 to £45,000 per annum Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

Accountancy, Tax Accounting & Xero Accounting and Bookkeeping
Delivered Online On Demand3 days
£309

Programming and Data Wrangling with VBA and Excel

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand. Overview In this course, you will develop and deploy VBA modules to solve business problems. You will: Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Use reference tools built into Excel to get help on VBA programming language and objects used in the Excel VBA environment. Write VBA code to create a custom worksheet function. Eliminate, avoid, or handle errors in VBA code, and optimize its performance. Control how and when macros run. Develop UserForm objects to create custom dialog boxes and windows. Use VBA to read and write data from local files and cloud services. Use VBA to clean and transform data. Run programs and commands outside of Excel and share VBA projects with other users VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft© Excel© and other applications in the Microsoft© Office application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks involving the collection, processing, analysis, and visualization of data. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks, show you how to work with data across different applications, and how to package the macros and functions you create so you can back them up, move them to other computers, and share them with other users Prerequisites To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365? (Desktop or Online) courses, Parts 1, 2, and 3 1 - Using VBA to Solve Business Problems Topic A: Use Macros to Automate Tasks in Excel Topic B: Identify Components of Macro-Enabled Workbooks Topic C: Configure the Excel VBA Environment 2 - Automating Repetitive Tasks Topic A: Use the Macro Recorder to Create a VBA Macro Topic B: Record a Macro with Relative Addressing Topic C: Delete Macros and Modules Topic D: Identify Strategies for Using the Macro Recorder 3 - Getting Help on VBA Topic A: Use VBA Help Topic B: Use the Object Browser to Discover Objects You Can Use in VBA Topic C: Use the Immediate Window to Explore Object Properties and Methods 4 - Creating Custom Worksheet Functions Topic A: Create a Custom Function Topic B: Make Decisions in Code Topic C: Work with Variables Topic D: Perform Repetitive Tasks 5 - Improving Your VBA Code Topic A: Debug VBA Errors Topic B: Deal with Errors Topic C: Improve Macro Performance 6 - Controlling How and When Macros Run Topic A: Prompt the User for Information Topic B: Configure Macros to Run Automatically 7 - Developing Custom Forms Topic A: Display a Custom Dialog Box Topic B: Program Form Events 8 - Using VBA to Work with Files Topic A: Use VBA to Get File and Directory Structure Topic B: Use VBA to Read Text Files Topic C: Use VBA to Write Text Files 9 - Using VBA to Clean and Transform Data Topic A: Automate Power Query Topic B: Transform Data Using VBA and Workbook Functions Topic C: Use Regular Expressions Topic D: Manage Errors in Data 10 - Extending the Programming Environment Beyond the Workbook Topic A: Run Other Programs and Commands Topic B: Share Your VBA Projects

Programming and Data Wrangling with VBA and Excel
Delivered OnlineFlexible Dates
£885

New Excel Functions

By Ideas Into Action

New Excel Functions   Course Description   Ross Maynard     Description In the second half of 2020 Microsoft released a significant upgrade to the most used spreadsheet programme in the world. Microsoft Excel now offers the ability to handle dynamic arrays – functions that return a range of results that update as the source data changes. In this course, we discuss the power of dynamic arrays and introduce the new functions. The functions I am going to cover are: RANDARRAY- creating a table of random numbers or random dates UNIQUE – identifying the distinct items in a list SEQUENCE – listing numbers with a set interval SORT and SORTBY – new ways of dynamically sorting data FILTER – building the ability to filter data into formulae XLOOKUP – replacing VLOOKUP with greater flexibility IFS and SWITCH making it easier to construct IF statements The new CONCAT, and TEXTJOIN text functions   If you have an earlier version of Microsoft Excel then these functions will not be available to you and this course might not be for you. But if you do have a subscription to Office365 – either personally or through your work – I think you will find this course extremely useful.         Learning Outcomes Participants in this course will learn: What the new dynamic arrays feature in Microsoft Excel means How the new RANDARRAY function works How the new UNIQUE function works How the new SEQUENCE function works How the new SORT and SORTBY functions work How the new FILTER function works How the new XLOOKUP function can replace VLOOKUP How to build IF statements with the new IFS function How the new SWITCH function works How the new TEXTJOIN function can replace CONCATENATE and CONCAT How the new functions can be used in management reporting     Course Requirements There are no pre-course requirements.   Additional Resources Course Spreadsheet with the examples covered.       About Ross Ross Maynard is a Fellow of the Chartered Institute of Management Accountants in the UK. He is director of Ideas2Action Process Excellence Ltd and has 30 years’ experience as a process improvement consultant and facilitator. Ross is also a professional author of online training courses for accountants. Ross lives in Scotland with his wife, daughter and Cocker Spaniel

New Excel Functions
Delivered Online On Demand
£4.61