What you will learn
- Worksheet Command
CERTIFICATION
At the end of this course, a certificate will be giving to you.
Course Features
- Lectures 35
- Quizzes 0
- Duration 1 Year
- Skill level Intermediate
- Language English
- Students 43
- Certificate Yes
- Assessments Yes
Curriculum
- 2 Sections
- 35 Lessons
- 365 Days
Expand all sectionsCollapse all sections
- Worksheet Command34
- 2.1ADDING CALCULATED COLUMN
- 2.2COMBINE COLUMN
- 2.3COMBINE SHEET
- 2.4COMPARE NETPAY VALUE IN TWO PAYROLL
- 2.5CONVERT CELL TO NUMBER
- 2.6DUPLICATING SHEET
- 2.7FILL SELECTED CELL
- 2.8FORMAT SHEET
- 2.9JOIN (MERGING COLUMN FROM DIFFERENT SHEET)
- 2.10JOIN PAYROLL (FEB MATCH JAN)
- 2.11JOIN PAYROLL (FEB NOT IN JAN)
- 2.12QUEERY BY MATCH
- 2.13QUERY BY EXAMPLE 1
- 2.14QUERY BY EXAMPLE 2
- 2.15QUERY BY FORMULA (DATE)
- 2.16QUERY BY FORMULA (LABEL)
- 2.17QUERY BY FORMULA (NUMERIC)
- 2.18RANDOM SAMPLE
- 2.19RANDOM SAMPLE 2
- 2.20REARRANGE COLUMN
- 2.21REMOVE BLANK ,INSERT,DUPLICATE COLUMN
- 2.22ROW MANIPULATION
- 2.23SLIT BY DATE
- 2.24SORT TO NEW SHEET
- 2.25SORTING BY FIELD TABLE
- 2.26SPLIT BY GROUP
- 2.27SPLIT BY YEAR
- 2.28SPLIT COLUM FROM LEFT
- 2.29SPLIT ON THE SAME SHEET WITH BLANK ROW SEPERATION
- 2.30SPLITING COLUMN
- 2.31STRATA
- 2.32TAG MANIPULATION 1
- 2.33TAG MANIPULATION 2
- 2.34TRANSPOSE
- Downloadable Files1
