1291 Courses delivered Online

Learning Outcomes Familiarise yourself with the basic to advanced level excel tools Learn the process of managing and modifying Workbooks Enrich your knowledge of Pivot Tables and Pivot Charts Develop your skills in data analysis Learn about lookup functions and formula editing Grasp the principles of data mapping and forecasting Microsoft Office 2016 Excel Beginner to Advanced Course Description At this time and age, it is pretty impossible to land a good job without some basic Excel skills. So, if you want to build an impressive resume, it is high time you acquire advanced-level Excel skills. It will uplift your CV and keep you ahead of the competition. The Microsoft Office 2016 Excel Beginner To Advanced course is the perfect place to develop your Excel skills. Here, you will learn basic to advanced-level Excel in no time. In this ultimate course, you will get the opportunity to establish a solid foundation in Excel. The course will first teach you the basic functions and formulas. Gradually, you will learn to work with multiple Worksheets. Furthermore, the course will introduce you to the essentials of Pivot Tables and Pivot Charts. In addition, you will know how to analyse data in Excel. The course will also show you the fundamentals of forecasting data and data mapping. At the end of the course, you will be able to take your Excel skills to the next level. This course will also provide you with a QLS- endorsed certificate and elevate your resume. Join now! Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Upon successful completion of the final assessment, you will be eligible to apply for the Quality Licence Scheme Endorsed Certificate of achievement. This certificate will be delivered to your doorstep through the post for £119. An extra £10 postage charge will be required for students leaving overseas.  CPD Accredited Certificate After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for 9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for 15.99, which will reach your doorsteps by post.  Method of Assessment At the end of the course, there will be an MCQ assessment. In order to pass this exam, you must score at least 60%. When you submit the assessment, it will be examined, and the results will be given to you immediately. Career path This Microsoft Office 2016 Excel Beginner to Advanced course is designed to help you extant your knowledge and understanding of this sector. After completing the course, you will be able to explore career options such as Data Analyst Receptionist Office Admin Data entry Officer Course Contents Microsoft Excel Beginners Getting Started with Microsoft Office Excel 2016 Performing Calculations Modifying a Worksheet Formatting a Worksheet Printing Workbooks Managing Workbooks Microsoft Excel Intermediate Working with Functions Working with Lists Analyzing Data Visualizing Data with Charts Using PivotTables and PivotCharts Microsoft Excel Advanced Working with Multiple Worksheets and Workbooks Using Lookup Functions and Formula Auditing Sharing and Protecting Workbooks Automating Workbook Functionality Creating Sparklines and Mapping Data Forecasting Data Resources

Description: Microsoft Office 2016 Complete Bundle Course (Word, Excel, PowerPoint, Outlook and Access) is intended to prepare you to get complete control on Microsoft Office 2016. It is designed to educate about Microsoft Office 2016. In this course, you will learn about the basic features of Microsoft Word such as creating a new document, personalizing the Microsoft Word interface, adding graphics, etc. Besides, you will learn about the techniques of controlling page appearance, proofing and editing a document. Following that, you will learn about the essentials to create and work with an electronic spreadsheet. You will be able to insert and delete text or images, adjust cells, create columns, rows and much more. This advanced course helps you to navigate the PowerPoint environment, create and save PowerPoint presentation, delivering advanced text editing etc. Finally, you will learn how to set up and use Outlook on Windows. It will assist you in creating and sending messages, managing contacts, using the calendar, managing tasks, working with notes and so much more. Overall, this course is created especially for you to provide all information to access Microsoft Office 2016. Enroll today and get benefit from this course. Learning Outcomes: Changing user information, sharing documents, working with comments and comparing document changes Collaborate on documents by reviewing them, merging changes and co-authoring Discover how to best use reference tools, like captions, cross-references, bookmarks, hyperlinks, footnotes, endnotes, citations and bibliographies Working with master documents and subdocuments Adding cover page; creating an index, table of contents, and ancillary tables; and managing outlines to simplify and manage large documents Suppressing information from a document, setting editing restrictions, adding digital signature platforms, and restricting document access Find out techniques for saving and exporting form data, along with creating and manipulating forms Using SharePoint Server with Word in order to create, compare and combine different document versions Ways to update worksheet properties, create and edit macros, applying conditional formatting and add data validation criteria Auditing worksheets through tracing cells, troubleshooting invalid data and formula errors, watching and evaluating formulas, and creating a data list online Create Sparklines, scenarios and interactive data using Power View Perform what-if analysis and statistical analysis with the Analysis ToolPak Ways to multitask by consolidating data, linking cells in different workbooks, and merging them Export Excel data, import delimited text files, integrate Excel data with the web and create web queries How to import and export XML data PowerPoint environment and how to modify it according to needs Customizing user interface and setting up options Create and manage sections, modify slide masters and slide layouts, add headers and footers, modify notes master and handout master Creating and modifying SmartArt Adding audio video to presentations and customizing animations and transitions to enhance presentation Better collaboration by adding comments, reviews, storing and sharing presentations on the web Setting up and creating custom slide shows, adding hyperlink and action buttons, and recording a presentation Security and distribution of presentations through various outlets Change message settings, properties, options, using automatic replies and inserting objects Sort and filter options, organising and searching messages, managing junk mail and mailbox Managing advanced calendar options, additional calendars, meeting responses, and assigning tasks Advanced, forward and export contact options, handling contacts and editing electronic business cards Sharing calendars and contacts whilst also delegating access to mail folders to others Modifying data file settings and backing up Outlook items Email security and configuring email message security Designing forms through adding and setting controls, creating subforms, using tab pages to organize information, improve navigation, formatting and applying conditional formatting Data, field, form and record validation Creating macros, restricting records using conditions, validate data, automate data entry and convert a macro to VBA in order to enhance user interface design Link tables to external data sources, manage database, determine object dependency, document database, and analyze database performance Allow multiple user access to database by splitting it, implement security, set passwords, convert Access database to ACCDE file, and add digital signatures Create and modify switchboards and startup options 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 Complete Bundle Course (Word, Excel, PowerPoint, Outlook and Access) 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 Complete Bundle Course (Word, Excel, PowerPoint, Outlook and Access) 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. Microsoft Word 2016 Modify User Information 00:15:00 Share a Document 00:30:00 Work with Comments 00:15:00 Compare Document Changes 00:15:00 Review a Document 00:15:00 Merge Document Changes 00:15:00 Coauthor Documents 00:15:00 Add Captions 00:15:00 Add Cross-References 00:15:00 Add Bookmarks 00:15:00 Add Hyperlinks 00:15:00 Insert Footnotes and Endnotes 00:15:00 Add Citations 00:30:00 Insert a Bibliography 00:15:00 Insert Blank and Cover Pages 00:15:00 Insert an Index 00:30:00 Insert a Table of Contents 00:30:00 Insert an Ancillary Table 00:15:00 Manage Outlines 00:30:00 Create a Master Document 00:30:00 Suppress Information 00:30:00 Set Editing Restrictions 00:30:00 Add a Digital Signature to a Document 00:15:00 Restrict Document Access 00:15:00 Create Forms 00:30:00 Manipulate Forms 00:15:00 Form Data Conversion 00:15:00 Create a New Document Version 00:30:00 Compare Document Versions 00:15:00 Merge Document Versions 00:15:00 Activities - Microsoft Word 2016 Advanced 00:00:00 Microsoft Excel 2016 Update Workbook Properties 00:15:00 Activity-Update Workbook Properties 00:05:00 Create and Edit a Macro 00:15:00 Activity-Create and Edit a Macro 00:05:00 Apply Conditional Formatting 00:15:00 Activity-Apply Conditional Formatting 00:05:00 Add Data Validation Criteria 00:15:00 Activity-Add Data Validation Criteriaty 00:05:00 Trace Cells 00:15:00 Activity-Trace Cells 00:05:00 Troubleshoot Invalid Data and Formula Errors 00:15:00 Activity-Troubleshoot Invalid Data and Formula Errors 00:05:00 Watch and Evaluate Formulas 00:15:00 Activity-Watch and Evaluate Formulas 00:05:00 Create a Data List Outline 00:15:00 Activity-Create a Data List Outline 00:05:00 Create Sparklines 00:15:00 Activity_Create Sparklines 00:05:00 Create Scenarios 00:15:00 Activity-Create Scenarios 00:05:00 Perform a What-If Analysis 00:15:00 Activity-Perform a What-If Analysis 00:05:00 Perform a Statistical Analysis with the Analysis ToolPak 00:15:00 Activity-Perform a Statistical Analysis with the Analysis ToolPak 00:05:00 Create Interactive Data with Power View 00:15:00 Activity-Create Interactive Data with Power View 00:05:00 Consolidate Data 00:15:00 Activity-Consolidate Data 00:05:00 Link Cells in Different Workbooks 00:15:00 Activity-Link Cells in Different Workbooks 00:05:00 Merge Workbooks 00:15:00 Activity-Merge Workbooks 00:05:00 Export Excel Data 00:15:00 Activity-Export Excel Data 00:05:00 Import a Delimited Text File 00:14:00 Activity- Import a Delimited Text File 00:05:00 Integrate Excel Data with the Web 00:15:00 Activity-Integrate Excel Data with the Web 00:05:00 Create a Web Query 00:15:00 Activity-Create a Web Query 00:05:00 Import and Export XML Data 00:15:00 Activity-Import and Export XML Data 00:05:00 Activities and Exercise Files - Microsoft Excel 2016 Advanced 00:00:00 Microsoft PowerPoint 2016 Customize the User Interface 01:30:00 Set PowerPoint 2016 Options 00:45:00 Create and Manage Sections 01:00:00 Modify Slide Masters and Slide Layouts 01:15:00 Add Headers and Footers 00:30:00 Modify the Notes Master and the Handout Master 00:45:00 Create SmartArt 00:45:00 Modify SmartArt 01:00:00 Add Audio to a Presentation 00:45:00 Add Video to a Presentation 01:00:00 Customize Animations and Transitions 01:00:00 Add Comments to a Presentation 00:45:00 Review a Presentation 00:45:00 Store and Share Presentations on the Web 01:30:00 Annotate a Presentation 00:45:00 Set Up a Slide Show 00:45:00 Create a Custom Slide Show 00:30:00 Add Hyperlinks and Action Buttons 00:45:00 Record a Presentation 00:15:00 Secure a Presentation 01:30:00 Present a Slide Show Online 01:00:00 Create a Video or a CD 00:45:00 Activities - Microsoft PowerPoint 2016 Advanced 00:00:00 Microsoft Outlook 2016 Insert Advanced Characters and Objects 01:30:00 Modify Message Settings, Properties, and Options 01:30:00 Use Automatic Replies 01:30:00 Sort Messages 00:45:00 Filter Messages 01:00:00 Organize Messages 02:00:00 Search Messages 01:30:00 Manage Junk Mail 01:00:00 Manage Your Mailbox 02:00:00 Manage Advanced Calendar Options 00:45:00 Manage Additional Calendars 01:00:00 Manage Meeting Responses 00:45:00 Assign and Manage Tasks 01:00:00 Edit an Electronic Business Card 01:00:00 Manage Advanced Contact Options 01:30:00 Forward Contacts 00:30:00 Export Contacts 01:00:00 Delegate Access to Mail Folders 01:00:00 Share Your Calendar 00:30:00 Share Your Contacts 00:15:00 Back Up Outlook Items 00:45:00 Change Data File Settings 00:45:00 Configure E-mail Message Security Settings 00:30:00 Activities - Microsoft Outlook 2016 Advanced 00:00:00 Microsoft Access 2016 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 Mock Exam Mock Exam- Microsoft Office 2016 Advanced 00:30:00 Final Exam Final Exam- Microsoft Office 2016 Advanced 00:30:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

The Microsoft Office Specialist (MOS) is a globally recognised qualification. Having a Microsoft Office Specialist certification on your CV demonstrates that you have gained the necessary expertise to competently use Microsoft applications, giving you a competitive advantage when job hunting as well as in the workplace. It will significantly increase your confidence, skills and employability. It will serve to objectively validate your IT skills and assist in your advancement in your chosen career.

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents, and interests with our special Azure AD PowerShell for Microsoft Office 365 Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides the professional training employers seek in today's workplaces. The Azure AD PowerShell for Microsoft Office 365 Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This Azure AD PowerShell for Microsoft Office 365 Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Azure AD PowerShell for Microsoft Office 365 Course, like every one of Skillwise's courses, is meticulously developed and well-researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At Skillwise, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from Skillwise, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Azure AD PowerShell for Microsoft Office 365? Lifetime access to the course forever Digital Certificate, Transcript, and student ID are all included in the price Absolutely no hidden fees Directly receive CPD Quality Standards accredited qualifications after course completion Receive one-to-one assistance every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Azure AD PowerShell for Microsoft Office 365 there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Azure AD PowerShell for Microsoft Office 365 course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skills. Prerequisites This Azure AD PowerShell for Microsoft Office 365 does not require you to have any prior qualifications or experience. You can just enroll and start learning. This Azure AD PowerShell for Microsoft Office 365 was made by professionals and it is compatible with all PCs, Macs, tablets, and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as a bonus, you will be able to pursue multiple occupations. This Azure AD PowerShell for Microsoft Office 365 is a great way for you to gain multiple skills from the comfort of your home. Section 01: Introduction Introduction 00:02:00 Section 02: PowerShell Basic Introduction PowerShell Introduction 00:05:00 PowerShell Console (PowerShell ISE, VS Code) 00:05:00 PowerShell Useful Commands (Get-Help) 00:04:00 PowerShell Useful Commands (Get-Command) 00:01:00 PowerShell Useful Commands (Get-Module) 00:03:00 Section 03: Visual Studio Code Editor Initial Setup Visual Studio Code Setup 00:02:00 VS Code Interface & Install PowerShell Ext 00:03:00 Write & Test PowerShell Script 00:02:00 Section 04: Connect to Azure Active Directory through PowerShell Azure Active Directory Introduction 00:04:00 Prerequisite & Install AZURE AD PS Module 00:03:00 Connect to Azure AD PowerShell with Microsoft Office 365 Subscription 00:04:00 Install All Office 365 Service's Module (To Prepare All-in-one Scripts) 00:03:00 All-in-one PowerShell Script to Connect all M365 Services 00:09:00 Section 05: Administration of Microsoft Office 365 User Accounts View Microsoft Office 365 User Accounts 00:05:00 Create Single Microsoft Office 365 User Account 00:09:00 Create Multiple Microsoft Office 365 User Accounts 00:04:00 Modify Microsoft Office 365 User Account Properties 00:08:00 Delete Microsoft Office 365 User Accounts 00:03:00 Block Microsoft Office 365 User Accounts 00:02:00 Section 06: Administration of Microsoft Office 365 Licenses and Service View M365 Licenses Details 00:04:00 View M365 License's Services Details 00:03:00 View Licensed and Unlicensed User's Details 00:03:00 Assign Licenses to Single User Account (Newer AzureAD Module) 00:07:00 Assign Licenses to Single User Account (Older AzureAD Module) 00:02:00 Assign Licenses to Multiple User Account 00:02:00 Assignment Assignment -Azure AD PowerShell for Microsoft Office 365 00:58:00 Order Your Certificate Order Your Certificate QLS

Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. Course Curriculum Introduction Introduction 00:02:00 PowerShell Basic Introduction PowerShell Introduction 00:05:00 PowerShell Console (PowerShell ISE, VS Code) 00:05:00 PowerShell Useful Commands (Get-Help) 00:04:00 PowerShell Useful Commands (Get-Command) 00:01:00 PowerShell Useful Commands (Get-Module) 00:03:00 Visual Studio Code Editor Initial Setup Visual Studio Code Setup 00:02:00 VS Code Interface & Install PowerShell Ext 00:03:00 Write & Test PowerShell Script 00:02:00 Connect To Azure Active Directory through Powershell Azure Active Directory Introduction 00:04:00 Prerequisite & Install AZURE AD PS Module 00:03:00 Connect to Azure AD PowerShell with Microsoft Office 365 Subscription 00:04:00 Install All Office 365 Service's Module (To Prepare All-in-one Scripts) 00:03:00 All-In-One PowerShell Script To Connect All M365 Services 00:09:00 Administration Of Microsoft Office 365 User Accounts View Microsoft Office 365 User Accounts 00:05:00 Create Single Microsoft Office 365 User Account 00:09:00 Create Multiple Microsoft Office 365 User Accounts 00:04:00 Modify Microsoft Office 365 User Account Properties 00:08:00 Delete Microsoft Office 365 User Accounts 00:03:00 Block Microsoft Office 365 User Accounts 00:02:00 Administration Of Microsoft Office 365 Licenses And Service View M365 Licenses Details 00:04:00 View M365 License's Services Details 00:03:00 Assign Licenses to Single User Account (Older AzureAD Module) 00:02:00 Assign Licenses to Multiple User Account 00:02:00

Let's give you three situations: Firstly, you need to write down a formal letter Then, your boss asks for annual employment records Finally, you have to make a presentation for the next conference How do you complete these tasks? Do you start making posters for your presentation or start calculating the records on hand? You can not imagine doing that this way. Right? Because it's time-consuming. You probably want to use software where you can complete your work efficiently. One of these software is Microsoft Office which most companies use. So, acquire your knowledge and expertise in Microsoft Office and flourish in your career. Apex Learning is offering you a comprehensive Microsoft Training course, where you can learn from the basics to advanced levels to learning about Microsoft Word, Microsoft PowerPoint, Microsoft Excel and many more. So, join this course for further learning! We included the latest knowledge about Microsoft to make you an exceptional candidate and well fit for the position. So, go through our learning material and acquire how to add, delete, and attach data, tables and pictures. Moreover, learn how to calculate data in Excel, how to create slides on PowerPoint and how to write documents in Word from this course. So, if you are keen to advance your skills in Microsoft Office, enrol in our Microsoft Training course now. Furthermore, to help you showcase your expertise in Microsoft, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest. This Microsoft Training Bundle Consists of the following Premium courses: Course 01: Microsoft SQL Server Development for Everyone Course 02: MS Word Diploma Course 03: Advanced Diploma in MS Excel Course 04: PowerPoint Diploma Course 05: The Complete Microsoft OneDrive Course Course 06: The Complete Microsoft Outlook Masterclass Course 07: Course 08: Complete Microsoft Power BI 2021 Course 09: Microsoft Teams Course 10: Course 11: Touch Typing Essentials Course 12: GDPR Data Protection Level 5 Course 13: Functional Skills IT Course 14: Time Management Learning outcomes: After completing this Microsoft Training course, learners will be able to: Learn about the fundamentals of Microsoft from this course Acquire how to work in Microsoft Word, Microsoft Excel and Microsoft PowerPoint Know more about attaching, adding, editing and deleting data in excel Deepen your understanding of managing various work in Microsoft Office Equip yourself with the knowledge of Microsoft office and advance your career in the future So, what are you waiting for? Enrol in the Microsoft Training course and start your learning journey now! The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Microsoft Trainingexpertise and essential knowledge, which will assist you in reaching your goal. Enrol now in Microsoft Training to advance your career, and use the premium study materials from Apex Learning. CPD 150 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Microsoft Training course is designed for everyone. More suitable for Students Recent Graduate A beginner who wants to learn about Microsoft Office An expert who wants to improve their skills in Microsoft Office Anyone with a knack for learning about Microsoft Office Requirements You don't need any specific skills or qualifications to enrol in this Microsoft Training course. Career path The expertise and knowledge you will gain after the completion of this Microsoft Training course will help you grab various opportunities, such as; Office Administrator Data Analyst Microsoft Security Specialist IT Support Analyst Software Tester The annual salary of these positions is between£25,000 - £50,000 per annum in the UK. Certificates Certificate of completion Digital certificate - Included

Master Microsoft Office 2021 with our comprehensive course. From Excel to PowerPoint and Word, learn essential tools and techniques for enhanced productivity and efficiency.

The Microsoft Office Course is designed to provide you with essential skills in MS Office applications that are integral to virtually every workplace, from multinational companies to local schools. Whether you're looking to enhance your everyday work or boost your resume, this course covers everything from Excel to Word, PowerPoint, and Access. By enrolling in this training, you will develop the necessary expertise to manage data, and create documents, presentations, and databases, all while improving your overall proficiency in Microsoft Office tools.

Course Objectives At the end of this course you will be able to: Identify the common objects of an Access database Design and build the structure of a database Input and maintain data Design user-friendly data entry forms Search the database using queries Generate reports from your data 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Tailored in company training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Introducing Microsoft Access The Access interface Database terminology Access database objects Fields and records Properties Designing a database Planning and designing a table Creating fields Setting common field properties Defining key fields Working with table data Entering and editing data Sorting and filtering table records Deleting records Relationships Why use table relationships? Relationship types Referential Integrity Working with table subdatasheets Querying a database Creating simple Select Queries Specifying query criteria Sorting query results Adding calculated fields Designing Forms Creating simple forms for data entry Designing custom forms Working with form sections Creating sub forms Designing Reports Creating basic list reports Working with grouping and sorting in a report Adding totals to a report Who is this course for? Who is this course for? This course is intended for the user that wants to explore the creation of a relational database. It will focus on the structuring of the database itself and the creation of the basic functional elements of a database in order to manage data. Requirements Requirements Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Career path Career path Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

Discover the power of Azure Active Directory (Azure AD) PowerShell to automate and advance the CLI administration of Microsoft Office 365 identity and access management.  The Azure Active Directory PowerShell for Microsoft Office 365 course will teach you how to install and use the new Visual Studio Code, familiarise you with Azure's most useful commands, and equip you with the skills to carry out a wide range of Azure AD administrative tasks.  This course is ideal for those who have basic PowerShell scripting knowledge and Office 365 Admin Centre knowledge. By the end of the course, you will be able to install the prerequisite Azure Active Directory (Azure AD) modules and software, and automate the established PowerShell connection to all Microsoft Office 365 services through the single script. This best selling Azure Active Directory PowerShell for Microsoft Office 365 has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Azure Active Directory PowerShell for Microsoft Office 365 is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Azure Active Directory PowerShell for Microsoft Office 365 is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Azure Active Directory PowerShell for Microsoft Office 365 is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Azure Active Directory PowerShell for Microsoft Office 365, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Azure Active Directory PowerShell for Microsoft Office 365 will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Azure Active Directory PowerShell for Microsoft Office 365 to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.