Microsoft Excel Course.Learn microsoft Excel
This course will give you a deep understanding of the advanced Excel formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool.
What you’ll learn
- Create dynamic reports by mastering one of the most popular tools, PivotTables.
- Maintain large sets of Excel data in a list or table.
- Learn the most common Excel functions used in the Office.
- Master Microsoft Excel from Beginner to Advanced.
- Build a solid understanding on the Basics of Microsoft Excel.
- Become expert in excel.
Course Content
- Introduction –> 1 lecture • 2min.
- Day 1 –> 4 lectures • 9min.
- Day 2 –> 5 lectures • 13min.
- Day 3 –> 7 lectures • 14min.
- Day 4 –> 3 lectures • 4min.
- Day 5 –> 7 lectures • 14min.
Requirements
This course will give you a deep understanding of the advanced Excel formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool.
While most Excel courses focus on simply what each formula does, I teach through hands-on, contextual examples designed to showcase why these formulas are awesome and how they can be applied in a number of ways for analysis of data I will teach you how to THINK like Excel.This course is hands on tutorial where sample excel sheets are provided for practice.
- Easily build dynamic tools & Excel dashboards to filter, display and analyze your data
- Create your own formula-based Excel formatting rules
- Join datasets from multiple sources with XLOOKUP, INDEX & MATCH functions
- Manipulate dates, times, text, and arrays
- Automate tedious and time-consuming tasks using cell formulas and functions in Excel (no VBA required!)
- Pull real-time data from APIs directly into Excel (weather, stock quotes, directions, etc.)
- Plotting charts
- Learn how to manipulate and analyse data
- At completion of this course you will have mastered the most popular Excel tools and come out with confidence to complete any Excel tasks with efficiency and grace. Below are just a few of the topics that you will master:
- Creating effective spreadsheets
- Managing large sets of data
- Mastering the use of some of Excel’s most popular and highly sought after functions (SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH and many more…)
- Create dynamic report with Excel PivotTables
- Unlock the power and versatility of Microsoft Excel’s Add-In, PowerPivot
- Audit Excel Worksheet formulas to ensure clean formulas
- Automate your day to day Excel tasks by mastering the power of Macros and VBA
- How to do data analysis
- How to plot beautiful charts