624 Courses

Course Overview Build a solid foundation on Excel Spreadsheet with the Basic Excel Spreadsheet course. This course is designed to introduce you to the ins and outs of excel spreadsheets. Within no time, you will be able to add a new and valuable skill set to your resume. The Basic Excel Spreadsheet course will show you the essential components of the excel spreadsheet. You will understand the method of entertaining data. The course will enrich your knowledge of Autofill and Autosum. From the bite-sized modules, you will pick up skills to use the basic formulas. The course will show you how to format and manage spreadsheets. You will gain the expertise for linking the sheets together. This comprehensive course will also provide you with a detailed introduction to functions. Upon completing the course you will be equipped with the basic skills to operate a spreadsheet. The Basic Excel Spreadsheet course is the online platform to train yourself on the fundamentals of spreadsheets. Enroll in the course to elevate your abilities and increase your employability in the relevant sectors. Learning Outcomes Understand the fundamentals of Excel spreadsheets Learn the process of entering data into spreadsheets Enrich your knowledge of formula basics and copywriting formulas Grasp the skills for formatting spreadsheets Know the process of linking the sheets together Become competent in managing the sheets Who is this course for? Individuals who want to learn the basics of Excel Spreadsheet Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path  The Basic Excel Spreadsheet course is a useful qualification to possess and would be beneficial for any related profession or industry such as: Business Professional Data Operator Data Specialist Basic Excel Spreadsheet Tour of the Excel screen 00:10:00 Entering Data 00:13:00 Autofill Speedfill 00:09:00 Saving the file 00:02:00 Autosum 00:04:00 Formula Basics 00:11:00 Copying formulas - Relative Formulas 00:04:00 Totals and Averages 00:04:00 Formatting the Spreadsheet 00:07:00 Managing the Sheets 00:06:00 Copying formulas - absolute formulas 00:08:00 Linking the Sheets together 00:06:00 Introduction to Functions 00:05:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Overview This comprehensive course on Learn Trigonometry and Trigonometric Functions will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Learn Trigonometry and Trigonometric Functions 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 Learn Trigonometry and Trigonometric Functions. It is available to all students, of all academic backgrounds. Requirements Our Learn Trigonometry and Trigonometric Functions 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 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 7 sections • 54 lectures • 10:40:00 total length •Course Promo: 00:02:00 •Number Tools: 00:10:00 •Graphing Tools: 00:06:00 •The Coordinate Plane: 00:06:00 •Introduction: 00:01:00 •The Unit Circle: 00:08:00 •Terminal Points: 00:31:00 •Reference Number: 00:22:00 •Trigonometric Functions: 00:12:00 •Evaluating Trigonometric Functions: 00:14:00 •Graph of Sine & Cosine: 00:24:00 •Sine & Cosine Graph Transformations: 00:17:00 •Tangent & Cotangent Graphs: 00:20:00 •Secant & Cosecant Graphs: 00:25:00 •Domain and Range of Sin, Cos and Tan: 00:22:00 •Examples: 00:13:00 •Domain and Range of Sec, Csc and Cot: 00:13:00 •Examples: 00:16:00 •Introduction: 00:01:00 •Angles: 00:16:00 •Standard Position: 00:08:00 •Trigonometric Ratios: 00:15:00 •Examples: 00:13:00 •Special Angles: 00:24:00 •Examples: 00:05:00 •Reference Angle: 00:14:00 •Evaluating Trig Functions and Points: 00:18:00 •Inverse Trigonometric Functions: 00:12:00 •The Law of Sines: 00:13:00 •The Law of Cosines: 00:10:00 •Area of a Triangle: 00:08:00 •Introduction: 00:01:00 •Fundamental Identities: 00:10:00 •Examples: 00:18:00 •Addition and Subtraction Formulas: 00:15:00 •Sums of Sines and Cosines: 00:07:00 •Double Angle Formulas: 00:10:00 •Half Angle Formulas: 00:08:00 •Formulas for Lowering Powers: 00:05:00 •Sum-to-Product Formulas: 00:06:00 •Product-to-Sum Formulas: 00:05:00 •Polar Coordinates: 00:19:00 •Polar and Rectangular Coordinates: 00:11:00 •Polar Equations: 00:07:00 •Graph of Polar Equations: 00:18:00 •Symmetry: 00:17:00 •Common Polar Curves: 00:12:00 •Graphing Complex Numbers: 00:06:00 •Modulus: 00:04:00 •Polar Form of Complex Numbers: 00:09:00 •Multiplication and Division: 00:07:00 •De Moivre's Theorem: 00:05:00 •nth Roots of a Complex Number: 00:21:00 •Resource - Learn Trigonometry and Trigonometric Functions: 00:00:00

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Did you know that in the UK, 80% of businesses use spreadsheets according to a recent study? Spreadsheets are a fundamental part of many businesses, but are you getting the most out of them? Proficiency in Excel is a highly sought-after skill in the UK. The average salary for an Excel expert can reach £50,000 and there's a consistent demand for qualified candidates across various industries.This comprehensive Microsoft Excel bundle can help you unlock the full potential of this powerful tool and take your career to the next level. With a single payment, you will gain access to Microsoft Excel course, including 10 premium courses, a QLS Endorsed Hardcopy certificate (for the title course) and 11 PDF certificates for Absolutely free. This Microsoft Excel Bundle Package includes: Main Course : Diploma in Complete Excel Course for All at QLS Level 5 10 Additional CPD Accredited Premium Courses related to Microsoft Excel: Course 01: Ultimate Microsoft Excel For Business Bootcamp Course 02: Business Data Analysis Course 03: Financial Modelling Using Excel Course 04: Microsoft Excel - Beginner, Intermediate & Advanced Course 05: Microsoft Excel Training: Depreciation Accounting Course 06: New Functions in Microsoft Excel Course 07: Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Course 08: Microsoft Excel - 25 Must-Know Formulas and Functions Course 09: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query Course 10: Microsoft Excel: Excel Sheet Comparison with VBA This Microsoft Excel course bundle is designed to take you from complete beginner to advanced user. You'll learn all the essential skills you need to manage data effectively, create impactful charts and graphs, and use formulas and functions to automate complex tasks. Whether you're looking to improve your financial modelling skills, build dynamic dashboards, or simply become more efficient with everyday spreadsheet tasks, this bundle has a course for you. Learning Outcomes of Microsoft Excel Master essential formulas and functions for data manipulation and analysis. Create dynamic charts and graphs to present data insights effectively. Automate tasks and workflows using advanced Excel features. Build interactive dashboards to monitor key performance indicators (KPIs). Learn best practices for data cleaning, organisation, and presentation. Explore VBA programming to further customise your spreadsheets. Invest in your future and enrol now to unlock exciting career possibilities with the power of Microsoft Excel! Why Choose Our Microsoft Excel Bundle? Get a Free QLS Endorsed Certificate upon completion of Microsoft Excel Get a free student ID card with Microsoft Excel Training The Microsoft Excel is affordable and simple to understand The Microsoft Excel is an entirely online, interactive lesson with voiceover audio Lifetime access to the Microsoft Excel course materials The Microsoft Excel comes with 24/7 tutor support Start your learning journey straightaway! *** Course Curriculum *** Main Course : Diploma in Complete Excel Course for All at QLS Level 5 Section 01: Getting Started Section 02: Excel Basics Section 03: Excel Essential Functions Section 04: XLookup Only For Excel 2021 And Office 365 Section 05: Get Data And Tools Section 06: Formatting Data And Tables Section 07: Pivot Tables Section 08: Excel Charts Section 09: Advanced Excel Charts Section 10: Pivot Charts and much more... Course 01: Ultimate Microsoft Excel For Business Bootcamp Microsoft Excel 2019 New Features Getting Started With Microsoft Office Excel Performing Calculations Modifying A Worksheet Formatting A Worksheet Printing Workbooks Managing Workbooks Working With Functions Working With Lists Analyzing Data and much more... Course 02: Business Data Analysis Module 01: Introduction To Business Analysis Module 02: Business Environment Module 03: Business Processes Module 04: Business Analysis Planning And Monitoring Module 05: Strategic Analysis And Product Scope Module 06: Solution Evaluation Module 07: Investigation Techniques Module 08: Ratio Analysis Module 09: Stakeholder Analysis And Management Module 10: Process Improvement With Gap Analysis and much more... =========>>>>> And 8 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your QLS Endorsed Certificates and CPD Accredited Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*11 = £143) QLS Endorsed Hard Copy Certificate: Free (For The Title Course: Previously it was £119) CPD 255 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this Microsoft Excel Training course. This course is ideal for:. Beginners Intermediate Users Advanced Users Data Analysts Business Professionals Anyone who wants to excel in Excel! Requirements You will not need any prior background or expertise to enrol in this Microsoft Excel bundle. Career path After completing this Microsoft Excel bundle, you are to start your career or begin the next phase of your career. Data Analyst Business Analyst Financial Analyst Project Manager Accountant Entrepreneur Certificates CPD QS Accredited PDF Certificate Digital certificate - Included Diploma in Complete Excel Course for All at QLS Level 5 Hard copy certificate - Included

Duration 1 Days 6 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 Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Write VBA code to create VBA subroutines and functions. Use various programming elements to solve problems through code, including variables,objects, conditional statements, and loops. Eliminate, avoid, or handle errors in VBA code, and optimize its performance. VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft Excel and other applications in the Microsoft 365 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 so they can be performed faster, more consistently, and with less effort than performing them manually. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks. You will learn how to use the macro recorder effectively, as well as how to write your own VBA code from scratch. You will use tools built into Excel to explore and learn VBA's capabilities and to optimize and debug your code. 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 Use Macros to Automate Tasks in Excel Identify Components of Macro-Enabled Workbooks Configure the Excel VBA Environment 2. Recording a Macro Use the Macro Recorder to Create a VBA Macro Record a Macro with Relative Addressing Delete Macros and Modules Identify Strategies for Using the Macro Recorder 3. Writing VBA Code Directly Write VBA Code Discover Objects You Can Use Create a Custom Function 4. Solving Problems through Code Make Decisions in Code Work with Variables Perform Repetitive Tasks 5. Improving Your VBA Code Debug VBA Errors Deal with Errors Improve Macro Performance 6. Controlling How and When Macros Run Prompt the User for Information Configure Macros to Run Automatically Additional course details: Nexus Humans VBA with Microsoft Excel (v1.2) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the VBA with Microsoft Excel (v1.2) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Overview This comprehensive course on Excel spreadsheet for Beginner will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Excel spreadsheet for Beginner 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 spreadsheet for Beginner. It is available to all students, of all academic backgrounds. Requirements Our Excel spreadsheet for Beginner 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 2 sections • 14 lectures • 01:29:00 total length •Tour of the Excel screen: 00:10:00 •Entering Data: 00:13:00 •Autofill Speedfill: 00:09:00 •Saving the file: 00:02:00 •Autosum: 00:04:00 •Formula Basics: 00:11:00 •Copying formulas - Relative Formulas: 00:04:00 •Totals and Averages: 00:04:00 •Formatting the Spreadsheet: 00:07:00 •Managing the Sheets: 00:06:00 •Copying formulas - absolute formulas: 00:08:00 •Linking the Sheets together: 00:06:00 •Introduction to Functions: 00:05:00 •Assignment - Excel spreadsheet for Beginner: 00:00:00

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

Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Course Overview "Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!" is designed for learners who want to enhance their Excel skills in a short period. This course covers the essential formulas that are frequently used in both everyday tasks and professional settings. It provides quick, easy-to-follow insights on the most common Excel functions, enabling you to work more efficiently with data, improve productivity, and gain confidence in using Excel’s powerful features. By the end of this course, you will have a comprehensive understanding of 50 key Excel formulas and be able to apply them confidently across various tasks and scenarios. Course Description In this course, learners will be introduced to 50 of the most widely used Microsoft Excel formulas, including basic functions like SUM and AVERAGE, as well as more advanced formulas such as VLOOKUP, IF statements, and pivot table formulas. Each formula is explained with clear examples, offering learners a straightforward approach to improving their Excel proficiency. Whether you are managing data, performing financial analysis, or generating reports, these formulas will significantly enhance your ability to complete tasks faster and more effectively. With a focus on learning key formulas, this course provides an excellent foundation for anyone looking to optimise their Excel skills in a time-efficient way. Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Curriculum Module 01: Introduction to Excel Formulas Module 02: Basic Mathematical Formulas Module 03: Logical Functions and Conditions Module 04: Lookup and Reference Functions Module 05: Text and Date Functions Module 06: Statistical Functions and Analysis Module 07: Advanced Excel Formulas Module 08: Using Formulas for Data Validation and Error Checking Module 09: Formulas for Financial Modelling Module 10: Troubleshooting and Optimising Formulas (See full curriculum) Who is this course for? Individuals seeking to enhance their Excel capabilities. Professionals aiming to improve data management and analysis skills. Beginners with an interest in improving their productivity with Excel. Anyone wanting to quickly learn the key Excel formulas used in daily tasks. Career Path Data Analyst Financial Analyst Project Manager Business Analyst Office Administrator Operations Manager IT Support Specialist

Overview Learn how to become an exemplary Receptionist and positively represent your company when interacting with all clients and customers. Every business needs an efficient administrator to manage the Front-Office, along with providing support and assistance to their boss. We can coach you to become an excellent Receptionist and gain all the required business skills that you'll need to succeed, and the confidence with which to use them. Description The course has been compiled by industry experts and provides an overview of the responsibilities of a valued Receptionist. You will be tutored in a wide range of administrative practises, so that you can immediately start to use them in the office. It also includes training in customer-facing etiquette and suggestions on how to positively improve your company's reputation with clients. Various other crucial office aptitudes will be covered, such as; Time Management, Travel Arrangement, Record Keeping, and Business Writing. Make sure you present the efficiency of your company by enrolling now. Learning outcomes:  Understand the basic requirements needed to run receptions areas efficiently Gain the all-round skills to be a first-class Receptionist Learn how to represent your boss and company in reception Be skilled in organising travel and arranging executive meetings for others Attain the ability to file and retrieve essential company records Acquire the skills to apply excellent communicate practises at work Display great customer service for clients and colleagues Be trusted to handle internal finances and petty cash funding Why People Love And Enrol In The Receptionist Skills From Studyhub: Instantly accessible CPD-accredited certificate on successful completion of this Receptionist Skills 24/7 access to the course for 12 months Study at your own pace No hidden fees or exam charges Full Tutor support on weekdays (Monday - Friday) Efficient assessment and instant results Method of Assessment To assess your learning, you have to participate in an automated multiple-choice question exam. You have to score at least 60% to pass the exam and to qualify for CPD accredited certificates. After passing the exam, you will be able to apply for a certificate. To enhance your knowledge regarding the course and to further assess your learning, you are advised to complete the assignment questions provided at the end of the course, which you can complete anytime you wish.  After submitting the assignment, our expert tutor will assess your assignment and will give you feedback on your performance. Certification After completing the MCQ assessment, you will qualify for the CPD Certificate from Studyhub, as proof of your continued professional development. Certification is available in PDF format, for £9, or a hard copy can be sent to you via post, for just £15. Who is This course for? This course is primarily designed to provide coaching and training for those individuals who aspire to work as Receptionists or a similar role such as a Secretary or PA. Requirements There are no specific prerequisites to enrol in this Receptionist Skills. Anyone and everyone can take this course. The Receptionist Skills is fully accessible from any internet-enabled smart device. So, you can study from the comfort of your home! All you need is a passion for learning, literacy, and to be over the age of 16. Career Path This course provides training and a comprehensive overview of all the skills and knowledge that are needed by a Receptionist or a similar administrative role. As such, it will cover the following roles and careers:  Receptionist Administrative Manager Personal Assistant Private Secretary Human Resources staff Course Curriculum Office Admin and Reception Module 1: Introduction to Reception and Receptionist 00:11:00 Module 2: Business Telephone Skills 00:19:00 Module 3: Representing Your Boss and Company 00:34:00 Module 4: Mail Services and Shipping 00:25:00 Module 5: Travel Arrangements 00:24:00 Module 6: Organising Meeting and Conferences 00:25:00 Module 7: Time Management 00:35:00 Module 8: Record Keeping and Filing Systems 00:28:00 Module 9: Business Writing Skills 00:40:00 Module 10: Organisational Skills 00:25:00 Module 11: Communication Skills 00:25:00 Module 12: Customer Service 00:16:00 Module 13: Effective Planning and Scheduling 00:46:00 Module 14: Invoicing/Petty Cash 00:27:00 Module 15: Business Environment 00:19:00 Advanced MS Excel How to Get the most of the course 00:01:00 Text formulas in Excel 00:08:00 Text Formulas Exercise 00:01:00 Text Formulas Exercise (answers) 00:01:00 Mathematical Formulas In Excel 00:04:00 Mathematical Formulas Exercise 00:01:00 Mathematical Formulas Exercise (answers) 00:01:00 Date and Time Formulas In Excel 00:06:00 Date and Time Formulas Exercise 00:01:00 Date and Time Exercise Formulas (answers) 00:01:00 Logic Formulas In Excel 00:12:00 Logic Formula Exercise 00:01:00 Logic Formula Exercise (answers) 00:01:00 Financial Formula In Excel 00:06:00 Financial Formula Exercise 00:01:00 Financial Formula Exercise (answers) 00:02:00 Informational Formula In Excel 00:04:00 Informational Formula Exercise 00:01:00 Informational Formula Exercise (answers) 00:01:00 Getting Traffic To Your Site 01:00:00 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 Power Query Intro and Excel version 00:03:00 Excel Power Query - Introduction 00:03:00 Enabling M in Power Query 00:02:00 Transform Data - Trim in Excel Power Query 00:05:00 Transform Data - Format Dates and Values in Excel Power Query 00:02:00 Simple Expressions 00:08:00 Simple Expressions - Nested Expressions 00:03:00 Transform Data - Parsing URLs in Excel Power Query 00:05:00 Variables 00:08:00 Formatting Excel Keyboard Shortcuts 00:02:00 Table Excel Keyboard Shortcuts 00:02:00 Editing Excel Keyboard Shortcuts 00:05:00 Formula Excel Keyboard Shortcuts 00:03:00 Workbook Excel Keyboard Shortcuts 00:02:00 Handy Excel Shortcuts Keyboard Shortcuts 00:05:00 Mock Exam Mock Exam - Office Admin and Reception 00:20:00 Final Exam Final Exam - Office Admin and Reception 00:20:00

We know how crucial digital skills are to the modern economy. In the UK, employers report that 33% of positions they find challenging to fill are partly due to applicants' inadequacies in this area. However, because "digital skills" encompasses a broad range of abilities, knowledge, and skills, it is challenging to develop programs that target digital skills demands. Fortunately, Apex Learning has already made an effort to shed light on the matter by highlighting the skills companies seek by summarising all you need to know in a 30-in-1 bundle of Microsoft Office Specialist (MOS) that serves as an excellent foundation to reach the advanced level of Microsoft office. With the help of this bundle, you may quickly and simply master all the most essential and significant aspects of Microsoft Office without wasting time on unimportant stuff. It is designed in a straightforward, easy, and approachable manner. In this bundle, you will be getting the following courses, Package Details: Number of Courses: 30 Courses Accreditation: CPD Quality Standards Free Certificates: PDF: 30Hardcopy: 30 (Delivery Charge Applicable) Courses Access: Lifetime Instalment Payment Available Microsoft Office Specialist (MOS) Course 01: MS Word Diploma Course 02: Proofreading & Copyediting Course 03: PowerPoint Diploma Course 04: Microsoft Excel Level 3 Course 05: New Functions in Microsoft Excel 2021 Course 06: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query Course 07: Microsoft Excel: Excel Sheet Comparison with VBA Course 08: Microsoft Excel: Master Power Query in 120 Minutes! Course 09: Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Course 10: Excel Pivot Tables Course 11: Data Analysis in Microsoft Excel Complete Training Course 12: Excel Must know Formulas and Functions Course 13: Excel spreadsheet for Beginner Course 14: Excel Data Analysis for Beginner Course 15: Diploma in Excel Vlookup Xlookup Match and Index Course 16: Excel Pivot Tables, Pivot Charts, Slicers, and Timelines Course 17: PowerBI Formulas Course 18: Outlook Tips and tricks Course 19: Excel PowerQuery and PowerPivot Course 20: Complete Microsoft Power BI 2021 Course 21: The Complete Microsoft Outlook Masterclass Course 22: The Complete Microsoft OneDrive Course Course 23: MS Access Tables and Queries for Beginner Course 24: MS Access Databases Forms and Reports Level 3 Course 25: Microsoft Teams Course 26: Planning & Control Using Microsoft Project 2013, 2016 & 2019 Course 27: Data Protection and Data Security Level 2 Course 28: Office Skills and Administration Management Diploma Course 29: Touch Typing Essentials Course 30: Document Control Learning Outcomes Upon completion of the course, you will be able to, Discover the MS Word tools. Learn how to make PowerPoint presentations. Gain a thorough understanding of Microsoft Office Excel. Discover how to use Excel for data analysis. Explore the PowerBI formulae. Learn more about Microsoft Access. Project's fundamentals. Increase your understanding of office and administrative management. And much more... This comprehensively designed course includes different tools such as word, excel, PowerPoint, outlook, access etc. As a consequence, the knowledge you acquire from it will make you a better worker and colleague. You will master techniques for utilising Microsoft Office products in this course beyond just using the basic functions. It will boost your working efficiency. The high output will eventually result in career success over the long run. So enrol right away to avoid missing out! CPD 315 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this bundle including- Students Graduates Job Seekers Job Holders Requirements None. Career path The Microsoft Office Specialist (MOS) will help you develop a certain demanding skill and will be beneficial to the following careers, Office Administrator Office Manager Supervisor Executive Assistant Personal Assistant The average annual income for these occupations in the United Kingdom is between £22,000 and £28,000.

This course is designed for students who already have foundational knowledge and skills in Excel and who wish to perform robust and advanced data and statistical analysis with Microsoft Excel using PivotTables, use tools such as Power Pivot and the Data Analysis ToolPak to analyze data and visualize data and insights using advanced visualizations in charts and dashboards in Excel.