Microsoft Office培训

Microsoft Office培训

Microsoft Office courses

Testi...Client Testimonials

Project Management with Microsoft Project

Flexibility and ability to adjust to my training needs during the training session itself

Daniela Kostovska - NLMK BELGIUM HOLDINGS

Excel Advanced

examples

Ewelina Palacz - UBS Business Solutions Poland Sp. z o.o.

Excel Advanced

trainer patient and knowledge

Iwona Jawdyk - UBS Business Solutions Poland Sp. z o.o.

Excel Advanced

The training was really useful. I liked the most the parts related to the pivot tables, filtering, lookup options and data consolidation. I appreciated trainer's excellent knowledge on the subject. His attitude was very good as well. He built open and 'not so formal' atmosphere which helped participants to ask the questions or speak about their daily excel issues. He was fully understandable during the whole training and his way of explaining the topics was direct and adequate.

Katarzyna Chalinska - UBS Business Solutions Poland Sp. z o.o.

Excel Advanced

The training was really useful. I liked the most the parts related to the pivot tables, filtering, lookup options and data consolidation. I appreciated trainer's excellent knowledge on the subject. His attitude was very good as well. He built open and 'not so formal' atmosphere which helped participants to ask the questions or speak about their daily excel issues. He was fully understandable during the whole training and his way of explaining the topics was direct and adequate.

Katarzyna Chalinska - UBS Business Solutions Poland Sp. z o.o.

Excel Advanced

The training was really useful. I liked the most the parts related to the pivot tables, filtering, lookup options and data consolidation. I appreciated trainer's excellent knowledge on the subject. His attitude was very good as well. He built open and 'not so formal' atmosphere which helped participants to ask the questions or speak about their daily excel issues. He was fully understandable during the whole training and his way of explaining the topics was direct and adequate.

Katarzyna Chalinska - UBS Business Solutions Poland Sp. z o.o.

Excel Advanced

The training was really useful. I liked the most the parts related to the pivot tables, filtering, lookup options and data consolidation. I appreciated trainer's excellent knowledge on the subject. His attitude was very good as well. He built open and 'not so formal' atmosphere which helped participants to ask the questions or speak about their daily excel issues. He was fully understandable during the whole training and his way of explaining the topics was direct and adequate.

Katarzyna Chalinska - UBS Business Solutions Poland Sp. z o.o.

Excel Advanced

The training was really useful. I liked the most the parts related to the pivot tables, filtering, lookup options and data consolidation. I appreciated trainer's excellent knowledge on the subject. His attitude was very good as well. He built open and 'not so formal' atmosphere which helped participants to ask the questions or speak about their daily excel issues. He was fully understandable during the whole training and his way of explaining the topics was direct and adequate.

Katarzyna Chalinska - UBS Business Solutions Poland Sp. z o.o.

Excel Advanced

The training was really useful. I liked the most the parts related to the pivot tables, filtering, lookup options and data consolidation. I appreciated trainer's excellent knowledge on the subject. His attitude was very good as well. He built open and 'not so formal' atmosphere which helped participants to ask the questions or speak about their daily excel issues. He was fully understandable during the whole training and his way of explaining the topics was direct and adequate.

Katarzyna Chalinska - UBS Business Solutions Poland Sp. z o.o.

Excel Advanced

Training was well prepared from the beginning. Enthusiasm and great attitude of the trainer helped us successfully deliver the training. Positive feelings! Highly recommended!

Łukasz - UBS Business Solutions Poland Sp. z o.o.

Excel Advanced

Possibility to ask various questions and real life solutions to them.

Magdalena Wojtas - UBS Business Solutions Poland Sp. z o.o.

Excel Advanced

Very helpful, made me feel more comfortable using Excel.

TruGreen

Excel Advanced

I appreciated the amount of effort and energy that Roman put into this. Hours and hours and hours of Excel training will inevitably get boring, but Roman's attention to detail, energy, and thoroughness made me want to keep learning--even at 5 PM on the second, of two, eight hour learning days.

Christian Labenberg - TruGreen

Excel Advanced

Relevant examples and interesting corriculum

Alex Gubanov - TruGreen

Excel Advanced

Excellent trainer. Very adept at modifying the course to fit our timeline.

TruGreen

Excel Advanced

Learning new ways to process data in Excel, in an engaging and fun learning environment.

Hunter Smith - TruGreen

Excel Advanced

Interaction with the class

TruGreen

Excel Advanced

The instructor(see Other Remarks below)

TruGreen

Microsoft Office大纲

代码 名字 时长 概览
msproj1 Project Management with Microsoft Project 14小时 The course participants will learn how to skillfully use the Microsoft Project to create a schedule of tasks, manage resources and monitor the implementation of the various stages of the project. Introduction Definition of the project. The key principles of development projects Model triangle Handling Installing the application Features of Microsoft Project Help Save, search, open the project Basic views Schedule Scheduling rules types of schedules Calendars Project Entering tasks to schedule Editing tasks in the schedule Duration of the tasks Time continuous tasks Estimated time for tasks Priority project and task Correlations between tasks Trail and delay Milestones Visualization tasks in different views Optimize schedule Restrictions on tasks Deadline critical Tasks critical Path Extra time in the project Shortening the critical path Customize views Resources Definition of resources Variable costs of resources One-time costs of enforcement Tables rates Availability of resources Jobs - definition Constants in the equation of work The labor input The allocation of resources Overload resources Balancing resources Costs Fixed costs Cost control The costs of the project, tasks, resources, and labor Realization of the project Methods of implementation of the project Baseline Analysis of the state Analysis of deviations Changes in the project Reports Reports in Microsoft Project Create custom reports Search of data Sorting Data Filters Grouping data
ExcelAdv Excel Advanced 21小时 The course participants will be able to efficiently use primarily data analysis tools such as scenarios and pivot tables, use the features to perform calculations on dates and text-processing functions, and create and adapt to the needs of macros to automate work with spreadsheets. Adjustment of the working environment Hotkeys, facilities Create and modify toolbars Options excel (autosave, input, etc.). Options paste special (transpose) Formatting (style, format painter) Tool - go to Organization of information Management sheets (naming, copying, color change) Assign and manage the names of cells and ranges Protect worksheet and workbook Secure and encrypt files Collaboration and track changes, comments Inspection sheet Create your own templates (charts, worksheets, workbooks) Data analysis Logic Basic Features Advanced Features Creation of complex / multiple formulas Scenarios Search result Solver Charts Graphics support (shadows, charts, AutoShapes) Database management (list) Data consolidation Grouping and outlining data Sorting data (over 4 columns) Advanced data filtering Database Functions Subtotal (partial) Tables and Pivot Charts Cooperation with other applications Get External Data (CSV, TXT) OLE (static and link) Web Queries Publication sheets on site (static and dynamic) Publication PivotTables Automation of work Conditional Formatting Create your own formats Check the validation Macros - automation tasks in sheets Registration macros Understanding and modifying the code macros (VBA items) Connecting the interface macros or workbook Create forms on screen or printed
exceldataanal Excel Data Analysis 14小时 Knowledge of Windows and MS Excel basics Excel Data Types Look up values ​​in a spreadsheet Naming the range, create a range of labels Modifying named ranges Create custom number formats Use AutoFormat options in a spreadsheet Create a named style Creating a user template Protection sheets Organizing data in a worksheet Create a list of data Adding to the list of series Creating a custom sort lists Consolidate data Create conspect Processing of data in a spreadsheet Apply conditional formatting Summarizing data with subtotals Filter the list of data Create a custom filter Create an advanced filter Create scenarios Data Validation Creating formulas Aggregation of cell contents using the AutoSum Adding in the dialog window Insert Function Editing formulas Evaluate Formula Using Solver tool to obtain specific values ​​of the arguments Create a conditional formula Using the data table to solve the formulas Tracking error performance formulas Look up values ​​in a particular row or column Determine the value location  Returning values ​​from a cell in a specific location in the data list Positioning of the data list Create a table of credit The processing of information from external data sources Combining data from other Windows programs Importing a delimited text file Dividing a column of data into multiple columns Create a Web Query Importing database table Using queries to selectively retrieve information from external databases Calculate the average of the values ​​stored in the database Produce data charts Changing the chart type Creating a custom chart types Adding a trendline to a chart Adding new values ​​and change data for the chart Create a combination chart Using Pivot Table reports Basic information about PivotTables Overview of PivotTable fields. Create a PivotTable report with a list of data Change the layout of a PivotTable Filtering fields Changing the type of calculation data fields Grouping PivotTable data elements Entering additional calculations to the data area Add a calculated field Adding a calculated Get values ​​from a PivotTable report Creating a PivotChart Performing the pivot of information from external database Change the layout of a PivotChart Changing a PivotChart Filtering fields PivotChart Grouping elements PivotChart field Add a table of data to the PivotChart

其它地区

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

促销课程

订阅促销课程

为尊重您的隐私,我公司不会把您的邮箱地址提供给任何人。您可以享有优先权和随时取消订阅的权利。

我们的客户