+- Softwarez.Info - Software's World! (https://softwarez.info)
+-- Forum: Library Zone (https://softwarez.info/Forum-Library-Zone)
+--- Forum: Video Tutorials (https://softwarez.info/Forum-Video-Tutorials)
+--- Thread: Udemy - Microsoft Excel Beginners & Intermediate Excel Training (/Thread-Udemy-Microsoft-Excel-Beginners-Intermediate-Excel-Training)
Udemy - Microsoft Excel Beginners & Intermediate Excel Training - Farid - 09-05-2023
![[Image: w3F6ec.qj3dih7i4vf8.jpg]](https://i.im.ge/2023/09/05/w3F6ec.qj3dih7i4vf8.jpg)
Microsoft Excel Beginners & Intermediate Excel Training
Last updated 11/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.52 GB | Duration: 3h 21m
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
Requirements
Install Microsoft 2016, 2013 or 2010
No previous knowledge is required!
Great for students who want to learn at their own pace
Description
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 learnedExcellent support: If you don't understand a concept or you simply want to drop us a line, you'll receive an answerDynamic: We don't want to waste your time! The instructor maintains a very good pace throughout the whole courseHow 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 pathsPromotions. Top Excel users are promoted very easily inside large corporationsSecure Future. Excel skills remain with you and provide extra security. You won't ever have to fear unemploymentThis 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!
Overview
Section 1: Welcome! Course Introduction
Lecture 1 What Does the Course Cover?
Lecture 2 Bonus Gift Number 1
Lecture 3 Bonus Gift Number 2
Section 2: A Quick Introduction to the Basics of Excel
Lecture 4 Overview of Excel
Lecture 5 The Excel Ribbon
Lecture 6 Working with Rows & Columns
Lecture 7 Data Entry in Excel
Lecture 8 Introduction to Formatting
Lecture 9 Creating Formulas in Excel
Lecture 10 Microsoft Excel at Its Best - Functions
Lecture 11 Work Efficiently By Using Cut, Copy & Paste
Lecture 12 Format Cells
Lecture 13 Pasting Values, Formulas and Formats with Paste Special
Section 3: Assignment 1
Section 4: Excel Best Practices: Useful Tips & Tools
Lecture 14 This Is How You Can Start Formatting Your Sheets in a Professional Way
Lecture 15 Fast Scrolling That Would Allow You to Be 3x Faster
Lecture 16 Fixing Cell References Properly
Lecture 17 Using the Alt plus Enter combination
Lecture 18 Learn How to Organize Your Excel Data with Text to Columns
Lecture 19 Wrapping Text in Excel
Lecture 20 Create Easily Printable Documents by Using Set Print Area
Lecture 21 Find and Select Special Types of Cells with Select Special (F5)
Lecture 22 Learn How to Assign Dynamic Names within a Model
Lecture 23 Excel Formulas that Make Sense - Named Ranges
Lecture 24 Completing 33% of the course
Lecture 25 Introduction to Custom Formatting
Lecture 26 Assigning Custom Formats to Specific Cells (Ex. Multiples)
Lecture 27 Execute 50 Commands with a Single Click - Excel Macros
Lecture 28 Create a Drop-Down List by Using Data Validation
Lecture 29 Using Custom Sort in Order to Sort Multiple Columns within a Table
Lecture 30 Create a Great Index Page at the Beginning of Your Financial Models
Lecture 31 Freeze the Title Row of Your Table - Freeze Panes
Lecture 32 Excel's "Tell Me" Search Bar
Section 5: Keyboard Shortcuts in Excel
Lecture 33 Keyboard Shortcuts Save LOTS of time in Excel
Section 6: Excel Functions
Lecture 34 A helpful consideration
Lecture 35 Key Functions in Excel: COUNT, COUNTA, COUNTIF, COUNTIFS
Lecture 36 Key Functions in Excel: SUM, SUMIF, SUMIFS
Lecture 37 Key Excel Functions: AVERAGE & AVERAGEIF
Lecture 38 Completing 50% of the course
Lecture 39 Working with Text in Excel: LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE
Lecture 40 Find the Highest and the Lowest Values in a Range: MAX & MIN
Lecture 41 Include ROUND in Your Financial Models
Lecture 42 Transferring Data Efficiently: VLOOKUP & HLOOKUP
Lecture 43 Use INDEX & MATCH as a Substitute of VLOOKUP
Lecture 44 The Perfect VLOOKUP Substitute: XLOOKUP (Office 365 Only)
Lecture 45 IFERROR Allows You to Deal Easily with Error Mesages
Lecture 46 Excel's Dynamic & Interactive Tables: Pivot Tables
Lecture 47 Create Flexible Financial Models with the CHOOSE Function
Lecture 48 Find the Result that You Are Looking For with Goal Seek
Lecture 49 Include Sensitivity Analysis In Your Model Through Data Tables
Section 7: Create Professional Charts in Microsoft Excel 2016
Lecture 50 Introduction to Charts in Excel 2016
Lecture 51 Inserting Charts in Excel & Learning About the Various Chart Types
Lecture 52 Formatting of Excel Charts (1/2)
Lecture 53 Formatting of Excel Charts (2/2)
Lecture 54 Creating a Bridge Chart in Excel 2016 - As Easy As It Gets
Lecture 55 An Easy Way to Create a Treemap
Lecture 56 Use Sparklines to Show Data Trends
Section 8: Build a Complete P&L from Scratch
Lecture 57 Introduction to the Case Study
Lecture 58 This Is the data that we will use for our Exercise
Lecture 59 Let's Reorder our Excel sheet and create a clear structure
Lecture 60 Introducing a Code: The best way to work with large amounts of data
Lecture 61 Finishing Touches of our Database
Lecture 62 Using Vlookup in Order to Transfer Data
Lecture 63 Applying Sumif in Order to Populate the Database with Numbers
Lecture 64 Demonstrating How Index & Match Can Successfully Replace Vlookup
Lecture 65 Substituting VLOOKUP with XLOOKUP (Office 365 Only)
Lecture 66 Mapping the Items Within Our Database - A Key Exercise For Financial Analysts
Lecture 67 Creating the Structure of the P&L Statement
Lecture 68 Time for Some Formatting! The Secret of Creating Awesome Looking Excel Sheets
Lecture 69 Populating the P&L sheet with figures
Lecture 70 How do We Find Mistakes in the easiest way possible?
Lecture 71 Finishing Touches: Calculating Year-on-Year Growth and Percentage Incidence
Lecture 72 Course Challenge - Apply Your Skills in Practice
Section 9: Practical Exercise - SUMIFS
Lecture 73 Practical Exercise - SUMIFS
Lecture 74 Completing 100% of the course
Beginner, Intermediate and Advanced users who want to be proficient in Excel
KatFile Link(s)
RapidGator Link(s)