Learning Microsoft Excel 2016 for Mac Год выпуска: 2015 Производитель: O'Reilly Media Сайт производителя: oreilly.com Автор: Guy Vaccaro Продолжительность: 5:30 Тип раздаваемого материала: Видеоурок Язык: Английский Описание: In this Learning Microsoft Excel 2016 for Mac training course, expert author Guy Vaccaro will teach you everything you need to know to be able to work in Excel 2016, including managing your own workbooks, formatting worksheets, and creating and using formulas. This course is designed for the absolute beginner, meaning no previous experience with Excel is required. You will start by learning how to manage Excel workbooks and worksheets, including creating and saving a new workbook, saving Excel files in other formats, and using the Excel 2016 templates. From there, Guy will teach you how to enter and edit data in cells. This video tutorial also covers how to use basic mathematical operators, format worksheets, and use mathematical formulas. Finally, you will cover advanced formatting and security, including activating worksheet and workbook protection and password protecting the workbook file. Once you have completed this computer based training course, you will have gained the knowledge necessary to manage your own workbooks and worksheets in Microsoft Excel 2016 for Mac. Working files are included, allowing you to follow along with the author throughout the lessons. Работа в новой версии Эксель на маках: книги, таблицы, формулы и мн. др.
Содержание
01. Your Excel 2016 Journey Starts Here 0101 Quick Introduction To The New Excel 2016 Interface 0102 Do I Need A Microsoft Account? 0103 About Your Author 0104 Using The Included Working Files 0105 How To Access Your Working Files 02. Managing Excel Workbooks And Worksheets 0101 Creating And Saving A New Workbook 0102 Opening And Closing Workbooks 0103 Saving And Opening Excel Files To And From OneDrive And iCloud 0104 Saving Excel Files In Other Formats 0105 Adding, Deleting, Moving, And Copying Worksheets 0106 Using The Excel 2016 Templates 03. Entering And Editing Data In Cells 0301 Entering Text, Numbers, And Dates 0302 Editing The Contents Of Cells 0303 Undo And Redo Your Actions 0304 Cut, Copy, And Paste 0305 Drag And Dropping Cells 0306 The Fill Handle 0307 Inserting And Deleting Rows And Columns 0308 Changing Column Widths And Row Heights 0309 Hiding And Unhiding Rows, Columns And Sheets 0310 Searching For Values In A Workbook 04. Math Basics 0401 Getting Started With Basic Mathematical Operators 0402 Order Of Operation With BODMAS 0403 Introduction To Basic Formula 0404 The New Formula Builder And Quick SUMs 0405 Copying Formula And Functions 0406 Displaying Formulae On A Worksheet 05. Formatting Worksheets 0501 Selecting Cells For Formatting 0502 Modifying Typeface, Font Size And Colors 0503 Cell Alignment, Orientation And Merging 0504 Using Number Formats 0505 Adding And Removing Borders 0506 Applying Date Formats To Cells 0507 Format Painter And Fill Formatting 0508 Clearing Cell Contents And Formatting 06. Page Setup And Printing 0601 Paper Size, Margins, Orientation And Scaling 0602 Using A Print Area And Printing Titles 0603 Using The Page Break Tools 0604 Creating Headers And Footers - Method 1 0605 Creating Headers And Footers - Method 2 0606 Other Print Options And Checking Spelling 0607 Generating A PDF From A Worksheet 07. Mathematical Formulas 0701 The SUM Function 0702 Other Mathematical Functions - AVERAGE, MIN And MAX 0703 Useful Count Functions 0704 Averages, Mean, Mode, And Median 0705 Using PI In Formula 0706 Absolute Referencing Explained 0707 Formulas Across Worksheets 0708 3D Referencing 0709 Making Use Of Named Ranges 0710 Dates, Shapes, And Formula 0711 IF Statements 08. Advanced Formatting 0801 Adding, Editing, Deleting, And Printing Comments 0802 Creating Your Own Custom List 0803 Converting To A Table For Formatting 09. Security 0901 Activate And Deactivate Worksheet And Workbook Protection 0902 Protecting Part Of A Worksheet To Aid Data Entry 0903 Password Protecting The Workbook File 10. Excel 2016 Summary 1001 What You Have Learned
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}
