– Excel 2010 Tutorial Collection (4 courses)

Size: 2.42 GB

There are 4 courses inside:

Excel 2010: Advanced Formatting Techniques, Excel 2010 Essential Training, Excel 2010: Pivot Tables in Depth and Excel 2010: Charts in Depth.

Excel 2010: Advanced Formatting Techniques Description:

In Excel 2010: Advanced Formatting Techniques, author Dennis Taylor shares simple and powerful tips for making spreadsheet information readable and understandable, from emphasizing specific cells to adding style and readability to worksheets. It also covers automation techniques that take the drudgery out of formatting even the largest amounts of data. Exercise files accompany this course.

Topics include:
Saving time with keyboard shortcuts
Adjusting fonts, cell borders, and fills
Setting themes
Formatting numeric data with cell formats
Using conditional formatting
Hiding repeating column information
Printing double-spaced data
Elbow formatting

Excel 2010 Essential Training Description:

In Excel 2010 Essential Training, Bob Flisser demonstrates the core features and tools in Excel 2010. The course introduces key Excel skills, shows how to utilize these skills with in-depth tutorials on Excel functions and spreadsheet formatting. It also covers prepping documents for printing, working with large worksheets and workbooks, collaborating with others, using Excel as a database, analyzing data, charting, and automating and customizing Excel. Exercise files are included with the course.
Topics include:
Copying and pasting techniques
Working with formulas and functions
Dealing with formula errors
Creating lookup tables
Naming cell ranges
Formatting data and worksheets
Finding and replacing data
Creating SmartArt diagrams
Creating charts and PivotTables
Recording macros
Sharing workbooks

Excel 2010: Pivot Tables in Depth Description:

In Excel 2010: Pivot Tables in Depth, author Curt Frye provides comprehensive, hands-on tutorials on Excel PivotTables, including more advanced techniques such as using macros and the new PowerPivot add-in. The course shows how to connect and consolidate data sources to power PivotTables, sort and filter records, display data in a PivotChart, print tables and charts, and also introduces the DAX language for performing advanced summaries in PowerPivot. Exercise files are included with the course.
Topics include:
Formatting data for use in a PivotTable
Connecting to an external data source
Refreshing a data source
Adding, removing, and positioning subtotals and grand totals
Creating a calculated field
Grouping PivotTable fields
Clearing and reapplying PivotTable filters
Applying field styles
Formatting cells
Creating a PivotChart
Printing PivotTables and PivotCharts
Creating relationships between tables in a PowerPivot model
Using the DAX language for advanced summaries in PowerPivot

Excel 2010: Charts in Depth Description:

In this course, Dennis Taylor shows how to analyze and communicate the value of data with charts in Excel. The course starts with the foundations: what the parts of a chart are, what the different types of charts are, and which charts work best for your data. The course then shows how to create a presentation-ready chart in minutes and offers dozens of in-depth tutorials on formatting and fine-tuning charts so they represent data clearly and accurately.
Topics include:
Identifying the plot area, chart area, gridlines, legends, and more
Selecting the right chart type
Creating charts instantly with shortcuts
Choosing a layout
Dealing with empty and hidden cells
Switching rows and columns for a different view of the data
Moving and resizing a chart
Inserting pictures and shapes
Adding labels to a chart
Analyzing existing and future data with trendlines
Changing a chart’s data source
Printing charts

Purchase premium accounts in order to enjoy unlimited downloads with resuming support
***If link dead, please leave a message, we will update immediately***

Leave a Reply