21.11.2024
Introduction to Excel
with
Ned Krastev
Go from beginner to pro in Excel with this introductory Excel course that will quickly boost your skills. Learn the most popular office productivity tool in the world
6 hours of content
168848 students
$99.00
14-Day Money-Back Guarantee
What you get:
- 6 hours of content
- 40 Interactive exercises
- 198 Downloadable resources
- World-class instructor
- Closed captions
- Q&A support
- Future course updates
- Course exam
- Certificate of achievement
Introduction to Excel
A course by
Ned Krastev
$99.00
14-Day Money-Back Guarantee
What you get:
- 6 hours of content
- 40 Interactive exercises
- 198 Downloadable resources
- World-class instructor
- Closed captions
- Q&A support
- Future course updates
- Course exam
- Certificate of achievement
$99.00
14-Day Money-Back Guarantee
What you get:
- 6 hours of content
- 40 Interactive exercises
- 198 Downloadable resources
- World-class instructor
- Closed captions
- Q&A support
- Future course updates
- Course exam
- Certificate of achievement
What You Learn
- Gain speed, reliability, and competence in Excel
- Master Excel through best practices taught by a top global instructor
- Format spreadsheets professionally to enhance look and function
- Utilize essential Excel tools like functions and pivot tables
- Design polished, professional Excel charts
- Confidently organize and structure your Excel projects
Top Choice of Leading Companies Worldwide
Industry leaders and professionals globally rely on this top-rated course to enhance their skills.
Course Description
Are you looking for Excel courses for beginners that will elevate you to pro level? Would you like to learn to work competently in Excel in just a few hours? If so, this is the perfect Excel course for you! You don’t need to spend hundreds of hours trying to learn Excel on your own. It doesn’t get any easier if you rely on Excel tutorials from specialized websites and YouTube. There is a good reason for that. The most effective way to master Excel is through comprehensive Excel training, where an industry professional guides you from the basics to advanced techniques, offering a structured, step-by-step learning experience beyond mere snippets of information. This Excel course for beginners stands out because it introduces practical tools and best practices and combines all the acquired knowledge to solve a real-world problem. We know this system works exceptionally well because hundreds of thousands of users worldwide have provided feedback and expressed satisfaction. The Excel training is ideal for recent graduates, inexperienced young professionals, and analysts a few years into their roles who need to enhance their skills and adopt best practices. No prior knowledge of Excel basics? No problem. This course efficiently guides you from the ground up. Hundreds of Excel courses are available online, but this highly popular one stands out. Instructor Ned Krastev delivers Excel lessons in a clear, friendly manner—ensuring that students can work proficiently on their own by the course's end. Ned brings practical insights from his roles at PwC, Coca-Cola, and Infineon Technologies—making him the perfect instructor for Excel beginners. With over a decade of teaching experience and millions of students globally, his courses have proven effective. Join us to master quick Excel navigation with shortcuts and popular functions like VLOOKUP, SUMIF, SUMIFS, INDEX, MATCH, and more. Gain the flexibility to create financial and data analysis reports with pivot tables and Excel functions. Format your work professionally and follow Excel best practices. Earn an Excel certificate recognized by employers and boost your resume. What sets this beginner Excel course apart from others? 1. Exceptional Content Quality Enjoy structured learning and bestselling Excel course content that thousands of students rated excellent. The curriculum distills the practical experience of the instructor and teaches you the Excel skills that allow you to perform at a high level in any corporation globally. The instructor doesn’t simply introduce you to Excel’s tools and features but also shows you how to work with them in real-world scenarios. 2. One of the Top Excel Courses Online This course is one of the most popular online Excel courses—attracting nearly a million students across major global corporations and this platform. 3. Comprehensive Downloadable Material Access essential Excel resources anytime during your learning journey, including course notes, key term flashcards, exercises, and practice exams—all included in the course. 4. Certificate of Achievement Complete the Intro to Excel coursfe and pass the exam to earn a verifiable certificate of achievement—a testament to your dedication and hard work. Click the 'Buy Now' button to embark on an incredible learning journey and invest in a career-changing opportunity.
Learn for Free
1.1 Welcome to the Course
1.2 Excel Made Easy: A Beginner's Guide to Excel Spreadsheets
1.3 Data Entry Techniques in Excel
1.5 How to Make Your Spreadsheets Look Professional
1.7 Inserting, Deleting, and Modifying Rows & Columns
1.8 Excel Formulas for Beginners
Interactive Exercises
Practice what you've learned with coding tasks, flashcards, fill in the blanks, multiple choice, and other fun exercises.
Practice what you've learned with coding tasks, flashcards, fill in the blanks, multiple choice, and other fun exercises.
Curriculum
- 1. Welcome! Course Introduction10 Lessons 34 Min
This section is fundamental for those of you who have never used Excel. We will start from the very basics: introducing the Excel ribbon, learning how to insert (and delete) rows and columns, how to perform data entry tasks, and how to format worksheets professionally. In addition, you will create your first formulas and functions, and cut, copy, and paste values for the first time.
Welcome to the Course4 minExcel Made Easy: A Beginner's Guide to Excel Spreadsheets4 minData Entry Techniques in Excel3 minHow to Make Your Spreadsheets Look Professional6 minInserting, Deleting, and Modifying Rows & Columns2 minExcel Formulas for Beginners3 minExcel Functions4 minWork Efficiently by Using Cut, Copy, and Paste2 minFormatting5 minPasting Values, Formulas and Formats with Paste Special1 min - 2. Useful Tools & Tips29 Lessons 62 Min
Once you are familiar with the basic operations in Excel, it will be time to learn Excel best practices and learn how to navigate spreadsheets professionally. In this section, you will learn how to apply fast scrolling, use keyboard shortcuts, format sheets professionally, fix cell references, use named ranges, apply custom cell formats, and much more.
Inserting a Line Break with Alt + Enter1 minDo More with Your Sales Data with Excel's Text to Columns Feature2 minCreate Easily Printable Excel Documents1 minHow to Wrap Text in Excel and Adjust a Cell's Size1 minInsert Hyperlinks into Excel Spreadsheets1 minUsing Excel's Freeze Panes to Handle Large Datasets1 minFind Excel Functionalities in a Quicker Way - Tell Me What You Want to Do1 minA Quick Introduction to Excel's Pivot Tables2 minInitial Formatting Is Key for Creating Professional-looking Spreadsheets2 minMacros Are a Great Timesaver! Here's Why3 minHow to Use the Same Macro On Multiple Workbooks2 minThe Secret to Faster Scrolling in Excel2 minBe even quicker: F5 + Enter2 minUsing Absolute and Relative Cell References2 minFind and Select Cells That Meet Specific Conditions2 minHow to Create Dynamic Names in Excel Spreadsheets1 minUsing Named Ranges to Make Formulas More Readable2 minHow to Add a Drop-down List in Excel2 minUsing Custom-sort to Sort Multiple Columns Within a Table1 minSaving Time in Excel and Doing Everything Faster by Using Excel Shortcuts4 minMultiply by 12 minFind and Replace - References3 minFind and Replace - Formatting2 minGreen References2 minBeauty Saving - The Professional Way of Saving Files2 minThe Power of F22 minConditional Formatting6 minIntroduction to Custom Cell Formatting6 minCustom Formatting - An example2 min - 3. Beginner, Intermediate & Advanced Functions17 Lessons 52 Min
Excel is one of the most popular productivity tools the business world has ever seen. The main reason for this is Excel functions. Here, you will learn how to use Excel functions like a true professional. We will start with some easier examples (SUM, COUNT, AVERAGE, IF, MAX, MIN, VLOOKUP, HLOOKUP), and gradually introduce more advanced (and more powerful) functions such as SUMIF, SUMIFS, COUNTIF, COUNTIFS, INDEX, MATCH, INDEX & MATCH, etc.
Key Excel Functions: IF3 minEnlarge the formula bar1 minKey Excel Functions: SUM, SUMIF, SUMIFS4 minKey Excel Functions: COUNT, COUNTIF, COUNTIFS4 minKey Excel Functions: AVERAGE, AVERAGEIF2 minKey Excel Functions: LEFT, RIGHT, MID, UPPER, LOWER, PROPER4 minWorking with text in Excel3 minFind the Highest and Lowest Values in a Range: MAX & MIN1 minWhen you start typing a formula1 minUse ROUND in Your Financial Models1 minExcel's Lookup Functions: VLOOKUP & HLOOKUP made easy8 minINDEX, MATCH, and Their Combination - The Perfect Substitute for VLOOKUP7 minUsing Excel's IFERROR Function to Trap Spreadsheet Errors2 minA Useful Tool for Financial Analysis - The RANK Function3 minCreate Flexible Financial Models with CHOOSE2 minGoal Seek Will Help You Find the Result You Are Looking For2 minPerform Sensitivity Analysis with Excel's Data Tables Functionality4 min - 4. Practical Exercise "Build a P&L From Scratch"16 Lessons 41 Min
It is one thing to learn how to work with Excel’s most important tools, but it is even better to apply these techniques in a practical exercise. This is what we will do here. The “Build a P&L from scratch” exercise allows you to see how everything you have learned so far can be put into practice.
Introduction to the Case Study1 minWhat You Will See Next1 minUnderstand Your Data Source Before You Start Working on It3 minOrdering the Source Worksheet2 minCreate a Code: The Best Way to Organize Your Data and Work Efficiently with It2 minLearn How to Create a Database2 minUsing Lookup Functions (Vlookup) to Fill the Database Sheet5 minUse Sumif to Complete the Database Sheet4 minUsing Index & Match as a Substitute for Vlookup4 minThe Mapping Exercise2 minMapping the Rows in the Database Sheet2 minBuilding the Structure of the P&L Sheet2 minA Practical Example of Professional Formatting in Excel3 minPopulate the P&L Sheet with Sumif3 minLearn How to Find Mistakes with Countif2 minCalculating Growth Rates in Excel3 min - 5. Introduction to Excel Charts7 Lessons 15 Min
One of the strongest features of Microsoft Excel, besides multi-layered calculations, is that it allows you to visualize data. Here, you will learn how to insert and format different types of charts that will help you make sense of numbers and figure out their trend.
Introduction to Excel Charts1 minBeginner's Guide to Inserting Charts in Excel2 minModifying Excel Charts - The Easy Way2 minMaking Your Excel Charts Sexier - Proven Tips3 minCreating a Bridge Chart in Excel 2016 - As Easy as It Gets2 minNew Ways to Visualize Your Data - Treemap Charts1 minHow to Represent Trends with Sparklines4 min - 6. Building Professional Charts in Excel4 Lessons 22 Min
Pivot Tables are capable of summarizing thousands of rows of data in just a few seconds. All you have to do is drag and drop, and you will be able to create the report you need. No functions are needed when working with Pivot Tables, which makes them popular among a large number of users.
Stacked Column Chart with a Secondary Axis6 minDoughnut Chart5 minArea Chart4 minBridge Chart7 min
Topics
Course Requirements
- No prior experience or knowledge is required. We will start from the basics and gradually build your understanding. Everything you need is included in the course
- You will need Microsoft Excel 2010, 2013, 2016, 2020, or Microsoft Excel 365
Who Should Take This Course?
Level of difficulty: Beginner
- Excel beginners
- Aspiring financial analysts and data analysts
- Graduate students who want to learn how to work with Excel professionally
Exams and Certification
A 365 Data Science Course Certificate is an excellent addition to your LinkedIn profile—demonstrating your expertise and willingness to go the extra mile to accomplish your goals.
Meet Your Instructor
Nedko earned a Master’s degree in Finance from Bocconi University (Milan, Italy) in 2012. Then, he gained valuable working experience with exciting firms like PwC Italy (Financial Advisory and M&A), Coca-Cola European Partners (Financial Analyst), and Infineon Technologies (M&A). In 2014, he published his first online course on financial modeling and valuation when he realized that creating educational materials is his true calling. The amazing students and content creators in the data science community, the 365 team, and the strong desire to build the perfect learning platform drive Nedko to continue on this exciting journey. His goal is to establish 365 Data Science as the learning platform that bridges the gap between theoretical knowledge and practical business application.
What Our Learners Say
365 Data Science Is Featured at
Our top-rated courses are trusted by business worldwide.