12215 Courses in Nottingham delivered On Demand

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 Sage 50 Payroll Bundle Now Become an invaluable asset to your company's future and take charge of its finances almost immediately by learning to use Sage 50. Sage 50 Payroll is today's trusted benchmark in money handling, and we can train you to use it without any prior experience. No matter whether you are starting as an accountant in a large company, or having to pay salaries in a private firm, this learning experience can take your career and business to the next level. With a single payment you will gain access to Sage 50 Payroll Advanced Diploma including 10 Career development courses, original hardcopy certificate, transcript and a student ID card. Courses are included with this Sage 50 Payroll Advanced Diploma: Course 01: Sage 50 Training Course 02: Payroll Management Course Course 03: Level 3 Xero Training Course 04: Financial Management Course 05: Accounting and Bookkeeping Level 2 Course 06: Applied Business Analysis Diploma Course 07: Data Analysis in Excel Level 3 Course Course 08: Office Skills Course 09: Effective Communication Skills Course 10: Performance Management Course 11: New Functions in Microsoft Excel 2021 This Sage 50 Payroll Advanced Diploma offers you all the training you will need to take a Payroll Administrator's role and establish your skills with Sage software. Benefits you'll get choosing Apex Learning for this Sage 50: One payment, but lifetime access to 11 CPD courses Learn at your ease - anytime, from anywhere Study the Sage 50 course from your computer, tablet or mobile device CPD accredited Sage 50 course - improve the chance of gaining professional skills Gain valuable experience of Sage 50 without leaving your home Curriculum **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 more............. How will I get my Certificate? After successfully completing the Sage 50 Payroll 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) CPD 115 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 Sage 50 Payroll Advanced Diploma. It is available to all students, of all academic backgrounds. Requirements Our Sage 50 Payroll Advanced Diploma 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 This Sage 50 Training will help you stand out from the competition and will help you in procuring jobs like: Bookkeeper Accounts Executive Auditor Staff Accountant Tax Accountant 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 (Sage 50 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.

Description Depreciation Accounting for Fixed assets is usual activity and process for any accountant in his/her job, but things can get really tricky and difficult when there are numbers of assets and there are transactions like disposal, sale and purchase in mid-month/mid-year.  This course is designed to help you understand the concept of depreciation through practical situations and examples It is very important to have a robust Fixed assets and depreciation model in place which calculates accurate depreciation monthly, helps you in budgeting and forecasting depreciation costs for next year (years to come). Also when there are assets sale/disposal you need to figure out exact profit or loss on such sale/disposal (especially when it takes place on old days in the month/year) I will guide you through practical accounting issues and situations while accounting for depreciation, forecasting depreciation costs, impact of sale of an assets (profit and loss) on your profit and loss statement and Balance sheet  Depreciation model which I have prepared for the course is quite robust and takes care of any practical scenario in dealing with situations At end of his course, you will have hands-on experience in dealing with any challenging depreciation and fixed assets accounting situation and its financial impact (which your manager would want to know accurately). You will also receipt free copy of the template used in the course !! So let's dive into it ! What Will I Learn? Hands on knowledge on how depreciation and fixed assets accounting works Fixed assets and depreciation forecasting in Business budgeting The impact of the sale of assets prematurely on your profit and loss for the period Requirements Basic to Intermediate knowledge of Microsoft Excel Basic to Intermediate knowledge of Accounting (Practical Accounting) Accounting terms for Fixed Assets and Depreciation (briefly explained in introduction section of this course) Who is the target audience? Accountants who want to sharpen their practical accounting Knowledge for Fixed Assets and depreciation Accounting Auditors who want to audit effectively for Fixed assets and depreciation for their clients Non-Accounting professional/Entrepreneurs who wants to estimate impact of depreciation on their investment and Profit and Loss over fixed term (usually assets useful life) Introduction Accounting For Depreciation with Advanced Excel Model Introduction 00:03:00 Minimum requirements before taking the course 00:01:00 What is Depreciation? What is amortization? And related terms What is Depreciation 00:02:00 What is Amortization? 00:02:00 What Are The Related Terms 00:02:00 Various methods of depreciation and Depreciation Accounting Most common methods of Depreciation 00:09:00 Depreciation Accounting 00:05:00 Depreciation and Taxation Depreciation Tax Shield 00:04:00 Depreciation Tax Shield Under Various Depreciation Methods 00:03:00 Master Depreciation Model (how to use) Introduction and basics of Depreciation Model in Excel 00:01:00 Deep Dive into Depreciation Model 00:07:00 How to use the model with Example 00:10:00 Advanced functionalities of the Model 00:11:00 Conclusion (Thank you) Conclusion 00:01:00

Introduction to Excel's Pivot Tables This presentation will explore the use of pivot tables, including what they are, what you can do with them, how to create them, and other special features. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

Overview Excel at Marketing Through a Well Defined Marketing Strategy Course is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Excel at Marketing Through a Well Defined Marketing Strategy Course and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 05 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Excel at Marketing Through a Well-Defined Marketing Strategy Section 01: Create Well-Defined Marketing Objectives Marketing Plan Objectives 00:07:00 Aligning Your Marketing Objectives 00:06:00 Guidelines for Creating Marketing Objectives 00:02:00 Types of Objectives 00:08:00 Workshop - Create Your Marketing Objectives 00:02:00 Section 02: Marketing Programs that Power Customer Acquisition Marketing Programs Explained 00:01:00 What types of marketing programs are best for your business? 00:03:00 Your Website 00:05:00 SEO 00:05:00 Advertising Online 00:09:00 Print Advertising 00:03:00 Press Relations 00:06:00 Social Media 00:05:00 Email 00:06:00 Content Marketing 00:06:00 Trade Shows 00:06:00 Retention Marketing 00:05:00 Additional Marketing Programs 00:04:00 Section 03: Thought Leadership That Drives Customer Acquisition Thought Leadership Explained 00:02:00 Stand Out with Thought Leadership 00:01:00 Why Thought Leadership Matters 00:05:00 Thought Leadership Programs 00:10:00 Workshop: Create Your Thought Leadership Strategy 00:02:00 Section 04: Create a Strategic Marketing Plan That Drives Action Strategic Marketing Plan Explained 00:01:00 Choosing a Marketing Program 00:13:00 Case Study: Product and Services Businesses 00:05:00 Evaluate Your Marketing Mix 00:05:00 Objectives, Tactics, and Assumptions about your marketing program 00:09:00 Common Mistakes 00:03:00 Workshop: Create Your Marketing Action Plan 00:04:00 Support Materials Resource - Excel at Marketing Through a Well Defined Marketing Strategy 00:00:00

Master Quickbooks for all your accounting and bookkeeping needs with this step-by-step training course! The Complete QuickBooks Bookkeeping with Excel and Xero Accounting will build your proficiency in Quickbooks in no time, with instructor-led guidance taking you through fundamental procedures. You will also develop your accounting knowledge, gaining in-demand skills to work for the finance department of top organisations. This practical training course includes up-to-date knowledge, shortcuts and tips for faster, more efficient accounting and bookkeeping. Kickstart your career today and go from beginner to expert in no time! Why buy this Complete QuickBooks Bookkeeping with Excel and Xero Accounting? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Complete QuickBooks Bookkeeping with Excel and Xero Accounting you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Complete QuickBooks Bookkeeping with Excel and Xero Accounting does not require you to have any prior qualifications or experience. You can just enrol and start learning. Prerequisites This Complete QuickBooks Bookkeeping with Excel and Xero Accounting was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Complete QuickBooks Bookkeeping with Excel and Xero Accounting is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Getting prepared - access the software and course materials The structure of the course - first things first! 00:05:00 Set up free trial 00:03:00 Getting started Starting A New Company File 00:11:00 Setting up the system Enter opening balances 00:02:00 Reverse opening balances - accruals and prepayments 00:06:00 Report Journal 00:05:00 Nominal ledger Amend The Nominal Ledger 00:07:00 Report listing the nominal ledgers 00:02:00 Customers Enter customers 00:09:00 Report on customer contact information 00:01:00 Suppliers Enter Suppliers 00:05:00 Supplier Contact List 00:02:00 Sales ledger Enter Invoices 00:09:00 Invoice Entering 00:03:00 Invoice batch 00:06:00 Post Sales Credit Notes 00:08:00 Report showing Customer Activity 00:03:00 Aged Debtors 00:02:00 Purchases ledger Post Supplier Invoices 00:03:00 Entering a Batch of Supplier Bills 00:09:00 Credit Notes Suppliers 00:05:00 Reclassify Supplier Bills - Flash Bulbs Purchased 00:04:00 Supplier Account Activity Report 00:04:00 Sundry payments Post Cheques 00:07:00 Reports showing supplier payments 00:01:00 Sundry receipts Receipts from customers 00:07:00 Report showing customer receipts 00:02:00 Petty cash Post Petty Cash Transactions and Report 00:04:00 Post cash payments to ledgers 00:02:00 Enter petty cash items 00:14:00 Report on Petty Cash Payments Proper 00:05:00 Post Sundry Payments 00:05:00 Report Bank Payments 00:03:00 VAT - Value Added Tax VAT Return 00:03:00 Bank reconciliation Reconcile The Bank 00:10:00 Provide A Report Showing Any Unreconnciled Transaction 00:02:00 Payroll / Wages Post the Wages Journal 00:08:00 Posting Journal Adjustments 00:02:00 Reports Month end adjustments 00:03:00 Month end reports 00:06:00 Tasks Task- Clearing the accounts 00:06:00 Task - Customer report 00:01:00 Additional Resources Course Paper 00:00:00

This course is a great opportunity for you to learn new skills or enhance your existing ones in Microsoft Office skills with admin support. You will also gain valuable insights into secretarial and PA roles. Whether you want to advance your career or start a new one in office administration or support roles. This course will equip you with the knowledge and skills you need to succeed. Don't miss this chance to enrol today!

Description: Microsoft Office 2016 Complete Bundle Course (Word, Excel, PowerPoint, Outlook and Access) is intended to prepare you to get complete control on Microsoft Office 2016. It is designed to educate about Microsoft Office 2016. In this course, you will learn about the basic features of Microsoft Word such as creating a new document, personalizing the Microsoft Word interface, adding graphics, etc. Besides, you will learn about the techniques of controlling page appearance, proofing and editing a document. Following that, you will learn about the essentials to create and work with an electronic spreadsheet. You will be able to insert and delete text or images, adjust cells, create columns, rows and much more. This advanced course helps you to navigate the PowerPoint environment, create and save PowerPoint presentation, delivering advanced text editing etc. Finally, you will learn how to set up and use Outlook on Windows. It will assist you in creating and sending messages, managing contacts, using the calendar, managing tasks, working with notes and so much more. Overall, this course is created especially for you to provide all information to access Microsoft Office 2016. Enroll today and get benefit from this course. Learning Outcomes: Changing user information, sharing documents, working with comments and comparing document changes Collaborate on documents by reviewing them, merging changes and co-authoring Discover how to best use reference tools, like captions, cross-references, bookmarks, hyperlinks, footnotes, endnotes, citations and bibliographies Working with master documents and subdocuments Adding cover page; creating an index, table of contents, and ancillary tables; and managing outlines to simplify and manage large documents Suppressing information from a document, setting editing restrictions, adding digital signature platforms, and restricting document access Find out techniques for saving and exporting form data, along with creating and manipulating forms Using SharePoint Server with Word in order to create, compare and combine different document versions Ways to update worksheet properties, create and edit macros, applying conditional formatting and add data validation criteria Auditing worksheets through tracing cells, troubleshooting invalid data and formula errors, watching and evaluating formulas, and creating a data list online Create Sparklines, scenarios and interactive data using Power View Perform what-if analysis and statistical analysis with the Analysis ToolPak Ways to multitask by consolidating data, linking cells in different workbooks, and merging them Export Excel data, import delimited text files, integrate Excel data with the web and create web queries How to import and export XML data PowerPoint environment and how to modify it according to needs Customizing user interface and setting up options Create and manage sections, modify slide masters and slide layouts, add headers and footers, modify notes master and handout master Creating and modifying SmartArt Adding audio video to presentations and customizing animations and transitions to enhance presentation Better collaboration by adding comments, reviews, storing and sharing presentations on the web Setting up and creating custom slide shows, adding hyperlink and action buttons, and recording a presentation Security and distribution of presentations through various outlets Change message settings, properties, options, using automatic replies and inserting objects Sort and filter options, organising and searching messages, managing junk mail and mailbox Managing advanced calendar options, additional calendars, meeting responses, and assigning tasks Advanced, forward and export contact options, handling contacts and editing electronic business cards Sharing calendars and contacts whilst also delegating access to mail folders to others Modifying data file settings and backing up Outlook items Email security and configuring email message security Designing forms through adding and setting controls, creating subforms, using tab pages to organize information, improve navigation, formatting and applying conditional formatting Data, field, form and record validation Creating macros, restricting records using conditions, validate data, automate data entry and convert a macro to VBA in order to enhance user interface design Link tables to external data sources, manage database, determine object dependency, document database, and analyze database performance Allow multiple user access to database by splitting it, implement security, set passwords, convert Access database to ACCDE file, and add digital signatures Create and modify switchboards and startup options Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2016 Complete Bundle Course (Word, Excel, PowerPoint, Outlook and Access) is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2016 Complete Bundle Course (Word, Excel, PowerPoint, Outlook and Access) is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Microsoft Word 2016 Modify User Information 00:15:00 Share a Document 00:30:00 Work with Comments 00:15:00 Compare Document Changes 00:15:00 Review a Document 00:15:00 Merge Document Changes 00:15:00 Coauthor Documents 00:15:00 Add Captions 00:15:00 Add Cross-References 00:15:00 Add Bookmarks 00:15:00 Add Hyperlinks 00:15:00 Insert Footnotes and Endnotes 00:15:00 Add Citations 00:30:00 Insert a Bibliography 00:15:00 Insert Blank and Cover Pages 00:15:00 Insert an Index 00:30:00 Insert a Table of Contents 00:30:00 Insert an Ancillary Table 00:15:00 Manage Outlines 00:30:00 Create a Master Document 00:30:00 Suppress Information 00:30:00 Set Editing Restrictions 00:30:00 Add a Digital Signature to a Document 00:15:00 Restrict Document Access 00:15:00 Create Forms 00:30:00 Manipulate Forms 00:15:00 Form Data Conversion 00:15:00 Create a New Document Version 00:30:00 Compare Document Versions 00:15:00 Merge Document Versions 00:15:00 Activities - Microsoft Word 2016 Advanced 00:00:00 Microsoft Excel 2016 Update Workbook Properties 00:15:00 Activity-Update Workbook Properties 00:05:00 Create and Edit a Macro 00:15:00 Activity-Create and Edit a Macro 00:05:00 Apply Conditional Formatting 00:15:00 Activity-Apply Conditional Formatting 00:05:00 Add Data Validation Criteria 00:15:00 Activity-Add Data Validation Criteriaty 00:05:00 Trace Cells 00:15:00 Activity-Trace Cells 00:05:00 Troubleshoot Invalid Data and Formula Errors 00:15:00 Activity-Troubleshoot Invalid Data and Formula Errors 00:05:00 Watch and Evaluate Formulas 00:15:00 Activity-Watch and Evaluate Formulas 00:05:00 Create a Data List Outline 00:15:00 Activity-Create a Data List Outline 00:05:00 Create Sparklines 00:15:00 Activity_Create Sparklines 00:05:00 Create Scenarios 00:15:00 Activity-Create Scenarios 00:05:00 Perform a What-If Analysis 00:15:00 Activity-Perform a What-If Analysis 00:05:00 Perform a Statistical Analysis with the Analysis ToolPak 00:15:00 Activity-Perform a Statistical Analysis with the Analysis ToolPak 00:05:00 Create Interactive Data with Power View 00:15:00 Activity-Create Interactive Data with Power View 00:05:00 Consolidate Data 00:15:00 Activity-Consolidate Data 00:05:00 Link Cells in Different Workbooks 00:15:00 Activity-Link Cells in Different Workbooks 00:05:00 Merge Workbooks 00:15:00 Activity-Merge Workbooks 00:05:00 Export Excel Data 00:15:00 Activity-Export Excel Data 00:05:00 Import a Delimited Text File 00:14:00 Activity- Import a Delimited Text File 00:05:00 Integrate Excel Data with the Web 00:15:00 Activity-Integrate Excel Data with the Web 00:05:00 Create a Web Query 00:15:00 Activity-Create a Web Query 00:05:00 Import and Export XML Data 00:15:00 Activity-Import and Export XML Data 00:05:00 Activities and Exercise Files - Microsoft Excel 2016 Advanced 00:00:00 Microsoft PowerPoint 2016 Customize the User Interface 01:30:00 Set PowerPoint 2016 Options 00:45:00 Create and Manage Sections 01:00:00 Modify Slide Masters and Slide Layouts 01:15:00 Add Headers and Footers 00:30:00 Modify the Notes Master and the Handout Master 00:45:00 Create SmartArt 00:45:00 Modify SmartArt 01:00:00 Add Audio to a Presentation 00:45:00 Add Video to a Presentation 01:00:00 Customize Animations and Transitions 01:00:00 Add Comments to a Presentation 00:45:00 Review a Presentation 00:45:00 Store and Share Presentations on the Web 01:30:00 Annotate a Presentation 00:45:00 Set Up a Slide Show 00:45:00 Create a Custom Slide Show 00:30:00 Add Hyperlinks and Action Buttons 00:45:00 Record a Presentation 00:15:00 Secure a Presentation 01:30:00 Present a Slide Show Online 01:00:00 Create a Video or a CD 00:45:00 Activities - Microsoft PowerPoint 2016 Advanced 00:00:00 Microsoft Outlook 2016 Insert Advanced Characters and Objects 01:30:00 Modify Message Settings, Properties, and Options 01:30:00 Use Automatic Replies 01:30:00 Sort Messages 00:45:00 Filter Messages 01:00:00 Organize Messages 02:00:00 Search Messages 01:30:00 Manage Junk Mail 01:00:00 Manage Your Mailbox 02:00:00 Manage Advanced Calendar Options 00:45:00 Manage Additional Calendars 01:00:00 Manage Meeting Responses 00:45:00 Assign and Manage Tasks 01:00:00 Edit an Electronic Business Card 01:00:00 Manage Advanced Contact Options 01:30:00 Forward Contacts 00:30:00 Export Contacts 01:00:00 Delegate Access to Mail Folders 01:00:00 Share Your Calendar 00:30:00 Share Your Contacts 00:15:00 Back Up Outlook Items 00:45:00 Change Data File Settings 00:45:00 Configure E-mail Message Security Settings 00:30:00 Activities - Microsoft Outlook 2016 Advanced 00:00:00 Microsoft Access 2016 Add Controls to Forms 01:00:00 Set Form Controls 01:00:00 Create Subforms 00:30:00 Organize Information with Tab Pages 00:30:00 Enhance Navigation with Forms 00:30:00 Format a Form 01:00:00 Apply Conditional Formatting 00:30:00 Field Validation 00:30:00 Form and Record Validation 00:30:00 Create a Macro 01:00:00 Restrict Records Using a Condition 00:30:00 Validate Data Using a Macro 00:30:00 Automate Data Entry Using a Macro 00:30:00 Convert a Macro to VBA 00:30:00 Link Tables to External Data Sources 00:30:00 Manage a Database 00:30:00 Determine Object Dependency 00:30:00 Document a Database 00:30:00 Analyze the Performance of a Database 00:30:00 Split a Database for Multiple User Access 00:30:00 Implement Security 00:30:00 Set Passwords 00:30:00 Convert an Access Database to an ACCDE File 00:30:00 Package a Database with a Digital Signature 00:30:00 Create a Database Switchboard 01:00:00 Modify a Database Switchboard 00:30:00 Set Startup Options 00:30:00 Activities - Microsoft Access 2016 Advanced 00:00:00 Mock Exam Mock Exam- Microsoft Office 2016 Advanced 00:30:00 Final Exam Final Exam- Microsoft Office 2016 Advanced 00:30:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

In today’s world, the accounting and finance industry is more competitive than ever and goes beyond simply having theoretical qualifications. Candidates who desire to make an impression are required to have an understanding of computerised packages such as Sage 50 Accounts & Microsoft Excel. Our 3-month training programme provides everything you need to become fully qualified in Sage 50 Accounts & Microsoft Excel. Once you have completed your training session you will gain accredited certifications and three months of remote experience directly with one of our clients. After completing this programme candidates will be able to showcase that they have the following: Sage 50 Accounts Beginners Sage 50 Accounts Intermediate Sage 50 Accounts Advanced Microsoft Excel for Accountants beginners to advanced 3 months of remote work experience Job reference Career support This comprehensive training programme has been developed to enhance your CV and boost your job prospects. CPD 480 CPD hours / pointsAccredited by The CPD Certification Service Description What’s included 3 months access to the online course Professional qualifications Guaranteed work placement (12 weeks) Accountancy certifications Learn industry-leading software to stand out from the crowd Information-packed practical training starting from basics to advance principles Course content designed considering current software and the job market trends A practical learning experience working with live company data Who is this course for? Part Qualified, Freshly Qualified Accountancy Students Graduates with No or little Job Experience Students Currently Studying or intending to study Accountancy or want to refresh knowledge on tax and accounting People who are already working in the industry but want to gain further knowledge about tax and accounting And Thinking of opening an accountancy/Tax/Payroll Practice Requirements There are no formal entry requirements for this course. We also expect the candidates to have basic knowledge of Accountancy. Career path Candidates who have completed this programme have secured jobs in the following roles; Trainee Accountant – Salary £24,750 Credit Controller – Salary £21,434.43 General Ledger Accountant – Salary £23,850.60 Accountant – Salary £28,985.77 Insurance Accountant – Salary £29,541.25

Overview The job market in the UK has been through a significant amount of turbulence over the last year, mainly due to the pandemic and recent war. As a result, finding a suitable niche in this highly competitive job market has become more challenging. So to cover up all your limitations and uproot all the hurdles to a stable and dignified career, we are here with a package you can't refuse! This time Apex Learning will show you the pathway to a successful career through the most well-researched and expertly made Microsoft Office bundle. Our Microsoft Office package, with the latest digital study materials and innovative learning method, will give you in-depth knowledge of this domain. You will learn the basics step by step with clear lessons and support from experienced tutors. You will be able to hone your knowledge from beginner to advanced level of Microsoft office as there will be frequent tests, fun quizzes and practical analysis of the topics. Moreover, you will keep yourself up to date with the current situation in the area of your interest. As Microsoft Office, there are endless opportunities for you if you have the right knowledge and skill. Therefore, to make your career journey a successful one, we designed this Microsoft Office bundle as a one-stop solution for you. This 20-in 1 Ultimate Microsoft Office bundle consists of the following Courses: Course 01: MS Word Diploma Course 02: Proofreading & Copyediting Course 03: PowerPoint Diploma Course 04: Microsoft Excel Level 3 Course 05: New Functions in Microsoft Excel 2021 Course 06: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query Course 07: Microsoft Excel: Excel Sheet Comparison with VBA Course 08: Microsoft Excel: Master Power Query in 120 Minutes! Course 09: Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Course 10: Excel Pivot Tables Course 11: Data Analysis in Microsoft Excel Complete Training Course 12: Excel Must know Formulas and Functions Course 13: Excel spreadsheet for Beginner Course 14: Excel Data Analysis Course 15: Excel Vlookup, Xlookup, Match and Index Course 16: Excel Pivot Tables, Pivot Charts, Slicers, and Timelines Course 17: PowerBI Formulas Course 18: Outlook Tips and tricks Course 19: Excel PowerQuery and PowerPivot Course 20: Complete Microsoft Power BI 2021 Additionally, you will get 5 other career-guided courses in this Microsoft Office bundle: Course 01: Career Development Plan Fundamentals Course 02: CV Writing and Job Searching Course 03: Interview Skills: Ace the Interview Course 04: Video Job Interview for Job Seekers Course 05: Create a Professional LinkedIn Profile Learning Outcomes of Microsoft Office bundle This career-oriented bundle will help you to Gain the ability to excel in the role of Microsoft Office Know your responsibilities as Microsoft Office and convey your experience to others Gain excellent interpersonal and communication skills Know the pros and cons of working as Microsoft Office Adhere to the regulations around this area Gain time and risk management skills to ensure efficiency Manipulate technological advancement to become more effective Maintain moral standards and set an example for your peers So, stop scrolling down and procure the skills and aptitude with Apex Learning to outshine all your peers by enrolling in this Microsoft Office bundle. Certificates Digital certificate - Included Hard copy certificate - Included You will get the Hard Copy certificate for the title course (MS Word Diploma) 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. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is for anyone who wants to learn Microsoft Office for office admin jobs. It’s ideal for beginners who are just starting or for those who want to refresh their Microsoft Office skills. By mastering Microsoft Office, you’ll be better prepared to handle office tasks efficiently. Requirements This Microsoft Office course has been designed to be fully compatible with tablets and smartphones. Career path Completing this course will enhance your CV and prepare you for a range of office administration roles where Microsoft Office skills are highly valued. Office Assistant: £18,000 to £25,000 Administrative Coordinator: £20,000 to £30,000 Executive Secretary: £25,000 to £40,000 Office Manager: £30,000 to £50,000 Senior Administrative Officer: £40,000 to £60,000 Operations Administrator: £45,000 to £70,000 With strong Microsoft Office knowledge, you’ll be ready to excel in these roles and stand out in the competitive job market.

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Microsoft Essentials bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 30 course mega bundle that will exceed your expectations within your budget. The Microsoft Essentials related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive bundle will help you build a solid foundation to become a proficient worker in the sector. This Bundle consists of the following 25 CPD Accredited Premium courses - Course 1: MS Word Diploma Course 2: Proofreading & Copyediting Course 3: PowerPoint Diploma Course 4: Microsoft Excel Level 3 Course 5: New Functions in Excel 2021 Course 6: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query Course 7: Excel: Excel Sheet Comparison with VBA Course 8: Excel: Master Power Query in 120 Minutes! Course 9: Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Course 10: Excel Pivot Tables Course 11: Data Analysis in Excel Complete Training Course 12: Excel Must know Formulas and Functions Course 13: Excel spreadsheet for Beginner Course 14: Excel Data Analysis Course 15: Excel Vlookup, Xlookup, Match and Index Course 16: Excel Pivot Tables, Pivot Charts, Slicers, and Timelines Course 17: PowerBI Formulas Course 18: Outlook Tips and tricks Course 19: Excel PowerQuery and PowerPivot Course 20: Complete Microsoft Power BI 2021 Course 21: The Complete Microsoft Outlook Masterclass Course 22: Microsoft Access Complete Course (Beginner, Intermediate, Advanced) Course 23: Microsoft Access Tables and Queries Course 24: Microsoft Access Databases Forms and Reports Course 25: Microsoft Teams 5 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 1: Career Development Plan Fundamentals Course 2: CV Writing and Job Searching Course 3: Interview Skills: Ace the Interview Course 4: Video Job Interview for Job Seekers Course 5: Create a Professional LinkedIn Profile Learning Outcome This tailor-made bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This Essentials Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete Microsoft Essentials training materials, you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for free. Original Hard Copy certificates need to be ordered at an additional cost of •8. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Microsoft Teams Essentials bundle! This bundle is also ideal for professionals looking for career advancement. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in Microsoft Teams Essentials Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.