1291 Courses delivered Online

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Ever feel like there's a secret handshake you need to know to break into the world of administration? We've all been there. But the truth is, with the right skills and training, you can be that friendly face greeting clients and the organised whiz behind the scenes any office needs. According to the UK's Office for National Statistics, the employment of receptionists is projected to grow by 8% from 2020 to 2030, significantly faster than the average for all occupations. This Receptionist program equips you with the essential knowledge and practical skills to excel in today's demanding workplace. Our comprehensive bundle equips you with the skills to excel as a receptionist and office administrator. Master communication, phone etiquette, and visitor management. Learn administrative tasks, UK employment law, customer service, minute-taking, and Microsoft Office. Become a highly sought-after professional! With a single payment, you will gain access to the Receptionist: Office Admin and Reception Training course, including 5 premium courses, and 5 PDF certificates for Absolutely Free. This Receptionist: Office Admin and Reception Training Bundle Contains 05 of Our Premium Courses for One Discounted Price: Course 01: Diploma in Receptionist Skills at QLS Level 5 Course 02: Administrative Receptionist Course 03: UK Employment Law Course 04: Customer Service Training & Minute-Taking Administrator Course 05: Complete Microsoft Office Enrolling in this bundle could be the key to unlocking a rewarding career path. Think receptionist, office administrator, personal assistant - the options are endless! So, what are you waiting for? Sign up today and watch your office skills take flight! Learning Outcomes of Receptionist: Office Admin and Reception Master professional communication for clear and impactful interactions. Develop exceptional telephone etiquette for a positive first impression. Gain a strong understanding of UK employment law and best practices. Enhance customer service skills to build strong client relationships. Learn effective minute-taking techniques for accurate meeting records. Achieve proficiency in Microsoft Office applications for efficient workflow. Why Choose Us? Get a Free CPD Accredited Certificate upon completion of Receptionist: Office Admin and Reception Get a free student ID card with Receptionist: Office Admin and Reception Training program (£10 postal charge will be applicable for international delivery) The Receptionist: Office Admin and Reception is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the Receptionist: Office Admin and Reception course materials The Receptionist: Office Admin and Reception comes with 24/7 tutor support Course 01: Diploma in Receptionist Skills at QLS Level 5 Introduction to Reception and Receptionist Business Telephone Skills Representing Your Boss and Company Mail Services and Shipping Travel Arrangements Organising Meetings and Conferences Time Management Record Keeping and Filing Systems Business Writing Skills Organisational Skills Communication Skills Customer Service Effective Planning and Scheduling Invoicing/Petty Cash Business Environment Course 02: Administrative Receptionist Module 01: Introduction To Reception And Receptionist Module 02: Business Telephone Skills Module 03: Representing Your Boss And Company Module 04: Mail Services And Shipping Module 05: Travel Arrangements Module 06: Organising Meeting And Conferences Module 07: Time Management Module 08: Record Keeping And Filing Systems Module 09: Business Writing Skills Module 10 :Organisational Skills Module 11: Communication Skills Module 12: Customer Service Module 13: Effective Planning And Scheduling Module 14: Invoicing/Petty Cash Module 15: Business Environment Module 16: Advanced MS Excel Course 03: UK Employment Law Module 01: Basic Of Employment Law Module 02: Legal Recruitment Process Module 03: Employment Contracts Module 04: Employee Handbook Module 05: Disciplinary Procedure Module 06: National Minimum Wage & National Living Wage Module 07: Parental Right, Sick Pay & Pension Scheme Module 08: Discrimination In The Workplace Module 09: Health & Safety At Work Module 10: Dismissal, Grievances And Employment Tribunals Module 11: Workplace Monitoring & Data Protection =========>>>>> And 2 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*5 = £65) CPD Hard Copy Certificate: £29.99 CPD 180 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: Newcomers to office administration Career changers Individuals seeking upskilling Requirements You will not need any prior background or expertise to enrol in this bundle. Career path This Receptionist: Office Admin and Reception bundle will allow you to kickstart or take your career to the next stage in the related sector. Office Administrator Receptionist Manager Executive Assistant Customer Service Representative Certificates CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. CPD Accredited Hard Copy Certificate Hard copy certificate - £29.99 Please note that International students have to pay an additional £10 as a shipment fee.

Do you want to be an expert in e-mail management? Do you need to learn Microsoft Outlook? The course will teach you the basics about Microsoft Outlook. Course Description: Microsoft Outlook is a service offered by Microsoft. It is a part of Microsoft Office suite together with Microsoft Word, Microsoft Excel, Microsoft Access and Microsoft Power point. Microsoft Outlook offers free email and calendar services. It also allows you to take notes or set a reminder for your next program. The course will help you to know how to use the program. You will also learn how to customise the Outlook interface and how to use Quick Steps to automate regular actions. By the end of the course, you will be an expert user of Microsoft Outlook. Course Highlights Accredited Microsoft Outlook for Beginners is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Accredited Microsoft Outlook for Beginners into 13 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 11 hours, 40 minutes hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Accredited Microsoft Outlook for Beginners Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Accredited Microsoft Outlook for Beginners is CPD certified and IAO accredited. 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 backgrounds. Requirements Our Accredited Microsoft Outlook for Beginners 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 You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Module One - Getting Started FREE 00:30:00 Module Two - Opening and Closing Outlook FREE 01:00:00 Module Three - Understanding the Interface 01:00:00 Module Four - Working with the Message List and the Reading Pane 01:00:00 Module Five - Using Message List Commands 01:00:00 Module Six - Creating a New Email 01:00:00 Module Seven - Managing Email 01:00:00 Module Eight - Searching for Items 01:00:00 Module Nine - An Introduction to the Calendar 01:00:00 Module Ten - An Introduction to Tasks 01:00:00 Module Eleven - An Introduction to Contact 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities - Accredited Microsoft Outlook for Beginners 00:00:00 Mock Exam Mock Exam- Accredited Microsoft Outlook for Beginners 00:20:00 Final Exam Final Exam- Accredited Microsoft Outlook for Beginners 00:20:00

Microsoft Office Excel is a great tool used to create and format spreadsheets. Spreadsheets allow you to organise information in rows and tables and analyse it with automatic mathematics. Spreadsheets are also very commonly used to perform various types of calculations. Regardless of whether you are completely new to Excel or upgrading from an older version, this Excel 2007 course will empower you with the knowledge and skills necessary to be a proficient user. We have incorporated years of experience, knowledge and teaching techniques to create an easy-to-use course that can be customised to meet your personal learning needs.  Course Highlights Accredited Diploma in Microsoft Excel 2007 is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Accredited Diploma in Microsoft Excel 2007 into 26 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 22 hours, 30 minutes hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Accredited Diploma in Microsoft Excel 2007 Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Accredited Diploma in Microsoft Excel 2007 is CPD certified and IAO accredited. 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 backgrounds. Requirements Our Accredited Diploma in Microsoft Excel 2007 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 You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Microsoft Excel 2007 for Beginners Module One - Getting Started 01:00:00 Module Two - Opening and Closing Excel 01:00:00 Module Three - Your First Worksheet 01:00:00 Module Four - Working with Excel Files 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Printing Excel Data 01:00:00 Module Seven - Building Formulas 01:00:00 Module Eight - Using Excel Functions 01:00:00 Module Nine - Using Time Saving Tools 01:00:00 Module Ten - Formatting your Data 01:00:00 Module Eleven - More Formatting 01:00:00 Module Twelve - Wrapping Up 00:30:00 Microsoft Excel 2007 Advanced Level Module One - Getting Started 00:30:00 Module Two - SmartArt 01:00:00 Module Three - Inserting Objects 01:00:00 Module Four - Creating Charts 01:00:00 Module Five - Creating Pivot Tables 01:00:00 Module Six - Working with Pivot Tables 01:00:00 Module Seven - Creating Pivot Charts 01:00:00 Module Eight - Solving Formula Errors 01:00:00 Module Nine - Using What-If Analysis 01:00:00 Module Ten - Managing Your Data 01:00:00 Module Eleven - Grouping and Outlining Data 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities-Accredited Microsoft Excel 2007 for Beginners 00:00:00 Activities-Microsoft Excel 2007 Advanced Level CPD & IAO Accredited- CPD Accredited 00:00:00 Mock Exam Final Exam

Duration 1 Days 6 CPD hours This course is intended for This course is intended for business users and knowledge workers in a variety of roles and fields who have competence in a desktop-based installation of Microsoft Office, and who are now extending Microsoft 365 to a collaborative cloud-based environment. Overview In this course, you will work productively in the Microsoft 365 cloud-based environment. You will: Navigate Microsoft 365 and integrate the online apps. Use Microsoft Outlook on the Web. Use Microsoft Teams on the web. Store documents in SharePoint, OneDrive, and Teams. Work with files online. This course is an introduction to Microsoft 365 in a cloud-based environment. Using the Microsoft 365 suite of productivity apps online, users can easily communicate and collaborate through Microsoft Teams messaging and meeting functionality and Outlook email. When you create a team, the Microsoft SharePoint team site provides a central storage location for accessing and modifying shared documents. Each user also receives individual document storage through OneDrive for Business. Teams can provide a central hub for working with shared documents in the familiar apps?Word, PowerPoint, and Excel?as an alternative to installing the Microsoft 365 Desktop applications. Getting Started with Microsoft 365 for the Web Topic A:ÿSign In to Microsoft 365 Online Topic B:ÿNavigate the Microsoft 365 Web Environment Topic C:ÿIntegrate the Microsoft 365 Web Apps Using Outlook on the Web Topic A:ÿSend and Receive Email on the Web Topic B:ÿAccess the Outlook Calendar Online Using Teams on the Web Topic A:ÿAccess Teams Features Topic B:ÿCreate and Configure Teams and Channels Topic C:ÿChat and Post in Teams Topic D:ÿCall and Meet in Teams Storing Documents on the Web Topic A:ÿOrganize Documents in SharePoint Topic B:ÿOrganize Documents in OneDrive Topic C:ÿWork with Documents in Teams Topic D:ÿSelect a File Storage Location Working with Files Online Topic A:ÿEdit Documents in Microsoft 365 Online Topic B:ÿCollaborate on Files Online Topic C:ÿFind Shared Resources Online Additional course details: Nexus Humans Microsoft 365 for the Web (with Teams, SharePoint, and OneDrive) v3.0 training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Microsoft 365 for the Web (with Teams, SharePoint, and OneDrive) v3.0 course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 1 Days 6 CPD hours This course is intended for This course is designed for Microsoft© Windows© and Microsoft Office users who are transitioning to a SharePoint environment, and who need to access information from and collaborate with team members within Microsoft SharePoint. Overview Launch a SharePoint site and navigate among the pages and resources provided by the site. Use SharePoint lists to track and view information. Use document libraries to store and organize documents. Find, share, and archive content stored in SharePoint. Author documents as a member of a SharePoint team site. Use SharePoint workflow automation tools. In many professional environments, people work collaboratively in teams. Information technology and applications facilitate this by enabling people to easily share, access, edit, and save information. Microsoft© SharePoint© is a platform specifically designed to facilitate communication and collaboration, enabling people to use familiar applications and web-based tools to create, access, store, and track documents and data in a central location. In this course, you will use SharePoint to access, store, share, and collaborate with information and documents. Prerequisites To ensure your success in this course, you should have basic end-user skills with a current version of Microsoft Windows. Lesson 1: Navigating SharePoint Sites Topic A: Launch SharePoint Topic B: Gain Access to a Site You Didn't Create Topic C: Navigate Within a SharePoint Site Topic D: Access SharePoint from Your Mobile Device Lesson 2: Using Lists to Track Information Topic A: Add and Populate Lists Topic B: Change View Options Topic C: Create a Custom View Lesson 3: Using Document Libraries to Share and Organize Documents Topic A: Store Files in a Document Library Topic B: Create and Use Document Templates Lesson 4: Finding, Sharing, and Archiving Content Topic A: Search for Items in Lists or Libraries Topic B: Share Through Links Topic C: Move Files Offline Lesson 5: Authoring Documents as a Team Topic A: Work Together on Documents Topic B: Manage File Versions and Document Recovery Lesson 6: Automating Business Processes Topic A: Use Rule-Based Automation Topic B: Use Power Automate to Automate a Workflow

Microsoft Word Online Training Course Overview Are you looking to begin your Microsoft word career or want to develop more advanced skills in Microsoft word? Then this Microsoft Word online training course will set you up with a solid foundation to become a confident office admin and help you to develop your expertise in Microsoft word. This Microsoft Word online training course is accredited by the CPD UK & IPHM. CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Whether you are self-taught and you want to fill in the gaps for better efficiency and productivity, this Microsoft Word online training course will set you up with a solid foundation to become a confident office admin and develop more advanced skills. Gain the essential skills and knowledge you need to propel your career forward as a office admin. The Microsoft Word online training course will set you up with the appropriate skills and experience needed for the job and is ideal for both beginners and those currently working as a office admin. This comprehensive Microsoft Word online training course is the perfect way to kickstart your career in the field of Microsoft word. This Microsoft Word online training course will give you a competitive advantage in your career, making you stand out from all other applicants and employees. If you're interested in working as a office admin or want to learn more skills on Microsoft word but unsure of where to start, then this Microsoft Word online training course will set you up with a solid foundation to become a confident office admin and develop more advanced skills. As one of the leading course providers and most renowned e-learning specialists online, we're dedicated to giving you the best educational experience possible. This Microsoft Word online training course is crafted by industry expert, to enable you to learn quickly and efficiently, and at your own pace and convenience. Who is this Microsoft Word online training course for? This comprehensive Microsoft Word online training course is suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of Microsoft word. Entry Requirement There are no academic entry requirements for this Microsoft Word online training course, and it is open to students of all academic backgrounds. As long as you are aged seventeen or over and have a basic grasp of English, numeracy and ICT, you will be eligible to enrol. Assessment Method This Windows Server 2019 - Level 2 Hands-on Training course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner can grasp from each section. In the assessment pass mark is 60%. Course Curriculum Course Overview Course Overview Microsoft Word 2016 Basics Video - Overview of the Microsoft Word 2016 Ribbon Video - Open and Save a New Microsoft Document Video - Save or Covert a word document as a PDF in Word 2016 Video - Edit a PDF Document Using Microsoft Word Video - Making Business Cards With Microsoft Word Video - Create double space lines in Microsoft Word Video - Add or Remove Page Numbers in Microsoft Word Video - Delete Blank Pages in Microsoft Word Video - Create a page break in Microsoft Word Video - Create a Document Using a Microsoft Word Template Video - Inspecting and Protecting Word Documents Video - Encrypting and De-encrypting a Microsoft Word Document Inserting Objects in Microsoft Word Video - Insert a Chart in Microsoft Word Video - Insert Movie or Picture in Microsoft Word Video - Insert an Online image in Microsoft Word Video - Insert a Hyperlink in Microsoft Word Video - Insert/embed an Excel Spreadsheet in Microsoft Word Video - Insert, Resize and Format a Table in Microsoft Word Video - How to Use Bookmarks in Microsoft Word Video - Insert Text Boxes in Microsoft Word Video - Insert a Video or Audio File in Word 2016 Video - Installing Free Fonts for Microsoft Word Microsoft Word for Students Video - Using the APA template in Microsoft Word Video - Adding Grammarly to Your Microsoft Word Program Video - Create an Automatic Table of Contents in Microsoft Word Video - Create a cover page in Microsoft Word Video - Add Recently Viewed Word Documents to Pin List Video - Using Search & Replace in Microsoft Word Video - Add Comments in Microsoft Word Video - Using the New Undo feature in Microsoft Word Video - Set the Default Font in Microsoft Word Video - Using SmartArt for Graphic Design in Microsoft Word Advanced Microsoft Word Features Video - Reshaping Images in Microsoft Word Video - Remove the Background of an Image Using Microsoft Word Video - Perform Calculations in Microsoft Microsoft Word Video - Write Equations in Microsoft Word Video - Using Smart Lookup in Microsoft Word Video - Using Microsoft's Random Text Generator Video - Enable Text to Speech in Microsoft Word Video - Using the Clipboard and Multi-Paste Feature Video - Add page Numbers to an Existing Header or Footer Video - Tips & Tricks for Microsoft Word Mail Merge Video - Create a Directory in M$ Word Using Mail Merge Troubleshooting's Microsoft Word Video - Using the File Open and Repair Feature Video - Repair or Reinstall the Microsoft Word Video - Word Experienced an Error Trying to Open the file Video - Reset Microsoft Office Word to Default Settings Order Your Certificate Now Order Your Certificate Now Get Your Insurance Now Get Your Insurance Now Feedback Feedback

Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course are Application Consultants, Business Analysts, Business Process Owners/Team Leads/Power Users, Data Consultants /Managers, Program/Project Managers, and Solution Architects. Overview Gain hands-on experience in running SAP BusinessObjects BI tools on top of SAP NetWeaver BW data In this course, students are provided with detailed knowledge on the integration for reporting of SAP BusinessObjects BI Platform 4.x with SAP NetWeaver 7.x. Overview of SAP BusinessObjects Business Intelligence(BI) 4.x and SAP NetWeaver Describing SAP BusinessObjects 4.x Semantic Layer in SAP BusinessObjects BI 4.x and Data Connectivity Describing Semantic Layer Technology Creating a Universe with the Information Design Tool SAP BusinessObjects Analysis, Edition for Microsoft Office and SAP NetWeaver BW Creating a Workbook in SAP BusinessObjects Analysis, Edition for Microsoft Office Creating a Workbook with SAP BusinessObjects Analysis, Edition for Microsoft Office and SAP BW SAP BusinessObjects Analysis, Edition for OLAP and SAP NetWeaver BW Creating a Workspace with SAP BusinessObjects Analysis, Edition for OLAP Creating a Workspace in SAP BusinessObjects Analysis, Edition for OLAP Based on a BW Query SAP BusinessObjects Design Studio and SAP NetWeaver BW Creating an Analytical Application in SAP BusinessObjects Design Studio Creating an Analytical Application with Scripting SAP BusinessObjects Dashboards and SAP NetWeaver BW Creating a Dashboard with SAP BusinessObjects Dashboards Creating a Dashboard with BEx Query SAP Crystal Reports and SAP NetWeaver BW Creating a Report with SAP Crystal Reports for Enterprise Creating a Report with SAP Crystal Reports 2013 Creating a Report with SAP Crystal Reports 2013 and SAP NetWeaver BW Differentiating SAP Crystal Reports 2013 and SAP Crystal Reports for Enterprise SAP BusinessObjects Web Intelligence and SAP NetWeaver BW Creating a Web Intelligence Document Creating a Web Intelligence Document for SAP NetWeaver BW SAP BusinessObjects Explorer and SAP NetWeaver BW Creating an SAP BusinessObjects Explorer Information Space Describing Data Connectivity between SAP BusinessObjects Explorer and SAP NetWeaver BW Information Distribution Reporting with Mobile Devices Creating Publications with SAP Crystal Reports and SAP BusinessObjects Web Intelligence Integrating BI Content with SAP NetWeaver Enterprise Portal

Dive into the intricate world of numbers and data with our comprehensive 'Microsoft Excel & Accounting Training' course. Begin your journey by mastering the foundational elements of Microsoft Office Excel 2016, from the basics of worksheet modifications to the art of data visualisation using charts. As you progress, pivot your attention towards the meticulous realm of accounting. Here, you'll unravel the secrets of the accounting equation, immerse yourself in transaction analyses, and culminate your learning by understanding the complete accounting cycle. Whether you're looking to enhance your data management skills or embark on a career in accounting, this course is your stepping stone to success. Learning Outcomes: Acquire proficiency in utilising Microsoft Excel 2016 for data analysis, visualisation, and workbook management. Understand the core principles of accounting, including the accounting equation and transaction analysis. Demonstrate the ability to prepare financial statements and complete the accounting cycle. Implement advanced Excel features such as PivotTables, PivotCharts, and Lookup Functions. Apply knowledge in real-world scenarios, including fiscal year evaluations and spreadsheet exercises. Why buy this Microsoft Excel & Accounting Training? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Microsoft Excel & Accounting Training Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience Who is this Microsoft Excel & Accounting Training course for? Individuals aiming to bolster their data analysis and management capabilities. Aspiring accountants keen on understanding the fundamentals of the profession. Business owners desiring a deeper grasp of financial statements and accounting cycles. Students pursuing a career in finance or data management. Professionals looking to integrate Excel functionalities into their daily tasks. Career path Data Analyst: Average salary range: £25,000 - £40,000 Annually Accountant: Average salary range: £28,000 - £52,000 Annually Financial Controller: Average salary range: £40,000 - £70,000 Annually Management Accountant: Average salary range: £30,000 - £55,000 Annually Excel Specialist: Average salary range: £22,000 - £35,000 Annually Bookkeeper: Average salary range: £18,000 - £30,000 Annually Prerequisites This Microsoft Excel & Accounting Training does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Microsoft Excel & Accounting Training 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum **Microsoft Excel** Getting Started with Microsoft Office Excel 2016 Navigate the Excel User Interfact 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting a Worksheet Apply Text Formats 00:16:00 Apply Number Format 00:07:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:08:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:09:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:06:00 Working with Functions Work with Ranges 00:18:00 Use Specialized Functions 00:11:00 Work with Logical Functions 00:23:00 Work with Date & Time Functions 00:08:00 Work with Text Functions 00:11:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Create and Modify Tables 00:16:00 Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 Working with Multiple Worksheets and Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Sharing and Protecting Workbooks Collaborate on a Workbook 00:19:00 Protect Worksheets and Workbooks 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 **Accounting Training** Professional Bookkeeper Introduction Professional Bookkeeper 00:09:00 Introduction to Accounting and Business Defining a Business 00:07:00 Ethics in Accounting 00:05:00 Generally Accepted Accounting Principles (GAAP) 00:10:00 The Accounting Equation The Accounting Equation 00:07:00 Transactions 00:11:00 Financial Statements 00:13:00 Analyzing Transactions The Accounting Equation and Transactions 00:16:00 Double-Entry System 00:11:00 Transactions - Journalizing 00:17:00 Journal Entries 00:38:00 Entering Information - Posting Entries Posting Entries 00:10:00 The Trial Balance 00:10:00 Finding Errors Using Horizontal Analysis 00:09:00 Horizontal Trend : Balance Sheet 00:21:00 Horizontal Trend: Income Statement 00:36:00 Adjusting Process The Purpose of the Adjusting Process 00:15:00 Adjusting Entries Adjusting Entries - Prepaid Expenses 00:13:00 Adjusting Entries - Accrued Revenues 00:10:00 Adjusting Entries - Depreciation Expense 00:09:00 Adjustment Summary Adjustment Summary - Review 00:13:00 Vertical Analysis 00:33:00 Preparing a Worksheet Preparing a Worksheet 00:06:00 Financial Statements The Income Statement 00:11:00 Financial Statements - Definitions 00:12:00 Completing the Accounting Cycle Temporary vs. Permanent Account 00:19:00 The Accounting Cycle Illustrated Accounting Cycle Illustrated - Steps 1-5 00:11:00 Accounting Cycle Illustrated - Steps 6-10 00:12:00 Fiscal Year Fiscal Year 00:09:00 Spreadsheet Exercise Spreadsheet Exercise - Steps 1-4 00:11:00 Spreadsheet Exercise - Steps 5-7 00:37:00

Looking for an easy to use and functional spreadsheet application. Look no further as this course will get you started on becoming a professional on the most important spreadsheet application, Microsoft Excel 2007. Microsoft Excel 2007 is part of the Microsoft Office suite of programs which is the most widely used software package on Earth. Excel 2007 is a great tool for simple or complex calculations, particularly ones which you want to repeat. You can use this software to visualize data as well. You can use this useful tool to deal with large quantities of data, for quick data manipulation, for checklists and status reporting. Use pivot tables to aggregate and filter data. During this course, you will learn all the functions of Microsoft Excel 2007 and will make you a professional at representing your data. At the end of the course you will be able learn all there is to know about Microsoft Excel and be fully capable of presenting data or solving any problems regarding Microsoft Excel. Course Highlights Certified Microsoft Excel 2007 Complete Course - Beginner to Advanced is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Certified Microsoft Excel 2007 Complete Course - Beginner to Advanced into 26 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 22 hours, 30 minutes hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Certified Microsoft Excel 2007 Complete Course - Beginner to Advanced Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Certified Microsoft Excel 2007 Complete Course - Beginner to Advanced is CPD certified and IAO accredited. 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 backgrounds. Requirements Our Certified Microsoft Excel 2007 Complete Course - Beginner to Advanced 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 You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Microsoft Excel 2007 for Beginners Module One - Getting Started 01:00:00 Module Two - Opening and Closing Excel 01:00:00 Module Three - Your First Worksheet 01:00:00 Module Four - Working with Excel Files 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Printing Excel Data 01:00:00 Module Seven - Building Formulas 01:00:00 Module Eight - Using Excel Functions 01:00:00 Module Nine - Using Time Saving Tools 01:00:00 Module Ten - Formatting your Data 01:00:00 Module Eleven - More Formatting 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Accredited Microsoft Excel 2007 for Beginners 00:00:00 Microsoft Excel 2007 Advanced Level Module One - Getting Started 00:30:00 Module Two - SmartArt 01:00:00 Module Three - Inserting Objects 01:00:00 Module Four - Creating Charts 01:00:00 Module Five - Creating Pivot Tables 01:00:00 Module Six - Working with Pivot Tables 01:00:00 Module Seven - Creating Pivot Charts 01:00:00 Module Eight - Solving Formula Errors 01:00:00 Module Nine - Using What-If Analysis 01:00:00 Module Ten - Managing Your Data 01:00:00 Module Eleven - Grouping and Outlining Data 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Excel 2007 Advanced Level CPD & IAO Accredited- CPD Accredited 00:00:00 Mock Exam Final Exam

***Don't Spend More; Spend Smart*** Life Just Got Better This Summer! Get Hard Copy + PDF Certificates + Transcript + Student ID Card + e-Learning App 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 13-in-1 extensive bundle that has everything you need to succeed in Work from Home Essentials and other relevant fields! After surveying thousands of learners just like you and considering their valuable feedback, this all-in-one Work from Home Essentials bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Work from Home Essentials course that will enhance your skills and prepare you for the competitive job market. Also, our Work from Home Essentials experts are available for answering your queries and help you along your learning journey. Advanced audio-visual 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 Work from Home Essentials, 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 Work from Home Essentials Bundle Consists of the following Premium courses: Course 01: Working from Home Essentials Course 02: Online Course - A Perfect Guide to Home Business Course 03: Online Meeting Management Course 04: Using Zoom Meeting Effectively Course 05: ZOOM: Master Video Conferencing in Just 40 minutes! Course 06: Business Writing Course 07: Document Control Course 08: Level 2 Microsoft Office Essentials Course 09: Touch Typing Essentials Course 10: Effective Communication Skills Diploma Course 11: Stress Management Training Course 12: Functional Skills IT Course 13: Time Management Course 14: Freelancing on UpWork Benefits you'll get choosing Apex Learning: Pay once and get lifetime access to 13 CPD courses Free e-Learning App for engaging reading materials & helpful assistance Certificates, student ID for the title course included in a one-time fee Free up your time - don't waste time and money travelling for classes Accessible, informative modules designed by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills How will I get my Certificate? After successfully completing the course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (For The Title Course) Hard Copy Certificate: Free (For The Title Course) Curriculum: Course 01: Working from Home Essentials Module 1: Introduction to Work from Home Module 2: Online Meeting Tools Module 3: Project Management Tools Module 4: Project Planning Tools Module 5: Communication Tools Course 02: Online Course - A Perfect Guide to Home Business Module 01: Introduction to Business Module 02: Understanding Entrepreneurship Module 03: What Is a Home-Based Business? Module 04: Introduction to Online Business Module 05: Introduction to Digital Marketing Module 06: E-Commerce Business Model: Dropshipping Module 07: E-Commerce Business Model: Affiliate Marketing Module 08: Opportunities for Home-Based Income Module 09: At-Home Professional Service Provider Business Module 10: Introduction to Freelancing Course 03: Online Meeting Management Module 01: Planning and Preparation Module 02: Online Meeting Platforms Module 03: Meeting Etiquette and Tips Course 04: Using Zoom Meeting Effectively Module 01: Introduction Module 02: What is Zoom Meeting? Module 03: Why Use Zoom? Module 04: Tighter Security Module 05: Create Zoom Account Module 06: Navigating Zoom as a Participant Module 07: Scheduling a Meeting Module 08: Navigating Zoom as the Host Module 09: Live on Zoom as a Participant Module 10: Live on Zoom as a Host Module 11: Zoom Webinar Introduction Module 12: Closing Remarks Course 05: ZOOM: Master Video Conferencing in Just 40 minutes! Intro Zoom Intro and signing up Hosting Your First Zoom Meeting Inviting Participants Manage Participants Sharing Screens and Whiteboards More Screen Share Options Chat, Recording and Reactions TIPS 01- Virtual Backgrounds TIPS 02 - Custom Virtual Background TIPS 03 - Video Settings TIPS 04 - Calendar Zoom Extension TIPS 05 - Hiding Floating Menu TIPS 06 - Mute All Shortcut TIPS 07 - New Share TIPS 08 - Pause Share TIPS 09 - Annotate Course 06: Business Writing Words to Cut Building Strong Sentences SCQA How to Write Punchy Summaries Words that Work, Feedback that Improves Proof Reading Makes Perfect Course 07: Document Control Module 1: Introduction to Document Control Module 2: Principles of Document Control and Elements of Document Control Environment Module 3: Document Control Lifecycle Module 4: Document Control Strategies and Instruments Module 5: Document Management Module 6: Quality Assurance and Controlling Quality of Documents Module 7: Project Document Control Module 8: Electronic Document Management Systems and Soft Copy Documentation Course 08: Level 2 Microsoft Office Essentials Excel 2016 Getting Started with Microsoft Office Excel 2016 Performing Calculations Modifying a Worksheet Formatting a Worksheet Printing Workbooks Managing Workbooks Word 2016 Getting Started with Word Formatting Text and Paragraphs Working More Efficiently Managing Lists Adding Tables Inserting Graphic Objects Controlling Page Appearance Preparing to Publish a Document Workbooks - Microsoft Word 2016 (Beginner) PowerPoint 2016 PowerPoint Interface Presentation Basics Formatting Inserting Options Working with Objects Table Charts Review and Presentatin Access 2016 Introduction to Access Modify Data Working with Queries Access Forms Working with Reports Course 09: Touch Typing Essentials Course 10: Effective Communication Skills Diploma Course 11: Stress Management Training Course 12: Functional Skills IT Course 13: Time Management Course 14: Freelancing on UpWork CPD 145 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Work from Home Essentials 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 Work from Home Essentials 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