224 Data Entry courses

Looking to sharpen your everyday maths and English abilities without sitting in a crowded classroom? Our Functional Skills Level 2 – Maths and English Course offers a straightforward, fully online route to building confidence in these two essential subjects. Designed for learners from all walks of life, it provides the tools you need to handle real-life situations – whether that’s helping with homework, managing personal finances, or communicating more effectively in the workplace. With flexible access and a carefully structured format, this dual-subject course makes studying manageable and efficient. You'll develop skills in problem solving, writing, reading, and numeracy – all tailored to meet the demands of modern life. Whether you're aiming to support your career prospects or simply improve your day-to-day capabilities, this course delivers reliable knowledge without unnecessary fluff. Ready when you are, it fits around your schedule – not the other way round. Learning Outcomes: Master basic arithmetic operations and fractions. Understand decimal and percentage conversions. Learn about ratios, proportions, and direct/indirect variation. Gain knowledge of profit and loss and tax calculations. Improve English grammar, sentence structure, and punctuation. Enhance spelling and reduce common mistakes Welcome to the Functional Skills Level 2 Maths and English course, a comprehensive curriculum designed to boost your confidence and proficiency in essential numeracy and literacy skills. Through a series of engaging lectures and practice problems, you will learn everything from basic arithmetic to complex problem-solving, with a focus on real-world applications. In the Maths section, you will delve into the fundamentals of integers, fractions, decimals, and percentages, mastering operations and problem-solving techniques along the way. With topics ranging from multiplication to profit and loss, you will gain a versatile mathematical skills to apply in everyday life. Meanwhile, the English section covers the basics of grammar, sentence structure, and punctuation, with a particular focus on common mistakes and ways to improve. By the end of the course, you will have developed your writing and reading abilities, equipping you with the tools you need to succeed in any professional or personal setting. How is the course assessed? Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%. Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The course is ideal for highly motivated individuals or teams who want to enhance their professional skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Achieving the Functional Skills Level 2 in Maths and English can broaden your career prospects in the financial sector, leading to potential job roles and salary brackets such as: Retail Sales Associate - £17,000 per year Administrative Assistant - £19,000 per year Customer Service Representative - £20,000 per year Data Entry Clerk - £21,000 per year Account Manager - £35,000 per year Certificates Certificate of completion Digital certificate - £9 You can apply for a CPD Accredited PDF Certificate at the cost of £9. Certificate of completion Hard copy certificate - £15 Hard copy can be sent to you via post at the expense of £15.

This bundle course has been designed to give our learners a more in-depth understanding of general office procedures, codes of practice and required skills. It provides essential training on the Microsoft Office Suite for managing everyday clerical tasks and is ideal for entry-level learners. Fast track your career and be equipped with the skills and knowledge to manage everyday office tasks efficiently with the Admin, Secretarial & PA Diploma. This comprehensive course is a general introduction to office procedures and practices, exploring the basics of administrative management and admin support. You will develop essential business writing skills, improve your telephone etiquette, learn how to communicate professionally with clients and much more. This course also includes step-by-step guidance on Microsoft Word. Master Microsoft Office suite and boost your efficiency in general administrative tasks with the Microsoft Office Applications Training course. This introductory program is ideal for beginners who have little or no experience with Office programs. You will be guided step-by-step on how to use Word, Excel, PowerPoint, Outlook and Access. On completion, you will be able to create professional slideshow presentations, automate tasks, analyse numerical data and much more. Enrol today and add valuable transferable skills to your CV. Learning Outcomes: Gain a solid understanding of administrative management and admin support Learn the fundamental principles of business writing and improve your telephone etiquette Learn how to communicate effectively and develop your body language skills Familiarise with the day-to-day responsibilities of an administrative assistant, secretary & PA Get tips on how to organise your workload and manage your time efficiently Master Microsoft Office programs - Word, Excel, Powerpoint, Outlook & Access Share documents, automate tasks, analyse data, create slideshows & much more Gain valuable transferable skills to boost your professional development Be able to customise the user interface to your desire Discover time-saving techniques, tips & shortcuts to work faster and more efficiently Who is This Course for? This bundle course is ideal for anyone who wishes to boost their professional development in an office-based role. This training program is particularly suitable for those who are new to their profession and wish to gain the skills and knowledge to prepare them for their career. Method of Assessment: Upon completion of the course, you will be required to sit for an online multiple-choice quiz based assessment, which will determine whether you have passed the course (60% pass mark). The test will be marked immediately and results will be published instantly. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path On successful completion, learners will have a solid understanding of fundamental office procedures and practices, and will be equipped with the skills to pursue the following roles: Office Administrator Secretary Personal Assistant Receptionist Admin Assitant Data Entry Clerk

This bundle course has been designed to give our learners a more in-depth understanding of general office procedures, codes of practice and required skills. It provides essential training on the Microsoft Office Suite for managing everyday clerical tasks and is ideal for entry-level learners. Fast track your career and be equipped with the skills and knowledge to manage everyday office tasks efficiently with the Admin, Secretarial & PA Diploma. This comprehensive course is a general introduction to office procedures and practices, exploring the basics of administrative management and admin support. You will develop essential business writing skills, improve your telephone etiquette, learn how to communicate professionally with clients and much more. This course also includes step-by-step guidance on Microsoft Word. Master Microsoft Office suite and boost your efficiency in general administrative tasks with the Microsoft Office Applications Training course. This introductory program is ideal for beginners who have little or no experience with Office programs. You will be guided step-by-step on how to use Word, Excel, PowerPoint, Outlook and Access. On completion, you will be able to create professional slideshow presentations, automate tasks, analyse numerical data and much more. Enrol today and add valuable transferable skills to your CV. Learning Outcomes: Gain a solid understanding of administrative management and admin support Learn the fundamental principles of business writing and improve your telephone etiquette Learn how to communicate effectively and develop your body language skills Familiarise with the day-to-day responsibilities of an administrative assistant, secretary & PA Get tips on how to organise your workload and manage your time efficiently Master Microsoft Office programs - Word, Excel, Powerpoint, Outlook & Access Share documents, automate tasks, analyse data, create slideshows & much more Gain valuable transferable skills to boost your professional development Be able to customise the user interface to your desire Discover time-saving techniques, tips & shortcuts to work faster and more efficiently Who is This Course for? This bundle course is ideal for anyone who wishes to boost their professional development in an office-based role. This training program is particularly suitable for those who are new to their profession and wish to gain the skills and knowledge to prepare them for their career. Method of Assessment: Upon completion of the course, you will be required to sit for an online multiple-choice quiz based assessment, which will determine whether you have passed the course (60% pass mark). The test will be marked immediately and results will be published instantly. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path On successful completion, learners will have a solid understanding of fundamental office procedures and practices, and will be equipped with the skills to pursue the following roles: Office Administrator Secretary Personal Assistant Receptionist Admin Assitant Data Entry Clerk

Learn how to create fully relational databases and how to input, extract and report on data. Course overview Duration: 2 days (13 hours) Our Access Database Design and reporting course looks at the key elements to building fully relational databases and entering and extracting information from them. This course is designed for new users who need to build relational database systems. Objectives  By the end of the course you will be able to: Create a new database Create data tables Set field validation and properties Enter data and manage data Create forms Use queries to extract data Create parameter queries Create calculations in queries Build relational databases Use sub datasheets Build multi table queries Use advanced form and report design techniques Content Creating a database Creating a new database Database elements Creating a data table Setting field properties Using input masks Using input masks Validation rules Default values Setting a primary key Creating lookup fields Data entry Adding data Deleting data Quick keys for data entry Working with data Sorting data Filtering data Finding information Navigation Creating data form Creating quick forms The form wizard Amending forms Formatting Setting the tab order Entering data using forms Creating queries Creating a query Setting criteria Using the expression builder Creating parameter queries Using wildcards Using more than one parameter Using calculations in queries Adding a totals row Formatting results Adding calculations Printing and reporting Printing tables and queries Creating reports Building and amending reports Adding headers and footers Working with relational databases Relational database principles Importing data from other sources Linking information between tables One-to-one and one-to-many links Defining referential integrity Amending links Deleting links Sub datasheets Viewing a subdatasheet Removing a subdatasheet Connecting a subdatasheet Multiple table queries Deciding which tables to use Adding tables to the query Creating links between tables Setting join properties Advanced form design Field properties Creating lookup fields Adding calculated fields Applying conditional formatting Advanced report design Field properties Report properties Alternate colour bandings Concatenating fields Adding calculated fields Sorting and grouping Grouping settings Adding headers and footers Adding dates, times, page numbers

This one-day workshop is designed to give you an awareness of the fundamentals of Microsoft Excel and, in particular, to give you the confidence needed to efficiently create, edit and manage spreadsheets. This course will help participants: Create tables Use functions Manage rows and columns Write formulas Manage sheets Use content formats Handle larger tables Create reports and charts 1 Creating a table Creating an Excel table from scratch Wrapping text in cells Speeding up data entry using AutoFill Sorting columns 2 Inserting function Inserting function calculators Using AutoSum to sum numbers Statistical calculations AVERAGE, MAX and MIN 3 Table rows and columns Inserting and deleting rows and columns Adjusting multiple column widths and row heights Hiding and unhiding rows and columns 4 Formula writing The basics of formula writing Understanding mathematical symbols Using multiple mathematical symbols in a formula When to use brackets Troubleshooting calculation errors 5 Managing sheets Inserting, renaming, moving and deleting sheets Copying a worksheet to another file Copying a table to another sheet 6 Managing content formats Applying data formats Managing number formats Controlling formats with the Format Painter 7 Managing larger tables Applying freeze panes to lock tables when scrolling Sorting on multiple columns Using filters to extract table information 8 Creating and modifying charts Creating a pie chart Creating a column chart Inserting chart titles and data labels Controlling chart formatting Changing chart types 9 Printing Previewing and printing tables and charts Modifying page orientation Adjusting print margins Printing a selection 10 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 11 Pivot tables Create a pivot table report Insert a pivot chart into a report

Project planning doesn’t have to be complicated, and it certainly isn’t just for managers with clipboards or Gantt charts. This course takes the confusion out of planning and replaces it with clarity, logic, and a touch of well-earned confidence. Whether you’re managing a team, organising an event, or simply sorting out your week with fewer headaches, this course introduces accessible methods to bring structure to the chaos. It focuses on realistic timelines, goal-setting that makes sense, and planning strategies that work for all walks of life. No technical jargon. No over-complication. Just a clear and clever way to think ahead, manage expectations, and handle priorities with a little more finesse. You’ll learn how to map out projects, deal with risks before they cause trouble, and keep everything running smoothly—without needing to download a dozen apps or become a spreadsheet wizard. Perfect for anyone who likes the idea of getting things done without the drama, this course helps you plan smarter, not harder. If you’ve ever written ‘plan project’ at the top of a to-do list and then stared blankly at it—this course is probably what you’ve been missing. Learning Outcomes: Understand the basics of project management and project planning Learn how to use Microsoft Project software for project planning Know how to create project plans, enter tasks and resources, and track progress Understand how to create and customise Gantt charts Learn how to generate and interpret project reports The "Project Planning for Everyone" course is designed to teach individuals the basics of project planning and management using Microsoft Project software. Through this course, learners will develop the knowledge and skills necessary to create, manage and track project plans effectively. The course covers all aspects of project planning, including basic concepts and techniques, task and resource management, Gantt chart creation, and project tracking. Participants will be exposed to real-world scenarios and practical examples to help them understand how to apply the concepts learned in the course in a work environment. Project Planning for Everyone Course Curriculum Section 01: Introduction Section 02: Basic M S Projects Section 03: Data Entry in MS Projects How is the course assessed? Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%. Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of __ GBP. £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals interested in learning project planning and management Professionals seeking to enhance their project management skills Project managers who want to learn how to use Microsoft Project software Business owners who want to manage their projects efficiently and effectively Anyone who wants to acquire knowledge and skills in project planning and management Career path Project Manager: £25k - £70k Construction Project Manager: £31k - £69k IT Project Manager: £30k - £77k Digital Project Manager: £26k - £54k Marketing Project Manager: £26k - £60k Certificates Certificate of completion Digital certificate - £9 You can apply for a CPD Accredited PDF Certificate at the cost of £9. Certificate of completion Hard copy certificate - £15 Hard copy can be sent to you via post at the expense of £15.

Description: Nowadays data management is absolutely crucial, and there's not much room for error. If you've already taken the basic Microsoft Access 2013 course, or know your way around the program already, then you're ready for this advanced level of Microsoft Access 2013. This Microsoft Office 2013 Access Advanced - Complete Video Course covers advanced functions and features of Access 2013. You will learn about implementing advanced form design, using data validation and using macros to improve user interfacer design. You will also learn how to use advanced database management, distribute and secure a database and manage switchboards. If you want to take your Microsoft Access 2013 skills to the next level, you'll learn how to use this program's advanced features to build a fully functional database from scratch. 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? Microsoft Office 2013 Access Advanced - 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 Microsoft Office 2013 Access Advanced - 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. Implementing Advanced Form Design Add Controls to Forms FREE 00:22:00 Create Subforms 00:03:00 Organize Information with Tabs Pages 00:05:00 Enhance Navigation of Forms 00:06:00 Apply Conditional Formatting 00:05:00 Using Data Validation Field and Record Validation 00:23:00 Form Validation 00:08:00 Using Macros to Improve User Interface Design Create a Macro 00:17:00 Restrict Records Using a Condition 00:05:00 Validate Data Using a Macro 00:06:00 Automate Data Entry Using a Macro 00:06:00 Convert a Macro to VBA 00:05:00 Using Advanced Database Management Link Tables to External Data Sources 00:05:00 Manage a Database 00:07:00 Determine Object Dependency 00:05:00 Document a Database 00:05:00 Analyze the Performance of a Database 00:05:00 Distributing and Securing a Database Splitting a Database for Multiple User Access 00:05:00 Implement Security 00:09:00 Set Passwords 00:07:00 Convert an Access Database to an ACCDE File999 00:07:00 Analyze the Performance of a Database 00:04:00 Managing Switchboards Create a Database Switchboard 00:07:00 Modify a Database Switchboard 00:04:00 Set Startup Options 00:06:00 Mock Exam Mock Exam- Microsoft Office 2013 Access Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2013 Access Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

48-Hour Knowledge Knockdown! Prices Reduced Like Never Before. Boost Your Career By Enrolling In This Virtual Assistant Bundle To Overcome Your Challenges! 6 in 1 Virtual Assistant Bundle Are you interested in a career as a virtual assistant? Are you considering setting up a virtual assistant business? If so, then this Course will equip you with the practical knowledge and skills you need to kickstart your career. Improve your knowledge and enhance your skills to succeed with this Virtual Assistant bundle. This bundle is designed to build your competent skill set and enable the best possible outcome for your future. Our Virtual Assistant bundle is ideal for those who aim to be the best in their fields and are always looking to grow. Why Prefer Virtual Assistant Bundle from Us? All-in-one package Virtual Assistant bundle Earn a certificate accredited by CPD. Get a free student ID card with this Virtual Assistant Bundle Get instant access to this Virtual Assistant course. Learn Virtual Assistant from anywhere in the world Virtual Assistant Training is affordable and simple to understand Virtual Assistant Course is entirely online, interactive lesson with voiceover audio Lifetime access to the Virtual Assistant course materials Virtual Assistant comes with 24/7 tutor support Enrol now in this Virtual Assistant Level 3 Diploma - CPD Certified to advance your career! Start your learning journey straightaway with our Virtual Assistant Diploma Course 01: Virtual Assistant Introduction Different Types of Virtual Assistants Be a Virtual Assistant Must-Have Skills for VA Essential Tools Finding Your Niche Get Hired for VA Jobs How to Set VA Business Admin Support- a Vital Part of VA How to Manage Clients Working with a Virtual Team Data Security Measures Assessment Process of Virtual Assistant Once you have completed all the courses in the Virtual Assistant bundle, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards. Enrol now in this Virtual Assistant Level 3 Diploma - CPD Certified to advance your career! CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Virtual Assistant Level 3 Diploma - CPD Certified. Requirements Virtual Assistant Level 3 Diploma - CPD Certified. Career path Virtual Assistant Level 3 Diploma - CPD Certified. Certificates Certificate Accredited by CPD Digital certificate - £10 Upon passing the Virtual Assistant Bundle, you need to order to receive a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD. Certificate Accredited by CPD Hard copy certificate - £29 Upon passing the Virtual Assistant Bundle, you need to order to receive a Hard copy Certificate for each of the courses inside this bundle. If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.

Are you part of the Office Management department of your company? Or are you a businessman who's having issues with office management? Can you say that you are someone who knows everything about office management or do you still need to learn about it? If so, then this course will help you in office management and find out how to run the business smoothly! Description: Office Management is an essential part of the business since this is where you would know how your office is run and is the key for your business to be successful. In this course, you will be learning how your business or the company you are working for has the right leaders to run its management and operations. You will also learn how to build a successful brand. Then know the importance of teamwork to be able to achieve and accomplish more things. You will also learn that motivation is at the heart of a better business and one of the ways to succeed. Moreover, you will know how to improve the marketing of the business and learn how to provide top customer service. Who is the course for? Businessmen, entrepreneurs or professionals that need to know about office management. People who have an interest in becoming part of the office management department. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Diploma in Office Management is a useful qualification to possess, and would be beneficial for the following careers: Administrative Assistants Client Relations Manager Contract Administrator Data Entry Specialists Executive Assistants General Office Clerks Information Assistants Material Recording Clerks Secretaries Virtual Assistants. Managing Office Building Your Management Team 01:00:00 Building A Successful Brand 01:00:00 Achieving Quality Through Teamwork 00:30:00 Keys To Staying Motivated 00:30:00 Improve Your Marketing 01:00:00 Provide Top Customer Service 00:30:00 Wrapping Up 00:30:00 Office Management Module One - Getting Started 00:30:00 Module Two - New Hires 01:00:00 Module Three - It's About Interacting and Influencing 01:00:00 Module Four - Dealing with Rumors Gossip and Half Truths 01:00:00 Module Five - Office Personalities (I) 00:30:00 Module Six - Office Personalities (II) 01:00:00 Module Seven - Getting Support for Your Projects 01:00:00 Module Eight - Conflict Resolution 01:00:00 Module Nine - Ethics 01:00:00 Module Ten - You Are Not an Island 01:00:00 Module Eleven - Social Events Outside of Work 00:30:00 Module Twelve - Wrapping Up 00:30:00 Mock Exam Mock Exam- Diploma in Office Management 00:20:00 Final Exam Final Exam- Diploma in Office Management 00:20:00

Description: Nowadays Excel has become very much more than just a simple spreadsheet. Although its roots are still in number management, today Excel's uses cover a wide gamut - from simple data entry to complicated financial models and analysis. This Microsoft Office 2016 Excel Advanced - Complete Video Course is designed to help you to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros. You will learn Visualize data with charts, how to use PivotTables and PivotCharts, working with powerful Functions you need to know, and more. So, if you have intermediate skills with Microsoft Excel 2016 and want to learn more advanced skills or want to learn the topics covered in this course in the 2016 interface. Then this advanced level will be very helpful for you. So, be an expert by joining us. 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? Microsoft Office 2016 Excel Advanced - 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 Microsoft Office 2016 Excel Advanced - 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. Working with Multiple Worksheets and Workbooks Use Links and External References FREE 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Sharing and Protecting Workbooks Collaborate on a Workbook 00:19:00 Protect Worksheets and Workbooks 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Mock Exam Mock Exam- Microsoft Office 2016 Excel Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2016 Excel Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00