|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/asset-allocation-in-google-spreadsheet-only-with-formulas/
课程评论：没有评论
课程名称：股票与加密货币：仅使用谷歌表格与公式 概述：本课程将教你如何管理股票、加密货币和贵金属的资产配置。这是你所需的唯一资产配置方案，能够帮助你随时随地更新财务状况。完成课程后，你将能够显示当前存款价值，创建购买决策的监控清单，展示历史价格趋势，构建汇率转换器，评估股息或收入分配，并从多个外部来源导入加密资产及其他币种。 课程内容包括： - 熟悉GOOGLEFINANCE公式 - 查询各个交易所的股票与加密货币 - 查询历史数据 - 使用SUMIF和SUMIFS函数创建自动评估 - 使用IMPORTXML函数查询外部数据 - 利用LEFT和RIGHT函数处理导入数据 - 用VALUE函数将导入数据转换为数字 - 使用IF ERROR捕捉函数和外部数据的错误 - 使用INDEX函数修整表格值 - 进行跨表引用 为什么选择谷歌表格？ 因为只要有互联网，你就能随时随地访问你的财务概览。谷歌云端硬盘几乎能在所有设备上访问，且谷歌表格及其功能是免费的。随着接口和公式的不断发展，我们将能接触到越来越多的金融产品和加密货币。因此，谷歌表格的重要性日益凸显，让你只需一个程序便可管理财务概览。 期待在课堂上与你见面！
That's the only asset allocation you'll need. This course will teach you everything you need to know to stay up to date with your asset management of stocks, cryptos, and precious metals. With this overview, you can keep track of your finances anytime and from anywhere.If you have completed this course, then:you can display your current deposit valueyou can you create a watchlist with purchase decisionyou can you show a historical price history with a trend lineyou can you create a currency converter with showing you the current currency rateyou can you evaluate dividends or income distributions from your bank statementyou can import crypto assets as well as altcoins from various external sourcesWhat we go through in the course:Get to know GOOGLEFINANCE formulaQuery stocks and cryptos on various exchanges with GOOGLEFINANCE.Query historical data.Use SUMIF and SUMIFS functions to create automated evaluationsQuery external data with the IMPORTXML functionPrepare imported data with the LEFT and RIGHT function.Convert imported data to a number with VALUE functionCatch errors of functions and external data with IF ERRORUse INDEX function for trimming table valuesQuerverweise zu anderen Tabellenblätter vornehmenMake cross-references to other spreadsheetsWhy Google Sheets?Because you have access to your financial overview anytime and anywhere there is internetYou can access Google Drive on nearly every deviceGoogle Spreadsheet as well as all functions and used interfaces are free of chargeThe interfaces and formulas are constantly evolving and we will have more and more access to financial products and cryptos.Google Sheet immer wichtiger wird und du somit nur ein Programm zum Bedienen für deine Finanzübersicht benötigstI'm looking forward to see you in classpixelEDI
