12526 Courses delivered Online

3 QLS Endorsed Diploma | QLS Hard Copy Certificate Included | Plus 10 CPD Courses | Lifetime Access

This Access 2016 Intermediate is specially designed for you if you are thinking to take your Microsoft Access skills to the next level. Through the course, you'll master more advanced techniques for this powerful database program and build an entire database project from scratch.  From building reports to using conditional formatting, you'll see how to present your data and gain techniques for using Visual Basic to automate common tasks. You will learn to design tables for improved accuracy in data entry by setting default values and restricting data entry, review the various options to share data with other applications, including Word and Excel, learn about Action Queries to automate updating, appending and deleting table data, and review various advanced query techniques such as using Query Joins, Parameter queries, working with totals and Crosstab queries. Finally, you'll build a navigation form to make it easy for your users to find their way around your database.  What Will I Learn? Design Tables for Better Data Entry Share Data with Other Applications Work with Action Queries Advanced Query Techniques Automate Processes with Macros Advanced Forms Advanced Report Techniques Requirements Access 2016 Introduction or equivalent experience. Who is the target audience? Students who want to take Access to the next level and improve their database design skills. Introduction Introduction FREE 00:01:00 Designing Tables for Better Data Entry Reviewing Table Design Principles 00:04:00 Setting Field Size, Formats and Captions 00:06:00 Setting Default Value and Required Fields 00:03:00 Restricting Data Entry Using Data Validation 00:02:00 Restricting Data Entry Using Input Masks 00:06:00 Sharing Data with Other Applications Exporting Tables and Queries to Excel 00:03:00 Importing Data from a TXT File 00:03:00 Importing Data from Excel 00:02:00 Exporting Data to a TXT File 00:02:00 Linking External Data Sources 00:03:00 Using Word Merge 00:02:00 Working with Action Queries What are Action Queries 00:02:00 Creating an Update Query 00:02:00 Creating an Append Query 00:03:00 Creating a Delete Query 00:02:00 Creating a Make Table Query 00:02:00 Changing the Start Number of an Auto Number Field 00:03:00 Advanced Query Techniques Creating Query Joins 00:05:00 Creating Find Unmatached and Find Duplicate Queries 00:03:00 Creating Parameter Queries 00:04:00 Using -Like- Keyword in Parameter Queries 00:02:00 Creating a Top X Query 00:02:00 Reviewing Calculated Query Fields 00:03:00 Summarizing Query Data with Totals 00:03:00 Inserting Where Statements in Summary Queries 00:01:00 Creating a Crosstab Query 00:03:00 Automating Processes with Macros Understanding Macro Basics 00:06:00 Creating Macros to Open Forms by Record 00:04:00 Validating Data Entry with Macros 00:04:00 Creating a Macro to Automate Data Entry 00:03:00 Advanced Data Entry Using Macros and DLOOKUP Function 00:06:00 Advanced Form Using Conditional Formatting 00:02:00 Organizing Form Fields with Tab Controls 00:03:00 Creating a Combo Box Control 00:02:00 Creating an Option Group Control 00:03:00 Using a Subform to Show Data from a Related Table 00:03:00 Advanced Report Techniques Inserting a Chart on a Report 00:03:00 Showing Data in Columns 00:02:00 Inserting a Subreport 00:02:00 Configuring Reports with Parameter Queries 00:04:00 Sending Reports 00:02:00 Conclusion Course Recap 00:01:00 Resources Resources - Access 2016 Intermediate 00:00:00 Course Certification

🚀 Unlock Your Career Potential with Essential Career Soft Skills Course! 🚀 Are you ready to take your career to the next level? Do you want to stand out in today's competitive job market? Look no further! Our Essential Career Soft Skills course is here to empower you with the essential tools and techniques needed to thrive in any professional environment.   🔍 What are Soft Skills? Soft skills are the backbone of successful careers. Unlike technical skills, which are job-specific and can be taught through formal education or training, soft skills are the interpersonal attributes that enable individuals to effectively navigate their professional lives. From communication and teamwork to problem-solving and adaptability, soft skills play a pivotal role in shaping one's career trajectory.   💼 Why are Soft Skills Essential for Career Success? In today's dynamic workplace, employers increasingly prioritize soft skills when making hiring and promotion decisions. While technical proficiency is undoubtedly important, it is often soft skills that set exceptional candidates apart from the rest. Employers value individuals who can communicate effectively, collaborate seamlessly with colleagues, and adapt to new challenges with ease. By honing your soft skills, you not only enhance your professional credibility but also open doors to new opportunities for career advancement. Whether you're aiming for a leadership role, seeking to switch industries, or striving to excel in your current position, mastering essential soft skills is key to unlocking your full potential.   🎯 What Will You Learn? Our Essential Career Soft Skills course is designed to equip you with the practical knowledge and expertise needed to excel in today's fast-paced work environment. Through a series of interactive lessons, case studies, and real-world scenarios, you'll develop proficiency in the following areas: Communication: Learn how to articulate your ideas clearly, listen actively, and convey information effectively in various professional contexts. Teamwork: Discover strategies for building and leading high-performing teams, fostering collaboration, and resolving conflicts constructively. Adaptability: Cultivate resilience and flexibility to navigate change, embrace innovation, and thrive in dynamic work environments. Problem-Solving: Develop critical thinking skills, identify root causes of complex problems, and implement strategic solutions. Time Management: Master techniques for prioritizing tasks, managing deadlines, and optimizing productivity to achieve your professional goals.   Who is This For? Our Essential Career Soft Skills course is suitable for professionals at all stages of their careers, from entry-level employees to seasoned executives. Whether you're a recent graduate entering the workforce for the first time or a seasoned professional looking to sharpen your skill set, this course offers valuable insights and practical strategies to help you succeed.   Career Path Upon completing the Essential Career Soft Skills course, you'll be equipped with the foundational skills and knowledge needed to excel in a wide range of professional roles and industries. Whether you aspire to climb the corporate ladder, launch your own business venture, or pursue a career in academia, the soft skills you acquire in this course will serve as a solid foundation for your future success.   FAQs Q: Is this course suitable for beginners? A: Absolutely! Our Essential Career Soft Skills course is designed to accommodate learners of all levels, from beginners to seasoned professionals. Whether you're just starting your career journey or looking to enhance your existing skill set, you'll find valuable insights and practical strategies to help you succeed. Q: How long does it take to complete the course? A: The duration of the course varies depending on your individual pace and learning preferences. On average, most participants complete the course within [insert estimated duration]. However, you're free to progress through the material at your own pace and revisit lessons as needed. Q: Will I receive a certificate upon completion of the course? A: Yes, upon successfully completing the Essential Career Soft Skills course, you'll receive a certificate of completion to showcase your newfound expertise and commitment to professional development. This certificate can be shared with employers, included on your resume, or displayed on professional networking platforms to enhance your credibility and marketability. Q: Is there any prerequisite knowledge required to enroll in the course? A: No prior experience or prerequisite knowledge is required to enroll in the Essential Career Soft Skills course. Our curriculum is designed to be accessible to learners of all backgrounds and experience levels, ensuring that everyone can benefit from the valuable insights and practical strategies offered in the course.   Don't miss this opportunity to invest in yourself and take your career to new heights! Enroll in our Essential Career Soft Skills course today and embark on a journey toward professional excellence. Unlock your potential and seize the opportunities that await you in the dynamic world of work! 🌟 Course Curriculum Module 1 Communication Skills and Productivity. Communication Skills and Productivity. 00:00 Module 2 Teamwork and Problem Solving. Teamwork and Problem Solving. 00:00 Module 3 Adaptability and Interpersonal Skills. Adaptability and Interpersonal Skills. 00:00 Module 4 Innovation and Conflict Resolution. Innovation and Conflict Resolution. 00:00 Module 5 Financial Literacy and Professional Etiquette. Financial Literacy and Professional Etiquette. 00:00

Revit face to face training customised and bespoke. Online or Face to Face

Sketchup face to face training customised and bespoke.

As you look out of your window, you see the intricate details of the buildings around you. Each line, each curve, and each shape holds a story, a narrative that only a skilled draughtsman can weave. If you've ever wanted to master the art of architectural drawing, then the Draughtsman Training bundle is for you. This Draughtsman training bundle features 11 CPD-certified courses that cover a wide range of topics. From CAD Design to Building Design and Construction, this bundle has everything you need to become a skilled draughtsman. With this knowledge, you can take your career to new heights. Whether you're a seasoned professional or just starting, the Draughtsman Training bundle can help you develop the skills and expertise you need to succeed. You'll learn how to design with precision and accuracy, how to programme and automate your work, and how to create buildings and spaces that are both beautiful and functional. Best of all, you'll receive a hardcopy CPD certificate for free with your first course. This Draughtsman certificate is a testament to your commitment to your career, and it can help you stand out in a crowded job market. So why wait? Enrol in the Draughtsman Training bundle today and take your first step towards becoming a skilled draughtsman! Learning Outcomes of Draughtsman Training: Master the use of CAD design tools for building structures and civil drawings Understand AutoCAD VBA programming to automate your work process Apply AutoCAD to Excel VBA programming in your daily work Gain knowledge on the Construction Industry Scheme and its application in the construction field Explore the WELL Building Standard and its significance in creating sustainable and healthy buildings Acquire architectural studies knowledge, including the history of architecture, design theories and principles Design interior and exterior spaces using Revit Architecture Develop an in-depth understanding of the LEED v4 building design and construction process This Draughtsman Bundle Consists of the following Premium courses: Course 01: Level 5 CAD Designer Training Course 02: CAD Design Course: Assemblies, Modelling And Civil Drawings Course 03: AutoCAD VBA Programming - Beginner course Course 04: AutoCAD to Excel - VBA Programming Hands-On! Course 05: Construction Industry Scheme (CIS) Course 06: WELL Building Standard Course 07: Architectural Studies Course 08: Revit Architecture Ultimate Interior Design Course Course 09: Revit Architecture Ultimate Exterior Design for Beginners Course 10: Revit Architecture Advanced Exterior Design Course Course 11: LEED V4: Building Design and Construction Enrol now in Draughtsman to advance your career and use the premium study materials from Apex Learning. The Draughtsman bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Draughtsman expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn from any place in your own time without travelling for classes. How will I get my Microsoft Office with Draughtsman Certificate? After successfully completing the Draughtsman bundle you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Draughtsman bundle. Requirements Our Draughtsman is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This Draughtsman course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this Draughtsman course, it can be studied in your own time at your own pace. Career path Having this Draughtsman expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Level 5 CAD Designer Training) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Get ready for an exceptional online learning experience with the Trading & Investment (Stock Trading, Forex, Analysis, Day, Penny Stock) bundle! This carefully curated collection of 20 premium courses is designed to cater to a variety of interests and disciplines. Dive into a sea of knowledge and skills, tailoring your learning journey to suit your unique aspirations. This Trading & Investment (Stock Trading, Forex, Analysis, Day, Penny Stock) is a dynamic package, blending the expertise of industry professionals with the flexibility of digital learning. It offers the perfect balance of foundational understanding and advanced insights. Whether you're looking to break into a new field or deepen your existing knowledge, the Trading & Investment package has something for everyone. As part of the Trading & Investment (Stock Trading, Forex, Analysis, Day, Penny Stock) package, you will receive complimentary PDF certificates for all courses in Trading & Investment bundle at no extra cost. Equip yourself with the Trading & Investment bundle to confidently navigate your career path or personal development journey. Enrol our Trading & Investment bundle today and start your career growth! This Trading & Investment Bundle Comprises the Following CPD Accredited Courses: Course 01: Stock Market Investing for Beginners Course 02: Forex Trading Diploma Course 03: Investment Course 04: Technical Analysis Masterclass for Trading & Investing Course 05: Complete Swing Trading Training Course 06: Trading - Gold Trading Course 07: Cryptocurrency: Wallets, Investing & Trading Course 08: Trading and Financing: Candlestick Pattern Course 09: Stock Trading Analysis with Volume Trading Course 10: Stock Market Day Trading Strategies Course 11: Penny Stocks Trading Course 12: Day Trade Stocks with Price Action and Tape Reading Strategy Course 13: Capital Budgeting & Investment Decision Rules Course 14: Investment Banking: Venture Capital Fundraising for Startups Course 15: Anti-Money Laundering (AML) Training Course 16: Risk Management Course 17: Financial Ratio Analysis for Business Decisions Course 18: Data Analysis and Forecasting in Excel Course 19: Microsoft Excel Complete Course 2019 Course 20: Decision-Making and Critical Thinking Learning Outcome: By completing the Trading & Investment (Stock Trading, Forex, Analysis, Day, Penny Stock) course, you will: Gain comprehensive insights into multiple fields. Foster critical thinking and problem-solving skills across various disciplines. Understand industry trends and best practices through the Trading & Investment Bundle. Develop practical skills applicable to real-world situations. Enhance personal and professional growth with the Trading & Investment Bundle. Build a strong knowledge base in your chosen course via the Trading & Investment Bundle. Benefit from the flexibility and convenience of online learning. With the Trading & Investment package, validate your learning with a CPD certificate. Each course in Trading & Investment (Stock Trading, Forex, Analysis, Day, Penny Stock) bundle holds a prestigious CPD accreditation, symbolising exceptional quality. The materials, brimming with knowledge, are regularly updated, ensuring their relevance. This bundle promises not just education but an evolving learning experience. Engage with this extraordinary collection, and prepare to enrich your personal and professional development. Embrace the future of learning with Trading & Investment (Stock Trading, Forex, Analysis, Day, Penny Stock), a rich anthology of 15 diverse courses. Each course in the Trading & Investment bundle is handpicked by our experts to ensure a wide spectrum of learning opportunities. This Trading & Investment (Stock Trading, Forex, Analysis, Day, Penny Stock) bundle will take you on a unique and enriching educational journey. The bundle encapsulates our mission to provide quality, accessible education for all. Whether you are just starting your career, looking to switch industries, or hoping to enhance your professional skill set, the Trading & Investment (Stock Trading, Forex, Analysis, Day, Penny Stock) bundle offers you the flexibility and convenience to learn at your own pace. Make the Trading & Investment package your trusted companion in your lifelong learning journey. CPD 210 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Trading & Investment (Stock Trading, Forex, Analysis, Day, Penny Stock) bundle is perfect for: Lifelong learners looking to expand their knowledge and skills. Professionals seeking to enhance their career with CPD certification. Individuals wanting to explore new fields and disciplines. Anyone who values flexible, self-paced learning from the comfort of home. Requirements Without any formal requirements, you can delightfully enrol this Trading & Investment (Stock Trading, Forex, Analysis, Day, Penny Stock) course. Career path Unleash your potential with the Trading & Investment (Stock Trading, Forex, Analysis, Day, Penny Stock)bundle. Acquire versatile skills across multiple fields, foster problem-solving abilities, and stay ahead of industry trends. Ideal for those seeking career advancement, a new Certificates Certificate Of Completion Digital certificate - Included Certificate Of Completion Hard copy certificate - Included You will get a complimentary Hard Copy Certificate.

Are you looking to enhance your Sports Leadership & Management skills? If yes, then you have come to the right place. Our comprehensive courses on Sports Leadership & Management will assist you in producing the best possible outcome by learning the Sports Leadership & Management skills. This Bundle Includes Course 01: Leadership and Management Level 7 Course 02: Sports Coaching Diploma Course 03: Motivation Skills Course 04: Sports Nutrition for Sports and Fitness Course 05: Healthy Fitness Course 06: Nutritional Therapy So, enrol in our Sports Leadership & Management bundle now! Other Benefits Lifetime Access to All Learning Resources An Interactive, Online Course A Product Created By Experts In The Field Self-Paced Instruction And Laptop, Tablet, And Smartphone Compatibility 24/7 Learning Support Free Certificate After Completion Learn at your own pace from the comfort of your home, as the rich learning materials of this course are accessible from any place at any time. The curriculums are divided into tiny bite-sized modules by industry specialists. And you will get answers to all your queries from our experts. So, enrol and excel in your career with Compliance Central. Curriculum Breakdown of Leadership and Management Level 7 Module 01: Understanding Management and Leadership Module 02: Leadership Theories Module 03: Improving Management and Leadership Performance Module 04: High Performance Teams Module 05: Motivating Employees Module 06: Organisational Skills Module 07: Talent Management Module 08: Succession Planning Module 09: Business Process Management Module 10: Communication Skills Module 11: Negotiation Techniques Module 12: Managing Meetings and Giving Feedback Module 13: Managing Change Module 14: Time Management Module 15: Stress Management Module 16: Emotional Intelligence in Leadership Module 17: Managing Conflict Module 18: Dealing with Office Politics Module 19: Risk Management Module 20: Corporate Responsibility and Ethics Module 21: Microsoft Word, Excel, PowerPoint CPD 60 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this bundle. Requirements To enrol in this Sports Leadership & Management, all you need is a basic understanding of the English Language and an internet connection. Career path After completing this course, you can explore trendy and in-demand jobs related to Sports Leadership & Management. Certificates CPD Accredited PDF Certificate Digital certificate - Included 6 CPD Accredited PDF Certificate for Free. CPD Accredited Hard Copy Certificate Hard copy certificate - £9.99 CPD accredited hard copy certificates are available for £9.99 each Delivery Charge for Each Hard Copy Certificates: Inside the UK: £3.99 Outside of the UK: £9.99

Our OISC Level 1 training course is designed as a two-day, entry-level course, offering participants an introduction into Immigration Advice. In this course, we aim to cover the syllabus at level one, as according to OISC standards. View the OISC Level 1 course dates below, delivered on Microsoft Teams. Course Overview:   Our OISC Level 1 Training Course, your gateway to comprehensive knowledge in Immigration, EU, and Asylum law. Our course is specifically designed to equip participants with the fundamental understanding needed to excel in the level one assessments, with a strong focus on fulfilling the core requirements set by the OISC (Office of the Immigration Services Commissioner). Designed as a comprehensive two-day entry-level course, it serves as an excellent introduction to Immigration Advice. Our aim is to cover the level one syllabus prescribed by the OISC, ensuring that you meet the standards set by the regulatory body. By enrolling in our OISC Level 1 training course, you’ll gain the essential knowledge, skills, and confidence required to navigate the complex world of immigration law effectively. Whether you’re looking to launch a career in immigration advice or seeking to enhance your existing expertise, this course will lay a solid foundation for your professional journey. Don’t forget to check out ourExam Technique Training (Level 1) which is designed to help prepare learners for their accreditation exam. Are you interested in setting up your own OISC law firm? Join our Setting Up An OISC Firm course, where you’ll learn the requirements, processes and key information about running a firm as well as receive handy resources and materials. Course joining links, materials and instructions are sent out 24hours before the course starts. What is included in the OISC Level 1 Syllabus? Based on the latest syllabus, published by the Office of the Immigration Services Commissioner, the OISC Level 1 Training Course covers the following: Analysis of the structures, terminology, ethical practices and frameworks of immigration law Asylum and protection law European Economic Area (EEA) free movement law British Naturalisation and British Citizenship registration Business immigration law Appeals process and structures of the Asylum and Immigration Tribunal Join over 92% of satisfied customers who found their training with IAS useful and beneficial. You will also be provided with training materials to keep after completing the course. How is the OISC Level 1 exam structured? The OISC Level 1 exam is structured into two parts: The first part comprises 20 multiple-choice questions. You have 1 hour and 15 minutes to complete this section of your OISC exam. There is only one correct answer for each question. The second part presents different scenario-based questions to be answered within 1 hour and 15 minutes. You should provide answers which are legible and written clearly in plain English. Detailed instructions on how to complete each section of your OISC Level 1 exam will be provided during the course, to ensure that each candidate is adequately prepared to pass the test.

Description: Customer service is an essential part of any business. Companies always look for the people who have the strong command over handling customer issues. With the help of the Customer Service Training - Complete Video Course, you gain mastery over customer service skills. The bundle video course covers all the necessary parts that a person should know for managing the customer service. For understanding the skill properly, the course is divided into several sections and sub-sections. Firstly, in the Customer Service Skills part, you will be introduced to the fundamentals of customer service including the telephone etiquette. Then, you will learn about the communication procedures in the Communication Essential sections. You will learn about the different types of communication covering business communication, verbal and non-verbal communication, written and electrical communication, etc. Next section is Time Management- one of the best and most efficient parts of any business. Here, you will know the tips and techniques for managing time properly. After that, you will be introduced to the Microsoft Office Word and Microsoft Office Excel. These are two necessary skills that every employee should know for managing the customer service properly. You will learn to use these two applications. Finally, it can be said that the Customer Service Training - Complete Video Course course helps you to achieve the necessary skills for grabbing the attention of the customers with proper etiquette and create a long-term relationship with them. 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? Customer Service Training - 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 Customer Service Training - 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. Understanding Customer Service Understanding Customer Service FREE 00:17:00 Identifying Customer Expectations 00:06:00 Providing Excellent Customer Service 00:07:00 Focusing on the Customer Focusing on the Customer 00:08:00 Customer Service and the Telephone Customer Service and the Telephone 00:08:00 Handling Complaints Handling Complaints 00:12:00 Enduring Stress Enduring Stress 00:13:00 Business Communication Identifying Basic Communication Techniques FREE 00:09:00 Formal and Informal Communication 00:02:00 Verbal and Non-verbal Communication Describing Verbal and Non-verbal Communication 00:04:00 Understanding Body Language 00:05:00 Making Effective Presentations 00:10:00 Fundamentals of Productive Meetings 00:08:00 Written Communication Written Communication 00:13:00 Electronic Communication Electronic Communication 00:19:00 Communicating with Graphics Creating Graphics for Business Communication 00:04:00 Communicating Static Information 00:03:00 Communicating Dynamic Information 00:03:00 Effectively Working for Your Boss Representing Your Boss 00:06:00 Communicating Your Boss's Decisions 00:03:00 Supporting Your Boss and Colleagues 00:04:00 Building a Partnership with Your Boss 00:13:00 Identifying Goals Identifying Goals FREE 00:10:00 Effective Energy Distribution Energy Distribution 00:09:00 Time Logs 00:11:00 Working with Your Personal Style Personal World View 00:10:00 Strengths 00:09:00 Building Your Toolbox A Building Your Toolbox 00:10:00 Establishing Your Action Plan Establishing Your Action Plan 00:11:00 Getting Started with Word Navigate in Microsoft Word FREE 00:12:00 Create and Save Word Documents 00:24:00 Manage Your Workspace 00:06:00 Edit Documents 00:16:00 Preview and Print Documents 00:04:00 Customize the Word Environment 00:08:00 Formatting Text and Paragraphs Apply Character Formatting 00:17:00 Control Paragraph Layout 00:19:00 Align Text Using Tabs 00:07:00 Display Text in Bulleted or Numbered Lists 00:03:00 Apply Borders and Shading 00:04:00 Working More Efficiently Make Repetitive Edits 00:06:00 Apply Repetitive Formatting 00:10:00 Use Styles to Streamline Repetitive Formatting Tasks 00:14:00 Managing Lists Sort a List 00:05:00 Format a List 00:06:00 Adding Tables Insert a Table 00:07:00 Modify a Table 00:06:00 Format a Table 00:03:00 Convert Text to a Table 00:04:00 Inserting Graphic Objects Insert Symbols and Special Characters 00:04:00 Add Images to a Document 00:11:00 Controlling Page Appearance Apply a Page Border and Color 00:03:00 Add Headers and Footers 00:06:00 Control Page Layout 00:05:00 Add a Watermark 00:04:00 Preparing to Publish a Document Check Spelling Grammar and Readability 00:07:00 Use Research Tools 00:06:00 Check Accessibility 00:03:00 Save a Document to Other Formats 00:04:00 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 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00