3052 Microsoft courses in March delivered Online

Become the Microsoft Excel Magician and Impress Everyone! Do you want to be the go-to person in your office for Microsoft Excel? Do you want to be able to complete tasks in seconds that would take others hours? If so, then you need to master the magic of Microsoft Excel functions and formulas. In this Microsoft Excel 2019 course, you will learn everything you need to know to become an Microsoft Excel magician. You will learn how to use the most powerful functions and formulas in Microsoft Excel to automate your work, analyse data, and create stunning visualisations. Why would you choose the Microsoft Excel course: Lifetime access to Microsoft Excel course materials Full tutor support is available from Monday to Friday with the Microsoft Excel course Learn Microsoft Excel skills at your own pace from the comfort of your home Gain a complete understanding of Microsoft Excel course Accessible, informative Microsoft Excel learning modules designed by experts Get 24/7 help or advice from our email and live chat teams with Microsoft Excel Study Microsoft Excel in your own time through your computer, tablet or mobile device. A 100% learning satisfaction guarantee with your Microsoft Excel course Microsoft Excel Specialist - Advanced Microsoft Excel Formulas and Functions Curriculum Breakdown Microsoft Excel 2019 New Features Getting Started with Microsoft Excel Performing Calculations Modifying a Worksheet Formatting a Worksheet Printing Workbooks Managing Workbooks Working with Microsoft Excel Functions Working with Lists Analyzing Data with Microsoft Excel Visualizing Data with Charts Using PivotTables and PivotCharts Working with Multiple Worksheets and Workbooks Using Lookup Functions and Formula Auditing Sharing and Protecting Workbooks Automating Workbook Functionality Creating Sparklines and Mapping Data Forecasting Data with Microsoft Excel CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Microsoft Excel course helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Microsoft Excel. It is also great for professionals who are already working in Microsoft Excel and want to get promoted at work. Requirements To enrol in this Microsoft Excel Specialist - Advanced Excel Formulas and Functions course, all you need is a basic understanding of the English Language and an internet connection. Career path The Microsoft Excel Specialist - Advanced Excel Formulas and Functions course will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Excel Specialist - Advanced Excel Formulas and Functions. Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Description: Microsoft Windows 8 is the latest iteration of Microsoft's widely used Windows operating system. This new version of Windows incorporates hundreds of new features as well as improvements to existing ones. By this Microsoft Windows 8 Professional Operating System you will learn what you need on any computer running the Windows 8 Pro operating system. With work and play functionality, Windows gives you the power to quickly browse websites, watch movies, play games, polish your resume and pull together a killer presentation all on a single PC. So, if you want to improve your skills on this professional level, you can join this course. Learning Outcomes: Take a look at the new File Explorer application previously known as Windows Explorer by learning how to use the program, customizing it, and changing folder and search options Get more information regarding the Recycle Bin Use libraries and search options to improve your organisation Learn about administrative file tools - like command prompt and PowerShell - and create, manage and edit files and folders Share files and folders using the Charms bar and file explorer Catch up on the security tools including Action Centre, Windows Defender, Windows Firewall, and the Family Safety Centre features 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 Windows 8 Professional Operating System 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 Windows 8 Professional Operating System is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Microsoft Windows 8 Professional Operating System Using File Explorer 00:30:00 Customizing File Explorer 00:30:00 Changing Folder and Search Options 00:30:00 Working with the Recycle Bin 00:30:00 Customizing Libraries 00:30:00 Creating a New Library 00:30:00 Searching from the Charms Bar 00:30:00 Searching from the Desktop 00:30:00 Creating Files and Folders 00:30:00 Managing Files and Folders 00:30:00 Working with Files 00:30:00 Making a File or Folder Easy to Access 00:30:00 Using Administrative File Tools 00:30:00 Sharing Files from the Charms Bar 00:30:00 Sending Files from File Explorer 00:30:00 Sharing Files from File Explorer 00:30:00 Using Zipped Folders 00:30:00 Using the Action Center 00:30:00 Using Windows Defender 00:30:00 Using Windows Firewall 00:30:00 Keeping Your Family Safe, Part One 00:30:00 Keeping Your Family Safe, Part Two 00:30:00 Mock Exam Mock Exam- Microsoft Windows 8 Professional Operating System 00:20:00 Final Exam Final Exam- Microsoft Windows 8 Professional Operating System 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Highlights of the Course Course Type: Online Learning Duration: 3 Hours 5 Minutes 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 Word Understand the core competencies and principles of Microsoft Word Explore the various areas of Microsoft Word Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert office admin Microsoft Office Word 2016: Part 3 (Advanced) Training Course Master the skills you need to propel your career forward in Microsoft Word. 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 Office Word advanced course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this Microsoft Office Word advanced 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 Word practice and equip you with the essential skills, confidence and competence to assist you in the Microsoft Word industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Microsoft Word. 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 Word. Enrol in this Microsoft Office Word advanced 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 Office Word advanced 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 Word 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 Office Word advanced 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 Office Word advanced 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 Office Word advanced 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 Manipulating Images Manipulate Images - Introduction 00:01:00 Integrate Pictures and Text 00:08:00 Adjust Image Appearance 00:06:00 Compress Pictures 00:03:00 Insert Other Media Elements - Introduction 00:01:00 Insert Other Media Elements 00:06:00 Using Custom Graphic Elements Use Custom Graphic Elements - Introduction 00:00:00 Create Text Boxes and Pull Quotes 00:05:00 Add WordArt and Other Text Effects 00:07:00 Draw Shapes 00:07:00 Create Complex Illustrations with SmartArt - Introduction 00:01:00 Create Complex Illustrations with SmartArt 00:05:00 Collaborating on Documents Collaborate on Documents - Introduction 00:02:00 Prepare a Document for Collaboration - Part 1 00:06:00 Prepare a Document for Collaboration - Part 2 00:07:00 Mark Up a Document Part 1 00:04:00 Mark Up a Document - Part 2 00:06:00 Merge Changes from Other Documents - Introduction 00:01:00 Merge Changes from Other Documents 00:05:00 Adding Document References and Links Add Document References and Links - Introduction 00:01:00 Add Captions 00:04:00 Add Bookmarks 00:05:00 Add Hyperlinks 00:04:00 Insert Footnotes and Endnotes 00:06:00 Add Citations 00:09:00 Add a Bibliography 00:04:00 Securing a Document Secure a Document - Introduction 00:01:00 Suppress Sensitive Information 00:06:00 Set Formatting and Editing Restrictions 00:06:00 Restrict Document Access 00:04:00 Add a Digital Signature to a Document - Introduction 00:01:00 Add a Digital Signature to a Document 00:08:00 Using Forms to Manage Content Use Forms to Manage Content - Introduction 00:01:00 Create Forms 00:08:00 Automating Repetitive Tasks with Macros Automate Repetitive Tasks with Macros - Introduction 00:01:00 Automate Tasks by Using Macros 00:04:00 Identify Word Macro Uses and Concerns - Introduction 00:01:00 Identify Word Macro Uses and Concerns 00:04:00 Create a Macro - Introduction 00:01:00 View the Code for an Existing Macro 00:06:00 Record a Macro 00:05:00 Add Custom Code to a Recorded Macro 00:10:00 Course Follow-Up 00:01: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

Course Objectives At the end of this course you will be able to: Manage project costs Consolidate and reuse project plan information Exchange project plan data with other applications Update a project plan Customise Project to meet specific requirements ' 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 Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great. Kelly Moreley - TACT Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further Jenny Price - Acer ' 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. Exchanging Project Plan Data with Other Applications Import a list of tasks from Outlook Import a Task List from an Excel File Create a Custom Import Map Export Project Plan Cost Data into Excel Save Project Plan Information as a Web Page Updating a Project Plan Enter Task Progress Information View Task Progress Split a Task Reschedule a Task Creating Custom Fields Text fields Lookup fields Calculated fields with the use of formulas and functions Inserting Graphical Indicators Customizing how you look at data Filter Tasks in a Project Plan Create a Custom Table Create a Custom View Copy custom Views and Tables between projects Earned value analysis Understanding Earned Value Fields View Multiple Baselines in a Single Project Tracking progress between interim plans Creating Custom Reports Create a Custom Report Modify a Custom Report's Header and Footer Add a Picture to a Report Modify a Custom Report's Margins Print a Custom Report Re-using Project Plan Information Create a Project Plan Template Create a Custom Combination View Make Custom Views Available to Other Project Plans Share Resources between Projects, Create a Master Project Plan with sub projects Who is this course for? Who is this course for? This course is designed for those that who already have the skills to create and modify project plans and would like to acquire a more in depth and thorough knowledge of more advanced functionalities in project planning and tracking. Requirements Requirements Preferably, delegates would have attended the MS Project Introduction course. 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

Overview This comprehensive course on Introduction to Microsoft Ads Training will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Introduction to Microsoft Ads Training 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 Introduction to Microsoft Ads Training. It is available to all students, of all academic backgrounds. Requirements Our Introduction to Microsoft Ads Training 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 • 14 lectures • 01:08:00 total length •Lesson 1 - Microsoft Ads Training: 00:02:00 •Lesson 2 - Microsoft Ads Training: 00:02:00 •Lesson 3 - Microsoft Ads Training: 00:01:00 •Lesson 4-5 - Microsoft Ads Training: 00:02:00 •Lesson 6-10 - Microsoft Ads Training: 00:07:00 •Lesson 11-15 - Microsoft Ads Training: 00:11:00 •Lesson 16-20 - Microsoft Ads Training: 00:06:00 •Lesson 21-25 - Microsoft Ads Training: 00:07:00 •Lesson 26-30 - Microsoft Ads Training: 00:06:00 •Lesson 31-35 - Microsoft Ads Training: 00:06:00 •Lesson 36-40 - Microsoft Ads Training: 00:06:00 •Lesson 41-45 - Microsoft Ads Training: 00:06:00 •Lesson 46-50 - Microsoft Ads Training: 00:06:00 •Resource - Introduction to Microsoft Ads Training: 00:00:00

Description: In these days Keeping knowledge about data is an important part of your career. That's because to stand out in the workplace, you've got to be able to find information fast and to identify game-changing insights. This Microsoft Office 2013 Access Basic - Complete Video Course covers the basic functions and features of Access 2013. This course is designed to make you comfortable with what a database is all about and how to move around the screen. You will learn about working with table data, querying a database, how to create a simple database, and creating advanced queries. You will also learn how to generate reports and customize the Access environment. Here, you will get oriented with Microsoft Access, Windows Components, and more. This course will give you a basic understanding of the many Access 2013 features that will enable you to gather and interpret data faster than everyone else. 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 Access Basic - 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 Access Basic - 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. Getting Started with Access Orientation to Microsoft Access FREE 00:48:00 Create a Simple Access Database 00:28:00 Get Help in Microsoft Access 00:05:00 Working with Table Data Modify Table Data 00:13:00 Sort and Filter Records 00:06:00 Create Lookups 00:15:00 Querying a Database Join Data from Different Tables in a Query 00:14:00 Sort and Filter Data in a Query 00:19:00 Perform Calculations in a Query 00:11:00 Creating Advanced Queries Create Parameter Queries 00:11:00 Create Action Queries 00:08:00 Create Unmatched and Duplicate Queries 00:06:00 Summarize Data 00:09:00 Generating Reports Create a Report 00:10:00 Add Controls to a Report 00:08:00 Enhance the Appearance of a Report 00:05:00 Prepare a Report for Print 00:03:00 Customizing the Access Environment The Access Options Dialog Box 00:06:00 Mock Exam Mock Exam- Microsoft Office 2013 Access Basic - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2013 Access Basic - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Microsoft SharePoint is a web-based, collaborative platform that is a strong document management and storage system. Microsoft SharePoint 2016 Complete Course has been designed so that you, an administrator, site owner or a normal user, can fully garner knowledge about this web-based application and use it to full potential. In this course, for administrators, you will learn about the interface of SharePoint Team sites: opening, navigating, working, sharing contents, using communication features, etc. For site owners, you will learn to create a new site, adding and configuring libraries, site settings, assigning permission and rights. For the users, you will learn to share and edit contents, accessing SharePoint and using alternative methods. Learning Outcomes: Accessing and navigating through SharePoint sites Adding documents and searching in SharePoint sites Filter, group and sort lists, while also adding item to lists, modifying them and configuring views Collaborating with others by sharing and updating profiles, sharing and following content, and creating blog posts Using SharePoint across other Microsoft Office programs like Outlook Integrate SharePoint with OneDrive and using it on mobile devices Create and design SharePoint sites Management of document library, the site assets library, and adding wikis for sites How to add blogs and adding & configuring lists like - announcement list, task list, contact list, calendar lists and custom lists Site setting management through search options, administration settings and navigation settings Managing access rights through site permission configuration, security options and security components 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? Level 3 Diploma in Microsoft SharePoint 2016 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 Level 3 Diploma in Microsoft SharePoint 2016 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. Module : 1 Access SharePoint Sites 00:15:00 Navigate SharePoint Sites 00:15:00 Adding Documents 00:15:00 Searching SharePoint 00:15:00 Add Items to Lists 00:15:00 Modifying List Items 00:15:00 Configure List Views 00:15:00 Filter, Group, and Sort List Data 00:15:00 Update and Share Your Profile 00:15:00 Share and Follow SharePoint Content 00:15:00 Create a Blog Post 00:30:00 Open and Save SharePoint Documents with Microsoft Office 00:15:00 Use Document Versions in Microsoft Office 00:30:00 Access SharePoint Using Outlook 2016 00:15:00 Synchronize OneDrive with SharePoint 00:15:00 Use SharePoint with a Mobile Device 00:15:00 Activities Activities - Microsoft SharePoint 2016 For Users 00:00:00 Module : 2 Create a Site 00:45:00 Design Your SharePoint Site 01:00:00 Configure a Document Library for a Team Site 01:30:00 Configure the Site Assets Library for a Site 00:45:00 Add a Wiki to your Site 00:45:00 Add an Announcement List 00:45:00 Add a Task List 00:30:00 Add a Blog 00:30:00 Add a Custom List 01:30:00 Configure Site Search Options 00:30:00 Configure Site Administration Settings 00:30:00 Configure Site Navigation Settings 00:45:00 Configure Site Permissions and Security Options 01:00:00 Activities Activities - Microsoft SharePoint 2016 For Site Owners 00:00:00 Module : 3 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 Managing Features and Apps 00:30:00 Add an RSS Feed to Your Site 00:30:00 Create a New Content Type 01:15:00 Add Columns to Content Types 00:45:00 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 Understanding Workflows 00:30:00 Create and Run a Workflow 01:00:00 Configure Search Options 01:00:00 Create Search Alerts 00:15:00 Activities Activities - Microsoft SharePoint 2016 For Administrators 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Project 2016 Advanced is one of our best selling and most popular course. This course is suitable for anyone aspiring to or already working in Microsoft Project and looks at skills needed to improve Microsoft Project. By taking this course you will gain the necessary skills to perform effectively in this field. The Microsoft Project 2016 Advanced is organised into 4 modules and includes everything you need to become successful in this profession. To make this course more accessible for you, we have designed it for both part-time and full-time students. You can study at your own pace or become an expert in just 18hours! If you require support, our experienced tutors are always available to help you throughout the comprehensive syllabus of this course and answer all your queries through email. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays 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 Mock exams Multiple-choice assessment Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Course Content Managing the Project Environment Link Projects 01:00:00 Create and Use Resource Pools 01:30:00 Baseline a Project 00:00:00 Work with Custom Fields 01:30:00 Change Project Options 01:30:00 Extend Project with Apps 00:30:00 Managing Task Structures Change a Task List 01:30:00 Create a Network Diagram 00:45:00 Manage the Critical Path 00:15:00 Use Lag and Lead 00:30:00 Update Project Work 00:45:00 Analyze Earned Value 01:00:00 Generating Project Views Use View Commands 01:00:00 Use Existing Views 00:15:00 Create Custom Views 01:30:00 Format and Share the Timeline View 00:45:00 Producing Project Reports Use Existing Reports 00:30:00 Create Custom Reports 01:30:00 Export Visual Reports 01:00:00 Activities Activities - Microsoft Project 2016 Advanced 00:00:00 Mock Exam Mock Exam- Microsoft Project 2016 Advanced 00:20:00 Final Exam Final Exam- Microsoft Project 2016 Advanced 00:20:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00: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:  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

Course Overview Take your Microsoft Office skills to a new level and gain full proficiency in Word, Excel, PowerPoint, Access and Outlook. This complete Diploma in Microsoft Office will teach you how to automate tasks with macros, create powerful work presentations, write professional business documents, and much more. Through step-by-step audiovisual training, you will familiarise with the advanced tools and features of each program, taking you from beginner to expert in no time. In just a few days, you will be able to perform advanced tasks such as creating queries in Access, and will be able to work faster and much more efficiently when taking on day-to-day office tasks. By the end of this Advanced Microsoft Office Training course, you will have the skills and confidence to utilise key Microsoft Office features and tools to customise your work and enhance your documents and slides to your liking. Not only that, but you will be able to add this qualification to your resume to instantly stand out to prospective employers! Develop full proficiency in Microsoft Office and stand out to prospective employers! What You Will Learn In this Microsoft Office Diploma, you will develop full proficiency in Word, Excel, PowerPoint, Outlook and Access, guaranteeing your career prospects in any office-based role. Performing Advanced Editing & Formatting Tasks in Word Formatting Pictures and Adding SmartArt in Word Working With Illustrations in Word Adding Tables & Inserting Special Objects in Word Working With Document References in Word How to Automate Tasks With Macros In Excel Managing, Grouping & Outlining Data In Excel Inserting Text, Audio & Visual in PowerPoint Tips for Preparing Your PowerPoint Presentation Creating Queries, Reports & Reforms in Access Managing Junk Mail & Performing Advanced Calendar Tasks Why You Should Choose This Course From iStudy Study at your own pace Full Tutor support on weekdays (Monday - Friday) Fully compatible with any device Free Printable PDF Certificate immediately after completion No prior qualifications are needed to take this course No hidden fees or exam charges CPD Qualification Standards and IAO accredited Efficient exam system, assessment, and instant results Our customer support team is always ready to help you Gain professional skills and better earning potential Certification After completing the course you'll receive a free printable CPD accredited PDF certificate. Hard Copy certificate is also available, and you can get one for just £9! Accreditation This course is accredited by Continuing Professional Development (CPD). It is a recognised independent accreditation service. Enrol today and learn something new with iStudy. You'll find a full breakdown of the course curriculum down below, take a look and see just how much this course offers. We're sure you'll be satisfied with this course.