Microsoft Excel from Beginner to Advanced Level Udemy Free Download
What you'll learn:
- Learn all Microsoft Excel tools
- Learn the most common Excel functions used in the Office
- Maintain large sets of Excel data in a list or table
- Microsoft Excel Interface (menu bar, sheets, cells, columns, rows)
- Basic functions Microsoft Excel (printing, resizing, Autofill, Fleshfill, Shortcuts)
- Work with data (find and replacing text, Constant link in formulas, Import text, Linking text)
- Work with formulas ( brief information about all types of formulas)
- Studying math formulas SUMM, AUTOSUM, AVERAGE, AVERAGEA
- Studying logical formulas and statements (TRUE, FALSE, IF, IFERROR)
- Studying other types of formulas ( VLOOKUP, HLOOKUP, MIN,MAX, DATE, DAY, TODAY
- Studying advance formulas (SUMIF, SUMIFS, COUNTIF, COUNTIFS)
- Formatting (Draw, Merging, Splitting text, Bordering, Filing (Coloring), Data grouping, text formatting)
- Filtering and sorting
- Working with Smart Tables (and slicing)
- Creating Charts
- Extra functions (Protect information, Changing menu bars, Notes and comments)
Requirements::
- You need PC or MacBook
- You have to have Microsoft Excel or access to Google Spreadsheets
Description:
The Microsoft Excel course exposes students to all available tools, command and Functions in the application. The training is carefully structured to take care of the learning needs of students, who are really yearning to know how to use Excel to carry out tasks in their workplaces. The course is also prepared to help regular users of the application, who want to upgrade their knowledge and upskill.
The Beginners to Intermediate topics capture the most frequently used command for day to day tasks. The Advanced level is also to help students learn the most advanced formulas, functions, and Tools. The advanced Excel training course builds on the beginner to intermediate course and is designed specifically for spreadsheet users who are already proficient and looking to take their skills to an advanced level.
The advanced excel tutorial will help you start a career in the area of data and financial analysis especially in the following fields; investment banking, private equity, corporate development, and equity research. By watching the instructor build all the formulas and functions right on your screen, you can easily pause, replay, and repeat exercises until you have mastered them.
Who this course is for:
- New and Intending Users of Microsoft Excel
- Accountants, Financial Analyst, Data Analyst, Human Resource Managers, Project Managers and Trainers
- Any person who desires to know Microsoft Excel and use it for Day to Day office Task.
Course Details:
- 18 hours on-demand video
- 79 downloadable resources
- 1 practice test
- Full lifetime access
- Access on mobile and TV
- Assignments
- Certificate of completion