• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

661 Courses delivered Online

Microsoft Access Intermediate Level

4.3(43)

By John Academy

Description: Microsoft Access is a database management system (DBMS) from Microsoft. This software combines the relational Jet Database Engine with a graphical user interface and software-development tools. Microsoft Access is one of the Microsoft Office suites of applications. In this application, users can create tables, queries, forms and reports, and connect them together with macros. Through this course, you will learn the necessary skills, knowledge, and information about Microsoft Access 2013 needed for any users and for any professionals. Who is the course for? Professionals who want to learn about the Access. People who have an interest in the more functions and features of Access. 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 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 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 Access Intermediate Level course is a useful qualification to possess and would be beneficial for following careers: Software Engineer Technical Support Technical Sales Business Analyst Web Developer Software Tester. Microsoft Access Intermediate Level Module One - Getting Started 00:30:00 Module Two - Creating a Custom App 01:00:00 Module Three - Customizing App Actions 01:00:00 Module Four - Customizing Your App Views with Macros 01:00:00 Module Five - Working with Validation Rules and Messages 01:00:00 Module Six - Working with Macros 01:00:00 Module Seven - Advanced Query Tasks 01:00:00 Module Eight - Designing Forms 01:00:00 Module Nine - Advanced Reporting Tasks 01:00:00 Module Ten - Advanced Database Tools 01:00:00 Module Eleven - Working with the Access Environment 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities - Microsoft Access Intermediate Level 00:00:00 Mock Exam Mock Exam- Microsoft Access Intermediate Level 00:20:00 Final Exam Final Exam- Microsoft Access Intermediate Level 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Access Intermediate Level
Delivered Online On Demand11 hours 40 minutes
£21

Corel WordPerfect Complete Training Course

4.3(43)

By John Academy

Description: Corel WordPerfect 12 is a word processing application with a long history on multiple personal computer platforms. In the first section of the course, you will get basic knowledge on foundation training along with Workspace manager, customizing spelling and grammar. You will be able to create, edit, and save documents. Secondly, the intermediate level explains to you how to use the file dialogue box, toolbar, page set up, save and print files, etc. It will also teach you all the tools and techniques required to operate any work making it more valuable. Moving on to the advanced level, you will learn the stuff such as creating and modifying charts, making tables, working with rows and columns, sorting data, etc. Following that, you will learn about the basic introduction, applications and advantages of using email. Besides, you will get a clear idea of the anatomy, interface, shortcut keys, inbox, outbox, basic email etiquette, and so much more. Finally, application training section teaches you about email applications, opening and closing the WordPerfect email application. Corel WordPerfect Complete Training Course is created to help you stand out among other co-workers and to perform better at work. Learning Outcomes: Opening and closing the program; understanding the interface; using menus, quickmenus, toolbars and dialog boxes How to use the programs toolbar and property bar, showing or hiding toolbars, customizing and managing it Typing text basics, selecting text with mouse, keyboard and menu, general tips and tricks Working with text via cutting, copying, pasting, using drag and drop, understanding insert and typeover mode, and using undo and redo How to save files for the first and second times, opening and closing files and/or document Utilizing the help menu, help topics, Corel tutor, specialized help, contextual help amd 'What's This' option Navigation through your cursor, scroll bars, keyboard, and the toolbar Using the object browser, go to dialog box, find the dialog box, and find and replace words Managing fonts through font face, size, bold, underline, italics, colour, quickfonts button, highlighting, and text's case through the property bar More font options through the dialog box, and advanced font tasks like embedding fonts and more Managing text position using the alignment, justification, line and paragraph spacing, ruler, tabs, margins and more options Spelling and grammar checking, using prompt-as-you-go, Grammatik, thesaurus, and the dictionary Opening, using, creating a template and organising projects Using PerfectExpert, and creaing envelopes and labels from the menu option Inserting data, time, symbols, using QuickWords, QuickCorrect, and smart quotes Ways to insert, suppress, remove page numbers, force pages and further insert line numbers Inserting clipart and pictures, reshaping and resizing graphics, positioning through the QuickMenu, ordering and flipping pictures, and adding borders How to use page view, draft view, two page view and zoom Using the print preview option to make adjustments and printing through various settings and options Switching between various documents, arranging document windows, moving text between documents, saving text in a separate file, and inserting documents Emailing and faxing your documents, and publishing them as PDF Affects of HTML on your document, previewing file in your browser, and publishing to HTML Making WordPerfect look like MS Office, opening office documents, saving office files, and using outlook contacts in WordPerfect Utilizing the WordPerfect file dialog box and toolbar options Saving your files using file extensions, viewing file properties, backing up your documents, and saving different versions Using page setup through margins, layout options, page size and orientation Explore the various printing options in order to get printouts Creating, expanding and saving Master documents; also creating, editing and removing subdocuments Understanding reveal codes window and un-revealing codes Examining code - like modifying, deleting, hard vs. soft; working with specific codes - character, sentence and paragraphs, etc.; and finding and replacing codes Applying built-in style using the property bar, updating existing styles, and creating your own style using QuickStyles and dialog boxes Creating and using document styles; and managing styles through the adding, saving and settings options Inserting and creating different list styles, and managing these list styles Utilizing QuickFormat and other formatting tools like the Make-It-Fit command and more Creating headers and footers, using the property bar, placing, suppressing, and deleting headers and footers Formatting text into columns, commenting on documents and reviewing them as well How to create watermark or text boxes Moving, resizing, adding borders and fill, adding captions, and wrapping text in text boxes Understand the basics of custom graphics and how to edit them to meet your needs Creating hyperlink and speed link within your documents Working with bookmarks and quickmarks Create table of contents, setting it up, generating and re-generating it, and using the document map Discover how to use WordPerfect, Microsoft Word, WordPerfect Classic, and Legal mode Customize toolbars, property bars, menus, keyboards, display settings and application bar options Modify WordPerfect environment, file settings, setting summary and conversion options Keep your spelling and grammar on check, change language preferences, add words to dictionary, and customize word list Understand the table structure and use tables property bar, QuickCreate, table menu and perfect expert to manage tables Insert, delete, resize, join and split cells or columns and rows Format tables through cells rotation option, setting vertical alignment, adding borders and fill, using speedformat, and creating or deleting speedformat styles Carry out advanced table tasks by using QuickSum, creating formulas, changing numeric formula of a cell, converting table to tabbed text and vice versa Understand the structure of charts, insert charts, how interface differs when working with them, move, resize, and delete them Changing chart type, chart colours and fonts, legend box, and your perspective Sort out data using sort dialog, setting sort options, creating custom sort, and outputting sort results to a disk Importing and linking spreadsheets or databases, and inserting objects and other file types Merging mail, creating data file, entering your data, using meal merge toolbar in data file Finding records; navigating between records and fields; modifying field names; adding, deleting and editing records Create form documents, add merge fields and merge codes, performing the merge, and creating envelopes during the merge Get an overview of the XML interface, creating new documents, publishing to XML, and converting existing documents to XML Using macro toolbars and visual basic editor along with recording, playing, editing and deleting macros Downloading the OfficeReady browser, using it and templates from the browser How to searchfor files in WordPerfect, starting the WordPerfect when Windows starts, and the differences between Windows Clipboard vs. Corel Clipbook Email address structure, the benefits of email, email etiquette, understand spam and viruses, and digital signatures Common email applications, opening and closing the WordPerfect email application, understanding its structure and getting help Using the folder list, main menus, toolbar, shortcut menus, shortcut keys and dialogue boxes Opening your inbox and messages, switching between open messages, closing email messages, and adding and removing message list headings Using the contact list, searching for messages, creating folders, and moving messages to a folder Sorting and deleting messages, restoring and emptying deleted items Flagging messages, marking messages as read or unread, opening and saving attachments, using reply & reply to all, and forwarding messages options How to print your messages using the print preview, print commands, choosing a print range, and setting the number of copies Creating and addressing messages; adding a subject; composing message; using the cut, copy and paste options and sending the message Adding and removing attachments, changing priority, and copying text into a message Explore the differences between HTML and Plain text emails, set up default text fonts, add images, and spell checks Adding people to your contact list, how to create a distribution list, and adding and removing addresses from the distribution list Understanding the structure of email addresses, advantages of email, email etiquette, spams and viruses, and digital signatures Common email applications, opening and closing the WordPerfect email application, understanding its structure and getting help Utilizing the folder list, main menus, toolbar, shortcut menus, shortcut keys and dialogue boxes Opening your inbox and messages, switching between open messages, closing email messages, and adding and removing message list headings Best ways to use the contact list, search for messages, create folders, and moving messages to a folder Sorting and deleting messages, restoring and emptying deleted items Discover more about message tools through flagging, marking messages as read or unread, opening and saving attachments, using reply and forwarding messages options How to print your messages using the print preview, print commands, choosing a print range, and setting the number of copies Creating and addressing messages; adding a subject; composing message; using the cut, copy and paste options and sending the message Advanced message tools like adding and removing attachments, changing priority, copying text into a message Compare HTML vs. Plain text emails, set up default text fonts, add images, and check spellings Adding people to your contact list, how to create a distribution list, and changing the addresses from the distribution list 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? Corel WordPerfect Complete Training 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 Corel WordPerfect Complete Training 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. Module - 1 OPENING COREL WORDPERFECT 12 00:30:00 MORE ABOUT TOOLBARS 00:30:00 CREATING AND SELECTING TEXT 00:30:00 WORKING WITH TEXT 00:30:00 WORKING WITH YOUR DOCUMENT 00:30:00 FINDING HELP 00:30:00 BASIC NAVIGATION 00:15:00 USING WORDPERFECT'S TOOLS TO NAVIGATE THROUGH YOUR DOCUMENT 00:30:00 USING FONTS ON THE PROPERTY BAR 00:30:00 USING THE FONTS DIALOG BOX 00:30:00 ADVANCED FONT TASKS 01:00:00 CHANGING TEXT'S POSITION 00:30:00 ADVANCED TEXT POSITIONING 00:30:00 LANGUAGE TOOLS 00:30:00 PROJECTS 01:00:00 OTHER PRE-FORMATTED DOCUMENTS 00:30:00 USING TIMESAVING TOOLS 01:00:00 USING PAGE NUMBERS 00:30:00 ADDING PICTURES 01:00:00 VIEWING YOUR DOCUMENT 00:30:00 USING PRINT PREVIEW 00:30:00 PRINTING YOUR DOCUMENT 00:30:00 WORKING WITH MULTIPLE DOCUMENTS 00:30:00 SENDING YOUR DOCUMENT ELSEWHERE 00:30:00 CREATING A WEB PAGE 00:15:00 WORDPERFECT AND MICROSOFT OFFICE 00:30:00 Module - 2 USING THE FILE DIALOG BOX 01:00:00 USING TOOLBARS 00:15:00 SAVING YOUR FILES 00:30:00 USING PAGE SETUP 00:30:00 PRINTING YOUR FILES 00:30:00 USING MASTER DOCUMENTS AND SUBDOCUMENTS 01:00:00 REVEALING CODES 00:30:00 EXAMINING CODE 00:30:00 SPECIFIC CODES 00:30:00 FINDING AND REPLACING CODES 00:30:00 APPLYING A BUILT-IN STYLE 00:30:00 CREATING A STYLE 00:30:00 USING DOCUMENT STYLES 00:30:00 MANAGING LIST STYLES 00:30:00 USING LIST STYLES 01:00:00 MANAGING LIST STYLES 00:30:00 USING QUICKFORMAT 01:00:00 OTHER FORMATTING TOOLS 01:00:00 CREATING HEADERS AND FOOTERS 00:30:00 FORMATTING TEXT INTO COLUMNS 01:00:00 COMMENTING ON A DOCUMENT 01:00:00 REVIEWING A DOCUMENT 01:00:00 CREATING A WATERMARK 00:30:00 CREATING TEXT BOXES 00:30:00 JAZZING UP TEXT BOXES 01:00:00 THE BASICS OF CUSTOM GRAPHICS 00:30:00 EDITING CUSTOM GRAPHICS 01:00:00 CREATING LINKS TO OUTSIDE YOUR DOCUMENT 00:30:00 WORKING WITH BOOKMARKS 00:30:00 WORKING WITH QUICKMARKS 00:30:00 CREATING A TABLE OF CONTENTS 01:00:00 Module - 3 Using the Workspace Manager 00:30:00 Customizing How You Interact With Word 00:15:00 Customizing How WordPerfect Interacts With Data 00:30:00 Customizing Spelling and Grammar 00:30:00 Creating a Basic Table 01:00:00 Working With Rows and Columns 00:30:00 Formatting a Table 00:30:00 Advanced Table Tasks 01:00:00 Creating Charts 00:30:00 Modifying Charts 00:30:00 Sorting Data 01:00:00 Using Data From Other Applications 00:30:00 Mail Merge Basics 00:30:00 Modifying Your Data 00:30:00 Finalizing the Merge 00:30:00 Creating an XML Document 01:00:00 Macros 01:00:00 Using the OfficeReady Browser 00:30:00 WordPerfect and Windows 01:00:00 Module - 4 All About E-mail 00:30:00 Getting Started 01:00:00 Components of the Mail Interface 00:30:00 Working with Messages 01:00:00 Managing Mail 01:00:00 Working With Messages 00:30:00 Message Tools 01:00:00 Printing Messages 00:30:00 Creating Messages 01:00:00 Advanced Message Tools 01:00:00 Working With E-mail 01:00:00 Address Tools 01:00:00 Module - 5 All About E-mail 00:15:00 Getting Started 00:30:00 Components of the Mail Interface 00:30:00 Working with Messages 00:30:00 Managing Mail 01:00:00 Working With Messages 00:30:00 Message Tools 00:30:00 Printing Messages 00:30:00 Creating Messages 00:30:00 Advanced Message Tools 00:30:00 Working With E-mail 00:30:00 Address Tools 00:30:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Corel WordPerfect Complete Training Course
Delivered Online On Demand48 hours
£22

Microsoft Word 2007 Advanced Level

4.3(43)

By John Academy

Description: Regardless of whether you are a business writer, an advertiser, or somebody who utilizes the software for general report creation and handling, the skills incorporated into this course will enable you to maximize your use of many powerful Word features to create compelling, visually attractive, and useful documents. This online course will allow you to learn advanced Word techniques, covering all that you need to help you get started. It shows you how to open reports and control the words on the page, so they look as you mean, whatever your purpose.In this course you will learn the necessary skills, knowledge and information of Microsoft Word 2007.  Who is this course for? New users, beginners, and intermediates users can benefit from this course. This course would be ideal for individuals who wish to develop their skills of using Microsoft Office Excel 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:  Microsoft Word 2007 Advanced Level will be very beneficial and helpful, especially to the following professionals: Administrative Assistant. PA. Secretary. Administrator. Office Manager. Microsoft Word 2007 Advanced Level Module One - Getting Started 00:30:00 Module Two - Working with the Word Window 01:00:00 Module Three - Adding Pictures 01:00:00 Module Four - Adding Smart Art 01:00:00 Module Five - Adding Tables 01:00:00 Module Six - Advanced Table Tasks 01:00:00 Module Seven - Inserting Special Objects 01:00:00 Module Eight - Adding In-Document References 01:00:00 Module Nine - Advanced Research Tasks 01:00:00 Module Ten - Reviewing a Document 01:00:00 Module Eleven - Customizing Word 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities-Microsoft Word 2007 Advanced Level 00:00:00 Mock Exam Mock Exam- Microsoft Word 2007 Advanced Level 00:20:00 Final Exam Final Exam- Microsoft Word 2007 Advanced Level 00:20:00

Microsoft Word 2007 Advanced Level
Delivered Online On Demand11 hours 40 minutes
£21

Microsoft One Note 2007 Advanced

4.3(43)

By John Academy

Description: Microsoft OneNote 2007 is a powerful tool that helps you to organize your projects and ideas. Explore all that you need at an advanced level to become a proficient Microsoft one note 2007 user. This course will help you learn more advanced skills for working with your Notebooks. It demonstrates the new and enhanced features in Microsoft OneNote 2007 for gathering and sharing information. Once you complete the course, your familiarity and confidence in using the advanced feature of OneNote 2007 will increase, making OneNote 2007 a more useful tool for you at work or home. In this course you 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. This course is designed for anyone who wants to learn Microsoft one note 2007 at an advanced level. 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 Advanced 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 Advanced Module One - Getting Started 00:30:00 Module Two - Upgrading from One Note 2003 01:00:00 Module Three - Staying Organized 01:00:00 Module Four - Note Taking Tools 01:00:00 Module Five - Text and Page Formatting 01:00:00 Module Six - Office Integration 01:00:00 Module Seven - Researching a Topic 01:00:00 Module Eight - Handwriting Notes 01:00:00 Module Nine - On the Road 01:00:00 Module Ten - Live Sharing 01:00:00 Module Eleven - Other Tools 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities - Microsoft One Note 2007 Advanced 00:00:00 Mock Exam Mock Exam- Microsoft One Note 2007 Advanced 00:20:00 Final Exam Final Exam- Microsoft One Note 2007 Advanced 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft One Note 2007 Advanced
Delivered Online On Demand11 hours 40 minutes
£21

Microsoft Excel 2010 for Beginners

4.3(43)

By John Academy

Description: Microsoft Excel is one of the most popular spreadsheet programs in the world and is used throughout every single type of business out there. This program is designed to help people analyze large amounts of data through tabulation, charts, graphs and more. If you want to start learning about this program, then this Microsoft Excel 2010 for Beginners is for you. This is a basic course designed to help you get familiarized with the workings of Microsoft Excel. You will first start with simple tasks like opening and closing excel and work in worksheets. You will then start reviewing excel data and printing them as well. This course will help you further by teaching you to build formulas, functions and utilize time-saving tools. Finally, you will also look into formatting from both a beginner and advanced perspective. This is a great course for anyone that wants to learn about MS Excel and would prove invaluable if you want to use it for problem-solving through data analysis. So what are you waiting for, get this course now to make your life easier? Who is the course for? Professionals who want to learn how to use Microsoft Office Excel. People who have a need to analyze and organise large amounts of data. 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: Microsoft Excel 2010 for Beginners is a useful qualification to possess and would be beneficial for any professions or career from any industry you are in such as: Accounting Management consultant Investment Banking Analyst Marketing Engineering Academics Microsoft Excel 2010 for Beginners Module One - Getting Started 00:30: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 00:30:00 Module Ten - Formatting Your Data 01:00:00 Module Eleven - Advanced Formatting Tools 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities-Microsoft Excel 2010 for Beginners 00:00:00 Mock Exam Mock Exam- Microsoft Excel 2010 for Beginners 00:20:00 Final Exam Final Exam- Microsoft Excel 2010 for Beginners 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Excel 2010 for Beginners
Delivered Online On Demand11 hours 10 minutes
£21

Microsoft PowerPoint 2016 Advanced

4.3(43)

By John Academy

Description: Microsoft Office PowerPoint 2016 is the latest version of Microsoft's ubiquitous presentation software. This Microsoft PowerPoint 2016 Advanced is designed for them who have basic skills with Microsoft PowerPoint 2016 and want to learn advanced-level skills or want to learn the topics covered in this course in the 2016 interface. You will learn to modify the PowerPoint environment, customizing design templates, working with media and animation, and much more. So if you want to develop your skills and knowledge in this program, you should join this course now. Learning Outcomes: PowerPoint environment and how to modify it according to needs Customizing user interface and setting up options Create and manage sections, modify slide masters and slide layouts, add headers and footers, modify notes master and handout master Creating and modifying SmartArt Adding audio video to presentations and customizing animations and transitions to enhance presentation Better collaboration by adding comments, reviews, storing and sharing presentations on the web Setting up and creating custom slide shows, adding hyperlink and action buttons, and recording a presentation Security and distribution of presentations through various outlets 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 PowerPoint 2016 Advanced 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 PowerPoint 2016 Advanced is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path 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 01:30:00 Set PowerPoint 2016 Options 00:45:00 Customizing Design Templates Create and Manage Sections 01:00:00 Modify Slide Masters and Slide Layouts 01:15:00 Add Headers and Footers 00:30:00 Modify the Notes Master and the Handout Master 00:45:00 Adding SmartArt to a Presentation Create SmartArt 00:45:00 Modify SmartArt 01:00:00 Working with Media and Animations Add Audio to a Presentation 00:45:00 Add Video to a Presentation 01:00:00 Customize Animations and Transitions 01:00:00 Collaborating on a Presentation Add Comments to a Presentation 00:45:00 Review a Presentation 00:45:00 Store and Share Presentations on the Web 01:30:00 Customizing a Slide Show Annotate a Presentation 00:45:00 Set Up a Slide Show 00:45:00 Create a Custom Slide Show 00:30:00 Add Hyperlinks and Action Buttons 00:45:00 Record a Presentation 00:15:00 Securing and Distributing a Presentation Secure a Presentation 01:30:00 Present a Slide Show Online 01:00:00 Create a Video or a CD 00:45:00 Activities Activities - Microsoft PowerPoint 2016 Advanced 00:00:00 Mock Exam Mock Exam- Microsoft PowerPoint 2016 Advanced 00:20:00 Final Exam Final Exam- Microsoft PowerPoint 2016 Advanced 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft PowerPoint 2016 Advanced
Delivered Online On Demand20 hours 10 minutes
£21

MS SharePoint 2016 Site User

4.3(43)

By John Academy

Description Be an expert in MS SharePoint knowing the key issues of this app from the MS SharePoint 2016 Site User course. The course can solve your different problems in MS SharePoint and make you an efficient in this field.   The MS SharePoint 2016 Site User course incorporates some effective methods of SharePoint interface and functions to teach the students easily. The course assists the students to know how to identify sites, run libraries and lists, and work with library documents. The course enables them to know about library setting incorporating the ideas of alert, check in and out of documents, and creation of calendar list, contact lists, and task list along with the relevant work of list setting. The purpose of the course is to enhance the SharePoint expertise knowing the fact of different views, use of newsfeed, and other MS office products. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. 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? MS SharePoint 2016 Site User 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 MS SharePoint 2016 Site User 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. Introduction Introduction FREE 00:01:00 SharePoint Overview SharePoint Overview 00:04:00 Accessing SharePoint Sites 00:02:00 Sharepoint Interface and Navigation 00:08:00 Using the Open Menu 00:02:00 Using the Details Pane 00:01:00 Overview of SharePoint Permissions for Site Users 00:05:00 Locating Sites, Libraries, and Lists 00:04:00 Searching for SharePoint Content 00:04:00 Working with Document Libraries SharePoint Library Overview 00:04:00 Viewing and Downloading a Document from a Library 00:03:00 Uploading Items to a Document Library 00:03:00 Syncing a Library 00:03:00 Creating and Saving New Documents 00:04:00 Editing a Document 00:03:00 Creating a New Folder 00:03:00 Uploading and Moving Document into a Folder 00:01:00 Moving Document to Another Library 00:01:00 Pin to Top 00:02:00 Renaming Documents or Folders 00:02:00 Deleting Documents or Folders 00:02:00 Restoring a Document from the Recycle 00:02:00 Working with Document Library Settings Viewing Permissions for a Document 00:03:00 Version History Overview 00:03:00 Viewing, Comparing, and Restoring Prior Document Versions 00:04:00 Check In or Check Out Overview 00:03:00 Checking Out or Checking In a Document 00:03:00 Editing a Document with Check In or Check Out Enabled 00:03:00 Uploading a File to a Library with Check In or Check Out Enabled 00:02:00 Discarding a Check Out 00:02:00 Setting an Alert on a Document 00:03:00 Setting an Alert on a Library 00:03:00 Modifying or Deleting Alert Subscriptions 00:03:00 Changing View Column Settings 00:03:00 Sorting and Filtering Library Content 00:03:00 Sharing Links Including Durable Links 00:04:00 Working with Properties 00:02:00 Adding and Editing Properties 00:03:00 Adding and Editing Properties while Editing in Office 00:02:00 Narrowing a Document Search Result by Properties 00:02:00 Working with SharePoint Lists SharePoint List Overview 00:03:00 Adding an Item to a List 00:02:00 Adding an Item to a Contact List 00:01:00 Adding an Item to a Calendar 00:02:00 Creating a Recurring Calendar Event 00:02:00 Adding an Item to a Task List 00:03:00 Adding an Item to a Links List 00:02:00 Adding an Announcement 00:03:00 Attaching Content to an Announcement 00:04:00 Editing or Deleting a List Item 00:02:00 Editing or Deleting a Contact 00:02:00 Editing or Deleting a Calendar Event 00:04:00 Editing or Deleting a Task 00:03:00 Editing or Deleting an Announcement 00:02:00 Editing or Deleting a Link 00:01:00 Working with List Settings Adding and Editing Items Using Quick Edit 00:04:00 Sorting and Filtering List Items 00:03:00 Copying and Pasting Excel Info into a List 00:03:00 Exporting List Data into Excel 00:03:00 Creating an Alert for a List Item 00:03:00 Creating an Alert for a List 00:04:00 Enhancing the SharePoint Experience Working with Library or List Views 00:05:00 Creating Public or Personal Standard Views 00:10:00 Using Task Views 00:04:00 Creating a Views 00:04:00 Modifying or Deleting a View 00:04:00 Creating a Grouped View 00:06:00 Creating a Datasheet View 00:03:00 Creating a View to Display Items without Folders 00:03:00 Creating a View to Display Items Checked Out to Me 00:04:00 Sharing Documents and Sites 00:03:00 Coauthoring 00:02:00 Integration with Microsoft Office Integration with Office Online 00:03:00 Checking In or Checking Out Documents via Microsoft Office 00:02:00 Accessing and Uploading Properties from Microsoft Office 00:02:00 Accessing Prior Versions from Microsoft Office 00:02:00 Saving a Document to SharePoint from Microsoft Office 00:03:00 Syncing a Calendar to Outlook 00:02:00 Syncing a Library To Outlook 00:02:00 Integration with Office 365 00:04:00 Personal Profile and Newsfeed Updating Your Profile 00:04:00 Following Sites 00:03:00 OneDrive Overview 00:03:00 Uploading Documents to OneDrive 00:02:00 Sharing Content in OneDrive 00:04:00 Newsfeed Overview 00:06:00 Creating a Blog 00:04:00 Editing and Replying to Blogs 00:03:00 Conclusion Course Recap 00:01:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

MS SharePoint 2016 Site User
Delivered Online On Demand4 hours 29 minutes
£18

Microsoft PowerPoint 2016 for Beginners

4.3(43)

By John Academy

Description: PowerPoint is Microsoft's powerful and easy to use presentation program. By this Microsoft PowerPoint 2016 for Beginners you will learn how to create PowerPoint presentations in the newest version of Microsoft Office. This version of PowerPoint incorporates some new features and connectivity options in an effort to make collaboration and production as easy as possible. This Microsoft PowerPoint 2016 for Beginners is designed to help all novice computer users get up to speed with PowerPoint Quickly. You will learn to navigate the PowerPoint environment, create and save PowerPoint presentation, and much more. If, you are interested to take this course, don't delay to join us now. Learning Outcomes: Utilize the PowerPoint user interface, creating and saving presentations, and using help Making presentations through presentation options like selecting types, building it, layouts, text editing, viewing and navigation Discover methods for formatting characters, paragraphs, and text boxes Adding images, screenshots, screen recordings, shapes and WordArt Modifying options for objects and animation features Creating and formatting a table and integrating data from other Microsoft Office applications Create format and manipulate a chart 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 PowerPoint 2016 for Beginners is certified by CPD Qualifications Standards and IAO. 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 PowerPoint 2016 for Beginners 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 PowerPoint Navigate the PowerPoint Environment 00:30:00 ACTIVITY - NAVIGATING THE POWERPOINT 2016 USER INTERFACE 00:05:00 Create and Save a PowerPoint Presentation 00:15:00 ACTIVITY - CREATING AND SAVING A POWERPOINT PRESENTATION 00:05:00 Use Help 00:15:00 ACTIVITY - USING POWERPOINT HELP 00:05:00 Developing a PowerPoint Presentation Select a Presentation Type 00:15:00 ACTIVITY - SELECTING A PRESENTATION TYPE 00:05:00 Build a Presentation 00:15:00 ACTIVITY - BUILDING A PRESENTATION 00:05:00 Lay Out a Presentation 00:15:00 ACTIVITY - LAYING OUT A PRESENTATION 00:05:00 Edit Text 00:15:00 ACTIVITY - EDITING TEXT 00:05:00 View and Navigate a Presentation 00:15:00 ACTIVITY - VIEWING A PRESENTATION 00:05:00 Performing Advanced Text Editing Format Characters 00:15:00 ACTIVITY - FORMATTING CHARACTERS 00:05:00 Format Paragraphs 00:30:00 ACTIVITY - FORMATTING PARAGRAPHS 00:05:00 Format Text Boxes 00:15:00 ACTIVITY - FORMATTING TEXT BOXES 00:05:00 Adding Graphical Elements to Your Presentation Insert Images 00:30:00 ACTIVITY - INSERTING IMAGES 00:05:00 Insert Shapes 00:15:00 ACTIVITY - INSERTING SHAPES 00:05:00 Insert WordArt 00:15:00 ACTIVITY - INSERT WORDART 00:05:00 Modifying Objects in Your Presentation Edit Objects 00:30:00 ACTIVITY - EDITING OBJECTS 00:05:00 Format Objects 00:15:00 ACTIVITY - FORMATTING OBJECTS 00:05:00 Group Objects 00:15:00 ACTIVITY - GROUPING OBJECTS 00:05:00 Arrange Objects 00:15:00 ACTIVITY - ARRANGING OBJECTS 00:05:00 Animate Objects 00:15:00 ACTIVITY - ANIMATING OBJECTS 00:05:00 Adding Tables to Your Presentation Create a Table 00:15:00 ACTIVITY - CREATING A TABLE 00:05:00 Format a Table 00:15:00 ACTIVITY - FORMATTING A TABLE 00:05:00 Insert a Table from Other Microsoft Office Applications 00:15:00 ACTIVITY - INSERTING A TABLE FROM MICROSOFT EXCEL 00:05:00 Adding Charts to Your Presentation Create a Chart 00:15:00 ACTIVITY - CREATING A CHART 00:05:00 Format a Chart 00:15:00 ACTIVITY - FORMATTING A CHART 00:05:00 Manipulate a Chart 00:15:00 ACTIVITY - MANIPULATING A CHART 00:05:00 Insert a Chart from Microsoft Excel 00:15:00 ACTIVITY - INSERTING A CHART FROM MICROSOFT EXCEL 00:05:00 Preparing to Deliver Your Presentation Review Your Presentation 00:30:00 ACTIVITY - REVIEWING YOUR PRESENTATION 00:05:00 Apply Transitions 00:15:00 ACTIVITY - APPLYING TRANSITIONS 00:05:00 Print Your Presentation 00:15:00 ACTIVITY - PRINTING YOUR PRESENTATION 00:05:00 Deliver Your Presentation 01:00:00 ACTIVITY - DELIVERING YOUR PRESENTATION 00:05:00 Activities Activities - Microsoft PowerPoint 2016 for Beginners 00:00:00 Mock Exam Mock Exam- Microsoft PowerPoint 2016 for Beginners 00:20:00 Final Exam Final Exam- Microsoft PowerPoint 2016 for Beginners 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft PowerPoint 2016 for Beginners
Delivered Online On Demand12 hours 40 minutes
£18

Executive Secretary & PA Training

By Training Tale

For confident candidates with outgoing personalities and a relentless attention to detail, the field of Secretary & PA Diploma services is wide open. Professional personal assistants (PAs) are the ultimate multitaskers, hired to manage the personal affairs and activities of those they support. Some secretaries and PAs work for large corporations, while others are hired by a single executive, entrepreneur, or influential figure. Regardless of which path you take, becoming a trusted and respected PA or Secretary opens the door to a world of incredible career opportunities. Personal qualities and character, as well as hard skills, are important for success as a PA or secretary. It's simply a matter of learning the roles of PAs and secretaries in order to prepare for a rewarding career in the field. This Executive Secretary & PA Training could be the key to your dream job. Transform your ambition and enthusiasm into a rewarding career for life by studying from home at your own pace and time. Learn how to handle a wide range of essential office administration tasks, as well as how to write important business letters and handle complex mail and shipping requirements. Making travel arrangements on behalf of others, organising meetings and events, the importance of time management as a PA, and how to become a better communicator are also covered in the course. Our Executive Secretary & PA Training course has been designed to equip you with the essential knowledge and skills needed to become an expert executive secretary or personal assistant and will give you all the practical knowledge & credentials that you need to excel in your new role. Enrol on our Executive Secretary & PA Training course today and begin your journey to improve your career prospects with the latest skills and the power of self-belief! Learning Outcomes After completing this Executive Secretary & PA Training course, learner will be able to: Understand personal assistant fundamentals Understand business telephone approaches Understand information regarding shipping and mail services Understand travel arrangements Understand outline setting up conferences and meetings Understand management of time Understand systems for record keeping and filing Understand business writing techniques Understand communication skills Understand customer service Understand basics of microsoft office skills Why Choose Executive Secretary & PA Training Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Executive Secretary & PA Training Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the course. ***Courses are included in this Executive Secretary & PA Training Bundle Course Course 01: Executive Secretary & PA Training Course 02: Minute Taking Course 03: Self Esteem & Assertiveness Skill Course Course 04: Networking Skills Training Course 05: Communication Skills Course Course 06: Level 4 Time Management Course Course 07: Workplace Stress Management Others benefits of this Executive Secretary & PA Training bundle course 7 Free PDF Certificate Lifetime Access Free Retake Exam Tutor Support [ Note: Free PDF certificate as soon as completing the Executive Secretary & PA Training course ] Course Curriculum Of Executive Secretary & PA Training Module 01: Personal Assistant Fundamentals Module 02: Business Telephone Approaches Module 03: Information regarding shipping and mail services Module 04: An Overview of Travel Arrangements Module 05: Outline setting up conferences and meetings Module 06: Management of time Module 07: Systems for Record Keeping and Filing Module 08: Business Writing Techniques Module 09: Communication Skills Module 10: Customer Service Module 11: Basics of Microsoft Office Skills >>-------------<< Assessment Method After completing each module of the Executive Secretary & PA Training Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification After completing the MCQ/Assignment assessment for this Executive Secretary & PA Training course, you will be entitled to a Certificate of Completion from Training Tale. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? This Executive Secretary & PA Training course is designed for existing secretarial/administrative workers seeking advancement or newcomers seeking their first professional position. Requirements There are no specific requirements for this Executive Secretary & PA Training course because it does not require any advanced knowledge or skills. Career path After completing this Executive Secretary & PA Training course, you may able to pursue a formal position in professional Executive PA services such as: Personal Executive Assistant Receptionist Office Assistant Support Secretary Office Manager Personal Concierge Executive Assistant

Executive Secretary & PA Training
Delivered Online On Demand40 hours
£21

Microsoft Excel 2007 Advanced Level

4.3(43)

By John Academy

Description: Knowing how to utilise the advanced features of Microsoft Excel 2007 opens an entirely new experience in utilising this spreadsheet program. This course is designed to provide you with everything you need to know about Microsoft Excel 2007. From the essentials to the most advanced tools, by the end of this course, you will have the skills to utilise Microsoft Excel 2007 at an expert level. Once you complete the course, your familiarity and confidence in using the advanced feature of Excel 2007 will increase, making Excel 2007 a more useful tool for you at work or home. Who is the course for? New users, beginners, intermediates and advanced Excel users can benefit from this course. This course would be ideal for individuals who wish to develop their skills of using Microsoft Office Excel 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 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 2007 Advanced Level will be very beneficial and helpful, especially to the following professionals: Administrative Assistant. PA. Secretary. Administrator. Office Manager. 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 Activities-Microsoft Excel 2007 Advanced Level 00:00:00 Mock Exam Mock Exam- Microsoft Excel 2007 Advanced Level 00:20:00 Final Exam Final Exam- Microsoft Excel 2007 Advanced Level 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft Excel 2007 Advanced Level
Delivered Online On Demand11 hours 40 minutes
£19