CALL US: 6506922500, INTERNATIONAL: 6506922500, MON-FRI 6AM-4PM PT
0 item(s)
Best Saving! Instantly take as many online training courses as you want! As low as $29.00 per month.
Microsoft Excel 2013 Expert Training

Microsoft Excel 2013 Expert Training

review
5
0
5
Your Price: $99.95
In Stock
Part Number:KAL01013
  • Amazon customer:This DVD course is available at Amazon

Microsoft Excel 2013 Tutorial DVD Course

*** Complete Training Course on DVD (Internet access is not required)


Why learn the new features on your own if you can easily take our Microsoft Excel 2013 training courses to master the new version of the most popular spreadsheet program used worldwide. The self-study Excel 2013 training videos are cost-effective since everything you need to learn with is included in the course so you do not have to spend extra money on additional materials. We have certified instructors teaching our Microsoft Excel 2013 training course so that you get a quality and comprehensive education. After learning from our self-study Excel 2013 training videos, you will be a more knowledgeable professional and be able to use your skills to enhance your computer skills.

-

Excel2013 inter 5 1 from Amazing eLearning on Vimeo.



      • DURATION

        • 1.0 New Feature in Microsoft Excel 2013 (5)
          • Introduction2:08
          • Using the Startup Page, Opening New Windows and Changing Accounts5:34
          • Animating Dependent Formula Cells and Pasting as a Picture4:42
          • Using Flash Fill4:21
          • Accessing Quick Analysis Tools4:06
          • Sharing Online5:50
          • Turning Off the Workbook Share4:12
          • Creating Surveys Using SkyDrive4:54
          • Posting Spreadsheets to Social Networks7:27
          • Searching for and Inserting Graphics6:18
          • Building Data Model Relationships9:55
          • Importing Data as a Table or PivotTable Report8:25
          • Adding Timelines and Slicers8:01
          • Summary0:54
      • Basic LevelDURATION

        • 1.0 Learning Basic Excel Elements (2)
          • Introduction1:29
          • Starting and Closing Excel7:39
          • Moving Around the Worksheet9:00
          • Using the Ribbon and Locating the Backstage7:14
          • Utilizing Worksheet Tabs10:14
          • Clicking - Left, Right and on the Smart Icon8:14
          • Saving a Workbook5:00
          • Opening Existing and Recently Used Workbooks3:47
          • Setting up the Page Layout9:04
          • Previewing and Printing a Workbook6:15
          • Getting Help6:28
          • Summary0:25
        • 2.0 Applying Selection and Viewing Techniques
          • Introduction1:08
          • Selecting Cells and Ranges5:50
          • Selecting Non-Adjacent Cells and Ranges6:21
          • Selecting Columns and Rows7:02
          • Changing Column Width or Cell Height6:59
          • Hiding and Unhiding Rows and Columns5:52
          • Using Excel Views for the Perfect Visual8:23
          • Freezing Panes5:22
          • Summary0:43
        • 3.0 Utilizing Data Entry and Editing Techniques
          • Introduction1:21
          • Entering Information7:55
          • Typing Text versus Numbers8:29
          • Changing Cell Contents5:46
          • Deleting Information8:25
          • Moving and Copying Data7:34
          • Using Drag and Drop4:33
          • Using Undo and Redo3:56
          • Learning AutoFill and Flash Fill Basics6:04
          • Using AutoFill Tricks7:36
          • Summary0:42
        • 4.0 Working with Excel Data
          • Introduction0:59
          • Inserting Page Breaks5:52
          • Finding and Replacing Information8:36
          • Sorting Data5:24
          • Inserting and/or Deleting Columns and Rows5:45
          • Naming Ranges7:55
          • Checking Spelling3:23
          • Summary0:34
        • 5.0 Formatting an Excel Worksheet
          • Introduction1:49
          • Changing Font and Font Size6:12
          • Pouring Color into the Cell Background8:04
          • Bordering Cells5:11
          • Aligning Text Within a Cell3:01
          • Using the Text Wrap Feature or Wrapping Text Manually4:36
          • Using the Merge and Center Tool7:37
          • Creating the Proper Number Format9:09
          • Using Built-in Styles4:01
          • Applying Conditional Formatting8:22
          • Copying Formats with the Format Painter5:50
          • Summary0:20
        • 6.0 Performing Calculations (2)
          • Introduction1:22
          • Understanding Formula Operators and Order of Operations8:02
          • Doing Math with Real Numbers and Cell References7:18
          • Letting the Sum Button do the Math for You9:53
          • Creating Simple Formulas8:27
          • Using Common Functions6:35
          • Using the Insert Function Dialog Box10:56
          • Editing Formulas and Functions9:15
          • Changing a Formula to a Value7:02
          • Summary0:53
      • Intermediate LevelDURATION

        • 1.0 Applying Formatting Techniques
          • Introduction1:28
          • Accessing Quick Analysis Tools4:06
          • Using Worksheet Comments5:54
          • Creating and Modifying Styles7:16
          • Using Special Number Formats4:06
          • Developing Custom Number Formats10:48
          • Creating Custom Themes4:58
          • Summary0:31
        • 2.0 Organizing Worksheet and Table Data (1)
          • Introduction1:37
          • Hiding Windows and Sheet Tabs4:54
          • Creating Custom AutoFills5:28
          • Creating Tables6:42
          • Formatting with Table Styles4:24
          • Sorting and Filtering Table Data5:08
          • Using a Custom Sort5:33
          • Removing Duplicate Records4:24
          • Converting a Table to a Cell Range6:04
          • Summary0:40
        • 3.0 Using Multiple Pages, Worksheets and Workbooks (1)
          • Introduction1:18
          • Selecting Multiple Worksheets10:48
          • Viewing and Arranging Multiple Workbook Windows6:55
          • Linking Data Between Worksheets9:37
          • Linking Worksheets with Formulas10:35
          • Linking Workbooks14:02
          • Summary0:54
        • 4.0 Inserting Graphic Objects
          • Introduction1:11
          • Inserting Pictures6:18
          • Modifying Pictures9:00
          • Drawing and Modifying Shapes9:50
          • Using SmartArt Graphics7:38
          • Layering and Grouping Graphic Objects5:16
          • Using the Screenshot Tool5:00
          • Summary0:40
        • 5.0 Creating Charts (1)
          • Introduction1:38
          • Charting Consecutive Data3:49
          • Charting Non-Consecutive Data6:11
          • Moving, Resizing and Deleting Charts and Objects6:47
          • Adding Chart Titles and Legends5:15
          • Changing the Chart Type and Colors7:45
          • Displaying the Data Table6:30
          • Using Charting Tools like Sparklines and Slicers12:45
          • Printing Charts3:39
          • Saving the Chart Template for Later Use4:05
          • Summary0:44
        • 6.0 Utilizing Formulas
          • Introduction1:17
          • Using Absolute and Relative Cell References10:18
          • Using the IF Function11:42
          • Using the VLOOKUP Function10:04
          • Creating Nested Functions7:37
          • Auditing Worksheets6:07
          • Utilizing the Watch Window4:52
          • Summary0:46
        • 7.0 Finishing Details before the Workbook is Complete
          • Introduction1:08
          • Printing Titles on Each Page4:31
          • Setting the Print Area3:28
          • Adding Headers and Footers to Printed Pages5:43
          • Hyperlinking to Other Locations7:15
          • Saving the Workbook as a Template5:55
          • Changing Excel Properties4:37
          • Summary0:31
      • Advanced LevelDURATION

        • 1.0 Managing Data (2)
          • Introduction1:20
          • Importing Data into Excel7:28
          • Exporting Data from Excel6:36
          • Creating Advanced Filters6:41
          • Grouping and Ungrouping Data4:16
          • Creating an Auto Outline4:33
          • Using the Subtotal Feature7:28
          • Summary0:31
        • 2.0 Collaborating with Others (1)
          • Introduction1:18
          • Protecting Worksheets and Workbooks8:07
          • Sharing Workbooks5:45
          • Reviewing Tracked Revisions7:57
          • Turning Off the Workbook Share4:12
          • Creating Surveys Using SkyDrive5:45
          • Posting Spreadsheets to Social Networks6:34
          • Summary0:46
        • 3.0 Working with Data Tools
          • Introduction1:20
          • Validating Data7:46
          • Consolidating Data11:06
          • Working with Scenarios and Goal Seek9:31
          • Using Solver11:10
          • Creating Data Tables8:14
          • Summary0:46
        • 4.0 Recording and Using Macros (1)
          • Introduction1:26
          • Accessing the Developer Tab and Opening Workbooks with Macros7:57
          • Recording and Running a Macro8:20
          • Viewing and Modifying Macros5:19
          • Assigning Macros to the Quick Access Toolbar, Buttons and Shapes10:18
          • Creating a Macro to Automatically Run when the Workbook Opens2:56
          • Deleting Macros and Saving Workbooks with Macros4:07
          • Summary0:59
        • 5.0 Using Functions
          • Introduction1:25
          • Using Logical Functions11:14
          • Combining Cells using Concatenate and Turning Text to Columns12:03
          • Using the SUMIF Function11:41
          • Utilizing Database Functions10:42
          • Nesting the Index and Match Functions10:39
          • Creating a Custom Spreadsheet Formula7:01
          • Summary0:59
        • 6.0 Analyzing Data with Pivot Tables and Pivot Charts
          • Introduction1:22
          • Creating and Modifying a PivotTable13:27
          • Adding Timelines and Slicers8:01
          • Adding Calculated Fields to Pivot Tables7:42
          • Utilizing Built-in Data Model Relationships9:55
          • Importing Data as a Table or PivotTable Report9:05
          • Adding In and Applying PowerPivot Tools10:03
          • Establishing Hierarchies using PowerPivot Tools7:34
          • Analyzing Data Using Pivot Charts10:06

 

5 Stars
Perfect for proffessional
I have read and watch full tutorial.Its really helpful to increase my professional activites. Thank you
Did you find this helpful? 
Reviewed by:  from Australia. on 12/1/2014
5

Reward Points

100 points will be rewarded to you when you buy this item.

Related Items