01 Essential Training | D9875630B7714453B1D927DDC3CDDC9F5E5A857F

01 Essential Training

Name	01 Essential Training	DOWNLOAD Copy Link
Total Size	493.6 MB
Total Files	174
Hash	D9875630B7714453B1D927DDC3CDDC9F5E5A857F

/13 Creating and Using Macros/
1302 Recording and using a simple macro.mov	14.8 MB
1303 Editing a macro.mov	7.6 MB
1301 Understanding macros.mov	2.9 MB
/14 Customizing Excel/
1402 Customizing the Ribbon bar.mov	13.8 MB
1403 Setting Excel options.mov	10.2 MB
1401 Customizing the Quick Access toolbar.mov	4.5 MB
/08 Collaborating with Others/
0806 Saving files in shared locations.mov	12.7 MB
0801 Importing and exporting data in Excel.mov	10.6 MB
0803 Inserting and editing comments.mov	8.9 MB
0802 Setting workbook permissions.mov	7.7 MB
0805 Tracking changes.mov	3.8 MB
0804 Sharing a workbook.mov	1.8 MB
/04 Essential Formatting/
0406 Adding pictures and shapes.mov	10.3 MB
0401 Formatting numbers and dates.mov	8.2 MB
0405 Using custom conditional formatting.mov	8.1 MB
0403 Adjusting columns, rows, and text.mov	5.9 MB
0404 Using conditional formatting.mov	5.8 MB
0402 Applying fonts, background colors, and borders.mov	5.6 MB
/10 Analyzing Data/
1006 Exploring the Analysis Toolpak.mov	9.4 MB
1001 Using auditing to diagram.mov	7.4 MB
1004 Using data tables in formulas.mov	6.8 MB
1005 Using scenarios in formulas.mov	6.2 MB
1003 Working with Goal Seek.mov	6.1 MB
1002 Using evaluation in Excel.mov	2.4 MB
/07 Large Excel Projects/
0704 Creating multiple custom worksheet views.mov	9.2 MB
0706 Managing worksheets.mov	8.2 MB
0705 Hiding or grouping rows and columns.mov	7.9 MB
0707 Calculating formulas across worksheets.mov	7.4 MB
0702 Freezing panes.mov	5.1 MB
0703 Repeating row and column titles.mov	4.5 MB
0701 Finding and replacing data.mov	4.2 MB
/05 Advanced Formatting/
0501 Inserting SmartArt.mov	9.0 MB
0504 Creating and sharing styles.mov	7.7 MB
0502 Coordinating a look using themes.mov	5.1 MB
0503 Applying built-in styles.mov	4.9 MB
0505 Using templates.mov	4.8 MB
0506 Creating and using original templates.mov	3.2 MB
/09 Exploring Excel's Database Features/
0903 Basic and multi-field sorting.mov	8.7 MB
0906 Creating lookup tables.mov	7.1 MB
0904 Using tables to sort and filter data.mov	7.0 MB
0902 Joining data from multiple cells.mov	5.4 MB
0905 Inserting automatic subtotals.mov	4.9 MB
0901 Splitting cell data into multiple cells.mov	3.2 MB
/12 Creating and Using Charts/
1205 Creating and modifying a pie chart.mov	8.5 MB
1204 Modifying a column chart.mov	7.2 MB
1206 Placing Excel charts into other Office applications.mov	6.1 MB
1202 Inserting Sparklines.mov	4.7 MB
1203 Creating a column chart.mov	3.8 MB
1201 Choosing chart types.mov	1.8 MB
/11 Advanced Analysis with PivotTables/
1103 Modifying a PivotTable.mov	8.0 MB
1104 Creating and modifying a PivotChart.mov	7.5 MB
1102 Creating a basic PivotTable.mov	3.2 MB
1101 Discovering PivotTables.mov	2.4 MB
/00 Introduction/
0001 Welcome.mov	7.6 MB
0002 Using the exercise files.mov	774.7 KB
/01 Getting Started/
0102 Touring the interface.mov	7.5 MB
0105 Maintaining file compatibility.mov	7.5 MB
0103 Finding the commands you need.mov	5.2 MB
0104 Using Backstage view or the File tab.mov	4.1 MB
0101 Exploring three common uses for Excel.mov	3.4 MB
/03 Excel Formula Basics/
0304 Adding numbers using Sum and AutoSum.mov	7.0 MB
0307 Preventing errors using absolute references.mov	6.4 MB
0310 Using SUMIF and AVERAGEIF.mov	5.8 MB
0306 Working with numbers in columns.mov	5.4 MB
0303 Adding numbers manually.mov	5.1 MB
0309 Using IF.mov	5.1 MB
0301 Understanding formulas and functions.mov	4.9 MB
0311 Naming and using cell ranges.mov	4.3 MB
0308 Working with times and dates.mov	3.5 MB
0302 Entering data in a worksheet.mov	3.5 MB
0305 Adding a whole worksheet.mov	2.0 MB
/06 Printing Preparation/
0601 Making the pieces fit.mov	6.4 MB
0603 Printing and PDFs.mov	5.4 MB
0602 Inserting headers and footers.mov	4.6 MB
/02 Worksheet Basics/
0204 Targeting large data groups.mov	6.4 MB
0203 Entering data automatically with Auto Fill.mov	6.0 MB
0201 Creating a worksheet.mov	5.6 MB
0202 Techniques for copying and pasting.mov	4.5 MB
0205 Changing a worksheet's structure.mov	3.9 MB
/15 Conclusion/
1501 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
Total files 174