كورس برنامج الاكسل 2016
Mach 42 Productions - Excel 2016 Course - Popular Excel Text Functions Explained
Year: 2015
Manufacturer: Mach 42 Productions / Udemy
Manufacturer Website: udemy.com
Duration: 0:32
Type dispensed material: videos
Language English
Description: This bite size course will show you how to use Excel string functions that are frequently used to perform operations on strings for everyday tasks such as cleaning data.
If you want to know how to use common Excel string functions then take this course.
You will learn how to extract text from strings, how to search within strings, how to replace characters in strings and much more.
Each lecture explains the Excel string function and gives examples. Excel is one of the most popular tools used today in businesses. Knowing how to use functions in it is necessary.
I look forward to seeing you on the other side.
The use of line functions in Excel 2016.
Sample Files: present
Video Format: MP4
Video: AVC, 1152x720 (16:10) / 1240x720 (1.722: 1), 30fps, 419kbps
Audio: AAC, 44.1kHz, 64kbps, stereo
PHP Code:
Section 1: Introduction to this course
1 Introduction to Excel course
2 Udemy course completion certificate for LinkedIn - Text
3 Leaving a review - Text
Section 2: Text functions used commonly in Excel part 1
4 Getting the length of a string
5 Strings length quiz - 2 issue (s)
6 Finding text within a string
7 Finding text quiz - 2 issue (s)
Section 3: Text functions used commonly in Excel part 2
8 Extracting text from a string
9 Extracting text quiz - 2 issue (s)
10 Getting rid of excess spaces
11 Trimming text quiz - 2 issue (s)
12 Joining text from different Excel cells
13 Joining text quiz - 2 issue (s)
Step 4: Wrap up section
14 Wrap up lecture
57MB
*
