1296 Courses delivered Online

Level 2, 3 & 4 QLS Endorsed Diploma | QLS Hard Copy Certificate Included | Plus 10 CPD Courses | Lifetime Access

Course Objectives At the end of this course you will be able to: Do advance Table design Do advance Query design and Action Querys Do advance Form design with the use of macros and buttons Export and import data to and from different sources. 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. Our competitive rates start from £550.00 per day of training Tailored 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. Advanced Table Design Advanced Field Properties Table Properties Advanced Query Design Advanced Naming Conventions Join Tables in Queries Manage Query Joins Use Self-Joins in Queries Summarise Data in Queries Parameter Queries Action Queries Crosstab Queries Advanced Form Design Create Subforms and Linked Forms Form Controls Command Buttons Form Properties Interface, Start-Up and Navigations Forms Working with Macros Create Single Macros Run Macros Work with Sub Macros Use Conditional Macros Run Macros from Buttons Assign Macros to Events Extending Data Reach Import Data Export Data Work with Linked Tables Managing Databases Object Dependencies Database Documenter Performance Analyzers Regular Management of a Database Access Database Security Who is this course for? Who is this course for? The course is aimed at all users who would like to obtain the necessary skills to create advanced table, query, form and reports as well as to automate tasks with the use of macros. 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

Microsoft Office 365 is an innovative computer program and highly suggested for individuals who are regularly on the go. This Office 365 Core Apps course introduces you to the Microsoft Word, Excel, and PowerPoint Online apps which are an integral part of the Office 365 suite. By enrolling in this course, you'll acquire essential skills for producing professional work with the Microsoft Office suite and access many of the Office tools and features online from any device with an Internet connection. This course includes both basic and advanced features of MS Office and explains the difference in the online versions of Word, Excel, and PowerPoint, and how to edit the online documents. You'll also learn to open and save online documents in desktop versions of Office products. What Will I Learn? Open and save online files in Office Edit documents in Office Online Learn what is different in Microsoft Word, Excel, and PowerPoint Online View and add comments to documents Print and share documents Use co-authoring for collaboration Requirements Familiarity with the desktop versions of Microsoft Word, Excel, and PowerPoint Introduction Introduction FREE 00:02:00 Working with Word, Excel, and PowerPoint Online Opening Files in Office 00:06:00 Saving Files 00:04:00 Editing Documents in Office Online 00:04:00 What is Different in Word? 00:05:00 What is Different in Excel? 00:05:00 What is Different in PowerPoint? 00:06:00 Viewing and Adding Comments 00:07:00 Printing and Sharing Documents 00:06:00 Using Co-Authoring for Collaboration 00:04:00 Course Recap 00:01:00 Course Certification

Course Objectives At the end of this course you will be able to: Identify the components of the PowerPoint interface Create slides Format text on slides Add and modify graphical objects to a presentation Work with tables in a presentation Add charts to a presentation Prepare the SlideShow '1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk Customer Feedback Very patient Trainer. Happy to adapt course + help with problems on existing presentations. Andrea Lethbridge - CNN ' 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. Getting Started with PowerPoint Identify the Components of the PowerPoint Interface Create a PowerPoint Presentation Accessing Help Choose the right view for the task in PowerPoint Normal view Slide Sorter view Notes Page view Outline view Add, rearrange, and delete slides in PowerPoint Working with Themes Add colour and design to my slides with themes Remove the current slide design (theme) Slide Layout What is a slide layout? Apply or change a slide layout Working with text Add text to a slide Create a new text box Format text Tables Add a table to a slide Format a Table Copy and paste a table from Word Insert an Excel spreadsheet within PowerPoint Edit Cells, Rows and Columns Delete a table Graphics Working with Clipart, and Shapes Selecting objects, shapes, pictures or text boxes Arrange a picture, shape or other object Adding Charts to Your Presentation Create a Chart Format a Chart Insert a Chart from Microsoft Excel Inserting date and slide numbers Add slide numbers to your presentation Hide slide numbers on the title slide Change where the page numbers appear on your slides Start your slide numbering with a specific number Print slides, notes, or handouts Create the Slide Show Record your slide show Preview the recorded slide show Turn slide timings off Set the slide timings manually Add or remove transitions between slides Add Animations to Text and Objects Deliver the Presentation Speakers notes Add speaker notes to your slides View your speaker notes as you deliver your slide show Who is this course for? Who is this course for? This course is designed for end users who are interested in learning the fundamentals needed to create and modify engaging presentations. Requirements Requirements General knowledge of the Windows OS 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

Course Objectives This course aims to provide delegates with a foundation for Excel knowledge and skills. ' Customer Feedback Great course and excellent trainer. Thanks Tracy Preston - Western Power Distribution Very helpful course. Would definitely take another one. Pedro was very patient and made it fun and engaged with us all. Laura Smith - James Grant Very professional and well mannered, fun and pleasant at the same time. I learnt a lot Carolina Foster - CNN 1 year email support service Take a look at the consistent excellent feedback from trainees 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. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. What is Excel? The Excel Interface Ribbon, Tabs and Groups Microsoft Office Backstage view Working with Workbooks Create a blank Workbook Create a Workbook using a Template Opening and saving Files Working with worksheets Worksheet navigation Select one or multiple Worksheets Insert, Move, Copy or Delete a Worksheet Working with Cells, Rows & Columns Cell References How to select cells or ranges Different types of data Move, Copy and Delete cells Pasting Options Find and Replace Working with Rows and Columns Overview of formulas in Excel Autocalculation The parts of an Excel formula Using calculation operators in Excel formulas The difference between Absolute, Relative and Mixed references Using Excel functions; Sum, Average, Max and Min Cell Formatting Font Format options Number Format options Change the Fill and Borders Cell Alignment An Introduction to Charts Create a simple Chart Format your chart Page Layout and Print Page Layout and Page Break View Change the Page Orientation Set Page Margins Headers and Footers in a worksheet Print a worksheet or workbook Who is this course for? Who is this course for? For those who want to explore in more detail formulas and functions, data analysis and data presentation. Requirements Requirements General knowledge of the Windows OS Career path Career path Excel 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

Description: Are you not familiar with Office 2016 and want to learn every single detail of it? Then you are at the right place! Office 2016 Complete Course is designed for beginners to educate about Microsoft Office 2016. Initially, you will learn about the basic features of Microsoft Word such as creating a new document, personalizing the Microsoft Word interface, adding graphics, controlling page appearance, proofing and editing a document. Following that, you will learn about the foundations of Microsoft Office Excel that is essential to create and work with an electronic spreadsheet. You will be able to insert and delete text or images, create columns, rows and much more. Microsoft PowerPoint will help you in navigating the PowerPoint environment, create and save PowerPoint presentation, etc. Microsoft Outlook will help you to set up and use Outlook on Windows, also assist you in creating and sending messages, managing contacts, working with notes, etc. You will learn related information to access Microsoft Office 2016. Additionally, you will learn Project management basics, adding tasks and resources to a project and saving them. In the course, you will learn the essential features of the latest version of Microsoft Visio and the basic information about the diagramming software. Learning Outcomes: Word 2016 user interface, creating basic documents and utilizing help Managing text through modifying, finding and replacing, and selecting them; and arranging texts through tabs and lists Understanding the commands on the home tab and mini toolbar Paragraph layout tool, borders, shading, styles and formatting management techniques Maximizing your ability to utilize tables within Word 2016 Inserting symbols and special characters along with techniques for adding them Managing your page's appearance with colours, borders, watermarks, headers, footers and page setup dialog box Reviewing documents through spell check, research pane and thesaurus Document accessibility options Customizing the user interface, modifying save options and managing other file types Familiarize the excel user interface, creating basic worksheet and using the help system How to create formulas, reuse them and insert functions in a worksheet Managing cells, columns and rows and ways to manipulate data Utilizing the 'Search and replace' data options and spell checking Modifying fonts, adding borders and colours to cells, using number formats, aligning cell contents and applying cell styles Define and refine page layouts for printing options Managing large workbooks through worksheet tab formatting and using different views Options for general customization, language, formula, proofing and saving Customizing Quick Access toolbar, ribbon, advanced and Trust Center options Utilize Excel's version control features and enabling add-ins Utilize the PowerPoint user interface, creating and saving presentations, and using help Making presentations through presentation options like selecting types, building it, layouts, text editing, viewing and navigation Discover methods for formatting characters, paragraphs, and text boxes Adding images, screenshots, screen recordings, shapes and WordArt Modifying options for objects and animation features Creating and formatting a table and integrating data from other Microsoft Office applications Create format and manipulate a chart Navigate throughout the Outlook user interface and learn to perform basic email functions and utilize help Composing emails, grammar and spell checks, formatting content, attaching files, enhancing messages and managing automatic message responses Customize reading options, work with attachments and manage message responses Managing and organization of messages with the help of tags, flags, other commands and folders Using calendar options to manage appointments and meetings Using People workspace to create, update, view and organise contacts Managing tasks and notes Creating and managing Quick Steps, and customizing the interface according to needs 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 subqueries, 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 Project management basics, navigating and customizing the user interface, adding tasks and resources to a project and saving them Managing project time frames and changing working time Managing project tasks, adding summary tasks and milestones Managing project resources, allocating and levelling work resources Sharing and exporting projects, and adjusting project print views Navigation throughout Visio interface, creating basic drawing and using the help system Drawing components, modifying drawings and work with callouts and groups Organization charts creation, modifying their layouts, positioning and spacing Create and integrate organization chart copies and compare them Making a basic floor plan and custom room shapes, utilizing the program as a modelling tool and modelling room layouts Creating cross-functional flowcharts and related features like - swimlanes and separators Altering orientation and direction, changing margins and choosing styles for flowcharts Creating network diagrams, and utilizing shape data and layers Other network diagram relevant topics such as network shapes, shape data, adding layers, activating, colouring and more Working with shape, connector styles, themes, variants and containers 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? Office 2016 Complete 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 Office 2016 Complete 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.

QLS Endorsed Diploma! Free 3 QLS Certificates + Free 10 CPD Course & Assessments> 250 CPD Points > Lifetime Access

Course Objectives This course aims to provide delegates with a foundation for Excel knowledge and skills. ' Customer Feedback Great course and excellent trainer. Thanks Tracy Preston - Western Power Distribution Very helpful course. Would definitely take another one. Pedro was very patient and made it fun and engaged with us all. Laura Smith - James Grant Very professional and well mannered, fun and pleasant at the same time. I learnt a lot Carolina Foster - CNN 1 year email support service Take a look at the consistent excellent feedback from trainees 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. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. What is Excel? The Excel Interface Ribbon, Tabs and Groups Microsoft Office Backstage view Working with Workbooks Create a blank Workbook Create a Workbook using a Template Opening and saving Files Working with worksheets Worksheet navigation Select one or multiple Worksheets Insert, Move, Copy or Delete a Worksheet Working with Cells, Rows & Columns Cell References How to select cells or ranges Different types of data Move, Copy and Delete cells Pasting Options Find and Replace Working with Rows and Columns Overview of formulas in Excel Autocalculation The parts of an Excel formula Using calculation operators in Excel formulas The difference between Absolute, Relative and Mixed references Using Excel functions; Sum, Average, Max and Min Cell Formatting Font Format options Number Format options Change the Fill and Borders Cell Alignment An Introduction to Charts Create a simple Chart Format your chart Page Layout and Print Page Layout and Page Break View Change the Page Orientation Set Page Margins Headers and Footers in a worksheet Print a worksheet or workbook Who is this course for? Who is this course for? For those who want to explore in more detail formulas and functions, data analysis and data presentation. Requirements Requirements General knowledge of the Windows OS Career path Career path Excel 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 Certificates Certificates Certificate of completion Digital certificate - Included

Duration 1 Days 6 CPD hours This course is intended for This course is intended for people in a variety of roles and fields who have a basic understanding of Microsoft Office and want to incorporate digital note-taking and note collaboration by using Microsoft OneNote. In addition to creating and modifying OneNote notebooks, this course will introduce you to inserting images and embedding files into notebooks, categorizing content, sharing content with OneDrive, and exporting content to other file formats. Overview In this course, you will develop digital note-taking skills by creating, modifying, and managing OneNote notebooks that work with other Microsoft Office programs. You will: Navigate and customize the OneNote interface and environment. Add and format text, images, audio, links, and drawing objects to a notebook. Embed Excel spreadsheets and attach other files to a notebook. Categorize, organize, and search notebook content. Check spelling in, print, and password-protect notebooks. Use Outlook and OneDrive to send and share notebook content. Export notebook content and manage notebook history and backups. In our fast-paced digital world, the need to capture ideas, meeting notes, and to-do items is ever present. Microsoft© Office OneNote© for the Desktop provides a way for you to efficiently create and collect your notes in an electronic notebook. This course will introduce you to using OneNote notebooks to store a wide variety of content in an organized structure, access the content from anywhere, and also share it with others. Additionally, learning how OneNote and the other applications in the suite are integrated increases your productivity with Microsoft Office. This courseware is applicable to all users of the current OneNote desktop software. The classroom environment setup is based on the Office 2016 desktop application. Getting Started with OneNote Topic A: Navigate the OneNote 2016 Environment Topic B: Use Templates Topic C: Customize the OneNote User Interface Adding and Formatting Notebook Content Topic A: Apply Formatting to Notebook Content Topic B: Insert Images and Audio into a Notebook Topic C: Add Quick Notes and Links Topic D: Use Drawing Tools Embedding and Attaching Files Topic A: Embed Excel Spreadsheets Topic B: Attach Other File Types Organizing and Searching Notebooks Topic A: Use Tags Topic B: Organize and Search Notebooks Finalizing a Notebook Topic A: Proof and Print a Notebook Topic B: Configure Password Protection and Notebook Properties Managing Notebook Files Topic A: Export Content from OneNote Notebooks Topic B: Back Up and Restore Notebook Content Sending and Sharing OneNote Content Topic A: Send OneNote Content in Other Formats Topic B: Share OneNote Content by Using OneDrive

Dynamic Arrays in Microsoft Excel Training Course Overview Are you looking to begin your Microsoft Office Excel career or want to develop more advanced skills in Microsoft Office Excel? Then this dynamic arrays in Microsoft Excel training course will set you up with a solid foundation to become a confident office admin and help you to develop your expertise in Microsoft Office Excel. This dynamic arrays in Microsoft Excel training course is accredited by the CPD UK & IPHM. CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Whether you are self-taught and you want to fill in the gaps for better efficiency and productivity, this dynamic arrays in Microsoft Excel training course will set you up with a solid foundation to become a confident office admin and develop more advanced skills. Gain the essential skills and knowledge you need to propel your career forward as an office admin. The dynamic arrays in Microsoft Excel training course will set you up with the appropriate skills and experience needed for the job and is ideal for both beginners and those currently working as an office admin. This comprehensive dynamic arrays in Microsoft Excel training course is the perfect way to kickstart your career in the field of Microsoft Office Excel. This dynamic arrays in Microsoft Excel training course will give you a competitive advantage in your career, making you stand out from all other applicants and employees. If you're interested in working as an office admin or want to learn more skills on Microsoft Office Excel but unsure of where to start, then this dynamic arrays in Microsoft Excel training course will set you up with a solid foundation to become a confident office admin and develop more advanced skills. As one of the leading course providers and most renowned e-learning specialists online, we're dedicated to giving you the best educational experience possible. This dynamic arrays in Microsoft Excel training course is crafted by industry expert, to enable you to learn quickly and efficiently, and at your own pace and convenience. Who should take this course? This comprehensive dynamic arrays in Microsoft Excel training course is suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of Microsoft Office Excel. Entry Requirement There are no academic entry requirements for this dynamic arrays in Microsoft Excel training course, and it is open to students of all academic backgrounds. As long as you are aged seventeen or over and have a basic grasp of English, numeracy and ICT, you will be eligible to enrol. Method of Assessment On successful completion of the course, you will be required to sit an online multiple-choice assessment. The assessment will be evaluated automatically and the results will be given to you immediately.. Career path This dynamic arrays in Microsoft Excel training course opens a brand new door for you to enter the relevant job market and also provides you with the chance to accumulate in-depth knowledge at the side of needed skills to become flourishing in no time. You will also be able to add your new skills to your CV, enhance your career and become more competitive in your chosen industry. Recognised Accreditation CPD Certification Service 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. CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field. Quality Licence Scheme Endorsed The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees.     Certificate of Achievement Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35.   FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org