444 Row courses delivered Online

🌟 Unlock the Power of Excel 2019! 🌟 Are you ready to master Microsoft Excel 2019 and elevate your skills to new heights? Introducing our comprehensive online course: 'Microsoft Excel 2019 - Beginner Level Training.' 🚀 Dive into Excel's World-Class Features 🚀 📚 Section 1 - Excel Beginner Get started with a solid foundation. Learn the interface, navigation, and essential tools to kickstart your Excel journey. 📊 Section 2 - Excel Fundamentals Discover the core functionalities of Excel 2019, from cells and formulas to tables and more. Lay the groundwork for proficient data manipulation. ️ Section 3 - Entering and Editing Text Master the art of inputting and refining text within Excel. Gain efficiency and accuracy in handling textual data. Section 4 - Basic Excel Functions Explore the fundamental functions that make Excel a powerhouse. From basic calculations to data analysis, unlock Excel's potential. 🔄 Section 5 - Modifying an Excel Worksheet Learn techniques to manage, organize, and customize worksheets effectively. Boost productivity and streamline your workflow. 🎨 Section 6 - Formatting Data Transform raw data into visually appealing, easy-to-read formats. Elevate your reports and presentations with polished data formatting skills. 🖼️ Section 7 - Images, Shapes, and Smart Art Enhance your spreadsheets with visuals! Master the incorporation of images, shapes, and smart art for impactful data representation. 🖨️ Section 8 - Printing in Excel Navigate the intricacies of printing in Excel. Optimize layouts and settings to produce professional-looking documents. 📑 Section 9 - Templates Harness the power of pre-designed templates. Learn how to utilize and customize templates for various Excel projects efficiently. 🎓 Section 10 - Excel Beginner - Conclusion Wrap up your journey with a comprehensive understanding of Excel's beginner level. Recap key takeaways and prepare to advance your skills further. 🔥 Join Now and Excel in Excel 2019! 🔥 👩‍💻 Whether you're a student, professional, or an Excel enthusiast, this course is your gateway to proficiency in Microsoft Excel 2019. Enroll today and unlock a world of possibilities with data manipulation, analysis, and presentation! 🌟 Don't miss this opportunity! Enroll now and empower yourself with Excel mastery! 🌟 Course Curriculum Section 1 - Excel Beginner Introduction 01:02 Section 2 - Excel Fundamentals Launching Excel 01:59 Start Up Screen 02:54 The Excel Interface 06:46 The Quick Access Toolbar 02:13 The Ribbon 04:43 Creating New Excel Workbooks 01:27 Saving Excel Files 02:22 Opening Excel Files 01:38 Beginner Shortcut Keys 01:37 Section 3 - Entering and Editing Text Entering Text 06:41 Working with Numbers 06:55 An Introduction to Dates 01:15 Find and Replace 04:10 Sorting Data 04:13 Working with Cell References 06:05 Relative Versus Absolute Cell Reference in Formulas 06:24 Understanding the Order of Operation 02:41 Section 4 - Basic Excel Functions The structure of an Excel Function 00:00 Working with the Sum Function 00:00 Working with Min and Max 00:00 Working with Averages 00:00 Working with Count and CountA 00:00 Section 5 - Modifying an Excel Worksheet Moving and Copying Data 00:00 Inserting and Deleting Rows and Columns 00:00 Changing the Width and Height of Cells 00:00 Hiding and Unhiding Rows, Columns and Sheets 00:00 Renaming Worksheets 00:00 Deleting Worksheets 00:00 Moving and Copying Worksheets 00:00 Section 6 - Formatting Data Adding Borders to Cells 00:00 Formatting Percentages 00:00 Merging and Centering Cells 00:00 A Quick look at Styles 00:00 Basic Conditional Formatting 00:00 Section 7 - Images, Shapes and Smart Art Inserting Images and Shapes 00:00 Working with SmartArt 00:00 Section 8 - Printing in Excel Print Preview 00:00 Margins, Scaling and Orientation 00:00 Printing 00:00 Section 9 - Templates Intro to Excel Templates 00:00 Opening an Existing Template 00:00 Creating a Custom Template 00:00 Section 10 - Excel Beginner - Conclusion Conclusion 00:00

Description Do you want to know how to be an expert in creating forms and gathering data? Are you looking for the easiest method regarding MS InfoPath? You may look at the MS InfoPath 2013: Working With InfoPath 2013 in SharePoint course. This course may assist you to get an approximate idea about this field. The MS InfoPath 2013: Working With InfoPath 2013 in SharePoint course incorporates some basic ideas regarding the use of MS InfoPath. It enables to know you how to make forms and collect data by using Infopath within SharePoint. It also teaches you how to edit, create, and publish a form along with a strong command of associated properties. It gives you a proper direction to use Infopath forms by utilizing WebParts. After the end of the course, you will be an expert on some advanced functions of InfoPath that enables you to modify data source and work with it vivid sections. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. 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? MS InfoPath 2013: Working With InfoPath 2013 in SharePoint 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 MS InfoPath 2013: Working With InfoPath 2013 in SharePoint 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. Introduction Introduction FREE 00:01:00 SharePoint and InfoPath Using InfoPath with SharePoint 00:04:00 Exploring the InfoPath Interface 00:03:00 Creating a Form from an Existing List 00:03:00 Creating a new List and Form within InfoPath 00:04:00 Creating a Form in InfoPath Using SharePoint Designer 00:02:00 Editing a Form 00:02:00 Publishing a Form 00:02:00 Restoring the Default SharePoint Form 00:03:00 Working with List Forms Components of the InfoPath Form 00:03:00 Formatting Text in the Form 00:03:00 Spellcheck Your Form 00:02:00 Inserting or Deleting a Table 00:02:00 Formatting a Table 00:03:00 Add or Remove Rows and Columns 00:02:00 Merging and Splitting Cells 00:04:00 Adding or Removing a Field 00:03:00 Resizing and Formatting a Field 00:03:00 Changing Field Controls 00:05:00 Inserting a Section 00:03:00 Inserting a Picture 00:02:00 Inserting a Button 00:05:00 Inserting a Calculated Value 00:04:00 Setting Default Field Values 00:05:00 Creating a Validation Rule 00:04:00 Creating a Formatting Rule 00:04:00 Creating an Action Rule 00:05:00 Modifying or Deleting a Rule 00:02:00 Setting the Form Load Rules 00:03:00 Advanced InfoPath Features Exploring the Fields Pane 00:02:00 Creating a Data Source 00:05:00 Modifying and Deleting a Data Source 00:02:00 Creating a View 00:03:00 Configuring View Settings 00:03:00 Creating Cascading Columns 00:06:00 Understanding Repeating Sections and Tables 00:03:00 Creating a Repeating Section 00:04:00 Using Repeating Tables to Add Multiple Items to a List 00:08:00 Using Repeating Sections to Show Existings Records 00:07:00 Hiding a Form Section Based on Field Values 00:05:00 InfoPath Forms Within SharePoint Using the InfoPath Form WebPart on a SP Page 00:04:00 Using Form Views for Different Groups 00:06:00 InfoPath Form WebPart and WebPart Filters 00:08:00 Conclusion Course Recap 00:01:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Excel Spreadsheet Training Course Overview Tired of staring at endless rows and columns in frustration? Would you like to transform your data into insights that impress your boss and streamline your work? Then welcome to Excel Spreadsheet Training: Your Journey from Spreadsheet Novice to Spreadsheet Ninja! At the beginning of the Excel Spreadsheet Training course, you will acquire a thorough understanding of the Excel interface, confidently navigating and leveraging its features for efficient spreadsheet management. Besides, you will learn to enter and manipulate various data types, including text, numbers, time, logical values, and graphics, ensuring accurate and diverse information representation. This course will help you increase your productivity as you master Autofill and Speedfil functionalities, streamlining your workflow and saving valuable time during data entry. Additionally, this Excel Spreadsheet Training course will assist you in developing the skills to save files effectively, ensuring data security and accessibility while maintaining a well-organized digital workspace. Expertise in formulas increases Excel efficiency. In this Excel Spreadsheet Training course, you will gain a solid foundation in Formula Basics, understand the mathematical order behind formulas, and confidently create and manipulate them to suit your analytical needs. Furthermore, you will learn the art of copying relative and absolute formulas, facilitating efficient replication of calculations across your spreadsheet. As you move deeper into the Excel Spreadsheet Training course, you will learn the tricks and techniques to manage the sheets efficiently. When you finish the course, you will be introduced to the functions enabling you to harness Excel's full potential for complex data analysis and decision-making. Without any further delay, enrol in the Excel Spreadsheet Training course to make a fast progression in your career.  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 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 spreadsheet for Beginner Tour of the Excel screen 00:10:00 Entering Data 00:13:00 Autofill Speedfill 00:09:00 Saving the file 00:02:00 Autosum 00:04:00 Formula Basics 00:11:00 Copying formulas - Relative Formulas 00:04:00 Totals and Averages 00:04:00 Formatting the Spreadsheet 00:07:00 Managing the Sheets 00:06:00 Copying formulas - absolute formulas 00:08:00 Linking the Sheets together 00:06:00 Introduction to Functions 00:05:00

Data Analysis In Excel for School Administrators 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 Data Analysis In Excel for School Administrators 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 5 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 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 numeracy and IT Desire for entrepreneurship over the age of 16. Assessment The assessment is straightforward, you need to complete the assignment questions that will be provided to you at the end of the course, you can complete the assignment anytime you want. After you complete and submit your assignment, our tutors will assess your assignment and give you feedback if needed.  After your assignment has been assessed and you have passed, you will be qualified and will be able to apply for a course completion certificate. 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. 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 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 Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:06:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:13:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:08: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:06:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:13:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:09: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:09:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:06:00

Description: Microsoft Excel, developed by Microsoft Corporation, is world's leading spreadsheet program for Windows, macOS, Android and iOS. The program includes calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications to make your task easy and for saving your precious time. You can hardly find any company where Microsoft Excel is not used. The knowledge of Excel is a must for meeting any career perspective. The course will help you to achieve the goals. The course is divided into three parts - beginners, intermediate and advanced. Therefore after completing the bundle video course, you will be a prolific user of the program. As the course is sectioned based on the level of difficulty, you will know the basics of Excel at first. You will know how to open an excel program, how to put data or know some simple calculations. After the primary knowledge, you will be introduced to some more features and functions of the program such as analyse massive amounts of data, extract actionable information from it, etc. Finally, you will learn the advanced features of Excel program that allows you take the right business decisions for your company. 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 Excel Complete Video Course - Beginner, Intermediate & Advanced 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 Excel Complete Video Course - Beginner, Intermediate & 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 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. Getting Started with Microsoft Office Excel 2016 Navigate the Excel User Interface FREE 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 Working with Functions Work with Ranges FREE 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:15: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 FREE 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 Refer A Friend Refer A Friend 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description:  This Microsoft Office 2010 Excel Beginners - Complete Video Course will teach you the basic functions and features of Excel 2010. After an introduction to spreadsheet terminology and Excel's window components, you will learn how to use the Help system and navigate worksheets and workbooks. Then you will enter and edit text, values, formulas, and pictures, and you will save workbooks in various formats. You will also move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. This course is designed to introduce you to using Microsoft Excel if you're unfamiliar with any major aspect of it. The series will lead you through the fundamentals of creating and working with Excel spreadsheets. Today's Excel spreadsheet isn't just for financial professionals. Microsoft Excel offers intuitive tools that make it easy to access, connect, and analyze critical data-regardless of your profession. 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 2010 Excel Beginners - Complete Video Course 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 2010 Excel Beginners - Complete Video Course 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. Getting Started Spreadsheet Terminology FREE 00:02:00 The Excel Environment 00:05:00 Getting Help 00:03:00 Navigating a Worksheet 00:06:00 Entering and Editing Data Entering and Editing Text and Values 00:09:00 Entering and Editing Formulas 00:09:00 Working with Pictures 00:03:00 Saving and Updating Workbooks 00:07:00 Modifying a Worksheet Moving and Copying Data 00:13:00 Moving and Copying Formulas 00:07:00 Absolute and Relative References 00:06:00 Inserting and Deleting Ranges, Rows, and Columns 00:07:00 Functions Entering Functions 00:15:00 AutoSum 00:04:00 Other Common Functions 00:11:00 Formatting Text Formatting 00:06:00 Column Formatting 00:12:00 Number Formatting 00:06:00 Conditional Formatting 00:10:00 Additional Formatting Options 00:12:00 Printing Preparing to Print 00:09:00 Page Setup Options 00:14:00 Printing Worksheets 00:04:00 Charts Chart Basics 00:11:00 Formatting Charts 00:05:00 Managing Large Workbooks Viewing Large Worksheets 00:14:00 Working with Multiple Worksheets 00:12:00 Printing Large Worksheets 00:08:00 Graphics and Screenshots Conditional Formatting with Graphics 00:09:00 SmartArt Graphics 00:05:00 Screenshots 00:05:00 Mock Exam Mock Exam- Microsoft Office 2010 Excel Beginners - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2010 Excel Beginners - Complete Video Course 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Get started with crochet! From holding your hook to creating a beautiful granny square blanket, get the techniques you need to crochet with confidence! The Crochet Basics - Learn to Crochet Within a Week will teach you the basic crochet techniques and will make swatches of each to practice and build confidence in the skills. The course will cover basic pattern reading, pattern abbreviations and terminology and take a look at chart reading. You will learn the stitches, tools and techniques you need to get started with crochet! Learn how to work in rows, keep your crochet on track and troubleshoot rows gone wrong. Then, learn three different ways to get started working in the round and become comfortable reading patterns! Finally, combine your new skills to create a charming granny square blanket you'll be proud to display or give. The Crochet Basics - Learn to Crochet Within a Week is designed for beginners, no knowledge of crochet is necessary, and is in fact preferable if you are to make the most of the course structure. What Will I Learn? crochet, even if you have never done it before make simple items such as a heart, granny square, triangle, filet blocks, circle, flower and a spiral shell reading the crochet charts, and understanding the signs Requirements get a yarn, preferably not too thin (2-3 mm thick) get the right crochet hook for the yarn you have chosen - ask the shops advice, or you can see the suggestion on the yarns label as well scissors darning needle - not necessary in the beginning Who is the target audience? absolute beginners those, who has learned to crochet before, but would like to refresh their knowledge those who knows how to crochet, but want to be more explicit in their knowledge What is crochet? What is it good for? Introduction FREE 00:05:00 How to Study 00:04:00 Hooks 00:04:00 What is Needed 00:01:00 Crochet Basics Holding the Hook 00:03:00 Slip Knot 00:02:00 Chain Stitch 00:03:00 Double Crochet 00:02:00 Treble Crochet 00:03:00 Half Treble Crochet 00:02:00 Double Treble Crochet 00:03:00 Triple Treble Crochet 00:02:00 Slip Stitch 00:03:00 Increase Decrease 00:04:00 Front Back Loop 00:04:00 FSC 00:05:00 Simple Crochet Items, Based on What We Already Know Triangle 00:12:00 Filet Crochet 00:12:00 Heart 00:13:00 Circle 00:09:00 Granny squares 00:13:00 Five Petal Flower 00:15:00 Spiral Shell 00:13:00 Goodbye 00:01:00 Course Certification

Microsoft Office 2016 Essentials 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 Microsoft Office 2016 Essentials 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 17 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 2016 Getting Started With Microsoft Office Excel 2016 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: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: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 Word 2016 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:05: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 PowerPoint 2016 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 Access 2016 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

Corel WordPerfect is a word processing application with a long history on multiple personal computer platforms. Level 3 Diploma in Corel WordPerfect 12 is designed to help you in using WordPerfect 12 to become much more productive and efficient. The course is divided into three sections. In the first section of the course, you will get basic knowledge on foundation training along with Workspace manager, customizing spelling and grammar. Following that, you will move to an intermediate level where you will learn about creating and modifying charts, sorting data, basics of mail merge, creating XML document and so much more. After completing the intermediate level you will look forward to advanced modules. This module covers Macros, uses of the OfficeReady browser, WordPerfect, and Windows. By the end of this course, you will be able to customize toolbars, property bars, keyboards, menu bar, display settings etc. This course is a complete course for you. So save your time and money by enrolling in this course today. Learning Outcomes: Opening and closing the program; understanding the interface; using menus, quickmenus, toolbars and dialog boxes How to use the programs toolbar and property bar, showing or hiding toolbars, customizing and managing it Typing text basics, selecting text with mouse, keyboard and menu, general tips and tricks Working with text via cutting, copying, pasting, using drag and drop, understanding insert and typeover mode, and using undo and redo How to save files for the first and second times, opening and closing files and/or document Utilizing the help menu, help topics, Corel tutor, specialized help, contextual help amd 'What's This' option Navigation through your cursor, scroll bars, keyboard, and the toolbar Using the object browser, go to dialog box, find the dialog box, and find and replace words Managing fonts through font face, size, bold, underline, italics, colour, quickfonts button, highlighting, and text's case through the property bar More font options through the dialog box, and advanced font tasks like embedding fonts and more Managing text position using the alignment, justification, line and paragraph spacing, ruler, tabs, margins and more options Spelling and grammar checking, using prompt-as-you-go, Grammatik, thesaurus, and the dictionary Opening, using, creating a template and organising projects Using PerfectExpert, and creaing envelopes and labels from the menu option Inserting data, time, symbols, using QuickWords, QuickCorrect, and smart quotes Ways to insert, suppress, remove page numbers, force pages and further insert line numbers Inserting clipart and pictures, reshaping and resizing graphics, positioning through the QuickMenu, ordering and flipping pictures, and adding borders How to use page view, draft view, two page view and zoom Using the print preview option to make adjustments and printing through various settings and options Switching between various documents, arranging document windows, moving text between documents, saving text in a separate file, and inserting documents Emailing and faxing your documents, and publishing them as PDF Affects of HTML on your document, previewing file in your browser, and publishing to HTML Making WordPerfect look like MS Office, opening office documents, saving office files, and using outlook contacts in WordPerfect Utilizing the WordPerfect file dialog box and toolbar options Saving your files using file extensions, viewing file properties, backing up your documents, and saving different versions Using page setup through margins, layout options, page size and orientation Explore the various printing options in order to get printouts Creating, expanding and saving Master documents; also creating, editing and removing subdocuments Understanding reveal codes window and un-revealing codes Examining code - like modifying, deleting, hard vs. soft; working with specific codes - character, sentence and paragraphs, etc.; and finding and replacing codes Applying built-in style using the property bar, updating existing styles, and creating your own style using QuickStyles and dialog boxes Creating and using document styles; and managing styles through the adding, saving and settings options Inserting and creating different list styles, and managing these list styles Utilizing QuickFormat and other formatting tools like the Make-It-Fit command and more Creating headers and footers, using the property bar, placing, suppressing, and deleting headers and footers Formatting text into columns, commenting on documents and reviewing them as well How to create watermark or text boxes Moving, resizing, adding borders and fill, adding captions, and wrapping text in text boxes Understand the basics of custom graphics and how to edit them to meet your needs Creating hyperlink and speed link within your documents Working with bookmarks and quickmarks Create table of contents, setting it up, generating and re-generating it, and using the document map Discover how to use WordPerfect, Microsoft Word, WordPerfect Classic, and Legal mode Customize toolbars, property bars, menus, keyboards, display settings and application bar options Modify WordPerfect environment, file settings, setting summary and conversion options Keep your spelling and grammar on check, change language preferences, add words to dictionary, and customize word list Understand the table structure and use tables property bar, QuickCreate, table menu and perfect expert to manage tables Insert, delete, resize, join and split cells or columns and rows Format tables through cells rotation option, setting vertical alignment, adding borders and fill, using speedformat, and creating or deleting speedformat styles Carry out advanced table tasks by using QuickSum, creating formulas, changing numeric formula of a cell, converting table to tabbed text and vice versa Understand the structure of charts, insert charts, how interface differs when working with them, move, resize, and delete them Changing chart type, chart colours and fonts, legend box, and your perspective Sort out data using sort dialog, setting sort options, creating custom sort, and outputting sort results to a disk Importing and linking spreadsheets or databases, and inserting objects and other file types Merging mail, creating data file, entering your data, using meal merge toolbar in data file Finding records; navigating between records and fields; modifying field names; adding, deleting and editing records Create form documents, add merge fields and merge codes, performing the merge, and creating envelopes during the merge Get an overview of the XML interface, creating new documents, publishing to XML, and converting existing documents to XML Using macro toolbars and visual basic editor along with recording, playing, editing and deleting macros Downloading the OfficeReady browser, using it and templates from the browser How to searchfor files in WordPerfect, starting the WordPerfect when Windows starts, and the differences between Windows Clipboard vs. Corel Clipbook 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? Level 3 Diploma in Corel WordPerfect 12 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 Level 3 Diploma in Corel WordPerfect 12 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. Module : 1 OPENING COREL WORDPERFECT 12 00:30:00 MORE ABOUT TOOLBARS 00:30:00 CREATING AND SELECTING TEXT 00:30:00 WORKING WITH TEXT 00:30:00 WORKING WITH YOUR DOCUMENT 00:30:00 FINDING HELP 00:30:00 BASIC NAVIGATION 00:15:00 USING WORDPERFECT'S TOOLS TO NAVIGATE THROUGH YOUR DOCUMENT 00:30:00 USING FONTS ON THE PROPERTY BAR 00:30:00 USING THE FONTS DIALOG BOX 00:30:00 ADVANCED FONT TASKS 01:00:00 CHANGING TEXT'S POSITION 00:30:00 ADVANCED TEXT POSITIONING 00:30:00 LANGUAGE TOOLS 00:30:00 PROJECTS 01:00:00 OTHER PRE-FORMATTED DOCUMENTS 00:30:00 USING TIMESAVING TOOLS 01:00:00 USING PAGE NUMBERS 00:30:00 ADDING PICTURES 01:00:00 VIEWING YOUR DOCUMENT 00:30:00 USING PRINT PREVIEW 00:30:00 PRINTING YOUR DOCUMENT 00:30:00 WORKING WITH MULTIPLE DOCUMENTS 00:30:00 SENDING YOUR DOCUMENT ELSEWHERE 00:30:00 CREATING A WEB PAGE 00:15:00 WORDPERFECT AND MICROSOFT OFFICE 00:30:00 Module : 2 USING THE FILE DIALOG BOX 01:00:00 USING TOOLBARS 00:15:00 SAVING YOUR FILES 00:30:00 USING PAGE SETUP 00:30:00 PRINTING YOUR FILES 00:30:00 USING MASTER DOCUMENTS AND SUBDOCUMENTS 01:00:00 REVEALING CODES 00:30:00 EXAMINING CODE 00:30:00 SPECIFIC CODES 00:30:00 FINDING AND REPLACING CODES 00:30:00 APPLYING A BUILT-IN STYLE 00:30:00 CREATING A STYLE 00:30:00 USING DOCUMENT STYLES 00:30:00 MANAGING STYLES 00:30:00 USING LIST STYLES 01:00:00 MANAGING LIST STYLES 00:30:00 USING QUICKFORMAT 01:00:00 OTHER FORMATTING TOOLS 01:00:00 CREATING HEADERS AND FOOTERS 00:30:00 FORMATTING TEXT INTO COLUMNS 01:00:00 COMMENTING ON A DOCUMENT 01:00:00 REVIEWING A DOCUMENT 01:00:00 CREATING A WATERMARK 00:30:00 CREATING TEXT BOXES 00:30:00 JAZZING UP TEXT BOXES 01:00:00 THE BASICS OF CUSTOM GRAPHICS 00:30:00 EDITING CUSTOM GRAPHICS 01:00:00 CREATING LINKS TO OUTSIDE YOUR DOCUMENT 00:30:00 WORKING WITH BOOKMARKS 00:30:00 WORKING WITH QUICKMARKS 00:30:00 CREATING A TABLE OF CONTENTS 01:00:00 Module : 3 Using the Workspace Manager 00:30:00 Customizing How You Interact With Word 00:15:00 Customizing How WordPerfect Interacts With Data 00:30:00 Customizing Spelling and Grammar 00:30:00 Creating a Basic Table 01:00:00 Working With Rows and Columns 00:30:00 Formatting a Table 00:30:00 Advanced Table Tasks 01:00:00 Creating Charts 00:30:00 Modifying Charts 00:30:00 Sorting Data 01:00:00 Using Data From Other Applications 00:30:00 Mail Merge Basics 00:30:00 Modifying Your Data 00:30:00 Finalizing the Merge 00:30:00 Creating an XML Document 01:00:00 Macros 01:00:00 Using the OfficeReady Browser 00:30:00 WordPerfect and Windows 01:00:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Office Excel 2016 for Beginners Course Overview Are you looking to begin your Microsoft Office Excel career or want to develop more advanced skills in Microsoft Office Excel? Then this Microsoft Office Excel 2016 for beginners online course will set you up with a solid foundation to become a confident office admin and help you to develop your expertise in Microsoft Office Excel. This Microsoft Office Excel 2016 for beginners online 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 Office Excel 2016 for beginners online 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 an office admin. The Microsoft Office Excel 2016 for beginners online 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 an office admin. This comprehensive Microsoft Office Excel 2016 for beginners online course is the perfect way to kickstart your career in the field of Microsoft Office Excel. This Microsoft Office Excel 2016 for beginners online 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 an office admin or want to learn more skills on Microsoft Office Excel but unsure of where to start, then this Microsoft Office Excel 2016 for beginners online 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 Office Excel 2016 for beginners online course is crafted by industry expert, to enable you to learn quickly and efficiently, and at your own pace and convenience. Who should take this course? This comprehensive Microsoft Office Excel 2016 for beginners online 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 Office Excel. Entry Requirement There are no academic entry requirements for this Microsoft Office Excel 2016 for beginners online 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. Career path This Microsoft Office Excel 2016 for beginners online course opens a brand new door for you to enter the relevant job market and also provides you with the chance to accumulate in-depth knowledge at the side of needed skills to become flourishing in no time. You will also be able to add your new skills to your CV, enhance your career and become more competitive in your chosen industry. Course Curriculum Getting Started With Excel 2016 Navigate the Excel User Interface - Introduction Navigate the Excel User Interface Use Excel Commands - Introduction Use Excel Commands Create and Save a Basic Workbook - Introduction Create and Save a Basic Workbook Enter Cell Data - Introduction Enter Cell Data Flash Fill and Auto Fill Use Excel Help - Introduction Use Excel Help Performing Calculations Create Worksheet Formulas - Introduction Create Worksheet Formulas Insert Functions - Introduction Insert Functions Reuse Formulas and Functions - Introduction Reuse Formulas and Functions Modifying a Worksheet Insert, Delete and Adjust Cells, Columns and Rows Search for and Replace Data Insert, Delete and Adjust Cells, Columns and Rows - Introduction Use Proofing and Research Tools Check the Spelling in a Worksheet Search for and Replace Data - Introduction Insights Task Pane Formatting a Worksheet Apply Text Formats - Introduction Apply Text Formats Apply Number Formats - Introduction Apply Number Formats Align Cell Contents - Introduction Align Cell Contents Apply Cell Styles and Themes Apply Cell Styles and Themes - Introduction Create and Use Templates - Introduction Apply Basic Conditional Formatting - Introduction Apply Basic Conditional Formatting Create and Use Templates Printing Workbooks Preview and Print a Workbook Configure and Preview a Print Job Set Up the Page Layout - Introduction Set Up the Page Layout Configure Headers and Footers - Introduction Configure Headers and Footers Managing Workbooks Manage Worksheets - Introduction Manage Worksheets Manage Workbook and Worksheet Views - Introduction Manage Workbook and Worksheet Views Manage Workbook Properties - Introduction Manage Workbook Properties Bonus Lecture Recognised Accreditation CPD Certification Service This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field. Quality Licence Scheme Endorsed The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees.     Certificate of Achievement Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35.   FAQs Is CPD a recognised qualification in the UK? 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. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org