678 Courses

Description: Microsoft Excel is a program that consists powerful tools which can help you organize and manipulate your data. Learning about the Excel program will help you in sharing workbooks to advanced functions and formulas. The Excel 2010 intermediate course is created to help you keep security setting in mind when sharing workbooks with Macros. In this course, you will learn the necessary skills, knowledge and information about how to use the Track Changes feature to make comments on another's work and learn to merge copies of the shared workbook to consolidate the comments. Who is the course for? Professionals who want to learn about Microsoft Excel 2010 features and functions. People who have an interest in knowing all the essentials in Microsoft Office Excel. 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 hardcopy 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 Microsoft Excel 2010 Intermediate Level course is a useful qualification to possess and would be beneficial for any for any Office job, such as: Admin Assistant PA Secretary Administrator Account Assistant Bookkeeper Accountant Office Manager. 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 Activities-Microsoft Excel 2010 Intermediate Level 00:00:00 Mock Exam Mock Exam- Microsoft Excel 2010 Intermediate level 00:20:00 Final Exam Final Exam- Microsoft Excel 2010 Intermediate level 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Microsoft Project 2010 is the latest version of Project, a companion project management application for Microsoft Office. This Microsoft Project 2010 Beginners - Complete Video Course teaches the basic commands and features of Microsoft Project 2010. Here, you will learn how to create and modify task lists, establish a project schedule, create calendars, assign resources to tasks, track costs, and work with different views and tables. You will also learn how to apply filters and groups, and sort task and resource data. This version includes a wide range of changes, including the new ribbon interface. Microsoft Project integrates with all the other Office application you regularly use. You will finish up the course with learning how to resolve resource conflicts. If you want to know more detail about Microsoft Project you have to be a part of this course. You will get all the basic knowledge from here, which will help you to pull up ahead. 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 Beginners - 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 Beginners - 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 Project Management Concepts FREE 00:12:00 The Project Window 00:15:00 Project Files 00:10:00 The Help Window 00:02:00 Tasks Creating a Task List 00:10:00 Modifying a Task List 00:07:00 The Work Breakdown Structure 00:13:00 Tasks Scheduling Task Links 00:16:00 Task Relationships 00:09:00 Task Options 00:05:00 Resource Management The Base Calendar 00:07:00 Resources and Calendars 00:14:00 Project Costs 00:08:00 Views and Tables Working with Views 00:12:00 Working with Tables 00:04:00 Filters, Groups, and Sorting Filters 00:10:00 Groups 00:05:00 Sorting Tasks and Resources 00:05:00 Finalizing the Task Plan Finalizing Schedules 00:09:00 Handling Resource Conflicts 00:11:00 Mock Exam Mock Exam- Microsoft Project 2010 Beginners - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Project 2010 Beginners - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Increase your productivity by mastering OneNote, a virtual junk drawer for your notes and files with our OneNote 2016: A Complete Guide course. Our best-selling course will explain how to use OneNote 2016 in the most effective way possible. Learn to create and manage notes and keep your information organized with easy-to-grasp modules. Discover how to navigate through the OneNote 2016 interface, and use Backstage View. You'll also learn useful techniques to create new notes and edit your notes. By the time you complete the course, you'll have the abilities to use OneNote and manage different types of information, including images, audio, and video recordings, screen clippings, OCR, data, etc. What Will I Learn? Understand and navigate OneNote Create new notebooks and add pages and sections Add various kinds of content to a Notebook Share a OneNote notebook with others Integrate OneNote with other applications Manage OneNote notebooks Requirements Basic computer skills. A general understanding of the Microsoft Office Suite of user-productivity products is helpful but not required. Module : 01 Introduction FREE 00:01:00 Understanding the OneNote Environment 00:04:00 Using the Review and View Tabs 00:03:00 Module : 02 Inserting Files 00:03:00 Module : 03 Using Tags 00:07:00 Working with Outlook Tasks 00:03:00 Course Certification

The Office 365 Collaborating in Office 365 course focuses on giving you the relevant knowledge on how to collaborate with others in Office 365. You'll learn how to make a plan in Planner, and an app in Office 365. In addition to that, learn how to create and share a document, as well as create a SharePoint library. Explore the idea to use the Office 365 apps on a mobile device, and how to co-author documents. The course also instructs you to manage an Outlook group, following with OneNote, Skype, and Delve to locate documents. Last but not the least, improve the efficiency to collaborate using Yammer and Teams. The knowledge acquired from the course makes sure you've got the skills required to succeed in today's rapidly developing workplace. What Will I Learn? Use the various apps of Office 365 to collaborate with others. Requirements Familiarity with Microsoft Office Applications and using the Internet. Introduction Introduction FREE 00:02:00 Using Office 365 for Collaboration Overview FREE 00:03:00 Creating a Plan 00:07:00 Creating and Sharing a Document 00:05:00 Creating a Library 00:08:00 Using Office 365 on a Mobile Device 00:05:00 Co-Authoring in Office 00:05:00 Using an Outlook Group to Get Feedback 00:08:00 Meeting and Collaborating in Skype and OneNote 00:08:00 Using Delve 00:05:00 Getting Feedback Through Yammer 00:07:00 Using Teams 00:06:00 Conclusion Course Recap 00:02:00 Course Certification

Learning Objectives Introduction , Using Microsoft 365 for Collaboration , Conclusion   Pre-Requisites Familiarity with Microsoft Office Applications and using the Internet.   Description This course is designed to give an overview of the Microsoft 365 suite and how to use it for collaboration. Work online, offline, and in collaboration with others. Students will create a plan, create and share a document, and learn to collaborate in Teams. Students will learn to co-author in Microsoft 365, use Yammer and Teams to get feedback and use Microsoft Lists to help create better delegation when working on projects. Collaborating in Microsoft 365 Beginner Course Introduction 00:01:00 Lesson 01: Overview 00:01:00 Lesson 02: Teams in Action 00:07:00 Lesson 03: Working with Meeting Recordings 00:04:00 Lesson 04:Creating a Plan 00:03:00 Lesson 05:Setting up Time 00:04:00 Lesson 06: Creating a Document 00:04:00 Lesson 07: Sharing a Document 00:02:00 Lesson 08: SharePoint in Action 00:05:00 Lesson 09: Difference between SharePoint and OneDrive 00:02:00 Lesson 10: Co-Authoring in Microsoft 365 00:04:00 Lesson 11: Best Practices of Co-Authoring in Microsoft 365 00:06:00 Lesson 12: Using Lists in Microsoft Teams 00:04:00 Lesson 13: Getting Feedback in Yammer 00:04:00 Lesson 14: Getting Feedback in Teams 00:07:00 Course Recap 00:01:00 Final Exam Final Exam - Collaborating in Microsoft 365 Beginner 00:10:00

This course would be perfect for individuals who prefer to learn more about Microsoft OneDrive, part of the Office 365 environment. You can store all sort of file on OneDrive, including photos, video, documents, and share files with others within the organisation and outside users. You can access the data from both Windows PCs and mobile devices. In this Office 365 Getting the Most out of OneDrive course, you'll learn about Microsoft OneDrive and get the most out of using OneDrive. Learn to access data, modify the view and sorting options, open and save files, organise folders and share files, view file details and many more. Besides, you'll also learn how to work with Version History, delete files, and sync files. What Will I Learn? Access OneDrive files Modify views and sorting Open and save files Create and rearrange folders Share files Work with version history Delete and sync files Requirements Familiarity with cloud-based storage concepts and using the Internet Familiarity with Microsoft Office applications Who is the target audience? Students who want to learn more about Microsoft OneDrive, part of the Office 365 environment. Introduction Introduction FREE 00:02:00 Getting Started with OneDrive Overview 00:02:00 Accessing Files 00:06:00 Changing the View and Sorting 00:06:00 Opening a File 00:05:00 Saving Files to OneDrive 00:06:00 Creating and Rearranging Folders 00:05:00 Sharing Files 00:07:00 Viewing File Details 00:05:00 Working with Version History 00:06:00 DeletingFiles 00:04:00 Restoring Your OneDrive 00:02:00 SyncingFiles 00:06:00 Copying Files to SharePoint 00:03:00 Conclusion Course Recap 00:03:00 Course Certification

Description: This particular course has multiple functions including working with templates, generating the baseline plans, monitoring and renovating projects, analysing the project statistics, coping with delays and conflicts, and overall, learning to customise projects. In fact, through executing the project server 2010, you will gain knowledge of communicating the project information as well as combining the project data with the other relevant office applications in general. Moreover, the learners who are basically the information workers and those who want to learn the elementary level of the Access 2010 skills properly match with the very design of the course. Apart from that,the Microsoft Office 2010 Access Intermediate- Complete Video Course is basically based on the skills and ideas learned from the Access 2010.This particular course helps you learn the items such as: the relational databases, related tables,complex queries, reports and printing, charts and pivot tables and also pivot charts. The fundamental topics that have been discussed in the particular course include: learning about querying with SQL, the advanced queries, Macros, the Advanced Macros and so on. 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 Access 2010 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 Access 2010 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 01: Beginner Getting Started Database Concepts FREE 00:04:00 Exploring the Access Environment 00:11:00 Getting Help 00:02:00 Databases and Tables Planning and Designing Databases 00:12:00 Exploring Tables 00:11:00 Creating Tables 00:33:00 Fields and Records Changing the Design of a Table 00:15:00 Finding and Editing Records 00:06:00 Organizing Records 00:16:00 Data Entry Rules Setting Field Properties 00:14:00 Working with Input Masks 00:07:00 Setting Validation Rules 00:06:00 Basic Queries Creating and Using Queries 00:13:00 Modifying Query Results and Queries 00:05:00 Performing Operations in Queries 00:17:00 Using Forms Creating Forms 00:11:00 Using Design View 00:14:00 Sorting and Filtering Records 00:04:00 Working with Reports Creating Reports 00:10:00 Modifying and Printing Reports 00:16:00 Module 02: Intermediate Relational Databases Database Normalization 00:14:00 Table Relationships 00:13:00 Referential Integrity 00:12:00 Related Tables Creating Lookup Fields 00:11:00 Modifying Lookup Fields 00:06:00 Using Subdatasheets 00:04:00 Complex Queries Joining Tables in Queries 00:26:00 Using Calculated Fields 00:09:00 Summarizing and Grouping Values 00:08:00 Advanced Form Design Adding Unbound Controls 00:08:00 Adding Graphics 00:04:00 Adding Calculated Values 00:06:00 Adding Combo Boxes 00:04:00 Advanced Form Types 00:10:00 Reports and Printing Customized Headers and Footers 00:17:00 Calculated Values 00:08:00 Calculated Values 00:08:00 Printing 00:03:00 Labels 00:05:00 Charts Charts in Forms 00:08:00 Charts in Reports 00:06:00 PivotTables and PivotCharts PivotTables 00:05:00 Modifying PivotTables 00:07:00 PivotCharts 00:04:00 PivotTable Forms 00:01:00 Module 03: Advanced Querying with SQL SQL and Access FREE 00:06:00 Writing SQL Statements 00:18:00 Attaching SQL Queries to Controls 00:06:00 Advanced Queries Creating Crosstab Queries 00:05:00 Creating Parameter Queries 00:11:00 Using Action Queries 00:17:00 Macros Creating, Running, and Modifying Macros 00:08:00 Attaching Macros to the Events of Database Objects 00:05:00 Advanced Macros Creating Macros to Provide User Interaction 00:20:00 Creating Macros that Require User Input 00:04:00 Creating AutoKeys and AutoExec Macros 00:07:00 Creating Macros for Data Transfer 00:07:00 Importing, Exporting, and Linking Importing Objects 00:14:00 Exporting Objects 00:06:00 Working with XML Documents 00:13:00 Linking Access Objects 00:13:00 Using Hyperlink Fields 00:06:00 Database Management Optimizing Resources 00:16:00 Protecting Databases 00:05:00 Setting Options and Properties 00:06:00 Mock Exam Mock Exam- Level 3 Diploma in Microsoft Access 2010 00:30:00 Final Exam Final Exam- Level 3 Diploma in Microsoft Access 2010 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Visio is a comprehensive tool for creating professional charts and diagrams. In this Visio 365 Online course, you'll explore the essential functions and features of Visio Online 2016. From creating your first shape to using templates to create diagrams, this course describes how to create multiple diagrams in the most productive style. You'll learn how to draw shapes and arrange objects, work with text, and formatting, create flowcharts, organisational charts, add shapes, design the layout, work with themes and pages. Additionally, you'll learn about navigation, templates, themes, sharing, printing and much more. Upon successful completion of the course, it will be easier for you to create diagrams that illustrate intricate data and information. What Will I Learn? Create and share Visio Online drawings, diagrams, and flow charts. Add, format, and manipulate shapes. Create a flowchart, and add and connect shapes. Share and review diagrams in OneDrive Requirements Basic computer skills, familiarity with Microsoft Office Applications. Who is the target audience? Anyone who wishes to learn more about Vision Online 2016 Introduction Introduction FREE 00:01:00 Understanding Visio Online What Is Visio 00:02:00 Comparing Visio Online vs 2016 00:04:00 Launching Visio Online 00:02:00 Getting Started with Visio Understanding the Visio Environment 00:04:00 Navigating and Zooming 00:03:00 Creating New Diagrams Accessing Visio Templates 00:03:00 Creating a Visio Diagram in OneDrive 00:02:00 Opening a Diagram in Visio 00:03:00 Working with Shapes Adding Shapes 00:04:00 Formatting Shapes 00:03:00 Manipulating Shapes 00:02:00 Changing Stacking Order 00:03:00 Selecting and Grouping Shapes 00:02:00 Searching for Shapes 00:02:00 Creating a Flow Chart Working with Basic Flowchart Template 00:03:00 Connecting Shapes 00:03:00 Adding Text to Shapes 00:02:00 Working with Visio Diagrams Inserting Pictures 00:02:00 Changing the Document Theme 00:02:00 Adding Pages to a Diagram 00:01:00 Sharing Visio Diagrams Sharing Diagrams in OneDrive 00:03:00 Reviewing Diagrams in OneDrive 00:02:00 Conclusion Course Recap 00:01:00 Course Certification

Course Overview Admin Assistants, Secretaries and PAs play a key role in the smooth running of a business. They are the glue that holds the structure of each working day together. To excel in these roles, you must have a specific set of transferable skills that are crucial for supporting managers, clients and other members of staff. If you are interested in any of these professions and think admin support is the career path for you, then this course is just what you need to get started.  In this Admin, Secretarial & PA Course, you will familiarise with key office procedures, with step-by-step training on how to put together an office procedure guide. It also explores codes of practice such as telephone and business writing etiquette, meeting management, and business communication techniques. Furthermore, you will build your proficiency in Excel, Word and PowerPoint, learning how to manage data, create professional work presentations and structure your business reports/proposals. Throughout the course, you'll learn tips and techniques that can be applied to a wide range of professions, from organising your time and prioritising your workload, to building your professional image and dealing with difficult people.  Enrol in this comprehensive course today and add this recognised qualification to your resume! What You Will Learn This Admin, Secretarial & PA Course teaches fundamental office procedures, suitable for aspiring Secretaries, PAs, Receptionists, Office Managers and Administrative Assistants. It also provides training on key Microsoft Office programs, building your proficiency in Word, Excel and PowerPoint. An Overview of the Office Procedure Guide Communication Skills & Techniques How to Organise Your Binder & Workspace Tips for Scheduling Your Time Efficiently How to Work Effectively With Your Manager Business Writing & Telephone Etiquette Microsoft Word, Excel & PowerPoint Training The Fundamentals of Meeting Management Must-Have Administrative Soft Skills Self-Empowerment Exercises & Strategies 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 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.

Course Overview Secretaries and Personal Assistants are integral to the smooth running of a business, making sure that office procedures are maintained effectively and everyday administrative duties are completed to a high standard. They are responsible for managing meetings, greeting clients, maintaining records, and other key office support duties.  In this Personal Assistant Training Course, you will develop all the essential skills needed to fast track your career in this field, equipping you with practical knowledge that will help boost your earning potential. It will guide you through a range of office procedures, from organising your binder and workspace to Microsoft Office training and putting together an office procedure guide. Not only that, but you will learn how to build a positive relationship with your manager and learn strategies for building your professional image. Stand out to prospective employers with this accredited Personal Assistant Training Course! What You Will Learn In this Executive Personal Assistant Course, you'll learn a range of administrative and transferable skills needed to provide quality office support. It provides essential information on key office procedures, as well as strategies for improving your efficiency in the workplace. Fundamental Office Administrative Procedures Putting Together The office Procedure Guide What You Should Include in Your Binder Verbal & Nonverbal Communication Skills Steps to Effective Meeting Management Microsoft Word, Excel & PowerPoint Training Effective Time Management Strategies Building a Strong Working Relationship With Your Manager Building Your Self-Esteem and Professional Image Influencing and Negotiating Techniques 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.