Microsoft Excel courses


代码 名字 时长 概览
exceladvreporting Excel for Advanced Financial Reporting 7小时 In this instructor-led, live training, participants will learn how to use Excel to optimize the reporting process for financial statements. By the end of this training, participants will be able to: Optimize the report creation process Prepare data for Pivot Tables and formula-based reports Import data from various data sources using Open Database Connectivity (ODBC) and Online Analytic Processing (OLAP) Use Tables and PivotTables to create financial reports and analyses Automate the processes involved in reporting Build validation structures into spreadsheet reports Master Excel shortcuts for formatting financial reports Implement Excel templates to improve productivity Reduce errors, simplify reporting processes and improve the quality of reports Audience Experienced Excel user Accounting professionals Financial professionals Format of the course Part lecture, part discussion, exercises and heavy hands-on practice Note This course can be taught using different versions of excel (Excel 2007, Excel 2010, etc.). To request a specific version, please contact us to arrange. Introduction Building a Reporting Model Report Design And Structure Pivot Tables Preparing Spreadsheets Using Summing Functions Other Reporting Functions Defining Range Names Maintenance Conditional Formats Charting Techniques Report Validation Monthly Reporting Process Month-To-Date Reporting Year-To-Date Reporting 12-Month Reporting Closing Remarks


Excel,培训,课程,培训课程, Excel教程,Excel培训师,Excel老师,Excel晚上培训,小组Excel课程,Excel周末培训,一对一Excel课程,学习Excel ,Excel课程,Excel辅导班,学Excel班,Excel讲师,Excel训练,Excels辅导,短期Excel培训,企业Excel培训,Excel远程教育