|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-2016-bootcamp-zero-to-hero-training/
课程评论：没有评论
课程名称：Microsoft Excel 2016 Bootcamp - 从零到英雄培训 课程概述：欢迎参加本次Microsoft Excel BootCamp。在这个课程中，我们将学习Excel在我们职业生活中的各种应用。这门课程专为初学者设计，无需具备Excel的任何先前知识。我们将紧密围绕Excel强大的内置功能，避免复杂的代码和公式，使学习过程更加简单易懂。 该培训课程采用项目为基础的方法。我们将从创建一个简单的公司品牌发票开始，教授如何计算总额和税款。接着，我们会清理一个复杂且混乱的电子表格，利用Excel的自动化功能进行优化。在整理好的数据基础上，您将学习如何通过数据透视表将冗长复杂的信息转化为简单易读的表格和漂亮的图表。课程结束前，您将学会制作有助于输入和排序财务数据的下拉菜单。同时，您还将学习如何将普通的损益表转换为外观良好、易于使用的文档。 请注意，Mac用户的Excel体验与PC用户有所不同，因两者软件略有差异，并不具备完全相同的功能。例如，Mac版本的Excel目前不支持Flash填充，因此请确保您接受这个小部分的功能缺失。 课程项目包括： - 创建报价和发票表单 - 清理和格式化混乱的导入数据 - 库存电子表格 - 数据透视表 - 区域销售报告 - 利润与损失电子表格 - GST和税务计算 - 可用于Word、PowerPoint、InDesign和Illustrator的图表 - 创建与Word文档兼容的电子表格 这个课程将为您提供实用的Excel技能，使您能够在实际工作中更高效地处理数据。
Hi there, Welcome to this Microsoft Excel BootCamp. Together we're going to learn how helpful Excel is in nearly every part of our professional lives.This course is for beginners. You do not need any previous knowledge of Excel. We will stick closely to the powerful built in features of Excel and will not get bogged down in confusing code & complicated formulae.This training course is project based. We start with a simple company branded invoice and explain how to calculate totals & tax. Using a complex and messy spreadsheet we will clean it up using Excels automatic features. With our new tidy data you'll learn how easy pivot tables can turn long and hard to understand information into simple tables & beautiful graphs. Before you're finished you'll be making helpful drop down menus to help you fill out & sort your financial data.. You will learn how to turn uninspiring profit & loss statements into a good looking, easy to use documents. Note: Mac users won't have the same experience of Excel as PC users as the software is slightly different and doesn't contain the exact same features. For example the Mac version of Excel doesn't currently support Flash fill so please make sure you're okay with missing out on some small things.Class ProjectsCreate a quote & invoicing form.Cleaning & formatting messy imported data.Inventory spreadsheet.Pivot tablesRegional Sales ReportProfit & loss spreadsheet.GST & Tax calculationsGraphs for use in Word, PowerPoint, InDesign & IllustratorCreating spreadsheets that work within Word documents.
