Money Back

Learn Microsoft Excel 2016 with interactive features and Hands-on lab. You will learn from basic to advanced level of Excel spreadsheet training. Learn Microsoft Excel 2016 Interactive Training Course - Basic to Advanced User Learn Microsoft Excel 2016 Interactive Training with Windows 10 Course Click image to enlarge Description Excel 2016 Training CD Course with Interactive Exercise and Hands-on LabsSpecial Bonus: Essential Windows 10 Operating system Training Course Product Features: Learn Microsoft Excel 2016 in less time and more effective than other training methods. New! Classroom approach: Learn each topics, practice with interactive exercises and Hands-on Labs. Come with practice files that the user can use along with the instructor - the best way to learn how to use Excel. Break down complex features into easy smaller topics to understand and go over the topics later. Learn Excel New Ribbon Interface and how to create spreadsheets with formulas, graphs, charts, and much more! Master these special functions - VLookup, Auto Fill and Flash Fill and many more! Exclusive Features: Helpful captions and clear narrations for you to follow along Practice with interactive exercises Take the Hands-on Labs to reassure what you have learned Level: Beginner to Intermediate Lesson 1: Getting started with Excel 2016 Introduction to Excel spreadsheet Getting familar with New Interface of Excel 2016 Customizing the Quick Access toolbar Understanding the Status Bar Using Zoom-in and Mini Toolbar Using simple keyboard keys to move around Lesson 2: Basic Operation Creating and Converting Workbooks Understanding Type of Data Entering Data using Enter and Tab Performing basic operations: edit, move, copy and delete Entering Data using AutoFill Using Flash Fill and adding comments to the cell Lesson 3: Formatting Sheets, Cells and Tables Changing Font Settings of a Cell Applying Number Formats Adjusting row height and column width Hiding/unhiding rows and columns Applying Borders, Shading and Gradient Fill Using cell formatting Using Table Formatting Lesson 4: Formulas and Functions Using Formulas Entering Formulas Using Sum Formulas Using Sum, Average and SumIF Function Using Vlookup Function Lesson 5: Editing Graphics Inserting pictures Editing pictures Using SmartArt Inserting shapes Overlapping, grouping,& hiding graphics Capturing a Screenshot Lesson 6: Chart Design Inserting Charts Adding Chart Elements Changing Source Data Changing Chart Layout and Format Formatting Chart Elements Enhancing a chart Hierarchical and Statistical Charts Using 3D Maps Creating Sparklines Lesson 7: Managing Data Lists and Pivot Table Report Creating and Filtering a Data List Using Sort & Filter Using Subtotal Creating PivotTable Report Lesson 8: Automating Tasks with Macros Installing Developer Tab Recording Macro Editing Macro Macro Security Lesson 9: Helpful Keyboard shortcuts and hints Creating Excel Spreadsheet/chart in Word and PowerPoint Using Keyboard Shortcuts Helpful Hints Lesson 10: Using Excel for Financial Analysis Analyzing a potential investment Setting up an integrated Budgets Based Upon a Series of Assumptions Creating Pro-Forma Financial Statements from Your Budgets Analyzing Financial Ratios, Contribution Margin and Breakeven Point Bonus - Microsoft Windows 10 Essential Training Course: Lesson 1: Getting started in Windows 10Lesson 2: Working with Start MenuLesson 3: Mastering Basic Windows 10 SkillsLesson 4: Using AppsLesson 5: Exploring File ExplorerLesson 6: Running Applications Content: DVD-ROM (We will ship the DVD-ROM as default) You can insert this DVD-ROM into your Windows-based Computer with CD/DVD Drive. Content: USB Thumb Drive (we ship this as optional unless you request this) ++ These training courses can be stored in USB thumb drive so you can run on any web browsers, such as Edge, chrome, firefox or Safari. You can pay extra $10 for this special USB thumb drive option. System Requirements: Windows 11, 10, 8, 7, Vista and XP CD or DVD Drive Pictures sell! Auctiva offers Free Image Hosting and Editing.300+ Listing Templates! Auctiva gets you noticed! Attention Sellers - Get Templates Image Hosting, Scheduling at Auctiva.com. Track Page Views With Auctiva's FREE Counter