FileMood

Download Lynda.com Office 2007 Collection

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


Copyright © 2024 FileMood.com