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. Upon completing this specialization, you will be able to bring data to life using advanced Excel functions, creative visualizations, and powerful automation features. These courses will equip you with a comprehensive set of tools for transforming, linking, and analyzing data. You will master a broad range of charts and create stunning interactive dashboards. Finally, you will explore a new dimension in Excel with PowerPivot, Get and Transform, and DAX. Harnessing the power of an underlying database engine, we will remove the 1,048,576-row limitation, completely automate data transformation, create data models to effectively link data, and open the gateway to Power Business Intelligence.
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