Brochure
Enquire
- Welcome
- Course Files
- Additional files
Quick Facts
| particular | details | |||
|---|---|---|---|---|
|
Medium of instructions
English
|
Mode of learning
Self study
|
Mode of Delivery
Video and Text Based
|
Course and certificate fees
Fees information
₹ 399 ₹3,699
certificate availability
Yes
certificate providing authority
Udemy
The syllabus
Course Information
Quick Start
- Excel Quick Start
- Relative References
- Absolute References
- Functions
- Creating Charts
- Calculating A Grade Example
- Gathering Data With Google Forms
Getting Started
- Introduction To Excel
- Introduction To Excel
- Writing Formulas
- Writing Formulas
- Formula Essentials
- Formula Essentials
- Relative, Absolute, & Mixed References
- Relative, Absolute, and Mixed References
Working With Functions
- Introduction to Functions
- Introduction to Functions
- Payment Function & Loans
- Payment Function & Loans
- Future Value Function & Pensions
- Future Value Function & Pensions
- VLOOKUP Function & Gradebooks
- VLOOKUP Function & Gradebooks
- IF, Concatenate, & Evaluation
- IF, Concatenate, & Evaluation
- Conditional Formatting
- Conditional Formatting
- IFERROR Function & Dynamic Amortization Tables
- IFERROR Function & Dynamic Amortization Tables
Creating Charts & Graphs
- Visually Representing Data
- Visually Representing Data
- Creating Charts
- Creating Charts
- Formatting Charts
- Formatting Charts
- Scatter Charts
- Scatter Charts
- Combo Charts
- Combo Charts
- Pivot Charts
- Pivot Charts
Harvesting Data From The Web
- Finding Data
- Finding Data
- Copying Data From The Web
- Copying Data From The Web
- Transposing Data
- Transposing Data
- Copying Data From The Web II
- Copying Data From The Web II
- Parsing Data
- Parsing Data
- Web Scraping Software
- Web Scraping Software
Manipulating Data
- Freeze Panes
- Freeze Panes
- Filtering Data
- Filtering Data
- Removing Duplicates
- Removing Duplicates
- Sorting Data
- Sorting Data
- Subtotaling Data
- Subtotaling Data
- Data Tables
- Data Tables
Advanced Filtering
- Exploring The Find Function
- Exploring The Find Function
- Exploring Filters Further
- Exploring Filters Further
- The Advanced Filter
- The Advanced Filter
- The Find Function II
- The Find Function II
Going Pro With Pivot Tables
- Introduction to Pivot Tables
- Introduction to Pivot Tables
- Creating a Pivot Table
- Creating a Pivot Table
- Exploring Pivot Tables
- Exploring Pivot Tables
- Recommended Pivot Tables
- Recommended Pivot Tables
- Grouping in Pivot Tables
- Grouping in Pivot Tables
- Using "Slicers" in Pivot Tables
- Using "Slicers" in Pivot Tables
- Creating Pivot Charts
- Creating Pivot Charts
Formatting For Impact
- Formatting Your Worksheet
- Formatting Your Worksheet
- Formatting Essentials
- Formatting Essentials
- Formatting Fundamentals
- Formatting Fundamentals
- Design Considerations
- Design Considerations
- Inserting & Deleting Cells, Columns, & Rows
- Inserting & Deleting Cells, Columns, & Rows
- Formatting Options
- Formatting Options
- Formatting Examples
- Formatting Examples
- Formatting Secrets
- Formatting Secrets
Saving Time With Macros
- Understanding Macros
- Understanding Macros
- Macro Automation
- Macro Automation
Integrating Word & Excel
- Object Linking & Embedding
- Object Linking & Embedding
Securing Your Work
- Securing Your Worksheets
- Securing Your Worksheets
- Securing Your Workbooks
- Securing Your Workbooks
Printing & Sharing Your Work
- Preparing To Print
- Preparing To Print
- Printing & Sharing
- Printing & Sharing
Enhancing Your Value with Bonus Skills
- Awesome Stuff With Google
- Awesome Stuff With Google
- Google Form Examples
- Google Form Examples
Hands-On: Creating A Gradebook
- Creating A Gradebook
- Initial Considerations
- Tracking Attendance
- Gradebook Adjustments
- Entering and Adjusting Data
- Entering Formulas and Functions
- Automated Error Checking
- Calculating All Grades
- Looking Up The Letter Grade
- Freeze Panes and Sorting
Hands-On: Bringing Grades From Blackboard Into Excel
- Importing Data From Blackboard
Hands-On: Creating A Loan Amortization
- Creating A Loan Amortization Schedule
Templates
- Templates Shown Throughout Course
Final Exam
- Final Exam
Farewell
- Until We Meet Again!
- Bonus lecture
Instructors
Mr Todd McLeod
Professor
Freelancer
Other Bachelors
Articles
Popular Articles
prev
next
Latest Articles
prev
next
