Watch Excel 2016 For Dummies Video Training

Name: Excel 2016 For Dummies Video Training
Genre: How To
Released: 2015-12-31

2015
1 Season

Excel 2016 For Dummies Video Training from Wiley is a comprehensive online course that teaches users of all levels how to use Microsoft Excel. This course is designed for anyone who wants to achieve proficiency in this powerful spreadsheet software. The course is divided into 6 sections consisting of 5 to 6 short modules each. Each module is only a few minutes long, making it easy to learn at your own pace without getting overwhelmed. The sections are:

1. Introduction: This section covers the basics of Excel, including navigating the software, entering data, and customizing the interface.

2. Working with Formulas: This section covers how to create basic and complex formulas, functions, and calculations. You will learn how to work with operators, nested functions, and array formulas.

3. Formatting and Editing: This section covers how to format your data, including font styles, colors, borders, and shading. You will also learn how to edit data and use the find and replace function.

4. Charts and Graphs: This section covers how to create and format charts and graphs. You will learn how to select the right chart type for your data, edit and customize elements like labels and axis scales, and create trendlines.

5. Advanced Features: This section covers advanced Excel features such as pivot tables, macros, and conditional formatting. You will learn how to use filters, group and summarize data, create and run macros, and set up conditional formatting rules.

6. Conclusion: This final section includes a summary of the course material and tips for using Excel efficiently.

Throughout the course, you will learn how to use Excel to organize, analyze, and visualize data. You will learn how to create custom spreadsheets and workbooks, use formulas and functions to manipulate data, and create charts and graphs to summarize information. You will also learn how to use advanced features like pivot tables and macros to automate tasks and improve productivity.

Excel 2016 For Dummies Video Training from Wiley is perfect for beginners and intermediate Excel users who want to learn how to use this software efficiently. The course is easy to follow and includes hands-on exercises to help you reinforce what you've learned. The instructors are experienced Excel users who provide clear explanations and useful tips throughout the course.

Whether you want to use Excel for personal or professional purposes, this course will teach you everything you need to know to create professional-looking spreadsheets and harness the full power of this software. By mastering Excel, you will improve your productivity, impress your colleagues, and achieve your goals more efficiently.

Filter by Source

No sources available

Do you have Apple TV?

What are you waiting for?

Nice! Browse Apple TV with Yidio.

Ad Info

Seasons

11. Overcoming Obstacles in Excel

January 1, 2016

Getting stuck in Excel 2016? Before you chuck your computer out the window, take a look at some simple solutions to the most common issues users face while using the program.

10. Customizing Excel

January 1, 2016

Don't like the way the contextual ribbons are laid out or the default fonts in Excel 2016? Well Ronnie and Peter will show you how you can customize those and other features to tailor your experience to your liking.

9. Automate Tasks with Macros

January 1, 2016

Making changes to a sheet is one thing, but updating several at once can be time consuming. In this episode, Ronnie and Peter show you how macros can easily automate repetitive tasks to save you time and frustration.

8. Adding Charts

January 1, 2016

Suffering from data overload? Charts are a great way to showcase your information while providing visual interest. Ronnie and Peter review the different types of charts and go through the steps to set them up in Excel 2016.

7. Organize a Workbook

January 1, 2016

It's important to understand the difference between a workbook and worksheets in Excel 2016, as well as how they can interact with one another. In this episode, Ronnie and Peter detail how to create and organize different worksheets while providing tips for sharing data across them.

6. Print Excel Data

January 1, 2016

Printing a worksheet in Excel 2016 is not as simple as printing a document. In this episode, Ronnie and Peter not only show you the available print options, but offer tips for formatting your content so it prints in an easy-to-understand format.

5. Format in Excel

January 1, 2016

With the ability to hold seemingly endless amounts of data across thousands of rows and columns, working within Excel 2016 can be intimidating. Ronnie and Peter use this episode to break down the available formatting tools within Excel that allow you to style and organize your data.

4. Create a Basic Formula

January 1, 2016

The real power within Microsoft Excel 2016 lies in formulas, which allow you to perform complex calculations instantaneously. Ronnie and Peter show you the different ways to create formulas, as well as how to use the formulas built in to Excel.

3. Create a Spreadsheet

January 1, 2016

Not all data in Excel 2016 is created equally. Excel treats numbers like dates, currencies, and formulas different ways. In this episode, Ronnie and Peter show not only how to input information in to a spreadsheet, but how to tell excel what type of data it is.

2. Discover the Interface

January 1, 2016

Before you can really get started with Microsoft Excel 2016, you need to get a lay of the land. In this episode, Ronnie and Peter review the interface of Excel 2016 including the ribbon, contextual menus, and navigating within a worksheet.

1. Overview

December 31, 2015

In this episode, Host Peter VanRysdam and Excel guru Ronnie Wong will introduce you to Microsoft Excel 2016 and let you know what you can expect to learn from this series.

Description