Microsoft Office Excel is a great tool used to create and format spreadsheets. Spreadsheets allow you to organise information in rows and tables and analyse it with automatic mathematics. Spreadsheets are also very commonly used to perform various types of calculations. Regardless of whether you are completely new to Excel or upgrading from an older version, this Excel 2007 course will empower you with the knowledge and skills necessary to be a proficient user. We have incorporated years of experience, knowledge and teaching techniques to create an easy-to-use course that can be customised to meet your personal learning needs. Course Highlights Accredited Diploma in Microsoft Excel 2007 is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Accredited Diploma in Microsoft Excel 2007 into 26 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 22 hours, 30 minutes hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Accredited Diploma in Microsoft Excel 2007 Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Accredited Diploma in Microsoft Excel 2007 is CPD certified and IAO accredited. 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 backgrounds. Requirements Our Accredited Diploma in Microsoft Excel 2007 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 You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Microsoft Excel 2007 for Beginners Module One - Getting Started 01:00:00 Module Two - Opening and Closing Excel 01:00:00 Module Three - Your First Worksheet 01:00:00 Module Four - Working with Excel Files 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Printing Excel Data 01:00:00 Module Seven - Building Formulas 01:00:00 Module Eight - Using Excel Functions 01:00:00 Module Nine - Using Time Saving Tools 01:00:00 Module Ten - Formatting your Data 01:00:00 Module Eleven - More Formatting 01:00:00 Module Twelve - Wrapping Up 00:30:00 Microsoft Excel 2007 Advanced Level Module One - Getting Started 00:30:00 Module Two - SmartArt 01:00:00 Module Three - Inserting Objects 01:00:00 Module Four - Creating Charts 01:00:00 Module Five - Creating Pivot Tables 01:00:00 Module Six - Working with Pivot Tables 01:00:00 Module Seven - Creating Pivot Charts 01:00:00 Module Eight - Solving Formula Errors 01:00:00 Module Nine - Using What-If Analysis 01:00:00 Module Ten - Managing Your Data 01:00:00 Module Eleven - Grouping and Outlining Data 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities-Accredited Microsoft Excel 2007 for Beginners 00:00:00 Activities-Microsoft Excel 2007 Advanced Level CPD & IAO Accredited- CPD Accredited 00:00:00 Mock Exam Final Exam
Data has become the most important resource for every organisation – but the insights gained from data analysis will only ever be truly valuable if they can be clearly expressed to other people. This course is for anybody who works with data, and needs to communicate the meaning that's in the numbers to colleagues, customers, bosses or external stakeholders. It will give you or your team the confidence and skills to translate raw data into compelling visual stories for your key audiences. The principles and skills covered apply to the simplest PowerPoint chart, to more complex interactive visualisations. We’ll work with you before the course to ensure that we understand your organisation and what you’re hoping to achieve. Sample learning content Session 1: What makes a great data-driven story The key elements of a successful infographic or presentation. Industry best practice, and discussion of good (and bad) examples. A simple framework for identifying the Audience, Story and Action. Session 2: Data in context How to balance function and aesthetic appeal. Identifying the right graph, chart, infographic or other visual. Framing the data and providing contextual information. Session 3: Designing for the human brain Using colours to add emphasis and meaning. Design and layout principles, and creating hierarchies of information. The principle of ‘self-sufficiency’, and removing clutter. Session 4: Navigation and narrative Tailoring visualisations for different types of communications. Structuring presentations and longer reports. Thinking in layers to create interactive dashboards. Delivery We deliver our courses over Zoom, to maximise flexibility. The training can be delivered in a single day, or across multiple sessions. All of our courses are live and interactive – every session includes a mix of formal tuition and hands-on exercises. To ensure this is possible, the number of attendees is capped at 16 people. Tutor Alan Rutter is the founder of Fire Plus Algebra. He is a specialist in communicating complex subjects through data visualisation, writing and design. He teaches for General Assembly and runs in-house training for public sector clients including the Home Office, the Department of Transport, the Biotechnology and Biological Sciences Research Council, the Health Foundation, and numerous local government and emergency services teams. He previously worked with Guardian Masterclasses on curating and delivering new course strands, including developing and teaching their B2B data visualisation courses. He oversaw the iPad edition launches of Wired, GQ, Vanity Fair and Vogue in the UK, and has worked with Condé Nast International as product owner on a bespoke digital asset management system for their 11 global markets. Testimonial “I was familiar with Alan’s work as a Guardian Masterclass instructor on data visualisation and digital journalism, which made it easy for me to recommend him for onsite training at the Liverpool School of Tropical Medicine. We had a large group of people interested in honing their abilities to depict their research and stories in engaging ways. Alan’s course provided great insight about common communication pitfalls and how to avoid them, how to become better communicators by understanding the audience diversity, and it showcased some great online tools for creating infographics. This should be mandatory training for all students, academics, report writers and those involved with conveying research to the media as it will help increase the clarity and accessibility of our own research stories.” Dr Lee Haines | Liverpool School of Tropical Medicine
Do you want to be an expert in e-mail management? Do you need to learn Microsoft Outlook? The course will teach you the basics about Microsoft Outlook. Course Description: Microsoft Outlook is a service offered by Microsoft. It is a part of Microsoft Office suite together with Microsoft Word, Microsoft Excel, Microsoft Access and Microsoft Power point. Microsoft Outlook offers free email and calendar services. It also allows you to take notes or set a reminder for your next program. The course will help you to know how to use the program. You will also learn how to customise the Outlook interface and how to use Quick Steps to automate regular actions. By the end of the course, you will be an expert user of Microsoft Outlook. Course Highlights Accredited Microsoft Outlook for Beginners is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Accredited Microsoft Outlook for Beginners into 13 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 11 hours, 40 minutes hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Accredited Microsoft Outlook for Beginners Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Accredited Microsoft Outlook for Beginners is CPD certified and IAO accredited. 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 backgrounds. Requirements Our Accredited Microsoft Outlook for Beginners 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 You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Module One - Getting Started FREE 00:30:00 Module Two - Opening and Closing Outlook FREE 01:00:00 Module Three - Understanding the Interface 01:00:00 Module Four - Working with the Message List and the Reading Pane 01:00:00 Module Five - Using Message List Commands 01:00:00 Module Six - Creating a New Email 01:00:00 Module Seven - Managing Email 01:00:00 Module Eight - Searching for Items 01:00:00 Module Nine - An Introduction to the Calendar 01:00:00 Module Ten - An Introduction to Tasks 01:00:00 Module Eleven - An Introduction to Contact 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities - Accredited Microsoft Outlook for Beginners 00:00:00 Mock Exam Mock Exam- Accredited Microsoft Outlook for Beginners 00:20:00 Final Exam Final Exam- Accredited Microsoft Outlook for Beginners 00:20:00
Elevate your professional journey with our Workplace Productivity Training course. In today's fast-paced work environment, productivity is the key to success. This course is your gateway to unlocking productivity's secrets. Discover effective ways to enhance your performance, from organizational skills and productive communication to time management and stress coping strategies. Whether you're a working professional, a student entering the job market, or an entrepreneur striving for efficiency, this course equips you with the tools and knowledge you need to excel in your career. Let's embark on this transformative journey towards workplace productivity together. Learning Outcomes Develop techniques to improve workplace productivity. Master organizational skills for enhanced efficiency. Communicate effectively in a professional setting. Harness the power of time management for increased output. Acquire conflict management skills for a harmonious workplace. Why choose this Workplace Productivity Training course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Workplace Productivity Training course for? Professionals seeking to boost their productivity. Students transitioning into the professional world. Entrepreneurs and business owners aiming for efficiency. Anyone looking to thrive in a competitive work environment. Individuals interested in personal and professional development. Career path Productivity Consultant: £30,000 - £60,000 Office Manager: £24,000 - £40,000 Time Management Coach: £25,000 - £45,000 Communication Specialist: £28,000 - £50,000 Stress Management Counselor: £26,000 - £45,000 Wellness Coordinator: £22,000 - £40,000 Prerequisites This Workplace Productivity Training does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Workplace Productivity Training was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Module 01: Ways to Improve Workplace Productivity Ways to Improve Workplace Productivity 00:39:00 Module 02: Organisational Skills to Improve Productivity Organisational Skills to Improve Productivity 00:19:00 Module 03: Productive Communication Skills in the Workplace Productive Communication Skills in the Workplace 00:27:00 Module 04: Time Management Time Management 00:35:00 Module 05: Conflict Management Conflict Management 00:18:00 Module 06: Health, Safety and Wellness in the Workplace Health, Safety and Wellness in the Workplace 00:27:00 Module 07: Managing Stress and Coping Anxiety in the Workplace Managing Stress and Coping Anxiety in the Workplace 00:14:00 Assignment Assignment - Workplace Productivity Training 00:00:00
Give a compliment to your career and take it to the next level. This Microsoft Project Training bundle will provide you with the essential knowledge to shine in your professional career. Whether you want to develop skills for your next job or elevate your skills for your next promotion, this Microsoft Project Training bundle will help you stay ahead of the pack. Throughout the Microsoft Project Training programme, it stresses how to improve your competency as a person in your chosen field while also outlining essential career insights in the relevant job sector. Along with this Microsoft Project Training course, you will get 10 premium courses, an originalhardcopy, 11 PDF certificates (Main Course + Additional Courses) Student ID card as gifts. This Microsoft Project Training Bundle Consists of the following Premium courses: Course 01: Planning & Control Using Microsoft Project 2013, 2016 & 2019 Course 02: Complete Microsoft Power BI 2021 Course 03: Project Management: Build a Project Charter Course 04: Project Management Skills for Manager Course 05: Operations Management Course 06: People Management Skills Level 3 Course 07: Performance Management Course 08: Business Analysis Level 3 Course 09: Enterprise Risk: Identification and Mitigation Level 2 Course 10: Leadership & Management Diploma Course 11: Level 2 Microsoft Office Essentials So what are you waiting for? Hurry up and get started now! Wondering what benefits are there of learning this 11-in-1 Microsoft Project Training bundle? Demonstrate your ability to plan & control Using Microsoft Project 2013, 2016 & 2019 versions. Evaluate how to create projects and templates, define calendars, adding and organise tasks using Outlining. Strengthen your knowledge of Microsoft Power BI 2021 and its features, including data transformation, creating a data model, data visualisation and many more. Understand Project Management and how to build a project charter and its fundamentals. Learn how to simplify the task of organising your team's work and make the experience easy. Enhance your skills in order to increase efficiency and reduce misunderstanding in your work. Investigate the principles of project management skills and the vital foundation to your success as a project manager. Explore the various operations management such as supply chain management, planning & forecasting operations, procurement & purchasing management. Acquaint yourself with business analysis planning and monitoring and the career prospect as a Business Analyst in the UK. Benefits you'll get choosing Apex Learning: Pay once and get lifetime access to 11 CPD courses Free e-Learning App for engaging reading materials & helpful assistance Certificates, student ID for the title course included in a one-time fee Free up your time - don't waste time and money travelling for classes Accessible, informative modules designed by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills Gain valuable experience without leaving your home How will I get my Certificate? After successfully completing the course 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) PS The delivery charge inside the UK is £3.99, and the international students have to pay £9.99. The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Microsoft Project Training 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. Curriculum: Course 01: Planning & Control Using Microsoft Project 2013, 2016 & 2019 Introduction Creating a Project Schedule Navigation and Setting the Options Creating Projects and Templates Defining Calendars Adding Tasks Organizing Tasks Using Outlining Formatting the Display Network Diagram View+ Constraints Filters Tables and Grouping Tasks Views and Details Printing and Reports Tracking Progress Creating Resources and Costs Assigning Resources and Costs to Tasks Resource Optimization Updating Projects with Resources CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Microsoft Project Training bundle. Requirements This Microsoft Project Training course has been designed to be fully compatible with tablets and smartphones. Career path Having this 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 (Planning & Control Using Microsoft Project) 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.
Domiciliary Care Finding out about domiciliary consideration is fundamental for anyone who either requires care for themselves or a friend or family member or might want to give a domiciliary consideration administration as an individual or an office. Domiciliary consideration is an undeniably well known choice to mind homes, however there is a ton of opposing data out there, and this course will give you a brief and exact guide. We cover the nuts and bolts of who requires domiciliary consideration, the different undertakings and duties included and the essential principles that should be clung to. You will likewise be made through a stride by-step manage on the most proficient method to apply for committee helped domiciliary consideration and how to source it secretly by means of organizations and prepared people. At long last, we give a total guide on the most proficient method to enroll as a domiciliary carer, either separately or as an organization, and take you through the compulsory administrative and useful strides to offer this support lawfully in the UK. You Will Learn Who requires domiciliary consideration, what it involves and the duties in question The central consideration principles that all carers need to know About sourcing chamber helped and private domiciliary consideration Instructions to legitimately give domiciliary consideration as an office or a person Advantages of Taking this Course You will guarantee the joy and strength of your friends and family You will actually want to begin a compensating home consideration business in a couple of simple advances You will save time and exertion by getting the right data with respect to home consideration You will maintain a strategic distance from the lawful results of not after the right domiciliary consideration methodology
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.
Course Description The Hospitality Management: Part 2 course is designed to give you a deeper understanding of different aspects of hospitality management. In this course, you are expected to learn about the arrival chronology, from greeting to check-in and check-out. You will be led through the procedures for the front office communications. In addition to that, the course will explain to you the role and functions of the Housekeeping department. You will also learn about the duties and responsibilities of a food and beverage manager. Doing this course will enable you to explain the importance of service quality in the hospitality sector. If all these sound good, enrol today and start learning! Learning outcome Learn about the arrival chronology Understand the procedures for the front office communications Know the role and functions of the Housekeeping department Explore the duties and responsibilities of a food and beverage manager Explain the importance of service quality in the hospitality sector How Much Do Restaurant Managers Earn? Senior - £32,000(Appx.) Average - £29,000(Appx.) Starting - £26,000(Appx.) Requirement Our Hospitality Management: Part 2 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. Hospitality Management: Part 2 Module 01: Management of Front Office Operations 00:16:00 Module 02: Management of Housekeeping, Engineering and Security Operations 00:24:00 Module 03: Management of Food and Beverage Operations 00:17:00 Module 04: Management of Service Quality in Hospitality Industry 00:17:00 Assignment Assignment - Hospitality Management: Part 2 00:00:00
Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents, and interests with our special Data Entry Administrator Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides the professional training that employers are looking for in today's workplaces. The Data Entry Administrator Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This Data Entry Administrator Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Data Entry Administrator Course, like every one of Skillwise's courses, is meticulously developed and well-researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At Skillwise, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from Skillwise, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Data Entry Administrator? Unlimited access to the course forever Digital Certificate, Transcript, and student ID are all included in the price Absolutely no hidden fees Directly receive CPD Quality Standard-accredited qualifications after course completion Receive one-to-one assistance every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Data Entry Administrator there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Data Entry Administrator course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skills. Prerequisites This Data Entry Administrator does not require you to have any prior qualifications or experience. You can just enroll and start learning. This Data Entry Administrator was made by professionals and it is compatible with all PCs, Macs, tablets, and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as a bonus, you will be able to pursue multiple occupations. This Data Entry Administrator is a great way for you to gain multiple skills from the comfort of your home. Making Data Entry Jobs Easier Introduction to Data Entry 00:20:00 Using the Computer for Data Entry 00:15:00 Common Rules and Guidelines for Data Entry 00:30:00 Using Excel for Efficient Data Entry 00:30:00 Using Excel's Flash Fill and Autofill to Automate Data Entry 00:30:00 How to Create a Data Entry Form in Excel? 00:45:00 Using Statistics Packages in Data Entry 00:45:00 Getting Started with Microsoft Office Excel 2016 Navigate the Excel User Interface 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting a Worksheet Apply Text Formats 00:16:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:08:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:09:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:06:00 Mock Exam Final Exam