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.
$14.99$24.99
Curriculum For This Course
- 1. Introducing the Excel User Interface 9m
- 2. Essential Navigation Skills 10m
- 3. Entering Information 17m
- 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
IAPP CIPM Exam Dumps
CompTIA CS0-003 Exam Dumps
Amazon AWS SAA-C03 Exam Dumps
Microsoft AZ-800 Exam Dumps
Microsoft AZ-801 Exam Dumps
Microsoft AZ-305 Exam Dumps
CompTIA N10-008 Exam Dumps
Fortinet NSE6_FWF-6.4 Exam Dumps
SAP C_TS410_2020 Exam Dumps
CompTIA PT0-002 Exam Dumps
MSP MSP-Foundation Exam Dumps
ECCouncil 312-39 Exam Dumps
Microsoft MB-700 Exam Dumps
Cisco 350-901 Exam Dumps
Cisco 350-501 Exam Dumps
Amazon AWS AWS-Certified-Machine-Learning-Specialty-MLS-C01 Exam Dumps
Cisco 300-435 Exam Dumps
Microsoft AZ-900 Exam Dumps
Microsoft AZ-400 Exam Dumps
C++ Institute CPA Exam Dumps
Amazon AWS SAA-C03 Exam Dumps
CompTIA 220-1102 Exam Dumps
CompTIA CS0-003 Exam Dumps
Isaca CISM Exam Dumps
PMI PMP Exam Dumps
Amazon AWS AWS-Certified-Machine-Learning-Specialty-MLS-C01 Exam Dumps
CompTIA 220-1101 Exam Dumps
Microsoft SC-100 Exam Dumps
Fortinet NSE4_FGT-7.2 Exam Dumps
CompTIA SY0-701 Exam Dumps
ISC2 CISSP Exam Dumps
Microsoft AZ-900 Exam Dumps
Cisco 200-301 Exam Dumps
IAPP CIPM Exam Dumps
Microsoft SC-200 Exam Dumps
SAP C_TS410_2020 Exam Dumps
Isaca CRISC Exam Dumps
Huawei H19-301 Exam Dumps
ISC2 CCSP Exam Dumps
Exin SIAMF Exam Dumps
How to Open Test Engine .dumpsarena Files
Use FREE DumpsArena Test Engine player to open .dumpsarena files
Refund Policy
DumpsArena.com has a remarkable success record. We're confident of our products and provide a no hassle refund policy.
Your purchase with DumpsArena.com is safe and fast.
The DumpsArena.com website is protected by 256-bit SSL from Cloudflare, the leader in online security.