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

855 Microsoft Excel courses delivered Online

Kick Start Your Career with CompTIA's Data Analysis Certification - Live Classes

5.0(1)

By Media Tek Training Solutions Ltd

Get job ready with CompTIA's Data Analysis Certification. Live Classes - Career Guidance - Exam Included.

Kick Start Your Career with CompTIA's Data Analysis Certification - Live Classes
Delivered OnlineFlexible Dates
£1,595

Office Administration Online Course

4.8(9)

By Skill Up

Your path to excellence in Office Administration begins here. Learn about Bookkeeping & Payroll Management, Microsoft Word, Admin Support, Business Writing, and Microsoft Excel.

Office Administration Online Course
Delivered Online On Demand5 days
£25

Executive Secretarial & PA

4.7(160)

By Janets

The Executive Secretarial & PA Course is a wonderful learning opportunity for anyone who has a passion for this topic and is interested in enjoying a long career in the relevant industry. It's also for anyone who is already working in this field and looking to brush up their knowledge and boost their career with a recognised certification. This Executive Secretarial & PA Course consists of several modules that take around 11 hours to complete. The course is accompanied by instructional videos, helpful illustrations, how-to instructions and advice. The course is offered online at a very affordable price. That gives you the ability to study at your own pace in the comfort of your home. You can access the modules from anywhere and from any device. Why Choose this Course? Earn a digital 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 Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Course Content Module 1: Introduction to Personal Assistant Introduction to Personal Assistant 00:18:00 Module 2: Business Telephone Skills Business Telephone Skills 00:20:00 Module 3: Representing Your Boss and Company Representing Your Boss and Company 00:37:00 Module 4: Mail Services and Shipping Mail Services and Shipping 00:28:00 Module 5: Travel Arrangements Travel Arrangements 00:27:00 Module 6: Organising Meeting and Conferences Organising Meeting and Conferences 00:28:00 Module 7: Time Management Time Management 00:38:00 Module 8: Record Keeping and Filing Systems Record Keeping and Filing Systems 00:31:00 Module 9: Business Writing Skills Business Writing Skills 00:43:00 Module 10: Organisational Skills Organisational Skills 00:28:00 Module 11: Communication Skills Communication Skills 00:28:00 Module 12: Customer Service Customer Service 00:19:00 Module 13: Effective Planning and Scheduling Effective Planning and Scheduling 00:49:00 Module 14: Document Proofreading and Editing Document Proofreading and Editing 00:08:00 Module 15: Advanced MS Excel Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! 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:05: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 VLOOKUP: Master Excel Formula VLOOKUP in 60 minutes! 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 Microsoft Excel: Master Power Query in 120 Minutes! 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:06:00 Microsoft Excel Keyboard Shortcuts 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 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.

Executive Secretarial & PA
Delivered Online On Demand10 hours 36 minutes
£25

Financial Modelling & Valuation Analyst (FMVA) Essentials - CPD Certified

4.5(3)

By Studyhub UK

24 Hour Flash Deal **40-in-1 Financial Modelling & Valuation Analyst (FMVA) Essentials Mega Bundle** Financial Modelling & Valuation Analyst (FMVA) Essentials Enrolment Gifts **FREE PDF Certificate**FREE PDF Transcript ** FREE Exam** FREE Student ID ** Lifetime Access **FREE Enrolment Letter ** Take the initial steps towards a successful long-term career by studying the Financial Modelling & Valuation Analyst (FMVA) Essentials package online with Studyhub through our online learning platform. The Financial Modelling & Valuation Analyst (FMVA) Essentials bundle can help you improve your CV, wow potential employers, and differentiate yourself from the mass. This Financial Modelling & Valuation Analyst (FMVA) Essentials course provides complete 360-degree training on Financial Modelling & Valuation Analyst (FMVA) Essentials. You'll get not one, not two, not three, but forty Financial Modelling & Valuation Analyst (FMVA) Essentials courses included in this course. Plus Studyhub's signature Forever Access is given as always, meaning these Financial Modelling & Valuation Analyst (FMVA) Essentials courses are yours for as long as you want them once you enrol in this course. This Financial Modelling & Valuation Analyst (FMVA) Essentials Bundle consists the following career oriented courses: Course 01: Financial Modelling Course 02: Financial Modelling Course for a Non-Finance Background Course 03: Make Business Plans: Forecasting and Budgeting Course 04: Managing Budget: Financial Statements and Money Management Course 05: Capital Budgeting & Investment Decision Rules Course 06: Raise Money and Valuation for Business Course 07: Microsoft Excel Complete Course 2019 Course 08: VLOOKUP: Master Excel Formula VLOOKUP in 60 minutes! Course 09: Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Course 10: SQL for Data Science, Data Analytics and Data Visualization Course 11: Microsoft PowerPoint for Beginners Course 12: Accounting Fundamentals Diploma Course 13: Understanding Financial Statements and Analysis Course 14: Fundamentals of Corporate Finance Course 15: Investment Banking Operations Professional Course 16: Fundamentals of Business Analysis Course 17: Finance: Financial Risk Management Course 18: Credit Control and Compliance Training Course 19: AutoCAD VBA Programming - Beginner course Course 20: Python Basic Programming for Absolute Beginners Course 21: Financial Planning Course 22: Cost Control Process and Management Course 23: Economics Level 2 Diploma Course 24: Actuary Certification: Navigating the Complex World of Risk and Finance Course 25: Finance Law Fundamentals: Legal Aspects of Financial Transactions Course 26: Accounts Receivable Management: Optimising Financial Processes Course 27: Efficient Accounts Payable Processing: Streamlining Financial Transactions Course 28: Demystifying Depreciation Accounting: Financial Insights Course 29: Mastering Partnership Accounting: Financial Strategies and Reporting Course 30: Finance for Non-finance Managers Certification Course 31: Corporate Finance: Profitability in a Financial Downturn Course 32: Business Strategy Planning Course 33: Debt Management, Assessment, Financing & Counselling Course 34: Machine Learning Basics Course 35: CompTIA CySA+ Cybersecurity Analyst Course Course 36: Business Finance Course 37: Financial Investigator Course 38: Financial Analysis Methods Course 39: Personal Financial Management & Wellness Course 40: Tax Strategy and Financial Planning for Beginners In this exclusive Financial Modelling & Valuation Analyst (FMVA) Essentials bundle, you really hit the jackpot. Here's what you get: Step by step Financial Modelling & Valuation Analyst (FMVA) Essentials lessons One to one assistance from Financial Modelling & Valuation Analyst (FMVA) Essentials professionals if you need it Innovative exams to test your knowledge after the Financial Modelling & Valuation Analyst (FMVA) Essentials course 24/7 customer support should you encounter any hiccups Top-class learning portal Unlimited lifetime access to all forty Financial Modelling & Valuation Analyst (FMVA) Essentials courses Digital Certificate, Transcript and student ID are all included in the price PDF certificate immediately after passing Original copies of your Financial Modelling & Valuation Analyst (FMVA) Essentials certificate and transcript on the next working day Easily learn the Financial Modelling & Valuation Analyst (FMVA) Essentials skills and knowledge you want from the comfort of your home The Financial Modelling & Valuation Analyst (FMVA) Essentials course has been prepared by focusing largely on Financial Modelling & Valuation Analyst (FMVA) Essentials career readiness. It has been designed by our Financial Modelling & Valuation Analyst (FMVA) Essentials specialists in a manner that you will be likely to find yourself head and shoulders above the others. For better learning, one to one assistance will also be provided if it's required by any learners. The Financial Modelling & Valuation Analyst (FMVA) Essentials Bundle is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Financial Modelling & Valuation Analyst (FMVA) Essentials bundle course has been created with forty premium courses to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Financial Modelling & Valuation Analyst (FMVA) Essentials Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into Financial Modelling & Valuation Analyst (FMVA) Essentials Elementary modules, allowing our students to grasp each lesson quickly. The Financial Modelling & Valuation Analyst (FMVA) Essentials course is self-paced and can be taken from the comfort of your home, office, or on the go! With our Student ID card you will get discounts on things like music, food, travel and clothes etc. CPD 400 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Financial Modelling & Valuation Analyst (FMVA) Essentials training is suitable for - Students Recent graduates Job Seekers Individuals who are already employed in the relevant sectors and wish to enhance their knowledge and expertise in Financial Modelling & Valuation Analyst (FMVA) Essentials. Requirements To participate in this Financial Modelling & Valuation Analyst (FMVA) Essentials course, all you need is - A smart device A secure internet connection And a keen interest in Financial Modelling & Valuation Analyst (FMVA) Essentials. Career path You will be able to kickstart your Financial Modelling & Valuation Analyst (FMVA) Essentials career because this course includes various courses as a bonus. This bundle is an excellent opportunity for you to learn multiple skills from the convenience of your own home and explore Financial Modelling & Valuation Analyst (FMVA) Essentials career opportunities. Certificates CPD Accredited Certificate Digital certificate - Included CPD Accredited e-Certificate - Free CPD Accredited Hardcopy Certificate - Free Enrolment Letter - Free Student ID Card - Free Quality Licence Scheme Endorsed Certificate of Achievement Hard copy certificate - Included Upon successful completion of the course, you will be eligible to order QLS Endorsed Hardcopy Certificate titled 'Financial Modelling at QLS Level 3' Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses.

Financial Modelling & Valuation Analyst (FMVA) Essentials - CPD Certified
Delivered Online On Demand9 days
£399

Xero Accounting and Bookkeeping at QLS Level 7 Diploma

4.7(26)

By Academy for Health and Fitness

***24 Hour Limited Time Flash Sale*** Xero Accounting and Bookkeeping at QLS Level 7 Diploma Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Are you a professional feeling stuck in your career, struggling to keep up with the ever-changing demands of the industry? Or perhaps you're a beginner, unsure of where to start or how to break into your desired field. Whichever stage you're in, our exclusive Xero Accounting and Bookkeeping at QLS Level 7 Diploma Bundle provides unique insights and tools that can help you achieve your goals. Designed to cater to the needs of both seasoned professionals and aspiring newcomers, our Xero Accounting and Bookkeeping at QLS Level 7 Diploma bundle is a comprehensive program that will equip you with the essential skills and knowledge you need to succeed. Whether you're looking to advance in your current role or embark on a new career journey, this bundle has everything you need to take your professional life to the next level. But that's not all. When you enrol in Xero Accounting and Bookkeeping at QLS Level 7 Diploma Online Training, you'll receive 30 CPD-Accredited PDF Certificates, Hard Copy Certificates, and our exclusive student ID card, all absolutely free. Courses Are Included In this Xero Accounting and Bookkeeping at QLS Level 7 Diploma Career Bundle: Course 01: Xero Accounting & Bookkeeping Course Course 02: Xero Advisor Course 03: Quickbooks Bookkeeping Course 04: Excel for Bookkeeping Course 05: Bookkeeping Tool: Google Sheets Course 06: Sage 50 Accounts Course 07: Payroll: Payroll Management Course 08: Accountancy at QLS Level 5 Diploma Course 09: Managerial Accounting Training Course 10: Applied Accounting Course: Mastering Financial Management Course 11: Accounts Payable Clerk Training Course 12: Making Budget & Forecast Course 13: Cost Control Process and Management Course 14: Anti-Money Laundering (AML) Course 15: Tax Accounting Diploma Course 16: Introduction to VAT Online Training Course 17: Corporate Finance: Working Capital Management Course 18: Level 4 Diploma Accounting and Business Finance Course 19: Financial Modelling for Decision Making and Business plan Course 20: Financial Accounting Course 21: Commercial Law Course 22: Microsoft Excel Training: Depriciation Accounting Course 23: Concept of Charity Accounting Course 24: Understanding Financial Statements and Analysis Course 25: Finance Assistant Training: Level 1 & 2 Certification Course 26: Negotiation Skills Certificate Course 27: Document Control Course 28: Advanced Diploma in Microsoft Excel Course 29: Online Time Management Training Course 30: Risk Assessment & Management With Level 7 in Strategic Learning & Development, you'll embark on an immersive learning experience that combines interactive lessons with voice-over audio, ensuring that you can learn from anywhere in the world, at your own pace. And with 24/7 tutor support, you'll never feel alone in your journey, whether you're a seasoned professional or a beginner. Don't let this opportunity pass you by. Enrol in Xero Accounting and Bookkeeping at QLS Level 7 Diploma today and take the first step towards achieving your goals and dreams. Why buy this Level 7 in Strategic Learning & Development? Free CPD Accredited Certificate upon completion of Level 7 in Strategic Learning & Development Get a free student ID card with Level 7 in Strategic Learning & Development Lifetime access to the Xero Accounting and Bookkeeping at QLS Level 7 Diploma course materials Get instant access to this Xero Accounting and Bookkeeping at QLS Level 7 Diploma course Learn Xero Accounting and Bookkeeping at QLS Level 7 Diploma from anywhere in the world 24/7 tutor support with the Xero Accounting and Bookkeeping at QLS Level 7 Diploma course. Start your learning journey straightaway with our Xero Accounting and Bookkeeping at QLS Level 7 Diploma Training! Xero Accounting and Bookkeeping at QLS Level 7 Diploma premium bundle consists of 30 precisely chosen courses on a wide range of topics essential for anyone looking to excel in this field. Each segment of Xero Accounting and Bookkeeping at QLS Level 7 Diploma is meticulously designed to maximise learning and engagement, blending interactive content and audio-visual modules for a truly immersive experience. Certification You have to complete the assignment given at the end of the Xero Accounting and Bookkeeping at QLS Level 7 Diploma course. After passing the Xero Accounting and Bookkeeping at QLS Level 7 Diploma exam You will be entitled to claim a PDF & Hardcopy certificate accredited by CPD Quality standards completely free. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Xero Accounting and Bookkeeping at QLS Level 7 Diploma course is ideal for: Students seeking mastery in Level 7 in Strategic Learning & Development Professionals seeking to enhance Xero Accounting and Bookkeeping at QLS Level 7 Diploma skills Individuals looking for a Level 7 in Strategic Learning & Development-related career. Anyone passionate about Level 7 in Strategic Learning & Development Requirements This Xero Accounting and Bookkeeping at QLS Level 7 Diploma doesn't require prior experience and is suitable for diverse learners. Career path This Xero Accounting and Bookkeeping at QLS Level 7 Diploma bundle will allow you to kickstart or take your career in the related sector to the next stage. Certificates CPD Accredited Hard copy certificate Hard copy certificate - Included If you are an international student, you will be required to pay an additional fee of 10 GBP for international delivery, and 4.99 GBP for delivery within the UK, for each certificate CPD Accredited Digital certificate Digital certificate - Included

Xero Accounting and Bookkeeping at QLS Level 7 Diploma
Delivered Online On Demand7 days
£209

Excel 365 VBA Expert

By iStudy UK

Learning Objectives Introduction , Getting Started with VBA , Working with Variables , Working with Conditional Logic , Working with Strings and String Functions , Working with Loops , Working with Sub Procedures Options and Functions , Working with User Forms , Debugging your Code , Conclusion   Pre-Requisites Intermediate Microsoft Excel training or equivalent experience is recommended.   Description This course will teach students proper Visual Basic programming techniques along with an understanding of Excel's object structure. Students will learn how to work with variables, how to use various conditional logic statements such as If and Else, and how to work with string functions. Students will also learn how to work with various loops such as next loops and each loops, as well as how to create user forms. Finally, students will get an in-depth understanding of the debugging tools available and how to effectively debug their code. Course Introduction Introduction 00:03:00 Section 01 Lesson 1-Adding the Developer Toolbar 00:05:00 Lesson 2-Understanding the VBA Editor 00:11:00 Lesson 3-Recording a Macro in Personal 00:10:00 Lesson 4-Understanding the Elements of the VBA Language 00:07:00 Lesson 5-Understanding Methods 00:05:00 Lesson 6-Understanding Comments 00:06:00 Lesson 7-Working with the Range Property and Worksheet Object 00:07:00 Lesson 8-Adding a Macro Button to a Spreadsheet 00:03:00 Lesson 9-Working with the ActiveCell Object 00:02:00 Lesson 10-Working with the Offset Property 00:08:00 Section 02 Lesson 1-Understanding Variables 00:07:00 Lesson 2-Working with Integer Variables 00:03:00 Lesson 3-Understanding Option Explicit 00:05:00 Lesson 4-Working with Other Variable Types 00:07:00 Section 03 Lesson 1-Working with IF Statements 00:04:00 Lesson 2-Working with ELSE 00:03:00 Lesson 3-Working with ELSEIF 00:03:00 Lesson 4-Understanding Conditional Operators 00:06:00 Lesson 5-Working with NOT, AND, and OR 00:07:00 Lesson 6-Working with Nested IF 00:04:00 Lesson 7-Working with Select Case 00:06:00 Lesson 8-Working with WITH and END WITH 00:05:00 Section 04 Lesson 1-Working with Text Strings 00:05:00 Lesson 2-Working with LCASE and UCASE Functions 00:05:00 Lesson 3-Working with LEN and TRIM Functions 00:07:00 Lesson 4-Working with LEFT, RIGHT, and MID Functions 00:07:00 Section 05 Lesson 1-Understanding Loops 00:02:00 Lesson 2-Working with For Next Loops 00:07:00 Lesson 3-Working with For Each Loops 00:06:00 Lesson 4-Working with Cells Property 00:08:00 Lesson 5-Working with Do Until Loops 00:09:00 Lesson 6-Working with Do While Loops 00:05:00 Section 06 Lesson 1-Calling Sub Procedures 00:05:00 Lesson 2-Working with Exit Sub 00:04:00 Lesson 3-Working with Message Boxes 00:08:00 Lesson 4-Working with Input Boxes 00:08:00 Lesson 5-Working with VBA Functions 00:12:00 Lesson 6-Working with Object Variable and Set 00:06:00 Section 07 Lesson 1-Understanding and Creating a User Form 00:08:00 Lesson 2-Adding Controls to a User Form 00:16:00 Lesson 3-Adding Code for a User Form 00:10:00 Lesson 4-Launching a User Form from Excel 00:05:00 Section 08 Lesson 1-Getting Started with Debugging 00:10:00 Lesson 2-Stepping Through Your Code 00:06:00 Lesson 3-Working with Breakpoints 00:03:00 Lesson 4-Working with the Immediate Window 00:05:00 Lesson 5-Working with the Locals Window 00:05:00 Lesson 6-Working with the Err Object 00:06:00 Lesson 7-Getting Help-v2 00:07:00 Course Recap Recap 00:02:00 Additional Materials Resource - Excel 365 VBA Expert 00:00:00 Final Exam Final Exam - Excel 365 VBA Expert 00:20:00

Excel 365 VBA Expert
Delivered Online On Demand5 hours 34 minutes
£25

Microsoft Excel Introduction (trainer led live online classes)

By Microsoft Office Training

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

Microsoft Excel Introduction (trainer led live online classes)
Delivered in London or OnlineFlexible Dates
£225

77-728 Complete Techniques for the MOS Excel Expert Exam

By Packt

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

77-728 Complete Techniques for the MOS Excel Expert Exam
Delivered Online On Demand9 hours 18 minutes
£121.99

Stock Market Investing & Trading - Level 2

5.0(10)

By Apex Learning

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 With a single payment you will gain access to Stock Market Investing & Trading - Level 2 including 11 Career development courses, original hardcopy certificate, transcript and a student ID card which will allow you to get discounts on things like music, food, travel and clothes etc. Trade efficiently in the stock market, learning advanced techniques and strategies from the Stock Market Investing & Trading - Level 2 course. The Stock Market Investing & Trading - Level 2 course aims to equip you with all the required knowledge and skills to trade like a pro in the stock market and gain a consistent profit. You'll be trained on technical and candlestick chart analysis to equip you with the skills to perceive the market accurately. You'll also learn trading tips, exploring tools and exchange policy. What's more, you'll explore some mistakes of new traders that will protect you from making poor trading decisions. Thrive in the stock market by enrolling today! Take this course anywhere and at any time. Don't let your lifestyle limit your learning or your potential. Gain experience online and interact with experts. This can prove to be the perfect way to get noticed by a prospective employer and stand out from the crowd. All of our courses have interactive online modules that allow studying to take place where and when you want it to. Experienced tutors and mentors will be there for you whenever you need them, and solve all your queries through email and chat boxes. Benefits you'll get choosing Apex Learning for this Stock Market Investing & Trading - Level 2: One payment, but lifetime access to 11 CPD courses Certificates, student ID for the title course included in a one-time fee Full tutor support available from Monday to Friday Free up your time - don't waste time and money travelling for classes Accessible, informative modules taught 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 Gain valuable knowledge without leaving your home Courses are included with this Bundle: Course 1: Stock Market Investing for Beginners Course 2: Forex Trading Level 3 Course 3: Budgeting and Forecasting Course 4: Business Analysis Level 3 Course 5: Level 2 Financial Planning and Management Course Course 6: Corporate Finance: Working Capital Management Course 7:Team Management Course 8: Microsoft Excel Level 3 Course 9: GDPR Data Protection Level 5 Course 10: Financial Modeling Using Excel Course 11: Fraud Management & Anti Money Laundering Awareness Complete Diploma Course 12: Risk Management Level 7 Curriculum: Course 1: 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 2: Forex Trading Level 3 Module 1: Introduction to Forex Trading Module 2: Major Currencies and Market Structure Module 3: Kinds of Foreign Exchange Market Module 4: Money Management Module 5: Fundamental Analysis Module 6: Technical Analysis Module 7: Pitfalls and Risks Module 8: Managing Risk Module 9: Trading Psychology Course 3: Budgeting and Forecasting Unit-1. Introduction Unit-2. Detail Budget Requirement Unit-3. Process of Making Budget Course 4: Business Analysis Level 3 Module 01: Introduction to Business Analysis Module 02: Business Processes Module 03: Business Analysis Planning and Monitoring Module 04: Strategic Analysis and Product Scope Module 05: Solution Evaluation Module 06: Investigation Techniques Module 07: Ratio Analysis Module 08: Stakeholder Analysis and Management Module 09: Process Improvement with Gap Analysis Module 10: Documenting and Managing Requirements Module 11: Career Prospect as a Business Analyst in the UK Course 5: 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 6: Corporate Finance: Working Capital Management Module 01: Course Introduction Module 02: Introduction to Working Capital Management Module 03: Trade Credit and Receivable Management Module 04: Payables Management Module 05: Inventory Management Practices Module 06: Cash Management Practice Course 8: Microsoft Excel Level 3 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 Templates Course 9: GDPR Data Protection Level 5 Module 01: GDPR Basics Module 02: GDPR Explained Module 03: Lawful Basis for Preparation Module 04: Rights and Breaches Module 05: Responsibilities and Obligations 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: Fraud Management & Anti Money Laundering Awareness Complete Diploma Module 01: Introduction to Money Laundering Module 02: Proceeds of Crime Act 2002 Module 03: Development of Anti-Money Laundering Regulation Module 04: Responsibility of the Money Laundering Reporting Office Module 05: Risk-based Approach Module 06: Customer Due Diligence Module 07: Record Keeping Module 08: Suspicious Conduct and Transactions Module 09: Awareness and Training Course 12: Risk Management Level 7 Module 01: Introduction to Risk Management Module 02: Risk and Types of Risk Module 03: Benefits of Risk Management Module 04: Enterprise Risk Management Module 05: Risk Management Process Module 06: Risk Analysis & Assessment Module 07: The Risk Evaluation Process Module 08: Managing Financial Risks Module 09: The Fundamentals of Operational Risk Management Module 10: Managing Technology Risks Module 11: Managing Legal & Political Risk Module 12: Environmental Risk Assessment Module 13: Risk Assessment at Workplace Module 14: Market & Social Risk Assessment Module 15: Preparing Risk Management Plan: Step by Step 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 * 12 = £120) 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 this Fall, Apex Learning is offering a Flat 50% discount on hard copy certificates, and you can get each for just £10! P.S. The delivery charge inside the U.K. is £3.99 and the international students have to pay £9.99. CPD 125 CPD hours / points Accredited by CPD Quality Standards Who is this course for? There is no experience or previous qualifications required for enrolment on this Stock Market Investing & Trading - Level 2. It is available to all students, of all academic backgrounds. Requirements Our Stock Market Investing & Trading - Level 2 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 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 CPD certificate 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. Certificates Certificate of completion Digital certificate - Included

Stock Market Investing & Trading - Level 2
Delivered Online On Demand
£100

Level 7 Xero Accounting & Bookkeeping - QLS Endorsed

4.7(26)

By Academy for Health and Fitness

24-Hour Flash Sale! Prices Reduced Like Never Before!! Did you know that over 50% of small businesses in the UK fail within the first 5 years of operation? One of the main reasons for this is poor financial management. But with the Xero Accounting & Bookkeeping bundle, you'll have the skills and knowledge to ensure your business not only survives but thrives. This comprehensive bundle includes 11 courses, all relevant and CPD-accredited, covering everything from Xero Accounting and Bookkeeping to GDPR compliance and Financial Management. You'll gain mastery over Managerial Accounting, and get up to speed with the latest in GDPR and Microsoft Excel. From managing payroll to analysing financial data for strategic decision-making, this course bundle equips you with the skills to manage business finances efficiently and compliantly. This Xero Accounting & Bookkeeping Bundle Package includes: Course 01: Advanced Diploma in Xero Accounting and Bookkeeping at QLS Level 7 10 Premium Additional CPD QS Accredited Courses - Course 01: Xero Advisor Course 02: Bookkeeping Diploma Course 03: Sage 50 Diploma Course 04: Quickbooks Bookkeeping Course 05: UK Tax Accounting Course Course 06: Managerial Accounting Training Course 07: Accountancy Course 08: Financial Management Course 09: GDPR Course 10: Microsoft Excel Whether you're looking to advance your career or start your own business, the Xero Accounting & Bookkeeping bundle has everything you need to succeed. Enrol today, and don't let poor financial management hold you back - take control of your future with the Xero Accounting & Bookkeeping bundle. Learning Outcomes of this Xero Accounting & Bookkeeping Bundle Course: Master the functionalities of Xero, Sage 50, and QuickBooks for comprehensive bookkeeping. Navigate UK tax laws confidently and manage accounting tasks effectively. Utilize Excel 2019 for advanced financial analysis and data management. Ensure compliance with GDPR in handling financial and personal data. Develop managerial accounting strategies to aid in decision-making and financial planning. Enhance financial management skills, focusing on budgeting, forecasting, and financial reporting. Why Prefer this Course? Get a Free CPD Accredited Certificate upon completion of the course Get a Free Student ID Card with this training program (£10 postal charge will be applicable for international delivery) The course is Affordable and Simple to understand Get Lifetime Access to the course materials The training program comes with 24/7 Tutor Support Start your learning journey straight away! Course Curriculum Course 01: Advanced Diploma in Xero Accounting and Bookkeeping at QLS Level 7 Module 01: Introduction Module 02: Getting Started Module 03: Invoices and Sales Module 04: Bills and Purchases Module 05: Bank Accounts Module 06: Products and Services Module 07: Fixed Assets Module 08: Payroll Module 09: VAT Returns Course 02: Xero Advisor Module 01: Getting Started Module 02: Setting Up Of The System Module 03: Customers And Suppliers Module 04: Fixed Assets Module 05: Bank Payments And Receipts Module 06: Petty Cash Module 07: Bank Reconciliation Module 08: Business Credit Card Account Module 09: Aged Reports Module 10: Payroll And Journals Module 11: Vat Return Module 12: Correction Of Error Course 03: Bookkeeping Diploma Module 01: Introduction to Bookkeeping Module 02: Manual System Module 03: Computerised Systems Module 04: How it Fits Together Module 05: Bookkeeping Basics Module 06: Ledgers Module 07: Trial Balance and Coding Module 09: PNL Account and Balance Sheet Module 10: AILE Personal =========>>>>> And 8 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*11 = £143) CPD Hard Copy Certificate: Free (For The First Course: Previously it was £29.99) QLS Endorsed Hard Copy Certificate: Free (For The Title Course: Previously it was £139) CPD 280 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: Aspiring accountants and bookkeepers Small business owners Finance students Career changers Finance professionals Anyone interested in finance This Xero accounting software training program has been created to develop your Xero accounting skills and the overall understanding of the software. It has no association with Xero Limited and operates independently. Please note, that the certificate you receive upon completion is CPD accredited and not an official Xero certification. Requirements You will not need any prior background or expertise to enrol in this course. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Xero Certified Accountant - £40,000 to £55,000 Bookkeeper - £25,000 to £35,000 Financial Analyst - £35,000 to £50,000 Tax Accountant - £30,000 to £45,000 Payroll Manager - £28,000 to £40,000 Management Accountant - £35,000 to £50,000 Certificates Advanced Diploma in Xero Accounting and Bookkeeping 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. CPD Accredited Hard Copy Certificate Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee.

Level 7 Xero Accounting & Bookkeeping - QLS Endorsed
Delivered Online On Demand4 weeks
£159