Microsoft Excel Tutorial for Beginners-2022

Categories: Add On, Excel Courses

Wishlist

About Course

Course Content

Read Me!!

About Course
Certificate of Completion

1) Quick tour of excel

2) Data input
Please Note : Change your user Name Into Roll Number Provided By Us Class Time: 7.00 PM Join Zoom Meeting https://zoom.us/j/99487413869?pwd=V1h1UzVIZVVRMjIyN2k5SDJ0a0RJUT09

3) Worksheet, Navigation, Copying & Protecting

4) Important Excel Function

5) Data cleaning & Management

6) Formatting including CONDITIONAL & NUMBER FORMATTING in excel

Self Assessment Test

Resource Files

Get Certificate

Student Ratings & Reviews

No Review Yet

About Course

Course Content

Read Me!!

About Course

Certificate of Completion

1) Quick tour of excel

a) Excel work book worksheet, cell structure

b) Ribbon & Quick access toolbar

2) Data input Please Note : Change your user Name Into Roll Number Provided By Us Class Time: 7.00 PM Join Zoom Meeting https://zoom.us/j/99487413869?pwd=V1h1UzVIZVVRMjIyN2k5SDJ0a0RJUT09

Comments ,Finding excel formulas & input cells

Excel data validation to reduce time

Data entry & Editing excel data

Basic excel formula

Correctly inputs dates & time stamps

Use excel auto fill to do your work

Excel flash fill for major time saving

Custom list with autofill

3) Worksheet, Navigation, Copying & Protecting

Useful excel shortcuts for navigation

Copying, moving, & hiding worksheets

Freeze panes & split screen for long excel reports

Copying & pasting data

4) Important Excel Function

COUNT, COUNTA, COUNT BLANK

COUNTIFS based on a condition

SUM & AVERAGE Function

SUMIFS & AVERAGEIFS

MAX & MIN ( MAXIFS &MINIFS)

ROUNDING VALUES

VLOOKUP Function

5) Data cleaning & Management

Sort data

Un Sorting of Data

Filter data

Remove Blank

Remove duplicates

6) Formatting including CONDITIONAL & NUMBER FORMATTING in excel

Formatting including CONDITIONAL & NUMBER FORMATTING

Self Assessment Test

Basic Excel functions and formulas

Resource Files

Download All The Files Here

Get Certificate

Claim Your Certificate

Student Ratings & Reviews

2) Data input
Please Note : Change your user Name Into Roll Number Provided By Us Class Time: 7.00 PM Join Zoom Meeting https://zoom.us/j/99487413869?pwd=V1h1UzVIZVVRMjIyN2k5SDJ0a0RJUT09