» » Lynda - Excel 2013 Bundle Training Videos

Information of news
  • Author: xiucoi
  • Date: 8-01-2014, 09:22
8-01-2014, 09:22

Lynda - Excel 2013 Bundle Training Videos

Category: Tutorials

Lynda - Excel 2013 Bundle Training Videos

Excel 2013 Bundle Training Videos

English | mp4 | Video: AVC 960x540 15fps | Audio: AAC 48KHz 2ch | 4.7 GB

Genre : eLearning

Excel 2013 Essential Training

with Dennis Taylor

Whether you're a novice or an expert wanting to refresh your skillset with Microsoft Excel, this course covers all the basics you need to start entering your data and building organized workbooks. Author Dennis Taylor teaches you how to enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data, and build charts and PivotTables. Other lessons cover the powerful IF, VLOOKUP, and COUNTIF family of functions; the Goal Seek, Solver, and other data analysis tools; and how to automate many of these tasks with macros.

Topics include:

What is Excel and what is it used for?

Using the menus

Working with dates and times

Creating simple formulas

Formatting fonts, row and column sizes, borders, and more

Inserting shapes, arrows, and other graphics

Adding and deleting rows and columns

Hiding data

Moving, copying, and pasting

Sorting and filtering data

Printing your worksheet

Securing your workbooks

Tracking changes

Excel 2013: Pivot Tables in Depth

with Curt Frye

Join Curt Frye as he explains how to leverage PivotTables to summarize, sort, count, and chart your data in Microsoft Excel. Curt shows you how to navigate the complexity of PivotTables while taking advantage of their power. This course shows how to build PivotTables from single or multiple data sources, add calculated fields, filter your results, and format your layout to make it more readable. Plus, learn how to enhance PivotTable with macros, DAX expressions, and the PowerPivot add-in for analyzing millions of rows of data.

Topics include:

Creating a PivotTable

Summarizing multiple data fields

Managing subtotals and grand totals

Grouping PivotTable fields

Filtering with selections, rules, slicers, and search filters

Applying PivotTable styles

Formatting cells

Creating PivotCharts

Enabling PowerPivot

Using DAX operators

Visualizing data with matrices, cards, and tiles

Building charts and maps

Excel 2013: Advanced Formulas and Functions

with Dennis Taylor

Conquer some of the most daunting features in Microsoft Excel once and for all. In this 2013 update to his popular series, author Dennis Taylor demystifies some of the most challenging of the 300+ formulas and functions in Excel and shows how to put them to their best use. The course starts with a review of the more basic, building-block functions, and a few critical keyboard shortcuts that will speed up working with Excel data, even on multiple sheets. Dennis then covers how to perform advanced searching and data retrieval with Lookup functions, tabulate and sort data with counting and statistical functions, format data with text and math functions, and work with financial data using advanced formulas. Dennis focuses on practical examples that transition effortlessly to real-world scenarios.

Topics include:

Displaying and highlighting formulas

Converting formulas to values

Creating 3D formulas to gather data from multiple sheets

Understanding the hierarchy of operations in formulas

Using absolute and relative references

Creating and expanding the use of nested IF statements

Looking up information with VLOOKUP, MATCH, and INDEX

Using the power functions: COUNTIF, SUMIF, and AVERAGEIF

Analyzing data with the statistical functions

Performing basic math

Calculating dates and times

Editing text with functions

Checking for errors with formulas

Excel 2013: Charts in Depth

with Dennis Taylor

Charts allow you to communicate information visually, in a way that's more impactful than raw data, and they happen to be one of the most powerful and easy-to-use features in Microsoft Excel. Let Dennis Taylor show you how to create different kinds of Excel charts, from column, bar, and line charts to exploded pies, and decide which type works best for your data. Plus, learn how to fine-tune your chart's color and style; add titles, labels, and legends; insert shapes, pictures, and text boxes; and pull data from multiple sources.

Topics include:

Selecting the right chart type

Choosing data to display as a chart

Creating charts fast with the Quick Analysis tool

Choosing a chart layout

Changing the location of the source data

Dealing with empty and hidden cells

Moving and resizing charts

Adding data labels

Analyzing existing and future data with trendlines

Adding shapes and arrows

Working with column, bar, line, pie, and area charts

Working with specialized chart types: Gantt, Pareto, and Frequency charts

Creating dynamic charts

Printing and sharing your chart

Excel 2013 Power Shortcuts

with Curt Frye

Discover over 65 tips, tricks, and shortcuts in Microsoft Excel. In this course, Curt Frye reveals how to invoke commands, manage and organize data, and build formulas in Excel. Curt shares his power shortcuts for saving time on basic tasks, from entering data and selecting cell ranges to summarizing data with charts and tables and quickly finding information.

Topics include:

Entering a data series using the fill handle

Creating hyperlinks

Setting a print area

Applying a table style

Creating substitute data sets using scenarios

Wrapping and shrinking text

Creating a data entry form

Removing duplicate values

Inserting the current date or time

Generating a list of unique random numbers

Calculating running totals

Analyzing a formula for errors

Summarizing data with charts and PivotTables


Lynda - Excel 2013 Bundle Training Videos

Use 7zip for unrar if you get "Max 260 character" error






Site BBcode/HTML Code:
Dear visitor, you went to the site as unregistered user.
We recommend you Sign up or Login to website under your name.
Would you like to leave your comment? Please Login to your account to leave comments. Don't have an account? You can create a free account now.