# Excel data analysis bootcamp – FreeCourseSite

## Excel data analysis bootcamp â€“ FreeCourseSite

### Microsoft Excel Course.Learn Microsoft Excel

#### What youâ€™ll learn

Excel data analysis bootcamp â€“ FreeCourseSite

• 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 of the Basics of Microsoft Excel

• Become an expert in excel

#### Requirements

• No prior knowledge is required

#### Description

This course will deepen your 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 fantastic and

how

they can be applied in several ways for the analysis of data I will teach you how to THINK like Excel. This course is a hands-on tutorial where sample Excel sheets are provided for practice.

• Quickly 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 LOOKUP, 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 analyze data
• After this course, you will have mastered the most popular Excel tools and be confident to complete any Excel tasks efficiently and gracefully. 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

#### Who this course is for:

• Those who want to learn excel
• Those who want to master excel
• Those who want to learn data analysis using excel

If the links does not work, contact us we will fix them