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
-
-
Welcome
-
Course Structure
-
ScholarU Community
-
About You Survey
-
-
-
Introduction to Spreadsheets
FREE PREVIEW -
Anatomy of a Spreadsheet
FREE PREVIEW -
Getting Started with a Blank Spreadsheet
FREE PREVIEW -
Check: Save a File
FREE PREVIEW -
Navigating Around the Spreadsheet
FREE PREVIEW -
Check: Cell Location
-
Formatting Columns, Rows and Cells
-
Course Content
-
Copying Course Content
-
Exercise: Spreadsheet Basics
-
Exercise: Spreadsheet Basics - Introduction
-
Exercise: Spreadsheet Basics - Solution
-
-
-
Introduction to Different Data Types
-
Number Formats
-
Check: Percentage
-
Check: Left Justified
-
Undo / Redo Operations
-
Check: Undo
-
Number Data Type
-
Check: Scientific Notation
-
Exercise: Data Type Basics
-
Exercise: Data Type Basics - Introduction
-
Exercise: Data Type Basics - Solution
-
-
-
Introduction to Equations
-
Check: Addition
-
Order of Operations
-
Check: Order of Operations
-
Renaming Cells
-
Check: Renaming Cells
-
Circular References
-
Check: Circular References
-
Decimals
-
Check: Decimals
-
Exercise: Equations
-
Exercise: Equations - Introduction
-
Exercise: Equations - Solutions
-
-
-
Intro to Functions
-
Check: Ranges
-
Common Functions
-
Check: Common Functions
-
Nested Functions
-
Check: Nested Functions
-
Random Operations
-
Check: Random Operations
-
Exercise: Functions
-
Exercise: Functions - Introduction
-
Exercise: Functions - Solution
-
Exercise: Function Documentation
-
-
-
Sheet Basics
-
Exercise: Sheets
-
Exercise: Sheets - Introduction
-
Exercise: Sheets - Solution
-

About this course
- $199.00
- 10-15 hrs