O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Microsoft Office 2013 Excel

Video Description

From Microsoft: Microsoft Excel 2013 is designed to help you get professional-looking results with features that let you get away from walls of numbers and draw more persuasive pictures of your data, guiding you to better, more informed decisions. It includes templates for the set-up and design, Quick Analysis tool which converts your data into a chart or table in two steps or less, Flash Fill is data assistant that finishes your work, chart recommendations, slicers to filter table data, and several new functions in the math and trigonometry, statistical, engineering, date and time, lookup and reference, logical, and text function categories. Microsoft Office 2013 is a version of Microsoft Office, a productivity suite for Microsoft Windows. Our MOS Excel 2013 training course provides students with the knowledge and skills that are needed to use the advanced software features, and integrate the Office programs with other software. When you pass the Excel 2013 Exam 77-420, you achieve Microsoft Certified Application Specialist (MOS) status in Excel 2013. The Microsoft Certified Application Specialist Certification, (MOS) recognizes business professionals who have demonstrated expertise in Microsoft Office 2013.

Table of Contents

  1. Microsoft Excel 2013 - Course Introduction 00:01:12
  2. Module 1
    1. Section 1-1 - Create Worksheets and Workbooks 00:00:24
    2. Creating New Blank Workbooks 00:05:43
    3. Creating New Workbooks Using Templates 00:05:59
    4. Importing Files 00:05:09
    5. Opening Non-Native Files Directly in Excel 00:03:06
    6. Adding Worksheets to Existing Workbooks 00:02:00
    7. Copying and Moving Worksheets 00:03:37
    8. Section 1-2 - Navigate Through Worksheets and Workbooks 00:00:19
    9. Searching for Data Within a Workbook 00:03:41
    10. Using Go To and Name Box 00:03:50
    11. Changing Worksheet Order 00:02:17
    12. Inserting Hyperlinks 00:06:03
    13. Section 1-3 - Format Worksheets and Workbooks 00:00:28
    14. Changing Worksheet Tab Color 00:03:21
    15. Modifying Page Setup and Inserting Watermarks 00:11:26
    16. Inserting and Deleting Columns and Rows 00:03:12
    17. Changing Workbook Themes 00:04:08
    18. Adjusting Row Height and Column Width Part1 00:02:02
    19. Adjusting Row Height and Column Width Part2 00:02:09
    20. Inserting Headers and Footers 00:03:58
    21. Setting Data Validation 00:04:26
    22. Section 1-4 - Customize Options and Views for Worksheets and Workbooks 00:00:40
    23. Hiding Columns - Rows - Worksheets 00:03:19
    24. Customizing the Quick Access Toolbar and the Ribbon 00:08:52
    25. Managing Macro Security 00:05:27
    26. Changing Workbook Views 00:03:29
    27. Recording Simple Macros 00:06:03
    28. Adding Values to Workbook Properties 00:03:15
    29. Using Zoom 00:03:13
    30. Displaying Formulas 00:02:18
    31. Freezing Panes 00:05:22
    32. Splitting the Window 00:02:49
    33. Section 1-5 - Configure Worksheets and Workbooks to Print or Save 00:00:32
    34. Setting a Print Area 00:02:42
    35. Saving Workbooks in Alternate File Formats 00:04:25
    36. Printing Individual Worksheets and Scaling 00:05:46
    37. Repeating Headers and Footers 00:03:46
    38. Maintaining Backward Compatibility 00:03:49
    39. Configuring Workbooks to Print 00:01:51
    40. Saving Files to Remote Locations 00:04:46
  3. Module 2
    1. Section 2-1 - Insert Data in Cells and Ranges 00:00:21
    2. Appending Data to Worksheets 00:03:04
    3. Finding and Replacing Data 00:04:53
    4. Copying and Pasting Data 00:08:27
    5. Using AutoFill Tool 00:08:39
    6. Inserting and Deleting Cells 00:08:15
    7. Section 2-2 - Format Cells and Ranges 00:00:27
    8. Merging Cells 00:06:01
    9. Modifying Cell Alignment and Indentation plus Changing Font and Font Styles Part1 00:07:48
    10. Modifying Cell Alignment and Indentation plus Changing Font and Font Styles Part2 00:02:34
    11. Using Format Painter 00:04:19
    12. Wrapping Text Within Cells 00:04:31
    13. Applying Number Formatting 00:04:37
    14. Applying Highlighting and Cell Styles 00:06:20
    15. Changing Text to WordArt 00:05:19
    16. Section 2-3 - Order and Group Cells and Ranges 00:00:21
    17. Applying Conditional Formatting 00:10:34
    18. Transposing Columns and Rows 00:03:07
    19. Inserting Sparklines 00:04:32
    20. Creating Named Ranges 00:04:03
    21. Creating Outline - Collapsing Groups of Data in Outlines and Inserting Subtotals 00:08:14
  4. Module 3
    1. Section 3-1 - Create a Table 00:00:14
    2. Creating a Table and Moving Between Tables and Ranges 00:04:58
    3. Adding and Removing Cells Within Tables 00:04:40
    4. Defining Titles 00:03:21
    5. Section 3-2 - Modify a Table 00:00:13
    6. Applying Styles to Tables 00:03:10
    7. Banding Rows and Columns 00:03:08
    8. Inserting Total Rows 00:04:00
    9. Removing Styles From Tables 00:02:15
    10. Section 3-3 - Filter and Sort a Table 00:00:14
    11. Filtering Records 00:04:23
    12. Changing Sort Order 00:03:14
    13. Sorting Data on Multiple Columns 00:03:39
    14. Removing Duplicates 00:03:46
  5. Module 4
    1. Section 4-1 - Utilize Cell Ranges and References in Formulas and Functions 00:00:24
    2. Utilizing References - Relative - Mixed - Absolute 00:08:44
    3. Defining Order of Operations 00:06:51
    4. Referencing Cell Ranges in Formulas 00:05:23
    5. Section 4-2 - Summarize Data with Functions 00:00:18
    6. Utilizing the SUM Function 00:03:06
    7. Utilizing the MIN and MAX Functions 00:03:41
    8. Utilizing the COUNT Function 00:02:43
    9. Utilizing the AVERAGE Function 00:02:48
    10. Section 4-3 - Utilize Conditional Logic in Functions 00:00:15
    11. Utilizing the SUMIF Function 00:03:31
    12. Utilizing the AVERAGEIF Function 00:03:10
    13. Utilizing the COUNTIF Function 00:02:20
    14. Section 4-4 - Format and Modify Text with Functions 00:00:20
    15. Utilizing the RIGHT - LEFT and MID Functions 00:05:32
    16. Utilizing the TRIM Function 00:02:48
    17. Utilizing the UPPER and LOWER Functions 00:02:26
    18. Utilizing the CONCATENATE Function 00:03:15
  6. Module 5
    1. Section 5-1 - Create a Chart 00:00:18
    2. Creating Charts and Graphs 00:04:11
    3. Adding Additional Data Series 00:03:04
    4. Switching Between Rows and Columns in Source Data 00:03:31
    5. Using Quick Analysis 00:02:37
    6. Section 5-2 - Format a Chart 00:00:19
    7. Adding Legends 00:02:58
    8. Resizing Charts and Graphs 00:03:42
    9. Modifying Chart and Graph Parameters 00:01:59
    10. Applying Chart Layouts and Styles 00:04:42
    11. Positioning Charts and Graphs 00:03:18
    12. Section 5-3 - Insert and Format an Object 00:00:28
    13. Inserting Text Boxes 00:03:53
    14. Inserting SmartArt 00:03:48
    15. Inserting Images 00:04:56
    16. Adding Borders to Objects 00:04:53
    17. Adding Styles and Effects to Objects 00:07:58
    18. Changing Object Colors 00:04:14
    19. Modifying Object Properties and Positioning Objects 00:05:44
    20. Course Close 00:00:30