Cursusinhoud

Complete Guide to Excel 365: Getting Started

Course: 1 Hour, 14 Minutes

• 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

• 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

• 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

• 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

• 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

• 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

Course: 1 Hour, 15 Minutes

• 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

Begin vandaag met jouw Excel-reis!

✔️ Flexibel leren: Bestudeer op je eigen tempo met uitgebreide interactieve video’s.
✔️ Kennis toetsen: Test je voortgang met quizzen en praktijkgerichte opdrachten.
✔️ Professionele certificering: Ontvang een certificaat van deelname bij afronding van de training.
✔️ Direct toepasbare kennis: Gebruik wat je leert meteen in jouw werk of studie.

Bestel nu jouw cursus en word een expert in Excel!