887 Microsoft Excel courses

Become a Microsoft Certified Excel Expert - includes lectures, test exercises, and video solutions

**Don't Spend More; Spend Smarter** Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now Give a compliment to your career and take it to the next level. This Personal Finance will provide you with the essential knowledge to shine in your professional career. Whether you want to develop skills for your next job or elevate skills for your next promotion, this Personal Finance will help you keep ahead of the pack. The Personal Finance incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your expertise and essential knowledge, which will assist you in reaching your goal. Further, this Personal Finance will add extra value to your resume to stand out to potential employers. Throughout the programme, it stresses how to improve your competency as a person in your chosen field while also outlining essential career insights in this job sector. Consequently, you'll sharpen your knowledge and skills; on the other hand, see a clearer picture of your career growth in future. By the end of the Personal Finance, you can equip yourself with the essentials to keep you afloat in the competition. Along with this Personal Finance course, you will get 10 premium courses, an original Hardcopy, 8 PDF Certificates (Main Course + Additional Courses) Student ID card as gifts. This Personal Finance Bundle Consists of the following Premium courses: Course 01: Professional Personal Finance Course Course 02: Introduction to Accounting Course 03: Accounting and Bookkeeping Level 2 Course 04: Level 3 Tax Accounting Course 05: Financial Analysis Course 06: Level 2 Financial Planning and Management Course Course 07: Investment Course 08: Stock Market Investing for Beginners Course 09: Microsoft Excel Training: Depreciation Accounting Course 10: Financial Modeling Using Excel Course 11: Advanced Diploma in MS Excel So, enrol now to advance your career! Benefits you'll get choosing Apex Learning: Pay once and get lifetime access to 8 CPD courses Free e-Learning App for engaging reading materials & helpful assistance Certificates, student ID for the title course included in a one-time fee Free up your time - don't waste time and money travelling for classes Accessible, informative modules designed by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills How will I get my Certificate? After successfully completing the course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £10 * 11 = £110) Hard Copy Certificate: Free (For The Title Course) If you want to get hardcopy certificates for other courses, generally you have to pay £20 for each. But with this special offer, Apex Learning is offering a Flat 50% discount on hard copy certificates, and you can get each for just £10! PS The delivery charge inside the UK is £3.99, and the international students have to pay £9.99. Curriculum: Course 01: Professional Course Section 01: Introduction Section 02: Personal Finance Section 03: Personal Expenses and Income Section 04: Savings Section 05: How to Manage Your Personal Finance Using Free Budgeting Software Course 02: Introduction to Accounting Accounting Fundamental What is Financial Accounting Accounting Double Entry System and Fundamental Accounting Rules Financial Accounting Process and Financial Statements Generates Basic Accounting Equation and Four Financial Statements Define Chart of Accounts and Classify the accounts External and Internal Transactions with companies Short Exercise to Confirm what we learned in this section Accounting Policies What are Major Accounting Policies need to be decided by companies Depreciation Policies Operational Fixed Asset Controls Inventory Accounting and Controls Revenue Accounting and Controls Course 03: Accounting and Bookkeeping Level 2 Introduction to the course Introduction to Bookkeeping Bookkeeping systems Basics of Bookkeeping The functionality of bookkeeping On a personal note Course 04: Level 3 Tax Accounting Tax System and Administration in the UK Tax on Individuals National Insurance How to Submit a Self-Assessment Tax Return Fundamentals of Income Tax Advanced Income Tax Payee, Payroll and Wages Capital Gain Tax Value Added Tax Import and Export Corporation Tax Inheritance Tax Double Entry Accounting Management Accounting and Financial Analysis Career as a Tax Accountant in the UK Course 05: Financial Analysis Introduction Profitability Return Ratio Liquidity Ratio Operational Analysis Detecting Manipulation Course 06: Level 2 Financial Planning and Management Course Personal Finance Calculations Saving for Retirement Building Credit to Buy a Home Personal Finance Guides for Beginners Cashflow Management Budgets and Money Management Course 07: Investment Introduction to Investment Types and Techniques of Investment Key Concepts in Investment Understanding the Finance Investing in Bond Market Investing in Stock Market Risk and Portfolio Management Course 08: Stock Market Investing for Beginners Module 01: Introduction to the Course Module 02: Introduction to Stocks Module 03: Money Required for Primary Investment Module 04: Opening an Investment Account Module 05: Brokerage Account Walkthrough Module 06: Finding Winning Stocks Module 07: Earning from Dividends Module 08: Diversifying Portfolio Module 09: Investment Plan Module 10: Rebalancing Portfolio Module 11: Understanding Order Types Module 12: Investment Tax Module 13: Investment Rules: Rule-1 Module 14: Investment Rules: Rule-2 Module 15: Investment Rules: Rule-3 Module 16: Investment Rules: Rule-4 Module 17: Investment Rules: Rule-5 Module 18: Stock Market Dictionary Module 19: Setting Up the Trading Platform Course 09: Microsoft Excel Training: Depreciation Accounting Introduction Depreciation Amortization and Related Terms Various Methods of Depreciation and Depreciation Accounting Depreciation and Taxation Master Depreciation Model Conclusion Course 10: Financial Modeling Using Excel Welcome to the Course! Get the Overview of What You'll Learn Planning your Financial Model Building a Model Template Projecting the Income Statement Projecting the Balance Sheet Projecting Cash Flows Advanced Financial Modeling BONUS LESSON: Top 5 Excel Features for Financial Modellers Course 11: Advanced Diploma in MS Excel 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 Visualizing Data with Charts Using PivotTables and PivotCharts 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 Excel VBA Data Management CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this bundle. Persons with similar professions can also refresh or strengthen their skills by enrolling in this course. Students can take this course to gather professional knowledge besides their study or for the future. Requirements Ouris fully compatible with PC's, Mac's, laptops, tablets 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 this various expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included

The Microsoft Office Essentials - 3 Course Bundle has been expertly designed for you to complete through distance e-learning. Successful completion of the Microsoft Office bundle will see you achieve a CPD certified proficiency which will add significant weight to your CV and impress potential employers when applying for new jobs. Enrol now on the Microsoft Office Essentials - 3 Course Bundle and get access to top-quality training modules. Start studying Microsoft Office using any internet-enabled device including computers, tablets, and smartphones. With 24/7 student support, you can be sure of quick and comprehensive assistance whenever you need it. Why Choose Microsoft Office Essentials - 3 Course Bundle? Opportunity to boost your CV/Resume with CPD accredited proficiency Student ID card with amazing discounts - completely for FREE! (Postal charges will be applicable for international delivery) Certificates available in both PDF and hard copy format Interactive, high-quality course content with 24/7 online access Full tutor support and learning assistance included Course Curriculum Breakdown: Here are the topics you will cover on the Microsoft Office Essentials - 3 Course Bundle Course: Microsoft Excel 2022 New Features Introduction to Microsoft Excel 2019 New Features CONCAT IFS MAXIFS MINIFS SWITCH TEXTJOIN Map Chart Funnel Chart Better Visuals Pivot Table Enhancements Power Pivot Updates Getting Started with Microsoft Office Excel Navigate the Excel User Interface Use Excel Commands Create and Save a Basic Workbook Enter Cell Data Use Excel Help Performing Calculations Create Worksheet Formulas Insert Functions Reuse Formulas and Functions Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows Search for and Replace Data Use Proofing and Research Tools Formatting a Worksheet Apply Text Formats Apply Number Format Align Cell Contents Apply Styles and Themes Apply Basic Conditional Formatting Create and Use Templates Printing Workbooks Preview and Print a Workbook Set Up the Page Layout Configure Headers and Footers Managing Workbooks Manage Worksheets Manage Workbook and Worksheet Views Manage Workbook Properties Working with Functions Work with Ranges Use Specialized Functions Work with Logical Functions Work with Date & Time Functions Work with Text Functions Working with Lists Sort Data Filter Data Query Data with Database Functions Outline and Subtotal Data Analyzing Data Apply Intermediate Conditional Formatting Apply Advanced Conditional Formatting Visualizing Data with Charts Create Charts Modify and Format Charts Use Advanced Chart Features Using PivotTables and PivotCharts Create a PivotTable Analyze PivotTable Data Present Data with PivotCharts Filter Data by Using Timelines and Slicers Working with Multiple Worksheets and Workbooks Use Links and External References Use 3-D References Consolidate Data Using Lookup Functions and Formula Auditing Use Lookup Functions Trace Cells Watch and Evaluate Formulas Sharing and Protecting Workbooks Collaborate on a Workbook Protect Worksheets and Workbooks Automating Workbook Functionality Apply Data Validation Search for Invalid Data and Formulas with Errors Work with Macros Creating Sparklines and Mapping Data Create Sparklines MapData Forecasting Data Determine Potential Outcomes Using Data Tables Determine Potential Outcomes Using Scenarios Use the Goal Seek Feature Forecasting Data Trends Excel Templates Excel Templates CPD 11 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Microsoft Office Essentials - 3 Course Bundle has been professionally-designed for motivated learners who are looking to add a new skill to their CV and stand head and shoulders above the competition. Learn the latest industry-specific information with the Microsoft Office Essentials - 3 Course Bundle. Requirements Enrol on the Microsoft Office Essentials - 3 Course Bundle with no formal entry requirements! If you have a passion for knowledge and want to learn something new, register on the Microsoft Office Essentials - 3 Course Bundle without any delay. Certificates CPD Accredited Certificate Digital certificate - Included CPD Accredited Certificate Hard copy certificate - £29

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before The business world thrives on strong administrative, managerial, and customer service skills. Did you know that in the UK, a recent study found that 85% of employers prioritise well-developed soft skills in their candidates? Are you ready to take your career in business to the next level? This Office Administration, Business Administration & Retail Customer Service bundle equips you with the expertise to excel in various office administration, business administration, and retail customer service roles. We proudly offer 20 courses within the Office Administration, Business Administration & Retail Customer Service bundle, providing you with industry-recognised qualifications. These Courses are: Course 01: Office Administration & Skills Diploma Course 02: Compliance Officer Training Level 3 Course 03: Customer Service Training Course 04: Diploma in Performance Management Course 05: Project Management Course Course 06: Change Management Course 07: Business Administration Course 08: Financial Analysis Course Course 09: Diploma in Business Proposal Writing Course 10: Business Etiquette and Professional Behavior Course 11: Business Improvement Course 12: Ultimate Microsoft Excel For Business Bootcamp Course 13: Negotiation Skills Certificate Course 14: Retail Management Skills Course 15: Workplace Confidentiality Course 16: Product Management Course 17: Visual Merchandising Diploma Course 18: Strategic Marketing & Planning Course 19: Professional Diploma in Stress Management Course 20: Complete Communication Skills Master Class This Office Administration, Business Administration & Retail Customer Service bundle offers a holistic exploration of sales and marketing management principles, equipping you with the knowledge and skills to navigate the dynamic world of customer engagement. You'll delve into customer relationship management techniques, sales and marketing fundamentals, and innovative strategies for generating leads and driving sales. Learning Outcomes of Office Administration, Business Administration & Retail Customer Service Develop comprehensive office administration skills and compliance management knowledge. Master performance management strategies and project management methodologies. Gain insights into financial analysis, business proposal writing, and change management. Enhance business etiquette and professional behaviour in the workplace. Learn advanced Microsoft Excel techniques for data analysis and reporting. Acquire skills in retail management, customer service, and visual merchandising. Invest in your future and enrol today to unlock exciting career opportunities! Why Choose Our Office Administration, Business Administration & Retail Customer Service Course? Get a Free CPD Accredited Certificate upon completion of Office Administration Get a free student ID card with Office Administration Training The Office Administration is affordable and simple to understand This bundle is an entirely online, interactive lesson with voiceover audio Lifetime access to the Office Administration course materials This bundle comes with 24/7 tutor support Start your learning journey straightaway! *** Course Curriculum *** Course 01: Office Administration & Skills Diploma Module 01: Personal Assistant Module 02: Admin Support Module 03: Administrative Management Module 04: Organisational Skills Module 05: Telephone Etiquette Module 06: Business Writing Module 07: Time Management Module 08: Body Language And Effective Communication Module 09: Meeting Management Module 10: Excel Basics Module 11: PowerPoint Basic Course 02: Compliance Officer Training Level 3 Module 01 : Introduction to Compliance Module 02 : Compliance Management System Module 03 : Basic Elements of Effective Compliance Module 04 : Compliance Audit Module 05 : Compliance and Ethics Module 06 : Introduction to Risk and Basic Risk Types Module 07 : Further Risk Types Module 08 : Introduction to Risk Management Module 09 : Risk Management Process Module 10 : Risk Assessment and Risk Treatment Module 11 : Types of Risk Management Course 03: Retail Management Skills Module 01: Introduction To Retail Management Module 02: Retail Strategy Module 03: Retail Buying And Merchandising Module 04: Retail Pricing Module 05: Supply Chain Management In Retailing Module 06: The Sales Process And Dealing With Customers At The Checkout Module 07: Importance Of Consumer Behaviour Module 08: Taking Trends And Targeting Customers Effectively Module 09: The Importance Of Communicating With Customers Module 10: Choosing A Retail Location and much more... =========>>>>> And 17 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate:Free (Previously it was £12.99*20 = £260) CPD Hard Copy Certificate: Free ( For The Title Course: Previously it was £29.99) CPD 200 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 bundle. This Office Administration, Business Administration & Retail Customer Service bundle is ideal for: Newcomers to Business Office Professionals Retail Staff Career Changers Entrepreneurs Ambitious Individuals Requirements You will not need any prior background or expertise to enrol in this Office Administration, Business Administration & Retail Customer Service bundle. Career path After completing this Office Administration, Business Administration & Retail Customer Service bundle, you are to start your career or begin the next phase of your career. Office Manager Business Analyst Retail Manager Project Manager Marketing Specialist Entrepreneur Certificates CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. CPD Accredited Hard Copy Certificate Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee.

Course Objectives This course aims to provide delegates with a foundation for Excel knowledge and skills. ' Customer Feedback Great course and excellent trainer. Thanks Tracy Preston - Western Power Distribution Very helpful course. Would definitely take another one. Pedro was very patient and made it fun and engaged with us all. Laura Smith - James Grant Very professional and well mannered, fun and pleasant at the same time. I learnt a lot Carolina Foster - CNN 1 year email support service Take a look at the consistent excellent feedback from trainees visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Tailored in company training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. What is Excel? The Excel Interface Ribbon, Tabs and Groups Microsoft Office Backstage view Working with Workbooks Create a blank Workbook Create a Workbook using a Template Opening and saving Files Working with worksheets Worksheet navigation Select one or multiple Worksheets Insert, Move, Copy or Delete a Worksheet Working with Cells, Rows & Columns Cell References How to select cells or ranges Different types of data Move, Copy and Delete cells Pasting Options Find and Replace Working with Rows and Columns Overview of formulas in Excel Autocalculation The parts of an Excel formula Using calculation operators in Excel formulas The difference between Absolute, Relative and Mixed references Using Excel functions; Sum, Average, Max and Min Cell Formatting Font Format options Number Format options Change the Fill and Borders Cell Alignment An Introduction to Charts Create a simple Chart Format your chart Page Layout and Print Page Layout and Page Break View Change the Page Orientation Set Page Margins Headers and Footers in a worksheet Print a worksheet or workbook Who is this course for? Who is this course for? For those who want to explore in more detail formulas and functions, data analysis and data presentation. Requirements Requirements General knowledge of the Windows OS Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

Scientifically rigorous Accounting and Finance course that will equip you with the knowledge and skills to understand and interpret financial information, make sound financial decisions, and build a successful career in accounting and finance. Accounting and Finance is the language of business. It is the process of recording, summarizing, and interpreting financial information. This course will teach you the fundamental principles of accounting and finance, from financial statements to budgeting and forecasting. Learning Outcomes of Accounting and Finance: Master the fundamentals of accounting and finance Gain the skills to prepare and analyze financial statements Learn how to manage taxes and budgets Develop your analytical and problem-solving skills Enhance your career opportunities in the accounting and finance sector This Accounting and Finance Bundle Consists of the following Premium courses: Course 01: Introduction to Accounting Course 02: Basic Business Finance Course 03: Level 3 Tax Accounting Course 04: Professional Bookkeeping Course Course 05: Internal Audit Training Diploma Course 06: Diploma in Sage 50 Accounts Course 07: Level 3 Xero Training Course 08: Microsoft Excel Level 3 Course 09: Business Analysis Level 3 Course 10: Team Management Course 11: Certificate in Anti Money Laundering (AML) Course 12: GDPR Data Protection Level 5 Course 13: Microsoft Excel Training: Depreciation Accounting Course 14: Time Management This Accounting and Finance curriculum has been designed by experts with years of experience behind them. The course is extremely dynamic and well-paced to help you understand Accounting and Finance with ease. Enrol in this course today and start your journey with Accounting and Finance! This Accounting and Finance course is designed for anyone who wants to learn the basics of accounting and finance. Whether you are a student, a business owner, or a professional, this course will give you the skills you need to understand and manage your Accounting and Finance. The Accounting and Finance Bundle is a comprehensive collection of premium courses designed to give you the skills and knowledge you need to succeed in the world of accounting and finance. From the basics of accounting to advanced tax accounting, from bookkeeping to internal auditing, you'll learn everything you need to launch a successful career in this exciting field. The Curriculum of Accounting and Finance Bundle: => Course 01: Introduction to Accounting Section 01: Accounting Fundamental Lecture 01: What is Financial Accounting Lecture 02: Accounting Double Entry System and Fundamental Accounting Rules Lecture 03: Financial Accounting Process and Financial Statements Generates Lecture 04: Basic Accounting Equation and Four Financial Statements Lecture 05: Define Chart of Accounts and Classify the accounts Lecture 06: External and Internal Transactions with Companies Lecture 07: Short Exercise to Confirm what we learned in this section Section 02: Accounting Policies Lecture 08: What Major Accounting Policies need to be decided by companies Lecture 09: Depreciation Policies Lecture 10: Operational Fixed Asset Controls Lecture 11: Inventory Accounting and Controls Lecture 12: Revenue Accounting and Controls Lecture 13: Expenses Accounting and Working Capital =========>>>>> And 13 More Related Courses <<<<<========= How will I get my Accounting and Finance Certificate? After successfully completing this Accounting and Finance course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (For The Title Course) Hard Copy Certificate: Free (For The Title Course) Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost. Enroll in the Accounting and Finance course today and learn the skills and knowledge you need to succeed in this exciting field. CPD 145 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Accounting and Finance bundle course is ideal for anyone who wants to learn the fundamentals of accounting and finance, including: Students who are interested in a career in accounting and finance. Students who are interested in other business disciplines, such as economics and management. Professionals who want to brush up on their accounting and finance skills. Anyone who wants to learn more about the fundamentals of accounting and finance. Requirements Our Accounting and Finance bundle is fully compatible with PCs, Macs, laptops, tablets 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 Accounting and Finance course. It can be studied in your own time at your own pace. Career path Master the necessary skills to take a step closer to success with our Accounting and Finance bundle. Enhance your skill and explore opportunities such as - Accountant: £25,000 - £50,000 Auditor: £30,000 - £60,000 Financial analyst: £35,000 - £70,000 Investment banker: £40,000 - £80,000 Management consultant: £50,000 - £100,000 Tax consultant: £30,000 - £60,000 Credit analyst: £25,000 - £50,000 Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Introduction to Accounting) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Think about the backbone of any successful organization. It's the administrative team, the secretarial staff, and the PAs who keep things running smoothly. A recent study in the UK found that demand for skilled administrative professionals has grown by 15% in the last two years. Are you ready to step up and take on a leadership role in this essential field? This comprehensive Level 7 Diploma equips you with the advanced skills and knowledge to excel in administrative, secretarial, and personal assistant positions. You'll master essential areas like business communication, time management, project coordination, and legal procedures. Additionally, you'll gain expertise in using the latest Microsoft Office tools and navigate complex areas like GDPR and payroll. This Admin, Secretarial & PA at QLS Level 7 course is endorsed by The Quality Licence Scheme and accredited by CPD QS (with 180 CPD points) to make your skill development & career progression more accessible than ever! With a single payment, you will gain access to Admin, Secretarial & PA course, including 10 premium courses, a QLS Endorsed Hardcopy certificate (for the title course) and 11 PDF certificates for Absolutely free. This Admin, secretarial & PA Bundle Package includes: Course 01: Advanced Diploma in Admin, Secretarial & PA at QLS Level 7 10 Additional CPDQS Accredited Premium Courses - Course 01: Complete Microsoft Word Course 02: Microsoft Excel - Beginner, Intermediate & Advanced Course 03: Legal Secretary Course 04: GDPR Course 05: Payroll Course 06: Administrative Management Course 07: Leadership & Management Diploma Course 08: HR Assistant Course 09: Decision-Making in High-Stress Situations Course 10: Workplace Health and Safety Empower yourself to become an indispensable asset in today's competitive workplace. Enrol today and take your career to the next level! Learning outcome of this Admin, Secretarial & PA: Apply advanced administrative procedures for optimal efficiency. Demonstrate exceptional communication skills in written and verbal formats. Effectively manage time and prioritize tasks in a fast-paced environment. Utilize advanced Microsoft Office applications to streamline workflows. Navigate complex legal and regulatory requirements with confidence. Develop leadership qualities to motivate and support colleagues. Why Choose Us? Get a Free QLS Endorsed Certificate upon completion of Admin, secretarial & PA Get a free student ID card with Admin, secretarial & PA Training program (£10 postal charge will be applicable for international delivery) The Admin, secretarial & PA is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the Admin, secretarial & PA course materials The Admin, secretarial & PA comes with 24/7 tutor support Start your learning journey straightaway! *** Course Curriculum *** Course 01: Advanced Diploma in Admin, Secretarial & PA at QLS Level 7 Module 1: Personal Assistant Module 2: Admin Support Module 3: Administrative Management Module 4: Organisational Skills Module 5: Telephone Etiquette Module 6: Business Writing Module 7: Time Management Module 8: Body Language and Effective Communication Module 9: Meeting Management Module 10: Excel Basics Module 11: PowerPoint Basic Course 01: Complete Microsoft Word Manipulating Images Using Custom Graphic Elements Collaborating On Documents Adding Document References And Links Securing A Document Using Forms To Manage Content Automating Repetitive Tasks With Macros Course 02: Microsoft Excel - Beginner, Intermediate & Advanced 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 Section 11: Maps Chart Above 2019 Section 12: Business-Geo Charts Section 13: Named Ranges Section 14: Import Data Into Excel Section 15: Advanced Excel =========>>>>> 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 £139) 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 bundle. This bundle is ideal for: Seasoned Admin, Secretarial & PA professionals seeking career growth. Aspiring executive and personal assistants. Career changers entering Admin, Secretarial & PA roles. Individuals specialising in Admin, Secretarial & PA. Advanced administrative skills seekers. Requirements No prior background or expertise is required for this Admin, secretarial & PA bundle. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Executive Assistant: £25,000 - £50,000 Office Manager: £30,000 - £45,000 PA to CEO: £35,000 - £60,000 Administrative Director: £45,000 - £80,000 Operations Manager: £35,000 - £70,000 Business Development Manager: £35,000 - £70,000 Certificates Advanced Diploma in Admin, Secretarial & PA at QLS Level 7 Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee. CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free.

Unlock the world of data entry with our comprehensive course for beginners. Master Microsoft Word and Excel, delve into advanced techniques and tools, and learn best practices for accuracy. Build a successful data entry career with hands-on guidance and create a professional portfolio. Join us for a transformative journey into the heart of data entry excellence.

Learn Microsoft Excel to create and format spreadsheets, analyse and share information to make knowledgeable resolutions. This Microsoft Office 2016 Excel Beginners is intended to teach you creating high-level workbooks and worksheets. Upon completion, you will have the ability to explain massive amounts of data and present that information to increase your understanding of the organisational account. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certification 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. Course Content Getting Started with Microsoft Office Excel 2016 Navigate the Excel User Interface 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 Mock Exam Mock Exam - Microsoft Office 2016 Excel Beginners 00:20:00 Final Exam Final Exam - Microsoft Office 2016 Excel Beginners 00:20:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Description Microsoft Excel has hundreds, if not thousands, of functions and features. This course aims to cover some of the best – that is the ones I find most useful. In “Adventures in Excel”, I cover the simple-to-use but powerful functions that I use most often: Basic features including products and powers Key date functions including the calculation of due dates and days past due Generating random numbers and random dates The new IFS functions (new to Office365) Text functions The most useful logical functions and IS functions How to create a drop-down list The new XLOOKUP function Pivot tables   These functions are easy to use, and, unless your role is extremely specialised, they are probably the ones you’ll use 90% of the time. I hope you find the course helpful.   Learning Outcomes Participants in this course will learn: Basic Excel functions including SUM, AVERAGE, MIN, MAX, PRODUCT, POWER and SQRT Useful date functions including TODAY, EOMONTH, EDATE, and DAYS Generating random numbers using RAND and RANDBETWEEN; generating random dates; and randomly picking an item from a list or table The new RANDARRAY function in Office365 The new IFS functions in Office365 including AVERAGEIFS, MAXIFS, MINIFS, COUNTIFS, and SUMIFS Text functions including TRIM, LOWER, UPPER, PROPER, LEFT, MID, RIGHT, FIND, TEXTJOIN and CONCATENATE Logical functions AND, OR, and NOT and IS functions ISTEXT, ISNUMBER, ISBLANK and ISERROR How to create a drop-down list The new SORT and FILTER functions in Office365 VLOOKUP and the new XLOOKUP function How to create a Pivot table and analyse data with one     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