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

Pass IT Certication
Exams Guaranteed!

100% Real Questions from Actual Test
Accurate Answers Verified by Experts
Free New Questions Updates
99.8% Pass Rate Guaranteed
Exam Simulator Included!

PDFs and exam guides are not so efficient, right? 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.

140 Students Enrolled 85 Lectures 06:07:00 Hours

Curriculum For This Course

Introducing the Microsoft Excel User Interface

3Lectures

Time 00:36:00

1.1 Create Worksheets and Workbooks

5Lectures

Time 00:21:00

1.2 Navigate in Worksheets and Workbooks

4Lectures

Time 00:24:00

Introducing the Microsoft Excel User Interface
	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
	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
	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
	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
	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
	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
	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
	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
	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
	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
	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
	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
	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
	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
	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
	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
	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

Free 77-727 Exam Questions & Microsoft 77-727 Dumps
Microsoft.braindumps.77-727.v2025-02-02.by.evan.12q.ete	Downloads: 94	Size: 3.62 MB
Microsoft.pass4sures.77-727.v2021-05-12.by.darcie.11q.ete	Downloads: 1456	Size: 3.66 MB

Student Feedback

5.0

Excellent

49%

51 %

Add Comments

Name:^*

E-mail:^*

Comment:^* Comment will be moderated and published within 1-4 hours

Verification:^*

Type the characters from the picture.

Rate Course:^*

Pass IT Certication Exams Guaranteed!

Curriculum For This Course

Free 77-727 Exam Questions & Microsoft 77-727 Dumps

Student Feedback

Add Comments

Get Premium Membership

Pass IT Certication
Exams Guaranteed!