Exclusive SALE Offer Today

77-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation

Best Seller 85 Lectures 6h 7m
Prepare for your Microsoft examination with our training course. The 77-727 course contains a complete batch of videos that will provide you with profound and thorough knowledge related to Microsoft certification exam. Pass the Microsoft 77-727 test with flying colors.
$13.99$24.99
Curriculum For This Course
  • 1. 1.1.1 Create a Workbook 3m
  • 2. 1.1.2 Importing Data from a Delimited Text File 5m
  • 3. 1.1.3 Add a Worksheet to an Existing Workbook 2m
  • 4. 1.1.4 Copy and Move a Worksheet 3m
  • 5. Exercises Domain 1.1 8m
  • 1. 1.2.1 & 1.2.2 Search & Navigate to a Named Cell, Range, of Workbook Element 8m
  • 2. 1.2.2 Named Ranges 4m
  • 3. 1.2.3 Insert and Remove hyperlinks 4m
  • 4. Exercises Domain 1.2 8m
  • 1. 1.3.1 to 1.3.3 Changing Worksheet Characteristics 2m
  • 2. 1.3.4 Modify Page Setup 7m
  • 3. 1.3.5 Insert and Delete Columns or Rows (and Cells) 5m
  • 4. 1.3.6 Change Workbook Themes 2m
  • 5. 1.3.7 Adjust Row Height and Column Width 3m
  • 6. 1.3.8 Insert Headers and Footers 5m
  • 7. Exercises Domain 1.3 7m
  • 1. 1.4.1 and 1.4.2 Hide or Unhide Worksheets, Columns and Rows 2m
  • 2. 1.4.3 Customise the Quick Access Toolbar 2m
  • 3. 1.4.4 Change Workbook Views 3m
  • 4. 1.4.5 Change Window Views 8m
  • 5. 1.4.6 Modify Document Properties 2m
  • 6. 1.4.7 Change Magnification by using Zoom Tools 1m
  • 7. 1.4.8 Display Formulas 2m
  • 8. Exercises Domain 1.4 5m
  • 1. 1.5.1 1m
  • 2. 1.5.2 Save Workbooks in Alternative File Formats 2m
  • 3. 1.5.3 Print All of Part of a Workbook 1m
  • 4. 1.5.4 Set Print Scaling 4m
  • 5. 1.5.5 Display Repeating Row and Column Titles on Multipage Worksheets 2m
  • 6. 1.5.6 Inspect a Workbook for Hidden Properties or Personal Information 2m
  • 7. 1.5.7 Inspect a Workbook for Accessibility Issues 4m
  • 8. 1.5.8 Inspect a Workbook for Compatibility Issues 3m
  • 9. Exercises 1.5 3m
  • 1. 2.1.1 Replace Data 3m
  • 2. 2.1.2 Cut, Copy or Paste Data 4m
  • 3. 2.1.3 Paste Data by using Special Paste Options 4m
  • 4. 2.1.4 Fill Cells by using Auto Fill 3m
  • 5. 2.1.5 Insert and Delete Cells 1m
  • 6. Exercises Domain 2.1 6m
  • 1. 2.2.1 Merge Cells 2m
  • 2. 2.2.2 Modify Cell Alignment and Indentation 2m
  • 3. 2.2.3 Format Cells by using Format Painter 2m
  • 4. 2.2.4 Wrap Text Within Cells 1m
  • 5. 2.2.5 Apply Number Formats 7m
  • 6. 2.2.6 Apply Cell Formats 7m
  • 7. 2.2.7 Apply Cell Styles 2m
  • 8. Exercises Domain 2.2 7m
  • 1. 2.3.1 Insert Sparklines 4m
  • 2. 2.3.2 and 2.3.3 Outline Data and Insert Subtotals 8m
  • 3. 2.3.4 Apply Conditional Formatting 5m
  • 4. Exercises Domain 2.3 5m
  • 1. 3.1.1 and 3.1.2 Create an Excel Table from a Cell Range and Reverse 5m
  • 2. 3.1.3 Add or Remove Table rows and Columns 2m
  • 3. 3.2.1 to 3.2.3 Table Styles 2m
  • 4. Exercises Domain 3.1 and 3.2 2m
  • 1. 3.3.1 Filter Records 5m
  • 2. 3.3.2 and 3.3.3 Sort Data 6m
  • 3. 3.3.4 Remove Duplicate Records 1m
  • 4. Exercises Domain 3.3 4m
  • 1. 4.1.1 (Part I) Insert References 10m
  • 2. 4.1.1 (Part II) Absolute References 6m
  • 3. 4.1.2 Perform Calculations by using the SUM Function 5m
  • 4. 4.1.3 to 4.1.5 Using the Average, MIN, MAX and COUNT Functions 4m
  • 5. Exercises Domain 4.1 7m
  • 1. 4.2.1 Perform Logical Operations by using the IF Function 11m
  • 2. 4.2.2 to 4.2.4 Using the AverageIF, COUNTIF and SUMIF Functions 4m
  • 3. Exercises Domain 4.2 9m
  • 1. 4.3.1 Format Text by using RIGHT, LEFT and MID Functions 8m
  • 2. Exercises Domain 4.3 4m
  • 1. 5.1.1 Create a New Chart 4m
  • 2. 5.1.2 and 5.1.3 Add Additional Data Series and Switch Rows and Columns 1m
  • 3. 5.1.4 Analyse Data by using Quick Analysis 2m
  • 4. Exercises Domain 5.1 3m
  • 1. 5.2.1 Resize Charts 2m
  • 2. 5.2.2 Add and Modify Chart Elements 2m
  • 3. 5.2.3 and 5.2.4 Apply Chart Layouts and Styles and Move Charts 2m
  • 4. Exercises Domain 5.2 3m
  • 1. 5.3.1 Insert Text Boxes and Shapes 2m
  • 2. 5.3.2 Insert Images 3m
  • 3. 5.3.3 Modify Object Properties 10m
  • 4. 5.3.4 Add Alternative Text to Objects for Accessibility 1m
  • 5. Exercises Domain 5.3 5m

Hot Exams

How to Open Test Engine .dumpsqueen Files

Use FREE DumpsQueen Test Engine player to open .dumpsqueen files

DumpsQueen Test Engine

Windows

safe checkout

Your purchase with DumpsQueen.com is safe and fast.

The DumpsQueen.com website is protected by 256-bit SSL from Cloudflare, the leader in online security.

Need Help Assistance?

Customer Support