Explore the core foundations of data analytics with our concise and comprehensive guide. Covering essential concepts, methodologies, and applications, this resource equips you with the fundamental knowledge needed for effective data analysis. From data interpretation to actionable insights, dive into the world of data analytics with confidence and clarity.

1. MANAGE WORKSHEETS AND WORKBOOKS

Import data into workbooks

• Import data from .txt files
• Import data from .csv files

Navigate within workbooks

• Search for data within a workbook
• Navigate to named cells, ranges, or workbook elements
• Insert and remove hyperlinks

Format worksheets and workbooks

• Modify page setup
• Adjust row height and column width
• Customize headers and footers

Customize options and views

• Customize the Quick Access toolbar
• Display and modify workbook content in different views
• Freeze worksheet rows and columns
• Change window views
• Modify basic workbook properties
• Display formulas

Configure content for collaboration

• Set a print area
• Save workbooks in alternative file formats
• Configure print settings
• Inspect workbooks for issues

2. MANAGE DATA CELLS AND RANGES

Manipulate data in worksheets

• Paste data by using special paste options
• Fill cells by using Auto Fill
• Insert and delete multiple columns or rows
• Insert and delete cells

Format cells and ranges

• Merge and unmerge cells
• Modify cell alignment, orientation, and indentation
• Format cells by using Format Painter
• Wrap text within cells
• Apply number formats
• Apply cell formats from the Format Cells dialog box
• Apply cell styles
• Clear cell formatting

Define and reference named ranges

• Define a named range
• Name a table

Summarize data visually

• Insert Sparklines
• Apply built-in conditional formatting
• Remove conditional formatting

3. MANAGE TABLES AND TABLE DATA

Create and format tables

• Create Excel tables from cell ranges
• Apply table styles
• Convert tables to cell ranges

Modify tables

• Add or remove table rows and columns
• Configure table style options
• Insert and configure total rows

Filter and sort table data

• Filter records
• Sort data by multiple columns

4. PERFORM OPERATIONS BY USING FORMULAS AND FUNCTIONS

Insert references

• Insert relative, absolute, and mixed references
• Reference named ranges and named tables in formulas

Calculate and transform datas

• Perform calculations by using the AVERAGE(), MAX(), MIN(), and SUM() functions
• Count cells by using the COUNT(), COUNTA(), and COUNTBLANK() functions
• Perform conditional operations by using the IF() function

Format and modify text

• Format text by using RIGHT(), LEFT(), and MID() functions
• Format text by using UPPER(), LOWER(), and LEN() functions
• Format text by using the CONCAT() and TEXTJOIN() functions

5. MANAGE CHARTS

• Create charts
• Create chart sheets

Modify charts

• Add data series to charts
• Switch between rows and columns in source data
• Add and modify chart elements

Format charts

• Apply chart layouts
• Apply chart styles
• Add alternative text to charts for accessibility

3. CREATE ADVANCED FORMULAS AND MACROS

Perform logical operations in formulas

• perform logical operations by using nested functions including the IF(), IFS(), SWITCH(), SUMIF(), AVERAGEIF(), COUNTIF(), SUMIFS(), AVERAGEIFS(), COUNTIFS(), MAXIFS(), MINIFS(), AND(), OR(), and NOT() functions

Look up data by using functions

• look up data by using the VLOOKUP(), HLOOKUP(), MATCH(), and INDEX() functions

Use advanced date and time functions

• reference date and time by using the NOW() and TODAY() functions
• calculate dates by using the WEEKDAY() and WORKDAY() function

• Why Pivot Table
• What is Pivot Table
• Benefits of Excel Pivot Tables
• Pivot Table Starting Checklist
• Inserting a Pivot Table in Excel
• Pro Tip: Dealing with Growing Source Data (Become a Pro)
• Refreshing & Updating Pivot Table
• Parts of Pivot Table: Filters, Rows, Column, Values
• Modifying Value Field Settings
• Modifying Pivot Table Layout to Make a Pro
• Formatting Pivot Table Data
• Formatting Pivot Table Like a Pro
• Renaming Pivot Table as best practices
• Modifying Pivot Table Calculation (Show Values As)
• Real World KPIs Example – Running Total: YTD, MTD, WTD,  Difference From: YoY, QoQ, MoM, Contribution %
• Enriching Data with Pivot Table Calculated Values and Fields
• Sorting, Filtering & Grouping Data with Pivot Table
• Filtering
• Sorting
• Groupings
• Pivot Chart
• Filtering Data with Slicers
• Using Timeline (Working with Dates) in Excel
• Drilling Down Into Pivot Table Data
• Other Pivot Tips and Tricks

Streamline your data cleaning process with our Core Course: Data Cleaning Automation Through Power Query. Discover the power of automation to efficiently cleanse and prepare your datasets. Learn advanced techniques using Power Query to automate repetitive tasks, enhance data quality, and accelerate your workflow. Gain the skills needed to transform raw data into a refined, analysis-ready state effortlessly.

Dive into the fundamentals of effective data modeling with our Data Modeling 101 Core Course. Learn the essential principles and techniques to structure and organize data for maximum efficiency and relevance. This course empowers you to create robust data models, facilitating accurate analysis and informed decision-making. Elevate your skills in database design and enhance your ability to derive meaningful insights from your data.

Master the art of Data Analysis Expression (DAX) with our Definitive Guide to DAX 102 Core Course. Elevate your analytics proficiency as you delve deeper into advanced DAX functions, enhancing your ability to unlock valuable insights from complex datasets. Gain practical skills to optimize data modeling, streamline calculations, and elevate your decision-making capabilities. Take the next step in mastering DAX and empower your data-driven success.

Dive deep into the world of data visualization and learn how to unleash the power of storytelling with data. Explore advanced techniques to create captivating visualizations that effectively communicate insights and narratives. From choosing the right visualization types to incorporating design principles, you will discover how to transform raw data into compelling stories that engage and inspire your audience. Elevate your data analysis skills by mastering the art of data visualization and leave a lasting impact with your data-driven storytelling abilities.

Empower your sales strategy with Applied Data Analytics: Sales Dashboard. Transform raw data into actionable insights, track key performance metrics, and make informed decisions that drive business growth. Unleash the power of data visualization to enhance sales performance, optimize processes, and elevate your business intelligence. Elevate your sales game with a dynamic and insightful approach to data analytics

Elevate your professional profile and impress future employers or clients with a standout data analysis portfolio. In this module, you will learn how to curate and showcase your best data analysis projects, highlighting your skills, insights, and achievements. From selecting compelling datasets to crafting visually appealing presentations, you will develop the expertise to effectively communicate your data analysis prowess. By the end of this module, you will have a robust portfolio that demonstrates your ability to tackle real-world challenges and deliver valuable results, setting you apart in the competitive data analysis landscape.

Navigate the world of freelancing with confidence through Freelancing 101. This essential guide provides insights into the freelance landscape, offering tips on building a successful career. From securing projects to managing finances, Freelancing 101 equips you with the knowledge and strategies to thrive as an independent professional. Explore the freedom of freelancing and turn your skills into a rewarding and sustainable career.