1296 Courses delivered Online

Description: This Microsoft Office 2013 Outlook Advanced - Complete Video Course covers the advanced functions and features of Outlook 2013. You will learn about configuring advanced message options and advanced message, calendar and contact management. In this course you will learn how to successfully use Outlook to manage the numerous aspects of communicating electronically, including: managing email communications, managing calendar events, managing your contacts, using notes to keep yourself informed, sending and receiving invites, performing advanced message, calendar, and contacts management tasks, working with the tasks and journal workspaces, and more. It will explain all of the features and functionalities the application offers in an easy to understand. You will also learn how to manage activities by using tasks and journal entries, share workspaces with others and manage outlook data files. This course is intended for them who have basic skills with Microsoft Office 2013 Outlook, and want to learn more advanced skills. 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 Outlook Advanced - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2013 Outlook Advanced - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Configure Advanced Message Options Insert Advanced Characters and Objects FREE 00:24:00 Modify Message Settings, Properties, and Options 00:11:00 Using an Automatic Reply 00:07:00 Advanced Message Management Sort Messages 00:03:00 Filter Messages 00:03:00 Organize Messages 00:09:00 Search Messages 00:09:00 Manage Junk Mail 00:04:00 Manage Your Mailbox 00:04:00 Advanced Calendar Management Manage Advanced Calendar Options 00:10:00 Create Calendar Groups 00:04:00 Manage Meeting Responses 00:05:00 Advanced Contact Management Edit an Electronic Business Card 00:07:00 Manage Advanced Contacts Options 00:04:00 Forward Contacts 00:02:00 Export Contacts 00:03:00 Managing Activities by Using Tasks and Journal Entries Assign and Manage Tasks 00:14:00 Record and Modify Journal Entries 00:06:00 Sharing Workspaces with Others Delegate Access to Mail Folders 00:05:00 Share Your Calendar 00:04:00 Share Your Contacts 00:02:00 Managing Outlook Data Files Back Up Outlook Items 00:02:00 Change Data File Settings 00:04:00 Mock Exam Mock Exam- Microsoft Office 2013 Outlook Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2013 Outlook Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

[vc_row][vc_column][vc_column_text] Description: In this course, you will be able to identify the elements of the Microsoft Excel interface. You will learn how to create a basic worksheet and to get comfortable with the parts of the screen. This Microsoft Office 2013 Excel Beginners - Complete Video Course covers the basic functions and features of Excel 2013. You will learn about calculations and how to modify and format a worksheet. You will also learn how to customize the Excel environment and how to manage and print workbooks. In this course, you will take your knowledge up a notch as you get acquainted with Microsoft Excel 2013's most sophisticated features. If you think you know Excel 2013, think again, as this course goes way beyond the basics, leaving you with knowledge of all of the best Excel tips and tricks out there. 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 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 2013 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.[/vc_column_text][/vc_column][/vc_row] Getting Started with Microsoft Excel 2013 Identify the Elements of the Excel Interface FREE 00:14:00 Create a Basic Worksheet 00:16:00 Use the Help System 00:04:00 Performing Calculations Create Formulas in a Worksheet 00:15:00 Insert Functions in a Worksheet 00:13:00 Reuse Formulas 00:15:00 Modifying a Worksheet Manipulate Data 00:13:00 Insert, Manipulate, and Delete Cells, Columns, and Rows 00:08:00 Search for and Replace Data 00:12:00 Spell Check a Worksheet 00:06:00 Formatting a Worksheet Modify Fonts 00:11:00 Add Borders and Color to Cells 00:10:00 Apply Number Formats 00:10:00 Align Cell Contents 00:10:00 Apply Cell Styles 00:08:00 Printing Workbook Contents Define the Basic Page Layout for a Workbook 00:16:00 Refine the Page Layout and Apply Print Options 00:13:00 Managing Large Workbooks Format Worksheet Tabs 00:03:00 Manage Worksheets 00:09:00 Manage the View of Worksheets and Workbooks 00:10:00 Customizing the Excel Environment Customize General and Language Options 00:08:00 Customize Formula Options 00:04:00 Customize Proofing and Save Options 00:04:00 Customize the Ribbon and Quick Access Toolbar 00:04:00 Customize the Functionality of Excel by Enabling Add-Ins 00:05:00 Customize Advanced and Trust Center Options 00:06:00 Mock Exam Mock Exam- Microsoft Office 2013 Excel Beginners - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2013 Excel Beginners - 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: By this Microsoft Office 2016 Word Advanced Level - Complete Video Course you will be introduce with the advanced level of Microsoft Word 2016. This advanced level will help you to broad up your knowledge which you got from the intermediate level. Here you will learn how to work with tables of content, footnotes and endnotes, how to insert bibliographies and indexes, how to use comments, track changes including accepting and rejecting changes, compare and combine documents, how to use mail merge and create envelope and labels, protect document ,use bookmarks, add watermarks, and customize the Ribbon, and more. You can join this course, if you have intermediate skills and knowledge with Microsoft Word 2016 and want to take another step forward or want to learn the topics covered in this course in the 2016 interface. So, don't be late, come and 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 2016 Word Advanced Level - 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 Word Advanced Level - 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. Manipulating Images Integrate Pictures and Text FREE 00:15:00 Adjust Image Appearance 00:09:00 Insert Other Media Elements 00:02:00 Using Custom Graphic Elements Create Text Boxes and Pull Quotes 00:06:00 Add WordArt and Other Text Effects 00:05:00 Draw Shapes 00:07:00 Create Complex Illustrations with SmartArt 00:08:00 Collaborating on Documents Prepare a Document for Collaboration 00:09:00 Mark Up a Document 00:06:00 Review Markups 00:04:00 Merge Changes from Other Documents 00:06:00 Adding Document References and Links Add Captions 00:06:00 Add Cross References 00:08:00 Add Bookmarks 00:05:00 Add Hyperlinks 00:06:00 Insert Footnotes and Endnotes 00:05:00 Add Citations and a Bibliography 00:11:00 Securing a Document Suppress Information 00:07:00 Set Formatting and Editing Restrictions 00:06:00 Restrict Document Access 00:02:00 Add a Digital Signature to a Document 00:04:00 Using Forms to Manage Content Create Forms 00:09:00 Modify Forms 00:03:00 Automating Repetitive Tasks with Macros Automate Tasks by Using Macros 00:10:00 Create a Macro 00:19:00 Mock Exam Mock Exam- Microsoft Office 2016 Word Advanced Level - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2016 Word Advanced Level - 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 2013 Excel Advanced - Complete Video Course covers the advanced functions and features of Excel 2013. You will learn about working with multiple worksheets and automating and auditing worksheets, how to update workbook properties, and how to apply conditional formatting. You will also learn how to export, analyze and present Excel data. This Advanced level is designed for you to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros. This course is intended for them who have intermediate skills with Microsoft Excel 2013, and want to learn more advanced skills or want to learn the topics covered in this course in the 2013 interface. So, brush up your basic and intermediate knowledge and be an expert with the help of this course. 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 Advanced - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2013 Excel Advanced - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Automating Worksheet Functionality Update Workbook Properties FREE 00:07:00 Create and Edit a Macro 00:15:00 Apply Conditional Formatting 00:09:00 Add Data Validation Criteria 00:10:00 Auditing Worksheets Trace Cells 00:05:00 Troubleshoot Invalid Data and Formula Errors 00:12:00 Watch and Evaluate Formulas 00:10:00 Create a Data List Outline 00:09:00 Analyzing and Presenting Data Create Sparklines 00:13:00 Create Scenarios 00:12:00 Perform a What If Analysis 00:19:00 Perform a Statistical Analysis with the Analysis ToolPak 00:06:00 Create Interactive Data with Power View 00:10:00 Working With Multiple Workbooks Consolidate Data 00:10:00 Link Cells in Different Workbooks 00:10:00 Merge Workbooks 00:08:00 Exporting Excel Data Export Excel Data 00:06:00 Import a Delimited Text File 00:09:00 Integrate Excel Data with the Web 00:11:00 Create a Web Query 00:08:00 Mock Exam Mock Exam- Microsoft Office 2013 Excel Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2013 Excel Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

The Microsoft Office Specialist (MOS) is a globally recognised qualification. Having a Microsoft Office Specialist certification on your CV demonstrates that you have gained the necessary expertise to competently use Microsoft applications, giving you a competitive advantage when job hunting as well as in the workplace. It will significantly increase your confidence, skills and employability. It will serve to objectively validate your IT skills and assist in your advancement in your chosen career.

Microsoft Office 2016 Complete Course for Beginners is one of our best selling and most popular course. The Microsoft Office 2016 Complete Course for Beginners is organised into 5 modules and includes everything you need to become successful in this profession. To make this course more accessible for you, we have designed it for both part-time and full-time students. You can study at your own pace or become an expert in just 78 hours! If you require support, our experienced tutors are always available to help you throughout the comprehensive syllabus of this course and answer all your queries through email. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post.

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