Office 365 for Mac Essential Training: Excel Год выпуска: 2015 Производитель: Lynda Сайт производителя: www.lynda.com Автор: Curt Frye Продолжительность: 6h 20m Тип раздаваемого материала: Видеоурок Язык: Английский Описание: Узнайте все, что вам нужно для master самой популярной в мире программы обработки электронных таблиц - теперь доступны в любом месте с 365 подписки. Курт Frye содержится всеобъемлющий обзор Excel для Mac, в том числе манипулирования книги и ячейки данных, использование функций, печать таблиц, а также сотрудничает с другими. В последней половине курса, он охватывает более сложные методы, такие, как обобщение данных с помощью карт, работа с внешними источниками данных, добавление изображений и формы, и автоматизации рутинных задач.-Learn everything you need to master the world's most popular spreadsheet program—now accessible from anywhere with an Office 365 subscription. Curt Frye provides a comprehensive overview of Excel for Mac, including manipulating workbook and cell data, using functions, printing worksheets, and collaborating with others. In the last half of the course, he covers more complex techniques, such as summarizing data with charts, working with external data, adding images and shapes, and automating routine tasks.
Содержание
Introduction 1m 29s Welcome 55s Using the exercise files 34s 1. Getting Started with Excel 18m 22s What you can do with Excel 2016 2m 37s Exploring the Excel 2016 program window 4m 39s Introducing the Ribbon for the Mac 3m 46s Setting program preferences 4m 9s Getting help in Excel 3m 11s 2. Managing Workbooks 12m 54s Opening, creating, and saving workbooks 3m 18s Setting workbook properties 2m 45s Creating and modifying workbook templates 3m 47s Managing workbooks across multiple versions of Excel 3m 4s 3. Working with Worksheets, Cells, and Cell Data 44m 26s Selecting cells and groups of cells 3m 58s Copying and pasting cell data 3m 50s Entering data using AutoFill and other techniques 4m 7s Inserting symbols and special characters 4m 57s Creating named ranges 5m 58s Creating an Excel table 5m 9s Locating and changing data using Find and Replace 5m 54s Restricting input using validation rules 7m 25s Using lists to limit data entered into a cell 3m 8s 4. Sorting, Filtering, and Managing Worksheets 29m 4s Sorting worksheet data 3m 6s Creating a custom sort order 4m 49s Filtering worksheet data 3m 55s Inserting, moving, and deleting cells and cell ranges 4m 22s Splitting and freezing rows and columns 4m 28s Managing worksheets 5m 4s Creating, editing, and deleting headers and footers 3m 20s 5. Summarizing Data Using Formulas and Functions 42m 32s Introducing Excel formulas and functions 3m 12s Adding a formula to a cell 3m 56s Introducing arithmetic operators 4m 30s Using relative and absolute cell references 5m 47s Controlling how Excel copies and pastes formulas 4m 42s Referring to Excel table data in formulas 3m 5s Creating an AUTOSUM formula 4m 1s Summarizing data on the status bar 2m 19s Summarizing data using an IF function 4m 54s Summarizing data using SUMIF and other conditional functions 6m 6s 6. Analyzing Data and Formulas 31m 53s Creating formulas to count cells 2m 43s Rounding cell values 4m 14s Joining text in cells with concatenation 3m 45s Finding data using VLOOKUP and HLOOKUP 3m 38s Auditing formulas by identifying precedents and dependents 3m 4s Managing Excel formula error indicators 4m 27s Managing scenarios 7m 1s Performing Goal Seek analysis 3m 1s 7. Formatting Worksheet Elements 48m 13s Applying fonts, background colors, and borders 4m 50s Applying number and date formats to cells 5m 30s Managing text alignment 4m 46s Copying cell formats 3m 29s Managing cell styles 4m 10s Managing Office themes 5m 45s Creating rule-based conditional formats 4m 33s Defining top 10 conditional formats 4m 47s Defining data bar, color scale, and icon set conditional formats 6m 22s Editing, ordering, and deleting conditional formats 4m 1s 8. Working with Charts 32m 29s Creating bar and column charts 5m 8s Creating pie charts 2m 25s Creating line charts 3m 11s Creating XY (scatter) charts 2m 38s Creating stock charts 2m 42s Changing chart types and layouts 2m 29s Changing the appearance of chart elements 3m 16s Managing chart axes and numbering 2m 52s Adding trendlines to charts 3m 31s Creating sparkline charts 4m 17s 9. Working with External Data 15m 15s Importing data from comma-separated value (CSV) or text files 3m 53s Connecting to an external data source 1m 28s Using hyperlinks 4m 18s Including an Excel workbook in another Office document 3m 13s Linking to an Excel chart from another Office program 2m 23s 10. Working with Objects 30m 53s Creating and formatting shapes 5m 40s Adding and adjusting images 4m 58s Manipulating text boxes 3m 20s Cropping, compressing, and removing image backgrounds 5m 9s Creating SmartArt graphics 4m 19s Creating WordArt 2m 55s Aligning and layering objects 4m 32s 11. Exploring PivotTables 29m 14s Introducing PivotTable reports 2m 41s Creating a PivotTable report 3m 3s Pivoting a PivotTable report 3m 9s Managing subtotals and grand totals 2m 59s Summarizing more than one data field 1m 58s Changing the data field summary operation 4m 51s Changing the data field number format 1m 58s Filtering a PivotTable report 6m 9s Applying a PivotTable style 2m 26s 12. Reviewing and Sharing Your Spreadsheets 26m 55s Checking spelling 2m 55s Setting AutoCorrect and automatic Replace options 4m 31s Managing workbook comments 3m 29s Tracking and reviewing changes 4m 23s Printing a worksheet or workbook 2m 48s Setting and removing print areas 2m 38s Exporting to other formats 2m 48s Protecting a workbook 3m 23s 13. Automating Workbooks Using Macros 15m 41s Running an existing macro 4m 31s Recording a macro 2m 46s Renaming, viewing, and deleting macros 2m 40s Adding comments to a macro 2m 23s Turning off screen updating in a macro 3m 21s Conclusion 1m 13s Next steps 1m 13s
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}
