Course Description Our Microsoft Excel 2013 Essentials course shows you the fundamentals of entering data and creating spreadsheets, managing lists of data, creating formulas andamp; functions, formatting worksheets for print and electronic delivery, charting, data analysis, collaborating with others, automating tasks, and more.This comprehensive course uses a hands-on, engaging approach. It's as though you have one of the best Excel trainers giving you a private lesson, making concepts clear and understandable. Presenter Bob Flisser will show you not just how to use Excel, but how to be fast and efficient.When you finish this course, you won't just know Excel; you'll be an Excel rock star, and your co-workers will be jealous. You will know how to create worksheets for different types of tasks, and how to set up calculations used in different fields and professions. You'll also know how to analyze large amounts of data so they make sense, and how to format worksheets so they look polished. The best part is learning all the shortcuts that save you lots of time. Example Video Chapter 1: GETTING ACQUAINTED WITH EXCEL (51 min) If You're in a Hurry, Use a Template What's on the Screen File Management Basics Editing the Content andamp; Structure of a Worksheet Creating a Sample Worksheet Chapter 2: TECHNIQUES FOR EASIER DATA ENTRY (14 min) Using Auto Fill Selecting an Area for Faster Data Entry Using Automatic Decimals Using Flash Fill Chapter 3: MANAGING LISTS WITH EXCEL (42 min) Sorting a List of Names andamp; Addresses Formatting andamp; Editing a Table Advanced Filter Finding andamp; Replacing Data Splitting Cells Chapter 4: Basic Calculations with Formulas (46 min) How Do You Write a Formula? Adding, Subtracting andamp; Basic Number Formatting Squaring andamp; Cubing Numbers Absolutely Understand Absolute References Formatting Numbers The Order of Calculations is Critical Joining Cells Chapter 5: CALCULATING WITH FUNCTIONS (48 min) Understanding How Functions Work SUM Function andamp; AutoSum Tool Adding a Whole Worksheet with Just Two Clicks Calculating an Average Finding the Highest, Lowest andamp; Quantity of Values Inserting, Calculating andamp; Formatting Dates Automatic Subtotals Calculations across Worksheets Chapter 6: FUNCTIONS THAT MAKE DECISIONS (30 min) IF: Values that Depend on a Condition SUMIF andamp; AVERAGEIF: Sums andamp; Averages That Depend on a Condition VLOOKUP: Extract Data from a Table Chapter 7: MATH, STATISTICAL andamp; FINANCIAL FUNCTIONS (39 min) Square Roots andamp; Logarithms Correlation, Standard Deviation, Median andamp; Large Calculating Monthly Loan Payments Using Net Present Value to Evaluate an Investment Chapter 8: FORMATTING WORKSHEETS (72 min) Row andamp; Column Size andamp; Cell Alignment Using andamp; Modifying Built-in Styles Analyzing Data with Conditional Formatting Inserting andamp; Modifying Pictures Inserting Pictures from Online Sources Drawing andamp; Modifying Shapes Using Shortcuts to Draw andamp; Modify Shapes Creating Diagrams with SmartArt Chapter 9: Managing Workbooks (37 min) Arranging, Inserting, Moving andamp; Copying Worksheets Freezing Row andamp; Column Titles in Place Repeating Row andamp; Column Titles Hiding andamp; Un-hiding Rows andamp; Columns Chapter 10: DATA ANALYSIS TECHNIQUES (30 min) Goal Seek Creating Scenarios for Multiple What-Ifs Using the Quick Analysis Tool Using the Inquire Add-in to Compare Worksheets Chapter 11: CREATING CHARTS IN EXCEL (55 min) Creating Charts Instantly: Two Methods Creating a Column Chart Manually Creating a Pie Chart Manually Sparklines: Miniature Charts in Cells Setting Up a GeoFlow 3D Map Animating a GeoFlow 3D Map Chapter 12: PIVOTTABLES andamp; POWER VIEWS (42 min) Overview of PivotTables Inserting a Recommended PivotTable Creating a PivotTable Manually Modifying a PivotTable andamp; Filtering with Slicers Creating a PivotChart Creating a Power View Report Chapter 13: PRINTING A WORKSHEET (33 min) Print Layout, What Should Fit andamp; How Inserting Headers andamp; Footers Printing andamp; Print Settings Chapter 14: COLLABORATION (81 min) Writing andamp; Editing Comments Creating PDF Documents Importing andamp; Exporting Data Restricting Editing of a Workbook Protecting Workbook Structure, Finalizing andamp; Password Protection Tracking Changes Other People Make to a Workbook Saving a Workbook in SkyDrive, SharePoint, or Dropbox Allowing Others to Modify Your Open Workbook Inviting Others to Share Your Workbook Sharing a Workbook on a Social Network Share Workbooks on the Web with the Excel Button Chapter 15: AUTOMATING TASKS (31 min) Overview of Automation Installing andamp; Using Office Apps Creating Macros by Recording Keystrokes Editing Macros in Visual Basic for Applications Chapter 16: CUSTOMIZING EXCEL 2013 (24 min) Modifying the Ribbon Bar andamp; Quick Access Toolbar Setting Excel's Options Credits PACKAGE INCLUDES: Length of Subscription: 12 Months Online On-Demand Access Running Time: 7.2 Hours Platform: Windows andamp; MAC OS Level: Beginner to Intermediate Project Files: Included Learn anytime, anywhere, at home or on the go. Stream your training via the internet, or download to your computer and supported mobile device, including iPad, iPhone, iPod Touch and most Android devices. Need to train your Team? Contact Us for Discounts on Multiple Subscription Purchases.

"Unlock unparalleled value and streamline your sourcing with our incredible selection of bargain UK stockist Microsoft Excel 2013 Essentials Online Training Course deals, guaranteed to deliver products at the absolute best Microsoft Excel 2013 Essentials Online Training Course prices on the market. Forget the hassle of international shipping delays, unexpected import duties, and unreliable logistics; by choosing a UK stockist, you benefit from swift, reliable delivery directly to your doorstep, ensuring your shelves are always stocked and your customers satisfied. Our expertly curated Microsoft Excel 2013 Essentials Online Training Course deals aren't just about low Microsoft Excel 2013 Essentials Online Training Course prices; they represent a strategic advantage, allowing businesses, retailers, and astute buyers to significantly reduce their overheads, boost profit margins, and offer exceptional value to their own clientele. Capitalise on these unbeatable opportunities to acquire premium products without the premium price tag, securing the competitive edge you need in today's dynamic marketplace and transforming your purchasing into a genuine investment. " - Bargainplace UK

Microsoft Excel 2013 Essentials Online Training Course Deals From eBay and Amazon Stockists:

(A small commission is earned from sales made through eBay and Amazon links)

Search for a bargain "Microsoft Excel 2013 Essentials Online Training Course" deal on eBay or Amazon