Mastering Excel – Excel From Beginner To Advanced – [UDEMY]

Master unique tips & techniques that you won't find in ANY other course, guaranteed
Basic data entry and manipulation
Data analysis
Requirements
No Prior Excel Knowledge Required
Microsoft Excel 2007, 2010, 2013, 2013, 2019 or Microsoft 365 Excel Loaded on Computer to Follow Along with Instructor Lectures is Recommended
Description

Overview
Section 1: Introduction
Lecture 1 Microsoft Excel Tutorial - Beginners Level 1
Lecture 2 Microsoft Excel Tutorial - Beginners Level 2
Lecture 3 Microsoft Excel Tutorial - Beginners Level 3
Lecture 4 Microsoft Excel Tutorial - Beginners Level 4
Lecture 5 Microsoft Excel Tutorial - Beginners Level 5
Section 2: lookup Function in Excel for Beginners
Lecture 6 Vlookup Function
Lecture 7 Xlookup Function
Section 3: 10 Best Excel Tips for Beginners
Lecture 8 10 Best Excel Tips
Section 4: Tabels
Lecture 9 7 Reasons Why you Should use Excel Tables
Section 5: Dropdown
Lecture 10 How to Create Drop-Down List in Excel
Lecture 11 Quickly Create Multiple Dependent Drop-Down Lists in Microsoft Excel
Section 6: Pivot Table
Lecture 12 Excel Pivot Table Tutorial for Beginners
Section 7: Cells Formatting
Lecture 13 Combine Text and Numbers into One Cell in Excel
Lecture 14 Learn Different Ways to Combine Cells in Microsoft Excel
Lecture 15 4 Ways to Split Cells in Microsoft Excel
Section 8: Charts and Graphs in Excel
Lecture 16 How to Create Charts and Graphs in Microsoft Excel - Quick and Simple
Lecture 17 How to Make a Line Graph in Excel - From Simple to Scientific
Section 9: VBA in excel
Lecture 18 Quickly Create an Excel Data Entry Form Without VBA
Section 10: Password Protect your Microsoft Excel Files
Lecture 19 3 Ways to Password Protect your Microsoft Excel Files
Section 11: 3D Formulas in Excel
Lecture 20 How to QUICKLY Use 3D Formulas in Excel
Section 12: Extras
Lecture 21 Relative vs Absolute Cell Reference in Microsoft Excel - What's the difference
Lecture 22 How to use Formulas and Functions in Microsoft Excel
Basic data entry and manipulation: You can learn how to enter and format data in Excel, including how to add, delete, and modify cells and rows, format numbers and text, and use Excel's built-in functions to manipulate data. Data analysis: Excel provides a wide range of data analysis tools, including pivot tables, data sorting and filtering, and various statistical functions. You can use these tools to explore and understand large data sets and to identify trends, patterns, and outliers. Financial modeling: Excel is widely used for financial modeling, including creating and analyzing financial statements, forecasting revenue and expenses, and conducting sensitivity analysis. By learning how to use Excel for financial modeling, you can develop a range of valuable skills that are highly sought after by employers. Graphs and charts: Excel also includes a variety of tools for creating graphs and charts to help you visualize your data. You can learn how to create different types of graphs and charts, including bar graphs, line charts, pie charts, and more. Automation: Finally, Excel includes a range of automation tools, including macros and scripting, that can help you automate repetitive tasks and streamline your workflow. By learning how to use these tools, you can increase your efficiency and productivity, and make your work with Excel more enjoyable and rewarding.

Homepage

https://www.udemy.com/course/mastering-excel-excel-from-beginner-to-advanced/

Published 2/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 4.13 GB | Duration: 5h 26m