arrow_back
Introduction to Excel
Overview of Excel
Understanding the Excel interface
Basic data entry and navigation
Working with Worksheets
Creating and renaming worksheets
Entering data and formatting cells
Managing rows and columns
Using basic function and formulas
Formatting and Styling
Applying cell formatting and Conditional formatting
Basic formula applying
Creating and applying styles
Working with Tables
Freezing and Printing Tricks
Sorting and filtering data
Advanced filters
Charts and Graphs
Creating Basic charts
Formulas and Functions
Understanding formulas
Using basic functions
Working with references and ranges
V-Lookup Function
Data Analysis and Visualization
Visualizing data using spark lines
Creating PivotTables and PivotCharts
Visualizing data using slicers
Data Import and Export
Importing data from external sources
Exporting data to different formats attached with workbook
Share file in different format
Advanced Tools and Techniques
Conditional formatting with formulas
how to maintain stock in excel sheet format
Full Year and Monthly Stock Balance with In/Out Record
Using macros for automation
Attractive dashboard | Simple & Dynamic Graph