45 Courses

OVERVIEW The Ultimate Microsoft Office 4 Courses Bundle Course will provide you with everything you need to master the skills for confidently using Microsoft Office in the workplace. You will develop the essential knowledge and abilities employers expect in Word, Excel, PowerPoint and Access. This is a unique bundle course that will teach you the essential shortcuts and time-saving tools, including how to modify the programs according to your needs. You will also be tutored in a wide range of topics in an extremely expert manner that will make your life easier, no matter what your work requires. After the completion of this online Microsoft Office training program, you will receive a valid acknowledgement in Microsoft Office, and be able to accomplish office tasks quickly, with greater efficiency. WHY CHOOSE THIS COURSE * Earn an e-certificate upon successful completion. * Accessible, informative modules taught by expert instructors * Study in your own time, at your own pace, through your computer tablet or mobile device * Benefit from instant feedback through mock exams and multiple-choice assessments * Get 24/7 help or advice from our email and live chat teams * Full Tutor Support on Weekdays COURSE DESIGN The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of * Online study materials * Mock exams * Multiple-choice assessment CERTIFICATE OF ACHIEVEMENT Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £119. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. ENDORSEMENT This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment In order to ensure the Quality Licensing scheme endorsed and CPD acknowledged certificate, learners need to score at least 60% pass marks on the assessment process. After submitting assignments, our expert tutors will evaluate the assignments and give feedback based on the performance. After passing the assessment, one can apply for a certificate. Requirements There is no specific requirements for our Ultimate Microsoft Office 4 Courses Bundle course. It is compatible and accessible from any device including Windows, Mac, Android, iOS, Tablets etc. The course requires a moderate Internet connection so it is possible to start learning with any type of Internet from anywhere at anytime without any limitations.  COURSE CONTENT Microsoft Excel 2019 Microsoft Excel 2019 New Features Introduction to Microsoft Excel 2019 New Features 00:07:00 CONCAT 00:02:00 IFS 00:01:00 MAXIFS 00:01:00 MINIFS 00:01:00 SWITCH 00:02:00 TEXTJOIN 00:01:00 Map Chart 00:02:00 Funnel Chart 00:01:00 Better Visuals 00:06:00 Pivot Table Enhancements 00:02:00 Power Pivot Updates 00:01:00 Getting Started with Microsoft Excel Navigate the Excel User Interface 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting a Worksheet Apply Text Formats 00:17:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:07:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:08:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:05:00 Microsoft Word 2019 Microsoft Word 2019 New Features Introduction to Microsoft Word 2019 New Features 00:14:00 Inking Tools 00:03:00 Inking Tools 1 00:07:00 Learning Tools 00:07:00 Microsoft Translate 00:03:00 LaTeX 00:05:00 Smart Lookup 00:04:00 Side to Side Scrolling 00:02:00 Scalable Vector Graphics 00:03:00 Getting Started with Word Navigate in Microsoft Word 00:12:00 Create and Save Word Documents 00:24:00 Manage Your Workspace 00:06:00 Edit Documents 00:16:00 Preview and Print Documents 00:04:00 Customize the Word Environment 00:08:00 Formatting Text and Paragraphs Apply Character Formatting 00:17:00 Control Paragraph Layout 00:19:00 Align Text Using Tabs 00:07:00 Display Text in Bulleted or Numbered Lists 00:03:00 Apply Borders and Shading 00:04:00 Working More Efficiently Make Repetitive Edits 00:06:00 Apply Repetitive Formatting 00:10:00 Use Styles to Streamline Repetitive Formatting Tasks 00:14:00 Managing Lists Sort a List 00:05:00 Format a List 00:06:00 Adding Tables Insert a Table 00:07:00 Modify a Table 00:06:00 Format a Table 00:03:00 Convert Text to a Table 00:04:00 Inserting Graphic Objects Insert Symbols and Special Characters 00:04:00 Add Images to a Document 00:11:00 Controlling Page Appearance Apply a Page Border and Color 00:03:00 Add Headers and Footers 00:06:00 Control Page Layout 00:05:00 Add a Watermark 00:04:00 Preparing to Publish a Document Check Spelling Grammar and Readability 00:07:00 Use Research Tools 00:06:00 Check Accessibility 00:03:00 Save a Document to Other Formats 00:04:00 Workbooks - Microsoft Word 2016 (Beginner) Workbooks - Microsoft Word 2019 00:00:00 Microsoft PowerPoint 2019 Microsoft PowerPoint 2019 New Features Introduction to Microsoft PowerPoint 2019 New Features 00:06:00 Highlighting 00:02:00 Morph Transition 00:03:00 Zoom 00:03:00 Vector Graphics 00:03:00 SVG Icons to Shapes 00:04:00 3D Modeling 00:04:00 Background Removal 00:03:00 4K 00:03:00 PowerPoint Interface Navigate the PowerPoint Environment 00:28:00 View and Navigate a Presentation 00:15:00 Create and Save a PowerPoint Presentation 00:13:00 Use PowerPoint Help 00:10:00 Presentation Basics Select a Presentation Type 00:08:00 Edit Text 00:13:00 Build a Presentation 00:27:00 Formatting Format Characters 00:11:00 Format Paragraphs 00:16:00 Format Text Boxes 00:09:00 Inserting Options Insert Images 00:10:00 Insert Shapes 00:15:00 Working with Objects Edit Objects 00:16:00 Format Objects 00:06:00 Group Objects 00:04:00 Arrange Objects 00:07:00 Animate Objects 00:07:00 Table Create a Table 00:09:00 Format a Table 00:03:00 Insert a Table from Other Microsoft Office Applications 00:06:00 Charts Create a Chart 00:10:00 Format a Chart 00:10:00 Insert a Chart from Microsoft Excel 00:05:00 Review and Presentatin Review Your Presentation 00:11:00 Apply Transitions 00:05:00 Print Your Presentation 00:05:00 Deliver Your Presentation 00:08:00 Microsoft Access 2019 Microsoft Access 2019 New Features Introduction to Microsoft Access 2019 New Features 00:05:00 Window Resize 00:01:00 Charts 00:02:00 dbf 00:01:00 Large Number 00:01:00 Property Sorting 00:01:00 Introduction to Access Orientation to Microsoft Access 00:39:00 Create a Simple Access Database 00:10:00 Get Help and Configure Options in Microsoft Access 00:06:00 Modify Data Modify Table Data 00:17:00 Sort and Filter Records 00:05:00 Working with Queries Create Basic Queries 00:15:00 Sort and Filter Data in a Query 00:14:00 Perform Calculations in a Query 00:08:00 Access Forms Create Basic Access Forms 00:07:00 Work with Data on Access Forms 00:23:00 Working with Reports Create a Report 00:23:00 Add Controls to a Report 00:12:00 Enhance the Appearance of a Report 00:05:00 Prepare a Report for Print 00:03:00 Organize Report Information 00:15:00 Format Reports 00:12:00 Assignment Assignment - Ultimate Microsoft Office 4 Courses Bundle 3 weeks, 3 days Order Your Certificate Order your Certificate QLS 00:00:00

OVERVIEW Did you know that Microsoft Office proficiency is a highly sought-after skill in the UK job market? Our comprehensive Microsoft Office Specialist (MOS) course equips you with essential knowledge in Excel, Word, PowerPoint, and Access, covering Microsoft 2019 versions along with Excel 2016 basics. Dive into the world of spreadsheets with Excel, craft professional documents with Word, create engaging presentations with PowerPoint, and harness the power of databases with Access. Whether you're a beginner or seeking to upgrade your skills, this theoretical course ensures you're well-prepared to navigate the digital landscape, boost your employability, and enhance your productivity. DESCRIPTION Our Microsoft Office Specialist (MOS) course is a comprehensive exploration of Microsoft's most popular applications: Excel, Word, PowerPoint, and Access. With a focus on Microsoft 2019, this course also covers Excel 2016 basics to ensure you have a well-rounded understanding. You'll start by learning the fundamentals, from creating spreadsheets and documents to designing presentations and managing databases. Each module delves into specific features and functions, such as calculations in Excel, formatting in Word, and data manipulation in Access. With a theoretical approach, this course provides a solid foundation for anyone looking to excel in today's digital workplace. Dive into the world of spreadsheets with Excel, craft professional documents with Word, create engaging presentations with PowerPoint, and harness the power of databases with Access. Whether you're a beginner or seeking to upgrade your skills, this theoretical course ensures you're well-prepared to navigate the digital landscape, boost your employability, and enhance your productivity. WHY CHOOSE US? * This course is accredited by the CPD Quality Standards. * Lifetime access to the whole collection of the learning materials. * Online test with immediate results. * Enroling in the course has no additional cost. * You can study and complete the course at your own pace. * Study for the course using any internet-connected device, such as a computer, tablet, or mobile device. CERTIFICATE OF ACHIEVEMENT Upon successful completion, you will qualify for the UK and internationally-recognised CPD certificate and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £4.99 and Hardcopy Certificate for £9.99. WHO IS THIS COURSE FOR? * Individuals seeking to enhance their Microsoft Office skills. * Job seekers aiming to boost their employability in various industries. * Students preparing for MOS certification exams. * Professionals looking to improve their proficiency in Excel, Word, PowerPoint, and Access. * Anyone who wants to increase their productivity in office tasks. * Beginners interested in learning the basics of Microsoft Office applications. REQUIREMENTS The Microsoft Office Specialist (MOS) course requires no prior degree or experience. All you require is English proficiency, numeracy literacy and a gadget with stable internet connection. Learn and train for a prosperous career in the thriving and fast-growing industry of Microsoft Office (MOS), without any fuss. CAREER PATH * Administrative Assistant * Data Entry Clerk * Office Manager * Business Analyst * Database Administrator * Project Manager * IT Support Specialist ORDER YOUR CERTIFICATE To order CPD Quality Standard Certificate, we kindly invite you to visit the following link: COURSE CURRICULUM Microsoft Excel 2019 Microsoft Excel 2019 New Features Introduction to Microsoft Excel 2019 New Features 00:07:00 CONCAT 00:02:00 IFS 00:01:00 MAXIFS 00:01:00 MINIFS 00:01:00 SWITCH 00:02:00 TEXTJOIN 00:01:00 Map Chart 00:02:00 Funnel Chart 00:01:00 Better Visuals 00:06:00 Pivot Table Enhancements 00:02:00 Power Pivot Updates 00:01:00 Getting Started with Microsoft Excel Navigate the Excel User Interface 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting a Worksheet Apply Text Formats 00: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 Microsoft Word 2019 Microsoft Word 2019 New Features Introduction to Microsoft Word 2019 New Features 00:14:00 Inking Tools 00:03:00 Inking Tools 1 00:07:00 Learning Tools 00:07:00 Microsoft Translate 00:03:00 LaTeX 00:05:00 Smart Lookup 00:04:00 Side to Side Scrolling 00:02:00 Scalable Vector Graphics 00:03:00 Getting Started with Word Navigate in Microsoft Word 00:12:00 Create and Save Word Documents 00:24:00 Manage Your Workspace 00:06:00 Edit Documents 00:16:00 Preview and Print Documents 00:04:00 Customize the Word Environment 00:08:00 Formatting Text and Paragraphs Apply Character Formatting 00:17:00 Control Paragraph Layout 00:19:00 Align Text Using Tabs 00:07:00 Display Text in Bulleted or Numbered Lists 00:03:00 Apply Borders and Shading 00:04:00 Working More Efficiently Make Repetitive Edits 00:06:00 Apply Repetitive Formatting 00:10:00 Use Styles to Streamline Repetitive Formatting Tasks 00:14:00 Managing Lists Sort a List 00:05:00 Format a List 00:06:00 Adding Tables Inserting a Table 00:06:00 Modify a Table 00:06:00 Format a Table 00:03:00 Convert Text to a Table 00:04:00 Inserting Graphic Objects Insert Symbols and Special Characters 00:04:00 Add Images to a Document 00:11:00 Controlling Page Appearance Apply a Page Border and Color 00:03:00 Add Headers and Footers 00:06:00 Control Page Layout 00:05:00 Add a Watermark 00:04:00 Preparing to Publish a Document Check Spelling Grammar and Readability 00:07:00 Use Proofing and Research Tools 00:07:00 Check Accessibility 00:03:00 Save a Document to Other Formats 00:04:00 Workbooks - Microsoft Word 2016 (Beginner) Workbooks - Microsoft Word 2016 (Beginner) 00:00:00 Microsoft PowerPoint 2019 Microsoft PowerPoint 2019 New Features Introduction to Microsoft PowerPoint 2019 New Features 00:06:00 Highlighting 00:02:00 Morph Transition 00:03:00 Zoom 00:03:00 Vector Graphics 00:03:00 SVG Icons to Shapes 00:04:00 3D Modeling 00:04:00 Background Removal 00:03:00 4K 00:03:00 PowerPoint Interface Navigate the PowerPoint Environment 00:28:00 View and Navigate a Presentation 00:15:00 Create and Save a PowerPoint Presentation 00:13:00 Use PowerPoint Help 00:10:00 Presentation Basics Select a Presentation Type 00:08:00 Edit Text 00:13:00 Build a Presentation 00:27:00 Formatting Format Characters 00:11:00 Format Paragraphs 00:16:00 Format Text Boxes 00:09:00 Inserting Options Insert Images 00:10:00 Insert Shapes 00:15:00 Working with Objects Edit Objects 00:16:00 Format Objects 00:06:00 Group Objects 00:04:00 Arrange Objects 00:07:00 Animate Objects 00:07:00 Table Create a Table 00:09:00 Format a Table 00:03:00 Insert a Table from Other Microsoft Office Applications 00:06:00 Charts Create a Chart 00:10:00 Format a Chart 00:10:00 Insert a Chart from Microsoft Excel 00:05:00 Review and Presentation Review Your Presentation 00:11:00 Apply Transitions 00:05:00 Print Your Presentation 00:05:00 Deliver Your Presentation 00:08:00 Microsoft Access 2019 Microsoft Access 2019 New Features Introduction to Microsoft Access 2019 New Features 00:05:00 Window Resize 00:01:00 Charts 00:02:00 dbf 00:01:00 Large Number 00:01:00 Property Sorting 00:01:00 Introduction to Access Orientation to Microsoft Access 00:39:00 Create a Simple Access Database 00:10:00 Get Help and Configure Options in Microsoft Access 00:06:00 Modify Data Modify Table Data 00:17:00 Sort and Filter Records 00:05:00 Working with Queries Create Basic Queries 00:15:00 Sort and Filter Data in a Query 00:14:00 Perform Calculations in a Query 00:08:00 Access Forms Create Basic Access Forms 00:07:00 Work with Data on Access Forms 00:23:00 Working with Reports Create a Report 00:28:00 Add Controls to a Report 00:12:00 Enhance the Appearance of a Report 00:05:00 Prepare a Report for Print 00:03:00 Organize Report Information 00:15:00 Format Reports 00:12:00 Assignment Assignment - Microsoft Office Bundle 00:00:00 Order Your Certificate Order Your Certificate 00:00:00

OVERVIEW By enroling in Microsoft Office Bundle 2019, you can kickstart your vibrant career and strengthen your profound knowledge. You can learn everything you need to know about the topic. The Microsoft Office Bundle 2019 course includes all of the most recent information to keep you abreast of the employment market and prepare you for your future. The curriculum for this excellent Microsoft Office Bundle 2019 course includes modules at all skill levels, from beginner to expert. You will have the productivity necessary to succeed in your organisation once you have completed our Microsoft Office Bundle 2019 Program. So enrol in our Microsoft Office Bundle 2019 course right away if you're keen to envision yourself in a rewarding career. DESCRIPTION Enroling in this Microsoft Office Bundle 2019 course can improve your Microsoft Office Bundle 2019 perspective, regardless of your skill levels in the Microsoft Office Bundle 2019 topics you want to master. If you're already a Microsoft Office Bundle 2019 expert, this peek under the hood will provide you with suggestions for accelerating your learning, including advanced Microsoft Office Bundle 2019 insights that will help you make the most of your time. This Microsoft Office Bundle 2019 course will act as a guide for you if you've ever wished to excel at Microsoft Office Bundle 2019. WHY CHOOSE US? * This course is accredited by the CPD Quality Standards. * Lifetime access to the whole collection of the learning materials. * Online test with immediate results. * Enroling in the course has no additional cost. * You can study and complete the course at your own pace. * Study for the course using any internet-connected device, such as a computer, tablet, or mobile device. WILL I RECEIVE A CERTIFICATE OF COMPLETION? Upon successful completion, you will qualify for the UK and internationally-recognised CPD certificate and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £4.99 and Hardcopy Certificate for £9.99. WHO IS THIS COURSE FOR? This Microsoft Office Bundle 2019 course is a great place to start if you're looking to start a new career in Microsoft Office Bundle 2019 field. This training is for anyone interested in gaining in-demand Microsoft Office Bundle 2019 proficiency to help launch a career or their business aptitude.  REQUIREMENTS The Microsoft Office Bundle 2019 course requires no prior degree or experience. All you require is English proficiency, numeracy literacy and a gadget with stable internet connection. Learn and train for a prosperous career in the thriving and fast-growing industry of Microsoft Office Bundle 2019, without any fuss. CAREER PATH This Microsoft Office Bundle 2019 training will assist you develop your Microsoft Office Bundle 2019 ability, establish a personal brand, and present a portfolio of relevant talents. It will help you articulate a  Microsoft Office Bundle 2019 professional story and personalise your path to a new career. Furthermore, developing this Microsoft Office Bundle 2019 skillset can lead to numerous opportunities for high-paying jobs in a variety of fields. ORDER YOUR CERTIFICATE To order CPD Quality Standard Certificate, we kindly invite you to visit the following link: COURSE CURRICULUM Microsoft Excel 2019 Microsoft Excel 2019 New Features Introduction to Microsoft Excel 2019 New Features 00:07:00 CONCAT 00:02:00 IFS 00:01:00 MAXIFS 00:01:00 MINIFS 00:01:00 SWITCH 00:02:00 TEXTJOIN 00:01:00 Map Chart 00:02:00 Funnel Chart 00:01:00 Better Visuals 00:06:00 Pivot Table Enhancements 00:02:00 Power Pivot Updates 00:01:00 Getting Started with Microsoft Excel Navigate the Excel User Interface 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting a Worksheet Apply Text Formats 00: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 Microsoft Word 2019 Microsoft Word 2019 New Features Introduction to Microsoft Word 2019 New Features 00:14:00 Inking Tools 00:03:00 Inking Tools 1 00:07:00 Learning Tools 00:07:00 Microsoft Translate 00:03:00 LaTeX 00:05:00 Smart Lookup 00:04:00 Side to Side Scrolling 00:02:00 Scalable Vector Graphics 00:03:00 Getting Started with Word Navigate in Microsoft Word 00:12:00 Create and Save Word Documents 00:24:00 Manage Your Workspace 00:06:00 Edit Documents 00:16:00 Preview and Print Documents 00:04:00 Customize the Word Environment 00:08:00 Formatting Text and Paragraphs Apply Character Formatting 00:17:00 Control Paragraph Layout 00:19:00 Align Text Using Tabs 00:07:00 Display Text in Bulleted or Numbered Lists 00:03:00 Apply Borders and Shading 00:04:00 Working More Efficiently Make Repetitive Edits 00:06:00 Apply Repetitive Formatting 00:10:00 Use Styles to Streamline Repetitive Formatting Tasks 00:14:00 Managing Lists Sort a List 00:05:00 Format a List 00:06:00 Adding Tables Inserting a Table 00:06:00 Modify a Table 00:06:00 Format a Table 00:03:00 Convert Text to a Table 00:04:00 Inserting Graphic Objects Insert Symbols and Special Characters 00:04:00 Add Images to a Document 00:11:00 Controlling Page Appearance Apply a Page Border and Color 00:03:00 Add Headers and Footers 00:06:00 Control Page Layout 00:05:00 Add a Watermark 00:04:00 Preparing to Publish a Document Check Spelling Grammar and Readability 00:07:00 Use Proofing and Research Tools 00:07:00 Check Accessibility 00:03:00 Save a Document to Other Formats 00:04:00 Workbooks - Microsoft Word 2016 (Beginner) Workbooks - Microsoft Word 2016 (Beginner) 00:00:00 Microsoft PowerPoint 2019 Microsoft PowerPoint 2019 New Features Introduction to Microsoft PowerPoint 2019 New Features 00:06:00 Highlighting 00:02:00 Morph Transition 00:03:00 Zoom 00:03:00 Vector Graphics 00:03:00 SVG Icons to Shapes 00:04:00 3D Modeling 00:04:00 Background Removal 00:03:00 4K 00:03:00 PowerPoint Interface Navigate the PowerPoint Environment 00:28:00 View and Navigate a Presentation 00:15:00 Create and Save a PowerPoint Presentation 00:13:00 Use PowerPoint Help 00:10:00 Presentation Basics Select a Presentation Type 00:08:00 Edit Text 00:13:00 Build a Presentation 00:27:00 Formatting Format Characters 00:11:00 Format Paragraphs 00:16:00 Format Text Boxes 00:09:00 Inserting Options Insert Images 00:10:00 Insert Shapes 00:15:00 Working with Objects Edit Objects 00:16:00 Format Objects 00:06:00 Group Objects 00:04:00 Arrange Objects 00:07:00 Animate Objects 00:07:00 Table Create a Table 00:09:00 Format a Table 00:03:00 Insert a Table from Other Microsoft Office Applications 00:06:00 Charts Create a Chart 00:10:00 Format a Chart 00:10:00 Insert a Chart from Microsoft Excel 00:05:00 Review and Presentation Review Your Presentation 00:11:00 Apply Transitions 00:05:00 Print Your Presentation 00:05:00 Deliver Your Presentation 00:08:00 Microsoft Access 2019 Microsoft Access 2019 New Features Introduction to Microsoft Access 2019 New Features 00:05:00 Window Resize 00:01:00 Charts 00:02:00 dbf 00:01:00 Large Number 00:01:00 Property Sorting 00:01:00 Introduction to Access Orientation to Microsoft Access 00:39:00 Create a Simple Access Database 00:10:00 Get Help and Configure Options in Microsoft Access 00:06:00 Modify Data Modify Table Data 00:17:00 Sort and Filter Records 00:05:00 Working with Queries Create Basic Queries 00:15:00 Sort and Filter Data in a Query 00:14:00 Perform Calculations in a Query 00:08:00 Access Forms Create Basic Access Forms 00:07:00 Work with Data on Access Forms 00:23:00 Working with Reports Create a Report 00:28:00 Add Controls to a Report 00:12:00 Enhance the Appearance of a Report 00:05:00 Prepare a Report for Print 00:03:00 Organize Report Information 00:15:00 Format Reports 00:12:00 Assignment Assignment - Microsoft Office Bundle 00:00:00 Order Your Certificate Order Your Certificate 00:00:00

OVERVIEW Are you aware that proficiency in Microsoft Office is now considered a critical skill across all job sectors? With recent reports highlighting a dramatic increase in demand for digital literacy, the 'Microsoft Office Basic to Advance' course offers a comprehensive pathway to mastering these essential tools.  In today's digital world, proficiency in Microsoft Office is no longer a bonus; it's a critical skill for success in almost any job sector. With Microsoft Office skills listed in over 80% of middle-skill job postings, this course is designed to propel your career forward. It opens opportunities by equipping you with a deep, practical understanding of Microsoft Office applications-from basic to advanced levels. Whether aiming to boost your resume or streamline office tasks, this course will position you at the forefront of workplace efficiency, inspiring you to reach new heights in your career. Enrolling in the Microsoft Office Basic to Advance Course significantly enhances your employability and professional capabilities. This will prepare you to meet the challenges of today's job market head-on. This investment in your skill set is an investment in your future, setting you up for long-term success and career satisfaction. DESCRIPTION 'Microsoft Office Basic to Advance' course that spans comprehensive training in the most widely used Microsoft Office applications. Beginning with Excel, you will learn to perform basic calculations and engage in complex data management tasks like modifying and formatting worksheets and managing and printing workbooks. As you progress, the course delves into Word, where you will enhance your ability to format text and paragraphs, manage lists, add tables, and insert graphic objects, ensuring you are well-prepared to control page appearances and publish documents. Further, the PowerPoint modules equip you with the skills to handle the PowerPoint interface proficiently, manage presentation basics, insert various objects, and use charts effectively. For those interested in database management, the Access sessions provide insights into modifying data, working with queries, and creating forms and reports. Microsoft Office Basic to Advance Course ensures that each module builds on the last, providing a cohesive learning experience that develops your confidence and competence in using these tools to their full potential. LEARNING OUTCOMES: * By the end of this course, you will be able to master the foundational and advanced functionalities of Microsoft Excel 2019, including creating complex formulas, analysing data, and creating visually appealing charts and graphs. * Develop skills in professional document preparation with Microsoft Word 2019. * Create impactful presentations using the advanced features of Microsoft PowerPoint 2019. * Navigate and utilise Microsoft Access 2019 for database management. * Implement complex formatting, calculations, and data management across various projects. * Prepare and manage professional, publication-ready documents and reports. Are you ready for a more rewarding career? The 'Microsoft Office Basic to Advanced' course can help you answer that call! Take advantage of this opportunity to enhance your skills and open new doors in your career. WHY CHOOSE US? * This course is accredited by the CPD Quality Standards. * Lifetime access to the whole collection of the learning materials. * Online test with immediate results. * Enroling in the course has no additional cost. * You can study and complete the course at your own pace. * Study for the course using any internet-connected device, such as a computer, tablet, or mobile device. CERTIFICATE OF ACHIEVEMENT Upon successful completion, you will qualify for the UK and internationally-recognised CPD certificate and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £4.99 and Hardcopy Certificate for £9.99. WHO IS THIS COURSE FOR? * Office professionals are seeking to enhance their productivity and software knowledge. * Students and recent graduates aim to meet the baseline technical requirements for most job roles. * Administrative staff need to improve their reporting and data management skills. * Individuals are looking to develop their job qualifications and career prospects. * Educators and trainers who wish to instruct on using Microsoft Office tools. * Entrepreneurs need efficient ways to manage their business documentation and presentations. REQUIREMENTS The Microsoft Office Basic to Advance course requires no prior degree or experience. All you require is English proficiency, numeracy literacy and a gadget with stable internet connection. Learn and train for a prosperous career in the thriving and fast-growing industry of Microsoft Office Basic to Advance, without any fuss. CAREER PATH Microsoft Office Basic to Advance course will prepare you for a range of careers, including: * Administrative Assistant * Executive Assistant * Project Coordinator * Office Manager * Business Analyst * Marketing Coordinator * Data Analyst ORDER YOUR CERTIFICATE To order CPD Quality Standard Certificate, we kindly invite you to visit the following link: COURSE CURRICULUM Microsoft Excel 2019 Microsoft Excel 2019 New Features Introduction to Microsoft Excel 2019 New Features 00:07:00 CONCAT 00:02:00 IFS 00:01:00 MAXIFS 00:01:00 MINIFS 00:01:00 SWITCH 00:02:00 TEXTJOIN 00:01:00 Map Chart 00:02:00 Funnel Chart 00:01:00 Better Visuals 00:06:00 Pivot Table Enhancements 00:02:00 Power Pivot Updates 00:01:00 Getting Started with Microsoft Excel Navigate the Excel User Interface 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting a Worksheet Apply Text Formats 00: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 Microsoft Word 2019 Microsoft Word 2019 New Features Introduction to Microsoft Word 2019 New Features 00:14:00 Inking Tools 00:03:00 Inking Tools 1 00:07:00 Learning Tools 00:07:00 Microsoft Translate 00:03:00 LaTeX 00:05:00 Smart Lookup 00:04:00 Side to Side Scrolling 00:02:00 Scalable Vector Graphics 00:03:00 Getting Started with Word Navigate in Microsoft Word 00:12:00 Create and Save Word Documents 00:24:00 Manage Your Workspace 00:06:00 Edit Documents 00:16:00 Preview and Print Documents 00:04:00 Customize the Word Environment 00:08:00 Formatting Text and Paragraphs Apply Character Formatting 00:17:00 Control Paragraph Layout 00:19:00 Align Text Using Tabs 00:07:00 Display Text in Bulleted or Numbered Lists 00:03:00 Apply Borders and Shading 00:04:00 Working More Efficiently Make Repetitive Edits 00:06:00 Apply Repetitive Formatting 00:10:00 Use Styles to Streamline Repetitive Formatting Tasks 00:14:00 Managing Lists Sort a List 00:05:00 Format a List 00:06:00 Adding Tables Inserting a Table 00:06:00 Modify a Table 00:06:00 Format a Table 00:03:00 Convert Text to a Table 00:04:00 Inserting Graphic Objects Insert Symbols and Special Characters 00:04:00 Add Images to a Document 00:11:00 Controlling Page Appearance Apply a Page Border and Color 00:03:00 Add Headers and Footers 00:06:00 Control Page Layout 00:05:00 Add a Watermark 00:04:00 Preparing to Publish a Document Check Spelling Grammar and Readability 00:07:00 Use Proofing and Research Tools 00:07:00 Check Accessibility 00:03:00 Save a Document to Other Formats 00:04:00 Workbooks - Microsoft Word 2016 (Beginner) Workbooks - Microsoft Word 2016 (Beginner) 00:00:00 Microsoft PowerPoint 2019 Microsoft PowerPoint 2019 New Features Introduction to Microsoft PowerPoint 2019 New Features 00:06:00 Highlighting 00:02:00 Morph Transition 00:03:00 Zoom 00:03:00 Vector Graphics 00:03:00 SVG Icons to Shapes 00:04:00 3D Modeling 00:04:00 Background Removal 00:03:00 4K 00:03:00 PowerPoint Interface Navigate the PowerPoint Environment 00:28:00 View and Navigate a Presentation 00:15:00 Create and Save a PowerPoint Presentation 00:13:00 Use PowerPoint Help 00:10:00 Presentation Basics Select a Presentation Type 00:08:00 Edit Text 00:13:00 Build a Presentation 00:27:00 Formatting Format Characters 00:11:00 Format Paragraphs 00:16:00 Format Text Boxes 00:09:00 Inserting Options Insert Images 00:10:00 Insert Shapes 00:15:00 Working with Objects Edit Objects 00:16:00 Format Objects 00:06:00 Group Objects 00:04:00 Arrange Objects 00:07:00 Animate Objects 00:07:00 Table Create a Table 00:09:00 Format a Table 00:03:00 Insert a Table from Other Microsoft Office Applications 00:06:00 Charts Create a Chart 00:10:00 Format a Chart 00:10:00 Insert a Chart from Microsoft Excel 00:05:00 Review and Presentation Review Your Presentation 00:11:00 Apply Transitions 00:05:00 Print Your Presentation 00:05:00 Deliver Your Presentation 00:08:00 Microsoft Access 2019 Microsoft Access 2019 New Features Introduction to Microsoft Access 2019 New Features 00:05:00 Window Resize 00:01:00 Charts 00:02:00 dbf 00:01:00 Large Number 00:01:00 Property Sorting 00:01:00 Introduction to Access Orientation to Microsoft Access 00:39:00 Create a Simple Access Database 00:10:00 Get Help and Configure Options in Microsoft Access 00:06:00 Modify Data Modify Table Data 00:17:00 Sort and Filter Records 00:05:00 Working with Queries Create Basic Queries 00:15:00 Sort and Filter Data in a Query 00:14:00 Perform Calculations in a Query 00:08:00 Access Forms Create Basic Access Forms 00:07:00 Work with Data on Access Forms 00:23:00 Working with Reports Create a Report 00:28:00 Add Controls to a Report 00:12:00 Enhance the Appearance of a Report 00:05:00 Prepare a Report for Print 00:03:00 Organize Report Information 00:15:00 Format Reports 00:12:00 Assignment Assignment - Microsoft Office Basic to Advance 00:00:00 Recommended Materials Workbook - Microsoft Office Basic to Advance 00:00:00 Order Your Certificate Order Your Certificate 00:00:00

Master 75+ Excel tips and techniques and become a certified POWER USER, with unique hands-on demos and real-world projects to help you wrangle, analyze, and visualize your data in Excel.