Excel 2010 Level 2 (Download)
Excel 2010 Level 2 training videos download comes in Windows Media Video (.wmv) file format, and follow along exercise files! Our Excel 2010 Level 2, with Levels 1 & 3 training videos include all the training you need to pass the Excel 2010 Core (77-882) and Expert (77-888) Exams and become certified!
Excel 2010 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 2010!
Excel 2010 Level 2 (4+ hrs):
- Name Cells & Ranges (6:06)
- Linking Data (5:48)
- UPPER, LOWER & PROPER (3:08)
- CONCATENATE (3:50)
- LEFT, FIND & SEARCH (8:49)
- RIGHT, FIND & LEN (8:31)
- IF, AND & OR (6:09)
- Nested IF (3:11)
- IFERROR (2:20)
- PMT Payment Function (3:16)
- Display & Print Formulas (1:22)
- SUM, COUNT & AVERAGE IF(S) (8:11)
- VLOOKUP (7:11)
- HLOOKUP (5:44)
- Create Tables (3:39)
- Modifying Tables (5:37)
- Formatting Tables (1:46)
- Custom Table Style (2:50)
- Table Sorting & Filtering (4:28)
- DSUM, DAVERAGE & DCOUNT (9:04)
- Time Functions (3:31)
- Sorting & Database Flaws (7:18)
- AutoFilter (6:42)
- Advanced Filter (10:06)
- Subtotals (4:29)
- Create Charts (5:14)
- Modifying Charts A (4:55)
- Modifying Charts B (3:15)
- Chart Titles (3:26)
- Formatting Charts (3:50)
- Creating Chart Templates (1:34)
- Chart Application Sharing (1:04)
PivotTable & Charts
- Create PivotTables (9:58)
- Customize PivotTables (10:08)
- PivotTable Slicers (8:24)
- Create Pivot Charts (5:20)
- Insert & Modifying Pictures (4:00)
- ClipArt (2:26)
- Drawing & Modifying Shapes (5:33)
- SmartArt Graphics (5:25)
- Layering & Grouping Objects (4:21)
- Insert & Modify Comments (7:31)
- Hyperlinks (7:01)
- Web Research (0:55)
- Watermarks & Gridlines (5:00)
- Customize Themes (6:58)
- Create Workbook Templates (1:15)
- Create Custom Templates (3:59)
Excel 2010 Level 2 Training Videos (Download) from Dream Force — training videos solutions.
Affordable Excel 2010 Level 2 Training Videos (Download).
I've taken level 1 and level 2 Word. In process of taking level 2 Excel.
Trust me. You'll never attend another Microsoft seminar.