Excel Efficiency Essentials
From finance professionals to fashion designers, Excel is one of today’s most critical productivity tools, spanning all industries. Beat the fear of Excel’s complexity with this short, free taster course. Master the fundamentals and become more efficient at work.
3
Hours to Complete
5
Topic
11
Practical exercises
Free Course - Excel Efficiency Essentials includes
- Intro to Excel and Interface
- The Ribbon
- Shortcut Basics – Accelerator Keys
- Setting Up – Excel Options
- Cell Navigation, Editing, Selecting and Copying
- Font
- Cell Borders and Fill
- Colours
- Alignment
- Numbers – Percent, Currency, Date, Etc
- Styles
- Cell size
- Standard Formatting
- Often Used
- Intro to Formulas
- Avoid Hardcodes in Formulas
- Intro to Functions and Syntax – SUM Function
- COUNT Function
- MIN Function
- MAX Function
- AVERAGE Function
-
IF Function
-
SUMPRODUCT Function
- Intro to Naming Cells
- Creating Names Using the Mouse
- Creating and Editing Names Using Name Manager
Free Course - Excel Efficiency Essentials
| completion-certificate
Excel Efficiency Essentials
3
Hours
11
Practical exercises
Start learning Excel like the top investment bankers. Become comfortable with the interface basics before learning the functions that can maximize your efficiency. Work smarter and faster with essential shortcuts. Understand formatting techniques, basic formulas and more.
Menu and Shortcuts and Basics
21 video minutes
Video minutes 21
Excel Exercises 0
Basic Formatting
27 video minutes
1 excel exercises
Video minutes 27
Excel Exercises 1
Basic Formulas and Calculations
18 video minutes
3 excel exercises
Video minutes 18
Excel Exercises 3
Basic Functions
28 video minutes
4 excel exercises
Video minutes 28
Excel Exercises 4
Naming Cells and Referencing
9 video minutes
3 excel exercises
Video minutes 9
Excel Exercises 3
Learn from our expert instructors
Learn more about our full faculty
Wall Street Recognized Certification
Established on Wall Street, Financial Edge has taught at the biggest bulge-bracket firms since 2016, and now we offer that very same training online for you. It’s no secret that banking is fiercely competitive, which is why our Wall Street recognized certification is designed to let your employers know you have the skills to succeed.
What Our Students Say
Get Free Course - Excel Efficiency Essentials Completion Certificate
Free Plan
Get access to all our free learning materials, from videos to workouts.
- All free course content including practical exercises and quizzes
Boost Plan
Includes full access to all certified courses.
- 266+ hours of instructor-led learning
- Search across 480+ playlists, 4000+ videos and Q&As
- Role-focused pathways
- Expert instructor support
Pro Plan
Full Felix access including all learning content and data features.
- Everything in the Boost plan
- Streamlined company data
- Current and historic filings for over 7000 companies
- Market and industry data
- Ready-to-use sector and transaction models
Compare plans
| Free Plan | Boost Plan | Pro Plan | |
|---|---|---|---|
| Completion certificates | 4 | 42 | 42 |
| Skills certificates | 59 | 59 | |
| Micro-degrees | 12 | 12 | |
| Lifetime access to course | |||
| Expert instructor support | |||
| Practical exercises to work alongside videos and quick quizzes to test your understanding | |||
| Searchable library of 480+ playlists, 4000+ videos and Q&As | |||
| 12 role-based learning pathways, including Investment Banking, Equity Research, Sales and Trading and more | |||
| Weekly live webinars | |||
| Streamlined company data (WACC. & EV bridge calculator, custom comparables) | |||
| Current and historic filings for over 7000 firms globally | |||
| Current and historic filings for over 4000 US firms | |||
| Link to, label and share data points in filings (limited to 10 for Free and Boost users, unlimited for Pro) | |||
| Regional and industry data sets | |||
| Ready-to-use sector and transaction models | |||
Frequently Asked Questions
What tech do I need?
Is it right for me?
Are Financial Edge's courses credible?
Will the Excel Efficiency Essentials help me get a job?
How long do I have to complete the Excel Efficiency Essentials ?
Are there any hidden costs?
What support will I get along the way?
What is the difference between a Felix subscription and buying a single course?
