infyni

Microsoft Excel-Live Classes

Join our live Excel classes to master data management, analysis, and visualization. Elevate your skills with functions, formulas, and powerful spreadsheet techniques.

Live Course

Live Class: Monday, 04 Dec

Duration: 20 Hours

Enrolled: 0

Offered by: infyni

Live Course

About Course

Enhance your Excel skills with our live interactive classes covering the comprehensive functionality of Microsoft Excel. Delve into Excel's features, formulas, data analysis tools, and visualization techniques. Learn to efficiently manage data, create powerful spreadsheets, and automate tasks using functions and macros. Join our live sessions to elevate your Excel proficiency and become a spreadsheet master.

Skills You Will Gain

Excel Interface and Navigation Data Entry and Formatting Formulas and Functions Mastery Data Analysis Tools Data Visualization Techniques Advanced Functions and Formulas Data Management and Cleaning

Course Offerings

Instructor-led interactive classes
Clarify your doubts during class
Access recordings of the class
Attend on mobile or tablet
Live projects to practice
Case studies to learn from
Lifetime mentorship support
Industry specific curriculum
Certificate of completion
Employability opportunity

Topics
Instructor (1)

1 Manage Workbook Options and Settings

Create Worksheets and Workbooks
Navigate in Worksheets and Workbooks
Format Worksheets and Workbooks
Customize Options and Views for Worksheets and Workbooks
Configure Worksheets and Workbooks for Distribution

2 Apply Custom Data Formats and Layouts

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

3 Create Tables

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

4 Perform Operations with Formulas and Functions

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

5 Create Charts and Objects

Create Charts
Format Charts
Insert and Format Objects

6 Manage Workbook Options and Settings

Manage Workbooks
Manage Workbook Review Restrict editing

7 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

8 Create Advanced Formulas

Apply Functions in Formulas
Look up data by using Functions
Apply Advanced Date and Time Functions
Perform Data Analysis and Business Intelligence
Troubleshoot Formulas
Define Named Ranges and Objects

9 Create Advanced Charts and Tables

Create and Manage PivotTables
Create and Manage Pivot Charts