24x7 Online Access Multimedia Training

Microsoft Excel Master Training Bundle

Learning247
Virtual

£ 120 - ($ 474.499)

Información importante

Tipología Curso
Metodología Virtual
Duración Flexible
Inicio clases A definir
  • Curso
  • Virtual
  • Duración:
    Flexible
  • Inicio clases:
    A definir
Descripción

Learn the skills every Excel user needs to know--no matter how new (or how experienced) you are. Whether you want to learn Excel 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.

Información importante
Sedes

Dónde se imparte y en qué fechas

Inicio Ubicación
A definir
Online
Inicio A definir
Ubicación
Online

¿Qué aprendes en este curso?

Excel
Excel for Accounting
Microsoft Excel
Spreadsheet
Excel Formula
Excel Sheet
Microsoft excel training
MS Excel
Spreadsheets
Excel Features

Programa académico

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 2016201320102007, 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.


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.