Lynda Excel 3Courses | 840EF791F7B5885B6689193A1F5C7AFE0CE407CA

Lynda Excel 3Courses

Name	Lynda.Excel.3Courses	DOWNLOAD Copy Link
Total Size	359.6 MB
Total Files	61
Hash	840EF791F7B5885B6689193A1F5C7AFE0CE407CA

/.../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
/.../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
/Essential Training/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
/.../10 Analyzing Data/
1001 Using auditing to diagram.mov	7.4 MB
1003 Working with Goal Seek.mov	6.1 MB
1004 Using data tables in formulas.mov	5.0 MB
1002 Using evaluation in Excel.mov	2.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
Total files 61