Lynda com Excel 2010 Tutorial Collection courses | 38ED72B5BD564DA57110C50D0733DC31991408D3

Lynda com Excel 2010 Tutorial Collection courses

Name	Lynda.com - Excel 2010 Tutorial Collection (4 courses)	DOWNLOAD Copy Link
Total Size	2.6 GB
Total Files	435
Hash	38ED72B5BD564DA57110C50D0733DC31991408D3

/Exercise Files/Ch09/
WholesaleData.xlsx	46.8 MB
Relationship.xlsx	16.3 MB
Import.xlsx	16.2 MB
Manage.xlsx	16.2 MB
AddTable.xlsx	16.2 MB
MonthTable.accdb	376.8 KB
/.../10 - Adjusting Specific Chart Types/
10-1 Using column and bar charts.mp4	35.7 MB
10-4 Using area, stock, and XY charts.mp4	35.7 MB
10-5 Using doughnut, bubble, and radar charts.mp4	32.2 MB
10-3 Using pie charts.mp4	19.9 MB
10-2 Using line charts.mp4	19.8 MB
/Exercise Files/Ch10/
Filtered.xlsx	30.7 MB
Measures.xlsx	30.1 MB
Aggregate.xlsx	30.1 MB
DAX Intro.xlsx	30.1 MB
DAX Functions.xlsx	30.1 MB
DAX Operators.xlsx	30.1 MB
/.../6 - Layout Tab Options Using Axes and Gridlines/
6-1 Modifying axis scaling.mp4	27.7 MB
6-2 Working with gridlines.mp4	14.9 MB
/.../7 - Tables, Themes, Styles and Other Visualization Tools/
7-1 Converting data into a table and reformatting it.mov	26.7 MB
7-2 Using styles and themes for consistent formatting.mov	17.8 MB
7-4 Fine-tuning shape effects.mov	13.8 MB
7-6 Formatting Sparklines for optimum impact.mov	13.7 MB
7-3 Understanding the options in shape formatting.mov	9.6 MB
7-5 Learning the WordArt essentials for titles and headings.mov	5.9 MB
/.../1 - Understanding Excel Chart Concepts/
1-2 Selecting the right chart type.mp4	26.7 MB
1-1 Identifying chart elements like plot area, chart area, gridlines, and legends.mp4	22.3 MB
1-3 Understanding chart terminology.mp4	20.2 MB
1-4 Understanding the Ribbon and the Design, Layout, and Format tabs.mp4	11.8 MB
/.../7 - Layout Tab Options Using the Analysis Tools/
7-1 Analyzing existing and future data with trendlines.mp4	23.4 MB
7-4 Adding error bars.mp4	15.9 MB
7-3 Adding high-low lines and up-down bars.mp4	6.1 MB
7-2 Adding drop lines.mp4	4.7 MB
/.../12 - Printing and Sharing Charts/
12-1 Printing charts.mp4	21.3 MB
12-2 Copying and linking charts with Word and PowerPoint.mp4	15.5 MB
/.../3 - Fine-Tuning Charts with Design Tab Choices/
3-3 Dealing with empty and hidden cells.mp4	20.9 MB
3-7 Moving and resizing a chart.mp4	14.9 MB
3-4 Choosing a chart layout.mp4	12.5 MB
3-2 Setting a default chart type and creating a template.mp4	12.2 MB
3-1 Switching rows and columns for a different view of the data.mp4	11.0 MB
3-5 Choosing a chart style from 48 colorful variations.mp4	10.7 MB
3-6 Changing the location of a chart.mp4	7.2 MB
/.../2 - Creating Basic Charts Quickly/
2-5 Creating graphic-in-cell charts with sparklines.mp4	20.7 MB
2-1 Selecting data to display as a chart.mp4	14.0 MB
2-2 Creating charts instantly with shortcuts.mp4	7.4 MB
2-4 Creating presentation-ready charts with just a few adjustments.mp4	7.3 MB
2-3 Creating charts with standard menu commands.mp4	4.1 MB
/.../5 - Layout Tab Options Adding Titles, Labels, and Legends/
5-8 Adding and editing data labels.mp4	19.9 MB
5-4 Showing numbers of different scales.mp4	13.9 MB
5-5 Specifying the position of tick marks and axis labels.mp4	13.6 MB
5-6 Changing the numeric format on labels.mp4	12.7 MB
5-2 Adding horizontal and vertical titles.mp4	10.9 MB
5-1 Adding, editing, and removing chart titles.mp4	8.7 MB
5-7 Adding, editing, and removing legends.mp4	7.8 MB
5-9 Showing the source of a chart's data.mp4	7.1 MB
5-3 Linking titles to content.mp4	6.0 MB
/.../8 - Format Tab Options Adding Shapes and WordArt Styles/
8-2 Adding shape effects.mp4	19.8 MB
8-1 Selecting shape fill and outline.mp4	17.1 MB
8-3 Applying WordArt styles.mp4	7.4 MB
/.../1 - Adjusting Numeric Formats Quickly/
1-1 Working with the numeric formatting options.mov	17.0 MB
1-3 Setting special formats for dates, times, phone numbers, fractions, etc.mov	15.9 MB
1-4 Building custom numeric formats.mov	15.0 MB
1-2 Learning the important formatting keystroke shortcuts.mov	14.2 MB
1-5 Building custom date formats.mov	13.5 MB
/.../8 - Manipulating PivotTables Using Macros/
8-2 Running a macro.mp4	15.8 MB
8-1 Recording and reviewing a macro.mp4	11.6 MB
8-3 Creating a simple PivotTable presentation kit.mp4	8.9 MB
/.../13 - Creating and Using Macros/
13-2 Recording and using a simple macro.mov	14.8 MB
13-3 Editing a macro.mov	7.6 MB
13-1 Understanding macros.mov	2.9 MB
/4 - Formatting PivotTables/
4-1 Applying a PivotTable style.mp4	14.7 MB
4-2 Creating a PivotTable style.mp4	14.4 MB
4-3 Changing the PivotTable layout.mp4	8.9 MB
4-4 Changing the data field number format.mp4	5.3 MB
/.../4 - Layout Tab Options Inserting Pictures, Shapes, and Text Boxes/
4-1 Using pictures as chart elements.mp4	14.5 MB
4-2 Adding shapes and arrows.mp4	10.7 MB
4-3 Adding floating text and text boxes.mp4	10.4 MB
/.../14 - Customizing Excel/
14-2 Customizing the Ribbon bar.mov	13.8 MB
14-3 Setting Excel options.mov	10.2 MB
14-1 Customizing the Quick Access toolbar.mov	4.5 MB
/.../3 - Sorting and Filtering PivotTable Data/
3-8 Filtering a PivotTable with report filter fields.mp4	13.0 MB
3-6 Filtering a PivotTable using slicers.mp4	10.7 MB
3-7 Formatting slicers.mp4	10.1 MB
3-2 Creating a custom sort order.mp4	9.8 MB
3-3 Filtering a PivotTable field by selection.mp4	8.8 MB
3-5 Filtering a PivotTable using a search filter.mp4	8.3 MB
3-4 Filtering a PivotTable by rule.mp4	7.6 MB
3-1 Sorting PivotTable data.mp4	5.4 MB
3-9 Clearing and reapplying PivotTable filters.mp4	3.7 MB
/.../2 - Summarizing PivotTable Data/
2-2 Changing the PivotTable data field summary operation.mp4	12.9 MB
2-6 Using PivotTable data in a formula.mp4	12.6 MB
2-1 Adding, removing, and positioning subtotals and grand totals.mp4	9.3 MB
2-3 Summarizing more than one data field.mp4	9.1 MB
2-5 Grouping PivotTable fields.mp4	8.0 MB
2-4 Creating a calculated field.mp4	7.0 MB
2-7 Drilling down to the underlying data.mp4	4.4 MB
/.../10 - Working with DAX Expressions/
10-6 Using filters in aggregate functions.mp4	12.7 MB
10-5 Using aggregate functions.mp4	11.6 MB
10-4 Adding calculated columns and measures.mp4	11.3 MB
10-2 Using DAX operators.mp4	10.9 MB
10-3 Surveying DAX functions.mp4	9.5 MB
10-1 Introducing the DAX language.mp4	8.7 MB
/.../8 - Collaborating with Others/
8-6 Saving files in shared locations.mov	12.7 MB
8-1 Importing and exporting data in Excel.mov	10.6 MB
8-3 Inserting and editing comments.mov	8.9 MB
8-2 Setting workbook permissions.mov	7.7 MB
8-5 Tracking changes.mov	3.8 MB
8-4 Sharing a workbook.mov	1.8 MB
/.../9 - Getting Started with PowerPivot/
9-6 Creating relationships between tables.mp4	12.6 MB
9-4 Managing table columns.mp4	12.4 MB
9-3 Importing PowerPivot data.mp4	8.0 MB
9-2 Downloading and installing PowerPivot.mp4	7.9 MB
9-5 Adding tables to a PowerPivot mode.mp4	7.1 MB
9-1 Introducing PowerPivot.mp4	6.5 MB
/.../2 - Controlling Fonts, Borders, and Cell Colors/
2-4 Applying border styles and adjusting gridlines.mov	12.5 MB
2-1 Applying and adjusting fonts and font colors.mov	8.0 MB
2-3 Applying underline, strikethrough, subscript, and superscript formatting .mov	6.3 MB
2-5 Using fill color and patterns for cell backgrounds.mov	6.0 MB
2-2 Adding custom formats with font color variations.mov	3.9 MB
/.../9 - Using Other Formatting Tools/
9-2 Filling an area with a color gradient.mp4	12.4 MB
9-1 Formatting lines and borders.mp4	11.9 MB
9-5 Changing the rotation of chart text.mp4	10.9 MB
9-4 Working with chart text.mp4	9.1 MB
9-3 Specifying line style, color, and weight.mp4	9.1 MB
/.../1 - Creating and Pivoting PivotTables/
1-2 Formatting data for use in a PivotTable.mp4	12.4 MB
1-9 Updating and refreshing PivotTable data sources.mp4	12.1 MB
1-3 Creating a PivotTable.mp4	11.8 MB
1-8 Consolidating data from multiple sources.mp4	11.6 MB
1-1 Introducing PivotTables.mp4	11.4 MB
1-4 Pivoting a PivotTable.mp4	10.7 MB
1-5 Configuring a PivotTable.mp4	10.2 MB
1-6 Connecting to an external data source.mp4	9.4 MB
1-10 Managing PivotTables.mp4	9.4 MB
1-7 Connecting to an Access database.mp4	5.9 MB
/.../6 - Displaying Data as an Outline/
6-1 Setting up data for outlining.mov	12.2 MB
6-2 Using outlining symbols and levels.mov	8.4 MB
/.../4 - Other Valuable Formatting Tools/
4-5 Adding a background image to a worksheet.mov	12.2 MB
4-3 Copying formats quickly with dragging techniques and the Format Painter.mov	8.7 MB
4-4 Formatting text from Word or the web with the Justify feature.mov	6.1 MB
4-1 Using the multipurpose Format Cells dialog box and the pop-up mini-toolbar.mov	5.4 MB
4-2 Applying different formatting styles within the same cell.mov	5.1 MB
/.../11 - Changing a Chart's Data Source/
11-2 Creating charts from multiple data sources.mp4	12.2 MB
11-3 Adding new data using a table.mp4	11.9 MB
11-1 Pasting new data into a chart.mp4	9.0 MB
/.../6 - Creating and Manipulating PivotCharts/
6-6 Changing a PivotChart's chart type.mp4	11.9 MB
6-4 Formatting a PivotChart.mp4	11.0 MB
6-1 Creating a PivotChart.mp4	9.0 MB
6-3 Filtering a PivotChart.mp4	8.6 MB
6-2 Pivoting a PivotChart.mp4	8.3 MB
6-5 Changing a PivotChart's layout.mp4	7.5 MB
6-7 Adding a trendline to a PivotChart.mp4	7.0 MB
/.../9 - Dynamically Accentuating Data with Conditional Formatting/
9-3 Creating formats based on formulas.mov	11.0 MB
9-2 Creating value-based formatting using data bars and color scales.mov	10.2 MB
9-1 Creating value-based formatting using logical operators.mov	6.6 MB
/.../5 - Applying Conditional Formatting to PivotTables/
5-3 Formatting PivotTable cells using data bars.mp4	11.0 MB
5-4 Formatting PivotTable cells using color scales.mp4	10.7 MB
5-7 Controlling how multiple rules are applied.mp4	9.9 MB
5-2 Highlighting the top or bottom values in a PivotTable.mp4	9.5 MB
5-5 Formatting PivotTable cells using icon sets.mp4	8.6 MB
5-1 Highlighting cells by applying a rule.mp4	7.8 MB
5-6 Editing conditional formatting rules.mp4	6.3 MB
5-8 Deleting a conditional formatting rule.mp4	6.1 MB
/.../5 - Row, Column, and Sheet Adjustments/
5-3 Working with the Hide Unhide options.mov	10.9 MB
5-2 Working with rows, columns, and sheets.mov	9.4 MB
5-1 Adjusting single and multiple row heights and column widths without commands.mov	6.8 MB
/.../7 - Printing PivotTables and PivotCharts/
7-1 Printing a PivotTable.mp4	10.4 MB
7-2 Printing each item on its own page.mp4	9.2 MB
7-3 Printing a PivotChart.mp4	4.7 MB
/4 - Essential Formatting/
4-6 Adding pictures and shapes.mov	10.3 MB
4-1 Formatting numbers and dates.mov	8.2 MB
4-5 Using custom conditional formatting.mov	8.1 MB
4-3 Adjusting columns, rows, and text.mov	5.9 MB
4-4 Using conditional formatting.mov	5.8 MB
4-2 Applying fonts, background colors, and borders.mov	5.6 MB
/.../10 - Analyzing Data/
10-6 Exploring the Analysis Toolpak.mov	9.4 MB
10-1 Using auditing to diagram.mov	7.4 MB
10-4 Using data tables in formulas.mov	6.8 MB
10-5 Using scenarios in formulas.mov	6.2 MB
10-3 Working with Goal Seek.mov	6.1 MB
10-2 Using evaluation in Excel.mov	2.4 MB
/.../7 - Large Excel Projects/
7-4 Creating multiple custom worksheet views.mov	9.2 MB
7-6 Managing worksheets.mov	8.2 MB
7-5 Hiding or grouping rows and columns.mov	7.9 MB
7-7 Calculating formulas across worksheets.mov	7.4 MB
7-2 Freezing panes.mov	5.1 MB
7-3 Repeating row and column titles.mov	4.5 MB
7-1 Finding and replacing data.mov	4.2 MB
/5 - Advanced Formatting/
5-1 Inserting SmartArt.mov	9.0 MB
5-4 Creating and sharing styles.mov	7.7 MB
5-2 Coordinating a look using themes.mov	5.1 MB
5-3 Applying built-in styles.mov	4.9 MB
5-5 Using templates.mov	4.8 MB
5-6 Creating and using original templates.mov	3.2 MB
/3 - Alignment Tools/
3-5 Controlling titles and headings with the Wrap Text and Shrink to Fit options.mov	8.9 MB
3-2 Creating angled text variations for greater variety and readability.mov	7.9 MB
3-4 Simplifying title adjustments with the versatile Merge and Center commands.mov	6.7 MB
3-1 Adjusting horizontal and vertical cell alignment.mov	6.7 MB
3-3 Indenting data and dollar signs.mov	6.0 MB
/.../9 - Exploring Excel's Database Features/
9-3 Basic and multi-field sorting.mov	8.7 MB
9-6 Creating lookup tables.mov	7.1 MB
9-4 Using tables to sort and filter data.mov	7.0 MB
9-2 Joining data from multiple cells.mov	5.4 MB
9-5 Inserting automatic subtotals.mov	4.9 MB
9-1 Splitting cell data into multiple cells.mov	3.2 MB
/.../12 - Creating and Using Charts/
12-5 Creating and modifying a pie chart.mov	8.5 MB
12-4 Modifying a column chart.mov	7.2 MB
12-6 Placing Excel charts into other Office applications.mov	6.1 MB
12-2 Inserting Sparklines.mov	4.7 MB
12-3 Creating a column chart.mov	3.8 MB
12-1 Choosing chart types.mov	1.8 MB
/0 - Introduction/
0-1 Welcome.mov	8.3 MB
0-2 Using the exercise files.mov	1.0 MB
/.../10 - Specialized Power Formatting Techniques/
10-3 Displaying large values without using formulas.mov	8.2 MB
10-2 Restoring missing title data in a column.mov	6.7 MB
10-1 Hiding repeating titles in a column to clarify printed output.mov	5.4 MB
10-5 Formatting a list for double-spaced printing.mov	3.9 MB
10-4 Formatting column row titles.mov	3.6 MB
/8 - Adding Pictures/
8-1 Converting a chart to a picture and adding new images.mov	8.0 MB
8-3 Adding borders and effects to pictures.mov	6.6 MB
8-2 Applying picture styles.mov	4.5 MB
/.../11 - Advanced Analysis with PivotTables/
11-3 Modifying a PivotTable.mov	8.0 MB
11-4 Creating and modifying a PivotChart.mov	7.5 MB
11-2 Creating a basic PivotTable.mov	3.2 MB
11-1 Discovering PivotTables.mov	2.4 MB
/0 - Introduction/
0-1 Welcome.mov	7.6 MB
0-2 Using the exercise files.mov	774.7 KB
/1 - Getting Started/
1-2 Touring the interface.mov	7.5 MB
1-5 Maintaining file compatibility.mov	7.5 MB
1-3 Finding the commands you need.mov	5.2 MB
1-4 Using Backstage view or the File tab.mov	4.1 MB
1-1 Exploring three common uses for Excel.mov	3.4 MB
/.../3 - Excel Formula Basics/
3-4 Adding numbers using Sum and AutoSum.mov	7.0 MB
3-7 Preventing errors using absolute references.mov	6.4 MB
3-10 Using SUMIF and AVERAGEIF.mov	5.8 MB
3-6 Working with numbers in columns.mov	5.4 MB
3-3 Adding numbers manually.mov	5.1 MB
3-9 Using IF.mov	5.1 MB
3-1 Understanding formulas and functions.mov	4.9 MB
3-11 Naming and using cell ranges.mov	4.3 MB
3-8 Working with times and dates.mov	3.5 MB
3-2 Entering data in a worksheet.mov	3.5 MB
3-5 Adding a whole worksheet.mov	2.0 MB
/Exercise Files/
olive_tree_v2.tiff	6.7 MB
IMG_0058.JPG	808.0 KB
Ch_08_Pictures.xlsx	539.9 KB
TTOO_logo.tiff	468.4 KB
E863A600	148.3 KB
Ch_10_Power.xlsx	147.3 KB
Ch_09_Conditional.xlsx	94.2 KB
Ch_05_RowColumn.xlsx	93.1 KB
Ch_06_Outlining.xlsx	92.8 KB
Ch_07_Visualization.xlsx	88.6 KB
Ch_01_Numeric.xlsx	67.2 KB
Ch_04_Tools.xlsx	58.7 KB
TTOliveOil_Confidential.tiff	54.0 KB
Ch_03_Alignment.xlsx	47.6 KB
Ch_02_Display.xlsx	32.7 KB
TwoTreesValley_small.jpg	15.5 KB
/0 - Introduction/
0-1 Welcome.mp4	6.6 MB
0-2 Using the exercise files.mp4	2.8 MB
/6 - Printing Preparation/
6-1 Making the pieces fit.mov	6.4 MB
6-3 Printing and PDFs.mov	5.4 MB
6-2 Inserting headers and footers.mov	4.6 MB
/2 - Worksheet Basics/
2-4 Targeting large data groups.mov	6.4 MB
2-3 Entering data automatically with Auto Fill.mov	6.0 MB
2-1 Creating a worksheet.mov	5.6 MB
2-2 Techniques for copying and pasting.mov	4.5 MB
2-5 Changing a worksheet's structure.mov	3.9 MB
/0 - Introduction/
0-1 Welcome.mp4	5.9 MB
0-2 Using the exercise files.mp4	1.2 MB
/Conclusion/
Final thoughts.mov	1.8 MB
/Conclusion/
Additional resources.mp4	1.6 MB
/Conclusion/
Next steps.mp4	1.5 MB
/Exercise Files/
Ch_01_Chart_Concepts.xlsx	952.8 KB
Ch_12_PPT_Finished.pptx	921.0 KB
Ch_02_Chart_Building.xlsx	895.9 KB
Ch_10_SpecificTypes.xlsx	838.2 KB
Ch_08_FormatTab.xlsx	251.5 KB
Ch_04_LayoutTabPics.xlsx	244.2 KB
Ch_09_OtherFormatting.xlsx	241.3 KB
Ch_05_LayoutTabTitles.xlsx	240.7 KB
Ch_03_DesignTab.xlsx	236.9 KB
Ch_06_LayoutTabAxes.xlsx	197.2 KB
Ch_11_ChartSource.xlsx	56.4 KB
Ch_07_LayoutAnalysis.xlsx	39.9 KB
Ch_12_PrintShare-Revised by DPT on 6-11-11.xlsx	36.3 KB
Ch_12_PrintShare.xlsx	32.9 KB
/Exercise Files/Ch01/
PTDatabase.accdb	421.9 KB
Refreshing.xlsx	25.6 KB
Managing.xlsx	19.8 KB
Configure.xlsx	18.2 KB
Introducing.xlsx	17.9 KB
Pivoting.xlsx	17.1 KB
CreatePivot.xlsx	12.9 KB
DataPrep.xlsx	12.2 KB
Consolidating.xlsx	10.5 KB
OutsideSource.xlsx	10.2 KB
PTAccess.xlsx	8.4 KB
External.xlsx	8.4 KB
/Conclusion/
Goodbye.mov	250.2 KB
/Exercise Files/chapt 8/
comments.xlsx	206.3 KB
permissions.xlsx	147.5 KB
sharing.xlsx	142.1 KB
protecting.xlsx	142.1 KB
import into this.xlsx	139.6 KB
export this.xlsx	139.2 KB
kalamata.jpg	63.8 KB
multi-pack 1.jpg	32.1 KB
saving shared locations.xlsx	12.2 KB
import data.txt	2.2 KB
import data.csv	2.2 KB
/Exercise Files/chapt 5/
logo.jpg	164.7 KB
custom styles.xlsx	141.3 KB
styles.xlsx	141.0 KB
merge styles.xlsx	140.3 KB
smart art.xlsx	139.1 KB
turn into template.xlsx	138.9 KB
garlic.jpg	52.2 KB
gift pack.jpg	32.1 KB
themes.xlsx	26.1 KB
herbs.jpg	19.8 KB
/Exercise Files/chapt 13/
editing macro.xlsm	160.3 KB
west data.xlsx	138.5 KB
overseas data.xlsx	138.3 KB
recording macro.xlsx	138.0 KB
northeast data.xlsx	138.0 KB
southeast data.xlsx	137.9 KB
/Exercise Files/chapt 11/
pivot table.xlsx	159.5 KB
pivot chart.xlsx	151.0 KB
modifying a pivottable.xlsx	144.2 KB
create pivot table.xlsx	139.3 KB
/Exercise Files/chapt 7/
freezing panes.xlsx	157.1 KB
3D formulas.xlsx	155.5 KB
views.xlsx	143.5 KB
grouping.xlsx	140.9 KB
repeating rows.xlsx	140.6 KB
find and replace.xlsx	140.5 KB
managing worksheets.xlsx	139.8 KB
/Exercise Files/chapt 1/
backstage view.xlsx	155.1 KB
ribbon bar.xlsx	155.1 KB
current format.xlsx	149.8 KB
what is excel for.xlsx	147.0 KB
touring the interface.xlsx	140.2 KB
older format workbook.xls	35.3 KB
/Exercise Files/chapt 9/
tables.xlsx	143.0 KB
subtotals.xlsx	142.8 KB
sorting.xlsx	142.4 KB
merging.xlsx	142.4 KB
splitting.xlsx	142.1 KB
lookups.xlsx	138.3 KB
/Exercise Files/chapt 10/
data tables.xlsx	142.3 KB
analysis toolpack.xlsx	141.4 KB
auditing.xlsx	141.3 KB
goal seek.xlsx	138.3 KB
scenarios.xlsx	136.4 KB
evaluate.xlsx	22.6 KB
/Exercise Files/chapt 14/
setting options.xlsx	141.6 KB
customizing ribbon.xlsx	141.6 KB
customizing QAT.xlsx	141.6 KB
Bob's Customizations.exportedUI	1.1 KB
/Exercise Files/chapt 3/
sumif.xlsx	141.1 KB
if.xlsx	139.0 KB
creating range names.xlsx	21.1 KB
sum.xlsx	12.9 KB
whole worksheet.xlsx	12.9 KB
average.xlsx	12.9 KB
dates.xlsx	11.7 KB
manual.xlsx	11.5 KB
absolute refs.xlsx	11.4 KB
expense report.xlsx	9.6 KB
formulas and functions.xlsx	9.6 KB
/Exercise Files/chapt 12/
placing chart.xlsx	140.3 KB
modifying a chart.xlsx	139.9 KB
sparklines.xlsx	139.8 KB
column chart.xlsx	138.1 KB
pie chart.xlsx	138.1 KB
insert pie chart.pptx	77.0 KB
insert pie chart.docx	44.3 KB
/Exercise Files/chapt 2/
rows and columns.xlsx	140.2 KB
selections.xlsx	11.8 KB
autofill.xlsx	9.4 KB
clipboard.xlsx	9.0 KB
/Exercise Files/chapt 4/
custom conditional formatting.xlsx	139.8 KB
conditional formatting.xlsx	139.8 KB
pictures - finished.xlsx	75.8 KB
bottle.jpg	49.6 KB
pictures.xlsx	14.9 KB
adjusting.xlsx	12.4 KB
fonts.xlsx	12.0 KB
formatting numbers.xlsx	11.9 KB
/Exercise Files/chapt 6/
create PDFs.xlsx	91.3 KB
headers and footers.xlsx	69.5 KB
page size.xlsx	69.3 KB
logo.jpg	24.7 KB
/Exercise Files/Ch08/
SimplePresKit.xlsm	26.7 KB
Running.xlsm	20.6 KB
RecordMacro.xlsx	18.3 KB
/Exercise Files/Ch07/
PrintPChart.xlsx	24.6 KB
PrintPTable.xlsx	18.3 KB
PrintItems.xlsx	18.2 KB
/Exercise Files/Ch06/
FilterPChart.xlsx	21.9 KB
FormatPChart.xlsx	21.3 KB
PivotPChart.xlsx	21.1 KB
PCTrendline.xlsx	20.6 KB
PivotChartLayout.xlsx	19.8 KB
PivotChartType.xlsx	19.5 KB
MakePTChart.xlsx	18.2 KB
/Exercise Files/Ch03/
FormatSlicer.xlsx	19.7 KB
FilterByRule.xlsx	19.0 KB
Selection.xlsx	18.4 KB
Sorting.xlsx	18.3 KB
Slicer.xlsx	18.3 KB
SearchFilter.xlsx	18.3 KB
CustomList.xlsx	18.2 KB
ReportFilter.xlsx	18.2 KB
Clearing.xlsx	17.5 KB
/Exercise Files/Ch05/
PTColorScale.xlsx	19.7 KB
DeletePTCF.xlsx	19.1 KB
MultConds.xlsx	19.1 KB
PTDataBars.xlsx	18.2 KB
TopTen.xlsx	18.2 KB
ConditionalRules.xlsx	18.2 KB
PTIconSets.xlsx	17.9 KB
EditConds.xlsx	16.6 KB
/Exercise Files/Ch02/
Summary.xlsx	19.3 KB
Calculated.xlsx	18.8 KB
MoreThanOne.xlsx	18.7 KB
Grouping.xlsx	18.3 KB
GetPivotData.xlsx	18.2 KB
DrillDown.xlsx	18.2 KB
SubAndGrand.xlsx	18.2 KB
/Exercise Files/Ch04/
ApplyStyle.xlsx	18.4 KB
PTLayout.xlsx	18.2 KB
DataFormat.xlsx	18.2 KB
CreatePTStyles.xlsx	18.2 KB
Total files 435