Undergraduate Certificate in Teaching Excel Skills
-- ViewingNowThe Undergraduate Certificate in Teaching Excel Skills is a comprehensive course designed to equip learners with the essential Excel skills demanded by today's industry. The course emphasizes the importance of data analysis, visualization, and automation, which are critical for career advancement in various fields.
2,398+
Students enrolled
GBP £ 140
GBP £ 202
Save 44% with our special offer
ě´ ęłźě ě ëí´
100% ě¨ëźě¸
ě´ëěë íěľ
ęłľě ę°ëĽí ě¸ěŚě
LinkedIn íëĄíě ěśę°
ěëŁęšě§ 2ę°ě
죟 2-3ěę°
ě¸ě ë ěě
ë기 ę¸°ę° ěě
ęłźě ě¸ëśěŹí
⢠Excel Basics: Introduction to Excel interface, creating and saving workbooks, navigating sheets, entering and editing data
⢠Working with Formulas: Understanding Excel formulas, basic functions (SUM, AVERAGE, MIN, MAX), relative and absolute cell references
⢠Data Management: Sorting and filtering data, data validation, removing duplicates, text manipulation functions
⢠Data Analysis: PivotTables, conditional formatting, data validation, goal seeking
⢠Charts and Graphs: Creating and customizing charts, using sparklines, understanding chart elements
⢠Formatting and Templates: Cell and sheet formatting, applying and creating templates, using themes
⢠Collaboration and Sharing: Sharing and tracking changes, collaborating with others, exporting to PDF
⢠Excel Add-ins: Introduction to Excel add-ins, using Power Query, Power Pivot, and Power View
⢠Excel Macros: Recording and playing back macros, using Visual Basic for Applications (VBA) to automate tasks
ę˛˝ë Ľ 경ëĄ
ě í ěęą´
- 죟ě ě ëí 기본 ě´í´
- ěě´ ě¸ě´ ëĽěë
- ěť´í¨í° ë° ě¸í°ëˇ ě ꡟ
- 기본 ěť´í¨í° 기ě
- ęłźě ěëŁě ëí íě
ěŹě ęłľě ěę˛Šě´ íěíě§ ěěľëë¤. ě ꡟěąě ěí´ ě¤ęłë ęłźě .
ęłźě ěí
ě´ ęłźě ě ę˛˝ë Ľ ę°ë°ě ěí ě¤ěŠě ě¸ ě§ěęłź 기ě ě ě ęłľíŠëë¤. ꡸ę˛ě:
- ě¸ě ë°ě 기ę´ě ěí´ ě¸ěŚëě§ ěě
- ęśíě´ ěë 기ę´ě ěí´ ęˇě ëě§ ěě
- ęłľě ě겊ě ëł´ěě
ęłźě ě ěąęłľě ěźëĄ ěëŁí늴 ěëŁ ě¸ěŚě뼟 ë°ę˛ ëŠëë¤.
ě ěŹëë¤ě´ ę˛˝ë Ľě ěí´ ě°ëŚŹëĽź ě ííëę°
댏롰 ëĄëŠ ě¤...
ě죟 돝ë ě§ëʏ
ě˝ě¤ ěę°ëŁ
- 죟 3-4ěę°
- 쥰기 ě¸ěŚě ë°°ěĄ
- ę°ë°Ší ëąëĄ - ě¸ě ë ě§ ěě
- 죟 2-3ěę°
- ě 기 ě¸ěŚě ë°°ěĄ
- ę°ë°Ší ëąëĄ - ě¸ě ë ě§ ěě
- ě 체 ě˝ě¤ ě ꡟ
- ëě§í¸ ě¸ěŚě
- ě˝ě¤ ěëŁ
ęłźě ě ëł´ ë°ę¸°
íěŹëĄ ě§ëś
ě´ ęłźě ě ëšěŠě ě§ëśí기 ěí´ íěŹëĽź ěí ě˛ęľŹě뼟 ěě˛íě¸ě.
ě˛ęľŹěëĄ ę˛°ě ę˛˝ë Ľ ě¸ěŚě íë