Please accept cookies to help us improve this website Is this OK? Yes No More on cookies »

A Comprehensive Guide on Excel E-Learning

A Comprehensive Guide on Excel E-Learning

€ 159,00 € 192,39 Excl. tax

Take an A Comprehensive Guide on Excel course now online. You will learn how to enter formulas, copy calculation results and links, transpose and adjust notation.

Read more
Discounts:
  • Buy 2 for €155,82 each and save 2%
  • Buy 3 for €154,23 each and save 3%
  • Buy 4 for €152,64 each and save 4%
  • Buy 5 for €151,05 each and save 5%
  • Buy 10 for €143,10 each and save 10%
  • Buy 25 for €135,15 each and save 15%
  • Buy 50 for €127,20 each and save 20%
Availability:
999
Delivery time:
Order before 4:00 PM and start today.
Browse our training methods: Elearning , Application Training (and more)
Compare
  • Bestel voor 17:00 uur en start vandaag
  • Persoonlijke service van ons deskundige team
  • Veilig betalen
  • Certificaat van deelname
  • De laagste prijs garantie

A Comprehensive Guide on Excel E-Learning

Order this great A Comprehensive Guide on Excel E-Learning course online, 1 year 24/7 access to rich interactive videos, speech, practical assignments, progress monitoring through reports and tests per subject to test the knowledge directly. After the course you will receive a certificate of participation.

Course content

Complete Guide to Excel 365: Getting Started

Course: 1 Hour, 14 Minutes
Expertise Level: Beginner

Course Overview
Launching and Customizing Excel
Exploring Excel Menu Items
Copy-pasting Data and Formatting Cells
Inserting, Deleting, and Merging Cells
Applying Cell Formatting
Importing Delimited Data
Importing Fixed-width Data
Exporting Excel Workbooks
Course Summary

Complete Guide to Excel 365: Working With Charts & Sparklines

Course: 1 Hour, 17 Minutes
Expertise Level: Beginner

Course Overview
Inserting and Working With Charts
Customizing Chart Appearance
Creating Treemaps and Pie and Sunburst Charts
Creating Histograms
Using Box-and-Whisker Plots
Analyzing Scatter Plots
Plotting Maps and Combo Charts
Creating Sparklines
Customizing Sparklines
Course Summary

Complete Guide to Excel 365: Using Formatting, Styles, & Themes

Course: 1 Hour, 18 Minutes
Expertise Level: Intermediate

Course Overview
Using Worksheet Formulas and Functions
Configuring Copy-paste and AutoCorrect Options
Contrasting Notes and Comments
Using Excel Data Tables
Using Conditional Formatting
Inserting Data Bars, Color Scales, and Icon Sets
Creating Custom Conditional Formatting Rules
Constructing Complex Custom Rules
Using Styles and Themes
Course Summary

Complete Guide to Excel 365: Linking, Printing, & Protecting Workbooks

Course: 1 Hour, 21 Minutes
Expertise Level: Intermediate

Course Overview
Working With AutoSave and AutoRecover
Using Templates and the XLSTART Folder
Grouping Data Using Outline and Auto Outline
Creating External Links
Editing External Links
Controlling How Workbooks Are Printed
Customizing Headers, Footers, and Background Images
Protecting Worksheets
Protecting Workbooks
Course Summary

Complete Guide to Excel 365: Validating, Cleaning, & Performing Lookups on Data

Course: 1 Hour, 30 Minutes
Expertise Level: Intermediate

Course Overview
Using Absolute Cell References and the $ Symbol
Using the Subtotal Feature
Using the Filter Feature
Checking Conditions Using IF()
Using Conditional Aggregates
One-dimensional Lookups With VLOOKUP() and HLOOKUP()
Two-dimensional Lookups Using INDEX() and MATCH()
Cleaning Data
Parsing Strings
Performing Simple Data Validation
Performing Complex Data Validation
Course Summary

Complete Guide to Excel 365: What-If Analysis, Solver, & Analysis ToolPak

Course: 1 Hour, 36 Minutes
Expertise Level: Expert

Course Overview
Implementing What-If Analysis
Using Goal Seek
Using Solver for Complex Optimization
Calculating Simple Descriptive Statistics
Analysis ToolPak: Analyzing Matrices
Using Analysis ToolPak for Hypothesis Testing
Implementing ANOVA Using Analysis ToolPak
Analysis ToolPak: Analyzing Data Characteristics
Generating Random Numbers
Performing Linear Regression
Course Summary

Complete Guide to Excel 365: Pivot, PowerPivot, & Financial Modeling

Course: 1 Hour, 15 Minutes
Expertise Level: Expert

Course Overview
Using Relational Data Models
Detecting Relationships and Foreign Keys
Using PowerPivot for Data Modeling
PowerPivot: Detecting and Visualizing Relationships
Modeling Fixed-Income Instruments
Computing Bond Yields
Performing Net Present Value (NPV) Analysis
Course Summary

Availabilty 9:31 hours
Language English
Certificate of participation Yes
Online access 365 days
Progress monitoring Yes
Award Winning E-learning Yes
Suitable for mobile Yes

There are no reviews written yet about this product.

Reviews

There are no reviews written yet about this product.

Newsletter

Read legal restrictions here

Goud Gecertificeerde Bekroonde E-Learning

MOS Gecertificeerde Docenten

Gemiddelde beoordeling

8.7

20 jaar Ervaring

Microsoft Office 365 Incompany Trainingen

Met MOS gecertificeerde docenten, nulmetingen met deskundig advies, maatwerk, huren van laptops, naslagwerk, hand-outs, evaluaties en certificaten van deelname.

Bekijk Incompany trainingen

From our blog

Read our most recent articles

View blog