882 Microsoft Excel courses

This one-day workshop is designed to give you an awareness of the fundamentals of Microsoft Excel and, in particular, to give you the confidence needed to efficiently create, edit and manage spreadsheets. This course will help participants: Create tables Use functions Manage rows and columns Write formulas Manage sheets Use content formats Handle larger tables Create reports and charts 1 Creating a table Creating an Excel table from scratch Wrapping text in cells Speeding up data entry using AutoFill Sorting columns 2 Inserting function Inserting function calculators Using AutoSum to sum numbers Statistical calculations AVERAGE, MAX and MIN 3 Table rows and columns Inserting and deleting rows and columns Adjusting multiple column widths and row heights Hiding and unhiding rows and columns 4 Formula writing The basics of formula writing Understanding mathematical symbols Using multiple mathematical symbols in a formula When to use brackets Troubleshooting calculation errors 5 Managing sheets Inserting, renaming, moving and deleting sheets Copying a worksheet to another file Copying a table to another sheet 6 Managing content formats Applying data formats Managing number formats Controlling formats with the Format Painter 7 Managing larger tables Applying freeze panes to lock tables when scrolling Sorting on multiple columns Using filters to extract table information 8 Creating and modifying charts Creating a pie chart Creating a column chart Inserting chart titles and data labels Controlling chart formatting Changing chart types 9 Printing Previewing and printing tables and charts Modifying page orientation Adjusting print margins Printing a selection 10 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 11 Pivot tables Create a pivot table report Insert a pivot chart into a report

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 Accountancy will provide you with the essential knowledge and skills required to shine in your professional career. Whether you want to develop skills for your next job or want to elevate skills for your next promotion, this Accountancy will help you keep ahead of the pack. The Accountancy incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can reinforce your professional skills and essential knowledge, reaching out to the level of expertise required for your position. Further, this Accountancy 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 profession while at the same time it outlines essential career insights in this job sector. Consequently, you'll strengthen your knowledge and skills; on the other hand, see a clearer picture of your career growth in future. By the end of the Accountancy, you can equip yourself with the essentials to keep you afloat into the competition. Along with this Accountancy course, you will get 10 other premium courses. Also, you will get an original Hardcopy and PDF certificate for the title course and a student ID card absolutely free. What other courses are included with this Accountancy? Course 01: Accounting and Tax Course 02: Diploma in Quickbooks Bookkeeping Course 03:Team Management Course 04: Payroll Management - Diploma Course 05: Xero Course 06: Sage 50 Training Course 07: Microsoft Excel Training: Depreciation Accounting Course 08: Applied Business Analysis Diploma Course 09: GDPR Data Protection Level 5 Course 10: Microsoft Excel Level 3 As one of the top course providers in the UK, we're committed to providing you with the best educational experience possible. Our industry experts have designed the Accountancy to empower you to learn all at once with accuracy. You can take the course at your own pace - anytime, from anywhere. So, enrol now to advance your career! Benefits you'll get choosing Apex Learning for this Accountancy: One payment, but lifetime access to 11 CPD courses Certificate, 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 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 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. Curriculum of Accountancy Bundle Course 01: Accountancy Module 01: Introduction to Accounting Module 02: The Role of an Accountant Module 03: Accounting Concepts and Standards Module 04: Double-Entry Bookkeeping Module 05: Balance Sheet Module 06: Income statement Module 07: Financial statements Module 08: Cash Flow Statements Module 09: Understanding Profit and Loss Statement Module 10: Financial Budgeting and Planning Module 11: Auditing Course 02: Accounting and Tax Module 01: Tax System and Administration in the UK Module 02: Tax on Individuals Module 03: National Insurance Module 04: How to Submit a Self-Assessment Tax Return Module 05: Fundamentals of Income Tax Module 06: Payee, Payroll and Wages Module 07: Value Added Tax Module 08: Corporation Tax Module 09: Double Entry Accounting Module 10: Management Accounting and Financial Analysis Module 11: Career as a Tax Accountant in the UK Course 03: Diploma in Quickbooks Bookkeeping Getting prepared - access the software and course materials Getting started Setting up the system Nominal ledger Customers Suppliers Sales ledger Purchases ledger Sundry payments Sundry receipts Petty cash VAT - Value Added Tax Bank reconciliation Payroll / Wages Reports Tasks Course 05: Payroll Management - Diploma Sage 50 Payroll for Beginners Payroll Basics Company Settings Legislation Settings Pension Scheme Basics Pay Elements The Processing Date Adding Existing Employees Adding New Employees Payroll Processing Basics And Many More... Sage 50 Payroll Intermediate Level The Outline View and Criteria Global Changes Timesheets Departments and Analysis Holiday Schemes Recording Holidays Absence Reasons Statutory Sick Pay And Many More... Course 06: Xero Introduction Getting Started Invoices and Sales Bills and Purchases Bank Accounts Products and Services Fixed Assets Payroll VAT Returns Course 07: Sage 50 Training Module 1: Payroll Basics Module 2: Company Settings Module 3: Legislation Settings Module 4: Pension Scheme Basics Module 5: Pay Elements Module 6: The Processing Date Module 7: Adding Existing Employees Module 8: Adding New Employees Module 9: Payroll Processing Basics Module 10: Entering Payments Module 11: Pre-Update Reports Module 12: Updating Records Module 13: e-Submissions Basics Module 14: Process Payroll (November) Module 15: Employee Records and Reports Module 16: Editing Employee Records Module 17: Process Payroll (December) Module 18: Resetting Payments Module 19: Quick SSP Module 20: An Employee Leaves Module 21: Final Payroll Run Module 22: Reports and Historical Data Module 23: Year-End Procedures Sage 50 Payroll Advanced Diploma Module 1: The Outline View and Criteria Module 2: Global Changes Module 3: Timesheets Module 4: Departments and Analysis Module 5: Holiday Schemes Module 6: Recording Holidays Module 7: Absence Reasons Module 8: Statutory Sick Pay Module 9: Statutory Maternity Pay Module 10: Student Loans Module 11: Company Cars Module 12: Workplace Pensions Module 13: Holiday Funds Module 14: Roll Back Module 15: Passwords and Access Rights Module 16: Options and Links Module 17: Linking Payroll to Accounts Course 08: 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 09: Applied Business Analysis Diploma 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: Documenting and Managing Requirements Module 09: Career Prospect as a Business Analyst in the UK Course 10: 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 11: 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 CPD 115 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Accountancy 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 Our Accountancy 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 expertise will increase the value in your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included

Turn yourself into the linchpin of highly organised data and a facilitator of streamlined processes. Learn about Using Excel's Flash Fill and Autofill to Automate Data Entry.

Move from Beginner to Professional Level in Financial Modelling and Analysis with this detailed Advanced Financial Modeler Certificate Course.

In the ever-evolving landscape of UK business, staying ahead is not just an advantage but a necessity. The Ultimate Business Mastery Bundle is your strategic toolkit to navigate the contemporary challenges facing businesses today. From intricate financial analyses to streamlined administrative practices, the Ultimate Business Mastery course empowers you with a diverse skill set to excel in the dynamic world of business. The Ultimate Business Mastery Bundle Consists of the following Premium courses: Course 01: Administration : Office Administration Course 02: Business Finance Course 03: Business Analysis Level 3 Course 04: Business Law Course 05: Budget Analysis and Financial Report Building Course 06: Payroll (UK Payroll System, Payee, Tax, NI, Pension) Course 07: Retail Management Course 08: Data Analysis & Forecasting Course 09: Microsoft Excel & Accounting Training Course 10: Financial Analysis Methods Course 11: Business Administration and Financial Management Level 2 Certification Course 12: Economics Level 2 Diploma Course 13: Administrative Management Course 14: Quality Management Course 15: Complete Customer Service and Communication Skills at QLS Level 3 Course 16: Communication and Organisational Skills Course 17: Level 3 Purchasing & Procurement Course 18: Advanced Tax Accounting Course 19: Business English and Communication Skills Course 20: Learn Microsoft Word, PowerPoint & Outlook In 90 Minutes! 10 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 01: Effective Communication Skills Diploma Course 02: Business Networking Skills Course 03: Influencing and Negotiation Skills Course 04: Delegation Skills Training Course 05: Time Management Course 06: Leadership Skills Training Course 07: Decision Making and Critical Thinking Online Course Course 08: Emotional Intelligence and Social Management Diploma Course 09: Assertiveness Skills Course 10: Touch Typing Complete Training Diploma Learning Outcomes: Upon completion of The Ultimate Business Mastery bundle, you should be able to: Navigate complex financial landscapes with proficiency in Business Finance. Analyse and interpret business data, fostering Data Analysis and forecasting expertise. Demonstrate mastery in administrative functions through Office Administration skills. Develop an in-depth understanding of Business Law and its implications. Implement effective communication strategies with enhanced Customer Service skills. Cultivate advanced proficiency in Microsoft Excel for efficient financial reporting. As businesses grapple with the complexities of post-pandemic recovery, our course tackles the key issues head-on. Dive deep into Business Finance, Budget Analysis, and Payroll intricacies. Equip yourself with the expertise needed to master Retail Management and Data Analysis, preparing you to make real-time data-driven decisions. With a focus on Quality Management and Administrative Efficiency, the Ultimate Business Mastery bundle is your gateway to ensuring operational excellence in any professional environment. Elevate your career with a suite of skills that are not just relevant but crucial in today's competitive business landscape. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring business professionals seeking a well-rounded skill set. Entrepreneurs looking to enhance their business acumen. Individuals aiming to advance their career in administration and finance. Professionals interested in mastering data-driven decision-making. Those wanting to stay abreast of the latest business laws and regulations. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Requirements To participate in this Ultimate Business Mastery Bundle course, all you need is - A smart device A secure internet connection And a keen interest in Business Career path Financial Analyst: •35,000 - •45,000 per annum Retail Manager: •25,000 - •40,000 per annum Business Administrator: •22,000 - •35,000 per annum Data Analyst: •30,000 - •45,000 per annum Procurement Specialist: •28,000 - •40,000 per annum Quality Assurance Manager: •35,000 - •50,000 per annum Certificates CPD Accredited Certificate Digital certificate - Included CPD Accredited e-Certificate - Free CPD Accredited Hardcopy Certificate - Free Enrolment Letter - Free Student ID Card - Free

Fall into Savings. Enjoy the biggest price fall this Autumn! Life Just Got Better This Summer! Get Hard Copy + PDF Certificates + Transcript + Student ID Card as a Gift - Enrol Now Tired of browsing and searching for the course you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this 14-in-1 extensive bundle that has everything you need to succeed in Xero and other relevant fields! After surveying thousands of learners just like you and considering their valuable feedback, this all in one Xero bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Xero course that will enhance your skills and prepare you for the competitive job market. Also, our Xero experts are available for answering your queries and help you along your learning journey. Advanced audiovisual learning modules of these courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once. Furthermore, to help you showcase your expertise in Xero, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest. This Xero Bundle Consists of the following Premium courses: Course 01: Level 3 Xero Training Course 02: Payroll Management - Diploma Course 03: Introduction to Accounting Course 04: Accounting and Bookkeeping Level 2 Course 05: Managerial Accounting Masterclass Course 06: Diploma in Quickbooks Bookkeeping Course 07: Theory of Constraints, Throughput Accounting and Lean Accounting Course 08: Internal Audit Training Diploma Course 09: Level 3 Tax Accounting Course 10: Team Management Course 11: Business Analysis Level 3 Course 12: GDPR Data Protection Level 5 Course 13: Microsoft Excel Training: Depreciation Accounting Course 14: Microsoft Excel Level 3 Benefits you'll get choosing Apex Learning for this Xero: Pay once and get lifetime access to 14 CPD courses 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 (For The Title Course) Hard Copy Certificate: Free (For The Title Course) Curriculum of Xero Bundle Course 01: Level 3 Xero Training Introduction Getting Started Invoices and Sales Bills and Purchases Bank Accounts Products and Services Fixed Assets Payroll VAT Returns Course 02: Payroll Management - Diploma Sage 50 Payroll for Beginners Module 1: Payroll Basics Module 2: Company Settings Module 3: Legislation Settings Module 4: Pension Scheme Basics Module 5: Pay Elements Module 6: The Processing Date Module 7: Adding Existing Employees Module 8: Adding New Employees Module 9: Payroll Processing Basics Module 10: Entering Payments Module 11: Pre-Update Reports Module 12: Updating Records Module 13: e-Submissions Basics Module 14: Process Payroll (November) Module 15: Employee Records and Reports Module 16: Editing Employee Records Module 17: Process Payroll (December) Module 18: Resetting Payments Module 19: Quick SSP Module 20: An Employee Leaves Module 21: Final Payroll Run Module 22: Reports and Historical Data Module 23: Year-End Procedures Sage 50 Payroll Intermediate Level Module 1: The Outline View and Criteria Module 2: Global Changes Module 3: Timesheets Module 4: Departments and Analysis Module 5: Holiday Schemes Module 6: Recording Holidays Module 7: Absence Reasons Module 8: Statutory Sick Pay Module 9: Statutory Maternity Pay Module 10: Student Loans Module 11: Company Cars Module 12: Workplace Pensions Module 13: Holiday Funds Module 14: Roll Back Module 15: Passwords and Access Rights Module 16: Options and Links Module 17: Linking Payroll to Accounts Course 03: 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 04: 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 05: Managerial Accounting Masterclass Setion 1 Manaerial Accounting Defined Financial Accounting Compared to Managerial Accounting Trends Foundation Concepts Setion 2 Process costing vs Job Cost Job cost part 1 Job cost part 2 Allocating costs to multiple products Departmental Overhead Rate Activity-Based Costing Setion 3 Cost Behavior Cost Behavior Continued Break Even Point Break Even Point Changes Sales Mix Pricing Short Term Decisions Section 4 Budgeting Intro Budgetin continued Operating Budgets Cash Budget Budgeted Balance Sheet Performance Evaluation Performance Evaluation Cont Standards Standard Costs Continued Setion 5 Capital Investment Decisions Capital Investment Analysis Course 06: Diploma in Quickbooks Bookkeeping Getting prepared - access the software and course materials Getting started Setting up the system Nominal ledger Customers Suppliers Sales ledger Purchases ledger Sundry payments Sundry receipts Petty cash VAT - Value Added Tax Bank reconciliation Payroll / Wages Reports Tasks Course 07: Theory of Constraints, Throughput Accounting and Lean Accounting The Theory of Constraints and Throughput Accounting Lean Accounting Summary and Lean Accounting Assignment Course 08: Internal Audit Training Diploma Auditing as a Form of Assurance Internal Audit Procedures Technology-based Internal Audit Internal Control and Control Risk Audit Interviews Reporting Audit Outcome UK Internal Audit Standards Career as an Auditor Course 09: 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 10: Presenting Financial Information Presenting Financial Information The Hierarchy of Performance Indicators The Principle of Effective Reports Guidelines for Designing Management Reports Methods of Presenting Performance Data The Control Chart: Highlighting the Variation in the Data The Pareto Chart: Highlighting Priorities Exercise: The Control Chart An Example Management Report Interpreting Performance Data Supporting Colleagues by Giving Feedback Data Visualisation Final Thoughts on Presenting Financial Information Course 11: Business Analysis Level 3 Introduction to Business Analysis Business Processes Business Analysis Planning and Monitoring Strategic Analysis and Product Scope Solution Evaluation Investigation Techniques Ratio Analysis Stakeholder Analysis and Management Course 12: GDPR Data Protection Level 5 GDPR Basics GDPR Explained Lawful Basis for Preparation Rights and Breaches Responsibilities and Obligations Course 13: 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 14: 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 CPD 115 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Xero 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 Our Xero is 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 that 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 Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Level 3 Xero Training) 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.

Become an expert in Microsoft Excel with our comprehensive online training program. Learn formulas, charts, pivot tables, data analysis, macros, and more. Develop in-demand Excel skills through hands-on exercises and project work. Gain proficiency in this powerful software to advance your career or improve productivity.

Course Objectives At the end of this course you will be able to: Record and edit a Macro Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects. Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks Create an error handling routine in case things go wrong with VBA code ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience.. Simon Harper - Lloyd's of London My learning experience was awesome. Perdinand Reagan - Subsea7 Very nice and relaxed approach to teaching. Was definitely a good learning experience. Jerome Pupe - S5 Agency World The Trainer – Very positive + patient + helpful + thorough Agnes Souza - Direct Wines ' 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 classroom, one to one, tailored and bespoke courses. Tailored In Company training: 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. Introduction to Macros and VBA Introducing Visual Basic for Applications Recording a Macro Naming conventions for Macro Procedures Running a Macro Absolute or Relative Cell Referencing Saving and Opening Files with Macros Making macros always available Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes Editing a Macro in the Visual Basic Editor Understanding the Development Environment Customising the Editor Tips for General Typing in VBA Using Visual Basic Help Working with Procedures Program Design Understanding Modules Naming Rules Creating a Module Understanding Procedures Programming Macro Concepts Creating a Subroutine Creating a Function Understanding Arguments Exiting Procedures Calling Procedures Objects, Properties, Methods and Events Understanding Objects Properties, Methods, and Events Navigating the Object Hierarchy Understanding Collections Accessing a Member of a Collection Understanding Hierarchy Using the Object Browser Using the With Statement Working with Properties Working with Methods Creating an Event Procedure Reserved Macro Names Using Expressions, Variables and Intrinsic Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Determining the Value of Variables Working with Variable Scope Using Built-in VBA Functions Understanding Constants Using Message Boxes Controlling the Answer to a Message Box Using Input Boxes Declaring and Using Object Variables Controlling Program Execution Understanding Control-of-Flow Structures Using the If...End If Decision Structures Nested If Statements Using the Select Case ... End Select Structure Using the Do ... Loop Structure Using the For ... Next Structure Using the For Each ... Next Structure Guidelines for Use of Control-of-Flow Structures Debugging and Handling Errors Understanding Errors Using Debugging Tools Setting Breakpoints and Using Break Mode Stepping Through Code Trapping Errors with the On Error Statement Understanding the Err Object Working with Inline Error Handling Writing an Error-Handling Routine Working with Forms and Controls Understanding UserForms Creating a Form Displaying and Removing a Form Aligning and Sizing Controls Using the Toolbox Working with a Form's Properties, Methods, and Events Working with Form and Control Properties, Methods and Event Setting the Tab Order Populating a Control Who is this course for? Who is this course for? This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools. Requirements Requirements Preferably, delegates should have attended the Excel Advanced course. 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

QLS Endorsed + CPD QS Accredited - Dual Certification | Instant Access | 24/7 Tutor Support | All-Inclusive Cost