Best seller!
Best seller!
$27.49
$24.99
77-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation Certification Video Training Course
The complete solution to prepare for for your exam with 77-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation certification video training course. The 77-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation certification video training course contains a complete set of videos that will provide you with thorough knowledge to understand the key concepts. Top notch prep including Microsoft Excel 77-727 exam dumps, study guide & practice test questions and answers.
91 Students Enrolled
06:07:00 Hours
77-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation Certification Video Training Course Exam Curriculum
1
Introducing the Microsoft Excel User Interface
3 Lectures
Time 00:36:00
2
1.1 Create Worksheets and Workbooks
5 Lectures
Time 00:21:00
3
1.2 Navigate in Worksheets and Workbooks
4 Lectures
Time 00:24:00
4
1.3 Format Worksheets and Workbooks
7 Lectures
Time 00:31:00
5
1.4 Customise Options and Views for Worksheets and Workbooks
8 Lectures
Time 00:25:00
6
1.5 Configure Worksheets and Workbooks for Distribution
9 Lectures
Time 00:22:00
7
2.1 Insert Data in Cells and Ranges
6 Lectures
Time 00:21:00
8
2.2. Format Cells and Ranges
8 Lectures
Time 00:30:00
9
2.3 Summarise and Organise Data
4 Lectures
Time 00:22:00
10
3.1 and 3.2 Create and Manage Tables
4 Lectures
Time 00:11:00
11
3.3 Filter and Sort a Table
4 Lectures
Time 00:16:00
12
4.1 Summarise Data by Using Functions
5 Lectures
Time 00:32:00
13
4.2 Perform Conditional Operations by Using Functions
3 Lectures
Time 00:24:00
14
4.3 Format and Modify Text by Using Functions
2 Lectures
Time 00:12:00
15
5.1 Create Charts
4 Lectures
Time 00:10:00
16
5.2 Format Charts
4 Lectures
Time 00:09:00
17
5.3 Insert and Format Objects
5 Lectures
Time 00:21:00
Introducing the Microsoft Excel User Interface
-
9:00
1. Introducing the Excel User Interface
-
10:00
2. Essential Navigation Skills
-
17:00
3. Entering Information
1.1 Create Worksheets and Workbooks
-
3:00
1. 1.1.1 Create a Workbook
-
5:00
2. 1.1.2 Importing Data from a Delimited Text File
-
2:00
3. 1.1.3 Add a Worksheet to an Existing Workbook
-
3:00
4. 1.1.4 Copy and Move a Worksheet
-
8:00
5. Exercises Domain 1.1
1.2 Navigate in Worksheets and Workbooks
-
8:00
1. 1.2.1 & 1.2.2 Search & Navigate to a Named Cell, Range, of Workbook Element
-
4:00
2. 1.2.2 Named Ranges
-
4:00
3. 1.2.3 Insert and Remove hyperlinks
-
8:00
4. Exercises Domain 1.2
1.3 Format Worksheets and Workbooks
-
2:00
1. 1.3.1 to 1.3.3 Changing Worksheet Characteristics
-
7:00
2. 1.3.4 Modify Page Setup
-
5:00
3. 1.3.5 Insert and Delete Columns or Rows (and Cells)
-
2:00
4. 1.3.6 Change Workbook Themes
-
3:00
5. 1.3.7 Adjust Row Height and Column Width
-
5:00
6. 1.3.8 Insert Headers and Footers
-
7:00
7. Exercises Domain 1.3
1.4 Customise Options and Views for Worksheets and Workbooks
-
2:00
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
-
3:00
3. 1.4.4 Change Workbook Views
-
8:00
4. 1.4.5 Change Window Views
-
2:00
5. 1.4.6 Modify Document Properties
-
1:00
6. 1.4.7 Change Magnification by using Zoom Tools
-
2:00
7. 1.4.8 Display Formulas
-
5:00
8. Exercises Domain 1.4
1.5 Configure Worksheets and Workbooks for Distribution
-
1:00
1. 1.5.1. Set a Print Area
-
2:00
2. 1.5.2 Save Workbooks in Alternative File Formats
-
1:00
3. 1.5.3 Print All of Part of a Workbook
-
4:00
4. 1.5.4 Set Print Scaling
-
2: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
-
4:00
7. 1.5.7 Inspect a Workbook for Accessibility Issues
-
3:00
8. 1.5.8 Inspect a Workbook for Compatibility Issues
-
3:00
9. Exercises 1.5
2.1 Insert Data in Cells and Ranges
-
3:00
1. 2.1.1 Replace Data
-
4:00
2. 2.1.2 Cut, Copy or Paste Data
-
4:00
3. 2.1.3 Paste Data by using Special Paste Options
-
3:00
4. 2.1.4 Fill Cells by using Auto Fill
-
1:00
5. 2.1.5 Insert and Delete Cells
-
6:00
6. Exercises Domain 2.1
2.2. Format Cells and Ranges
-
2:00
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
-
1:00
4. 2.2.4 Wrap Text Within Cells
-
7:00
5. 2.2.5 Apply Number Formats
-
7:00
6. 2.2.6 Apply Cell Formats
-
2:00
7. 2.2.7 Apply Cell Styles
-
7:00
8. Exercises Domain 2.2
2.3 Summarise and Organise Data
-
4:00
1. 2.3.1 Insert Sparklines
-
8:00
2. 2.3.2 and 2.3.3 Outline Data and Insert Subtotals
-
5:00
3. 2.3.4 Apply Conditional Formatting
-
5:00
4. Exercises Domain 2.3
3.1 and 3.2 Create and Manage Tables
-
5:00
1. 3.1.1 and 3.1.2 Create an Excel Table from a Cell Range and Reverse
-
2: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
3.3 Filter and Sort a Table
-
5:00
1. 3.3.1 Filter Records
-
6:00
2. 3.3.2 and 3.3.3 Sort Data
-
1:00
3. 3.3.4 Remove Duplicate Records
-
4:00
4. Exercises Domain 3.3
4.1 Summarise Data by Using Functions
-
10:00
1. 4.1.1 (Part I) Insert References
-
6:00
2. 4.1.1 (Part II) Absolute References
-
5:00
3. 4.1.2 Perform Calculations by using the SUM Function
-
4:00
4. 4.1.3 to 4.1.5 Using the Average, MIN, MAX and COUNT Functions
-
7:00
5. Exercises Domain 4.1
4.2 Perform Conditional Operations by Using Functions
-
11:00
1. 4.2.1 Perform Logical Operations by using the IF Function
-
4:00
2. 4.2.2 to 4.2.4 Using the AverageIF, COUNTIF and SUMIF Functions
-
9:00
3. Exercises Domain 4.2
4.3 Format and Modify Text by Using Functions
-
8:00
1. 4.3.1 Format Text by using RIGHT, LEFT and MID Functions
-
4:00
2. Exercises Domain 4.3
5.1 Create Charts
-
4:00
1. 5.1.1 Create a New Chart
-
1:00
2. 5.1.2 and 5.1.3 Add Additional Data Series and Switch Rows and Columns
-
2:00
3. 5.1.4 Analyse Data by using Quick Analysis
-
3:00
4. Exercises Domain 5.1
5.2 Format Charts
-
2:00
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
-
3:00
4. Exercises Domain 5.2
5.3 Insert and Format Objects
-
2:00
1. 5.3.1 Insert Text Boxes and Shapes
-
3:00
2. 5.3.2 Insert Images
-
10:00
3. 5.3.3 Modify Object Properties
-
1:00
4. 5.3.4 Add Alternative Text to Objects for Accessibility
-
5:00
5. Exercises Domain 5.3
About 77-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation Certification Video Training Course
77-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation certification video training course by prepaway along with practice test questions and answers, study guide and exam dumps provides the ultimate training package to help you pass.
Prepaway's 77-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation video training course for passing certification exams is the only solution which you need.
Pass Microsoft Excel 77-727 Exam in First Attempt Guaranteed!
Get 100% Latest Exam Questions, Accurate & Verified Answers As Seen in the Actual Exam!
30 Days Free Updates, Instant Download!
$39.99
77-727 Premium Bundle
$69.98
$109.97
- Premium File 35 Questions & Answers. Last update: Feb 27, 2025
- Training Course 85 Video Lectures
- Study Guide 200 Pages
$109.97
$69.98
| Free 77-727 Exam Questions & Microsoft 77-727 Dumps | ||
|---|---|---|
| Microsoft.passguide.77-727.v2025-01-13.by.scarlett.12q.ete |
Views: 225
Downloads: 121
|
Size: 3.62 MB
|
| Microsoft.actualtests.77-727.v2020-09-06.by.alicia.11q.ete |
Views: 990
Downloads: 2041
|
Size: 3.66 MB
|
Student Feedback
4.6
Excellent
Only Registered Members
Can View Online Video Courses
Can View Online Video Courses
Please fill out your email address below in order to view Online Courses.
Registration is Free and Easy, You Simply need to provide an email address.
- Trusted By 1.2M IT Certification Candidates Every Month
- Hundreds Hours of Videos
- Instant download After Registration
A confirmation link will be sent to this email address to verify your login.
Log into your Prepaway Account
Please Log In to view Online Course
Registration is free and easy - just provide your E-mail address.
Click Here to Register
