Microsoft Excel for Mac - From Beginner to Expert in 7 Hours Год выпуска: 2015 Производитель: Udemy Сайт производителя: udemy.com Автор: Todd McLeod Продолжительность: 7:45 Тип раздаваемого материала: Видеоклипы Язык: Английский Описание: This course is for the benefit of everyone. If financial constraints prevent you from enrolling, simply send me a message and I will give you access to all of my courses for free. This training provides you everything you need to know about Microsoft Excel. From the fundamentals, to the most advanced features, after taking this online class you will be able to use Microsoft Excel at an expert level. Курс для всех по Экселю для маков.
Содержание
1.1 - 00welcome 2.1 - 01academicpricing 3.1 - 02versions 4.1 - 03videosettings 5.1 - 04locatingcoursefiles 6.1 - 05quickstartintro 7.1 - 06relativereferences 8.1 - 07absolutereferences 9.1 - 08functions 10 - Charts 11 - Calculating Your Grade 12 - Copying Data From The Web 13 - Gathering Data With Online Forms 14 - Introduction To Excel 15 - Mouse Pointer Awareness 16 - Writing Formulas 17 - Relative Absolute and Mixed References 18 - Introduction to Functions 19 - Payment Functions and Loans 20 - Create A Loan Amortization Schedule 21 - Future Value Functions and Pensions 22 - Investment Amortization 23 - Gradebook and VLookup 24 - The IF Function 25 - Conditional Formatting 26 - The IfError Function 27 - Introduction to Charts graphs 28 - The Basics of Creating Charts 29 - Chart Types 30 - Creating Charts - Pie Chart 31 - Creating Charts - Line Chart 32 - Creating Charts - Column Chart 33 - Creating Charts - Bar Chart 34 - Creating Charts - Sparklines 35 - Creating Charts - Scatter Charts 36 - Creating Charts - Area Stacked Chart 37 - Creating Charts - Combo Chart AWESOME 38 - Creating Charts - Troubleshooting Charts 39 - Creating Charts - Pivot Charts 40 - Introduction to Data 41 - Data and Excel - Google Adwords Example 42 - Extracting Data From The Web 43 - Sorting Data 44 - Filtering Data 45 - Removing Duplicates 46 - Transposing Data 47 - Freeze Panes 48 - Subtotaling Data 49 - Data Tables 50 - Introduction to Pivot Tables 51 - Creating Pivot Tables 52 - Refreshing Pivot Tables 53 - Pivot Table Examples 54 - Pivot Table Grouping 55 - Pivot Charts and Slicers 56 - Intro to Formatting 57.1 - 56contentandform 57 - Content and Form 58 - Saving Time With Templates 59 - Right-Clicking for Formatting 60 - Border and Fill 61 - Predefined Styles 62 - Formatting Tour 63 - Inserting and Formatting Images 64 - Inserting Media 65 - Arrows Circles and Shapes 66 - Textboxes and Hyperlinks 67 - Word Art 68 - Home Ribbon Formatting 69 - You Are Amazing 70 - Printing Introduction 71 - Page Layout 72 - Page Setup 73 - Headers Footers and Page Numbers 74 - Scaling Content 75 - Macros 76 - Not Creating A Macro 77 - Macros Illustrated 78 - Securing Workbooks 79 - Locking and Securing Worksheets 80 - Integrating Word and Excel 81 - Join Me In My Other Courses
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum
![[Quote]](./templates/default/images/lang/en/icon_quote.gif "Reply with quote"){kind=icon}
![[Profile]](./templates/default/images/lang/en/icon_profile.gif "View user's profile"){kind=icon}
![[PM]](./templates/default/images/lang/en/icon_pm.gif "Send private message"){kind=icon}
