3610 Office Skills & Productivity courses

Azure Virtual Network gives you an isolated and highly-secure environment to run your virtual machines and applications. Use your private IP addresses and define subnets, access control policies, and more. Use Virtual Network to treat Azure the same as you would your own datacenter. The Azure - Networking is designed to introduce to virtual network configuration through the Microsoft Azure Portal and network configuration files. You'll also see how to use network services to configure and load balance network traffic using tools such as Azure DNS. Load Balancer, Azure Traffic Manager, and Application Gateway. And because this is about the cloud, you'll see how to connect your on-premises computers to Azure virtual networks as well as establishing connectivity between sites. The course guides you to configure a Point to Site VPN and a Site to Site VPN. On completion this course, you will look at Azure Vnet peering, and how peering between Vnets can reduce the need to build Vnet-to-Vnet VPN gateways. What Will I Learn? Create a Vnet Configure a Point to Site VPN Understand Vnet Peering Understand DNS in Azure Vnets Who is the target audience? People interested in learning Networking Basics in Azure Requirements Some prior knowledge in Azure is required, or the completion of Introduction to Azure course Introduction Introduction FREE 00:02:00 Virtual Networks Virtual Network Overview 00:02:00 IP Address Space 00:03:00 DNS in Azure Vnets 00:03:00 Creating a VNet 00:03:00 VPNs with VNets 00:04:00 Configuring a Point to Site VPN 00:12:00 Configure Site to Site VPN 00:05:00 Azure Vnet Peering 00:02:00 Conclusion Course Recap 00:04:00 Course Certification

Powerful 1-hour Python workshop course understand Python Basics. Practical. Instructor-led. Online. Learn to code a Password Validator in 1 hour. 

The Microsoft Access 2016 Beginner to Advanced course is a comprehensive training program covering all levels of proficiency. From creating simple databases to advanced querying, form creation, report generation, and database management, this course provides a deep understanding of Microsoft Access's features and functions. Learning Outcomes: Build and modify Access databases, tables, and fields. Create effective queries to sort, filter, and summarize data. Develop professional-looking reports with controls, charts, and calculations. Design forms with controls, tab pages, and conditional formatting. Automate tasks using macros and understand the basics of VBA. Manage database performance, security, and object dependencies. Create a database switchboard and modify startup options. Understand data normalization, table relationships, and import/export processes. Why buy this Microsoft Access 2016 Beginner to Advanced? Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on 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 Microsoft Access 2016 Beginner to Advanced you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? Beginners with no previous experience in Microsoft Access. Professionals seeking to enhance their database management and reporting skills. Individuals aiming to become proficient in creating and maintaining databases. Students pursuing careers in data analysis, administration, or database management. Prerequisites This Microsoft Access 2016 Beginner to Advanced 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. Career path Data Analyst: Analyze, interpret, and present data insights using Access. Database Administrator: Design, implement, and maintain databases for organizations. Administrative Assistant: Manage data, generate reports, and streamline processes. Project Manager: Organize project-related data and create performance reports. Business Owner: Build and manage databases to support business operations. Course Curriculum Module - 1 Orientation to Microsoft Access 01:00:00 Create a Simple Access Database 01:00:00 Get Help in Microsoft Access 00:30:00 Modify Table Data 00:30:00 Work with Records 01:00:00 Sort and Filter Records 00:30:00 Create Lookups 01:00:00 Join Data from Different Tables in a Query 01:00:00 Sort and Filter Data in a Query 01:00:00 Perform Calculations in a Query 00:30:00 Create Parameter Queries 00:30:00 Create Action Queries 00:30:00 Create Find Duplicate and Find Unmatched Queries 00:30:00 Summarize Data 00:30:00 Create a Report 01:00:00 Add Controls to a Report 00:30:00 Enhance the Appearance of a Report 00:30:00 Prepare a Report for Print 00:30:00 The Access Options Dialog Box 01:00:00 Relational Database Design 00:30:00 Create a Table 01:00:00 Modify a Table and Fields 00:30:00 Create Table Relationships 00:30:00 Create Query Joins 00:30:00 Join Tables That Have No Common Fields 00:30:00 Relate Data within a Table 00:30:00 Work with Subdatasheets 00:30:00 Create Subqueries 00:30:00 Data Normalization 01:00:00 Create a Junction Table 00:30:00 Import Data into Access 00:30:00 Export Data to Text File Formats 00:30:00 Export Access Data to Excel 00:30:00 Create a Mail Merge 00:30:00 Organize Report Information 00:30:00 Format Reports 00:30:00 Include Charts in a Report 00:30:00 Add a Calculated Field to a Report 00:30:00 Add a Subreport to an Existing Report 00:30:00 Create a Mailing Label Report 00:30:00 Publish a Report as PDF 00:30:00 Activities - Microsoft Access 2016 for Beginners 00:00:00 Module - 2 Add Controls to Forms 01:00:00 Set Form Controls 01:00:00 Create Subforms 00:30:00 Organize Information with Tab Pages 00:30:00 Enhance Navigation with Forms 00:30:00 Format a Form 01:00:00 Apply Conditional Formatting 00:30:00 Field Validation 00:30:00 Form and Record Validation 00:30:00 Create a Macro 01:00:00 Restrict Records Using a Condition 00:30:00 Validate Data Using a Macro 00:30:00 Automate Data Entry Using a Macro 00:30:00 Convert a Macro to VBA 00:30:00 Link Tables to External Data Sources 00:30:00 Manage a Database 00:30:00 Determine Object Dependency 00:30:00 Document a Database 00:30:00 Analyze the Performance of a Database 00:30:00 Split a Database for Multiple User Access 00:30:00 Implement Security 00:30:00 Set Passwords 00:30:00 Convert an Access Database to an ACCDE File 00:30:00 Package a Database with a Digital Signature 00:30:00 Create a Database Switchboard 01:00:00 Modify a Database Switchboard 00:30:00 Set Startup Options 00:30:00 Activities - Microsoft Access 2016 Advanced 00:00:00

Overview Hospitals and other healthcare facilities are frequently associated with doctors and nurses. However, there is another group of personnel who keep the healthcare system up and running - medical & clinical administrators. Medical & clinical administrators are in charge of ensuring that patients receive the best possible treatment. They work with the patients & doctors and coordinate the several services involved to keep everyone in sync as they progress through treatment. Their primary responsibility is to interpret laws and regulations in light of specific patient profiles. If you desire a career in healthcare but don't want to go to medical school, this Administration: Medical & Clinical Administration course is for you. This course focuses on guiding you through every aspect of medical and clinical administration. From organising schedules to maintaining medical records, you will explore every bit of medical administrative duties. Moreover, this course will educate you on effective filing systems, confidentiality in a medical environment, controlling stocks and supplies, and more. You will also build a solid foundation of medical jargon and terminologies with the help of this administration training. Along with these, this course will train you in maintaining workplace safety, medical coding and billing, IT in healthcare, etc. You will also have a strong comprehension of the legal and ethical aspects of medical and clinical administration. Join this Administration: Medical & Clinical Administration course - build a rewarding career in the healthcare system without a medical degree! What skills you will gain: Understanding the fundamentals of Medical and Clinical Administration. Dexterity in organising schedules and maintaining medical records. Familiarity with the effective filing systems in medical offices. Proficiency in the crucial topic of confidentiality in a medical environment. Adeptness in controlling stocks and supplies. Expertise in medical jargon and terminology. A solid foundation for maintaining workplace safety. Enhanced awareness of information technology in healthcare. A clear comprehension of medical coding and billing. A complete overview of the legal and ethical aspects. Why buy this Medical & Clinical Administrator? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on 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 Medical & Clinical 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 £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Medical & Clinical 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 skill. Prerequisites This Medical & Clinical Administrator does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Medical & Clinical Administrator 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. Career path This Administration: Medical & Clinical Administration course is an excellent opportunity to acquire several competencies from the convenience of your home. This course's diverse curriculum allows you to pursue different careers, such as - Healthcare Administrator GP Receptionist Patient Coordinator Medical Assistant Medical Receptionist In the UK, these jobs pay between £12,000 and £30,000 a year. Course Curriculum Medical & Clinical Administrator Module 01: Introduction to Medical and Clinical Administration 00:18:00 Module 02: Organise Schedules 00:20:00 Module 03: Maintaining Medical Records 00:21:00 Module 04: Effective Filing Systems in Medical Offices 00:15:00 Module 05: Confidentiality in a Medical Environment 00:12:00 Module 06: Controlling Stocks and Supplies 00:10:00 Module 07: Medical Jargon and Terminology 00:25:00 Module 08: Maintaining Workplace Safety 00:18:00 Module 09: Information Technology in Health Care 00:14:00 Module 10: Medical (Clinical) Coding and Billing 00:20:00 Module 11: Legal aspects and Ethics 00:20:00 Assignment Assignment - Medical & Clinical Administrator 00:00:00

The 'Data Center Training Essentials: General Introduction' course provides a comprehensive overview of data centers, covering mechanical aspects, reliability, equipment, white space, support spaces, and essential considerations such as security, safety, networks, and IT infrastructure. Learning Outcomes: Understand the fundamental concepts and components of data centers. Gain knowledge about data center reliability and the importance of maintaining a secure and safe environment. Learn about the critical roles of various support spaces and the integration of networks and IT infrastructure within data centers. Why buy this Data Center Training Essentials: General Introduction? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on 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 Center Training Essentials: General Introduction 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 £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Data Center Training Essentials: General Introduction 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 skill. Prerequisites This Data Center Training Essentials: General Introduction does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Data Center Training Essentials: General Introduction 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. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Data Center Training Essentials: General Introduction is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Data Center Training Essentials: General Introduction Module 01:Data Center Mechanical Introduction 01:01:00 Module 02: Data Center Reliability 00:23:00 Module 03: Data Center Equipment 00:24:00 Module 04: Data Center White Space 00:24:00 Module 05: Data Center Support Spaces 00:27:00 Module 06: Data Center Security, Safety, Networks and IT 00:26:00 Assignment Assignment - Data Center Training Essentials: General Introduction 00:00:00

Embark on a comprehensive journey into the field of school administration with this diploma course. From understanding the diverse types of schools in the UK to mastering workplace development and school culture maintenance, this course equips you with essential skills for efficient educational administration and management. Dive into safeguarding students, child development, and managing serious behavioral issues while learning the intricacies of school premises management, safety, and maintenance. Moreover, discover techniques for self-management and stress reduction to thrive in the demanding role of a school administrator. Learning Outcomes: Gain insights into the role and significance of school administration. Understand the variety of schools present in the UK education system. Develop strategies for workplace development and cultivating a positive school culture. Learn about educational administration and effective management techniques. Explore methods for safeguarding students and ensuring their well-being. Acquire knowledge of child development and its relevance in education. Address serious behavioral issues and challenges faced by students. Master the intricacies of managing school premises, safety, and maintenance. Why buy this School Administrator Diploma?  Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on 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 School Administrator Diploma you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This School Administrator Diploma course is ideal for Individuals aspiring to become school administrators or educational managers. School staff members seeking to enhance their administrative skills. Education enthusiasts interested in understanding school operations. Anyone looking to pursue a career in the education sector. Prerequisites This School Administrator Diploma 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. Career path School Administrator - Average Earnings: £20,000 - £35,000 per year. School Business Manager - Average Earnings: £25,000 - £45,000 per year. School Operations Manager - Average Earnings: £30,000 - £50,000 per year. Head of School - Average Earnings: £40,000 - £60,000+ per year. Educational Director - Average Earnings: £50,000 - £80,000+ per year. Course Curriculum School Administrator Diploma Introduction to School Administration 00:12:00 Types of Schools In The UK 00:15:00 Workplace Development 00:12:00 Creating and Maintaining a School Culture 00:13:00 Educational Administration and Management 00:11:00 Safeguarding Students 00:14:00 Child Development 00:15:00 Serious Behavioural Issues and Problems of Students 00:12:00 Managing School Premises 00:10:00 Safety and Maintenance As an Administrator 00:08:00 Self-Management and Dealing with Stress 00:13:00 Mock Exam Mock Exam - School Administrator Diploma 00:20:00 Final Exam Final Exam - School Administrator Diploma 00:20:00 Assignment Assignment - School Administrator Diploma 00:00:00

The 'Microsoft Access Databases Forms and Reports' course offers comprehensive training on creating and customizing forms and reports in Microsoft Access. Participants will learn various techniques, such as using autoforms, form wizard, and design view, adding controls, subforms, and calculations, and creating reports using report wizard, groupings, sorts, and totals. The course concludes with finalizing the application and exporting reports to Excel. Learning Outcomes: Understand the fundamentals of creating forms and reports in Microsoft Access. Learn to use autoforms and the form wizard to quickly generate forms based on data tables. Master the art of customizing forms and reports using design view, adding controls, and creating subforms. Acquire the ability to create and modify reports using autoreport and report wizard functionalities. Add calculations, groupings, sorts, and totals to reports to present data more effectively. Utilize the Label Wizard to create labels for various purposes in Access databases. Explore form and report properties to control the appearance and behavior of forms and reports. Learn to export reports to Microsoft Excel for further analysis and sharing. Create a user-friendly menu using the Switchboard Manager for easy navigation within the application. Complete the course by finalizing the Access application, ensuring it is ready for use with optimized forms, reports, and functionalities. Why buy this Microsoft Access Databases Forms and Reports? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on 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 Microsoft Access Databases Forms and Reports 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 £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Microsoft Access Databases Forms and Reports 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 skill. Prerequisites This Microsoft Access Databases Forms and Reports does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Microsoft Access Databases Forms and Reports 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. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Microsoft Access Databases Forms and Reports is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Microsoft Access Databases Forms and Reports Autoforms 00:14:00 Form Wizard 00:09:00 Changing a form with design view 00:26:00 Adding controls to your form 00:21:00 Subforms 00:14:00 Using Autoreport to create a report 00:00:00 Using the Report Wizard to create a report 00:07:00 Changing a report in design view 00:11:00 Adding Calculations to your report 00:09:00 Adding Groups, Sorts and Totals to reports 00:16:00 Making labels with the Label Wizard 00:04:00 Form and Report Properties 00:06:00 Exporting a report to Excel 00:03:00 Creating a menu with the Switchboard Manager 00:17:00 Finalizing the Application 00:08:00 Assignment Assignment - Microsoft Access Databases Forms and Reports 00:00:00

CPD Accredited | Career Oriented Learning Modules | 24x7 Tutor Support | Lifetime Access

CPD Accredited | Career Oriented Learning Modules | 24x7 Tutor Support | Lifetime Access

Embark on a journey to master Microsoft Excel with our 'Excel Essentials for Office Administrators' course. Designed to transform beginners into proficient users, this comprehensive course is divided into two main sections: Excel Beginner and Excel Intermediate. In the initial phase, learners are introduced to the Excel interface, where they explore and identify its various elements. This is followed by practical activities such as creating basic worksheets, using the help system, and crafting formulas. As the course progresses, participants will delve into more advanced features like manipulating data, applying styles and formats, and managing worksheets. The intermediate section elevates your skills further, covering a wide range of topics from applying range names and specialized functions to creating sophisticated charts and PivotTables. Learning Outcomes Gain proficiency in navigating and utilizing the Excel interface. Develop the ability to create and manage complex worksheets effectively. Master a variety of Excel functions and formulas for diverse data processing needs. Learn advanced data management techniques including sorting, filtering, and using PivotTables. Acquire skills in visual data presentation and customization of Excel workbooks. Why choose this Excel Essentials for Office Administrators 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 Excel Essentials for Office Administrators course for? Office administrators and secretaries seeking to enhance their Excel skills. Professionals in various sectors requiring proficiency in Excel for data management. Students and individuals interested in learning Excel from a beginner to an intermediate level. Business owners needing to manage business data more efficiently. Anyone aiming to improve their productivity and data analysis skills through Excel. Career path Data Analyst: £25,000 - £50,000 Administrative Assistant: £18,000 - £30,000 Office Manager: £22,000 - £40,000 Business Analyst: £30,000 - £60,000 Financial Analyst: £28,000 - £55,000 Project Coordinator: £24,000 - £45,000 Prerequisites This Excel Essentials for Office Administrators does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course 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 Excel Beginner Identify the Elements of the Excel Interface 00:30:00 Activity - Identify the Elements of the Excel Interface 00:05:00 Create a Basic Worksheet 01:00:00 Activity - Create a Basic Worksheet 00:05:00 Use the Help System 00:30:00 Activity - Use the Help System 00:05:00 Create Formulas in a Worksheet 01:00:00 Activity - Create Formulas in a Worksheet 00:05:00 Insert Functions in a Worksheet 00:30:00 Activity - Insert Functions in a Worksheet 00:05:00 Reuse Formulas 00:30:00 Activity - Reuse Formulas 00:05:00 Manipulate Data 00:30:00 Activity - Manipulate Data 00:05:00 Insert, Manipulate, and Delete Cells, Columns, and Rows 00:30:00 Activity - Insert, Manipulate, and Delete Cells, Columns, and Rows 00:05:00 Search For and Replace Data 00:30:00 Activity - Search For and Replace Data 00:05:00 Spell Check a Worksheet 00:30:00 Activity - Spell Check a Worksheet 00:05:00 Modify Fonts 00:30:00 Activity - Modify Fonts 00:05:00 Add Borders and Colors to Cells 01:00:00 Activity - Add Borders and Colors to Cells 00:05:00 Apply Number Formats 00:30:00 Activity - Apply Number Formats 00:05:00 Align Cell Contents 00:30:00 Activity - Align Cell Contents 00:05:00 Apply Cell Styles 00:30:00 Activity - Apply Cell Styles 00:05:00 Define the Basic Page Layout for a Workbook 01:00:00 Activity - Define the Basic Page Layout for a Workbook 00:05:00 Refine the Page Layout and Apply Print Options 00:30:00 Activity - Refine the Page Layout and Apply Print Options 00:05:00 Format Worksheet Tabs 00:30:00 Activity - Format Worksheet Tabs 00:05:00 Manage Worksheets 00:30:00 Activity - Manage Worksheets 00:05:00 Manage the View of Worksheets and Workbooks 00:30:00 Activity - Manage the View of Worksheets and Workbooks 00:05:00 Customize General and Language Options 00:30:00 Activity - Customize General and Language Options 00:05:00 Customize Formula Options 00:30:00 Activity - Customize Formula Options 00:05:00 Customize Proofing and Save Options 01:00:00 Activity - Customize Proofing and Save Options 00:05:00 Customize the Ribbon and Quick Access Toolbar 00:30:00 Activity - Customize the Ribbon and Quick Access Toolbar 00:05:00 Customize the Functionality of Excel by Enabling Add-Ins 00:30:00 Activity - Customize the Functionality of Excel by Enabling Add-Ins 00:05:00 Customize Advanced and Trust Center Options 00:30:00 Activity - Customize Advanced and Trust Center Options 00:05:00 Activities and Exercise Files - Microsoft Excel 2016 for Beginners 00:00:00 Excel Intermediate Apply Range Names 00:30:00 Use Specialized Functions 00:30:00 Use Text Functions 00:30:00 Use Logical Functions 00:30:00 Use Lookup Functions 00:30:00 Use Date Functions 00:30:00 Use Financial Functions 00:30:00 Create and Modify Tables 00:30:00 Sort and Filter Data 00:30:00 Use Subtotal and Database Functions to Calculate Data 00:30:00 Create Charts 00:30:00 Modify and Format Charts 00:30:00 Create a Trendline 00:30:00 Create Advanced Charts 00:30:00 Create a PivotTable 00:30:00 Filter Data by Using Slicers 00:30:00 Analyze Data with PivotCharts 00:30:00 Insert and Modify Graphic Objects 00:30:00 Layer and Group Graphic Objects 00:30:00 Incorporate SmartArt 00:30:00 Customize Workbooks 00:30:00 Manage Themes 00:30:00 Create and Use Templates 00:30:00 Protect Files 00:30:00 Preparing a Workbook for Multiple Audiences 00:30:00 Activities and Exercise Files - Microsoft Excel 2016 Intermediate 00:00:00