Watch Excel 2013 Essentials

Name: Excel 2013 Essentials
Genre: How To
Released: 2014-01-14

TV-NR
2014
1 Season

Excel 2013 Essentials is an online course offered by John Wiley & Sons, Inc. that teaches individuals how to use Microsoft Excel 2013 to create, manipulate and analyze data. The course is aimed at beginners and intermediate Excel users who want to explore the advanced features of the software and improve their data handling skills.

The course is divided into eight sections covering everything from basic navigation to advanced data analysis techniques. Each section consists of several video tutorials that guide students through the different components of Excel 2013. The course also includes practice exercises and quizzes to test the students' knowledge at the end of each section.

The first section of the course focuses on basic navigation and formatting. Students learn how to navigate Excel's interface, create and save workbooks, and apply basic formatting to their worksheets. This section also covers how to use Excel's AutoFill feature to quickly populate cells with data.

The second section covers working with data and formulas. Students learn how to enter, edit and delete data in Excel, as well as how to create basic formulas and functions to perform calculations. This section also introduces Excel's powerful cell referencing system, which allows users to easily reference data from different parts of their workbook.

The third section of the course covers working with tables and charts. Students learn how to create and format tables, as well as how to insert and modify charts to visually represent their data. This section also covers how to use Excel's conditional formatting feature to highlight data based on specific criteria.

The fourth section covers working with large datasets. Students learn how to use Excel's sorting and filtering features to quickly analyze large amounts of data. This section also covers how to use Excel's pivot tables and pivot charts to create powerful, interactive reports.

The fifth section covers working with formulas and functions. Students learn how to use Excel's built-in functions to perform common calculations such as SUM, AVERAGE and MAX, as well as how to create their own custom functions using Excel's Visual Basic for Applications (VBA) language.

The sixth section covers working with advanced functions and formulas. Students learn how to use Excel's array formulas to perform complex calculations, as well as how to work with Excel's lookup and reference functions to find and retrieve specific data from their workbooks.

The seventh section covers working with data analysis tools. Students learn how to use Excel's goal seek, solver and data tables to perform advanced data analysis tasks. This section also covers how to use Excel's scenario manager to create different scenarios and compare the results.

The final section of the course covers working with macros and VBA. Students learn how to use Excel's macro recorder to automate repetitive tasks, as well as how to write their own VBA code to create custom macros and functions.

Overall, Excel 2013 Essentials is a comprehensive course that covers all the essential features of Microsoft Excel 2013. The course is designed for individuals who want to improve their data handling skills and use Excel to create powerful reports and analyses. Whether you are a beginner or an intermediate Excel user, Excel 2013 Essentials is a great way to develop your skills and increase your productivity.

Filter by Source

No sources available

Seasons

18. Creating a Hyperlink, Emailing a Workbook, Signing in to Office Online, Working with SkyDrive, and Downloading Apps

January 15, 2014

Learn how to create a hyperlink in one workbook that opens another workbook, email a workbook, sign in and out of Office Online, open and save a workbook in SkyDrive space, and use Excel to share a workbook. Discover how to open and edit a workbook using the Excel 2013 Web App, and download an add-on app from the Office Store..

17. Customizing the Status Bar, Hiding, Displaying and Customizing Ribbon Buttons, Customizing the Quick Access Toolbar, and Working with Macros

January 15, 2014

Learn how to add information to Excel's status bar and work with Ribbon buttons. Discover how to change the location of the Quick Access Toolbar, add buttons to it, and reposition the buttons, and how to create and run a macro and how to save a macro-enabled workbook.

16. Marking a Workbook as Final, Assigning a Password, Encrypting and Protecting, Working with Comments, and Change Tracking

January 15, 2014

Learn how to mark a workbook as final, require a password to open and modify a workbook, encrypt a workbook, and protect both a workbook and a worksheet. Discover how to add, view, edit, delete, and print comments. Examine how to use Excel's change tracking feature to review changes others might make to a worksheet.

15. Linking Workbooks, Consolidating Data, Creating, Switching, Merging and Reporting on Scenarios, Examining What-If Examples

January 15, 2014

Learn to link worksheets, consolidate information across workbooks and worksheets, create and switch between scenarios, merge scenarios from different worksheets into one worksheet, and create a Scenario report and PivotTable. Discover how to create one-variable and two-variable data tables and how to use the Goal Seek feature to solve for an unknown value.

14. Working with PivotTables

January 15, 2014

Learn how to create and format a PivotTable using both numeric and non-numeric data and adjust the table to view your data from various perspectives. Learn to summarize data in unusual ways and to update a PivotTable to reflect changes to the source data, and how to create a PivotChart using PivotTable data.

13. Working with Chart Elements, Shape Style Attributes, and Sparkline Charts

January 15, 2014

Learn how to add, format, and hide various chart elements, including the chart title, axis titles, data labels, horizontal and vertical gridlines, and a data table, how to reposition the chart legend and explode the slices of a pie chart. Discover how to work with shape style attributes to format individual chart elements, and how to create and modify sparkline charts.

12. Working with Graphic Elements, Creating, Moving and Making Changes to a Chart

January 15, 2014

Learn how to add, move, and resize a graphic element, how to capture a screenshot, create and work with charts, swap the rows and columns in a column or bar chart, select a chart layout, and change the chart style, type, and the data included in the chart.

11. Using Text Functions, Working with Database Functions, and Analyzing Formulas and Functions

January 15, 2014

Learn how to use common text functions, how to sum, count, and average records in a database, find the record that contains the smallest and largest value based on specified criteria, and discover common errors and methods you can use to find and correct them.

10. Summing, Subtotaling, Calculating, and Rounding, Working with Frequency Functions, Dates, and Financial Functions

January 15, 2014

Learn how to use functions such as sum, subtotal, and conditional sum, activate the Analysis ToolPak, create a frequency distribution and histogram, and insert the current date in a worksheet. Discover how to use financial functions to calculate the value of an investment and loan payment amount.

9. Using Cell and Range Names, Analyzing Data using Conditional Formatting, and Working with Tables

January 15, 2014

Discover how to establish names for ranges, select cells in a named range, edit and delete range names and use range names instead of cell references in formulas, highlight items in a list, and use data bars, color scales, and icon sets. Learn how to create a table, change its size, create a list of valid values to use in table columns, sort and filter, and add a total row to a table.

Filling a Range, Creating and Copying Formulas, Working with Cell References, Changing a Formula to a Value, Adding Data Across Ranges and Worksheets

8. Filling a Range, Creating and Copying Formulas, Working with Cell References, Changing a Formula to a Value, Adding Data Across Ranges and Worksheets

January 15, 2014

Learn how to fill a range with information, and create, edit and copy formulas. Explore the difference between absolute and relative cell references. Learn how to convert a formula to the result it calculates, how to add ranges and how to add across worksheets.

Setting Margins, Page Orientation, Paper Size and Scaling, Adding Headers and Footers, Printing, Filling a Range with Information, and Creating Formulas

7. Setting Margins, Page Orientation, Paper Size and Scaling, Adding Headers and Footers, Printing, Filling a Range with Information, and Creating Formulas

January 15, 2014

Learn how to set margins, page orientation, paper size and scaling, add headers and footers, print only selected cells, and control pagination. Explore options for printing in Excel, how to fill a range with numbers, dates, and text that follows a pattern, add, subtract, multiply and divide numbers using constants and cell references, edit formulas, and calculate common values.

Working with Styles and Themes, Finding and Replacing Text, Spellcheck and Thesaurus, Switching Views and Zooming, Hiding or Displaying Data, Freezing Column and Row Titles

6. Working with Styles and Themes, Finding and Replacing Text, Spellcheck and Thesaurus, Switching Views and Zooming, Hiding or Displaying Data, Freezing Column and Row Titles

January 15, 2014

Discover how to use and create a style, apply a theme, find and substitute text, check spelling, use the Thesaurus, and translate common words. Explore Normal, Page Layout, and Page Break views as well as zooming in and out. Learn how to hide screen elements and freeze the first row, column and a combination of the first row and column so that they are always visible on-screen.

5. Rows and Columns: Adding, Deleting, Hiding, Unhiding, Swapping, Adjusting Height and Width and Working with Worksheets

January 15, 2014

Rows and Columns: Adding, Deleting, Hiding, Unhiding, Swapping, Adjusting Height and Width and Working with Worksheets

4. Understanding and Assigning Number Formatting, Using Cell Colors and Borders, Indenting and Aligning Text, Copying and Clearing Formatting

January 15, 2014

Discover how to assign numeric formats to cells containing values, use color and border lines around cells, indent text within a cell, align cell content horizontally, vertically, and across several columns and rows. Learn how to use the Format Painter to copy all formatting from one cell to another and how to clear all formatting from a cell without deleting the cell content.

3. Selecting Cells, Moving or Copying Information, Changing Fonts, Font Size and Applying Effects, Fitting Text within Cells

January 15, 2014

Examine techniques to select cells. Learn how to move or copy information from one set of cells to another, select different fonts and font sizes for cells in a workbook, set a new default font and font size for all new workbooks you subsequently create, and fit text within cells by wrapping, shrinking or rotating it.

2. Starting, Saving, Reopening, and Closing a Workbook, Switching Workbooks, Importing a Text File

January 15, 2014

Learn to use the Save As dialog box, save workbooks to a format other than the default format, open a previously saved workbook, start a new blank workbook or a workbook based on a template, open multiple workbooks and switch between them, close a workbook, import text files, and use Flash Fill formatting.

1. 1. Opening Excel 2013, Excel Terminology, Working with Backstage View, Entering Information, Moving Around, and Selecting Command

January 14, 2014

Learn how to open Excel 2013 in Windows 8. Examine the Back Stage view, how Excel behaves when you enter information, how to undo mistakes and redo actions. Identify efficient ways to use the keyboard to move around a workbook, and learn how to select commands in Excel using both the keyboard and the mouse.

Description