Have a Question? Call 0800 689 3038 or Click here to email us.
Cart 0
Excel Master Online Training Bundle

Excel Master Online Training Bundle

[ TTEXBUN ]

£120.00

Seen this product cheaper elsewhere?
We'll beat any like-for-like training quote!
CLICK HERE


Learn the skills every Microsoft Excel user needs to know--no matter how new (or how experienced) you are. Whether you want to learn Excel 2016, 2013, 2010, 2007, or upgrade from one version to the next, our expert instructors will use a hands-on, engaging approach to teach you all of Excel's powerful features . Watch a single title or watch them all, as many times as you like for an entire year--all at one low price.


Many students ask us why we create our larger bundles, when most people probably wouldn't have time to complete all the courses inside the 12 month subscription window...

Well, essentially they're created to enable you to dip in and out of multiple related programs and obtain cross-referenced knowledge; the intention is not for you to study it all or sit all the exams! With any kind of technical learning, building your background knowledge on closely related areas makes a lot of sense. Therefore, having access to a wide range of connected programs enables you to research related topics to the actual program you're studying for (often just watching the video/tutorial), enhancing your overall understanding. This is why we create the larger bundles; to build the breadth of your knowledge. Also, many IT professionals use them as reference material after certification, as we usually provide discounts on subsequent re-subscription - to enable you to have the material as a constant professional reference.

 

Topics Covered:


Chapter 1: GETTING ACQUAINTED WITH EXCEL


  •     If You're in a Hurry, Use a Template
  •     What's on the Screen
  •     File Management Basics
  •     Editing the Content & Structure of a Worksheet
  •     Creating a Sample Worksheet


Chapter 2: TECHNIQUES FOR EASIER DATA ENTRY

  •     Using Auto Fill
  •     Selecting an Area for Faster Data Entry
  •     Using Automatic Decimals
  •     Using Flash Fill


Chapter 3: MANAGING LISTS WITH EXCEL

  •     Sorting a List of Names & Addresses
  •     Formatting & Editing a Table
  •     Advanced Filter
  •     Finding & Replacing Data
  •     Splitting Cells


Chapter 4: Basic Calculations with Formulas

  •     How Do You Write a Formula?
  •     Adding, Subtracting & Basic Number Formatting
  •     Squaring & Cubing Numbers
  •     Absolutely Understand Absolute References
  •     Formatting Numbers
  •     The Order of Calculations is Critical
  •     Joining Cells


Chapter 5: CALCULATING WITH FUNCTIONS

  •     Understanding How Functions Work
  •     SUM Function & AutoSum Tool
  •     Adding a Whole Worksheet with Just Two Clicks
  •     Calculating an Average
  •     Finding the Highest, Lowest & Quantity of Values
  •     Inserting, Calculating & Formatting Dates
  •     Automatic Subtotals
  •     Calculations across Worksheets


Chapter 6: FUNCTIONS THAT MAKE DECISIONS

  •     IF: Values that Depend on a Condition
  •     SUMIF & AVERAGEIF: Sums & Averages That Depend on a Condition
  •     VLOOKUP: Extract Data from a Table


Chapter 7: MATH, STATISTICAL & FINANCIAL FUNCTIONS

  •     Square Roots & Logarithms
  •     Correlation, Standard Deviation, Median & Large
  •     Calculating Monthly Loan Payments
  •     Using Net Present Value to Evaluate an Investment


Chapter 8: FORMATTING WORKSHEETS

  •     Row & Column Size & Cell Alignment
  •     Using & Modifying Built-in Styles
  •     Analyzing Data with Conditional Formatting
  •     Inserting & Modifying Pictures
  •     Inserting Pictures from Online Sources
  •     Drawing & Modifying Shapes
  •     Using Shortcuts to Draw & Modify Shapes
  •     Creating Diagrams with SmartArt


Chapter 9: Managing Workbooks

  •     Arranging, Inserting, Moving & Copying Worksheets
  •     Freezing Row & Column Titles in Place
  •     Repeating Row & Column Titles
  •     Hiding & Un-hiding Rows & Columns


Chapter 10: DATA ANALYSIS TECHNIQUES

  •     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

  •     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 & POWER VIEWS

  •     Overview of PivotTables
  •     Inserting a Recommended PivotTable
  •     Creating a PivotTable Manually
  •     Modifying a PivotTable & Filtering with Slicers
  •     Creating a PivotChart
  •     Creating a Power View Report


Chapter 13: PRINTING A WORKSHEET

  •     Print Layout, What Should Fit & How
  •     Inserting Headers & Footers
  •     Printing & Print Settings


Chapter 14: COLLABORATION

  •     Writing & Editing Comments
  •     Creating PDF Documents
  •     Importing & Exporting Data
  •     Restricting Editing of a Workbook
  •     Protecting Workbook Structure, Finalizing & 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

  •     Overview of Automation
  •     Installing & Using Office Apps
  •     Creating Macros by Recording Keystrokes
  •     Editing Macros in Visual Basic for Applications


Chapter 16: CUSTOMIZING EXCEL

  •     Modifying the Ribbon Bar & Quick Access Toolbar
  •     Setting Excel's Options
  •     Credits

* BONUS - Titles Include All Project Files to Work Along with the Instructor


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.

If you'd like a Free Demo of this bundle then please complete the form here :

Need to train your Team? Contact Us for Discounts on Multiple Subscription Purchases.


More from this collection