Microsoft Excel Beginners & Intermediate Excel Training
Focused View
365 Careers
3:16:34
132 View
001 What Does the Course Cover.mp4
05:30
002 Behavoiroal-Interview-QUESTIONS-2-.pdf
003 FREE-GIFT-2.pdf
001 02-6-Overview-of-Excel-Exercise-Text.xlsx
001 02-6-Overview-of-Excel-Solved.xlsx
001 Introduction-to-Excels-basic-features.pdf
001 Overview of Excel.mp4
03:34
002 02-8-The-Ribbon-Exercise-Text.xlsx
002 02-8-The-Ribbon-Solved.xlsx
002 Introduction-to-Excels-basic-features.pdf
002 The Excel Ribbon.mp4
02:43
003 8.Basic-Manipulations-Exercise-Solved.xlsx
003 8.Basic-Manipulations-Exercise-Unsolved.xlsx
003 8.Basic-Manipulations-Lecture.xlsx
003 Introduction-to-Excels-basic-features.pdf
003 Working with Rows & Columns.mp4
01:49
004 10.Data-Entry-Exercise-Solved.xlsx
004 10.Data-Entry-Exercise-Unsolved.xlsx
004 10.Data-Entry-Lecture.xlsx
004 Data Entry in Excel.mp4
03:00
004 Introduction-to-Excels-basic-features.pdf
005 11.Formatting-Exercise-Solved.xlsx
005 11.Formatting-Exercise-Unsolved.xlsx
005 11.Formatting-Lecture-Solved.xlsx
005 11.Formatting-Lecture-Unsolved.xlsx
005 Introduction to Formatting.mp4
05:52
005 Introduction-to-Excels-basic-features.pdf
006 12.Formulas-Exercise-Solved.xlsx
006 12.Formulas-Exercise-Unsolved.xlsx
006 12.Formulas-Lecture-Solved.xlsx
006 12.Formulas-Lecture-Unsolved.xlsx
006 Creating Formulas in Excel.mp4
03:01
006 Introduction-to-Excels-basic-features.pdf
007 13.Functions-Exercise-Solved.xlsx
007 13.Functions-Exercise-Unsolved.xlsx
007 13.Functions-Lecture-Solved.xlsx
007 13.Functions-Lecture-Unsolved.xlsx
007 Introduction-to-Excels-basic-features.pdf
007 Microsoft Excel at Its Best - Functions.mp4
03:50
008 14.Copy-Cut-Paste-Exercise-Solved.xlsx
008 14.Copy-Cut-Paste-Exercise-Unsolved.xlsx
008 Introduction-to-Excels-basic-features.pdf
008 Work Efficiently By Using Cut, Copy & Paste.mp4
02:15
009 10.Format-cells-after.xlsx
009 10.Format-cells-before.xlsx
009 Format Cells.mp4
05:24
010 15.Paste-Special-Exercise-Solved.xlsx
010 15.Paste-Special-Exercise-Unsolved.xlsx
010 Pasting Values, Formulas and Formats with Paste Special.mp4
01:16
001 18.Formatting-a-Worksheet-Exercise-Solved.xlsx
001 18.Formatting-a-Worksheet-Exercise-Unsolved.xlsx
001 18.Formatting-a-worksheet-Lecture-Solved.xlsx
001 18.Formatting-a-worksheet-Lecture-Unsolved.xlsx
001 This Is How You Can Start Formatting Your Sheets in a Professional Way.mp4
02:05
001 Useful-Tips-Tools.pdf
002 Fast Scrolling That Would Allow You to Be 3x Faster.mp4
01:41
002 Useful-Tips-Tools.pdf
003 21.Fixing-Cells-Exercise-Solved.xlsx
003 21.Fixing-Cells-Exercise-Unsolved.xlsx
003 21.Fixing-references-Lecture-Solved.xlsx
003 21.Fixing-references-Lecture-Unsolved.xlsx
003 Fixing Cell References Properly.mp4
02:20
003 Useful-Tips-Tools.pdf
004 22.Alt-Enter-Exercise-Solved.xlsx
004 22.Alt-Enter-Exercise-Unsolved.xlsx
004 22.Alt-Enter-Lecture-Solved.xlsx
004 22.Alt-Enter-Lecture-Unsolved.xlsx
004 Useful-Tips-Tools.pdf
004 Using the Alt plus Enter combination.mp4
00:54
005 23.Text-to-Columns-Exercise-Solved.xlsx
005 23.Text-to-Columns-Exercise-Unsolved.xlsx
005 23.Text-to-columns-Lecture-Solved.xlsx
005 23.Text-to-columns-Lecture-Unsolved.xlsx
005 Learn How to Organize Your Excel Data with Text to Columns.mp4
02:05
005 Useful-Tips-Tools.pdf
006 24.Wrap-Text-Exercise-Solved.xlsx
006 24.Wrap-Text-Exercise-Unsolved.xlsx
006 24.Wrap-text-Lecture-Solved.xlsx
006 24.Wrap-text-Lecture-Unsolved.xlsx
006 Useful-Tips-Tools.pdf
006 Wrapping Text in Excel.mp4
00:48
007 25.Set-Print-Area-Lecture-Solved.xlsx
007 25.Set-Print-Area-Lecture-Unsolved.xlsx
007 Create Easily Printable Documents by Using Set Print Area.mp4
01:18
007 Useful-Tips-Tools.pdf
008 26.Select-Special-F5-Exercise-Solved.xlsx
008 26.Select-Special-F5-Exercise-Unsolved.xlsx
008 26.Select-Special-Lecture.xlsx
008 Find and Select Special Types of Cells with Select Special (F5).mp4
01:45
008 Useful-Tips-Tools.pdf
009 27.Assigning-Dynamic-Names-Exercise-Solved.xlsx
009 27.Assigning-Dynamic-Names-Exercise-Unsolved.xlsx
009 27.Dynamic-Naming-Lecture-Solved.xlsx
009 27.Dynamic-Naming-Lecture-Unsolved.xlsx
009 Learn How to Assign Dynamic Names within a Model.mp4
01:27
009 Useful-Tips-Tools.pdf
010 28.Defining-a-Named-Range-Exercise-Solved.xlsx
010 28.Naming-ranges-Lecture-Solved.xlsx
010 Excel Formulas that Make Sense - Named Ranges.mp4
01:39
010 Useful-Tips-Tools.pdf
011 Completing 33% of the course.html
012 19.Custom-formatting-after.xlsx
012 19.Custom-formatting-before.xlsx
012 Introduction to Custom Formatting.mp4
06:14
013 Assigning Custom Formats to Specific Cells (Ex. Multiples).mp4
01:43
013 Useful-Tips-Tools.pdf
013 Useful-tips-and-tools-Excel-file.xlsx
014 30.Creating-a-Macro-Lecture-Solved.xlsx
014 30.Macros-Exercise-Unsolved.xlsx
014 Execute 50 Commands with a Single Click - Excel Macros.mp4
03:04
014 Useful-Tips-Tools.pdf
015 Create a Drop-Down List by Using Data Validation.mp4
01:58
015 Useful-Tips-Tools.pdf
016 33.Sort-data-Lecture-Unsolved.xlsx
016 Useful-Tips-Tools.pdf
016 Using Custom Sort in Order to Sort Multiple Columns within a Table.mp4
01:28
017 34.Hyperlinks-Exercise-Solved.xlsx
017 34.Hyperlinks-Exercise-Unsolved.xlsx
017 Create a Great Index Page at the Beginning of Your Financial Models.mp4
02:05
017 Useful-Tips-Tools.pdf
018 35.Freeze-Panes-Lecture-Solved.xlsx
018 35.Freeze-Panes-Lecture-Unsolved.xlsx
018 Freeze the Title Row of Your Table - Freeze Panes.mp4
01:17
018 Useful-Tips-Tools.pdf
019 Excels Tell Me Search Bar.mp4
00:46
019 Useful-Tips-Tools.pdf
019 Useful-tips-and-tools-Excel-file.xlsx
001 Beginner-to-Pro-in-Excel-Shortcuts.pdf
001 Beginner-to-Pro-in-Excel-Shortcuts-for-MAC.pdf
001 Keyboard Shortcuts Save LOTS of time in Excel.mp4
04:38
001 A helpful consideration.html
002 05-38-Counts-Exercise-Text.xlsx
002 05-38-Counts-Solved.xlsx
002 Key Functions in Excel COUNT, COUNTA, COUNTIF, COUNTIFS.mp4
04:06
003 48.Sum-Sumif-Sumifs-Exercise-Solved.xlsx
003 48.Sum-Sumif-Sumifs-Exercise-Unsolved.xlsx
003 48.Sum-Sumif-Sumifs-Lecture-Solved.xlsx
003 Key Functions in Excel SUM, SUMIF, SUMIFS.mp4
04:24
004 51.Average-Averageif-Lecture-Solved.xlsx
004 51.Average-Averageif-Lecture-Unsolved.xlsx
004 Key Excel Functions AVERAGE & AVERAGEIF.mp4
01:59
005 Completing 50% of the course.html
006 52.Text-Functions-Lecture-Solved.xlsx
006 52.Text-Functions-Lecture-Unsolved.xlsx
006 52.Text-functions-Exercise-Solved.xlsx
006 52.Text-functions-Exercise-Unsolved.xlsx
006 Excel-Functions.pdf
006 Working with Text in Excel LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE.mp4
04:29
007 54.MIN-MAX-Exercise-Solved.xlsx
007 54.MIN-MAX-Exercise-Unsolved.xlsx
007 54.Max-min-Lecture-Solved.xlsx
007 54.Max-min-Lecture-Unsolved.xlsx
007 Excel-Functions.pdf
007 Find the Highest and the Lowest Values in a Range MAX & MIN.mp4
00:52
008 55.Excel-functions-Lecture.xlsx
008 Excel-Functions.pdf
008 Include ROUND in Your Financial Models.mp4
01:01
009 56.Vlookup-Hlookup-Exercise-Solved.xlsx
009 56.Vlookup-Hlookup-Lecture-Solved.xlsx
009 56.Vlookup-Hlookup-Lecture-Unsolved.xlsx
009 Transferring Data Efficiently VLOOKUP & HLOOKUP.mp4
07:47
010 58.Index-Match-Exercise-Solved.xlsx
010 58.Index-Match-Exercise-Unsolved.xlsx
010 58.Index-Match-Lecture-Solved.xlsx
010 58.Index-Match-Lecture-Unsolved.xlsx
010 Use INDEX & MATCH as a Substitute of VLOOKUP.mp4
07:27
011 9.xlookup-lecture-after.zip
011 9.xlookup-lecture-before.zip
011 The Perfect VLOOKUP Substitute XLOOKUP (Office 365 Only).mp4
06:40
012 60.Iferror-Exercise-Solved.xlsx
012 60.Iferror-Exercise-Unsolved.xlsx
012 60.iferror-lecture-solved.zip
012 60.iferror-lecture-unsolved.zip
012 Excel-functions.xlsx
012 IFERROR Allows You to Deal Easily with Error Mesages.mp4
01:43
013 65.Pivot-Tables-Exercise-Solved.xlsx
013 65.Pivot-Tables-Exercise-Unsolved.xlsx
013 65.pivot-tables-lecture-solved.zip
013 65.pivot-tables-lecture-unsolved.zip
013 Excels Dynamic & Interactive Tables Pivot Tables.mp4
02:17
014 62.Choose-Exercise-Solved.xlsx
014 62.Choose-Exercise-Unsolved.xlsx
014 62.Choose-Lecture-Solved.xlsx
014 62.Choose-Lecture-Unsolved.xlsx
014 Create Flexible Financial Models with the CHOOSE Function.mp4
02:25
015 63.Goal-Seek-Exercise-Solved.xlsx
015 63.Goal-Seek-Exercise-Unsolved.xlsx
015 63.Goal-Seek-Lecture-Solved.xlsx
015 63.Goal-Seek-Lecture-Unsolved.xlsx
015 Find the Result that You Are Looking For with Goal Seek.mp4
02:17
016 64.sensitivity-analysis-exercise-solved.zip
016 64.sensitivity-analysis-lecture-unsolved.zip
016 Include Sensitivity Analysis In Your Model Through Data Tables.mp4
04:10
001 Introduction to Charts in Excel 2016.mp4
01:11
002 2.inserting-charts.zip
002 Inserting Charts in Excel & Learning About the Various Chart Types.mp4
02:10
003 3.formatting-a-chart.zip
003 Formatting of Excel Charts (12).mp4
02:29
004 Formatting of Excel Charts (22).mp4
03:10
004 Formatting-Charts.xlsx
005 Bridge-Charts.xlsx
005 Creating a Bridge Chart in Excel 2016 - As Easy As It Gets.mp4
01:42
006 An Easy Way to Create a Treemap.mp4
01:31
006 Treemap-Charts.xlsx
007 Sparklines.xlsx
007 Use Sparklines to Show Data Trends.mp4
03:52
001 Introduction to the Case Study.mp4
00:51
002 This Is the data that we will use for our Exercise.mp4
02:42
003 4.order-a-worksheet-after.zip
003 4.order-a-worksheet-before.zip
003 Lets Reorder our Excel sheet and create a clear structure.mp4
02:16
004 5.creating-a-code-after.zip
004 5.creating-a-code-before.zip
004 Introducing a Code The best way to work with large amounts of data.mp4
01:59
005 6.creating-a-database-after.zip
005 6.creating-a-database-before.zip
005 Finishing Touches of our Database.mp4
01:58
006 7.vlookup-after.zip
006 7.vlookup-before.zip
006 Using Vlookup in Order to Transfer Data.mp4
05:29
007 8.sumif-after.zip
007 8.sumif-before.zip
007 Applying Sumif in Order to Populate the Database with Numbers.mp4
04:06
008 9.index-match-after.zip
008 9.index-match-before.zip
008 Demonstrating How Index & Match Can Successfully Replace Vlookup.mp4
03:51
009 9a.xlookup-after.zip
009 9a.xlookup-before.zip
009 Substituting VLOOKUP with XLOOKUP (Office 365 Only).mp4
02:53
010 10.mapping-after.zip
010 10.mapping-before.zip
010 Mapping the Items Within Our Database - A Key Exercise For Financial Analysts.mp4
02:16
010 Mapping-exercise-explained.pdf
011 11.building-a-p-l-after.zip
011 11.building-a-p-l-before.zip
011 Creating the Structure of the P&L Statement.mp4
02:21
012 12.formatting-a-p-l-before.zip
012 12.formatting-the-p-l-after.zip
012 Time for Some Formatting! The Secret of Creating Awesome Looking Excel Sheets.mp4
03:17
013 13.formatting-the-p-l-after.zip
013 13.formatting-the-p-l-before.zip
013 Populating the P&L sheet with figures.mp4
02:47
014 14.countif-after.zip
014 14.countif-before.zip
014 How do We Find Mistakes in the easiest way possible.mp4
02:15
015 15.adding-variations-after.zip
015 15.adding-variations-before.zip
015 Finishing Touches Calculating Year-on-Year Growth and Percentage Incidence.mp4
03:08
015 Y-o-Y-Function-explanation.pdf
016 1.Course-Challenge.xlsx
016 1.SOULUTIONS-Course-Challenge.xlsx
016 Course Challenge - Apply Your Skills in Practice.mp4
01:09
001 Practical Exercise - SUMIFS.mp4
08:05
001 SUMIFS-Exercise-after.xlsx
001 SUMIFS-Exercise-before.xlsx
002 Completing 100% of the course.html
Description
Excel for the office: Excel Formatting, Excel functions, Excel charts, Excel pivot tables made easy for you
What You'll Learn?
- Work comfortably with Microsoft Excel 2016 and many of its advanced features
- Learn what is new in Excel 2016
- Be much quicker at carrying out regular tasks
- Become your team's go-to-guy when it comes to Excel
- Use sophisticated functions that will improve the quality of your work
Who is this for?
What You Need to Know?
More details
DescriptionDo you want to learn how to work with Excel?
Even if you don’t have any prior experience?
You want to become very good at Excel?
If so, then this is the right course for you!
*A verifiable certificate of completion is presented to all students who complete this course.*
Microsoft Excel is the greatest productivity software the world has seen so far.
However, it’s essential that you learn how to work with it effectively.
But how can you do that if you have very limited time and no prior training? And how can you be certain that you are not missing an important piece of the puzzle?
Microsoft Excel Beginners & Intermediate Excel Training is here for you. One of the best Excel courses online, this training includes everything you’ll need. We will start from the very basics and then gradually build a solid foundation that will help you grow as a professional.
What makes this course different from the rest of the Excel courses out there?
High quality of production – HD video and animated slides (this isn’t a collection of boring lectures!)
Knowledgeable instructor (1.5 million Udemy students, working experience in Big 4 Consulting and Coca-Cola)
Downloadable materials: The course comes with a complete set of downloadable materials (handouts, Excel files, etc.)
Extensive case studies that will help you reinforce everything that you’ve learned
Excellent support: If you don’t understand a concept or you simply want to drop us a line, you’ll receive an answer
Dynamic: We don’t want to waste your time! The instructor maintains a very good pace throughout the whole course
How come Microsoft Excel is so important?
Every company on the planet uses this software, right? So if you want to learn a new skill that is highly valued by all employers, you should start here.
Here are 5 more reasons why you should take this course and learn Excel:
Jobs. A solid understanding of Excel opens the door for a number of career paths
Promotions. Top Excel users are promoted very easily inside large corporations
Secure Future. Excel skills remain with you and provide extra security. You won’t ever have to fear unemployment
This course is suitable for people without any previous experience in Excel. We will start from the very basics and will gradually move on to some of the more advanced features, such as lookup functions, functions with conditions, goal seek, pivot tables, custom formatting, Excel charts, and other tools that are often used for the purposes of financial modeling.
Additionally, the course includes practical case studies that will reinforce everything you learn. One of the exercises we will see in the course consists of building a complete Profit & Loss statement from scratch.
This training is highly recommended for university students, entry-level finance, business and marketing professionals who would like to grow faster than their peers.
Please don’t forget that the course comes with Udemy’s 30-day unconditional money-back-in-full guarantee. And why not give such a guarantee, when we are convinced that it will provide a ton of value for you?
Buy the course today and let's start this journey together!
Who this course is for:
- Beginner, Intermediate and Advanced users who want to be proficient in Excel
Do you want to learn how to work with Excel?
Even if you don’t have any prior experience?
You want to become very good at Excel?
If so, then this is the right course for you!
*A verifiable certificate of completion is presented to all students who complete this course.*
Microsoft Excel is the greatest productivity software the world has seen so far.
However, it’s essential that you learn how to work with it effectively.
But how can you do that if you have very limited time and no prior training? And how can you be certain that you are not missing an important piece of the puzzle?
Microsoft Excel Beginners & Intermediate Excel Training is here for you. One of the best Excel courses online, this training includes everything you’ll need. We will start from the very basics and then gradually build a solid foundation that will help you grow as a professional.
What makes this course different from the rest of the Excel courses out there?
High quality of production – HD video and animated slides (this isn’t a collection of boring lectures!)
Knowledgeable instructor (1.5 million Udemy students, working experience in Big 4 Consulting and Coca-Cola)
Downloadable materials: The course comes with a complete set of downloadable materials (handouts, Excel files, etc.)
Extensive case studies that will help you reinforce everything that you’ve learned
Excellent support: If you don’t understand a concept or you simply want to drop us a line, you’ll receive an answer
Dynamic: We don’t want to waste your time! The instructor maintains a very good pace throughout the whole course
How come Microsoft Excel is so important?
Every company on the planet uses this software, right? So if you want to learn a new skill that is highly valued by all employers, you should start here.
Here are 5 more reasons why you should take this course and learn Excel:
Jobs. A solid understanding of Excel opens the door for a number of career paths
Promotions. Top Excel users are promoted very easily inside large corporations
Secure Future. Excel skills remain with you and provide extra security. You won’t ever have to fear unemployment
This course is suitable for people without any previous experience in Excel. We will start from the very basics and will gradually move on to some of the more advanced features, such as lookup functions, functions with conditions, goal seek, pivot tables, custom formatting, Excel charts, and other tools that are often used for the purposes of financial modeling.
Additionally, the course includes practical case studies that will reinforce everything you learn. One of the exercises we will see in the course consists of building a complete Profit & Loss statement from scratch.
This training is highly recommended for university students, entry-level finance, business and marketing professionals who would like to grow faster than their peers.
Please don’t forget that the course comes with Udemy’s 30-day unconditional money-back-in-full guarantee. And why not give such a guarantee, when we are convinced that it will provide a ton of value for you?
Buy the course today and let's start this journey together!
Who this course is for:
- Beginner, Intermediate and Advanced users who want to be proficient in Excel
User Reviews
Rating
average 0
Focused display
Category
365 Careers
Instructor's Courses365 Careers is the #1 best-selling provider of business, finance, and data science courses on Udemy. The company’s courses have been taken by more than 2,000,000 students in 210 countries. People working at world-class firms like Apple, PayPal, and Citibank have completed 365 Careers trainings. Currently, 365 focuses on the following topics on Udemy:
1) Finance – Finance fundamentals, Financial modeling in Excel, Valuation, Accounting, Capital budgeting, Financial statement analysis (FSA), Investment banking (IB), Leveraged buyout (LBO), Financial planning and analysis (FP&A), Corporate budgeting, applying Python for Finance, Tesla valuation case study, CFA, ACCA, and CPA2) Data science – Statistics, Mathematics, Probability, SQL, Python programming, Python for Finance, Business Intelligence, R, Machine Learning, TensorFlow, Tableau, the integration of SQL and Tableau, the integration of SQL, Python, Tableau, Power BI, Credit Risk Modeling, and Credit Analytics, Data literacy, Product Management, Pandas, Numpy, Python Programming, Data Strategy3) Entrepreneurship – Business Strategy, Management and HR Management, Marketing, Decision Making, Negotiation, and Persuasion, Tesla's Strategy and Marketing4) Office productivity – Microsoft Excel, PowerPoint, Microsoft Word, and Microsoft Outlook5) Blockchain for BusinessAll of our courses are: - Pre-scripted - Hands-on - Laser-focused - Engaging - Real-life tested By choosing 365 Careers, you make sure you will learn from proven experts, who have a passion for teaching, and can take you from beginner to pro in the shortest possible amount of time. If you want to become a financial analyst, a data scientist, a business analyst, a data analyst, a business intelligence analyst, a business executive, a finance manager, an FP&A analyst, an investment banker, or an entrepreneur365 Careers’ courses are the perfect place to start.
Udemy
View courses UdemyStudents take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.
- language english
- Training sessions 68
- duration 3:16:34
- English subtitles has
- Release Date 2023/09/12
