13269 Open courses in Liverpool delivered Online

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

What Will I Learn? Have theoretical knowledge on providing psychotherapy Understand various types of mental health disorders Have a knowledge on opening private practice and advertising Being aware of psychotherapeutic approaches and types The comprehensive Positive Psychiatry and Mental Health has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the Positive Psychiatry and Mental Health today, and learn from the very best the industry has to offer!

In the heart of every dog owner is the desire to offer optimal nutrition to their cherished companion. Venturing into the realm of raw diets opens up a world rich in benefits and holistic well-being for dogs. This course meticulously unravels every facet of raw feeding, presenting a well-rounded view of the topic.  Starting with the foundational philosophy of raw diets, learners progress to understanding detailed components, such as the BARF approach and the fine art of crafting balanced meals. Tailored for those keen on canine health, this comprehensive course ensures attendees emerge with a robust knowledge base, empowering them to make enlightened choices for their pet's nutritional journey.

Elevate your linguistic finesse and embark on a transformative journey into the realm of transcription. This course is your gateway to honing an indispensable skill that bridges the gap between spoken content and written documentation. From mastering the basics of transcription techniques to delving into advanced methods that equip you to tackle diverse content, you'll uncover the art of precision in language conversion. Navigating the intricacies of grammar and punctuation, you'll learn how to capture every nuance of spoken words accurately. As you explore various transcription specializations, you'll acquire insights into their unique demands, opening doors to diverse opportunities. Whether you're seeking to enhance your communication skills or lay the foundation for a fulfilling transcription career, this course empowers you to step confidently into the world of linguistic accuracy and professional transcription.

If you are trying to save money, embarrassed to have someone else wax private areas, fed up with paying so much salon prices, or simply just want to be independent and not rely on others, then this course is definitely for you. Whether you are a waxing professional or a complete novice, you will learn useful things on this course. Our DIY Self Waxing course focuses on covering the key areas of waxing such as legs, bikini line, and underarms. You will also learn about equipment needed (and where to find them), safety, the benefits of waxing, the hair growth cycle, aftercare advice, potential problems and how to overcome them. The cost of this course is equivalent to the price of just one of your salon waxing sessions, which means that you'll start saving money within just a couple of months. Gain the knowledge to be self-sufficient, and wax at a time that suits you, rather than being limited to salon opening hours and availability

🌟 Unlock Your Potential: Youth Counseling Certification Course 🌟 Are you passionate about making a positive impact on the lives of young people? Do you dream of becoming a trusted guide, mentor, and source of support for today's youth? It's time to turn your passion into a profession with our comprehensive Youth Counseling Certification Course!   🔑 Why Choose Our Youth Counseling Certification Course? ✨ Expert-Led Learning: Join a course developed and led by seasoned professionals in the field of youth counseling. Gain insights from experienced counselors who have successfully navigated the challenges of guiding and supporting young minds. 🌐 Accessible Anytime, Anywhere: Our online platform allows you to learn at your own pace and from the comfort of your home. Access high-quality content, engaging lectures, and interactive discussions 24/7. 🤝 Practical Skills Development: Acquire hands-on skills that go beyond theory. Our course is designed to equip you with practical tools, techniques, and real-world scenarios to enhance your counseling abilities. 🎓 Internationally Recognized Certification: Upon successful completion of the course, receive a prestigious Youth Counseling Certification that opens doors to a multitude of career opportunities globally. 🚀 Career Advancement: Whether you're just starting in the field or looking to advance your career, our certification will give you a competitive edge. Stand out as a qualified and compassionate youth counselor in a growing industry.   🌈 Comprehensive Curriculum: Understanding Adolescent Development Effective Communication Strategies Building Trust and Rapport Addressing Mental Health Challenges Conflict Resolution and Crisis Intervention Cultural Competency in Youth Counseling Ethical Considerations in Counseling   Lifetime Access: Enjoy continuous access to course updates and materials even after completion.   💡 Invest in Your Future: Enroll now and embark on a fulfilling journey toward becoming a certified youth counselor. Your investment in this course is an investment in the well-being and success of the next generation.   Ready to make a difference? Start your Youth Counseling Certification Course today and empower the youth of tomorrow! 🌟 Course Curriculum Youth Counselling CCA Programme Overview 01:40 CCA Introduction to Counselling 03:34 CCA Introduction to Child Psychology 03:03 CCA Cognitive Development 03:56 CCA Socio-Emotional Development 06:49 CCA Socio-cultural factors in a child's development 02:43 CCA Child therapy and counselling - General Guidelines 01:18 CCA Opening a Session 04:00 CCA Rapport-Building 09:02 CCA Reflection 02:11 CCA Paraphrasing 02:31 CCA Focusing 03:51 CCA Assessment 02:46 CCA Appropriate Questioning 04:56 CCA Counselling Process 03:57 CCA Behavioral Problems in Children 02:54 CCA Bullying and Child Abuse 02:21 CCA Stress in Children 02:09 CCA Children after Separation 02:06 CCA Children in Depression 03:07

Course Overview Discover new levels of self-awareness and show conviction in your beliefs and values when you take this training to Become the Best Version of Yourself. It's all too easy to let life and events change our characteristics or for us to put up a façade that hides our true feelings. Move away from that behaviour by taking this inspiring course that empowers you to feel your best, live your life as you want to, and be a better person. This Personal Improvement tutorial specifically looks at the way that we perceive ourselves and how we can do this in a more positive way. You will be taught how to be 'authentic', perform activities that you want to do without feeling judged or uncomfortable, live the lifestyle that you have chosen, interact with other individuals in a natural way, and so much more. This is an eye-opening journey into the truth of oneself and how being honest about your feelings leads to new kinds of personal freedom. Enrol now and start living the life you deserve. This best selling Become the Best Version of Yourself has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Become the Best Version of Yourself is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Become the Best Version of Yourself is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Become the Best Version of Yourself is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Become the Best Version of Yourself, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Become the Best Version of Yourself will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Become the Best Version of Yourself to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email. 

Course Overview Discover how to boost a fledgling company and make the most of its potential by taking this course on how to Start A T-Shirt Business: Using Merch By Amazon, Teespring & More. T-shirts are, and always will be, the premier garments for new designers and entrepreneurs in the fashion industry. With help from this training, you will be able to take advantage of available opportunities and build a trending brand name for yourself. This valuable Business Management tutorial provides step-by-step explanations and critical information about engaging potential vendors and merchandisers for your products. You will be shown how to create effective commercial strategies with the help of expert guidance and tuition in this field. Completing the course will boost your trade awareness and business-building abilities to new levels, opening more doors for you in this exciting profession. This best selling Start A T-Shirt Business | Merch By Amazon, Teespring & More has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Start A T-Shirt Business | Merch By Amazon, Teespring & More is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Start A T-Shirt Business | Merch By Amazon, Teespring & More is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Start A T-Shirt Business | Merch By Amazon, Teespring & More is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Start A T-Shirt Business | Merch By Amazon, Teespring & More, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Start A T-Shirt Business | Merch By Amazon, Teespring & More will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Start A T-Shirt Business | Merch By Amazon, Teespring & More to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Unlock Your Potential with Forklifting Mastery! 🏗️ Are you ready to elevate your skills and unlock new career opportunities? Welcome to Forklifting, your gateway to mastering the art of operating forklifts with precision and safety. 🚀 Why Choose Forklifting? Forklifting isn't just about lifting heavy loads; it's about mastering a crucial skill that opens doors to various industries. Whether you're looking to enhance your job prospects, improve workplace safety, or advance your current career, mastering forklifting techniques is an invaluable asset. Our comprehensive Forklifting course provides you with the knowledge, skills, and confidence to operate forklifts efficiently and safely in diverse work environments. From warehouses to construction sites, the demand for skilled forklift operators is on the rise, making this course a strategic investment in your professional future. Benefits of Taking Our Forklifting Course: Safety First: Learn essential safety protocols and best practices to ensure a secure working environment for yourself and others. Efficiency Boost: Master efficient forklift operation techniques to streamline workflow processes and maximize productivity in various industries. Career Advancement: Gain a competitive edge in the job market by acquiring valuable forklifting skills that are in high demand across industries. Increased Employability: Enhance your employability and job opportunities by adding a sought-after skill set to your resume. Confidence in Operation: Build confidence in your ability to operate forklifts in diverse settings, from warehouses to construction sites. Who is this for? New Entrants: Individuals looking to enter the logistics, construction, or manufacturing industries. Existing Workers: Current workers seeking to enhance their skill set and advance their careers. Employers: Companies aiming to improve workplace safety standards and boost operational efficiency. Career Path: The Forklifting course opens the doors to various career paths, including: Forklift Operator: Become a certified forklift operator in warehouses, distribution centers, and construction sites. Logistics Coordinator: Apply your forklifting skills in logistics and supply chain management roles. Warehouse Supervisor: Progress into supervisory or managerial positions within warehouse and distribution operations. Construction Crew Member: Contribute to construction projects as a skilled forklift operator. FAQ: Q: Is prior experience required to enroll in the Forklifting course? A: No prior experience is necessary. Our course is designed to accommodate beginners and experienced individuals alike. Q: What certification will I receive upon completion of the Forklifting course? A: Upon successful completion of the course, you will receive a Forklift Operator Certification, recognized by industry standards. Q: How long does it take to complete the Forklifting course? A: The duration of the course may vary depending on the program structure and individual learning pace. However, most courses typically range from a few days to a few weeks. Q: Will I learn about forklift maintenance and troubleshooting in the course? A: While the primary focus of the course is on forklift operation and safety, basic maintenance and troubleshooting techniques may be covered to ensure a well-rounded understanding of forklift operation. Q: Is the Forklifting course available online? A: Yes, many institutions offer online Forklifting courses to accommodate learners' schedules and preferences. However, practical hands-on training may also be required for comprehensive skill development. Q: Are there job placement services available after completing the Forklifting course? A: Some institutions may offer job placement assistance or resources to help students connect with potential employers. Be sure to inquire about specific services offered by the institution you choose. Start Your Forklifting Journey Today! Don't miss out on the opportunity to enhance your career prospects and become a proficient forklift operator. Enroll in our Forklifting course today and take the first step towards a rewarding career in logistics, construction, or manufacturing. Invest in your future with Forklifting mastery! 🌟 Course Curriculum Module 1_ Introduction to Forklifts Introduction to Forklifts 00:00 Module 2_ Forklift Safety Precautions Forklift Safety Precautions 00:00 Module 3_ Forklift Attachments and Special Considerations Forklift Attachments and Special Considerations 00:00 Module 4_ Forklift Stability and Tipping Hazards Forklift Stability and Tipping Hazardst 00:00 Module 5_ Forklift Refuelling and Battery Charging Procedures Forklift Refuelling and Battery Charging Procedures 00:00 Module 6_ Forklift Maintenance and Inspections Forklift Maintenance and Inspections 00:00

🌟 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