800.978.9790
 Loading... Please wait...


  • Image 1

Excel 2013 Level 1 (Download)

$14.95
Quantity:

Product Description

Excel 2013 Level 1 training videos download comes in Windows Media Video (.wmv) file format, and follow along exercise files! Our Excel 2013 Level 1, with Levels 2 & 3 training videos include all the training you need to pass the Excel 2013 Core (77-420) and Expert Part 1 (77-427) and Part 2 (77-428) Exams and become certified!

Excel 2013 training videos will explain first what a database is, and then the foundation of the database which are tables. After you'll want to learn how to quickly extract and enter your data in an organized format by using forms. Also, you'll be shown how fun and easy it is to create reports, a way to extract your data from your tables and into a printable format.

Learn to create relationships between tables including the most popularly misunderstood one-to-one relationship, and more by our Microsoft Certified Trainer training Excel 2013!

Excel 2013 Level 1 (4.5+ hrs):

Basics

  1. Excel 2013 Overview (9:46)
  2. Customize Excel Environment (9:33)
  3. Customize Quick Access Toolbar (6:51)
  4. Customize Ribbon (10:14)
  5. Navigating Excel (5:44)
  6. Creating A Basic Worksheet (4:52)
  7. Save & Save As (5:13)
  8. Convert To 2013 (3:44)
  9. Compatibility Checker (5:20)
  10. Convert To Previous Version (6:10)
  11. Excel 2013 Help (2:30)

Functions & Formulas

  1. Basic Formulas A (10:31)
  2. Basic Formulas B (6:13)
  3. SUM & AVERAGE A (9:10)
  4. SUM & AVERAGE B (5:44)
  5. MAX & MIN (4:56)
  6. COUNT & COUNTA (4:01)
  7. Move, Copy & Cut Data (10:33)
  8. Absolute References (7:59)
  9. Mixed References (6:38)
  10. AutoFill (7:58)
  11. FlashFill (3:57)
  12. Text To Columns (3:29)

Editing Worksheets

  1. Editing Data (3:13)
  2. Editing Columns, Rows & Cells (3:55)
  3. Find & Replace (5:29)
  4. GoTo (5:20)
  5. Transpose Data (3:08)
  6. Adjust Columns & Rows (4:40)
  7. Spell Check (2:04)

Formatting

  1. Modifying Fonts (2:45)
  2. Basic Number Formats (5:11)
  3. Basic Customer Number Formats (3:54)
  4. Borders & Colors (7:41)
  5. Formatting Shortcuts (3:16)
  6. Adding Background (1:29)
  7. Align & Positioning Contents (5:46)
  8. Create & Manage Styles (5:15)
  9. AutoFormat (2:30)
  10. Applying Themes (11:00)

Printing

  1. Print Preview (2:34)
  2. Page Orientation (2:25)
  3. Print Titles (5:08)
  4. Headers & Footers (7:09)
  5. Margins (3:15)
  6. Page Breaks (8:33)
  7. Print Range & Scaling (5:27)

Modifying Worksheet Appearance

  1. Managing Worksheets (8:56)
  2. Hide Sheets & Workbooks (5:02)
  3. Split Worksheet (1:37)
  4. Freeze Panes (4:45)
  5. Multiple Worksheet & Workbook Views (3:13)
  6. Formula Options (2:49)
  7. Speak Cells (1:25)

 

Excel 2013 Level 1 Training Videos (Download)

Excel 2013 Level 1 Training Videos (Download) from Dream Force — training videos solutions.
Affordable Excel 2013 Level 1 Training Videos (Download)
.

Product Reviews

Write Review

This product hasn't received any reviews yet. Be the first to review this product!

Find Similar Products by Category