Microsoft A Comprehensive Guide on Excel Course E-Learning
€192,39€159,00Incl. taxExcl. tax
In stock
Take an A Comprehensive Guide on Excel course E-Learning Training now online. You will learn how to enter formulas, copy calculation results and links, transpose and adjust notation.
Read more.
Bulk discount
No discount
1 Piece
€192,39€159,00
2% Discount
2 Pieces
€188,54€155,82/ Piece
3% Discount
3 Pieces
€186,62€154,23/ Piece
4% Discount
4 Pieces
€184,69€152,64/ Piece
5% Discount
5 Pieces
€182,77€151,05/ Piece
10% Discount
10 Pieces
€173,15€143,10/ Piece
15% Discount
25 Pieces
€163,53€135,15/ Piece
20% Discount
50 Pieces
€153,91€127,20/ Piece
Make a choice
Officieel examen Online of fysiek
Start nu – bekroonde e-learning Inclusief proefexamens & 24/7
ISO 9001 & 27001 werkwijze 1000+ organisaties gingen u voor
Maatwerk & gratis intake Inclusief nulmeting bij training
Product description
A Comprehensive Guide on Excel Course E-Learning
Discover the ultimate Excel course that guides you from beginner to expert! With A Comprehensive Guide on Excel Training, you will learn all the essential skills needed to work efficiently and professionally with Excel. From basic functions to advanced formulas and data visualisation, this course gives you a complete overview of all the tools and techniques you can use in your daily work.
You will receive hands-on lessons and assignments that will help you manage, analyse and present complex data. You will also learn to save time through automation and work with advanced features such as pivot tables and macros. This Excel training course is perfect for both beginners and experienced users who want to refresh or deepen their knowledge.
Enrol today and improve your Excel skills with our award-winning e-learning, including an official practice exam and personal online mentoring guidance!
Course highlights:
In-depth explanation of basic and advanced features
Practical examples and hands-on assignments
Tips to work more efficiently and save time
Full access to e-learning, practice exams and mentoring
Demo A Comprehensive Guide on Excel Course E-Learning
Course content
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()
Complete Guide to Excel 365: Pivot, PowerPivot, & Financial Modeling
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
Specifications
Article number
129378391
SKU
129378391
Language
English
Qualifications of the Instructor
Certified
Course Format and Length
Teaching videos with subtitles, interactive elements and assignments and tests
Lesson duration
9:31 Hours
Progress monitoring
Access to Material
365 days
Technical Requirements
Computer or mobile device, Stable internet connections Web browsersuch as Chrome, Firefox, Safari or Edge.
Support or Assistance
Helpdesk and online knowledge base 24/7
Certification
Certificate of participation in PDF format
Price and costs
Course price at no extra cost
Cancellation policy and money-back guarantee
We assess this on a case-by-case basis
Award Winning E-learning
Tip!
Provide a quiet learning environment, time and motivation, audio equipment such as headphones or speakers for audio, account information such as login details to access the e-learning platform.
Heeft u vragen over dit product of hulp nodig bij het bestellen? Onze AI-chatbot is 24/7 beschikbaar, of neem contact op via [email protected] of bel +31 36 760 1019
Heeft u vragen over dit product of hulp nodig bij het bestellen? Onze AI-chatbot is 24/7 beschikbaar, of neem contact op via [email protected] of bel +31 36 760 1019
Do you master Cloud Computing ? Order online and make an appointment for the Exa...
€169,40€140,00
Specifications
Article number
129378391
SKU
129378391
Language
English
Qualifications of the Instructor
Certified
Course Format and Length
Teaching videos with subtitles, interactive elements and assignments and tests
Lesson duration
9:31 Hours
Progress monitoring
Access to Material
365 days
Technical Requirements
Computer or mobile device, Stable internet connections Web browsersuch as Chrome, Firefox, Safari or Edge.
Support or Assistance
Helpdesk and online knowledge base 24/7
Certification
Certificate of participation in PDF format
Price and costs
Course price at no extra cost
Cancellation policy and money-back guarantee
We assess this on a case-by-case basis
Award Winning E-learning
Tip!
Provide a quiet learning environment, time and motivation, audio equipment such as headphones or speakers for audio, account information such as login details to access the e-learning platform.
Wij gebruiken functionele en analytische cookies om onze website goed te laten werken en het gebruik ervan te meten met Google Analytics. Er worden geen persoonsgegevens gedeeld voor advertentiedoeleinden. Door op "Accepteren" te klikken, geeft u toestemming voor het plaatsen van deze cookies.
Manage cookies