ShopTrack: Smart Billing & Inventory Database
ShopTrack: Smart Billing & Inventory Database
Updated on Feb, 2026
Language - English
Office Productivity,Microsoft,
Lectures -394
Resources -123
Quizzes -43
Duration -52.5 hours
Lifetime Access
Lifetime Access
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
Curriculum
Check out the detailed breakdown of what’s inside the course
Lets Start with Excel Fundamentals
10 Lectures
-
Excel Intro - New File and Title Bar
09:08
09:08
-
Customize Ribbons and Quick Access Toolbar
08:16
08:16
-
Excel Structure and Worksheets
10:47
10:47
-
Data Entry and Formatting
14:15
14:15
-
Fill Series in Excel
11:22
11:22
-
Flash Fill in Excel
03:15
03:15
-
Cell Reference Understanding
05:57
05:57
-
Resources
-
Quiz
-
Exercise 1
Mastering Mathematical Functions
6 Lectures
Mastering Logical Functions Use
10 Lectures
Data Filter and Sorting in Excel
6 Lectures
Conditional Formatting in Excel
5 Lectures
Mastering Text Functions and Tools
17 Lectures
Mastering Chart Presentation in Excel
9 Lectures
Mastering Pivot Table and Power Pivot
4 Lectures
Financial Functions and What if Analysis Tools
8 Lectures
Data Grouping and Linking
6 Lectures
How to Print Spreadsheet Efficiently
4 Lectures
Protect your Data in Excel
6 Lectures
Date and Time Management
7 Lectures
Mastering Lookup and Reference Functions
11 Lectures
Mastering Macro Recording Feature
5 Lectures
Introduction
4 Lectures
Working With An Excel List
11 Lectures
Excel List Functions
7 Lectures
Excel Data Validation
5 Lectures
Working With Large Sets Of Excel Data
7 Lectures
Working With Excel Conditional Functions
10 Lectures
Working With Excel Lookup Functions
7 Lectures
Working With Excel Text Based Functions
5 Lectures
Auditing An Excel Worksheet
6 Lectures
Protecting Excel Worksheets And Workbook
5 Lectures
Using "What-If Analysis" Tools In Excel
5 Lectures
Course Introduction
4 Lectures
Introduction to VBA
7 Lectures
Data Types and Variables
6 Lectures
Operators
11 Lectures
Functions and Sub-Procedures
5 Lectures
Msgbox and Inputbox
5 Lectures
Excel Object Model
14 Lectures
Conditional Statements
9 Lectures
Loops
13 Lectures
String Functions in Excel VBA
17 Lectures
Date Functions in Excel VBA
7 Lectures
Events and Userforms
5 Lectures
Error Handling
4 Lectures
Practical Examples
9 Lectures
VBA Tips
1 Lectures
Basics of Power Query
11 Lectures
Power Query Advanced
12 Lectures
Power Pivot With Dax
43 Lectures
Resource Files
2 Lectures
Advance Excel Assignments Solved With Videos Explanation
23 Lectures
Instructor Details
Tutorialspoint
Simple and Easy Learning
Tutorials Point originated from the idea that there exists a class of readers who respond better to online content and prefer to learn new skills at their own pace from the comforts of their drawing rooms.
The journey commenced with a single tutorial on HTML in 2006 and elated by the response it generated, we worked our way to adding fresh tutorials to our repository which now proudly flaunts a wealth of tutorials and allied articles on topics ranging from programming languages to web designing to academics and much more.
40 million readers read 100 million pages every month
Our Text Library Content and resources are freely available and we prefer to keep it that way to encourage our readers acquire as many skills as they would like to. We don't force our readers to sign up with us or submit their details either to use our Free Text Tutorials Library. No preconditions and no impediments, Just Simply Easy Learning!
We have established a Digital Content Marketplace to sell Video Courses and eBooks at a very nominal cost. You will have to register with us to avail these premium services.
Course Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now