Microsoft Excel: From Beginner to Expert

Microsoft Excel: From Beginner to Expert

Microsoft Excel: From Beginner to Expert

This course will help you learn, improve, and master your Excel skills

Language: english

Note: 4.8/5 (4 notes) 1,196 students  New course 

Instructor(s): Eduson Academy

Last update: 2022-04-19

What you’ll 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

 

Requirements

  • The course has no specific prerequisites.

 

Microsoft Excel: From Beginner to ExpertMicrosoft Excel: From Beginner to Expert

Description

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.

 

Who this course is for

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

 

Course content

  • How to Turn Chaotic Data into Tables Easy to Work with
    • Splitting and Merging the Text
    • Error Checking
    • Text Formatting
    • Pivot Tables
    • Conditional Formatting
    • Data Transposing
    • How to Hide and Show Columns and Rows
    • Data Grouping
    • Combining Data
  • How to Make Quick Calculations Using Excel Functions and Formulas
    • Quickly Calculate the Sum and Product
    • The Average and Percentage Increase
    • The MAX and MIN Functions
    • The FREQUENCY Function
    • Logical Functions. Part 1
    • Logical Functions. Part 2
    • What-If Analysis Tools
  • How to Automate Tasks and Speed up Work
    • Inserting a Symbol with a Keyboard Shortcut
    • Automatically Highlight an Active Row
    • The Flash Fill Function
    • How to Record and Edit Macros in Excel
    • New Features in Excel 2019
    • Employee Vacation Calendar
  • How to Create Visually Appealing Diagrams
    • Benchmark Lines
    • Overlapping Histograms
    • Diverging Stacked Bar –°harts
    • A Scatter Plot
    • Ranked Data
    • A Lollipop Chart
    • A Back to Back Chart
    • How to Use Sparklines
  • Financial Modelling in Excel
    • Overview of Sample Co business and input data. Getting started with Excel
    • Airline catering division: sales modelling
    • Airline catering division: historical cost items reconstruction
    • Airline division: costs modelling and P&L calculation
    • Event catering division modelling
    • RLH division modelling
    • Sample Co P&L modelling
    • Sample Co Cash Flow statement modelling
    • Sample Co Balance Sheet modelling, finalisation of CF statement modelling
    • Getting ready for DCF valuation
    • WACC calculation
    • DCF valuation
    • Multiples and sum of the parts valuation
    • Closing remarks and useful pieces of advice

 


Time remaining or 808 enrolls left

 

Don’t miss any coupons by joining our Telegram group 

Udemy Coupon Code 100% off | Udemy Free Course | Udemy offer | Course with certificate