آموزش اکسل مخصوص سیستم عامل mac

<< Office 2011 v14.1.0 Mac
آموزش اکسل مخصوص سیستم عامل mac
نویسنده و تهیه کننده LYNDA
امتیاز جایزه: 0
قیمت: 0 تومان

آموزش Excel for Mac 2011 Essential Training with Curt Frye

کلاس های آنلاین اکسل کاربردی

سرفصل مطالب:

 Introduction 1m 58s
Welcome 1m 16s 
Using the exercise files 42s 
1. Getting Started with Excel 20m 56s
Exploring the Excel 2011 window 4m 16s 
Introducing the Ribbon for Mac 4m 44s 
Customizing the Ribbon 4m 20s 
Setting program preferences 3m 20s 
Getting help in Excel 4m 16s 
2. Managing Workbooks 20m 4s
Opening, creating, and saving workbooks 5m 23s 
Setting workbook properties 4m 14s 
Creating and modifying workbook templates 4m 18s 
Managing workbooks across multiple versions of Excel 6m 9s 
3. Managing Worksheets, Cells, and Cell Data 1h 2m
Selecting cells and groups of cells 4m 58s 
Copying and pasting cell data 2m 39s 
Entering data using AutoFill and other techniques 4m 32s 
Inserting symbols and special characters 5m 3s 
Creating an Excel table 4m 43s 
Locating and changing data using Find and Replace 4m 57s 
Restricting input using validation rules 4m 42s 
Using lists to limit data entered into a cell 2m 32s 
Sorting worksheet data 3m 2s 
Creating a custom sort order 3m 54s 
Filtering worksheet data 4m 6s 
Inserting, moving, and deleting cells and cell ranges 3m 50s 
Splitting and freezing rows and columns 3m 51s 
Managing worksheets 5m 28s 
Creating, editing, and deleting headers and footers 4m 41s 
4. Summarizing Data Using Formulas and Functions 1h 17m
Introducing Excel formulas and functions 3m 17s 
Adding a formula to a cell 4m 0s 
Introducing arithmetic operators 4m 13s 
Using absolute and relative cell references 6m 29s 
Controlling how Excel copies and pastes formulas 6m 5s 
Referring to Excel table data in formulas 2m 3s 
Referring to Excel table data in formulas 2m 3s 
Creating an AutoSum formula 3m 22s 
Summarizing data on the status bar 2m 22s 
Joining text in cells with concatenation 3m 59s 
Summarizing data using SUMIF and other conditional functions 5m 41s 
Creating formulas to count cells 2m 37s 
Rounding cell values up and down 4m 55s 
Finding data using VLOOKUP and HLOOKUP 6m 33s 
Auditing formulas by identifying precedents and dependents 3m 25s 
Managing Excel formula error indicators 4m 42s 
Managing scenarios 4m 59s 
Performing Goal Seek analysis 2m 31s 
5. Formatting Worksheet Elements 45m 48s
Applying fonts, background colors, and borders 6m 7s 
Applying number and date formats to cells 7m 1s 
Managing text alignment 3m 56s 
Copying cell formats 4m 2s 
Managing cell styles 3m 16s 
Managing Office themes 3m 31s 
Creating rule-based conditional formats 3m 54s 
Defining Top 10 conditional formats 4m 19s 
Defining data bar, color scale, and icon set conditional formats 6m 6s 
Editing, ordering, and deleting conditional formats 3m 36s 
6. Working with Charts 36m 55s
Creating bar and column charts 5m 26s 
Creating pie charts 2m 32s 
Creating line charts 4m 34s 
Creating XY (scatter) charts 1m 49s 
Creating stock charts 4m 11s 
Changing chart types and layouts 2m 22s 
Changing the appearance of a chart 4m 25s 
Managing chart axes and numbering 2m 51s 
Adding trendlines to charts 4m 14s 
Creating sparkline charts 4m 31s 
7. Working with External Data 18m 39s
Importing data from comma separated value (CSV) or text files 4m 20s 
Connecting to an external data source 2m 22s 
Using hyperlinks 6m 1s 
Including an Excel workbook in another Office document 3m 5s 
Linking to an Excel chart from another Office program 2m 51s 
8. Working with Objects 26m 21s
Creating and formatting shapes 3m 10s 
Adding and adjusting images 5m 38s 
Cropping, compressing, and removing image backgrounds 4m 46s 
Creating SmartArt graphics 5m 7s 
Creating WordArt 2m 34s 
Aligning and layering objects 5m 6s 
9. Exploring PivotTable Reports 29m 51s
Introducing PivotTable reports 3m 47s 
Creating a PivotTable report 4m 37s 
Pivoting a PivotTable report 3m 18s 
Managing subtotals and grand totals 3m 23s 
Summarizing more than one data field 1m 34s 
Changing the data field summary operation 2m 40s 
Changing the data field number format 2m 27s 
Filtering a PivotTable report 2m 46s 
Applying a PivotTable style 2m 20s 
Creating and editing styles 2m 59s 
10. Reviewing and Sharing Your Spreadsheets 26m 47s
Checking spelling 3m 32s 
Setting AutoCorrect and automatic Replace options 3m 59s 
Managing workbook comments 3m 40s 
Tracking and reviewing changes 5m 12s 
Printing a worksheet or workbook 3m 44s 
Setting and removing print areas 2m 31s 
Exporting to other formats 1m 33s 
Protecting a workbook 2m 36s 
11. Automating Workbooks Using Macros 23m 52s
Running an existing macro 4m 56s 
Recording a macro 3m 56s 
Recording a macro using relative references 6m 15s 
Renaming, viewing, and deleting macros 2m 58s 
Adding comments to a macro 2m 43s 
Turning off screen updating in a macro 3m 4s 
Conclusion 1m 1s
Additional resources

مشخصات
زبان آموزش انگلیسی
مدت زمان آموزش 6:32
ویرایش 2010
نوع تصویری(Multimedia)
سطح مقدماتی-متوسط
هزینه حمل دارد
اوپن کارت فارسی
فروشگاه اینترنتی محصولات آموزشی آفیس © 2016