3601 Office Skills & Productivity courses

Level 7 QLS Endorsed Diploma | 180 CPD Points | +Gifts: QLS Certificate + PDF Certificate | 24/7 Learner Support

Microsoft Excel® in Depth (Virtual) This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses.This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables

Microsoft Excel® in Depth The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE

Microsoft Excel® in Depth (In-Person) This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses.This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Feeling Stuck in Your Career? The SAP, Project Management, Quality Assurance (QA) & Business Finance - 40 CPD Courses Bundle is Your Skill-Building Solution. This exceptional collection of 40 premium courses is designed to encourage growth and improve your career opportunities. Suited to meet different interests and goals, the SAP, Project Management, Quality Assurance (QA) & Business Finance bundle provides an engaging learning experience, helping you learn skills across various disciplines. With SAP, Project Management, Quality Assurance (QA) & Business Finance - 40 CPD Courses 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 SAP, Project Management, Quality Assurance (QA) & Business Finance 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 SAP, Project Management, Quality Assurance (QA) & Business Finance - 40 CPD Courses bundle on your job life and career growth! This SAP, Project Management, Quality Assurance (QA) & Business Finance - 40 CPD Courses Bundle Comprises the Following CPD Accredited Courses: Course 01: SAP Controlling (CO) - Product Costing S4HANA Course 02: SAP S4HANA Controlling - Cost Center Accounting Course 03: Operations Management: Enterprise Resource Planning Course 04: Project Management Training Course 05: Fundamentals of Business Analysis Course 06: Applied Business Strategy for Managers Course 07: Financial Analysis Course 08: Financial Controller Training Course 09: Accounting and Finance Course 10: Finance: Financial Investigator Course 11: Financial Ratio Analysis for Business Decisions Course 12: Quality Management Course 13: Diploma in Lean Process and Six Sigma Course 14: Business Project Manager Training Course 15: Agile Scrum Master Certification Course 16: Rapid Business Improvement Course 17: Automation of Processes Course 18: Process Improvement Course 19: RCA: Root Cause Analysis Course 20: Business Productivity Training Course 21: Marketing Principles Course 22: Product Management Course 23: Retail Management Diploma Course 24: Inventory Management Training Course 25: Logistics Management Course 26: Supply Chain Management Course 27: Certificate in Purchasing and Procurement Course 28: Transport Planner/ Transport Management Diploma Course 29: Xero Accounting and Bookkeeping Online Course 30: Advanced Tax Accounting Course 31: HR Management Course Course 32: Diploma in Customer Relationship Management (CRM) Course 33: Time Management Training - Online Course Course 34: Career Development Plan Fundamentals Course 35: CV Writing and Job Searching Course 36: Learn to Level Up Your Leadership Course 37: Networking Skills for Personal Success Course 38: Ace Your Presentations: Public Speaking Masterclass Course 39: Learn to Make a Fresh Start in Your Life Course 40: Motivation - Motivating Yourself & Others What will make you stand out? Upon completion of this online SAP, Project Management, Quality Assurance (QA) & Business Finance - 40 CPD Courses Bundle, you will gain the following: CPD QS Accredited Proficiency with this SAP, Project Management, Quality Assurance (QA) & Business Finance Bundle After successfully completing the SAP, Project Management, Quality Assurance (QA) & Business Finance 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 SAP, Project Management, Quality Assurance (QA) & Business Finance Bundle The online test with immediate results You can study and complete the SAP, Project Management, Quality Assurance (QA) & Business Finance bundle at your own pace. Study for the SAP, Project Management, Quality Assurance (QA) & Business Finance bundle using any internet-connected device, such as a computer, tablet, or mobile device. The SAP, Project Management, Quality Assurance (QA) & Business Finance - 40 CPD Courses 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 SAP, Project Management, Quality Assurance (QA) & Business Finance bundle, a comprehensive, complete collection of 40 courses. Each course in the SAP, Project Management, Quality Assurance (QA) & Business Financebundle 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 SAP, Project Management, Quality Assurance (QA) & Business Finance bundle offers the flexibility and convenience to learn at your own pace. Make the SAP, Project Management, Quality Assurance (QA) & Business Finance package your trusted partner in your lifelong learning journey. CPD 400 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The SAP, Project Management, Quality Assurance (QA) & Business Finance - 40 CPD Courses is perfect for: Expand your knowledge and skillset for a fulfilling career with the SAP, Project Management, Quality Assurance (QA) & Business Finance bundle. Become a more valuable professional by earning CPD certification and mastering in-demand skills with the SAP, Project Management, Quality Assurance (QA) & Business Finance bundle. Discover your passion or explore new career options with the diverse learning opportunities in the SAP, Project Management, Quality Assurance (QA) & Business Financebundle. Learn on your schedule, in the comfort of your home - the SAP, Project Management, Quality Assurance (QA) & Business Finance 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 SAP, Project Management, Quality Assurance (QA) & Business Finance bundle. Certificates CPD Certificates Digital certificate - Included

Gain advanced administrative, secretarial, and PA skills with our Level 5 course. Enhance your professional capabilities and excel in a dynamic work environment.

Do you know what the key skills graduate employers look for? Most employers often emphasise on industry-standard skills

Build your communication skills to boost the productivity of office administration. Learn Business Etiquette, Organisational Skills, Effective Planning and Scheduling.

Level 2 QLS Endorsed Diploma | 100 CPD Points | +Gifts: QLS Certificate + PDF Certificate | 24/7 Learner Support