0

  • No products in the basket.

Microsoft Office 2016 Advanced
Introduction Improve your admin skills, computer literacy and data analysis capabilities with this comprehensive online Microsoft Office course. Focussing on …
Microsoft Office 2016 Advanced

Category

CPD Accredited Office Productivity Others

Students

94

Review

4.7

Course Description

Introduction

Improve your admin skills, computer literacy and data analysis capabilities with this comprehensive online Microsoft Office course. Focussing on the industry-standard suite of administrative software, the Microsoft Office 2016 Advanced teaches you knowledge and expertise applicable to all areas of industry, boosting your confidence and enhancing your employability.

Course description

The Microsoft Office 2016 Advanced course is taught by expert instructors through easy-to-understand video tutorials, online study materials, and practical activities. You will gain a complete comprehension of using Microsoft Office software including creating documents using Word, managing data and spreadsheets in Excel, designing presentations in PowerPoint, as well as using Access for databases and maintaining your inbox with Outlook.

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

How is the course assessed?

To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion.

Will I receive a certificate of completion?

Upon successful completion you will qualify for the UK and internationally-recognised certificate and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15.

Why study this course

Whether you’re an existing practitioner or aspiring professional, this course will enhance your expertise and boost your CV with key skills and an accredited qualification attesting to your knowledge. The [course_title] is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16.

Course Content

      • Use Links and External References 00:12:00
      • Use 3-D References 00:06:00
      • Consolidate Data 00:05:00
      • Use Lookup Functions 00:12:00
      • Trace Cells 00:09:00
      • Watch and Evaluate Formulas 00:08:00
      • Collaborate on a Workbook 00:19:00
      • Protect Worksheets and Workbooks 00:08:00
      • Apply Data Validation 00:13:00
      • Search for Invalid Data and Formulas with Errors 00:04:00
      • Work with Macros 00:18:00
      • Create Sparklines 00:07:00
      • MapData 00:07:00
      • Determine Potential Outcomes Using Data Tables 00:08:00
      • Determine Potential Outcomes Using Scenarios 00:09:00
      • Use the Goal Seek Feature 00:04:00
      • Forecasting Data Trends 00:05:00
      • Integrate Pictures and Text 00:15:00
      • Adjust Image Appearance 00:09:00
      • Insert Other Media Elements 00:02:00
      • 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
      • 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
      • 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
      • 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
      • Create Forms 00:09:00
      • Modify Forms 00:03:00
      • Automate Tasks by Using Macros 00:10:00
      • Create a Macro 00:19:00
      • Customize the User Interface 00:19: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:09: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:15: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:11:00
      • Broadcast a Slide Show 00:07:00
      • Create a Video or a CD 00:08:00
      • Add Controls to Forms 00:11:00
      • Enhance Navigation and Organization of Forms 00:14:00
      • Apply Conditional Formatting 00:04:00
      • Import Data into Access 00:08:00
      • Export Access Data 00:06:00
      • Link Tables to External Data Sources 00:05:00
      • Create a Mail Merge 00:02:00
      • Create a Macro 00:08:00
      • Restrict Records by Using a Condition 00:04:00
      • Validate Data by Using a Macro 00:05:00
      • Automate Data Entry by Using a Macro 00:04:00
      • Manage a Database 00:08:00
      • Determine Object Dependency 00:04:00
      • Manage a Database 00:07:00
      • Document a Database 00:04:00
      • Splitting a Database for Multiple User Access 00:05:00
      • Implement Security 00:03:00
      • Convert an Access Database to an ACCDE File 00:04:00
      • Package a Database with a Digital Signature 00:01:00
      • Create a Database Switchboard 00:05:00
      • Modify a Database Switchboard 00:02:00
      • Set Start up Options 00:04:00

    4.7

    4.7
    7 ratings
    • 5 stars0
    • 4 stars0
    • 3 stars0
    • 2 stars0
    • 1 stars0

    No Reviews found for this course.

    Original price was: £424.99.Current price is: £29.00. ex Vat
    30-Day Money-Back Guarantee
    Includes
    • 46 hours on-demand video
    • Full lifetime access
    • Certificate of Completion
    Have a coupon?
    Facebook Twitter Youtube
    • (04) 3245-6988
    • A26BT5 Building, SilverC Street, London, England

    Useful Links

    Categories

    App Store
    Google Play

    subcribe New letters

    Enter your email and we’ll send you more information.

    Course Links | Corporate Training © Powered by Course Links.

    top