Click to turn the sound on
120 minutes
Branching Storyline
Lecture 1/8: How to Create a Drop-down List
Software

How to Confidently Use Microsoft Excel

You will learn how to…
Confidently use Microsoft Excel
Analyze financial indicators
Make stylish documents
Connect gaps in a line chart in Excel
Business Case

What is this course about?

Most of the office personnel are using Excel in one way or another. In Excel, if you know a couple of tricks you may save up to 90% of the time spent on your assignments. So now it's time to learn some of these tricks.

You will learn how to create drop-down lists for a more convenient document usage. You will learn to work with charts in a more efficient way, as well as practice formatting the tables. You will also learn to quickly delete blank rows and highlight duplicates, and lots of other Excel tips.

Each module consists of a short introduction and a soft simulation where you can practice editing tables yourself.

 

Who is this course for?

  • Everyone who works with documents
  • Business consultants
  • Analysts
  • Everyone who works with numbers and tables
  • Financial managers

Course Program

2
12:00
How to Delete Blank Rows
3
12:00
How to Connect Gaps in a Line Chart
4
12:00
How to Highlight Duplicates
5
12:00
How to Copy Formatting
6
11:00
How to Adjoin Text from Different Cells
7
12:00
How to Update Charts
8
08:00
How to Ban Changes
Get diploma