Lynda com Office 2007 Collection | B67DFA3BB8FA5427ADB8A4A0555AA251C514CCB6

Lynda com Office 2007 Collection

Name	Lynda.com Office 2007 Collection	DOWNLOAD Copy Link
Total Size	3.9 GB
Total Files	490
Hash	B67DFA3BB8FA5427ADB8A4A0555AA251C514CCB6

/Lynda.com - Excel 2007 Essential Training/
Lynda.com - Excel 2007 Essential Training.iso	560.9 MB
Lynda.com.Excel.2007.Essential.Training-MOJO.nfo	23.2 KB
Lynda.com.Excel.2007.Essential.Training-MOJO.rar	377.4 MB
Readme.txt	3.4 KB
Torrent_downloaded_from_Demonoid.com.txt	0.0 KB
/WMV/
00_01_Welcome_WMV V9.wmv	749.6 KB
01_01_Whytake_WMV V9.wmv	2.1 MB
01_02_Whats_changed_WMV V9.wmv	7.6 MB
01_03_Whats_the_Ribbon_WMV V9.wmv	2.9 MB
01_04_Office_Button_WMV V9.wmv	1.8 MB
02_01_Whats_on_Ribbon_WMV V9.wmv	1.9 MB
02_02_Moving_around_Ribb_WMV V9.wmv	2.1 MB
02_03_Customizing_Ribbon_WMV V9.wmv	3.1 MB
02_04_Customizing_Off_WMV V9.wmv	5.3 MB
03_01_Opening_Old_Wor_WMV V9.wmv	2.7 MB
03_02_Add_Delete_Workshe_WMV V9.wmv	3.1 MB
03_03_Insert_delete_cell_WMV V9.wmv	8.8 MB
03_04_Freezing_areas__WMV V9.wmv	4.7 MB
04_01_Width_and_Height_WMV V9.wmv	8.9 MB
04_02_Numeric_formats_WMV V9.wmv	3.0 MB
04_03_Alignment_of_data_WMV V9.wmv	4.1 MB
04_04_Playing_with_Fonts_WMV V9.wmv	3.7 MB
04_05_Auto_filter_WMV V9.wmv	3.0 MB
04_06_Formatting_Table_WMV V9.wmv	3.5 MB
05_01_Removing_duplicate_WMV V9.wmv	7.0 MB
05_02_Conditional_For_WMV V9.wmv	3.1 MB
05_03_Working_with_Co_WMV V9.wmv	3.0 MB
05_04_Managing_Cond_Form_WMV V9.wmv	3.4 MB
05_05_Text_to_Columns_WMV V9.wmv	5.5 MB
05_06_Data_Validation_WMV V9.wmv	4.3 MB
06_01_Templates_WMV V9.wmv	4.4 MB
06_02_Styles_WMV V9.wmv	4.9 MB
06_03_Autoformat_WMV V9.wmv	3.6 MB
07_01_Lists_and_Tables_WMV V9.wmv	3.4 MB
07_02_Text_to_Columns_WMV V9.wmv	4.2 MB
07_03_Sorting_and_Groupi_WMV V9.wmv	6.9 MB
07_04_Create_Summary_Rep_WMV V9.wmv	1.8 MB
08_01_Proofing_your_work_WMV V9.wmv	4.3 MB
08_02_Providing_comments_WMV V9.wmv	4.2 MB
09_01_Protecting_WMV V9.wmv	5.3 MB
09_02_Sharing_workbooks_WMV V9.wmv	5.2 MB
09_03_Track_changes_WMV V9.wmv	5.1 MB
10_01_Preparing_to_Print_WMV V9.wmv	3.2 MB
10_02_Print_Preview_WMV V9.wmv	3.4 MB
10_03_PageLayout_Tab_WMV V9.wmv	5.1 MB
10_04_Page_Breaks_WMV V9.wmv	5.1 MB
10_05_PageLayout_View_WMV V9.wmv	4.2 MB
10_06_Headers_and_Footer_WMV V9.wmv	4.2 MB
11_01_Adding_Themes_WMV V9.wmv	4.5 MB
11_02_Page_Setup_WMV V9.wmv	9.9 MB
11_03_Scale_to_Fit_WMV V9.wmv	3.1 MB
11_04_Worksheet_Options_WMV V9.wmv	7.0 MB
11_05_Inserting_Images_WMV V9.wmv	4.7 MB
12_01_Using_Templates_WMV V9.wmv	4.8 MB
13_01_Workbook_Views_WMV V9.wmv	3.8 MB
13_02_Hiding_and_Zooming_WMV V9.wmv	5.2 MB
13_03_Window_Panes_WMV V9.wmv	7.8 MB
13_04_More_Screen_Option_WMV V9.wmv	7.8 MB
14_01_Import_Access_WMV V9.wmv	2.5 MB
14_02_Import_Text_WMV V9.wmv	6.2 MB
15_01_Find_and_Select_WMV V9.wmv	6.1 MB
15_02_Find_and_Replace_WMV V9.wmv	3.8 MB
15_03_Removing_Duplicate_WMV V9.wmv	5.1 MB
16_01_What_are_Formulas_WMV V9.wmv	3.1 MB
16_02_Order_Operations_WMV V9.wmv	2.6 MB
16_03_Relative_Absolute_WMV V9.wmv	6.5 MB
16_04_Formula_Tab_WMV V9.wmv	7.7 MB
17_01_What_are_functions_WMV V9.wmv	3.6 MB
17_02_Adding_WMV V9.wmv	3.4 MB
17_03_Min_WMV V9.wmv	5.0 MB
17_04_Trim_WMV V9.wmv	6.9 MB
17_05_Left_WMV V9.wmv	3.9 MB
18_01_Concat_WMV V9.wmv	5.5 MB
18_02_SumIf_WMV V9.wmv	6.9 MB
18_03_VLookup_WMV V9.wmv	9.6 MB
18_04_What_If_WMV V9.wmv	3.8 MB
19_01_Why_Charts_WMV V9.wmv	2.8 MB
19_02_Creating_Chart_WMV V9.wmv	4.6 MB
19_03_Modifying_Charts_WMV V9.wmv	8.0 MB
19_04_Chart_Layout_WMV V9.wmv	4.8 MB
20_01_Why_Pivot_Tables_WMV V9.wmv	3.3 MB
20_02_Creating_Pivot_Tab_WMV V9.wmv	5.9 MB
20_03_Pivot_Table_Layout_WMV V9.wmv	3.2 MB
20_04_Pivot_Table_Design_WMV V9.wmv	5.2 MB
20_05_Pivot_Charts_WMV V9.wmv	4.4 MB
21_01_Why_Macros_WMV V9.wmv	3.0 MB
21_02_Record_Macros_WMV V9.wmv	5.7 MB
21_03_Macro_Security_WMV V9.wmv	2.7 MB
22_01_Workflow_in_Excel_WMV V9.wmv	7.4 MB
23_01_Conclusion_WMV V9.wmv	493.5 KB
/Lynda.com - Word 2007 Essential Training/
autorun.inf	0.0 KB
FullScreenMode.exe	638.0 KB
Lynda.com.Word.2007.Essential.Training-MOJO.nfo	23.1 KB
Lynda.com.Word.2007.Essential.Training-MOJO.rar	534.5 MB
lynda.ico	22.5 KB
readme.txt	4.4 KB
WindowMode.exe	134.0 KB
/data/
appname.txt	0.0 KB
chaptermov.swf	5.8 KB
controls.dxr	93.7 KB
holder.mov	6.6 KB
main.dxr	2.9 MB
movies.cxt	33.5 KB
movies.dxr	14.9 KB
movies.txt	5.2 KB
/data/art/
credits_screen.bmp	909.4 KB
main_title.bmp	218.5 KB
opening_screen.bmp	1.4 MB
/data/help/
bookmarks.mov	460.4 KB
exercise_files.mov	303.7 KB
interface_tour.mov	756.0 KB
playing_movies.mov	869.4 KB
preferences.mov	1.1 MB
/data/movies/chap00/
00_01_Intro.mov	857.6 KB
/data/movies/chap01/
01_01_Starting_Word.mov	1.7 MB
01_02_Understanding_the_UI.mov	10.5 MB
01_03_Navigating_UI.mov	24.0 MB
01_04_Navigating_Documen.mov	12.3 MB
/data/movies/chap02/
02_01_Creating_New_Documents.mov	10.6 MB
02_02_Importing.mov	6.9 MB
02_03_Saving.mov	9.6 MB
02_04_Sending_Documents.mov	5.2 MB
/data/movies/chap03/
03_01_Print_Preview.mov	4.6 MB
03_02_Quick_Print.mov	4.7 MB
03_03_Printing_Options.mov	11.8 MB
/data/movies/chap04/
04_01_Selecting_Text.mov	6.9 MB
04_02_Formatting_Text.mov	9.8 MB
04_03_Find_Replace.mov	6.0 MB
04_04_Undo.mov	4.4 MB
04_05_Copy_Paste.mov	7.8 MB
04_06_Show_Formatting.mov	5.6 MB
/data/movies/chap05/
05_01_Indents.mov	6.4 MB
05_02_Justification.mov	6.0 MB
05_03_Line_Spacing.mov	7.2 MB
05_04_Tabs.mov	7.1 MB
05_05_Highlighter.mov	3.7 MB
/data/movies/chap06/
06_01_Margins.mov	11.7 MB
06_02_Orientation.mov	4.8 MB
06_03_Page_Numbering.mov	11.2 MB
06_04_Paper_Size.mov	5.5 MB
06_05_Header_Footer.mov	15.0 MB
06_06_Background.mov	15.8 MB
06_07_Watermarks.mov	9.7 MB
/data/movies/chap07/
07_01_Spelling_Grammar.mov	8.1 MB
07_02_Synonyms.mov	6.9 MB
07_03_Translation.mov	9.7 MB
07_04_Proofing_Options.mov	10.9 MB
/data/movies/chap08/
08_01_Modify_Environment.mov	12.4 MB
08_02_Modify_Display.mov	9.6 MB
08_03_Modify_Toolbars.mov	13.0 MB
/data/movies/chap09/
09_01_Bullets.mov	12.8 MB
09_02_Numbered_Lists.mov	6.9 MB
09_03_Edit_List.mov	7.2 MB
/data/movies/chap10/
10_01_Create_Table.mov	6.2 MB
10_02_Table_from_Text.mov	4.4 MB
10_03_Insert_Spreadsheet.mov	7.9 MB
10_04_Modify_Table.mov	9.8 MB
10_05_Format_Table.mov	12.3 MB
10_06_Calculations.mov	5.5 MB
10_07_Charts.mov	8.7 MB
10_08_Modify_Chart_Data.mov	3.3 MB
10_09_Modify_Chart_Ap.mov	18.2 MB
10_10_Text_from_Table.mov	2.3 MB
/data/movies/chap11/
11_01_Using_Sytles.mov	5.7 MB
11_02_Create_Styles.mov	6.9 MB
11_03_Edit_Styles.mov	5.6 MB
/data/movies/chap12/
12_01_Create_Buiding_Blocks.mov	8.2 MB
12_02_Edit_Building_Blocks.mov	8.8 MB
/data/movies/chap13/
13_01_Merge.mov	20.2 MB
13_02_Data_Source.mov	7.1 MB
13_03_Envelopes.mov	9.6 MB
/data/movies/chap14/
14_01_Sort_Text.mov	5.2 MB
14_02_Sort_Numbers.mov	3.2 MB
14_03_Sort_Tables.mov	3.7 MB
/data/movies/chap15/
15_01_Create_Macro.mov	9.5 MB
15_02_Play_Macro.mov	3.3 MB
15_03_Edit_Marcro.mov	4.4 MB
/data/movies/chap16/
16_01_Newspaper_Columns.mov	11.2 MB
16_02_Parallel_Columns.mov	6.4 MB
/data/movies/chap17/
17_01_Pictures.mov	19.0 MB
17_02_Shapes.mov	10.2 MB
17_03_SmartArt.mov	12.8 MB
/data/movies/chap18/
18_01_Track_Changes.mov	11.5 MB
18_02_Review_Changes.mov	6.6 MB
18_03_Sending.mov	6.3 MB
18_04_Passwords.mov	5.5 MB
18_05_Linking.mov	20.0 MB
18_06_Inspecting.mov	5.0 MB
18_07_Encrypting.mov	5.1 MB
18_08_Signatures.mov	13.0 MB
/data/movies/chap19/
19_01_Cross_References.mov	7.3 MB
19_02_TOC.mov	8.2 MB
19_03_Index.mov	9.5 MB
19_04_Footnotes.mov	14.8 MB
19_05_Hyperlinks.mov	9.1 MB
19_06_Bookmarks.mov	7.0 MB
19_07_Doc_Map.mov	4.7 MB
/data/movies/chap20/
20_01_WordClosing.mov	596.6 KB
/data/os9/
Fullscreen_OS9	0.0 KB
WindowMode_OS9	0.0 KB
/exercise files/Lesson01/
newsletter1.docx	19.5 KB
newsletter2.docx	24.6 KB
recipe_book.docx	77.9 KB
/exercise files/Lesson02/
Job_Posting.doc	26.1 KB
Job_Posting.wpd	13.3 KB
newsletter1.docx	20.9 KB
~$wsletter1.docx	0.2 KB
/exercise files/Lesson03/
newsletter.docx	24.5 KB
/exercise files/Lesson04/
Job_Posting.docx	13.4 KB
Job_Posting2.docx	13.5 KB
Job_Posting3.docx	13.5 KB
newsletter4.docx	13.3 KB
recipe_book4.docx	78.4 KB
/exercise files/Lesson05/
Job_Posting5.docx	13.4 KB
Job_Posting6.docx	13.5 KB
Job_Posting7.docx	13.5 KB
Parts Inventory.docx	10.0 KB
Parts Inventory2.docx	10.4 KB
/exercise files/Lesson06/
cake_logo.jpg	9.4 KB
Job_Posting10.docx	13.9 KB
Job_Posting11.docx	13.9 KB
Job_Posting8.docx	13.9 KB
Job_Posting9.docx	13.9 KB
recipe_book6.docx	72.2 KB
recipe_book_plain.docx	58.4 KB
/exercise files/Lesson07/
Job_Posting12.docx	28.7 KB
Job_Posting13.docx	28.8 KB
Job_Posting14.docx	29.0 KB
/exercise files/Lesson09/
Job_Posting15.docx	16.8 KB
Job_Posting16.docx	18.6 KB
Job_Posting17.docx	19.2 KB
Shopping_List.docx	21.5 KB
Shopping_List2.docx	21.7 KB
/exercise files/Lesson10/
Annual Report on Revenues1.docx	20.5 KB
Annual Report on Revenues2.docx	28.4 KB
Annual Report on Revenues3.docx	28.5 KB
Annual Report on RevenuesFinal.docx	31.9 KB
Inventory5.docx	21.6 KB
Shopping_List3.docx	21.6 KB
Shopping_List4.docx	22.1 KB
Shopping_List5.docx	22.3 KB
Shopping_List6.docx	22.5 KB
Shopping_List7.docx	23.3 KB
Shopping_List8.docx	23.4 KB
~$nual Report on Revenues2.docx	0.2 KB
/exercise files/Lesson11/
Job_PostingA.docx	13.9 KB
Job_PostingB.docx	14.4 KB
Job_PostingC.docx	13.9 KB
/exercise files/Lesson12/
Posting1.docx	13.9 KB
Posting2.docx	13.7 KB
Posting3.docx	13.9 KB
/exercise files/Lesson13/
Contacts.docx	11.6 KB
EnvelopeLabelList.mdb	200.7 KB
Invitation.docx	11.5 KB
/exercise files/Lesson14/
AlstarTeam1.docx	11.4 KB
AlstarTeam2.docx	11.6 KB
AlstarTeam3.docx	14.0 KB
/exercise files/Lesson15/
Posting15a.docx	13.4 KB
Posting15b.docx	13.5 KB
/exercise files/Lesson16/
Inventory16a.docx	11.0 KB
newsletter16a.docx	18.9 KB
/exercise files/Lesson17/
Author.jpg	32.1 KB
cake_logo.jpg	9.4 KB
Newsletter17a.docx	21.9 KB
Newsletter17b.docx	50.0 KB
/exercise files/Lesson18/
AnnualReport18.docx	31.9 KB
ConfidentialReport18.docx	31.9 KB
ECPBalanceSheet1.xlsx	21.3 KB
FormLetter18a.docx	37.2 KB
FormLetter18b.docx	37.3 KB
IntroducingECP.pptx	269.6 KB
newsletter18.pdf	30.0 KB
Newsletter18a.doc	44.5 KB
Newsletter18b.doc	45.6 KB
Newsletter18c.doc	45.1 KB
Newsletter18d.doc	45.1 KB
Newsletter18e.doc	45.1 KB
Report18.docx	31.9 KB
/exercise files/Lesson19/
BookofRecipes.docx	72.8 KB
newsletter19a.docx	24.7 KB
recipe_book19a.doc	198.1 KB
recipe_book19b.doc	279.6 KB
Recipes19c.docx	76.9 KB
Recipes19d.docx	71.3 KB
Recipes19e.docx	71.2 KB
Recipes19f.docx	71.5 KB
Recipes19g.docx	71.2 KB
/Mac GUI/
Mac GUI Apps.sit	9.2 MB
/QuickTime/
get_quicktime.htm	1.6 KB
/Xtras/
CDPRO.X32	76.8 KB
Dirapi.dll	1.1 MB
DirectSound.x32	32.8 KB
FileIo.x32	41.0 KB
FileXtra3.x32	238.3 KB
Flash Asset.x32	340.0 KB
Font Asset.x32	69.6 KB
Font Xtra.x32	282.6 KB
Iml32.dll	561.2 KB
INetURL.x32	49.2 KB
MacroMix.x32	53.2 KB
msvcrt.dll	266.3 KB
Mui Dialog.x32	282.6 KB
NetFile.x32	53.2 KB
NetLingo.x32	49.2 KB
Proj.dll	159.7 KB
QT6Asset.x32	127.0 KB
Sound Control.x32	53.2 KB
SWADCmpr.x32	69.6 KB
SWAStrm.x32	57.3 KB
Text Asset.x32	98.3 KB
TextXtra.x32	348.2 KB
/00.Introduction/
00_01_Intro.mov	909.1 KB
/.../01.Getting Started with Access/
01_01_concepts.mov	18.3 MB
01_02_starting.mov	7.8 MB
01_03_getting_started.mov	7.1 MB
01_04_quick_access.mov	7.0 MB
01_05_open.mov	5.4 MB
01_06_work_area.mov	15.1 MB
01_07_customize.mov	11.7 MB
/.../02.Creating Databases and Tables/
02_01_planning.mov	2.8 MB
02_02_fields.mov	4.0 MB
02_03_keys.mov	2.9 MB
02_04_tables.mov	4.7 MB
02_05_fields.mov	6.9 MB
02_06_records.mov	5.8 MB
02_07_data.mov	10.3 MB
02_08_spelling.mov	7.7 MB
/.../03.Working with Fields and Records/
03_01_modify_table.mov	9.0 MB
03_02_find.mov	5.5 MB
03_03_sort.mov	7.7 MB
/.../04.Creating Data Entry Rules/
04_01_properties.mov	7.6 MB
04_02_masks.mov	7.6 MB
04_03_rules.mov	13.0 MB
/.../05.Relational Database Techniques/
05_01_keys.mov	6.9 MB
05_02_relationships.mov	7.5 MB
05_03_refintegrity.mov	5.0 MB
05_04_subdatasheets.mov	5.8 MB
/.../06.Working with Queries/
06_01_querywizard.mov	6.6 MB
06_02_queryscratch.mov	8.7 MB
06_03_querydesign.mov	5.9 MB
06_04_querycount.mov	3.3 MB
06_05_parameterquery.mov	10.2 MB
/.../07.Working with Forms/
07_01_forms.mov	2.0 MB
07_02_formwizard.mov	7.5 MB
07_03_formscratch.mov	6.6 MB
07_04_formdesign.mov	16.6 MB
07_05_subforms.mov	10.4 MB
07_06_formcommands.mov	9.8 MB
07_07_sortfilter.mov	8.4 MB
07_08_switchboard.mov	17.6 MB
/.../08.Working with Reports/
08_01_reportwizard.mov	7.8 MB
08_02_reportdesign.mov	13.4 MB
08_03_reportcalcs.mov	11.6 MB
08_04_reportformat.mov	18.1 MB
08_05_reportsummary.mov	12.9 MB
08_06_reportlabels.mov	9.3 MB
08_07_reportprinting.mov	7.3 MB
/.../09.Working with Macros/
09_01_createmacro.mov	6.5 MB
09_02_attachmacro.mov	8.5 MB
09_03_automateinput.mov	10.6 MB
09_04_validationmacro.mov	9.7 MB
09_05_autoexec.mov	3.7 MB
/.../10.Sharing Data with Word and Excel/
10_01_import.mov	9.1 MB
10_02_packagesign.mov	8.4 MB
10_03_email.mov	7.0 MB
10_04_export.mov	8.2 MB
/.../11.Working with Charts/
11_01_charts.mov	14.9 MB
11_02_pivotcharts.mov	7.8 MB
/Exercises/
Exercise_Files.sitx	4.0 MB
Exercise_Files.zip	4.2 MB
/WMV/01/
00_01_Intro_WMV V9.wmv	997.7 KB
01_01_concepts_WMV V9.wmv	14.7 MB
01_02_starting_WMV V9.wmv	6.7 MB
01_03_getting_started_WMV V9.wmv	6.5 MB
01_04_quick_access_WMV V9.wmv	5.5 MB
01_05_open_WMV V9.wmv	4.0 MB
01_06_work_area_WMV V9.wmv	10.1 MB
01_07_customize_WMV V9.wmv	8.8 MB
/WMV/02/
02_01_planning_WMV V9.wmv	3.5 MB
02_02_fields_WMV V9.wmv	4.5 MB
02_03_keys_WMV V9.wmv	3.3 MB
02_04_tables_WMV V9.wmv	4.4 MB
02_05_fields_WMV V9.wmv	6.2 MB
02_06_records_WMV V9.wmv	4.5 MB
02_07_data_WMV V9.wmv	7.3 MB
02_08_spelling_WMV V9.wmv	5.7 MB
/WMV/03/
03_01_modify_table_WMV V9.wmv	6.6 MB
03_02_find_WMV V9.wmv	4.3 MB
03_03_sort_WMV V9.wmv	5.9 MB
/WMV/04/
04_01_properties_WMV V9.wmv	5.7 MB
04_02_masks_WMV V9.wmv	5.9 MB
04_03_rules_WMV V9.wmv	9.0 MB
/WMV/05/
05_01_keys_WMV V9.wmv	5.1 MB
05_02_relationships_WMV V9.wmv	5.7 MB
05_03_refintegrity_WMV V9.wmv	4.8 MB
05_04_subdatasheets_WMV V9.wmv	4.7 MB
/WMV/06/
06_01_querywizard_WMV V9.wmv	6.1 MB
06_02_queryscratch_WMV V9.wmv	6.6 MB
06_03_querydesign_WMV V9.wmv	4.7 MB
06_04_querycount_WMV V9.wmv	2.8 MB
06_05_parameterquery_WMV V9.wmv	7.4 MB
/WMV/07/
07_01_forms_WMV V9.wmv	2.1 MB
07_02_formwizard_WMV V9.wmv	5.9 MB
07_03_formscratch_WMV V9.wmv	5.1 MB
07_04_formdesign_WMV V9.wmv	9.5 MB
07_05_subforms_WMV V9.wmv	7.1 MB
07_06_formcommands_WMV V9.wmv	7.0 MB
07_07_sortfilter_WMV V9.wmv	7.8 MB
07_08_switchboard_WMV V9.wmv	11.9 MB
/WMV/08/
08_01_reportwizard_WMV V9.wmv	5.8 MB
08_02_reportdesign_WMV V9.wmv	8.5 MB
08_03_reportcalcs_WMV V9.wmv	8.0 MB
08_04_reportformat_WMV V9.wmv	12.8 MB
08_05_reportsummary_WMV V9.wmv	9.3 MB
08_06_reportlabels_WMV V9.wmv	7.1 MB
08_07_reportprinting_WMV V9.wmv	5.0 MB
/WMV/09/
09_01_createmacro_WMV V9.wmv	5.0 MB
09_02_attachmacro_WMV V9.wmv	6.4 MB
09_03_automateinput_WMV V9.wmv	8.0 MB
09_04_validationmacro_WMV V9.wmv	7.7 MB
09_05_autoexec_WMV V9.wmv	2.8 MB
/WMV/10/
10_01_import_WMV V9.wmv	7.5 MB
10_02_packagesign_WMV V9.wmv	6.7 MB
10_03_email_WMV V9.wmv	5.8 MB
10_04_export_WMV V9.wmv	5.7 MB
/WMV/11/
11_01_charts_WMV V9.wmv	9.2 MB
11_02_pivotcharts_WMV V9.wmv	6.0 MB
/00. Introduction/
00 01. Welcome.mov	11.6 MB
00 02. Using the exercise files.mov	1.3 MB
/.../01. Formula and Function Tips-Shortcuts/
01 01. Using the entire row-column references.mov	5.5 MB
01 02. Copying column formulas instantly.mov	6.0 MB
01 03. Converting formulas to values with a simple drag.mov	5.2 MB
01 04. Creating 3D formulas to gather data from multiple sheets.mov	6.8 MB
01 05. Updating values without formulas.mov	4.0 MB
01 06. Showing all formulas with a single command.mov	8.0 MB
01 07. Highlighting formulas with two clicks.mov	5.3 MB
01 08. Simplifying debugging formulas.mov	6.5 MB
01 09. Creating range names to enhance readability.mov	8.0 MB
/.../02. Excel Functions/
02 01. Understanding and using basic Excel functions.mov	11.6 MB
02 02. Using common functions SUM, AVERAGE, MAX, and MIN.mov	7.5 MB
02 03. Using and extending AutoSum.mov	6.3 MB
/.../03. IF and Related Functions/
03 01. Exploring IF logical tests and using relational operators.mov	6.2 MB
03 02. Creating and expanding the use of nested IFs.mov	5.9 MB
03 03. Using the AND, OR, and NOT functions with IF to create compound logical tests.mov	7.4 MB
/.../04. Lookup and Reference Functions/
04 01. Looking up information with VLOOKUP and HLOOKUP.mov	7.4 MB
04 02. Using VLOOKUP for approximate matches.mov	9.8 MB
04 03. Using VLOOKUP for exact matches.mov	5.5 MB
04 04. Nesting Lookup functions.mov	4.3 MB
04 05. Finding table-like information within a function with CHOOSE.mov	4.2 MB
04 06. Locating data with MATCH.mov	6.9 MB
04 07. Retrieving information by location with INDEX.mov	3.1 MB
04 08. Using MATCH and INDEX together.mov	8.8 MB
/.../05. Power Functions/
05 01. Tabulating information on a single criterion with COUNTIF, SUMIF, and AVERAGEIF.mov	7.2 MB
05 02. Tabulating information on multiple criteria with COUNTIFS, SUMIFS, and AVERAGEIFS.mov	7.6 MB
/.../06. Statistical Functions/
06 01. Finding the middle value with MEDIAN.mov	3.8 MB
06 02. Ranking data without sorting with RANK.mov	6.4 MB
06 03. Finding the magnitude data with LARGE and SMALL.mov	2.5 MB
06 04. Tabulating blank cells with COUNTBLANK.mov	5.0 MB
/.../07. Date Functions/
07 01. Understanding Excel date-time capabilities in formulas.mov	11.9 MB
07 02. Identifying the day of the week with WEEKDAY.mov	5.0 MB
07 03. Counting working days with NETWORKDAYS.mov	3.6 MB
07 04. Determining a completion date with WORKDAY.mov	2.6 MB
07 05. Tabulating date-time differences with DATEDIF.mov	5.4 MB
/.../08. Math Functions/
08 01. Working with rounding functions.mov	13.5 MB
08 02. Finding the remainder with MOD.mov	4.9 MB
08 03. Building random number generators with RAND and RANDBETWEEN.mov	8.3 MB
08 04. Converting a value between measurement systems with CONVERT.mov	4.2 MB
/.../09. Array Formulas and Functions/
09 01. Extending formula capabilities with Arrays.mov	10.5 MB
09 02. Counting unique entries in a range with an Array formula.mov	6.8 MB
09 03. Determining frequency distributions with FREQUENCY.mov	4.7 MB
09 04. Flipping row-column orientation with TRANSPOSE.mov	4.3 MB
09 05. Building analysis via regression techniques with TREND and GROWTH.mov	3.0 MB
09 06. Combining multiple functions in arrays.mov	6.7 MB
/.../10. Text Functions/
10 01. Locating and extracting data with FIND and MID.mov	8.8 MB
10 02. Extracting specific data with LEFT and RIGHT.mov	3.7 MB
10 03. Removing excess spaces with TRIM.mov	5.3 MB
10 04. Using CONCATENATE with functions.mov	5.4 MB
10 05. Adjusting case within cells with PROPER, UPPER, and LOWER.mov	4.9 MB
10 06. Adjusting character content with REPLACE and SUBSTITUTE.mov	6.7 MB
10 07. Reviewing additional text functions.mov	10.5 MB
/.../11. Financial Functions/
11 01. Calculating payments with PMT.mov	8.8 MB
11 02. Finding future values with FV.mov	6.1 MB
11 03. Determining total amount of future payments with PV.mov	3.1 MB
/.../12. Information Functions/
12 01. Working with the IS information functions.mov	6.2 MB
12 02. Using error-checking functions ISERR, ISERROR, IFERROR.mov	9.7 MB
12 03. Getting data from remote cells with OFFSET.mov	6.4 MB
12 04. Returning references with INDIRECT.mov	13.3 MB
/13. Conclusion/
13 01. Goodbye.mov	683.4 KB
/Exercise Files/
Ex_Files_Excel07_Ad_Form.zip	803.7 KB
/
Torrent downloaded from Demonoid.me.txt	0.0 KB
Total files 490