Excel 2010 - Level 1: From Zero to Hero; Beginner-Novice Год выпуска: 2015 Производитель: Udemy Сайт производителя: udemy.com Автор: Joel Levy Продолжительность: 3:09 Тип раздаваемого материала: Видеоклипы Язык: Английский Описание: By taking this Excel For Beginners course, you will learn excel basics and other important details on your way to becoming an Expert in using Excel. Joel Levy of PC Applications with 20 years of Instructor Led Computer Training Experience will take you step by step through the entire process of creating a Worksheet with Net Income and Commission Calculations, Basic Function Calculations (including Average), and a Sales Chart as an example of how to create, save and print an Excel Workbook. Many important underlying concepts about working with Excel are explained in detail using plain simple terms. Course files are provide so you can work right along with each lesson for the "hands on experience". Along the way, you will learn about what Excel can be used for, the Excel Window and Using Tabs and Ribbons, Opening, Creating and Saving Workbooks, Excel File Types, Entering Data and Data Types, Creating Formulas and Functions, Cell Addresses and Cell Address Types, Moving and Copying Data and Formulas, Editing Data and Worksheets, Formatting Data and Worksheets, Creating Basic Charts, Proofing and Printing Including Headers and Footers in this excel for beginners. Many shortcuts are covered. This excel basics course contains 17 Lessons with almost 4 Hours of video content. Обзор Экселя 2010 для новичков.
Содержание
1 - Intro 2 - Opening Excel 3 - The Anatomy Of A Workbook 4 - The Anatomy Of A Workbook Review 5 - First Things First - Save Your New Workbook 6 - Entering Data - Text 7 - Editing Data - Text 8 - Ooops. I Made A Mistake - Undo and Redo 9 - Formatting Text - Fonts 10 - A Quick Word On Formatting 11 - Formatting - Alignment 12 - Saving Time with AutoFilling Sequences 13 - Saving Time with Format Painter 14 - Changing The Column Width 15 - Merge And Centre 16 - Entering Data - A Couple Of Shortcuts 17 - Sums - The Old Fashioned Way 18 - Sums - Using Autosum 19 - Copying Formulas 20 - SUMming Horizontally 21 - Basic Formulas - Subtraction 22 - Basic Formulas - Multiplication 23 - Basic Formulas - Division 24 - Average Function 25 - The Order Of Mathematical Operation 26 - POWER USER - Evaluate Formula Function 27 - Inserting New Columns and Rows 28 - Moving Existing Columns And Rows 29 - Cutting Copying Inserting And Deleting 30 - Hiding Columns And Rows 31 - ROUNDing 32 - Formatting Numbers 33 - A Primer In Building Complex Formulas 34 - Building A Complex Formula 35 - Sorting 36 - Wrapping Text And Soft Enter 37 - Adding A New Worksheet 38 - Creating A Simple Chart 39 - Adding Borders 40 - Customizing the Quick Access Toolbar 41 - Simple Printing 42 - Freezing For An Easier View 43 - Getting Help 44 - Filters 45 - Highlighting Cells 46 - Closing 47 - Bonus 1 - Whizzing Around Excel 48 - Bonus 2 - The Keyboard Shortcuts
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