Excel for Beginners

About the Course

Are you intrigued by the potential of Excel, a fundamental spreadsheet tool in various fields? If so, we welcome you to explore the essentials through "Excel for Beginners." This course is designed to equip you with the skills to effectively manage and analyze data for business, research, and personal projects. In our data-driven world, businesses seek professionals capable of handling, analyzing, and visualizing data, making this course an ideal starting point for those aspiring to pursue a career in business and data analysis.

Throughout the course, you'll acquire valuable skills in data organization, manipulation, and visualization, utilizing Excel's diverse features. Learn to apply formulas, functions (including sorting, filtering, and pivot tables), and create charts for insightful data presentations crucial in decision-making processes.

Enrich your learning experience with practical exercises and case studies, enabling the application of gained knowledge to real-world scenarios. Upon course completion, you'll possess the proficiency to work with data sets and generate meaningful insights. Join us today and elevate your analytics skills to the next level!

Who should take this course?

This course caters to individuals eager to embark on a career in business analysis, including pre-MBA students. It also serves as a valuable resource for professionals seeking to augment their expertise in this field.

Course Duration:

The course is self-paced and it takes between 10-15 hours to complete including watching the videos, and working on the knowledge checks, exercises and case studies.

Course Support:

There is a community page where you can ask questions, share your ideas and knowledge, and connect with other students and the staff.

Prerequisites:

Access to Excel.
A thirst for knowledge.

*Courses can be conducted live online or in person upon request. For more information send an email ([email protected])!

Course curriculum

1. Welcome
2. Course Structure
3. ScholarU Community
4. About You Survey
1. Introduction to Spreadsheets
  FREE PREVIEW
2. Anatomy of a Spreadsheet
  FREE PREVIEW
3. Getting Started with a Blank Spreadsheet
  FREE PREVIEW
4. Check: Save a File
  FREE PREVIEW
5. Navigating Around the Spreadsheet
  FREE PREVIEW
6. Check: Cell Location
7. Formatting Columns, Rows and Cells
8. Course Content
9. Copying Course Content
10. Exercise: Spreadsheet Basics
11. Exercise: Spreadsheet Basics - Introduction
12. Exercise: Spreadsheet Basics - Solution
1. Introduction to Different Data Types
2. Number Formats
3. Check: Percentage
4. Check: Left Justified
5. Undo / Redo Operations
6. Check: Undo
7. Number Data Type
8. Check: Scientific Notation
9. Exercise: Data Type Basics
10. Exercise: Data Type Basics - Introduction
11. Exercise: Data Type Basics - Solution
1. Introduction to Equations
2. Check: Addition
3. Order of Operations
4. Check: Order of Operations
5. Renaming Cells
6. Check: Renaming Cells
7. Circular References
8. Check: Circular References
9. Decimals
10. Check: Decimals
11. Exercise: Equations
12. Exercise: Equations - Introduction
13. Exercise: Equations - Solutions
1. Intro to Functions
2. Check: Ranges
3. Common Functions
4. Check: Common Functions
5. Nested Functions
6. Check: Nested Functions
7. Random Operations
8. Check: Random Operations
9. Exercise: Functions
10. Exercise: Functions - Introduction
11. Exercise: Functions - Solution
12. Exercise: Function Documentation
1. Sheet Basics
2. Exercise: Sheets
3. Exercise: Sheets - Introduction
4. Exercise: Sheets - Solution
1. Cut, Copy and Paste
2. Copying Patterns
3. Check: Patterns
4. Exercise: Simple Copying
5. Exercise: Simple Copying - Introduction
6. Exercise: Simple Copying - Solution
1. Relative Reference
2. Check: Relative Reference
3. Absolute Reference
4. Check Absolute Reference
5. Exercise: Cell Referencing
6. Exercise: Cell Referencing - Introduction
7. Exercise: Cell Referencing - Solution
1. Saving and Versioning
2. Exercise: Saving and Versioning
3. Exercise: Saving and Versioning - Introduction
4. Exercise: Saving and Versioning - Solution
1. Date Data Type
2. Date Functions
3. Check: Weekday
4. Boolean/Logical Data Type
5. Check: IsText
6. If Functions
7. Check: CountIf
8. Truth Table and Checkboxes
9. Check: And, Or, Not Part 1
10. Check: And, Or, Not Part 2
11. Exercise: Advanced Data Types - Dates and Booleans
12. Exercise: Advanced Data Types - Dates and Booleans - Introduction
13. Exercise: Advanced Data Types - Dates and Booleans Part 2
1. Text Functions
2. Check: Text
3. Exact, Find, Search and Replace
4. Check: Replace
5. Concat and Textsplit
6. Check: Textsplit
7. Data Validation, Dropdown and Links
8. Exercise: Advanced Data Types - Text
9. Exercise: Advanced Data Types - Text - Introduction
10. Exercise: Advanced Data Types - Text - Solution
1. VLOOKUP and HLOOKUP
2. Check: VLOOKUP
3. Index and Match
4. Check: Index and Match
5. XLOOKUP
6. Check: XLOOKUP
7. Exercise: LOOKUP Functions
8. Exercise: LOOKUP Functions - Introduction
9. Exercise: LOOKUP Functions - Solution
1. Text and Cells
2. Check: Text and Cells
3. Hiding the Ribbon, Gridlines, Formula Bar and Headings, and Merging Cells
4. Column and Row Views
5. Check: Column and Row Views
6. Insert Images and More
7. Table Format
8. Exercise: Formatting
9. Exercise: Formatting - Introduction
10. Exercise: Formatting - Solution
1. Conditional Formatting
2. Check: Conditional Formatting
3. Custom Conditional Format
4. Check: Custom Conditional Format
5. Exercise: Conditional Formatting
6. Exercise: Conditional Formatting - Introduction
7. Exercise: Conditional Formatting - Solution
1. Filter Function
2. Check: Filter Function
3. Sort Function
4. Check: Sort Function
5. Table Sort and Filter
6. Slicers
7. Exercise: Sort and Filter
8. Exercise: Sort and Filter - Introduction
9. Exercise: Sort and Filter - Solution
1. Introduction to Charts
2. Check: Type of Charts
3. Chart Style
4. Chart Elements
5. Data Series
6. Axis and Gridlines
7. Maps
8. Sparklines
9. Exercise: Charts
10. Exercise: Charts - Introduction
11. Exercise: Charts - Solution
1. Themes
2. Color Blind Friendly Color Palettes
3. Exercise: Themes
1. Motivation
2. Pivot Tables
3. Calculation, Sort and Filter
4. Check: Pivot Tables
5. Exercise: Pivot Tables
6. Exercise: Pivot Tables - Introduction
7. Exercise: Pivot Tables - Solution
1. Notes and Comments
2. Share, Email and Print
3. Paste Special
4. Protected Sheets and Workbook
5. Check: Collaboration and Sharing
6. Exercise: Collaboration and Sharing
7. Exercise: Collaboration and Sharing - Introduction
8. Exercise: Collaboration and Sharing - Solution
1. Duplicates
2. Check: Duplicates
3. Missing Data
4. Check: Missing Data
5. Text Cleanup
6. Incorrectly Formatted or Corrupted Data
7. Clear Column Names
8. Drop Unnecessary Columns
9. Sanity Checks
10. Descriptive Values
11. Exercise: Cleaning Data
12. Exercise: Cleaning Data - Introduction
13. Exercise: Cleaning Data - Solution
1. Error Message
2. Error Functions
3. Check: Debugging
4. Exercise: Debugging
5. Exercise: Debugging - Introduction
6. Exercise: Debugging - Solution
1. Case Study: Tax Calculator
2. Case Study: Tax Calculator - Introduction
3. Case Study: Tax Calculator - Solution Part 1
4. Case Study: Tax Calculator - Solution Part 2
5. Case Study: Tax Calculator - Solution Part 3
6. Case Study: Tax Calculator - Solution Part 4
7. Case Study: Tax Calculator - Solution Part 5
1. Final Note
2. End of Course Survey

About this course

$199.00
10-15 hrs

Discover your potential, starting today

Buy now!