Microsoft Office Training in Hsinchu

This instructor-led, live training in Hsinchu (online or onsite) is aimed at This instructor-led, live training (online or onsite) is aimed at beginner-level to intermediate-level business professionals, educators, and marketers who wish to integrate DeepSeek with PowerPoint to automate and optimize their presentations.

By the end of this training, participants will be able to:

• Automate the creation of text-based content in PowerPoint slides using DeepSeek.
• Generate data-driven visuals and infographics powered by DeepSeek models.
• Use AI to summarize long reports and turn them into presentation-ready slides.
• Integrate DeepSeek with PowerPoint for streamlined, dynamic presentations.

Excel is a spreadsheet application designed for data entry, analysis, reporting, and automation.

This instructor-led, live training (available both online and onsite) is aimed at users ranging from beginners to advanced levels who wish to enhance their skills across Excel’s essential, intermediate, and advanced functionalities.

Upon completing this training, participants will be equipped to:

• Work confidently with spreadsheets, formulas, and formatting techniques.
• Utilize intermediate tools such as tables, charts, and conditional logic effectively.
• Apply advanced functions, data analysis features, and automation methods.
• Create professional worksheets that support business decision-making processes.

Format of the Course

• Instructor-led demonstrations and guided explanations.
• Extensive workbook exercises and hands-on practice sessions.
• Practical lab activities using real-world spreadsheet scenarios.

Course Customization Options

• For tailored content based on your department’s specific workflows, please contact us to arrange a customized version of this course.

This instructor-led, live training in Hsinchu (online or onsite) is aimed at beginner-level to intermediate-level professionals who wish to master Microsoft Word, Excel, and PowerPoint for enhanced document creation, data analysis, and presentations.

By the end of this training, participants will be able to:

• Effectively create, format, and manage documents in Microsoft Word.
• Utilize Excel for data entry, analysis, and visualization.
• Design engaging and professional presentations in PowerPoint.
• Leverage collaboration features across Microsoft Office applications.

Excel is a widely utilized spreadsheet application for data organization, analysis, and automation.

This instructor-led, live training (available online or on-site) is designed for intermediate-level Excel users who want to apply Excel for inventory management, budgeting, reporting, and automation using real-world datasets.

By the end of this training, participants will be able to:

• Utilize formulas such as SUMIF, IF, VLOOKUP, and SUMIFS for inventory and purchasing scenarios.
• Efficiently handle and analyze large datasets with over 5,000 rows.
• Create and interpret pivot tables for monthly and cumulative tracking.
• Automate repetitive reporting tasks using macros.
• Track material purchases against consumption using structured templates.

Format of the Course

• Interactive lectures and discussions.
• Plenty of exercises and practice sessions.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

This instructor-led, live training in Hsinchu (online or onsite) is aimed at anyone who wishes to learn and use the software and services available in the MS Office suite to enhance their work productivity.

By the end of this training, participants will be able to:

• Learn and use the different software in the MS Office suite.
• Enhance work productivity and collaborate effectively using MS Office tools and services.

This instructor-led, live training in Hsinchu (online or onsite) is aimed at beginner-level to advanced-level data analysts who wish to use Excel to perform a variety of tasks such as data entry, formula creation, data analysis, and advanced automation.

By the end of this training, participants will be able to:

• Navigate Excel’s interface and perform basic data entry, formatting, and calculations.
• Apply advanced formulas, functions, and conditional formatting for data analysis.
• Create and manage pivot tables and charts for data visualization.
• Use tools like Power Query, Power Pivot, and perform data analysis.
• Automate tasks using macros and VBA to streamline workflows.

This instructor-led, live training in Hsinchu (online or onsite) is aimed at beginner-level to intermediate-level professionals who wish to enhance their productivity and efficiency by leveraging the advanced features of Excel and Google Sheets for data organization, analysis, and collaboration.

By the end of this training, participants will be able to:

• Navigate and utilize the core features of Excel and Google Sheets.
• Perform data analysis and create actionable insights using advanced spreadsheet techniques.
• Collaborate in real-time using Google Sheets for seamless teamwork.
• Create reusable templates for reporting, tracking, and project management.

This instructor-led, live training in Hsinchu (online or onsite) is aimed at MS Office users who wish to master the different tools and techniques of MS Office software and services.

By the end of this training, participants will be able to:

• Learn and master the different shortcut techniques in MS Office.
• Master macros and other Excel functions for faster worksheet manipulation.
• Use PowerPoint controls and advanced features for creating presentations.
• Quickly navigate and search through Outlook.

This instructor-led, live training in Hsinchu (online or onsite) is aimed at data analysts or anyone who wishes to learn how to use Excel for creating data models for data analysis.

By the end of this training, participants will be able to:

• Learn to analyze and solve any business problems using structured problem-solving tools.
• Navigate Excel tools with ease.
• Set up, format, and present data effectively.
• Understand the logical structure and apply correct functions to Excel models.

Microsoft Word is a powerful word-processing application designed for creating, formatting, and managing professional documents.

This instructor-led, live training (available both online and onsite) is aimed at users of all levels, from beginners to advanced, who wish to develop comprehensive skills in creating, editing, formatting, and automating documents using Microsoft Word.

Upon completing this course, participants will be able to:

• Create professional documents with consistent and polished formatting.
• Utilize intermediate features such as styles, templates, and collaboration tools.
• Apply advanced tools like mail merge, references, and automation techniques.
• Enhance productivity by leveraging Word’s advanced layout and document management capabilities.

Format of the Course

• Engaging demonstrations and guided instruction to ensure a hands-on learning experience.
• Extensive practical exercises and skill-building tasks to reinforce understanding.
• Real-time document creation and refinement in a live, interactive environment.

Course Customization Options

• If you need a customized version of this training, please contact us to discuss your specific requirements.

This instructor-led, live training in Hsinchu (online or onsite) is aimed at anyone who wishes to master the fundamentals and features of Microsoft Word to become more productive at work.

By the end of this training, participants will be able to:

• Learn the basics of Microsoft Word to best support daily workday responsibilities for meeting notes, memos, etc.
• Work with different formatting features.
• Manage document collaboration.

The course participants will be able to effectively utilize primary data analysis tools like scenarios and pivot tables, leverage features for performing calculations on dates and text processing functions, and develop and customize macros to automate spreadsheet tasks according to their specific needs.

Excel is a popular spreadsheet program created by Microsoft. Jest used to store, organize and analyze data in tabular form. Here are some key features and functions of Excel: 1. Spreadsheets: It consists of sheets, where each sheet is an array consisting of cells arranged in rows and columns. It allows you to create multiple sheets in one file, which allows you to organize different data sets. 2. Calculations and Formulas: Allows you to perform a variety of mathematical, statistical and logical calculations using formulas. It has a wide set of built-in functions such as SUM, AVERAGE, MAX, MIN, IF, VLOOKUP, etc. 3. Data Formatting and Appearance: Provides tools for formatting data, including changing font, color, style, and creating charts, pivot tables and diagrams. 4. Sorting, Filtering and Grouping: Allows you to sort data according to specific criteria. Allows you to filter data to display only selected information. Possibility to group data depending on needs. 5. Data analysis: Tools for performing advanced analyzes such as scenario analysis, trends, forecasting, and creating macros. 6. Data Sharing: Enables real-time data sharing and collaboration, allowing multiple users to work on the same data simultaneously. 7. Task automation: Ability to create macros and automate tasks using the programming language VBA (Visual Basic for Applications). Excel is widely used in various fields, from business to science and education. Its comprehensive features enable data analysis, creation of reports, budgets, schedules, data management and many other applications.

This instructor-led, live training in Hsinchu (online or onsite) is aimed at data analysts who wish to use advanced VBA in Excel for automating tasks.

By the end of this training, participants will be able to:

• Write an advanced object-oriented application
• Convert text files
• Use of external data sources
• Use external libraries

This instructor-led, live training in Hsinchu (online or onsite) is aimed at data analysts who wish to use VBA in Excel for automating tasks.

By the end of this training, participants will be able to:

• Record and edit macros as required.
• Write procedures using data from the sheet.
• Create your own functions.
• Handle an event (opening worksheet cell update etc.) by means of the handler.
• Create a form.

Audience

This course is designed for analysts, researchers, scientists, graduates, students, and anyone interested in learning how to facilitate statistical analysis using Microsoft Excel.

Course Objectives

This course aims to enhance your familiarity with Excel and statistics, thereby improving the effectiveness and efficiency of your work or research.

The course will cover the use of the Analysis ToolPack in Microsoft Excel, statistical functions, and basic statistical procedures. It will also address Excel's limitations and provide strategies to overcome them.

This instructor-led, live training in Hsinchu (online or onsite) is aimed at data analysts who wish to learn techniques for preparing data in Excel, then visualizing it in Power BI.

By the end of this training, participants will be able to:

• Understand the principles of data analysis, objectives of data analysis, and approaches for data analysis.
• Use DAX formulas in Power BI for complex calculations.
• Create and use visualizations and charts for particular analysis cases.
• Import with Power View to move from Excel based Power BI to independent Power BI.

Data analytics is a vital tool in today's business environment. Our focus will be on developing practical, hands-on skills for data analysis to help participants provide evidence-based answers to key questions:

What has happened?

• processing and analyzing data
• creating insightful data visualizations

What will happen?

• predicting future performance
• assessing the accuracy of forecasts

What should happen?

• transforming data into evidence-based business decisions
• enhancing processes for efficiency

The aim of the course is to empower participants to achieve a thorough understanding and practical application of VBA for Access and Excel.

The participants of the course will be able to efficiently carry out various calculations in a transparent manner, organizing and presenting their results. They will also utilize multiple methods to expedite and simplify spreadsheet creation in Excel.

This instructor-led training (conducted online or on-site) is designed for data analysts looking to leverage Excel for data analysis purposes.

Upon completion of the training, participants will be able to:

• Create spreadsheets using Excel.
• Visualize data through charts, graphs, and other visual aids.
• Produce reports that can be shared with team members.

Course Format

• Engaging lectures combined with discussions.
• Numerous exercises and ample practice opportunities.
• Practical implementation in a live-lab setting.

Customization Options for the Course

• If you require customized training, please contact us to make arrangements.

Throughout the training, we will explore financial analysis challenges using the advanced features of Excel.

This course is designed for financial analysts, accountants, and anyone looking to enhance their spreadsheet skills in the context of financial analysis.

Target Audience

Financial analysts, market analysts, managers, and accountants

Course Goals

To streamline and automate various types of financial analysis using Microsoft Excel

This instructor-led, live training in Hsinchu (online or onsite) is aimed at data analysts who wish to program in R for Excel.

By the end of this training, participants will be able to:

• Toggle and move data between Excel and R.
• Use R Tidyverse and R features for data analytic solutions in Excel.
• Extend their data analytical skills by learning R.

In this instructor-led, live training in Hsinchu (onsite or remote), participants will learn how to combine the capabilities of Python and Excel.

By the end of this training, participants will be able to:

• Install and configure packages for integrating Python and Excel.
• Read, write, and manipulate Excel files using Python.
• Call Python functions from Excel.

The course participants will be able to efficiently carry out a range of calculations in a clear and transparent manner, organize and present their results effectively, utilize various tools to streamline and speed up the creation of spreadsheets, and safeguard their calculations and results from unauthorized access.

Participants will enhance their skills to optimally create, consolidate, and manage data. Various tools are available to streamline workflows, significantly reducing the time required for tasks. These tools can also assist in designing applications capable of performing new and innovative functions.

Participants in this course will learn how to create clean, professional-looking documents, including all types of official correspondence. They will also gain a comprehensive understanding of the fundamental tools that facilitate clear and efficient information flow in both short and long documents.

Participants in the course will learn how to automate the process of creating complex documents, extracting data from databases, and preparing forms.

This course is designed for individuals who are already acquainted with the fundamentals of VBA and wish to expand their understanding and make more extensive use of the language's features.

This training is designed for individuals who work with Microsoft Excel spreadsheets and are looking to enhance their skills and efficiency.

This instructor-led, live training in Hsinchu (online or onsite) is aimed at beginner-level analysts who wish to use Excel VBA to automate repetitive work, clean and transform data, and improve reporting processes.

By the end of this training, participants will be able to: record and edit macros, write simple VBA procedures, work with Excel objects for reporting tasks, and debug basic automation solutions.

Please answer the following questions:

• Is your daily work in Excel a never-ending series of copy-paste commands?
• Are you wasting time repeating similar operations to prepare data for analysis?
• Do you know all the keyboard shortcuts in Excel but still feel unsatisfied with the results?
• Instead of focusing on data analysis, do you find yourself wasting time on data preparation?
• Do you have to manually verify the accuracy of data obtained from various systems?
• Do you often stay late at work or take Excel files home because you can't complete tasks during office hours?
• Is your job to prepare reports based on large datasets?
• Do you feel that working in Excel is a roundabout way to achieve results?

If you answered YES to any of these questions, it's time to put an end to this nightmare. This training is designed for you.

Discover how you can speed up your daily tasks and maximize the potential of MS Excel.

WARNING

After completing the training, your life will change dramatically. Activities that once took the whole day will now take just a few moments. Are you ready for this transformation?

This course is designed to enhance the PowerPoint skills of participants through practical exercises complemented by relevant theoretical knowledge. It is suitable for a wide range of individuals, including presentation designers, conference speakers, and those who frequently give presentations in team meetings.

This course is designed for individuals who wish to enhance their efficiency in PowerPoint, particularly when creating slides and learning the fundamentals of presenting them.

This course is designed specifically for sales teams. It emphasizes using PowerPoint’s features to enhance the sales process, such as presenting data effectively, avoiding overly cluttered slides, and identifying key elements to highlight in a sales presentation.

Objective:

Enhancing the skills needed to create engaging presentations using PowerPoint and other tools.

Target Audience:

This course is designed for sales representatives, consultants, research and teaching staff, managers, teachers, corporate employees, small and medium enterprise (SME) workers, and public institution personnel who need to captivate an audience and spark their interest.

This instructor-led, live training in Hsinchu (online or onsite) is aimed at beginner-level to intermediate-level business analysts and data analysts who wish to use Excel to perform data analysis and reporting for their projects and tasks.

By the end of this training, participants will be able to:

• Use Excel formulas and functions to perform calculations and data manipulation.
• Use Excel data analysis tools such as PivotTables, What-If Analysis, and Forecasting to summarize and visualize data.
• Use Excel charts and graphs to create and customize data visualizations.
• Use Excel data validation and conditional formatting to ensure data quality and highlight data insights.
• Use Excel data import and export features to connect to external data sources and share data with others.

This 1-day training session is tailored for power users of SharePoint who act as site owners and/or Site Collection administrators.

Course objectives:

• Set up site navigation
• Review site activity reports
• Tailor lists and libraries
• Manage Site Columns and Site Content Types
• Configure Check out/in, Content Approval, and Versioning
• Create and edit pages and web part pages

This one-day training session is tailored for individuals who utilize SharePoint as end-users and wish to gain insight into some of the advanced functionalities of the platform. Participants should enroll in this course if they aim to comprehend features such as team collaboration, document management, and social capabilities within Microsoft SharePoint 2013.

This course is intended for:

• SharePoint Site Owners and users

Course goals include:

• Managing Sites and Site Collections
• Adding users and groups, along with managing security settings for sites, lists, folders, and items
• Adding and configuring web parts
• Customizing site options such as theme, title, description, and icon

This instructor-led, live training in Hsinchu (online or onsite) is aimed at IT administrators who wish to use Office 365 as an administrator.

By the end of this training, participants will be able to:

• Answer the most common end-user support requests.
• Troubleshoot start up and version compatibility issues.
• Backup and fix damaged files.

This instructor-led, live training in Hsinchu (online or onsite) is aimed at financial analysts and staff who wish to use Adaptive OfficeConnect in creating financial reports using Microsoft Office Excel, Word, and PowerPoint.

By the end of this training, participants will be able to build, create, and update financial reports in Microsoft Office Suite.

This instructor-led, live training in Hsinchu (online or onsite) is aimed at marketeers who wish to create video content and presentations with Camtasia and PowerPoint.

By the end of this training, participants will be able to:

• Create video content and share it on a video hosting platform.
• Employ assets within Camtasia such as music and icons for interactive content.
• Save on costs by producing HQ videos with Camtasia and PowerPoint.

This course will equip you with the skills to present financial information (numbers) effectively in PowerPoint, going beyond mere presentation techniques. You will learn how to convey financial data in a more professional and polished manner.

This instructor-led, live training in (online or onsite) is aimed at beginner-level to intermediate-level developers who wish to use VSTO to create customized solutions for Microsoft Office applications.

By the end of this training, participants will be able to:

• Create add-ins and document-level customizations for Office applications.
• Access and manipulate the Office object model and its events.
• Create custom ribbons, task panes, and dialogs for Office applications.
• Use Windows Forms controls and .NET components in Office documents.
• Integrate Office applications with web services and databases.
• Deploy and secure Office solutions.