课程详情
Too often, Excel users struggle to effectively track data in Excel because they start with the final report in mind. While this seems intuitive, setting up a spreadsheet in this way limits what a person can get from their data. In this course, follow along with Excel MVP Oz du Soleil as he shows how to use Excel features and functions—including Power Query and dynamic arrays—to build and organize basic spreadsheets and transform them into robust tracking systems for any kind of data that is regularly updated. Learn how to create a tracker in Excel that you and your team can use to easily track any kind of data: sales, donations, inventory levels, project statuses, student progress, household spending, and more. Oz wraps up with challenges that invite you to pull together everything you've learned.
您将获得的技能
获取证书，展示成果
分享学到的内容，成为理想行业的达人，获取证书，展示您在课程中所学的知识。
-
在领英档案中的“资格认证”版块下展示
-
下载或打印为 PDF，与他人分享
-
以图片形式在线分享，展现您的技能
了解讲师
学员评价
-
-
Ujunwa Johnson FCA, MBA
Ujunwa Johnson FCA, MBA
Finance Manager |Business Analyst| Chartered Accountant | CSC?
-
内容
课程内容
- 边学边练 1 个练习文件
- 随时随地学习 可在平板电脑和手机上访问
相似课程
下载课程
使用 iOS 或安卓版领英学习 APP，即可在移动设备上离线观看课程。