RISPARMIA 47%
24x7 Online Access Multimedia Training
Learning247

Microsoft Excel Master Online Training Bundle

Learning247
Online
Prezzo Emagister

108 € 57 
*Prezzo Orientativo
Importo originale in GBP:
£ 90  £ 48

Informazioni importanti

Tipologia Corso
Metodologia Online
Inizio Scegli data
  • Corso
  • Online
  • Inizio:
    Scegli data
Descrizione

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.

Informazioni importanti

Prezzo per gli utenti Emagister:

Strutture (1)
Dove e quando
Inizio Luogo
Scegli data
Online
Inizio Scegli data
Luogo
Online

Cosa impari in questo corso?

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

Programma

This program covers several versions of Excel from beginner to advanced, but as an example, the topics covered (for Excel 2016) are...


PART 1 : BASICS

CHAPTER 01: MICROSOFT® EXCEL 2016 BASICS 4:04:11
  • Introduction
  • Selecting and Navigating
  • Keyboard Navigation and Basic Data Entry
  • The Ribbon
  • The Quick Access Toolbar
  • Creating a New Spreadsheet
  • Compatibility Issues
  • Cell Data & Data Types
  • Accessing Help
  • Creating Worksheet Formulas
  • Insert Functions
  • Re-using Formulas and Functions
  • Insert, Delete, & Adjust Columns & Rows
  • Find and Replace
  • Use Proofing and Research Tools
  • Apply Text Formats
  • Apply Number Formats
  • Align Cell Contents
  • Applying Styles and Themes
  • Conditional Formatting
  • Creating and Using Templates
  • Preview and Print a Notebook
  • Page Layout
  • Configure Headers and Footers
  • Managing Worksheets
  • View Options
  • Managing Workbook Properties

PART 2 : INTERMEDIATE

CHAPTER 01: FUNCTIONS 1:11:52
  • Working with Named Ranges
  • Using Named Ranges in Formulas
  • Using Specialized Functions
  • Working with Logical Functions
  • Displaying Functions/Formulas
  • Nesting Functions
  • Date and Time Functions
  • Text Functions
CHAPTER 02: DATA 32:24
  • Sorting Data
  • Filtering Data
  • Using Database Functions
  • Using Subtotals
CHAPTER 03: TABLES & CONDITIONAL FORMATTING 22:11
  • Create and Modify Tables
  • Manipulating Table Data
  • Conditional Formatting Rules
  • Using Logical Functions with Conditional Formatting
CHAPTER 04: CHARTS 28:35
  • Creating Charts
  • Modifying and Formatting Charts
  • Creating a Dual Axis Chart
  • Chart Templates
CHAPTER 05: SHAPES, TABLES, SLICERS & MORE 36:39
  • Formatting Shapes and Objects
  • Creating a PivotTable
  • Analyzing PivotTable Data
  • Pivot Charts
  • Slicers and Timelines

PART 3 : ADVANCED

CHAPTER 01: MICROSOFT® EXCEL 2016 ADVANCED 2:53:26
  • Using Links and External References
  • Using 3D References
  • Consolidating Data
  • Using Lookup Functions, Part 1
  • Using Lookup Functions, Part 2
  • Tracing Precedent and Dependent Cells
  • Watching and Evaluating Formulas
  • Comments and Track Changes
  • Comparing and Merging Workbooks
  • Accessibility Checker
  • Protecting Worksheets and Workbooks
  • Applying Data Validation
  • Search for Invalid Data
  • Working with Macros, Part 1
  • Working with Macros, Part 2
  • Creating Sparklines
  • 3D Maps
  • Data Tables
  • Using Scenarios
  • Goal Seek
  • Forecasting Data Trends
  • Changing Your Display
  • Importing Delimited Text Files
  • Data Forms and Form Controls
  • Calculated Fields and Cube Functions

* 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.