Microsoft Excel: From Beginner to Expert

Microsoft Excel: From Beginner to Expert, available at $19.99, has an average rating of 4.45, with 50 lectures, based on 47 reviews, and has 2077 subscribers.

You will learn about Make pivot tables and work with formulas Quickly transfer data from other tables and files Use advanced techniques and create your own formulas Build informative graphs and diagrams to impress the management and clients This course is ideal for individuals who are Anyone who wants to learn the Excel basics or improve their Excel skills. It is particularly useful for Anyone who wants to learn the Excel basics or improve their Excel skills.

Enroll now: Microsoft Excel: From Beginner to Expert

Summary

Title: Microsoft Excel: From Beginner to Expert

Price: $19.99

Average Rating: 4.45

Number of Lectures: 50

Number of Published Lectures: 50

Number of Curriculum Items: 50

Number of Published Curriculum Objects: 50

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

Make pivot tables and work with formulas
Quickly transfer data from other tables and files
Use advanced techniques and create your own formulas
Build informative graphs and diagrams to impress the management and clients

Who Should Attend

Anyone who wants to learn the Excel basics or improve their Excel skills.

Target Audiences

Anyone who wants to learn the Excel basics or improve their Excel skills.

Excel is used for many purposes in various fields. For example, one can enter, edit, store and sort, data, perform calculations, track anything, use it as a calendar and schedule events, create charts, diagrams, etc. All of the aforementioned actions will be easy for you after taking our Excel course.

In this course, you will learn and practice Microsoft Excel most important functions and features. Course curriculum includes topics that are in great demand and essential for those whose work or studies require basic Excel skills. You are going to study how to apply Conditional Formatting, hide and show columns and rows, split and merge cells, create pivot tables, group and transpose data, use statistical and logical functions, and many more. Additionally, you will be able to practice what you have learned: download the homework, complete it, and go to the Key tab. In case you have any questions, feel free to contact us. Our support team representatives will be happy to help you.

Still not sure whether you need this course? In our experience, improving your Excel skills offers many advantages. For example, mastering Excel will speed up your work at least 2 times, make you an independent Excel user, and help you get promoted quickly.

Course Curriculum

Chapter 1: How to Turn Chaotic Data into Tables Easy to Work with

Lecture 1: Splitting and Merging the Text

Lecture 2: Find and Remove Duplicates in Excel

Lecture 3: Error Checking

Lecture 4: Text Formatting

Lecture 5: Pivot Tables

Lecture 6: Conditional Formatting

Lecture 7: Data Transposing

Lecture 8: How to Hide and Show Columns and Rows

Lecture 9: Data Grouping

Lecture 10: Combining Data

Chapter 2: How to Make Quick Calculations Using Excel Functions and Formulas

Lecture 1: Quickly Calculate the Sum and Product

Lecture 2: The Average and Percentage Increase

Lecture 3: Calculating the Sum by Criteria

Lecture 4: The VLOOKUP Function

Lecture 5: The MAX and MIN Functions

Lecture 6: The FREQUENCY Function

Lecture 7: Logical Functions. Part 1

Lecture 8: Logical Functions. Part 2

Chapter 3: How to Build Financial Models and Forecast Results

Lecture 1: What-If Analysis Tools

Lecture 2: Goal Seek and Scenario Manager

Lecture 3: Solver Add-in

Chapter 4: How to Automate Tasks and Speed up Work

Lecture 1: Inserting a Symbol with a Keyboard Shortcut

Lecture 2: Automatically Highlight an Active Row

Lecture 3: The Flash Fill Function

Lecture 4: How to Record and Edit Macros in Excel

Lecture 5: New Features in Excel 2019

Chapter 5: How to Make Convenient Plans, Schedules and Calendars in Excel

Lecture 1: Employee Vacation Calendar

Lecture 2: Dates and Deadlines Auto Highlighting

Chapter 6: How to Create Visually Appealing Diagrams

Lecture 1: Benchmark Lines

Lecture 2: Overlapping Histograms

Lecture 3: Diverging Stacked Bar Сharts

Lecture 4: A Scatter Plot

Lecture 5: Ranked Data

Lecture 6: A Lollipop Chart

Lecture 7: A Back to Back Chart

Lecture 8: How to Use Sparklines

Chapter 7: Financial Modelling in Excel

Lecture 1: Overview of Sample Co business and input data. Getting started with Excel

Lecture 2: Airline catering division: sales modelling

Lecture 3: Airline catering division: historical cost items reconstruction

Lecture 4: Airline division: costs modelling and P&L calculation

Lecture 5: Event catering division modelling

Lecture 6: RLH division modelling

Lecture 7: Sample Co P&L modelling

Lecture 8: Sample Co Cash Flow statement modelling

Lecture 9: Sample Co Balance Sheet modelling, finalisation of CF statement modelling

Lecture 10: Getting ready for DCF valuation

Lecture 11: WACC calculation

Lecture 12: DCF valuation

Lecture 13: Multiples and sum of the parts valuation

Lecture 14: Closing remarks and useful pieces of advice

Instructors

Eduson Academy
Learning. Better.

Rating Distribution

1 stars: 0 votes
2 stars: 1 votes
3 stars: 3 votes
4 stars: 11 votes
5 stars: 32 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu