Data Analytics for Absolute Beginners

Cell, Row & Column Management – Insert, Delete, Resize, Merge & Wrap Cells.

Formatting Tools – Bold, Italic, Font Size, Color, Cell Border, Background Fill.

AutoFill & Flash Fill – Automatically fill in data patterns.

Sort & Filter – Arrange data in ascending or descending order and apply filters.

Formulas & Functions –

• SUM, AVERAGE, COUNT, MIN, MAX – Basic mathematical operations.

• IF, VLOOKUP, HLOOKUP, INDEX-MATCH – Logical operations and data lookup.

Conditional Formatting – Highlight cells based on specific conditions.

Charts & Graphs – Create bar charts, line charts, pie charts, and scatter plots.

Pivot Table & Pivot Chart – Summarize and analyze large datasets.

Data Validation – Control data input with predefined rules.

Freeze Panes – Keep headers or first columns visible while scrolling.

Find & Replace – Locate and replace specific values in the sheet.

Text to Columns – Split data from a single column into multiple columns.

Power Query – Import, clean, and transform data from various sources.

Data Modeling – Create relationships between different tables.

DAX (Data Analysis Expressions) – Use functions like SUM, AVERAGE, COUNT, IF, CALCULATE for advanced calculations.

Visualizations – Create bar charts, line charts, pie charts, tables, maps, and more.

Filters & Slicers – Apply filters to refine data views dynamically.

Drill Through & Drill Down – Explore data in detail by navigating different levels.

Custom Measures & Calculated Columns – Create new fields using DAX formulas.

Power BI Service – Publish and share reports online.

Data Refresh – Automatically update reports with the latest data.

Bookmarks & Selection Pane – Create interactive reports with navigation controls.

AI Insights – Use built-in AI features for advanced analytics.

Export & Embed – Export reports to PDF, PowerPoint, or embed them in web applications.