When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.

Productivity
SkillShare logo

Microsoft Excel 365 Training- Basic to Advance Level

Unlock creativity with Skillshare! Learn acrylic painting, AI writing, graphic design, and photography.

     0 |
  • Reviews ( 0 )
Free
Microsoft Excel 365 Training- Basic to Advance Level

Related Courses

This Course Includes

  • iconskillshare
  • icon0 (0 reviews )
  • icon6 hours 42 minutes
  • iconenglish
  • iconOnline - Self Paced
  • iconcourse
  • iconSkillShare

About Microsoft Excel 365 Training- Basic to Advance Level

Introduction

Create New File and Title Bar Understanding

Customize Ribbons and Quick Access Toolbar

Excel Structure and Worksheets

Data Entry and Formatting

Fill Series in Excel

Cell Reference in Excel

Math Operators in Excel

Math Function in Excel

Advance Math Function in Excel

Database Math Function

IF Function in Excel

Nested IF in Excel

If Function Task Solution

AND and OR Function

IF Function Project

IF Function Project Solution

Upper, Lower, Proper and Trim Function

Left, Right and Find Function

Find Related Project Solution

Left, Right and Find Function Nesting

MID Function

Concatenate Function

Concatenate Function Project Solution

Replace Function

Replace Function Project Solution

Substitute Function

Rept, Len Function and Project

Project Solution - Substitute and Len Nesting

Text to Column Option

Protect Workbook in Excel

Protect Sheet

Hide Formula and Unlocked Cell

Protect Excel File with Password

Print Options in Excel part 1

Print Options in Excel part 2

Vlookup Function

Iferror Function with Vlookup

Array Vlookup Function

Hlookup Function in Excel

Match and Index Function

Match and Index Nesting

Vlookup TRUE

Lookup and Reference Function Trick

Xlookup Function

Conditional Formatting - How to Apply

Types of Rules in Conditional Formatting

Manage Rules in Conditional Formatting

Goal Seek in Excel

Scenario Manager in Excel

PMT Function - EMI Calculator

Data Table in Excel

What You Will Learn?

  • Microsoft Excel is a spreadsheet application developed by Microsoft Inc for Microsoft Windows and MAC OS X. Its use is to do advanced calculation, graphing tools, pivot tables, and a macro programming language referred to as Visual Basic for Applications. The course curriculum is one of the most comprehensive and most advanced. Here you will trained from the very basic till the most advance level in the latest version..
  • You may expect to learn following topics in detail..
  • Learn about the structure of Excel.
  • Learn how to adjust the way data and information are displayed in Excel.
  • Learn how to apply function with function facts.
  • Learn how to create powerful calculations with Excel functions.
  • Learn how to use passwords in Excel to protect your work in multiple scenarios.
  • Learn how to use printing and sharing in Excel.
  • Learn to use Pivot table with slicers, Grouping and various tricks.
  • Learn how to organize your data based on Condition..
  • Mastering all important Text function with nested methodology.
  • Mastering Logical and Lookup and reference Function..
  • Mastering Operators use and Math Functions..
  • Working on latest XLOOKUP Function.