+ View more
Course Overview
Week 1-4: Introduction to Excel Basics
- Week 1:Getting Started with Excel
- Overview of Excel interface
- Workbook and worksheet basics
- Entering and editing data
- Week 2:Basic Formatting Techniques
- Formatting cells, rows, and columns
- Using styles and themes
- Week 3:Basic Formulas and Functions
- Introduction to formulas
- Common functions like SUM, AVERAGE, MIN, MAX
- Week 4:Managing Workbooks and Worksheets
- Adding, deleting, and organizing sheets
- Working with views and printing options
Week 5-8: Enhancing Data Presentation
- Week 5:Working with Tables
- Creating and formatting tables
- Sorting and filtering data
- Week 6:Introduction to Charts
- Creating various types of charts
- Customizing chart elements
- Week 7:Conditional Formatting
- Applying rules and color scales
- Highlighting important data
- Week 8:Using Templates and Themes
- Applying and modifying templates
- Customizing themes
Week 9-12: Intermediate Excel Skills
- Week 9:Data Validation
- Setting up data validation rules
- Creating drop-down lists
- Week 10:Working with Dates and Times
- Date and time functions
- Formatting dates and times
- Week 11:Advanced Formulas and Functions
- Nested functions
- Using IF, VLOOKUP, HLOOKUP
- Week 12:Data Analysis Tools
- PivotTables basics
- Using slicers and timelines
Week 13-16: Advanced Data Management
- Week 13:Introduction to Macros
- Recording and running macros
- Basic VBA concepts
- Week 14:Collaboration and Sharing
- Protecting workbooks and worksheets
- Sharing and co-authoring features
- Week 15:Advanced Charting Techniques
- Creating combination charts
- Using sparklines
- Week 16:Importing and Exporting Data
- Importing data from various sources
- Exporting Excel data
Week 17-20: Project-Based Learning and Review
- Week 17:Practical Project 1
- Applying learned skills to a real-world project
- Week 18:Practical Project 2
- Another hands-on project for practice
- Week 19:Course Review
- Reviewing key concepts and skills
- Q&A session for any remaining questions
- Week 20:Final Assessment and Certification
- Conducting a final project or test
- Issuing a certificate of completion
Powered by Froala Editor
What will i learn?
- Understand Excel Interface and Basic Navigation Navigate the Excel interface, including ribbons, toolbars, and worksheets. Understand basic terminology such as cell, range, worksheet, and workbook.
- Perform Basic Spreadsheet Operations Create, save, and manage Excel workbooks and worksheets. Enter and format data in cells, including text, numbers, and dates.
- Utilize Basic Formulas and Functions Use basic arithmetic formulas (e.g., addition, subtraction, multiplication, division). Apply common functions such as SUM, AVERAGE, MIN, and MAX.
- Format Cells and Data Apply basic formatting techniques, including font changes, cell borders, and fill colors. Use number formats to display data as currency, percentages, and dates
- Organize and Sort Data Sort data in ascending and descending order. Filter data to display only the information you need.
- Create and Modify Charts Create basic charts (e.g., column, line, pie) to visualize data. Customize chart elements such as titles, labels, and legends.
- Manage Worksheets and Workbooks Insert, delete, and rename worksheets. Move and copy worksheets within and between workbooks.
- Use Basic Data Analysis Tools Apply basic conditional formatting to highlight data. Use the AutoSum feature to quickly calculate totals.
- Print and Share Excel Documents Adjust print settings to fit worksheets on a page. Share workbooks through email or cloud storage.
- Troubleshoot Basic Excel Issues Identify and correct common errors in formulas. Use the Help feature and other resources to find solutions.
Requirements
- No prior knowledge of Excel and must have Zoom installed on their computer or device
Curriculum for this Course
Week 1 to 4 - Introduction to Excel Basics
4 Lessons
00:00:00 Hours
-
Week 1 : Getting Started with Excel
.
-
Week 2 : Basic Formatting Techniques
.
-
Week 3: Basic Formulas and Functions
.
-
Week 4 : Managing Workbooks and Worksheets
.
Week 5 to 8 - Enhancing Data Presentation
4 Lessons
00:00:00 Hours
-
Week 5 : Working with Tables
.
-
Week 6 : Introduction to Charts
.
-
Week 7 : Conditional Formatting
.
-
Week 8 : Using Templates and Themes
.
Week 9 to 12: Intermediate Excel Skills
4 Lessons
00:00:00 Hours
-
Week 9 : Data Validation
.
-
Week 10 : Working with Dates and Times
.
-
Week 11 : Advanced Formulas and Functions
.
-
Week 12 : Data Analysis Tools
.
Week 13 to 16 : Advanced Data Management
4 Lessons
00:00:00 Hours
-
Week 13 : Introduction to Macros
.
-
Week 14 : Collaboration and Sharing
.
-
Week 15 : Advanced Charting Techniques
.
-
Week 16 : Importing and Exporting Data
.
Week 17 to 20 : Project Based Learning and Review
3 Lessons
00:00:00 Hours
-
Project 1 : Personal Budget Tracker
00:00:00
-
Assignment 2 : Expense Tracker
00:00:00
-
Week 20 : Course Review
.
+ View more
Other related Courses
00:00:00 Hours
Updated Fri, 11-Apr-2025
0
$500
$150
00:00:00 Hours
Updated Fri, 11-Apr-2025
0
$500
$150
About instructor / organization
1 to 1 IT Coaching Australia
Dean Armellin is the visionary founder and driving force behind 1 to 1 IT Coaching Australia, a company dedicated to empowering individuals and businesses with personalized IT trai...
Dean Armellin
Dean Armellin is a seasoned computer expert and educator based in Melbourne, Australia. With over 28 years of experience in the IT industry, Dean has built a reputation for his dee...
Student feedback
Write a public review