Basic MS Excel Self-Paced Training
Welcome to the Basic MS Excel Self-Paced Training Course.
To get the digital certificate, you must:
1. On the same browser as you are using now, create a new tab, login to your YouTube account, if you have not. Refresh this page after logging into YouTube. (This should make the videos you watch in our page report completion to your YouTube account.)
2. Subscribe to our YouTube page and upload proof here. UPLOAD PROOF
3. While logged in to your YouTube account, watch the videos here in our page. (You can also watch them directly on YouTube-- but the files needed for the training are uploaded here in our website.)
Watch all the 17 videos in the playlist. The videos will be uploaded following this schedule:
However, the certificate is only valid if you completed the course by August 31, 10PM.
S01E01. Text Functions: UPPER, LOWER, and PROPER. <<START>>
S01E02. Text Functions: LEFT, RIGHT, MID
S01E03. Text Functions: CONCATENATE
S01E04. Logical Functions: IF
S01E05. Logical Functions: Combining IF with Other Functions
S01E06. Math Functions: SUM, AVERAGE, COUNT, MAX, MIN
S01E07. Math Functions: COUNTIF, SUMIF, AVERAGEIF
S01E08. Lookup Functions: VLOOKUP
S01E09. Lookup Functions: Looking up in Another Sheet using VLOOKUP
S01E10. Data Tools: Text-to-Columns, Delimited
S01E11. Data Tools: Text-to-Columns, Fixed Width
S01E12. Data Tools: Conditional Formatting Basic
S01E13. Data Tools: Data Bars, Color Scales, and Icon Sets
S01E14. Data Tools: Data Validation Lists
S01E15. Data Tools: Subtotal Tool
S01E16. PivotTables
S01E17. Grouping Data in PivotTables
Upload proof that you completed the video series.
To get the digital certificate, you must:
1. On the same browser as you are using now, create a new tab, login to your YouTube account, if you have not. Refresh this page after logging into YouTube. (This should make the videos you watch in our page report completion to your YouTube account.)
2. Subscribe to our YouTube page and upload proof here. UPLOAD PROOF
3. While logged in to your YouTube account, watch the videos here in our page. (You can also watch them directly on YouTube-- but the files needed for the training are uploaded here in our website.)
Watch all the 17 videos in the playlist. The videos will be uploaded following this schedule:
However, the certificate is only valid if you completed the course by August 31, 10PM.
S01E01. Text Functions: UPPER, LOWER, and PROPER. <<START>>
S01E02. Text Functions: LEFT, RIGHT, MID
S01E03. Text Functions: CONCATENATE
S01E04. Logical Functions: IF
S01E05. Logical Functions: Combining IF with Other Functions
S01E06. Math Functions: SUM, AVERAGE, COUNT, MAX, MIN
S01E07. Math Functions: COUNTIF, SUMIF, AVERAGEIF
S01E08. Lookup Functions: VLOOKUP
S01E09. Lookup Functions: Looking up in Another Sheet using VLOOKUP
S01E10. Data Tools: Text-to-Columns, Delimited
S01E11. Data Tools: Text-to-Columns, Fixed Width
S01E12. Data Tools: Conditional Formatting Basic
S01E13. Data Tools: Data Bars, Color Scales, and Icon Sets
S01E14. Data Tools: Data Validation Lists
S01E15. Data Tools: Subtotal Tool
S01E16. PivotTables
S01E17. Grouping Data in PivotTables
Upload proof that you completed the video series.
What the screenshot proof should look like? It should show that you watched all the videos like below. We will upload all videos in one playlist so you simply have to go to the playlist and all videos should show up like that.
Once you uploaded the proof, its confirmation page will show you the link to the mini quiz that will check for your understanding.
Once you submitted the quiz, you will receive the certificate if you receive a passing score. You can retake if needed.
Good luck and enjoy!
Feel free to chat with us via http://www.fb.com/InsightsManila for any questions.
Once you submitted the quiz, you will receive the certificate if you receive a passing score. You can retake if needed.
Good luck and enjoy!
Feel free to chat with us via http://www.fb.com/InsightsManila for any questions.
