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

https://www.udemy.com/course/excel_bootcamp/