3264 Microsoft courses

Description: The new version tends to slow down the workflow despite being better and more efficient. The main objective of this training is to get familiar with the new features of Office 2010. This Microsoft Office 2010: New Features & Developments - Complete Video Course will introduce you to the new interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn the new features that are shared between all products in the Office suite, as well as the new features that are product specific. This series is going take a look at how to work with a new interface, you will also learn preview and a new item call backstage view, you will be introduced with some new features as: Excel Ribbon, the Cell Styles gallery in Excel, Live Preview, Dialog Box Launcher, Status-bar View Buttons in Excel, Zoom buttons and slider bar and more. 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 2010: New Features & Developments - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2010: New Features & Developments - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. The Office 2010 Interface Office Interface Elements FREE 00:15:00 New Ribbon Features 00:16:00 Microsoft Office Backstage View 00:25:00 New Word Features Formatting Options 00:06:00 The Navigation Pane 00:06:00 New Excel Features Sparklines 00:05:00 PivotTables and Slicers 00:13:00 PivotCharts 00:05:00 New PowerPoint Features Reading View 00:05:00 Sections 00:07:00 Media Clips 00:09:00 Animations 00:07:00 Broadcasting a Slide Show Online 00:05:00 New Outlook Features The Outlook Interface 00:07:00 Conversation Management 00:13:00 Quick Steps 00:12:00 The People Pane 00:10:00 New Access Features The Access 2010 Environment 00:03:00 Data Features 00:11:00 Mock Exam Mock Exam- Microsoft Office 2010: New Features & Developments - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2010: New Features & Developments - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description:  Whether you use excel for work or study, this online course covers beginner, intermediate and advanced lessons in excel. Learn the main topics related to Microsoft excel 2007. Identify the basic excel techniques, explore the advanced functions of excel 2007 and create automated reports with the press of a button in this course. By completing this course, you will become an excel expert and use excel 2007 as a professional. Who is the course for? This course is perfect for individuals who are looking forward to developing their skills of using Microsoft Excel application. This course is for office professionals who want to nail all the meetings and projects at the workplace. This course will be ideal for professionals in business, finance and many other areas that need to analyse data in accounts. Entry Requirement: This course is available to all learners, of all academic backgrounds. However, an education and experience in accounting is an advantage. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The diploma in Microsoft Excel 2007 will be very beneficial and helpful, especially to the following professionals: Admin Assistant. PA. Secretary. Administrator. Account Assistant. Bookkeeper. Accountant. Office Manager. Microsoft Excel 2007 for Beginners Module One - Getting Started 01:00:00 Module Two - Opening and Closing Excel 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 01:00:00 Module Ten - Formatting your Data 01:00:00 Module Eleven - More Formatting 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Excel 2007 for Beginners 00:00:00 Microsoft Excel 2007 Advanced Level Module One - Getting Started 00:30:00 Module Two - SmartArt 01:00:00 Module Three - Inserting Objects 01:00:00 Module Four - Creating Charts 01:00:00 Module Five - Creating Pivot Tables 01:00:00 Module Six - Working with Pivot Tables 01:00:00 Module Seven - Creating Pivot Charts 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 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Excel 2007 Advanced Level 00:00:00 Mock Exam Final Exam Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Project planning is an art. There is so much to it: coordinating, scheduling, calendaring, organizing, budgeting, costs, resource management, etc. Without the right tools, it can become overwhelming. In this Microsoft Project 2010 Advanced - Complete Video Course you will be introduced with the advanced project management features Microsoft Project has to offer such as critical paths, scheduling, and calendars. This series builds on the concepts and skills taught in the Basic course. You will learn how to work with templates, create baseline plans, monitor and update projects, analyze project statistics, handle delays and conflicts, consolidate project files, share resources, and customize Project. You will also learn how to communicate project information by using Project Server 2010 and how to integrate Project data with other Office applications. If you already have a good grounding in Microsoft Project, this course will provide you with the knowledge and skills to use Microsoft Project 2010 at an expert level. 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 Project 2010 Advanced - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Project 2010 Advanced - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Using Templates and Importing Data Working with Templates 00:12:00 Creating Projects From Other Projects 00:06:00 Managing a Project Setting Baselines 00:08:00 Updating an Active Project 00:19:00 Monitoring Progress 00:08:00 Analyzing and Adjusting the Plan Analyzing the Plan 00:07:00 Delays and Conflicts 00:17:00 Team Planner View 00:10:00 Working with Reports Standard Reports 00:12:00 Visual Reports 00:07:00 Customizing Project Custom Views 00:10:00 Working with Tables 00:07:00 Gantt Chart Formatting 00:00:00 Custom Fields 00:13:00 Managing Multiple Projects Consolidating and Sharing Projects 00:15:00 Sharing Resources Among Projects 00:04:00 Exchanging Project Information Collaboration 00:03:00 Hyperlinks 00:03:00 Exporting to Office Applications 00:09:00 Mock Exam Mock Exam- Microsoft Project 2010 Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Project 2010 Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

This course will fully prepare you for virtually any Excel-related career path

Description: This Microsoft Office 2013 PowerPoint Advanced - Complete Video Course covers more advanced features of PowerPoint 2013. In this series, you will learn how to modify the PowerPoint environment, using methods like customizing design templates, working with media and animations, and adding SmartArt to a presentation, customizing a slide show and securing and distributing a presentation, use tables and spreadsheets to display data in a presentation, learn how to add, format and edit charts with the chart tools and quick clicks, design slide masters and apply slide transitions, apply animations to images in a slide show and edit the timing, add videos to a PowerPoint presentation and trim the media, practice delivering presentations with the presenter's tools, use the review tools to proof and protect presentations, and more. If, you have the basic skills with Microsoft Office 2013 PowerPoint and want to learn advanced-level skills then this course will be perfect for you. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2013 PowerPoint Advanced - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2013 PowerPoint Advanced - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Modifying the PowerPoint Environment Customize the User Interface FREE 00:12:00 Set PowerPoint 2013 Options 00:04:00 Customizing Design Templates Modify Slide Masters and Slide Layouts 00:12:00 Add Headers and Footers 00:06:00 Modify the Notes Master and the Handout Master 00:04:00 Adding SmartArt to a Presentation Create SmartArt 00:06:00 Modify SmartArt 00:07:00 Working with Media and Animations Add Audio to a Presentation 00:13:00 Add Video to a Presentation 00:12:00 Customize Animations and Transitions 00:14:00 Collaborating on a Presentation Review a Presentation 00:18:00 Store and Share Presentations on the Web 00:11:00 Customizing a Slide Show Annotate a Presentation 00:04:00 Set Up a Slide Show 00:04:00 Create a Custom Slide Show 00:04:00 Add Hyperlinks and Action Buttons 00:10:00 Record a Presentation 00:07:00 Securing and Distributing a Presentation Secure a Presentation 00:09:00 Broadcast a Slide Show 00:08:00 Create a Video or a CD 00:09:00 Mock Exam Mock Exam- Microsoft Office 2013 PowerPoint Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2013 PowerPoint Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Excel Advanced Course Please Note: This course uses the Windows version of Microsoft Office 2016. Any other versions will have some differences in the functions. The Microsoft (MS) Excel Certification Level 3 Course is the most comprehensive of the three Excel courses presented here. If a team member has successfully completed the Level 1 and Level 2 courses, they will be fully prepared to start the Level 3 course. Formulae or functions are what advanced users of Excel want from this tool. When you use formulae, not only can you see the data that you require for your work, you can also analyse it and get answers to complex questions. Although anyone with some Excel knowledge can use formulae, such as SUM, a user who has the advanced Excel skills presented in this course will use other formulae, both alone and combined, such as MATCH, INDEX, DSUM and VLOOKUP. In addition to knowing and using these formulae, an advanced user of Excel knows how to debug these formulae, how to audit them and how to choose the perfect formula for the particular task to be carried out.   What's Covered in the Course? Any staff member choosing to study this course can expect to gain the following skills: How to set A Password to an Excel document; VLOOKUP Advanced formula options and manipulations; Other advanced functions: OR, AND, CHOOSE, INDIRECT, REPLACE, LEN, LEFT, FIND; Functions of CEILING, CORREL, DATEDIF, DATEVALUE, DAVERAGE and EDATE; Colouring a column and row with a formula; Highlighting a cell with a formula; Functions of ISODD, ISNUMBER, ISTEXT, ISLOGICAL, ISNONTEXT, ISERR and ISBLANK; Functions of DGET, DMAX, DPRODUCT, DCOUNTA, DCOUNT and DSUM; How to calculate depreciation in Excel, including SLN depreciation and SYD depreciation; Calculating loan IPMT and EMI; Functions of DATEDIF, DATEVALUE, EDATE, EOMONTH, MATCH and INDEX; Full explanation of the INDEX and MATCH functions; Looking up data; Selecting only cells containing comments; Hiding formulae; Automatically inserting serial numbers;   The employee will also learn about calculating depreciation, calculating interest and calculating IPMT and EMI for loans, all by using Excel functions. The course features information on INDEX and MATCH functions, which is important in certain industries and roles. It also shows learners how to use the CHOOSE formula and how to create special charts. What are the Benefits of the Course? Upon completion of the Level 3 course, the employee will have access to the full functionality of Excel and will know how to use all of its formulae, functions and capabilities; The Level 3 Excel course is designed for 'power' users, but not only for programmers and those interested in financial modelling; Competent Excel users add huge value to an organisation, through advanced data analysis.

Overview This comprehensive course on Microsoft Excel - 25 Must-Know Formulas and Functions will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Microsoft Excel - 25 Must-Know Formulas and Functions comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast-track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Microsoft Excel - 25 Must-Know Formulas and Functions. It is available to all students, of all academic backgrounds. Requirements Our Microsoft Excel - 25 Must-Know Formulas and Functions is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 2 sections • 2 lectures • 01:12:00 total length •Must-Know Formulas and Functions: 01:12:00 •Resource - Microsoft Excel - 25 Must-Know Formulas and Functions: 00:00:00

Description: Microsoft OneNote 2007 is a powerful tool that helps you to organize your projects and ideas. This course is designed to provide a basic understanding of OneNote 2007. During this course, students will learn everything they need to know on how to create custom note books and pages to store all the details they work with every day. Students will also learn how to use the popular OneNote features including working with a graphics tablet, taking screen clippings, creating hyperlinks and much more. In this course students will learn the necessary skills, knowledge and information of Microsoft One Note 2007.  Who is this course for? This course would be ideal for Microsoft Office users, students and office workers who want to learn about Microsoft one note 2007. This course would be ideal for individuals who want to learn how to use the new features of this application. 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 career advancement opportunities; 24/7 student support via email. Career Path: The Microsoft One Note 2007 for Beginners will be very beneficial and helpful, especially to the following professionals: Event planner Project manager Real estate agent Travel agent Teacher Lawyer Microsoft One Note 2007 for Beginners Module One - Getting Started 00:30:00 Module Two - Opening and Closing One Note 01:00:00 Module Three - Your First Notebook 01:00:00 Module Four - Basic Editing Tasks 01:00:00 Module Five - Working with Pages 01:00:00 Module Six - Adding Objects to Your Notebook 01:00:00 Module Seven - Advanced One Note Objects 01:00:00 Module Eight - Drawing in One Note 01:00:00 Module Nine - Managing Notes 01:00:00 Module Ten - Working with Notebooks 01:00:00 Module Eleven - Adding the Finishing Touches 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities - Microsoft One Note 2007 for Beginners 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

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.

Duration 2 Days 12 CPD hours This course is intended for The course is targeted at professionals who have never worked with Microsoft 365 before, or who have yet to move beyond its basic functions. The target audience typically includes individuals, professionals, and organizations who are looking to improve their productivity, collaboration, and communication using the suite of applications and services provided by Microsoft 365. This could include office workers, project managers, IT professionals, and small to large-scale businesses who want to maximize the benefits of cloud-based solutions for their daily operations.  Overview Upon successfully completing this course, students will have confidence in using the Microsoft 365 applications. Students will increase their work productivity and decrease time on completing tasks. In this course, students will learn how to use different tools of Microsoft 365 for better online collaboration, including OneDrive, SharePoint, Teams, Excel, Outlook, Word, and PowerPoint. First Steps in Office 365 The Difference Between Office 365 and Microsoft 365 Pros and cons of Microsoft 365 First Steps on mobile devices OneDrive Introduction - What is Microsoft OneDrive? How To Access Microsoft OneDrive? Upload Files Share Files Sync Files Recycle Bin Using OneDrive How To Access Onedrive On Phone? Teams - Simplify Collaboration within Companies Discover new ways to collaborate and communicate An introduction to your central place in Office 365 How to launch and install Teams The Interface of Microsoft Teams Use the Teams window to structure your organization Use Channels to structure the Teams window Use Tabs to access tools and information Communicate with others via Chat Keep track of activities Meetings, video conferencing and screen sharing Share files effectively Manage teams and permissions for organizational structuring Use Teams effectively on mobile devices Final remarks SharePoint Sites Introduction First Steps Document Library - First Steps Document Library - Set and Manage Alerts Document Library - Understanding Versioning Sync Libraries Share a Site Picture Library Lists Calendar Tasks Discussion Board Outlook First Steps in Mail Improved Search Function Work with Folders Settings Working with the Mail App Calendar People Tasks Excel Online Introduction Open and Edit an Excel Online Workbook Limitations of Excel Online Create a New Workbook with Excel Online Edit a Workbook Simultaneously with another Person Working with the Excel AppUse Excel effectively on mobile devices PowerPoint Online Introduction Open a PowerPoint Online Presentation Edit a Presentation Online Limitations of PowerPoint Online Create a Presentation with PowerPoint Online Working with the PowerPoint App Use Power Point effectively on mobile devices Word Online Introduction Open and Edit a Word Document Online Limitations of Word Online Create a New Document Edit a Document Simultaneously Working with the Word App