Inbox Learners Hub | ISO certified Courses

Microsoft Excel - Excel from Beginner to Advanced Udemy

No Rating

(0 Reviews)

0 students enrolled

Microsoft Excel - Excel from Beginner to Advanced Udemy

This course offers comprehensive Excel training, starting from the basics and progressing to advanced features. It covers essential Excel functions like data entry, formatting, formulas, charts, pivot tables, macros, and VBA. Suitable for complete beginners, it also dives into advanced tools like data analysis and automation, making it ideal for anyone looking to enhance their Excel skills.

No Rating

(0 Reviews)

0 students enrolled

Requirements

Access to Microsoft Excel, Basic understanding of computer operations, practice and explore Excel’s functions

Description

Microsoft Excel - Excel from Beginner to Advanced

Overview

Microsoft Excel - Excel from Beginner to Advanced

Duration	21 Hours
Total Fee	₹3,099
Mode of learning	Online
Difficulty level	Beginner
Official Website	Go to Our Course
Credential	Certificate

Microsoft Excel - Excel from Beginner to Advanced

Highlights

Discover More

✔ 21 hours on-demand video
✔ 55 downloadable resources
✔ 15 articles

✔ Access on mobile and TV
✔ Lifetime Access
✔ Certificate of completion

Microsoft Excel - Excel from Beginner to Advanced

Course Details

Skills you will learn

In the "Microsoft Excel - Excel from Beginner to Advanced" course, you'll gain skills in mastering essential functions, formulas, and data management tools to efficiently organize and analyze data. You'll learn advanced techniques like PivotTables, macros, and automation for optimizing workflows. By the end, you'll be equipped to handle complex data tasks, create dynamic reports, and streamline processes in Excel.

More about this course

✔ Microsoft Excel 101 - An Introduction to Excel
✔ Microsoft Excel 102 - Intermediate Level Excel
✔ Microsoft Excel 103 - Advanced Level Excel
✔ Master Microsoft Excel Macros and VBA in 6 Simple Projects

Microsoft Excel - Excel from Beginner to Advanced

Curriculam

Microsoft Excel 101 Course Introduction

✓ Ask Questions
✓ Course Exercise Files
✓ Certificate of Completion

Microsoft Excel Fundamentals

✓ Launching Excel
✓ Microsoft Excel Startup Screen
✓ Introduction to the Excel Interface
✓ TIP - Hide Excel Ribbon
✓ TIP - Customizing the Excel Quick Access Toolbar
✓ More on the Excel Interface (Workbook and Status Bar)
✓ Understanding the Structure of an Excel Workbook
✓ Saving an Excel Document
✓ Opening an Existing Excel Document
✓ Common Excel Shortcut Keys
✓ Excel Fundamentals Quiz
✓ Excel Fundamentals Quiz (5 questions)

Entering and Editing Text and Formulas

✓ Entering Text to Create Excel Spreadsheet Titles
✓ Working with Numeric Data in Excel
✓ Entering Date Values in Excel
✓ Working with Cell References
✓ Creating Basic Formulas in Excel
✓ Relative Versus Absolute Cell References in Formulas
✓ Understanding the Order of Operation
✓ Entering and Editing Text and Formulas Quiz
✓ Entering and Editing Text and Formulas Quiz (4 questions)

Working with Basic Excel Functions

✓ The structure of an Excel Function
✓ Working with the SUM() Function
✓ Working with the MIN() and MAX() Functions
✓ Working with the AVERAGE() Function
✓ Working with the COUNT() Function
✓ Adjacent Cells Error in Excel Calculations
✓ Using the AutoSum Command
✓ Excel's AutoSum Shortcut Key
✓ Using the AutoFill Command to Copy Formulas
✓ Basic Excel Functions Quiz
✓ Basic Excel Functions Quiz (4 questions)

Modifying an Excel Worksheet

✓ Moving and Copying Data in an Excel Worksheet
✓ Inserting and Deleting Rows and Columns
✓ Changing the Width and Height of Cells
✓ Hiding and Unhiding Excel Rows and Columns
✓ Renaming an Excel Worksheet
✓ Deleting an Excel Worksheet
✓ Moving and Copying an Excel Worksheet
✓ Modifying Worksheets Quiz
✓ Modifying Worksheets Quiz (4 questions)

Formatting Data in an Excel Worksheet

✓ Working with Font Formatting Commands
✓ Changing the Background Color of a Cell
✓ Adding Borders to Cells
✓ Excel Cell Borders Continued
✓ Formatting Data as Currency Values
✓ Formatting Percentages
✓ Using Excel's Format Painter
✓ Creating Styles to Format Data
✓ Merging and Centering Cells
✓ Using Conditional Formatting
✓ Editing Excel Conditional Formatting
✓ Formatting Data Quiz
✓ Formatting Data Quiz (4 questions)

Inserting Images and Shapes into an Excel Worksheet

✓ Inserting Images
✓ Inserting Excel Shapes
✓ Formatting Excel Shapes
✓ Working with Excel SmartArt

Creating Basic Charts in Excel

✓ Creating an Excel Column Chart
✓ Working with the Excel Chart Ribbon
✓ Adding and Modifying Data on an Excel Chart
✓ Formatting an Excel Chart
✓ Moving a Chart to another Worksheet
✓ Working with Excel Pie Charts
✓ Microsoft Excel Charts Quick Guide
✓ Working with Excel Charts Quiz
✓ Working with Excel Charts Quiz (3 questions)

Printing an Excel Worksheet

✓ Viewing your Document in Print Preview
✓ Changing the Margins, Scaling and Orientation
✓ Excel Worksheet Margins
✓ Working with Page Layout View
✓ Adding Header and Footer Content
✓ Printing a Specific Range of Cells
✓ Printing an Excel Worksheet Quiz
✓ Printing an Excel Worksheet Quiz (4 questions)

Working with Excel Templates

✓ Intro to Excel Templates
✓ Opening an Existing Template
✓ Creating a Custom Template
✓ Excel Templates Quiz
✓ Excel Templates Quiz (1 question)

◆ Excel 101 - Practice What You've Learned

◆ Congratulations! You've Built a Solid Microsoft Excel Foundation

◆ Microsoft Excel 102 Course Introduction

◆ Working with an Excel List

◆ Excel List Functions

◆ Excel Data Validation

◆ Importing and Exporting Data

◆ Excel PivotTables

◆ Advanced Excel Topics

◆ Working with Large Sets of Excel Data

◆ Excel 102 Additional Practice Exercises

◆ Congratulations! You're an Intermediate Excel User

◆ Microsoft Excel 103 Course Introduction

◆ Working with Excel's Conditional Functions

◆ Working with Excel's Lookup Functions

◆ Working with Excel's Text Based Functions

◆ Auditing an Excel Worksheet

◆ Protecting Excel Worksheets and Workbooks

◆ Mastering Excel's "What If?" Tools

◆ Automating Repetitive Tasks in Excel with Macros

◆ Excel 103 Additional Practice Exercises

◆ Congratulations!

◆ Microsoft Excel Macros and VBA Course Introduction

◆ Project #1: Using Excel's Macro Recorder Tool

◆ Excel VBA Concepts

◆ Excel VBA Projects and Practices

Microsoft Excel - Excel from Beginner to Advanced

Entry Requirements

Eligibility Criteria

A high school diploma or equivalent is typically the minimum educational requirement, although it can be open to individuals with a 10th, 12th or equal studies though some programs may prefer candidates with a bachelor's degree.

Recent Courses

Fundamentals of Business Accounting...

January, 3rd 2025
0

Discover the essentials of business accounting and finance. Our comprehensive resources will help you master key concepts and..

199.00₹
~~1990.00₹~~

Business Strategy Consulting Master...

January, 3rd 2025
0

Elevate your business acumen with our Business Strategy Consulting Masterclass. Gain insights and skills to drive success and..

199.00₹
~~1990.00₹~~

Business Analysis: Writing Successf...

January, 3rd 2025
0

Discover how to craft compelling business cases that drive success. Our expert insights on business analysis will elevate you..

199.00₹
~~1990.00₹~~

Profitable Business Niche: Find An...

January, 3rd 2025
0

Discover your ideal business niche with our expert guidance. Unlock profitable opportunities and elevate your entrepreneurial..

199.00₹
~~1990.00₹~~

Gain control over your finances and...

January, 3rd 2025
0

Take charge of your financial future with expert tips and strategies to save capital and manage your finances effectively. St..

199.00₹
~~1990.00₹~~

About Instructor

Udemy EDU

About Instructor

Udemy is a website that offers online courses in a variety of topics, including business, coding, development, photography, and more. Udemy courses are created by instructors who can add videos, slides, text, and other resources to enhance the learning experience.