Themabewertung:
  • 0 Bewertung(en) - 0 im Durchschnitt
  • 1
  • 2
  • 3
  • 4
  • 5
Excel Bootcamp A-Z | The Hands-On Excel Training
#1
[Bild: 13rz65uqawmppox8gn4ieeoc6e.jpg]

Excel Bootcamp A-Z | The Hands-On Excel Training
Published 8/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 6.13 GB | Duration: 5h 51m

Learn how to get the most out of excel



What you'll learn
You will master Excel and boost your work productivity
You will be able to create interactive dashboards using pivot tables and charts
You will be able to create impactful charts and get the most out of Excel's visualization features such as conditional formatting and sparklines
You will be able to leverage formulas and functions for your data analysis to get more insights more quickly
You will learn from hands-on exercises that make sure you are able to implement everything straight away and to ensure you will remember all new information
You will learn the most useful tips and tricks - no time is spent on trivial functionalities or examples
You will have lifetime access to the ultimate excel training, which successfully helped thousands of students master excel
You will have access to a trainer with 10+ years of training who is well-known within the analytics community

Requirements
No prior experience is needed
Any windows excel version (Excel 2007, 2010, 2013, 2016, 2019, Office 365)

Description
You want to get up and running quickly in Excel or you already know a bit and want to learn how to get the most out of this wonderful tool. Then this training is for you. With a lot of practical examples and exercises you will learn about the most important topics you need to know. From working with formulas and functions to building dashboards with pivot tables and charts.This training is what you need if you are starting with Excel, struggling with Excel or want to deepen the Excel knowledge you already have. It is a complete Excel course that will help you build one of the most crucial skills in business- Excel proficiency.But be aware! It is not another boring copy/paste training where you learn irrelevant shortcuts or explore functionalities that do not provide much value in practice. You will learn tips and tricks that make you more efficient than ever in your everyday work. With a good grasp of key features and how they can be combined you'll be able to tackle common business challenges more effectively. Topics include: Building dashboards with Pivot Tables & Charts, visualization tools such as conditional formatting and sparklines, and of course everything you need to know about formulas and functions from conditional logic with IF functions to lookup functions like XLOOKUP and INDEX MATCH.After this training you will be able to gain insights from data quicker, visualize data correctly and automate some common manual tasks. Let's go!

Overview

Section 1: Let's Get the Training Files First

Lecture 1 Download Course Files

Section 2: Getting Started with Excel | Excel Bootcamp Part 1

Lecture 2 Shortcuts for selecting data and moving around the workbook

Lecture 3 What you need to know about text, values, and dates

Lecture 4 So what options do we have for sheets, rows & columns, and cells

Lecture 5 Copy pasting data - clipboard tasks

Lecture 6 Making everything pretty with formatting

Lecture 7 Getting everything ready for printing

Section 3: Fun with Formulas & Functions | Excel Bootcamp part 2

Lecture 8 Creating a simple formula

Lecture 9 Formulas for logical comparisons

Lecture 10 Cell references: what's up with the dollar signs $

Lecture 11 Exercise: where to put the $ signs?

Lecture 12 Aggregation functions: get more done more quickly with functions

Lecture 13 Logical functions: how to handle more complex logical conditions

Lecture 14 IF function + nesting functions: if within an if, within another if

Lecture 15 Some more practice with the IF function

Lecture 16 IFS function: maybe easier?

Lecture 17 Exercise: cell references, IF function, and returning blanks

Lecture 18 Conditional calculations: COUNTIF(S)

Lecture 19 Conditional calculations: SUMIF(S), AVERAGEIF(S)

Section 4: Lookup Functions | Excel Bootcamp Part 3

Lecture 20 VLOOKUP | The basics

Lecture 21 HLOOKUP | Same logic, just the other way around

Lecture 22 XLOOKUP | New and improved version

Lecture 23 Matching data with lookup functions

Lecture 24 Approximate vs exact match

Lecture 25 Wildcards for more flexibility

Lecture 26 INDEX MATCH | How it works

Lecture 27 Row and column lookup

Lecture 28 Multiple colum lookup

Section 5: Charts and Data Visualization | Excel Bootcamp Part 4

Lecture 29 Creating charts - where it all starts

Lecture 30 Dealing with missing data and filters

Lecture 31 How to customize any chart in any way you like

Lecture 32 Best practices: making charts pretty and easier to read

Lecture 33 Saving time with chart templates

Section 6: Pivot Tables & Charts | Excel Bootcamp Part 5

Lecture 34 Why pivot tables?

Lecture 35 Preparing the data

Lecture 36 Pivot tables 101

Lecture 37 Customizing pivot tables

Lecture 38 Grouping sorting and filtering

Lecture 39 Custom calculations

Lecture 40 Pivot charts

Lecture 41 Creating a dashboard

Anyone that wants a hands-on and fun excel training that focuses on the most impactful features,Excel users that want to deepen their knowledge and see if there are more efficient ways of doing this as well as explore new functionalities,Absolute beginners that want a structured learning path to master excel within a day

Homepage

[Bild: 32bestpracticesmakingifew3.jpg]

Zitieren


Möglicherweise verwandte Themen…
Thema Verfasser Antworten Ansichten Letzter Beitrag
  Microsoft Access and Microsoft Excel Mastery Bundle 2016 Panter 0 40 14.03.2024, 23:54
Letzter Beitrag: Panter
  Master Microsoft Excel, Outlook And Word 2013 - 26 Hours Panter 0 38 14.03.2024, 23:48
Letzter Beitrag: Panter
  Microsoft Office 365 - Excel, Word, Powerpoint Und Outlook Panter 0 35 14.03.2024, 23:43
Letzter Beitrag: Panter
  Master Excel and Solve 500 Problems (Beginner - Advanced) Panter 0 41 14.03.2024, 23:37
Letzter Beitrag: Panter
  The Comprehensive Microsoft Excel Course Panter 0 36 14.03.2024, 23:26
Letzter Beitrag: Panter
  Statistics & Excel (2023) Panter 0 58 16.01.2024, 22:19
Letzter Beitrag: Panter

Gehe zu:


Benutzer, die gerade dieses Thema anschauen: 1 Gast/Gäste
Expand chat