Video Course
BEST SELLER

77-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation Certification Video Training Course

Looking for studying for 77-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation certification training course. Our 77-727 certification video training course training course is your number one assistant. Pass with our 77-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation certification training course on the first try and become a certified professional in no time.

  • 104 Students Enrolled
  • 85 Lectures
  • 6 Hours
  • 5.0 Rating
$38.49
$34.99

Curriculum For This Course

  • Introducing the Microsoft Excel User Interface

    Video Name Time
    1. Introducing the Excel User Interface 9:00
    2. Essential Navigation Skills 10:00
    3. Entering Information 17:00

  • 1.1 Create Worksheets and Workbooks

    Video Name Time
    1. 1.1.1 Create a Workbook 3:00
    2. 1.1.2 Importing Data from a Delimited Text File 5:00
    3. 1.1.3 Add a Worksheet to an Existing Workbook 2:00
    4. 1.1.4 Copy and Move a Worksheet 3:00
    5. Exercises Domain 1.1 8:00

  • 1.2 Navigate in Worksheets and Workbooks

    Video Name Time
    1. 1.2.1 & 1.2.2 Search & Navigate to a Named Cell, Range, of Workbook Element 8:00
    2. 1.2.2 Named Ranges 4:00
    3. 1.2.3 Insert and Remove hyperlinks 4:00
    4. Exercises Domain 1.2 8:00

  • 1.3 Format Worksheets and Workbooks

    Video Name Time
    1. 1.3.1 to 1.3.3 Changing Worksheet Characteristics 2:00
    2. 1.3.4 Modify Page Setup 7:00
    3. 1.3.5 Insert and Delete Columns or Rows (and Cells) 5:00
    4. 1.3.6 Change Workbook Themes 2:00
    5. 1.3.7 Adjust Row Height and Column Width 3:00
    6. 1.3.8 Insert Headers and Footers 5:00
    7. Exercises Domain 1.3 7:00

  • 1.4 Customise Options and Views for Worksheets and Workbooks

    Video Name Time
    1. 1.4.1 and 1.4.2 Hide or Unhide Worksheets, Columns and Rows 2:00
    2. 1.4.3 Customise the Quick Access Toolbar 2:00
    3. 1.4.4 Change Workbook Views 3:00
    4. 1.4.5 Change Window Views 8:00
    5. 1.4.6 Modify Document Properties 2:00
    6. 1.4.7 Change Magnification by using Zoom Tools 1:00
    7. 1.4.8 Display Formulas 2:00
    8. Exercises Domain 1.4 5:00

  • 1.5 Configure Worksheets and Workbooks for Distribution

    Video Name Time
    1. 1.5.1. Set a Print Area 1:00
    2. 1.5.2 Save Workbooks in Alternative File Formats 2:00
    3. 1.5.3 Print All of Part of a Workbook 1:00
    4. 1.5.4 Set Print Scaling 4:00
    5. 1.5.5 Display Repeating Row and Column Titles on Multipage Worksheets 2:00
    6. 1.5.6 Inspect a Workbook for Hidden Properties or Personal Information 2:00
    7. 1.5.7 Inspect a Workbook for Accessibility Issues 4:00
    8. 1.5.8 Inspect a Workbook for Compatibility Issues 3:00
    9. Exercises 1.5 3:00

  • 2.1 Insert Data in Cells and Ranges

    Video Name Time
    1. 2.1.1 Replace Data 3:00
    2. 2.1.2 Cut, Copy or Paste Data 4:00
    3. 2.1.3 Paste Data by using Special Paste Options 4:00
    4. 2.1.4 Fill Cells by using Auto Fill 3:00
    5. 2.1.5 Insert and Delete Cells 1:00
    6. Exercises Domain 2.1 6:00

  • 2.2. Format Cells and Ranges

    Video Name Time
    1. 2.2.1 Merge Cells 2:00
    2. 2.2.2 Modify Cell Alignment and Indentation 2:00
    3. 2.2.3 Format Cells by using Format Painter 2:00
    4. 2.2.4 Wrap Text Within Cells 1:00
    5. 2.2.5 Apply Number Formats 7:00
    6. 2.2.6 Apply Cell Formats 7:00
    7. 2.2.7 Apply Cell Styles 2:00
    8. Exercises Domain 2.2 7:00

  • 2.3 Summarise and Organise Data

    Video Name Time
    1. 2.3.1 Insert Sparklines 4:00
    2. 2.3.2 and 2.3.3 Outline Data and Insert Subtotals 8:00
    3. 2.3.4 Apply Conditional Formatting 5:00
    4. Exercises Domain 2.3 5:00

  • 3.1 and 3.2 Create and Manage Tables

    Video Name Time
    1. 3.1.1 and 3.1.2 Create an Excel Table from a Cell Range and Reverse 5:00
    2. 3.1.3 Add or Remove Table rows and Columns 2:00
    3. 3.2.1 to 3.2.3 Table Styles 2:00
    4. Exercises Domain 3.1 and 3.2 2:00

  • 3.3 Filter and Sort a Table

    Video Name Time
    1. 3.3.1 Filter Records 5:00
    2. 3.3.2 and 3.3.3 Sort Data 6:00
    3. 3.3.4 Remove Duplicate Records 1:00
    4. Exercises Domain 3.3 4:00

  • 4.1 Summarise Data by Using Functions

    Video Name Time
    1. 4.1.1 (Part I) Insert References 10:00
    2. 4.1.1 (Part II) Absolute References 6:00
    3. 4.1.2 Perform Calculations by using the SUM Function 5:00
    4. 4.1.3 to 4.1.5 Using the Average, MIN, MAX and COUNT Functions 4:00
    5. Exercises Domain 4.1 7:00

  • 4.2 Perform Conditional Operations by Using Functions

    Video Name Time
    1. 4.2.1 Perform Logical Operations by using the IF Function 11:00
    2. 4.2.2 to 4.2.4 Using the AverageIF, COUNTIF and SUMIF Functions 4:00
    3. Exercises Domain 4.2 9:00

  • 4.3 Format and Modify Text by Using Functions

    Video Name Time
    1. 4.3.1 Format Text by using RIGHT, LEFT and MID Functions 8:00
    2. Exercises Domain 4.3 4:00

  • 5.1 Create Charts

    Video Name Time
    1. 5.1.1 Create a New Chart 4:00
    2. 5.1.2 and 5.1.3 Add Additional Data Series and Switch Rows and Columns 1:00
    3. 5.1.4 Analyse Data by using Quick Analysis 2:00
    4. Exercises Domain 5.1 3:00

  • 5.2 Format Charts

    Video Name Time
    1. 5.2.1 Resize Charts 2:00
    2. 5.2.2 Add and Modify Chart Elements 2:00
    3. 5.2.3 and 5.2.4 Apply Chart Layouts and Styles and Move Charts 2:00
    4. Exercises Domain 5.2 3:00

  • 5.3 Insert and Format Objects

    Video Name Time
    1. 5.3.1 Insert Text Boxes and Shapes 2:00
    2. 5.3.2 Insert Images 3:00
    3. 5.3.3 Modify Object Properties 10:00
    4. 5.3.4 Add Alternative Text to Objects for Accessibility 1:00
    5. Exercises Domain 5.3 5:00

Student Feedback

  1. 49%
  2. 51%
  3. 0%
  4. 0%
  5. 0%

Excellent Overall Rating

5.0

Add Comment

Rate Course *

Secure Code
Please enter security code exactly as shown

Log into your CertBolt Account

* Only Registered Members can Download Exam Questions & Answers

Create New CertBolt Account

or Login