Technojee - Excel Online Course

Call Now     Whatsapp

Fee 1499

Offer Price 299

Demo Class For Python

Learn Basice To Advance Excel with AI.

Get Certificate after course.

Get pdf notes and Assignment Sheet.

Course Duration 30 days.

Learn 200+ excel formula with easy ways.

One Click To solve Doubts.

One Click To solve Doubts.

Lecture mode is HINDI.

Interested candidates join online class.

Employee can save and increase your Salary.


Er. AMIT SINGH
(10 Years Exp in MNC)

  


MSME Registered
Institute.

Total Enroll Students- 44545

15:00

Join Course


Course Content

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

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 (DOWNLOAD EXERCISE FILE)


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
200+ Advance Excel Formula
copilot AI

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

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

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

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 (DOWNLOAD)
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


CERTIFICATE GET AFTER COURSE