54246 Courses in Cardiff delivered Online

Description: PowerPoint happens to be the most popular presentation software used in the world today. Its adaptation is wide and universal. You can use this software for so many different reasons; at work, in school and for personal projects. The Microsoft Office 2016 PowerPoint Complete Video Course - Beginner to Advanced is designed to teach you everything that you need to know about PowerPoint 2016. It will give you a basic to advanced knowledge. You will learn how to create amazing slides, how to use animations and transitions, how to insert videos and pictures in your presentation, how to use action buttons, how to create a perfect PowerPoint presentation. Finally, you will be able to apply what you have learned into real life situations. 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 2016 PowerPoint Complete Video Course - Beginner to 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 Office 2016 PowerPoint Complete Video Course - Beginner to 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. Microsoft PowerPoint - Beginner Navigate the PowerPoint Environment FREE 00:28:00 View and Navigate a Presentation 00:15:00 Create and Save a PowerPoint Presentation 00:13:00 Use PowerPoint Help 00:10:00 Select a Presentation Type 00:08:00 Edit Text 00:13:00 Build a Presentation 00:27:00 Format Characters 00:11:00 Format Paragraphs 00:16:00 Format Text Boxes 00:09:00 Insert Images 00:10:00 Insert Shapes 00:15:00 Edit Objects 00:16:00 Format Objects 00:06:00 Group Objects 00:04:00 Arrange Objects 00:07:00 Animate Objects 00:07:00 Create a Table 00:09:00 Format a Table 00:03:00 Insert a Table from Other Microsoft Office Applications 00:06:00 Create a Chart 00:10:00 Format a Chart 00:10:00 Insert a Chart from Microsoft Excel 00:05:00 Review Your Presentation 00:11:00 Apply Transitions 00:05:00 Print Your Presentation 00:05:00 Deliver Your Presentation 00:08:00 Microsoft PowerPoint - Advanced Customize the User Interface FREE 00:18:00 Set PowerPoint 2016 Options 00:07:00 Modify Slide Masters and Slide Layouts 00:16:00 Add Headers and Footers 00:05:00 Modify the Notes Master and the Handout Master 00:04:00 Create SmartArt 00:08:00 Modify SmartArt 00:05:00 Write Math Equations 00:07:00 Add Audio to a Presentation 00:09:00 Add Video to a Presentation 00:10:00 Customize Animations and Transitions 00:14:00 Review a Presentation 00:14:00 Store and Share Presentations on the Web 00:06:00 Annotate a Presentation 00:07:00 Set Up a Slide Show 00:08:00 Create a Custom Slide Show 00:03:00 Add Hyperlinks and Action Buttons 00:07:00 Record a Presentation 00:05:00 Secure a Presentation 00:10:00 Broadcast a Slide Show 00:07:00 Create a Video or a CD 00:08:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: In this Microsoft Office 2016 New Features - Complete Video Course you will learn all the new features and enhancement in the latest version of Office, including suite-wide enhancements and program-specific new features in Word. Excel, PowerPoint, and Outlook. Learn about accessibility, the new charts and graphs Office insights, and new ways to uncluttered your inbox and group contacts. See how to make these features part of a more productive and efficient Office workflow. You will learn to work with files and folders, Browse the Internet with Microsoft Edge, manage workspaces with Virtual Desktop, explore the general environment of Office 2016. You will also learn how to use the key new features of Word, Excel, PowerPoint, and Outlook 2016. Get an introduction with the New Features of Microsoft Office and improve your knowledge and skills. So, don't be late and grab this course now. 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 2016 New Features - 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 2016 New Features - 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. Word 2016 New Features New Themes FREE 00:26:00 New Chart Types 00:05:00 Excel 2016 New Features Power Query Enhancements 00:46:00 More Send As Options 00:04:00 New Chart Types 00:11:00 PowerPoint 2016 New Features Ink Annotations Pen Enabled 00:23:00 New Chart Types 00:07:00 Outlook 2016 New Features Archiving and Decluttering 00:19:00 OneDrive Integration 00:08:00 Mock Exam Mock Exam- Microsoft Office 2016 New Features - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2016 New Features - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: This Microsoft Office 2016 Excel Intermediate - Complete Video Course will teach you to create advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization that is able to compete at high level. If you have equivalent knowledge of Microsoft Excel 2016 Introduction then this course is perfect for you to expand your knowledge and skills. So, if you want to advance your skill set by learning to work with advanced formulas, lists, and illustrations you can join this course. You will also work with charts and advanced formatting including styles. So, why are you thinking? Come and be a part of this course now. 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 2016 Excel Intermediate - 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 2016 Excel Intermediate - 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. Working with Functions Work with Ranges FREE 00:18:00 Use Specialized Functions 00:11:00 Work with Logical Functions 00:23:00 Work with Date & Time Functions 00:08:00 Work with Text Functions 00:11:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Create and Modify Tables 00:15:00 Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 Mock Exam Mock Exam- Microsoft Office 2016 Excel Intermediate - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2016 Excel Intermediate - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: This Microsoft Office 2013 Excel Intermediate - Complete Video Course covers the intermediate functions and features of Excel 2013. You will learn about creating formulas, inserting graphics and enhancing workbooks. You will also learn how to organize worksheet data with tables and charts and how to analyze data using PivotTables, Slicers and PivotCharts. In this course creating advanced formulas, you will learn how to apply range names and how to use specialized functions. Once you are comfortable with the basics, you will be ready for this intermediate level. Here, you will explore more advanced formatting with terms, using Excel provided templates, adding graphics and charts, and using Excel as a database. You finish off with advanced formulas and applying conditional formatting to your worksheet, and more. If you want to take your Microsoft Excel 2013 skills to the next level, you'll learn how to use this program's advanced features to build a fully functional database from scratch. 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 Excel Intermediate - 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 Excel Intermediate - 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. Creating Advanced Formulas Apply Range Names FREE 00:18:00 Use Specialized Functions 00:14:00 Analyzing Data with Logical and Lookup Functions Leverage Questions and Testing to Write Formulas 00:01:00 Use Logical and Lookup Functions to Find Answers to Questions 00:25:00 Organizing Worksheet Data with Tables Create and Modify Tables 00:09:00 Sort and Filter Data 00:27:00 Use Summary and Database Functions to Calculate Data 00:25:00 Visualizing Data with Charts Create Charts 00:05:00 Modify and Format Charts 00:25:00 Create a Trendline 00:10:00 Create Advanced Charts 00:09:00 Analyzing Data with PivotTables, Slicers, and PivotCharts Create a PivotTable 00:24:00 Filter Data by Using Slicers 00:09:00 Analyze Data by Using PivotCharts 00:07:00 Inserting Graphics Insert and Modify Graphic Objects 00:10:00 Layer and Group Graphic Objects 00:12:00 Incorporate SmartArt 00:06:00 Enhancing Workbooks Customizing Workbooks 00:08:00 Manage Themes 00:06:00 Create and Use Templates 00:06:00 Protect Files 00:08:00 Mock Exam Mock Exam- Microsoft Office 2013 Excel Intermediate - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2013 Excel Intermediate - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: If you already have the basic skills and knowledge of Microsoft Word 2010 and you are able to create, edit, and print word documents on Windows then this [course_tite] is designed for you. This series builds on the skills and concepts taught in Word 2010 Basic. You will learn advanced formatting, use Word's drawing tools, create and manage tables, and work with column layouts. Here, you will work with styles, sections, and columns and will use the Navigation pane to work with outlines. By this course, you will learn to use Word's advanced editing tools, work with images, including placing and sizing images, wrapping text around images, and using borders and effects, how to adjust page orientation an layout, how to work with columns and with page and section breaks, and more. This intermediate level will pull up your basic knowledge and skills so don't delay to try this. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2010 Word Intermediate - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2010 Word Intermediate - 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. Styles and Outlines Examining Formatting FREE 00:07:00 Creating Styles 00:17:00 Modifying Styles 00:11:00 Working with Outlines 00:13:00 Sections and Columns Creating and Formatting Sections 00:13:00 Working with Columns 00:08:00 Formatting Tables Table Formatting Basics 00:09:00 Borders and Shading 00:06:00 Table Data 00:10:00 Table Styles 00:09:00 Printing Labels and Envelopes Labels 00:06:00 Envelopes 00:05:00 Templates and Building Blocks Template Basics 00:11:00 Building Blocks 00:02:00 Document Properties 00:14:00 Graphics Creating Diagrams 00:02:00 Using the Drawing Tools 00:13:00 Formatting Text Graphically 00:06:00 Managing Document Revisions Tracking Changes 00:21:00 Working with Comments 00:02:00 Web Features Web Pages 00:03:00 Hyperlinks 00:10:00 Mock Exam Mock Exam- Microsoft Office 2010 Word Intermediate - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2010 Word Intermediate - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: This Microsoft Office 2010 Outlook Intermediate - Complete Video Course is intended for novice information workers who want to learn the intermediate level Outlook 2010 skills. This series will provide you with more advanced skills for managing e-mail, schedules, and contacts. This series builds on the skills and concepts taught in Outlook 2010 Basic. You will be learning how to customize Outlook and work with address books, how to search and filter mail folders, and apply and customize categories. Finally you will be able to work with conversation view, arrange message in different ways, quickly locate message, print message, configure time zone, work with multiple calendars, print a calendar, create contact group, create and format business graphics, import and export contact records, personal, public, offline folders, set rules, and more. Before you taking this course you should have a firm grasp of the basics. This intermediate level will pull up your basic knowledge. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2010 Outlook Intermediate - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2010 Outlook Intermediate - 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. Customizing Outlook The Outlook Environment FREE 00:16:00 General Options 00:07:00 Language and Keyboard Options 00:07:00 Quick Steps 00:06:00 The Navigation Pane 00:07:00 Working with Contacts Address Books 00:12:00 Contact Groups 00:08:00 Customizing Messages Message Appearance 00:17:00 Signatures 00:13:00 Voting Buttons 00:07:00 Out-of-Office Messages 00:14:00 Organizing Items Folders 00:03:00 Searching 00:11:00 Filters 00:06:00 Categories 00:20:00 Organizing Mail Organizing the Inbox Folder 00:26:00 Setting Rules 00:18:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: This Microsoft Office 2010 Excel Intermediate - Complete Video Course builds on the skills and concepts taught in Excel 2010: Basic. You will learn how to use multiple worksheets and workbooks efficiently, and you will start working with more advanced formatting options including styles, themes, and backgrounds, create informative, eye-catching charts and harness the power of Excel's data analysis and filtering tools, how to create outlines and subtotals, how to create and apply cell names, and how to work with tables. You will save workbooks as Web pages, insert and edit hyperlinks, and learn to share workbooks by email. In addition, you'll find out how easy it is to create macros that let you manipulate data with the push of a button. You'll also discover how to use Goal Seek and Solver and apply them to real-world problems. And you'll set yourself apart from the casual Excel user by adding time-saving functions to your repertoire. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2010 Excel Intermediate - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2010 Excel Intermediate - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Using Multiple Worksheets and Workbooks Using Multiple Workbooks 00:05:00 Linking Worksheets with 3-D Formulas 00:05:00 Linking Workbooks 00:09:00 Managing Workbooks 00:04:00 Advanced Formatting Using Special Number Formats 00:10:00 Using Functions to Format Text 00:09:00 Working with Styles 00:08:00 Working with Themes 00:07:00 Other Advanced Formatting 00:17:00 Outlining and Subtotals Outlining and Consolidating Data 00:13:00 Creating Subtotals 00:06:00 Cell and Range Names Creating and Using Names 00:14:00 Managing Names 00:07:00 Tables Sorting and Filtering Data 00:09:00 Advanced Filtering 00:08:00 Working with Tables 00:10:00 Web and Sharing Features Saving Workbooks as Web Pages 00:05:00 Using Hyperlinks 00:06:00 Sharing Workbooks 00:03:00 Advanced Charting Chart Formatting Options 00:05:00 Combination Charts 00:08:00 Graphical Elements 00:11:00 Documenting and Auditing Auditing Features 00:05:00 Comments in Cells and Workbooks 00:04:00 Protection 00:08:00 Workgroup Collaboration 00:09:00 Templates and Settings Application Settings 00:08:00 Built-in Templates 00:04:00 Creating and Managing Templates 00:05:00 PivotTables and PivotCharts Working with PivotTables 00:14:00 Rearranging PivotTables 00:06:00 Formatting PivotTables 00:03:00 Using PivotCharts 00:04:00 Mock Exam Mock Exam- Microsoft Office 2010 Excel Intermediate - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2010 Excel Intermediate - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description:  This Microsoft Office 2010 Excel Beginners - Complete Video Course will teach you the basic functions and features of Excel 2010. After an introduction to spreadsheet terminology and Excel's window components, you will learn how to use the Help system and navigate worksheets and workbooks. Then you will enter and edit text, values, formulas, and pictures, and you will save workbooks in various formats. You will also move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. This course is designed to introduce you to using Microsoft Excel if you're unfamiliar with any major aspect of it. The series will lead you through the fundamentals of creating and working with Excel spreadsheets. Today's Excel spreadsheet isn't just for financial professionals. Microsoft Excel offers intuitive tools that make it easy to access, connect, and analyze critical data-regardless of your profession. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2010 Excel 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 Office 2010 Excel 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 Spreadsheet Terminology FREE 00:02:00 The Excel Environment 00:05:00 Getting Help 00:03:00 Navigating a Worksheet 00:06:00 Entering and Editing Data Entering and Editing Text and Values 00:09:00 Entering and Editing Formulas 00:09:00 Working with Pictures 00:03:00 Saving and Updating Workbooks 00:07:00 Modifying a Worksheet Moving and Copying Data 00:13:00 Moving and Copying Formulas 00:07:00 Absolute and Relative References 00:06:00 Inserting and Deleting Ranges, Rows, and Columns 00:07:00 Functions Entering Functions 00:15:00 AutoSum 00:04:00 Other Common Functions 00:11:00 Formatting Text Formatting 00:06:00 Column Formatting 00:12:00 Number Formatting 00:06:00 Conditional Formatting 00:10:00 Additional Formatting Options 00:12:00 Printing Preparing to Print 00:09:00 Page Setup Options 00:14:00 Printing Worksheets 00:04:00 Charts Chart Basics 00:11:00 Formatting Charts 00:05:00 Managing Large Workbooks Viewing Large Worksheets 00:14:00 Working with Multiple Worksheets 00:12:00 Printing Large Worksheets 00:08:00 Graphics and Screenshots Conditional Formatting with Graphics 00:09:00 SmartArt Graphics 00:05:00 Screenshots 00:05:00 Mock Exam Mock Exam- Microsoft Office 2010 Excel Beginners - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2010 Excel Beginners - Complete Video Course 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: This Microsoft Office 2007 PowerPoint Beginners - Complete Video Course will provide you with an overview of the features and functions of Microsoft Office PowerPoint 2007. By taking this course you will learn to work with PowerPoint environment, open move around in, and close a presentation, display different views of a presentation, save a presentation, quickly create a presentation, create a presentation based on a ready-made design, convert an outline to a presentation, reuse existing slides, create a photo album, enter text, edit text, add and manipulate text boxes, correct and size text boxes, correct and size text while typing, check spelling and choose the best words, find and replace text while typing, change the size, alignment, spacing, apply a theme, rearrange slides in a presentation, switch to a different color scheme, and more.  So, if you are interested to learn all the basics of Microsoft Office PowrPoint 2007, then you should join this course now. 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 2007 PowerPoint 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 Office 2007 PowerPoint 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 The PowerPoint Window FREE 00:17:00 Getting Help 00:01:00 New Presentations Creating New Presentations 00:09:00 Saving Presentations 00:03:00 Rearranging and Deleting Slides 00:03:00 Using Slides from Other Presentations 00:02:00 Formatting Slides Text Formatting 00:18:00 Modifying Text 00:10:00 Paragraph Formatting 00:03:00 Drawing Objects Shapes 00:05:00 Modifying Objects 00:16:00 Text in Shapes 00:12:00 Graphics WordArt 00:07:00 Pictures 00:10:00 Clip Art 00:07:00 Tables and Charts Tables 00:10:00 Charts 00:06:00 Diagrams 00:06:00 Modifying Presentations Templates and Themes 00:06:00 Slide Masters 00:17:00 Transitions and Timings 00:07:00 Speaker Notes 00:04:00 Setting Up Slide Shows 00:05:00 Proofing and Delivering Presentations Proofing Presentations 00:07:00 Running Presentations 00:02:00 Printing Presentationsns 00:07:00 Mock Exam Mock Exam- Microsoft Office 2007 PowerPoint Beginners - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2007 PowerPoint Beginners - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: This Microsoft Office 2007 Excel Intermediate - Complete Video Course will provide you with experience at creating more elaborate worksheet and workbooks n Microsoft Office Excel 2007 to display data in more effective ways. In this series you will work with multiple worksheets and workbooks, you will learn how to switch between workbooks and even copy worksheets, you will also get 3D formulas: 3D formulas will allow you to link the worksheets, and also add something call the Watch-Window. You will learn to create and manage all these linked workbooks as well as creating workspaces which will allow you to manage the workbook as well. Before getting this course you must have the basic skills of Microsoft Excel 2007. This level will give you an advanced knowledge you need to know about Microsoft Excel. 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 2007 Excel Intermediate - 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 2007 Excel Intermediate - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Using Multiple Worksheets and Workbooks Using Multiple Workbooks FREE 00:04:00 Linking Worksheets with 3-D Formulas 00:06:00 Linking Workbooks 00:11:00 Managing Workbooks 00:04:00 Advanced Formatting Using Special Number Formats 00:17:00 Using Functions to Format Text 00:13:00 Working with Styles 00:07:00 Working with Themes 00:11:00 Other Advanced Formatting 00:13:00 Outlining and Subtotals Outlining and Consolidating Data 00:11:00 Creating Subtotals 00:06:00 Cell and Range Names Creating and Using Names 00:12:00 Managing Names 00:04:00 Lists and Tables Examining Lists 00:03:00 Sorting and Filtering Lists 00:07:00 Advanced Filtering 00:12:00 Working with Tables 00:22:00 Web and Internet Features Saving Workbooks as Web Pages 00:11:00 Using Hyperlinks 00:04:00 Distributing Workbooks 00:03:00 Advanced Charting Chart Formatting Options 00:08:00 Combination Charts 00:05:00 Graphic Elements 00:09:00 Documenting and Auditing Auditing Features 00:05:00 Comments in Cells and Workbooks 00:08:00 Protection 00:05:00 Workgroup Collaboration 00:13:00 Templates and Settings Application Settings 00:05:00 Built-in Templates 00:07:00 Creating and Managing Templates 00:10:00 Mock Exam Mock Exam- Microsoft Office 2007 Excel Intermediate - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2007 Excel Intermediate - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00