精選 Microsoft Office 課程

Master in Microsoft Office

課程編號: MMO2001

Excel  

完成課程後您能學會

所有學員完成大師級 Excel 18 小時的商務課程後,將能夠熟練地在工作中運用 Excel, Word, PowerPoint例如 製作 Excel 報告 ( Vlookup, Pivot table, Charts etc.) , Word 製作報告或編寫 resume CV, 或 利用 PowerPoint 製作各種客戶會議需要的專業級 presentation本課程一個就可以滿足所有需求

Excel Advance2 word2

Master in Microsoft Office 商務課程簡介

MMO 高級商務課程,學員無需要任何相關經驗, 只要有基本電腦操作認識便可以報讀。本課程的設計是以公司内部的 MS Office 日常應用為基礎, 所以内容會比較深入, 更會用大量地工作例子及 Interview 的考試問題作爲功課練習, 導師由Excel 開始帶領學員認識 MS Office 内 Excel, Word 及 PowerPoint 三大軟件的應用, 充分瞭解 Excel 的數據分析工具, Word 的文件編寫功能及 PowerPoint 的簡報製作和 Presentation 的技巧

本課程融合了多年的實戰經驗,令各位學員能夠充分利用及了解 MS Office 各版本的特點。由1997年的紮實基礎到2019年版本的最新技術,都能夠靈活運用。

 

課程特色:適合高速及集中的你,快速學習全部技術,投入日常工作中提升效率 

課程時數:18 小時 

課程堂數:6 堂  每堂 3 小時

課程材料:筆記一份,練習檔案一份。

上課模式:一人一機,真人導師教授課程。

公司培訓:本課程適用於公司團體培訓, 詳情可與我們職員聯絡。

報名資格:課程適合任何人士報讀

報名方法:1)網上即時報名  2)  銀行入數報名

上課地點:銅鑼灣

    立即報名:按此報名

    證書認可 : 完成課程後可以申領證書一份


    課程內容:

    Standardizing Excel data
    tick Creating Data with Standard Format
    tick Using data with Define Name Function
    tick Calling the Name with Name Manager
    tick Excel Name as opposite to Object Name
    tick Doing Calculation in Table Cells
    tick Calling Cells in Table Ranges
    tick Advance Tabling and Formatting
    tick Using Advance Filtering with Conditional Formatting
    tick Applying Text to columns with CSV or TEXT files
    tick Using remove duplicate for data validation
    tick Class practice and Homework
     
    Pivot Table Reports
    tick Introduction to Pivot Table
    tick Reporting using Pivot Table in Office documents
    tick Creating Pivot Table Standard Data Format
    tick Pivot Table Data validation
    tick The 4 Major sections in using Pivot Table
    tick Managing Pivot Table Fields
    tick Error Handling with Pivot Table
    tick Understanding the Main group and Sub group of Data Structures
    tick Advance Filtering in Pivot Table
    tick Understanding the limitation of Pivot Table
    tick Grouping data by values, currencies and data values
    tick Applying 3 Major layout and reports in Pivot Table
    tick Refreshing and Updating original data in Pivot Table
    tick Major Business application case studies
    tick Class Practice and Homework
     
    Visualizing Excel Data Information
    tick Applying standard Format data for SubTotal
    tick Creating summarized reports with SubTotal
    tick Using Total to conditional adding data
    tick Generating conditional Total using SubTotal
    tick Structuring Data using Advance Formatting
    tick Applying visual effects with Conditional Formatting
    tick Advance application of Conditional Formatting Rules
    tick Reverse direction of Conditional Formatting
    tick Class Practice and Homework
     
    Advance Application of Excel Functions
    tick Introduction to Excel Functions and Library
    tick 3 Major ideas of Excel Functions
    tick Automation of Excel worksheet with functions
    tick Application of VLOOKUP and HLOOKUP combination
    tick Referencing data with VLOOLUP function
    tick Cross Worksheets VLOOKUP application
    tick Handling ID numbers and invoice numbers data
    tick Create Work Schedule using Date Time functions
    tick Using IF, AND, OR logical functions for automation
    tick Advance application of Nesting multiple functions
    tick Class Practice and Homework
     
    Managing Excel Data Information
    tick Applying standard Format with Data Validation
    tick Using Data Validation as work
    tick Learning Data Validation types and rules
    tick Duplicating Data Validation in worksheets
    tick Reference of Data Validation alerts
    tick Advance cell locking with Data Validation
    tick Create custom Data Validation rules with Formula
    tick Class Practice and Homework

    ----------------------------------------------------------------------------------

    Introduction to  MS Office 2016 Applications
    Tick Icon What is MS Office 2016?
    Tick Icon Introduction to PowerPoint 2016
    Tick Icon Application of MS Office Apps
    Tick Icon Why do we use MS PowerPoint and not other applications?
    Tick Icon Are there any PowerPoint replacements?
    Tick Icon Caution when using Windows / Macintosh and PowerPoint
    Tick Icon Introduction to PowerPoint version
    Tick Icon PowerPoint 2016 vs older versions

    PowerPoint File Format
    Tick Icon Introduction to  PowerPoint file .ppt
    Tick Icon How to open a PowerPoint file in local drive and cloud drive (Onedrive)
    Tick Icon Using the PowerPoint layout
    Tick Icon Using the PowerPoint Tabs layout
    Tick Icon Introduction to PowerPoint Ribbon tabs and functions
    Tick Icon Setting the Ribbon Tabs options
    Tick Icon Understanding The Ribbon Tabs content
    Tick Icon Using the File button

    Saving PowerPoint files for business applications
    Tick Icon How to save a PowerPoint file?
    Tick Icon How to save the PowerPoint file to difference version?
    Tick Icon How to use save and save as options for PowerPoint?
    Tick Icon How to save a file to a server/cloud?
    Tick Icon How to save the file to a PDF file?
    Tick Icon How to open the file in iPad/iPhone?

    PowerPoint Operation and Functions
    Tick Icon Building a PowerPoint presentation.
    Tick Icon How to use a template for a PowerPoint presentation?
    Tick Icon How to insert slides?
    Tick Icon How to delete slides?
    Tick Icon How to move slides?
    Tick Icon How to change the views in PowerPoint?
    Tick Icon How to change the background image?
    Tick Icon Sourcing PowerPoint templates
    Tick Icon How to use TextBox options
    Tick Icon How to use Font options and WordArt
    Tick Icon How to insert and edit images?
    Tick Icon Advance setting for Images
    Tick Icon Cropping an Image
    Tick Icon Adding effect filters to an image
    Tick Icon Adding photo frames to an image
    Tick Icon Adding color filters to an image
    Tick Icon Adding gallery effect to an image
    Tick Icon Removing background for an image
    Tick Icon Reducing the size and resolution for an image
    Tick Icon How to insert and edit transitions and animations?
    Tick Icon Adjusting the transition effect, duration and sound
    Tick Icon Adjusting the direction of the transition
    Tick Icon Adjusting the vector path of the transition
    Tick Icon Adjusting the delay setting of the transition
    Tick Icon Adjusting the animation item orders by using the animation pane
    Tick Icon Adjusting the animation duration and sounds
    Tick Icon Customize the animation effects
    Tick Icon How to insert audio(MP3) and video(MP4,Youtube) to PowerPoint?
    Tick Icon Insert a JPEG, PNG
    Tick Icon Insert a MP3, MP4 or YouTube
    Tick Icon How to insert charts?
    Tick Icon How to insert charts from Excel
    Tick Icon How to edit the Excel data in PowerPoint
    Tick Icon Excel/PowerPoint Integration
    Tick Icon How to play presentation and use presenter view for advance presentation
    Tick Icon Projecting the PowerPoint to second screen or projector

    ----------------------------------------------------------------------------------

    Introduction to  MS Office 2016 Applications
    Tick Icon What is MS Office 2016?
    Tick Icon Introduction to WORD 2016
    Tick Icon Application of MS Office Apps
    Tick Icon Why do we use MS WORD and not other applications?
    Tick Icon Are there any WORD replacements?
    Tick Icon Caution when using Windows / Macintosh and WORD
    Tick Icon Introduction to WORD version
    Tick Icon WORD 2016 vs older versions

     MS Word
    Tick Icon What is MS Word?
    Tick Icon Why do we use MS Word?
    Tick Icon What can MS Word do?
    Tick Icon Introduction to Word layout
    Tick Icon Introduction to the Word file extensions
    Tick Icon Using the Word The ribbons
    Tick Icon Understanding the The ribbon tabs

    Working with Word
    Tick Icon Creating our first document
    Tick Icon Using the Word templates
    Tick Icon Where can I buy a Word template
    Tick Icon Insert Tables in the document
    Tick Icon Insert Bullet points
    Tick Icon Insert Number items
    Tick Icon Controlling the Bullet points and Number items
    Tick Icon Adjusting text size and formatting
    Tick Icon Adjusting symbols in document
    Tick Icon Insert smart art
    Tick Icon Controlling the smart art with bullet points
    Tick Icon Caution when using smart art
    Tick Icon Insert Images
    Tick Icon Advance setting for Images
    Tick Icon Cropping an Image
    Tick Icon Adding effect filters to an image
    Tick Icon Adding photo frames to an image
    Tick Icon Adding color filters to an image
    Tick Icon Adding gallery effect to an image
    Tick Icon Removing background for an image
    Tick Icon Reducing the size and resolution for an image
    Tick Icon Insert Graphs in the document
    Tick Icon Export the Excel graphs to Word
    Tick Icon Insert Hyperlinks
    Tick Icon Insert Header
    Tick Icon Setting the header as templates or custom a header
    Tick Icon Insert footer
    Tick Icon Setting the footer as templates or custom a footer
    Tick Icon Insert Text box
    Tick Icon Insert foot notes
    Tick Icon Set Margin and the margin limite
    Tick Icon Apply printing settings
    Tick Icon Set paper size
    Tick Icon Set Columns
    Tick Icon Set Water mark
    Tick Icon Set Background color
    Tick Icon Set citation and bibliography Style
    Tick Icon How to change one page Horizontal
    Tick Icon How to set auto table of content
    Tick Icon Track Changes
    Tick Icon Compare two documents with track changes

    Excel Advance2

    Excel Advance3Powerpoint2

    word2