infyni Kids

Excel Essentials and Beyond

Take your Excel skills to the next level with our Formulas and Functions course. Learn how to create complex formulas, leverage built-in functions, and automate calculations.

Live Course

Live Class:

Enrolled: 0

Duration: 12 Hours

Offered by: infyni

Live Course

About Course

Learn the basics of Microsoft Excel with this comprehensive course. Learn essential functions, formatting techniques, and data management skills. Build a solid foundation for advanced Excel capabilities.

Key Benefits:

Understand Excel interface and basic functionalities

Efficient data entry and formatting

Create and manage worksheets and workbooks

Apply basic formulas and functions

Skills You Will Gain

Excel interface and basic functionalities; Efficient data entry; worksheets and workbooks; Apply basic formulas and functions

Course Offerings

Instructor Led Live sessions
Clarify doubts during session
Access Session Recordings
Attend on mobile and Tablet
Assessments and Competition
Direct Messages
Feedback from Instructor
Full lifetime Resources
Certificate of Completion

Topics
Instructor (1)

1 Module 1: Manage Workbook Options and Settings

Create Worksheets and Workbooks
Navigate in Worksheets and Workbooks
Format Worksheets and Workbooks
Customise Options and Views for Worksheets and Workbooks

2 Module 2: Apply Custom Data Formats and Layouts

Apply Custom Data Formats and Validation
Apply Advanced Conditional Formatting
Data Filtering
Create and Modify Custom Workbook Elements
Auditing Worksheets

3 Module 3: Create Tables

Create and Manage Tables
Manage Table Styles and Options
Filter and Sort a Table

4 Module 4: Perform Operations with Formulas and Functions

summarise Data by using Functions
Perform Conditional Operations by using Functions
Format and Modify Text by using Functions

5 Module 5: Create Charts and Objects

Create Charts
Format Charts
Insert and Format Objects

6 Module 6: Apply Custom Data Formats and Layouts

Apply Custom Data Formats and Validation
Apply Advanced Conditional Formatting and Filtering
Create and Modify Custom Workbook Elements
Prepare a Workbook for Internationalization