988 Courses delivered Online

Microsoft Office skills are in high demand across industries, and proficiency in Microsoft Word, Microsoft Excel, Microsoft PowerPoint, and Microsoft Office 365 opens up numerous career opportunities. In the UK, administrative roles, data analysis positions, office management, project coordination, and marketing support roles are just a few examples of job prospects. With average salaries ranging from £20,000 to £45,000 per year, individuals with comprehensive Microsoft Office skills can secure stable employment and contribute to the success of various organisations. Enrol in the Ultimate Microsoft Office Skills Training course today and equip yourself with the knowledge and expertise needed to thrive in the ever-evolving workplace. You Will Learn Following Things: Develop a solid foundation in Microsoft Office applications, including Word, Excel, PowerPoint, and Office 365. Acquire essential skills to efficiently navigate and manipulate data in Microsoft Excel, such as organising, sorting, filtering, and writing formulas. Gain proficiency in creating professional presentations in Microsoft PowerPoint, utilising features like multimedia, transitions, animations, and smart graphics. Master the art of document creation and formatting in Microsoft Word, including tables, styles, page layouts, envelopes, labels, and mail merges. Understand advanced features like pivot tables, charts, and data analysis tools in Microsoft Excel, enabling effective data visualisation and decision-making. This course covers everything you must know to stand against the tough competition. The future is truly yours to seize with this Mastering Microsoft Office: Word, Excel, PowerPoint, and 365. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-to-one support from a dedicated tutor throughout your course. Study online - whenever and wherever you want. Instant Digital/ PDF certificate 100% money back guarantee 12 months access This course covers everything you must know to stand against the tough competition. The future is truly yours to seize with this Mastering Microsoft Office: Word, Excel, PowerPoint, and 365. Enrol today and complete the course to achieve a certificate that can change your career forever. Process of Evaluation After studying the course, your skills and knowledge will be tested with an MCQ exam or assignment. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement After completing the Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 course, you will receive your CPD-accredited Digital/PDF Certificate for £5.99. To get the hardcopy certificate for £12.99, you must also pay the shipping charge of just £3.99 (UK) and £10.99 (International). Who Is This Course for? This course is designed for individuals who want to enhance their Microsoft Office skills for personal or skilled purposes. Whether you are a student, an experienced entrepreneur, or anyone who regularly works with Microsoft Word, Excel, PowerPoint, and Office 365, this Microsoft Office skills course will provide you with a solid foundation and advanced techniques to maximise your productivity and efficiency. No prior experience is required, making it suitable for beginners and intermediate users looking to expand their knowledge and capabilities in the Microsoft Office suite. On the other hand, anyone who wants to establish their career as: like MS Office User Microsoft Office 2019 User Touch Typing Worker Audio Typist Can take this Ultimate Microsoft Office Skills Training (Word, Excel, PowerPoint, and 365) course. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career path Administrative Assistant - £20K to £30K/year Data Analyst - £25K to £45K/year Office Manager - £25K to £40K/year Project Coordinator - £25K to £35K/year Marketing Assistant - £20K to £30K/year Course Curriculum Section 01: Getting Started Introduction 00:03:00 Getting started on Windows, macOS, and Linux 00:01:00 How to ask great questions 00:01:00 FAQ's 00:01:00 Section 02: Excel 2021: Basics Excel Overview 00:05:00 Start Excel Spreadsheet 00:04:00 Enter Text and Numbers 00:07:00 Relative References 00:04:00 Working with ranges 00:07:00 Save and Save as Actions 00:08:00 File Extensions, Share, Export, and Publish files 00:06:00 Section 03: Excel 2021: Rows, Columns, and Cells Adding Rows and Columns 00:03:00 Modifying Rows and Column lengths 00:05:00 Section 04: Excel 2021: Data Handling Copy, Cut, and Paste 00:07:00 Copying Formulas 00:03:00 Section 05: Excel 2021: Page Setting Up and Print Page setup options 00:06:00 Fit to print on One Page 00:03:00 Print Workbooks 00:03:00 Section 06: Excel 2021: Sorting and Filtering Sorting Data Ascending Order 00:04:00 Sorting Data Descending Order 00:02:00 Filter Data 00:04:00 Section 07: Excel 2021: Writing Formulas Creating Basic Formulas 00:06:00 Datetime Formulas 00:06:00 Mathematical formulas phase1 00:20:00 Mathematical formulas phase2 00:12:00 Section 08: Excel 2021: Advanced Formulas VLOOKUP formula 00:12:00 HLOOKUP formula 00:04:00 Section 09: Excel 2021: XLOOKUP only for 2021 and Office 365 XLOOKUP 00:08:00 Handling #NA and Approximates match in XLOOKUP 00:11:00 Section 10: Excel 2021: Data and Tools Split Text into columns 00:07:00 Flash Fill 00:07:00 Data Validation 00:07:00 Remove Duplicates 00:08:00 Import Data from Text files 00:06:00 Import Data from .CSV files 00:03:00 Section 11: Excel 2021: Formatting data and tables Formatting Font 00:04:00 Formatting Alignment 00:06:00 Formatting Numbers 00:05:00 Formatting Date 00:03:00 Formatting Tables 00:05:00 Section 12: Excel 2021: Pivot Tables Pivot Tables 00:07:00 Pivot Charts 00:02:00 Section 13: Excel 2021: Charts Excel Charts - Categories 00:03:00 Elements of a chart 00:04:00 Creating Charts 00:02:00 Column or Bar charts 00:04:00 Formatting charts 00:04:00 Line Charts 00:02:00 Pie and Doughnut charts 00:04:00 Section 14: PowerPoint 2021: Course Introduction Overview 00:04:00 Start PowerPoint Presentation 00:05:00 Screen setting and Views 00:05:00 Section 15: PowerPoint 2021: Basics Presentation Tips and Guidelines 00:06:00 Creating a New Presentation 00:04:00 Working with Slides 00:04:00 Save a Presentation 00:04:00 Print Slides 00:03:00 Section 16: PowerPoint 2021: Text and Bullet Options Formatting Text 00:05:00 Slide Text Alignments 00:03:00 Multi-Column Text Alignments 00:02:00 Adding Bullets and Numbered List Items 00:03:00 Section 17: PowerPoint 2021: Adding Graphic Assets Insert Shapes 00:03:00 Insert Icons 00:03:00 Insert Graphics 00:04:00 Add 3D Models 00:03:00 Insert Pictures 00:03:00 Section 18: PowerPoint 2021: Picture Formatting Picture Options 00:04:00 Picture Cropping 00:03:00 Applying Built-in Picture Styles 00:04:00 Section 19: PowerPoint 2021: SmartArt Graphics Add SmartArt Graphic 00:03:00 Modifying SmartArt 00:03:00 Creating a Target Chart using SmartArt 00:03:00 Section 20: PowerPoint 2021: Working with Tables Create a Table on Slide 00:04:00 Formatting Tables 00:02:00 Inserting Tables 00:02:00 Table Layouts 00:01:00 Section 21: PowerPoint 2021: Working with Charts Add a Chart 00:02:00 Formatting Charts 00:02:00 Insert Chart from Microsoft Excel 00:03:00 Section 22: PowerPoint 2021: Adding Multimedia Adding Video to a Presentation 00:03:00 Adding Audio to a Presentation 00:02:00 Screen Recording and Adding 00:02:00 Section 23: PowerPoint 2021: Working with Transition Applying Transitions to Presentation 00:04:00 Section 24: PowerPoint 2021: Animation Object Animation 00:03:00 Effect Options 00:02:00 Advanced Animation 00:02:00 Triggers to control animation 00:02:00 Section 25: PowerPoint 2021: Slideshow Effects Onscreen Presentation 00:02:00 Hiding Slides 00:02:00 Changing Order of Slides 00:02:00 Copying Slides 00:02:00 Section 26: Word 2021: Introduction Overview of MS Word 00:04:00 Start MS Word 2021 00:05:00 Section 27: Word 2021: Basics Create a new blank document 00:04:00 Creating a paragraph text 00:05:00 Non-printing characters 00:03:00 Save a document 00:03:00 Open a document 00:01:00 Find and replace 00:04:00 Section 28: Word 2021: Word Formatting AutoCorrect options 00:03:00 Formatting text 00:04:00 Copy cut and paste 00:04:00 Character formatting 00:02:00 Format painter 00:04:00 Work with numbers 00:02:00 Add bullets 00:03:00 Outline creation 00:04:00 Section 29: Word 2021: Tables Creating a table 00:03:00 Adding rows and columns to a table 00:02:00 Formatting table data 00:02:00 Borders and shading 00:02:00 Sorting in a table 00:04:00 Draw a table 00:04:00 Convert text to table 00:03:00 Convert table to text 00:02:00 Insert a spreadsheet 00:02:00 Quick tables - readily available formats 00:02:00 Section 30: Word 2021: Styles Working with styles 00:02:00 Creating styles 00:02:00 Clear formatting 00:01:00 Section 31: Word 2021: Page Layout Margins 00:02:00 Orientation 00:01:00 Page size setting 00:01:00 Adding columns 00:03:00 Page break - section break 00:02:00 Adding watermark 00:03:00 Headers and footers 00:03:00 Section 32: Word 2021: Envelops and Lables Create envelops 00:02:00 Creating labels 00:02:00 Section 33: Word 2021: Mail Merges Creating a mail merge document 00:03:00 Section 34: Word 2021: Review and Printing Thesaurus and spell check 00:01:00 Word count 00:01:00 Speech - read aloud 00:01:00 Language - translate 00:01:00 Tracking 00:01:00

Why Learn Revit and 3dsMax V-Ray Visualization Basic to Advance Training Course? Course info Master architectural visualization and photorealistic renderings. In-person or live online options available. Learn Revit and 3dsMax, V-Ray rendering, and advanced techniques. Hands-on projects for real-world experience. Duration: 40 hrs Method: 1-on-1 - Individual support. Schedule: Tailor your own schedule by pre-booking a convenient hour of your choice, available from Mon to Sat between 9 am and 7 pm. Comprehensive Training: Master Revit, 3dsMax, and advanced visualization techniques for exceptional results. V-Ray Rendering: Explore realistic rendering with V-Ray, including advanced techniques and materials. Real-World Projects: Work on industry-relevant projects for a professional portfolio. Flexible Learning: Choose in-person or live online sessions for an engaging experience. Lesson Recordings: Access recorded classes to reinforce your understanding. Lifetime Email Support: Get guidance and assistance from experienced instructors beyond the course duration. Autodesk Certified Instructors. Comprehensive Training: Master Revit, 3dsMax, and advanced visualization techniques for exceptional results. V-Ray Rendering: Explore realistic rendering with V-Ray, including advanced techniques and materials. Real-World Projects: Work on industry-relevant projects for a professional portfolio. Flexible Learning: Choose in-person or live online sessions for an engaging experience. Lesson Recordings: Access recorded classes to reinforce your understanding. Lifetime Email Support: Get guidance and assistance from experienced instructors beyond the course duration. Autodesk Certified Instructors. Part 1: Revit (16 hours) Module 1: Introduction to Revit Familiarizing with the Revit interface and workspace Embracing the Building Information Modeling (BIM) workflow Creating a fundamental building model as a starting point Module 2: Basic Modeling in Revit Working with essential elements such as walls, doors, and windows Constructing floors and roofs to complete the building structure Crafting functional and visually appealing stairs and railings Module 3: Advanced Modeling in Revit Delving into the creation and manipulation of families Utilizing parameters and constraints to enhance modeling efficiency Exploring intricate geometries for complex designs Module 4: Annotation and Documentation in Revit Enhancing project documentation by adding text and dimensions Generating informative schedules for better project management Mastering the printing and exporting processes for professional output Part 2: 3ds Max (16 hours) Module 1: Introduction to 3ds Max Navigating the 3ds Max interface and workspace Understanding the 3D modeling workflow for design visualization Initiating the creation of basic 3D models Module 2: Basic Modeling in 3ds Max Working with primitive shapes to build foundational models Creating and refining splines to form versatile shapes Advancing to complex 3D model development for intricate designs Module 3: Materials and Textures in 3ds Max Exploring the material editor and its functionalities Skillfully applying and adjusting materials for realistic renders Incorporating textures to add depth and detail to the models Module 4: Lighting and Cameras in 3ds Max Mastering the art of lighting creation and manipulation Utilizing the daylight system for enhanced realism Understanding cameras and perspectives for compelling visual storytelling Part 3: V-Ray (8 hours) Module 1: Introduction to V-Ray Getting acquainted with the V-Ray interface and workflow Exploring V-Ray materials and textures for high-quality renders Module 2: Lighting and Rendering in V-Ray Creating and refining lighting setups for stunning renders Utilizing global illumination to enhance the realism of scenes Implementing advanced rendering techniques for professional output Module 3: Materials and Textures in V-Ray Crafting and modifying V-Ray materials for realistic surfaces Applying V-Ray textures to add depth and realism to objects Utilizing V-Ray displacement maps for intricate details For 3ds Max free trial, visit: https://www.autodesk.co.uk/products/free-trial. To access the V-Ray free trial, visit: https://www.chaosgroup.com/. Start your journey to becoming a proficient designer and renderer in the world of 3D modeling and visualization. Download Revit Revit and 3dsMax V-Ray Visualization Basic to Advance Training Course: Proficient Software Skills: Acquire a strong command of Revit and 3dsMax, along with advanced techniques in V-Ray rendering. High-Quality Visualizations: Create realistic and visually stunning architectural visualizations using V-Ray. Architectural Modeling: Master the process of modeling architectural elements with precision and efficiency. Materials and Textures: Understand how to apply realistic materials and textures to enhance visualizations. Lighting Setup: Set up lighting environments to achieve optimal illumination and ambiance in renderings. Rendering Techniques: Explore advanced rendering techniques, including global illumination, caustics, and ambient occlusion. Real-World Projects: Complete industry-relevant projects to build a professional-grade portfolio. Problem-Solving Skills: Develop the ability to troubleshoot and resolve rendering challenges effectively. Efficient Workflows: Learn time-saving workflows and best practices for efficient visualization production. Portfolio Showcase: Showcase your newly acquired skills through a diverse range of visualizations.

Overview This Fitness Business - Sell Products, Training & Coaching Online course will unlock your full potential and will show you how to excel in a career in Fitness Business - Sell Products, Training & Coaching Online. So upskill now and reach your full potential. Everything you need to get started in Fitness Business - Sell Products, Training & Coaching Online is available in this course. Learning and progressing are the hallmarks of personal development. This Fitness Business - Sell Products, Training & Coaching Online will quickly teach you the must-have skills needed to start in the relevant industry. In This Fitness Business - Sell Products, Training & Coaching Online Course, You Will: Learn strategies to boost your workplace efficiency. Hone your Fitness Business - Sell Products, Training & Coaching Online skills to help you advance your career. Acquire a comprehensive understanding of various Fitness Business - Sell Products, Training & Coaching Online topics and tips from industry experts. Learn in-demand Fitness Business - Sell Products, Training & Coaching Online skills that are in high demand among UK employers, which will help you to kickstart your career. This Fitness Business - Sell Products, Training & Coaching Online course covers everything you must know to stand against the tough competition in the Fitness Business - Sell Products, Training & Coaching Online field.  The future is truly yours to seize with this Fitness Business - Sell Products, Training & Coaching Online. Enrol today and complete the course to achieve a Fitness Business - Sell Products, Training & Coaching Online certificate that can change your professional career forever. Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the Fitness Business - Sell Products, Training & Coaching Online course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the Fitness Business - Sell Products, Training & Coaching Online course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.  Certificate of Achievement Upon successfully completing the Fitness Business - Sell Products, Training & Coaching Online course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This Fitness Business - Sell Products, Training & Coaching Online is suitable for anyone aspiring to start a career in Fitness Business - Sell Products, Training & Coaching Online; even if you are new to this and have no prior knowledge on Fitness Business - Sell Products, Training & Coaching Online, this course is going to be very easy for you to understand.  And if you are already working in the Fitness Business - Sell Products, Training & Coaching Online field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  Taking this Fitness Business - Sell Products, Training & Coaching Online course is a win-win for you in all aspects.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements This Fitness Business - Sell Products, Training & Coaching Online course has no prerequisite.  You don't need any educational qualification or experience to enrol in the Fitness Business - Sell Products, Training & Coaching Online course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online Fitness Business - Sell Products, Training & Coaching Online course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Introduction Who this course is for 00:02:00 What you will learn 00:03:00 Fitness Business Models Fitness Business Models Overview 00:02:00 The Coaching Business Model 00:04:00 Selling Products Business Model 00:06:00 Affiliate Marketing Business Model 00:06:00 Fitness Sponsorships 00:02:00 Refining Your Business Idea The First Steps 00:03:00 Finding The Right Fitness Niche 00:04:00 How To Identify The Ideal Coaching Client 00:05:00 How To Identify Your Clients Pain Points 00:03:00 How To Become An Expert 00:04:00 Creating Your First Product Understand What You Are Selling 00:01:00 Creating Your First Fitness Information Product 00:07:00 MVP - Minimal Viable Product 00:03:00 Creating Your First Workout Routine / Diet Plan 00:04:00 Writing Your First Fitness eBook 00:06:00 Recording Your First Fitness Video Course 00:06:00 Creating A Coaching Offer 00:03:00 Selling & Marketing Fundamentals Overview 00:02:00 Most Common Fitness Marketing Mistakes 00:04:00 Setting SMART Marketing Goals 00:07:00 Crafting A Stong Marketing Message 00:06:00 Selling & Marketing Strategies Choosing The Right Marketing Channel 00:08:00 Email Marketing For Your Product 00:03:00 How To Build An Email List 00:03:00 Your First Autoresponder Series 00:10:00 How To Build The Perfect Lead Magnet 00:05:00 How To Use WordPress For Your Fitness Business 00:08:00 Installing WordPress 00:05:00 Building A Landing Page 00:06:00 Building A Thank You Page 00:03:00 Driving Traffic To Your Site Starting A Niche Youtube Channel 00:05:00 Keyword Research For Youtube 00:04:00 My Youtube Content Strategy 00:04:00 How To Set Up Your First Lead Ad In Facebook 00:06:00 Affiliate Marketing 3 lectures Affiliate Marketing Overview 00:01:00 Writing Blog Posts With Affiliate Links 00:04:00 Making Affiliate Sales With Youtube Videos 00:03:00 Online Business Motivation Motivation Intro 00:01:00 How To Deal With Difficult Customers / Clients 00:03:00 How To Deal With Email Overload 00:04:00 How To Develop The Mindset Of An Entrepreneur 00:04:00 How To Not Lose Track Of Your Business Goals 00:05:00

Designed for professional B2B salespeople to develop a modern approach to winning business

Description: Corel WordPerfect 12 is a word processing application with a long history on multiple personal computer platforms. In the first section of the course, you will get basic knowledge on foundation training along with Workspace manager, customizing spelling and grammar. You will be able to create, edit, and save documents. Secondly, the intermediate level explains to you how to use the file dialogue box, toolbar, page set up, save and print files, etc. It will also teach you all the tools and techniques required to operate any work making it more valuable. Moving on to the advanced level, you will learn the stuff such as creating and modifying charts, making tables, working with rows and columns, sorting data, etc. Following that, you will learn about the basic introduction, applications and advantages of using email. Besides, you will get a clear idea of the anatomy, interface, shortcut keys, inbox, outbox, basic email etiquette, and so much more. Finally, application training section teaches you about email applications, opening and closing the WordPerfect email application. Corel WordPerfect Complete Training Course is created to help you stand out among other co-workers and to perform better at work. 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 Email address structure, the benefits of email, email etiquette, understand spam and viruses, and digital signatures Common email applications, opening and closing the WordPerfect email application, understanding its structure and getting help Using the folder list, main menus, toolbar, shortcut menus, shortcut keys and dialogue boxes Opening your inbox and messages, switching between open messages, closing email messages, and adding and removing message list headings Using the contact list, searching for messages, creating folders, and moving messages to a folder Sorting and deleting messages, restoring and emptying deleted items Flagging messages, marking messages as read or unread, opening and saving attachments, using reply & reply to all, and forwarding messages options How to print your messages using the print preview, print commands, choosing a print range, and setting the number of copies Creating and addressing messages; adding a subject; composing message; using the cut, copy and paste options and sending the message Adding and removing attachments, changing priority, and copying text into a message Explore the differences between HTML and Plain text emails, set up default text fonts, add images, and spell checks Adding people to your contact list, how to create a distribution list, and adding and removing addresses from the distribution list Understanding the structure of email addresses, advantages of email, email etiquette, spams and viruses, and digital signatures Common email applications, opening and closing the WordPerfect email application, understanding its structure and getting help Utilizing the folder list, main menus, toolbar, shortcut menus, shortcut keys and dialogue boxes Opening your inbox and messages, switching between open messages, closing email messages, and adding and removing message list headings Best ways to use the contact list, search for messages, create folders, and moving messages to a folder Sorting and deleting messages, restoring and emptying deleted items Discover more about message tools through flagging, marking messages as read or unread, opening and saving attachments, using reply and forwarding messages options How to print your messages using the print preview, print commands, choosing a print range, and setting the number of copies Creating and addressing messages; adding a subject; composing message; using the cut, copy and paste options and sending the message Advanced message tools like adding and removing attachments, changing priority, copying text into a message Compare HTML vs. Plain text emails, set up default text fonts, add images, and check spellings Adding people to your contact list, how to create a distribution list, and changing the addresses from the distribution list 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? Corel WordPerfect Complete Training 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 Corel WordPerfect Complete Training 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. 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 LIST 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 Module - 4 All About E-mail 00:30:00 Getting Started 01:00:00 Components of the Mail Interface 00:30:00 Working with Messages 01:00:00 Managing Mail 01:00:00 Working With Messages 00:30:00 Message Tools 01:00:00 Printing Messages 00:30:00 Creating Messages 01:00:00 Advanced Message Tools 01:00:00 Working With E-mail 01:00:00 Address Tools 01:00:00 Module - 5 All About E-mail 00:15:00 Getting Started 00:30:00 Components of the Mail Interface 00:30:00 Working with Messages 00:30:00 Managing Mail 01:00:00 Working With Messages 00:30:00 Message Tools 00:30:00 Printing Messages 00:30:00 Creating Messages 00:30:00 Advanced Message Tools 00:30:00 Working With E-mail 00:30:00 Address Tools 00:30:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Bookkeeping: Sage 50 With Accounting and Finance Level 5 Would you like to acquire a basic grasp of bookkeeping? If yes, you are going to enjoy our Bookkeeping for Personal and Business Accounting course! The Bookkeeping: Bookkeeping Online for Personal and Business Accounting course delves into the fundamentals of financial record-keeping. This Bookkeeping: Bookkeeping Online for Personal and Business Accounting course also covers double-entry bookkeeping. Moreover, this Bookkeeping for Personal and Business Accounting involves transaction recording, and financial statement creation. With a focus on both personal and business accounting, Bookkeeping: Bookkeeping for Personal and Business Accounting participants gain practical skills in budgeting, expense tracking, and utilizing accounting software. Unlock our Bookkeeping: Bookkeeping Online for Personal and Business Accounting course to foster financial literacy for individuals and equips entrepreneurs for effective business accounting! Main Course: Bookkeeping for Personal and Business Accounting Free Courses Course 01: Level 5 Accounting and Finance Course 02: Sage 50 [ Note: Free PDF certificate as soon as completing the Bookkeeping: Bookkeeping Course] Bookkeeping: Bookkeeping Online This Bookkeeping: Bookkeeping Online Lead Course consists of 09 modules. Course Curriculum of Bookkeeping: Bookkeeping Online Course Module 1: Introduction to Bookkeeping Module 2: Proper Bookkeeping Module 3: Beginning Accounting Module 4: Types of Accounting Module 5: Making Sense of Your Accounts Module 6: Keeping Inventory and Tracking Sales Module 7: Controlling and Managing Expenses Module 8: Avoiding illegal accounting Module 9: Handling an audit Assessment Method of Bookkeeping: Bookkeeping Online Course After completing Bookkeeping: Bookkeeping Online Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Certification of Bookkeeping: Bookkeeping Online Course After completing the Bookkeeping: Bookkeeping Online Course, you can instantly download your certificate for FREE. Who is this course for? Bookkeeping: Bookkeeping Online Anyone who has a passion for establishing a career in this sector can take our Bookkeeping: Bookkeeping course. Requirements Bookkeeping: Bookkeeping Online To enrol in this Bookkeeping: Bookkeeping Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Bookkeeping: Bookkeeping Course. Be energetic and self-motivated to complete our Bookkeeping: Bookkeeping Course. Basic computer Skill is required to complete our Bookkeeping: Bookkeeping Course. If you want to enrol in our Bookkeeping: Bookkeeping Course, you must be at least 15 years old. Career path Bookkeeping: Bookkeeping Online After finishing this course on Bookkeeping: Bookkeeping Online for personal and business accounting, you can start career as entrepreneur, your own business or choose to work in the accounting field.

Bookkeeping Diploma with Payroll Management Would you like to acquire a basic grasp of bookkeeping? If yes, you are going to enjoy our Bookkeeping Diploma with Payroll Management course! The Bookkeeping Diploma with Payroll Management course delves into the fundamentals of financial record-keeping. This Bookkeeping Diploma with Payroll Management course also covers double-entry bookkeeping. Moreover, this Bookkeeping Diploma with Payroll Management involves transaction recording and financial statement creation. With a focus on both personal and business accounting, Bookkeeping Diploma with Payroll Management participants gain practical skills in budgeting, expense tracking, and utilizing accounting software. Unlock our Bookkeeping Diploma with Payroll Management to foster financial literacy for individuals and equip entrepreneurs for effective business accounting! Special Offers of this Bookkeeping Diploma with Payroll Management Course This Bookkeeping Diploma with Payroll Management Course includes a FREE PDF Certificate. Lifetime access to this Bookkeeping Diploma with Payroll Management Course Instant access to this Bookkeeping Diploma with Payroll Management Course 24/7 Support Available to this Bookkeeping Diploma with Payroll Management Course [ Note: Free PDF certificate as soon as completing the Bookkeeping Diploma with Payroll Management Course] Bookkeeping Diploma with Payroll Management Unlock your financial potential with our Bookkeeping Diploma with Payroll Management course! This comprehensive Bookkeeping Diploma with Payroll Management covers the fundamentals of financial record-keeping, ensuring a solid foundation in accounting practices. Learn essential skills such as double-entry bookkeeping with our Bookkeeping Diploma with Payroll Management course. Certificate of Completion You will receive a course completion certificate for free as soon as you complete the Bookkeeping Diploma with Payroll Management Course. Who is this course for? Bookkeeping Diploma with Payroll Management Anyone who has a passion for establishing a career in this sector can take our Bookkeeping Diploma with Payroll Management Course. Requirements Bookkeeping Diploma with Payroll Management To enrol in this Bookkeeping Diploma with Payroll Management Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Bookkeeping Diploma with Payroll Management Course. Be energetic and self-motivated to complete our Bookkeeping Diploma with Payroll Management Course. Basic computer Skill is required to complete our Bookkeeping Diploma with Payroll Management Course. If you want to enrol in our Bookkeeping Diploma with Payroll Management Course, you must be at least 15 years old. Career path Bookkeeping Diploma with Payroll Management After finishing this Bookkeeping Diploma with Payroll Management Course, you can start career as entrepreneur, your own business or choose to work in the accounting field.

Designated Safeguarding Officer The purpose of this Designated Safeguarding Officer course is to provide strong knowledge of safeguarding to people who work with children. Our exclusive Designated Safeguarding Officer Training Course will teach you about the safeguarding procedure and how to deal with suspected abuse in order to protect children from future harm. This Designated Safeguarding Officer Training Course provides learners with a solid understanding of why safeguarding is so important. It discusses the designated safeguarding lead's role, what they are responsible for and the short-term and long-term risks that a child may face as a result of abuse. The Designated Safeguarding Officer course also covers the procedures on how to report and respond to concerns that a child is being abused and the steps to follow. Why choose this Designated Safeguarding Officer Training Course from the School of Health Care? Self-paced course, access available from anywhere in the world. High-quality study materials that are easy to understand. Course developed by industry experts. After each module, there will be an MCQ quiz to assess your learning. Assessment results are generated automatically and instantly. 24/7 support is available via live chat, phone call, or email. Free PDF certificate after completing the course. Main Course: Level 3 Designated Safeguarding Lead Training Course Free Courses Course 01: Level 3 Award in Childcare and Education Course 02: Child and Adolescent Mental Health [ Note: Free PDF certificate as soon as completing Designated Safeguarding Officer Training Course] Designated Safeguarding Officer Course Curriculum of Level 3 Designated Safeguarding Lead Training Course Module 01: Introduction Module 02: Safeguarding Structure and Guidance Module 03: Recognising and Responding to Abuse Module 04: Responses Under the Safeguarding Structure Module 05: Working Together and Sharing Information Module 06: Recording Information Assessment Method of Designated Safeguarding Officer After completing Designated Safeguarding Lead Training Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Apart from this, you do not need to sit for any other assessments. Certification of Designated Safeguarding Officer After completing the Designated Safeguarding Lead Training course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £13.99 Who is this course for? Designated Safeguarding Officer This Designated Safeguarding Lead Training course is ideal for supervisors, managers, or designated safeguard leads who work with children, teenagers, or vulnerable adults. This includes the following: Nursery workers Teachers Support staff Social workers Nurses Doctors. Requirements Designated Safeguarding Officer There are no particular requirements for this Designated Safeguarding Officer Training Course because it doesn't call for any specialized training. Career path Designated Safeguarding Officer

HACCP: HACCP Course Online Unlock Your HACCP Potential with Our Level 3 HACCP Training Course! To ensure that the food you handle, produce, and distribute is completely safe for consumption, you must follow a set of approved rules. A supplier’s regulation differs from that of a manufacturer. Handling hot foods differs from handling cold or frozen foods. Not only must you take safety precautions, but you must also be diligent in terms of documentation and recording in order to comply with UK legislation. A HACCP: HACCP Course system is ideal in this regard for maintaining proper food safety and hygiene in your food business. A HACCP: HACCP Course system addresses various aspects using various approaches. Our HACCP: HACCP Course will provide you with a thorough understanding of the topic in general, eventually leading to an advanced level. We proceed by outlining the legislation, food safety hazards, and system principles after evaluating the system’s fundamentals. Later, we added the process of creating and implementing your system procedures even during this pandemic, so you do not have to worry about it. By completing this Level 3 HACCP Training Course, you will be fulfilling your legal obligations while reducing the risk of negative publicity or lawsuits. Register now for our Level 3 HACCP Training and become a HACCP champion! Main Course: Level 3 HACCP Training Course Free courses included with Time Management: Time Management Course Along with Level 3 HACCP Training Course you will get free Level 2 Food Hygiene and Safety Along with Level 3 HACCP Training Course you will get free Level 2 Food Hygiene and Safety for Catering Special Offers of this HACCP: HACCP Course: This HACCP: HACCP Course includes a FREE PDF Certificate. Lifetime access to this HACCP: HACCP Course Instant access to this HACCP: HACCP Course 24/7 Support Available to this HACCP: HACCP Course HACCP: HACCP Course Online Our HACCP: HACCP Course offers comprehensive coverage of HACCP: HACCP Course and related laws. It also includes alternatives and the HACCP: HACCP planning framework. The HACCP: HACCP Course modules cover a range of topics, such as prerequisite programms, food safety hazards, and building the HACCP: HACCP system. Who is this course for? HACCP: HACCP Course Online This HACCP: HACCP Course is ideal for those who work in: Restaurants or cafes. Hospitality and catering. Kitchens in schools and workplaces. Stalls, selling food. Supermarkets and butchers. Requirements HACCP: HACCP Course Online To enrol in this HACCP: HACCP Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our HACCP: HACCP Course. Be energetic and self-motivated to complete our HACCP: HACCP Course. Basic computer Skill is required to complete our HACCP: HACCP Course. If you want to enrol in our HACCP: HACCP Course, you must be at least 15 years old. Career path HACCP: HACCP Course Online Food Business Manager or Supervisor Owner of a Food Business Head Chef Lead Quality Controller in a Food Production System Health & Safety Inspector

Join our Microsoft Excel course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The Microsoft Excel course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Microsoft Excel course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now! You will Learn The Following Things: Learn strategies to boost your workplace efficiency. Hone your skills to help you advance your career. Acquire a comprehensive understanding of various topics and tips. Learn in-demand skills that are in high demand among UK employers This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Microsoft Excel. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-to-one support from a dedicated tutor throughout your course. Study online - whenever and wherever you want. Instant Digital/ PDF certificate 100% money back guarantee 12 months access Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement After completing the Microsoft Excel course, you will receive your CPD-accredited Digital/PDF Certificate for £5.99. To get the hardcopy certificate for £12.99, you must also pay the shipping charge of just £3.99 (UK) and £10.99 (International). Who Is This Course for? This Microsoft Excel is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand.  On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Microsoft Excel course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path The certification and skills you get from this Microsoft Excel Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Course Curriculum Unit 01: Excel from A-Z Course Introduction Excel from A-Z Course Intro 00:03:00 Excel Job Opportunities 00:03:00 Excel Job Types 00:04:00 Microsoft Excel Marketplace 00:04:00 What is Microsoft Excel? 00:04:00 Who is This Course For? 00:03:00 Unit 02: Getting Started With Excel Finding & Opening Excel 00:01:00 Excel's Start Screen 00:03:00 Explaining the Excel Interface 00:03:00 Excel Interface Continued 00:01:00 Excel Workbook vs. Excel Worksheet 00:02:00 Saving an Excel Document 00:04:00 Customizing the Quick Access Toolbar 00:02:00 Customizing the Excel Ribbon 00:03:00 Excel Shortcut Keys 00:02:00 Unit 03: Values, Referencing and Formulas Creating Excel Labels 00:03:00 Entering Numeric Values in Excel 00:03:00 Formatting Date Values in Excel 00:05:00 Building Basic Formulas in Excel 00:05:00 Order of Operations 00:06:00 Relative vs. Absolute Cell References 00:07:00 Unit 04: Intro to Excel Functions Excel Functions Explained 00:03:00 The SUM() Function 00:08:00 The MIN() & MAX() Function 00:04:00 The AVERAGE() Function 00:02:00 COUNT() Functions 00:05:00 Unit 05: Adjusting Excel Worksheets Moving & Copying Data 00:07:00 Insert & Delete Rows and Columns 00:05:00 Adjusting the Width and Height of Cells 00:05:00 Hiding and Unhiding Excel Rows and Columns 00:04:00 Renaming, Moving & Deleting Excel Worksheets 00:05:00 Adding Protection to Specific Cells 00:04:00 Protecting the Structure of a Workbook 00:02:00 Adding a Workbook Password to Open File 00:02:00 Unit 06: Visually Pleasing Cell Formatting Formatting Fonts and Cell Background Color 00:05:00 Adding Cell Borders 00:05:00 Formatting Data Appropriately 00:05:00 The Magic behind Excel's Format Painter 00:03:00 Creating Styles for Formatting Efficiency 00:06:00 Merging Cells for a Cleaner Look 00:03:00 The Power of Conditional Formatting 00:06:00 Unit 07: How to Insert Images and Shapes! Grab User's Attention using Illustrations 00:09:00 Customizing Icons 00:05:00 Create Compelling Graphics with SmartArt 00:06:00 Unit 08: Visualize Data with Charts The Commonly Used Column Chart 00:03:00 Changing the Chart Design.mp4 00:02:00 Formatting Elements of a Chart 00:06:00 Modifying the Data, Type & Location of a Chart 00:06:00 Unit 09: Excel's Printing Options Print Preview Options 00:04:00 Excel's Page Layout View 00:07:00 Printing a Specific Range of Cells 00:03:00 Converting Spreadsheets to PDF Files 00:02:00 Unit 10: Benefits of Using Excel Templates Why Create an Excel Template 00:01:00 How to Create an Excel Template 00:05:00 Unit 11: Working with Excel Datasets How to Prepare Data for Analysis 00:04:00 How to Sort Data in Excel 00:03:00 Multi-Level Sorting 00:03:00 Custom Sorting Datasets in Excel 00:02:00 Applying Filters to Datasets 00:05:00 Creating Subtotals within a Dataset 00:06:00 Converting Datasets into Tables 00:06:00 Little Slice of Pie Charts 00:05:00 Finding & Removing Duplicate Values 00:07:00 Unit 12: Excel Database Functions The SUMIF() Function 00:09:00 The DSUM() Function 00:08:00 The DSUM() Function Cont. 00:07:00 The SUBTOTAL() Function 00:06:00 Unit 13: Excel Data Validation What is Excel Data Validation? 00:02:00 Creating a Drop Down List with Data Validation 00:07:00 Different Types of Excel Data Validation 00:06:00 Adding Custom Alerts to Data Validation 00:07:00 Creating a Dynamic Drop Down List 00:03:00 Complex Validation: Dependent Drop Down List! 00:09:00 Unit 14: Excel PivotTables Creating an Excel Pivot Table 00:06:00 Modifying Excel PivotTables 00:06:00 Grouping & Filtering PivotTable Data 00:06:00 Drilling Down into PivotTable Data 00:02:00 Creating Pivot Charts & Utilizing Slicers 00:08:00 Unit 15: Excel's PowerPivot Add-In What is PowerPivot? 00:04:00 Activating the Excel PowerPivot Add-In 00:02:00 Creating Relationships between Data Tables.mp4 00:06:00 Using Data Models to Create PivotTables 00:05:00 How to Create PowerPivot KPI's 00:08:00 Unit 16: Excel's Conditional Functions Excels IF Function 00:05:00 IF() Function with AND() Criteria 00:05:00 IF() Function with OR() Criteria 00:05:00 Nesting Multiple IF() Functions 00:07:00 The COUNTIF() Function 00:04:00 Key Benefits of Named Ranges 00:04:00 Unit 17: Excel's Lookup Function VLOOKUP() Function 00:09:00 The Beauty of Excel's IFERROR() Function 00:04:00 HLOOKUP() Function 00:06:00 The INDEX Function 00:05:00 MATCH() Function 00:05:00 INDEX() and MATCH() Combined 00:05:00 Two-Way Lookup with INDEX() and MATCH() 00:04:00 Unit 18: Text Based Functions in Excel LEFT(), RIGHT() and MID() Function 00:07:00 Extracting Specific Text using LEN() & SEARCH() 00:13:00 Combining Text with CONCATENATE() 00:06:00 Quick Tips & Other Text Based Functions 00:06:00 Unit 19: Auditing Formulas and Views in Excel Tracing Precedents & Dependents in Formulas 00:04:00 Showing Formulas 00:02:00 Grouping Data 00:03:00 3D Referencing in Formulas 00:05:00 Utilizing the Watch Window in Excel 00:03:00 How to Freeze Panes in Excel 00:03:00 Unit 20: Excel's 'what If?' Tools Excel's Scenario Manager Tool 00:06:00 Goal Seek in Excel 00:06:00 Compare Results with Excel Data Tables 00:04:00 Solver Tool 00:11:00 Unit 21: Welcome to Excel VBA The Power Behind Excel VBA 00:03:00 A Look Inside the Visual Basic Editor (VBE) 00:04:00 Recording a Macro 00:09:00 Saving & Opening a Macro-Enabled Workbook 00:02:00 Unit 22: The VBA Language Modules and Procedures 00:07:00 Objects, Methods and Properties 00:06:00 Excel VBA Variables 00:05:00 Unit 23: Writing VBA Code Referencing a Range 00:13:00 InputBox & MsgBox 00:06:00 Using Variables in VBA Code 00:05:00 If Then Else Statement 00:10:00 Worksheet Functions inside VBA 00:08:00 Creating User Defined Functions 00:09:00 User Defined Functions within VBA Scripts 00:06:00 Unit 24: Important VBA Tools and Logic Find Last Row of Data 00:06:00 Find Last Column of Data 00:03:00 With Statement 00:05:00 Debugging & Error Handling 00:07:00 Debugging & Error Handling Cont. 00:07:00 Unit 25: Excel VBA Loop For Next Loop 00:09:00 Do Until Loop 00:06:00 For Each Loop 00:04:00 Unit 26: Triggering Macros Assigning Macros to Shapes 00:04:00 Form Controls vs ActiveX Controls 00:08:00 Worksheet Events 00:04:00 Workbook Events 00:03:00 Fun with VBA Events! 00:07:00 Unit 27: Excel User Forms Creating an Excel UserForm 00:03:00 Adding Controls to UserForms 00:10:00 How to Show an UserForm 00:03:00 Passing TextBox Values to Desired Cells 00:07:00 Passing Option Buttons to Desired Cells 00:07:00 UserForm ComboBoxes 00:08:00 Clearing Values from UserForm Controls 00:03:00 How to Close an UserForm 00:02:00 UserForms and Protected Sheets 00:05:00 Unit 28: Starting a Career in Excel Creating an Excel Resume 00:05:00 Getting Started with Freelancing 00:06:00 How to Become an Excel Freelancer 00:05:00 Top Freelance Websites 00:05:00 How to Get Your First Client 00:08:00 Personal Branding 00:07:00 Networking Do's and Don'ts 00:04:00 Importance of Having a Website 00:04:00 Resources Resources - Microsoft Excel 00:00:00