1291 Courses delivered Online

Learning Objectives Introduction , Customizing Excel , Analyzing Data with Logical Functions , Working with Lookup Functions , Using Text Functions , Working with Date and Time Functions , Formula Auditing , What-If Analysis , Worksheet and Workbook Protection , Automating with Macros , Working with Form Controls , Ensuring Data Integrity , Collaborating in Excel , Importing and Exporting Data to a Text File , Conclusion   Pre-Requisites Excel 365 Introduction and Intermediate courses or equivalent experience.   Description This course will teach students advanced concepts and formulas in Microsoft Excel 365. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions, and complex logical and text functions. Additionally, students will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in their worksheets and workbooks. Students will also learn about Excel's many collaboration features and import and export data to and from their workbooks. Course Introduction Introduction 00:01:00 Section 01 Lesson 01-Customizing the Ribbon 00:09:00 Lesson 02-Customizing the Quick Access Toolbar 00:06:00 Lesson 03-Customizing the General and Formula Options 00:04:00 Lesson 04-Customizing the AutoCorrect Options 00:03:00 Lesson 05-Customizing the Save Defaults 00:04:00 Lesson 06-Customizing Advanced Excel Options 00:03:00 Section 02 Lesson 01-Working with the Most Common Logical Functions 00:03:00 Lesson 02-Understanding IF Functions 00:06:00 Lesson 03-Evaluating Data with the AND Function 00:05:00 Lesson 04-Evaluating Data with the OR Function 00:03:00 Lesson 05-Creating a Nested IF Function 00:05:00 Lesson 06-Using the IFS Function 00:03:00 Lesson 07-Summarizing Data with SUMIF 00:03:00 Lesson 08-Summarizing Data with AVERAGEIF 00:02:00 Lesson 09-Summarizing Data with COUNTIF 00:02:00 Lesson 10-Summarizing Data with MAXIFS and MINIFS 00:03:00 Lesson 11-Using the IFERROR Function 00:03:00 Section 03 Lesson 01-What are Lookup Functions 00:03:00 Lesson 02-Using VLOOKUP 00:08:00 Lesson 03-Using HLOOKUP 00:03:00 Lesson 04-Using VLOOKUP with TRUE 00:04:00 Lesson 05-Using HLOOKUP with TRUE 00:02:00 Lesson 06-Using the Index Function 00:03:00 Lesson 07-Using the MATCH Function 00:03:00 Lesson 08-Combining INDEX and MATCH 00:04:00 Lesson 09-Comparing Two Lists with VLOOKUP 00:02:00 Lesson 10-Comparing Two Lists with VLOOKUP and ISNA 00:04:00 Lesson 11-Using the New XLookup Function-v2 00:07:00 Lesson 12-Using Dynamic Array functions-v2 00:06:00 Lesson 13-Other New Functions-v2 00:04:00 Section 04 Lesson 01-What are Text Functions 00:01:00 Lesson 02-Using CONCAT, CONCATENATE, AND TEXTJOIN 00:04:00 Lesson 03-Using Text to Columns 00:02:00 Lesson 04-Using LEFT, RIGHT, and MID Functions 00:03:00 Lesson 05-Using UPPER, LOWER, and PROPER Functions 00:02:00 Lesson 06-Using the Len Function 00:03:00 Lesson 07-Using the Trim Function 00:01:00 Lesson 08-Using the SUBSTITUTE Function 00:02:00 Section 05 Lesson 01-What are Date and Time Functions 00:02:00 Lesson 02-Using TODAY, NOW, and DAY Functions 00:03:00 Lesson 03-Using NETWORKDAYS and YEARFRAC Functions 00:03:00 Section 06 Lesson 01-Showing Formulas 00:03:00 Lesson 02-Tracing Precedents and Dependents 00:04:00 Lesson 03-Adding a Watch Window 00:04:00 Lesson 04-Error Checking 00:04:00 Section 07 Lesson 01-Using the Scenario Manager 00:07:00 Lesson 02-Using Goal Seek 00:03:00 Lesson 03-Analyzing with Data Tables 00:04:00 Section 08 Lesson 01-Understanding Protection 00:02:00 Lesson 02-Encrypting Files with Passwords 00:05:00 Lesson 03-Allowing Specific Worksheet Changes 00:02:00 Lesson 04-Adding Protection to Selected Cells 00:03:00 Lesson 05-Additional Protection Features 00:03:00 Section 09 Lesson 01-What are Macros 00:03:00 Lesson 02-Displaying the Developer Tab 00:03:00 Lesson 03-Creating a Basic Formatting Macro 00:05:00 Lesson 04-Assigning a Macro to a Button 00:03:00 Lesson 05-Creating Complex Macros 00:04:00 Lesson 06-Viewing and Editing the VBA Code 00:04:00 Lesson 07-Adding a Macro to the Quick Access Toolbar 00:03:00 Section 10 Lesson 01-What are Form Controls 00:02:00 Lesson 02-Adding a Spin Button and Check Boxes 00:04:00 Lesson 03-Adding a Combo Box 00:07:00 Section 11 Lesson 01-What is Data Validation 00:02:00 Lesson 02-Restricting Data Entry to the Whole Numbers 00:02:00 Lesson 03-Restricting Data Entry to a List 00:04:00 Lesson 04-Restricting Data Entry to a Date 00:02:00 Lesson 05-Restricting Data Entry to Specific Text Lengths 00:01:00 Lesson 06-Composing Input Messages 00:02:00 Lesson 07-Composing Error Alerts 00:03:00 Lesson 08-Finding Invalid Data 00:02:00 Lesson 09-Editing and Deleting Validation Rules 00:01:00 Section 12 Lesson 01-Working with Comments-v2 00:03:00 Lesson 02-Printing Comments and Errors 00:02:00 Lesson 03-Sharing a Workbook 00:04:00 Lesson 04-Co-Authoring in Excel 00:02:00 Lesson 05-Tracking Changes in a Workbook 00:03:00 Lesson 06-Working with Versions 00:03:00 Lesson 07-Sharing files Via Email-v2 00:03:00 Section 13 Lesson 01-Importing a Text File 00:04:00 Lesson 02-Exporting Data to a Text File 00:01:00 Course Recap Recap 00:02:00 Additional Materials Resource - Excel 365 Advanced 00:00:00 Final Exam Final Exam - Excel 365 Advanced 00:20:00

Do you want to improve your professional skill through Microsoft Excel? Do you want to know the advanced features of Excel program? The course explains the advanced features and facilities of Microsoft Excel. Course Description: Microsoft Excel is a powerful spreadsheet program that offers a great number of tools for organising your data. The knowledge of Excel helps you to share your workbooks to advanced functions and formulas. The course will help you to keep security setting in mind when sharing workbooks with Macros. The course will teach you how to use the Track Changes feature to make comments on another's work. In the course, you will also learn to merge copies of the shared workbook to consolidate the comments. Course Highlights Microsoft Excel Intermediate Level 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 Microsoft Excel Intermediate Level 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 8 hours, 10 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 Microsoft Excel Intermediate Level 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? Microsoft Excel Intermediate Level 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 Microsoft Excel Intermediate Level 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 00:30:00 Module Two - Working with Permissions and Options 00:30:00 Module Three - Sharing Workbooks 00:30:00 Module Four - Performing Advanced Formula and Function Tasks 00:30:00 Module Five - Working with Array Formulas 01:00:00 Module Six - Working With Macros 00:30:00 Module Seven - Working With Forms 00:30:00 Module Eight - Applying Advanced Chart Features 01:00:00 Module Nine - Working With Slicers and Timelines 00:30:00 Module Ten - Working With Multiple Tables, Relationships and External Data 00:30:00 Module Eleven - Working With PowerView 00:30:00 Module Twelve - Wrapping Up 01:00:00 Activities Activities- Microsoft Excel Intermediate Level CPD & IAO Accredited 00:00:00 Mock Exam Mock Exam- Microsoft Excel Intermediate Level CPD & IAO Accredited 00:20:00 Final Exam Final Exam- Microsoft Excel Intermediate Level CPD & IAO Accredited 00:20:00

Are you having trouble showcasing your data in important presentations? Then Microsoft Excel is useful software you can use to solve your problem. If you want to learn the complete guide on how to become a professional user on Microsoft Excel, then this is the course for you. With Excel, you can manage more data than ever, with increased worksheet and workbook sizes. Build great charts, use conditional formatting, help identify the trends and bring data together by using Excel. Gain access to new features such as sparklines, improved pivot tables, slicer, Access spreadsheets from anywhere and much more. Course Highlights Microsoft Excel 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 Microsoft Excel 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 12 hours, 10 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 Microsoft Excel 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? Microsoft Excel 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 Microsoft Excel 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 Excel FREE 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Worksheet 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Building Formulas 01:00:00 Module Seven - Using Excel Functions 01:00:00 Module Eight - Using Quick Analysis 01:00:00 Module Nine - Formatting Your Data 01:00:00 Module Ten - Using Styles, Themes, and Effects 01:00:00 Module Eleven - Printing and Sharing Your Workbook 01:00:00 Module Twelve - Wrapping Up 01:00:00 Activities Activities - Microsoft Excel for Beginners CPD & IAO Accredited 00:00:00 Mock Exam Mock Exam- Microsoft Excel for Beginners CPD & IAO Accredited 00:20:00 Final Exam Final Exam- Microsoft Excel for Beginners CPD & IAO Accredited 00:20:00

Microsoft Excel for Beginners Course Are you seeking to boost your career potential by acquiring practical knowledge in one of the most indispensable tools in modern business - Microsoft Excel? Or perhaps you are a student aiming to supplement your educational endeavors with this ubiquitous software? Then you've landed on the right course. Our Microsoft Excel for Beginners Certificate Course is designed to introduce learners to the essential functions and features of Excel, starting from the basics. This comprehensive online course offers step-by-step instructions on how to create, navigate, and manage worksheets and workbooks effectively. You'll embark on a journey from understanding the Excel interface, all the way to manipulating datasets and performing complex calculations with ease. Whether it's data sorting, cell formatting, creating tables, or crafting detailed charts, you'll learn how to do it all. You'll also become adept at employing powerful Excel functions and formulas, opening doors to seamless data analysis and interpretation. Course Highlights: Foundational Excel Knowledge: Familiarize yourself with Excel's interface, and learn how to create and manipulate worksheets and workbooks. Formatting and Styles: Learn how to use Excel's rich formatting options to emphasize and clarify your data. Tables and Data Features: Master the art of sorting and filtering data, as well as creating and formatting tables. Charts and Graphics: Acquire the skills to create visually appealing charts and graphics that communicate your data effectively. Functions and Formulas: Delve into the core functions and formulas, including VLOOKUP, SUM, AVERAGE, and more. Data Analysis: Discover the power of Excel's data analysis tools, and learn how to use them to derive meaningful insights from your data. Real-world Application Scenarios: Engage with interactive exercises and projects that reinforce your learning and allow you to practice your skills in realistic settings. This course is designed for absolute beginners, so no previous experience with Excel is required. Upon completion of the course, you'll receive a certificate to showcase your newfound proficiency. Furthermore, the course is self-paced and accessible 24/7, so you can learn at a time and pace that suits you best. Unlock your potential today with our Microsoft Excel for Beginners Certificate Course. Empower yourself with valuable skills that will serve you in any professional setting.

Excel Macros Certificate Course Finding out about Excel macros is vital for any individual who uses Excel at home or work. Regardless of whether you're hoping to build your overall Excel information or improve your abilities in the work environment, this course covers all you require. This course gives a thorough manual for Excel macros, including the references to utilize, and how to record and save macros. From proficient tips and counsel to top to bottom full scale classes and genuine equations you can quickly apply, this course covers all you require to think about each component of Excel macros.   You Will Learn: A comprehensive definition of Excel macros and how they work How to reference and record macros How to run, name and save macros Professional tips and expert advice Macro categories and practical coding   Benefits of Taking This Course: You will save time and increase productivity You will be able to interpret data faster and more effectively You will learn basic VBA coding and how to make it work for you You will be able to automate and optimise essential data You will understand the security risks associated with macros

You will hardly find a company or business who doesn't use Microsoft Excel. It is one of the most popular spreadsheet tools that is used to store, organize and analyse data. You can also manipulate the data to create useful visuals to understand trends and calculations. Having a professional Microsoft Excel degree can become an asset for you. Whether you are planning to start your career or want a promotion, our Microsoft Excel 2010 Intermediate Level will help you greatly. Please note that this course is for intermediate level. If you haven't completed the beginners course, then it will be a bit difficult for you to cope up with the intermediate features. But, if you are a quick learner and can adapt with changes, then you can enrol to this course without any doubt and master Microsoft Excel easily. It will help you to stand out in the crowd with your advanced MS Excel skills to that you can stay ahead in the workplace. Course Highlights Microsoft Excel 2010 Intermediate Level 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 Microsoft Excel 2010 Intermediate Level 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 10 hours, 40 minutes 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 Microsoft Excel 2010 Intermediate Level 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? Microsoft Excel 2010 Intermediate Level 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 Microsoft Excel 2010 Intermediate Level 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 2010 Intermediate Level Module One - Getting Started 00:30:00 Module Two - Working with Permissions and Options 01:00:00 Module Three - Sharing Workbooks 00:30:00 Module Four - Performing Advanced Formula and Function Tasks 01:00:00 Module Five - Working with Array Formulas 01:00:00 Module Six - Working with Functions 01:00:00 Module Seven - Working with Macros 01:00:00 Module Eight - Working with Forms 01:00:00 Module Nine - Applying Advanced Chart Features 01:00:00 Module Ten - Working with PivotTables and PivotCharts 01:00:00 Module Eleven - Using the Automated Analysis Tools Add -In 00:30:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities-Microsoft Excel 2010 Intermediate Level 00:00:00 Mock Exam Mock Exam- Microsoft Excel 2010 Intermediate level 00:20:00 Final Exam Final Exam- Microsoft Excel 2010 Intermediate level 00:20:00

Description As a beginner, do you want to learn about MS Access? Are you interested to know its various function and use? Do you want to be an expert in this field? If so, take a look at our MS Access 2016 Introduction course. It will assist you in understanding all you need to learn about this course. The course designs for the fresher who have a little or no basic knowledge of MS Access. It teaches you how to create, open, and save an Access database. It will acquaint you with the basic equipment such as ribbons and toolbar so that you can get access it flexibly to create a table, and store date smoothly. It introduces you to numeric and index field with a plenty of practical exercises so that you can learn the basic of MS Access 2016 effectively. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. 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? MS Access 2016 Introduction 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 MS Access 2016 Introduction 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. Introduction Introduction FREE 00:01:00 Getting Started What is a Database? 00:03:00 Understanding Database terminology 00:05:00 Navigating the Access Interface 00:06:00 What is a flat file database 00:04:00 What is a relational database 00:09:00 Relating Tables 00:06:00 Reviewing the Access Ribbon 00:04:00 Working with Data Working with Tables 00:04:00 Navigating Tables 00:02:00 Editing Data 00:03:00 Adding New Records 00:02:00 Using Subdatasheets 00:04:00 Creating Databases and Objects Understanding Database and Table Design Principles 00:10:00 Using Table Data Sheet View 00:04:00 Working with Field Data Types 00:04:00 Using Table Design View 00:04:00 Using Calculated Fields 00:04:00 Calculating Numbers 00:03:00 Calculating Dates 00:01:00 Calculating Strings 00:02:00 Using the Lookup Wizard 00:05:00 Editing Lookups 00:04:00 Using Indexes 00:02:00 Working with Queries What are Queries 00:03:00 Creating Simple Queries 00:05:00 Understanding the Dynaset 00:02:00 Entering Criteria: Exact Match and Range Operators 00:04:00 Understanding AND versus OR 00:03:00 Using Wild Cards 00:02:00 Using Keywords 00:03:00 Sorting and Hiding Fields 00:02:00 Creating Multi-Table Queries 00:03:00 Additional Tips 00:03:00 Working with Reports What are Reports 00:03:00 Understanding Report Types 00:03:00 Building Effective Reports 00:02:00 Using AutoReport 00:04:00 Understanding the Report Wizard 00:04:00 Using the Report Design View 00:08:00 Creating Labels 00:02:00 Working with Forms What are Forms 00:04:00 Understanding Form Types 00:02:00 Creating Forms 00:02:00 Navigating Forms 00:02:00 Editing Data in Forms 00:03:00 Understanding the Form Wizard 00:03:00 Using the Form Design View 00:04:00 Working with Controls 00:03:00 Using Form Layout View 00:02:00 Additional Tips 00:03:00 Conclusion Course Recap 00:01:00 Resources Resources - MS Access 2016 Introduction 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description Access 2016 is a software development and graphical user interface tool that assist you to collect, report, and analyze information for the reference. To become better at MS Access take a look at our well designed MS Access 2016 Advanced course. It will help you in understanding all you need to know about the MS Access. The course aims at the students' efficiency to improve their skill in the functions of an Access database. It teaches the learners how to form joint table and use table analyzer wizard effectively. The course incorporates the fundamental issues of MS Access such as automation process with the help of VBA, creation, and modification of switchboards, and function of table events. It enables the students to configure security and access for different environments providing knowledge with the multiple uses of tools and backup system. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. 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? MS Access 2016 Advanced 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 MS Access 2016 Advanced 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. Introduction Introduction FREE 00:01:00 Improving the Structure of a Database Using the Table Analyzer Wizard 00:05:00 Append Querying to Normalize a Table 00:08:00 Creating a Junction Table 00:06:00 Maintaining a Database Backing Up a Database 00:02:00 Using the Compact and Repair Database Tool 00:03:00 Using the Object Dependencies Tool 00:02:00 Using the Database Documenter Too 00:02:00 Using the Performance Analyzer Tool 00:02:00 Working with Access Switchboards Understanding the Access Switchboard 00:03:00 Using The Switchboard Manager 00:09:00 Modifying a Switchboard 00:05:00 Setting the Startup Options 00:04:00 Configuring Access for Multiple Users Using the database Splitter 00:04:00 Configuring Trusted Locations 00:02:00 Password Protecting a Database 00:03:00 Password Protecting Modules 00:01:00 Converting a Database to an ACCDE file 00:01:00 Automating Processes with VBA Understanding VBA Basics 00:06:00 Exploring Variables and Control Flow Statements 00:10:00 Exporting a Table or Query with VBA 00:06:00 Converting a Macro to VBA 00:02:00 Using Table Events Understanding Table Events 00:02:00 Using the Before Change Event Command 00:04:00 Using the After Change Event Command 00:04:00 Conclusion Course Recap 00:04:00 Resources Resources - MS Access 2016 Advanced 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: This Microsoft Access 2016 for Beginners will provide you the knowledge of how to Access is constructed and how to use the major objects within it. It allows you to create and manage database for all sorts of different purposes. It will help all novice computer users get up to speed quickly. It will also help more experienced users who have little to no experience with Microsoft Access and databases general. If you have the general knowledge of working with windows and want to improve your knowledge more you are welcome to join this course. Learning Outcomes: Get familiarized with Microsoft Access 2016, create simple databases, and use the help options Change table data, manage records, and create lookups Join data from different tables, sort and filter them, and perform calculations for queries Creating, adding controls, enhancing appearance and print preparation for reports How to utilize Access Options dialog box Relational database design, creating tables, managing table fields and creating table relationships Creating query joins and sub queries, joining tables with no common fields, relating data within a table, and working with sub datasheets Data normalization and creating junction tables Sharing Access data with other applications and through import and export options Managing reports through organizing information, formatting, including charts, adding calculated fields and sub-report inclusion to existing ones Create mailing label report and publishing reports in PDF format 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 Access 2016 for Beginners 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 Access 2016 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 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. Getting Started with Access Orientation to Microsoft Access 01:00:00 Create a Simple Access Database 01:00:00 Get Help in Microsoft Access 00:30:00 Working with Table Data Modify Table Data 00:30:00 Work with Records 01:00:00 Sort and Filter Records 00:30:00 Create Lookups 01:00:00 Querying a Database 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 Creating Advanced Queries 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 Generating Reports 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 Customizing the Access Environment The Access Options Dialog Box 01:00:00 Designing a Relational Database 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 Joining Tables 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 Organizing a Database for Efficiency Data Normalization 01:00:00 Create a Junction Table 00:30:00 Sharing Data Across Applications 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 Advanced Reporting 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 Additional Reporting Options Create a Mailing Label Report 00:30:00 Publish a Report as PDF 00:30:00 Activities Activities - Microsoft Access 2016 for Beginners 00:00:00 Mock Exam Mock Exam- Microsoft Access 2016 for Beginners 00:20:00 Final Exam Final Exam- Microsoft Access 2016 for Beginners 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: The Microsoft Excel program was designed to help people in their worksheets and spreadsheets. This course will teach you how to use SmartArt, pictures, text boxes and shapes to enhance your ability. You will learn to utilize many objects which have contextual tool tabs that appear when you select an object. Learn how to solve formula errors before they happen by using named ranges instead of cell references. Who is the course for? Professionals who want to learn about the Microsoft Excel 2013 advanced features. People who have an interest in knowing all the functions of Microsoft Excel 2013. 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 hard copy 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 recognized 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 Microsoft Excel Advanced course is a useful qualification to possess and would be beneficial for any Office job, such as: Admin Assistant PA Secretary Administrator Account Assistant Bookkeeper Accountant Office Manager. Microsoft Excel - Advanced Level Module One - Getting Started 01:00:00 Module Two - SmartArt and Objects 01:00:00 Module Three - Auditing 01:00:00 Module Four - Creating Charts 01:00:00 Module Five - Working with Charts 01:30:00 Module Six - Creating Pivot Tables and Pivot Charts 01:00:00 Module Seven - Macros 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 02:00:00 Module Eleven - Grouping and Outlining Data 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities-Microsoft Excel - Advanced Level 00:00:00 Mock Exam Mock Exam- Microsoft Excel - Advanced Level 00:20:00 Final Exam Final Exam- Microsoft Excel - Advanced Level 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00