3108 Microsoft courses

Are you having trouble showcasing your data in important presentations? Then Microsoft Excel is a 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 2010, then this is the course for you. With Excel 2010, 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 2010. Gain access to new features such as sparklines, improved pivotCharts, slicer, Access spreadsheets from anywhere and many more. Whether you are a beginner or an advanced level user at Microsoft Excel 2010, this course will help you. You will be able to learn all the relevant information on how to analyze numbers, keep track of data, and graphically represent your information using various charts. Course Highlights Microsoft Excel 2010 Certified - Beginners, Intermediate & Advanced 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 Certified - Beginners, Intermediate & Advanced into 39 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 1 day, 7 hours 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 2010 Certified - Beginners, Intermediate & Advanced 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 Certified - Beginners, Intermediate & Advanced 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 Certified - Beginners, Intermediate & 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 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 for Beginners Module One - Getting Started FREE 00:30:00 Module Two - Opening and Closing Excel FREE 01:00:00 Module Three - Your First Worksheet 01:00:00 Module Four - Working with Excel Files 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Printing Excel Data 01:00:00 Module Seven - Building Formulas 01:00:00 Module Eight - Using Excel Functions 01:00:00 Module Nine - Using Time Saving Tools 00:30:00 Module Ten - Formatting Your Data 01:00:00 Module Eleven - Advanced Formatting Tools 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Accredited Microsoft Excel 2010 for Beginners 00:00:00 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-Microsoft Excel 2010 Intermediate Level 00:00:00 Microsoft Excel 2010 Advanced Level Module One - Getting Started 00:30:00 Module Two - SmartArt and Objects 01:00:00 Module Three - Auditing 01:00:00 Module Four - Creating Charts 01:00:00 Module Five - Creating Pivot Tables 01:00:00 Module Six - Working with PivotTables and PivotCharts 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 01:00:00 Module Eleven - Grouping and Outlining Data 00:30:00 Module Twelve - Wrapping Up 00:30:00 Activities-Certified Microsoft Excel 2010 Advanced Level- CPD & IAO Accredited 00:00:00 Mock Exam Mock Exam- Microsoft Excel 2010 Certified - Beginners, Intermediate & Advanced 00:20:00 Final Exam Final Exam- Microsoft Excel 2010 Certified - Beginners, Intermediate & Advanced 00:20:00

The Microsoft Publisher 2007 is word processing and publishing software. Since Publisher is a task-based desktop publishing tool, you will learn more advanced skills on working with publications, including print, e-mail, and web-based. Through this, you will learn the advanced skills, knowledge, and information about Publisher 2007 advanced level and learn how to use the Publisher task panes to help guide you through your tasks. Find out how to save your publications in a variety of formats to make your work easier. Course Highlights Accredited Microsoft Publisher 2007 Professional is an award-winning and the best selling course that has been given the CPD Qualification Standards & 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 Accredited Microsoft Publisher 2007 Professional 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 11 hours, 40 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 Accredited Microsoft Publisher 2007 Professional Lifetime access to the course No hidden fees or exam charges CPD Qualification Standards 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? Accredited Microsoft Publisher 2007 Professional is CPD Qualification Standards 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 Accredited Microsoft Publisher 2007 Professional 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 Qualification Standards 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 - Publisher Tasks 01:00:00 Module Three - Graphics and Objects 01:00:00 Module Four - Moving and Grouping Objects 01:00:00 Module Five - File Management 01:00:00 Module Six - Designing and Creating Websites 01:00:00 Module Seven - Page Layout 01:00:00 Module Eight - Working with Pictures 01:00:00 Module Nine - Media Files 01:00:00 Module Ten - Working With Text 01:00:00 Module - Eleven Mail E-mail and Catalog 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities - Accredited Microsoft Publisher 2007 Professional 00:00:00 Mock Exam Mock Exam- Accredited Microsoft Publisher 2007 Professional 00:20:00 Final Exam Final Exam- Accredited Microsoft Publisher 2007 Professional 00:20:00

Description: Created to become the world's premier database software, Microsoft Access has been a very big help to anyone at their day-to-day work. Learning about the basic functions and features of this application can change someone's working habit. Through this course, you will learn the necessary skills, knowledge, and information about Microsoft Access 2010. As long as you have data, you can learn and create a database of that data using Access. Who is the course for? New staff or workers who want to learn about the Microsoft Access 2010. People who have an interest in the basics and features of the Access 2010. 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 the cost of £39 or in PDF format at the 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 applying for NUS Extra Discount Card; 24/7 student support via email. Career Path: The Microsoft Access 2010 for Beginners course is a useful qualification to possess and would be beneficial for following careers: Software Engineer Technical Support Technical Sales Business Analyst Web Developer Software Tester. Microsoft Access 2010 for Beginners Module One - Getting Started FREE 00:30:00 Module Two - Getting Started With Access FREE 01:00:00 Module Three - Using the Access Interface 01:00:00 Module Four - Working with Database Objects 01:00:00 Module Five - Creating Tables 01:00:00 Module Six - Working with Tables 01:00:00 Module Seven - Creating Forms 01:00:00 Module Eight - Working with Forms 01:00:00 Module Nine - Creating Reports 01:00:00 Module Ten - Creating Queries 02:00:00 Module Eleven - Managing Your Database 01:00:00 Module Twelve - Wrapping Up 00:30:00 Mock Exam Final Exam

Highlights of the Course Course Type: Online Learning Duration: 4 Hours Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about Microsoft PowerPont Understand the core competencies and principles of Microsoft PowerPont Explore the various areas of Microsoft PowerPont Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert office admin Microsoft PowerPoint 2016/2019/365 - Foundations for Beginners Course Master the skills you need to propel your career forward in Microsoft PowerPoint. This course will equip you with the essential knowledge and skillset that will make you a confident office admin and take your career to the next level. This comprehensive Microsoft PowerPoint course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this Microsoft PowerPoint course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective Microsoft PowerPoint practice and equip you with the essential skills, confidence and competence to assist you in the Microsoft PowerPoint industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Microsoft PowerPoint. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for office admin or for people who are aspiring to specialise in Microsoft PowerPoint. Enrol in this Microsoft PowerPoint course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive Microsoft PowerPoint course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this Microsoft PowerPoint can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This Microsoft PowerPoint course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This Microsoft PowerPoint course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This Microsoft PowerPoint course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. 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 Getting Started With PowerPoint Navigate the PowerPoint Environment - Introduction 00:01:00 Navigate the PowerPoint Environment 00:11:00 View and Navigate a Presentation - Introduction 00:01:00 View and Navigate a Presentation 00:09:00 Create and Save a PowerPoint Presentation - Introduction 00:01:00 Create and Save a PowerPoint Presentation 00:07:00 Use PowerPoint Help - Introduction 00:01:00 Use PowerPoint Help 00:06:00 Developing a PowerPoint Presentation Select a Presentation Type - Introduction 00:01:00 Select a Presentation Type 00:06:00 Edit Text 00:10:00 Add, Delete and Modify Slides 00:09:00 Work with Themes - Introduction 00:01:00 Work With Themes 00:05:00 Performing Advanced Text Editing Operations Format Characters - Introduction 00:01:00 Format Characters 00:08:00 Format Paragraphs - Introduction 00:01:00 Text Alignment Options 00:08:00 Text Alignment Options 00:08:00 Format Text Boxes 00:10:00 Adding Graphical Elements to Your Presentation Add Graphical Elements to Your Presentation - Introduction 00:01:00 Insert Images 00:08:00 Insert Shapes 00:08:00 Modifying Objects in Your Presentation Modify Objects In Your Presentation - Introduction 00:01:00 Edit Objects 00:09:00 Format Objects 00:08:00 Animate Objects 00:06:00 Adding Tables to Your Presentation Add A Table - Introduction 00:01:00 Create a Table 00:05:00 Format a Table 00:07:00 Insert A Table From Others Office Applictions 00:08:00 Adding Charts to Your Presentation Add A Chart - Introduction 00:01:00 Create a Chart 00:07:00 Format a Chart 00:08:00 Insert a Chart from Microsoft Excel 00:03:00 Preparing to Deliver Your Presentation Prepare Your Presentation - Introduction 00:02:00 Review Your Presentation - Part 1 00:06:00 Review Your Presentation - Part 2 00:06:00 Apply Transitions 00:06:00 Print Your Presentation 00:06:00 Present a Slide Show 00:07:00 Export a Presentation to a PDF File 00:03:00 Bonus Lecture 00:01:00 What's New In PowerPoint 2019/365? Highlight Text 00:03:00 How to Adjust the Link Color 00:02:00 Draw and Write Digitally 00:04:00 Animate Freehand Drawings 00:04:00 Create Professional Slide Layouts With PowerPoint Designer 00:04:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Register on the Azure AD PowerShell for Microsoft Office 365 today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion. The Azure AD PowerShell for Microsoft Office 365 is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Azure AD PowerShell for Microsoft Office 365 Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Azure AD PowerShell for Microsoft Office 365, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content 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 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Description: Microsoft SharePoint, a cloud-based service, helps the company to share and collaborate with colleagues, partners and customers. In the Microsoft SharePoint 2016 For Administrators, you will learn how to access internal sites, documents, and other information from anywhere at any place using any device. Throughout the course, you will know the tricks and techniques of using Microsoft SharePoint. You will know how to create and configure site collocations, how to configure top-level sites, how to use workflows, etc. The course will also teach you the procedures of configuring site collocation metadata, setting up archiving and compliance policies, and the ways of configuring search options. Learning Outcomes: Create & backing up site collections, set quotas, and configure audit options Handle different features and apps Adding RSS feed to sites and creation and configuration of document sets Content type creation and adding columns to it Configure site policies, in-place records management, and information management policies Configure and utilize content organizer Understanding workflows and its composition SharePoint workflow planning and development Configuring and implementing search options and search alerts 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 SharePoint 2016 For Administrators 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 SharePoint 2016 For Administrators 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. Creating and Configuring Site Collections Create a Site Collection 00:45:00 Set Quotas 00:30:00 Configure Audit Options 00:30:00 Back Up a Site Collection 00:15:00 Configuring Top-Level Sites Managing Features and Apps 00:30:00 Add an RSS Feed to Your Site 00:30:00 Create and Configure Document Sets 01:00:00 Configuring Site Collection Metadata Create a New Content Type 01:15:00 Add Columns to Content Types 00:45:00 Archiving and Compliance Configure Site Polices 00:45:00 Configure In-Place Records Management 01:00:00 Configure Information Management Policies 01:15:00 Configure and Use the Content Organizer 01:15:00 Creating Workflows Understanding Workflows 00:30:00 Create and Run a Workflow 01:00:00 Implementing and Configuring Search Configure Search Options 01:00:00 Create Search Alerts 00:15:00 Activities Activities - Microsoft SharePoint 2016 For Administrators 00:00:00 Mock Exam Mock Exam- Microsoft SharePoint 2016 For Administrators 00:20:00 Final Exam Final Exam- Microsoft SharePoint 2016 For Administrators 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback 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 classrom, one to one, tailored and bespoke courses. Tailored In Company training: 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. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate course. 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

Whether you use excel for work or study, this online course covers beginner, intermediate and advanced lessons in excel. This course is designed to enable you to analyse lots of data and tell a story quickly and interactively. Explore various time-saving Formulas, create automated reports with the press of a button, amaze your manager with professional Excel Charts and get noticed by top management & prospective employers. Course Highlights Certified Diploma in Microsoft Excel 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 Certified Diploma in Microsoft Excel into 39 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 1 day, 9 hours 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 Certified Diploma in Microsoft Excel 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? Certified Diploma in Microsoft Excel 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 Certified Diploma in Microsoft Excel 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 for Beginners 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 - Microsoft Excel for Beginners CPD & IAO Accredited 00:00:00 Microsoft Excel - Intermediate Level 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- Microsoft Excel Intermediate Level CPD & IAO Accredited 00:00:00 Microsoft Excel - Advanced Level Module One - Getting Started FREE 01:00:00 Module Two - SmartArt and Objects FREE 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-Microsoft Excel Advanced CPD & IAO Accredited 00:00:00 Mock Exam Mock Exam- Certified Diploma in Microsoft Excel 00:30:00 Final Exam Final Exam- Certified Diploma in Microsoft Excel 00:30:00

Microsoft PowerPoint Foundations - 2016, 2019, 365 Training Course Overview Are you looking to begin your Microsoft PowerPoint career or want to develop more advanced skills in Microsoft PowerPoint? Then this Microsoft PowerPoint foundations - 2016, 2019, 365 online 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 PowerPoint. This Microsoft PowerPoint foundations - 2016, 2019, 365 online 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 Microsoft PowerPoint foundations - 2016, 2019, 365 online 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 Microsoft PowerPoint foundations - 2016, 2019, 365 online 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 Microsoft PowerPoint foundations - 2016, 2019, 365 online training course is the perfect way to kickstart your career in the field of Microsoft PowerPoint. This Microsoft PowerPoint foundations - 2016, 2019, 365 online 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 PowerPoint but unsure of where to start, then this Microsoft PowerPoint foundations - 2016, 2019, 365 online 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 Microsoft PowerPoint foundations - 2016, 2019, 365 online trainingcourse 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 Microsoft PowerPoint foundations - 2016, 2019, 365 online 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 PowerPoint. Entry Requirement There are no academic entry requirements for this Microsoft PowerPoint foundations - 2016, 2019, 365 online 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. Career path This Microsoft PowerPoint foundations - 2016, 2019, 365 online 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. Course Curriculum Getting Started With PowerPoint Navigate the PowerPoint Environment - Introduction Navigate the PowerPoint Environment View and Navigate a Presentation - Introduction View and Navigate a Presentation Create and Save a PowerPoint Presentation - Introduction Create and Save a PowerPoint Presentation Use PowerPoint Help - Introduction Use PowerPoint Help Developing a PowerPoint Presentation Select a Presentation Type - Introduction Select a Presentation Type Edit Text Add, Delete and Modify Slides Work with Themes - Introduction Work with Themes. Performing Advanced Text Editing Operations Format Characters - Introduction Format Characters Format Paragraphs - Introduction Text Alignment Options Text Alignment Options Format Text Boxes Adding Graphical Elements to Your Presentation Add Graphical Elements to Your Presentation - Introduction Insert Images Insert Shapes Modifying Objects in Your Presentation Modify Objects in Your Presentation - Introduction Edit Objects Format Objects Animate Objects Adding Tables to Your Presentation Module 01: Introduction To Bicycle Maintenance Create a Table Format a Table Insert A Table From Others Office Applictions Adding Charts to Your Presentation Add a Chart - Introduction Create a Chart Format a Chart Insert a Chart from Microsoft Excel Preparing to Deliver Your Presentation Prepare Your Presentation - Introduction Review Your Presentation - Part 1 Review Your Presentation - Part 2 Apply Transitions Print Your Presentation Present a Slide Show Export a Presentation to a PDF File Bonus Lecture What's New In PowerPoint 2019/365? Highlight Text How to Adjust the Link Color Draw and Write Digitally Animate Freehand Drawings Create Professional Slide Layouts with PowerPoint Designer 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

Microsoft Access 2010 is the world's premier database software. This course is designed for both beginners as well as for individuals who are looking into enhancing their skills and learn advanced techniques of Microsoft Access 2010. Explore and learn about various features of Access 2010. Learn about the database tool and how can you benefit from it. Gain the right information to use Access as professionals.In this course you will learn the necessary skills, knowledge and information of Microsoft Access.  Course Highlights Accredited Microsoft Access 2010 for Beginners, Intermediate & Advanced 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 Accredited Microsoft Access 2010 for Beginners, Intermediate & Advanced Level into 39 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 1 day, 10 hours 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 Accredited Microsoft Access 2010 for Beginners, Intermediate & Advanced 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? Accredited Microsoft Access 2010 for Beginners, Intermediate & Advanced 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 Accredited Microsoft Access 2010 for Beginners, Intermediate & Advanced 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 Access 2010 for Beginners Module One - Getting Started FREE 00:30:00 Module Two - Getting Started With Access FREE 01:00:00 Module Three - Using the Access Interface 01:00:00 Module Four - Working with Database Objects 01:00:00 Module Five - Creating Tables 01:00:00 Module Six - Working with Tables 01:00:00 Module Seven - Creating Forms 01:00:00 Module Eight - Working with Forms 01:00:00 Module Nine - Creating Reports 01:00:00 Module Ten - Creating Queries 01:00:00 Module Eleven - Managing Your Database 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities - Microsoft Access 2010 for Beginners 00:00:00 Microsoft Access Word 2010 Intermediate Level Module One - Getting Started 00:30:00 Module Two - Working with the Access Environment 01:00:00 Module Three - Working with Access Options (I) 01:00:00 Module Four - Working with Access Options (II) 01:00:00 Module Five - Working with Tables 01:00:00 Module Six - Importing Table Data 01:00:00 Module Seven - Working with Queries (I) 01:00:00 Module Eight - Working with Queries (II) 01:00:00 Module Nine - Working with Forms 01:00:00 Module Ten - Using Reports 01:00:00 Module Eleven - Using Macros and Code 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities - Certified Microsoft Access 2010 for Intermediate Level 00:00:00 Microsoft Access 2010 Advanced Level Module One - Getting Started 00:30:00 Module Two - Advanced Table Tasks 01:00:00 Module Three - Advanced Form Tasks 01:00:00 Module Four - Advanced Reporting Tasks 01:00:00 Module Five - Understanding Relationships 01:00:00 Module Six - Advanced Query Tasks 01:00:00 Module Seven - Working with SQL 01:00:00 Module Eight - Linking Data 01:00:00 Module Nine - Importing Data 01:00:00 Module Ten - Exporting Data 01:00:00 Module Eleven - Advanced Database Tools 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities - Microsoft Access 2010 Advanced Level Accredited 00:00:00 Mock Exam Mock Exam- Microsoft Access 2010 - Beginners, Intermediate, Advanced 00:30:00 Final Exam Final Exam- Microsoft Access 2010 - Beginners, Intermediate, Advanced 00:30:00