【實用商業app】Easy Training for Excel 2013|最夯免費app-綠色工廠好玩App

Get Trained on the newly released Excel 2013 in a few hours!This iPAD app is an excellent training program to speed up your learning of new Excel 2013 spreadsheet program in less than a few hours and apply to your own projects.Why learn the new features on your own if you can easily take our Microsoft Excel 2013 training app to master the new version of the most popular spreadsheet program used worldwide. Course Outline:Lesson 1: Getting Acquainted with Excel 20131.1 Introduction to Excel spreadsheet1.2 The interface of Excel 20131.3 Customizing the Quick Access toolbar1.4 Understanding the status bar1.5 Using Zoom-in and Mini toolbar1.6 Using simple keyboard keys to move aroundLesson 2: Basic Operation 2.1 Creating and Converting Workbooks 2.2 Understanding Type of Data You Enter2.3 Entering data using Enter and Tab Key2.4 Performing basic operations: edit, move, copy and delete2.5 Using AutoFill 2.6 Using Flash Fill (new)Lesson 3: Worksheet Format 3.1 Changing fonts and font styles3.2 Changing number format settings3.3 Adjusting row height and column width3.4 Hide/unhide rows and columns3.5 Applying Borders, Shading and Gradient Fill3.6 Cell Formatting3.7 Table FormattingLesson 4: Formula and Functions 4.1 Using Formulas4.2 Entering Formulas4.3 Using Sum formulas4.4 Using Sum, Average and SumIF Function4.5 VLookup functionAdvanced Level (in-app purchase only) Lesson 5: Editing Graphics 5.1 Inserting pictures5.2 Editing pictures5.3 Using SmartArt5.4 Inserting shapes5.5 Capturing a Screenshot5.6 Overlapping, grouping,& hiding graphicsLesson 6: Chart Design 6.1 Inserting Charts6.2 Changing Chart Elements6.3 Changing Source Data6.4 Changing Layouts and Styles6.5 Formatting Chart Elements6.6 Enhancing a ChartLesson 7: Managing Data Lists and Pivot Table Report7.1 Creating and Filtering a Data List7.2 Using Sort & Filter7.3 Using Subtotal7.4 Creating PivotTable Report Lesson 8: Automating Tasks with Macros8.1 Installing Developer Tab8.2 Recording Macro8.3 Editing Macro8.4 Macro Security Lesson 9: Helpful Keyboard shortcuts and hints9.1 Creating Excel Spreadsheet/chart in Word and PowerPoint9.2 Using Keyboard Shortcuts9.3 Helpful Hints