As data becomes the modern currency, the ability to analyze data quickly and accurately has become of paramount importance. Therefore, data analytics and visualization are two of the most sought-after skills for high paying jobs with strong future growth prospects. This course will help you develop your analytical and visualization skills so that you not only improve your current work performance but also expand your future job prospects. For those in business and data analysis who want to master advanced Excel and beginner Power BI, that will add an asset to your employability portfolio.

What will you learn in this Data Analytics & Visualizations in Excel in Excel Training?

• Understand the different types of data in Excel and use appropriate
functions to work with them.
• Use logical and lookup functions to transform, link and categorize
data.
• Use Excel tools and functions to clean and prepare data for analysis.
• Use Named Ranges and Tables to automate your analysis

Course Outline

GETTING DATA INTO MICROSOFT EXCEL
• Import data from various platforms into Microsoft Excel for further
analysis

DATA CLEANING AND MANIPULATION
• Use functions for combining and splitting text
• Clean data, change case, and remove unwanted characters
• Understand the importance of well-organized data for analysis

WORKING WITH NUMBERS AND DATES
• Convert data types from text to numbers, dates to text, and both numbers and text to
dates
• Utilize functions for generating dates, calculating days between two dates, and more

DEFINED NAMES FOR BETTER DATA MANAGEMENT
• Referencing and naming cells, creating named ranges, and automating processes.
• Improve efficiency and accuracy by using defined names in
calculations

AUTOMATING DATA MANIPULATION WITH TABLES
• Use SMART TABLES to create, format, and manage tables
• Format, select, sort, and filter data
• Improve the organization and analysis of data with structured
referencing

LOGICAL AND LOOKUP FUNCTIONS
• Evaluate data using nested IF functions
• Perform logical operations with IF
• Categorize data with VLOOKUP and XLOOKUP
• Match data with advanced functions such as INDEX and MATCH

DATA TRANSFORMATION WITH POWER QUERY
• Use the Query Editor Engine to extract, transform, and load data
• Combine multiple datasets for more comprehensive analysis.

DATA VISUALIZATION
• Visualize data with conditional formatting, sparklines, number formats,
and more
• Utilize standard charts such as line charts, pie charts, and scatter
charts, as well as specialized charts such as hierarchy, waterfall, funnel, geospatial, and gauge
charts

CREATING INTERACTIVE DASHBOARDS
• Summarize data with Pivot Tables
• Customize, group, sort, and filter pivot data
• Create interactive dashboards with pivot charts, slicers, and timelines

DATA VISUALIZATION WITH POWER BI
• Quickly visualize data with the help of Power BI.