Microsoft Excel, Word, PowerPoint Combined 3 Day Training With CoPilot

Microsoft 365 Excel, PowerPoint, Word & Copilot Training course at Intellisoft Singapore
Microsoft 365 Excel, PowerPoint, Word & Copilot Training course at Intellisoft Singapore

Microsoft Word, Excel, and PowerPoint  Training Workshop in Singapore – Combined Class

Word,PowerPoint,Excel 2010 Training @Intellisoft Singapore
Word, PowerPoint, Excel with Copilot in Microsoft 365Training @Intellisoft Singapore

Improve your PowerPoint Presentation skills, Work better with Numbers and Data in Excel  Microsoft 365, and create stunning documents in Microsoft Word by attending a short, 3 day, Hands-on & Practical workshop on Microsoft Office in Singapore.

Course Duration : 3 days is available to Singapore Companies (For company sponsored candidates). Call +65 6250-3575 for Details.

If you want to join our dedicated Excel course in Singapore & improve your skills, we have multiple courses – Basic Excel for Analytics, Advanced Excel Courses in Singapore & VBA Macro Programming Courses.

Learn Microsoft Word,PowerPoint,Excel2010 at Intellisoft
Learn Microsoft 365 Word, PowerPoint, Excel at Intellisoft with Copilot

Microsoft Office (Word, Excel & PowerPoint) for Basic to Intermediate Level is best suited for people who want to get more out of Microsoft Office Suite and make the best use of the software in their day-to-day use.

Learn Office 365 tips and techniques that will make your work you work faster, efficiently, and you will be able to do complex tasks in a short time.

Excel, Word & PowerPoint are simple office productivity tools from Microsoft, and are very easy to pick up, once you follow our step-by-step, practical and useful approach to learning the software to maximize your efficiency and effectiveness with the use of these popular software packages.

Learn Copilot for Office 365 - Word, Excel, PowerPoint
Learn Copilot for Office 365 – Word, Excel, PowerPoint

Go To Top

This program is highly recommended for those who want to understand the concepts of Documents, Spreadsheets and Presentations, and want to demonstrate the ability to expertly use these applications on a personal computer.

Beginner users and People who know the basics, but want to learn the Intermediate features of Microsoft Excel, Word & PowerPoint will find this program extremely useful.

Go To Top

 

Day 1: Microsoft Excel 

Section 1: Formulas and Functions 

Entering Formulas
Excel Arithmetic Operators
Using AutoFill Options
Commonly Used Functions

Section 2: Organizing Worksheet and Table Data

Create and Modify Tables
Sort and Filtering Data
Get Summary Information in a Table

Section 3: Working with Charts

Summarizing Data Using Charts
Customizing Chart Data
Format Chart Legend and Titles
Creating a Pie Chart

Section 4: Working with Graphics

Add Pictures into a Worksheet
Customize Pictures and Objects
Add Drawing Objects
Add SmartArt

Section 5: Managing Large Workbook

Manage Large Workbook Printing
Worksheets Setting
Page Setup Options

Section 6: Customizing & Enhancing Workbooks

Customizing Excel to Your Work
Creating Hyperlinks
Customizing Quick Access Toolbar

Section 7: Analyze and transform data with Microsoft 365 Copilot in Excel

Analyze your data
Transform your data
Add Tables
Add Charts
Sort & Filter Data

Day 2: Microsoft Word 

Section 1: Manage documents

Format documents
Save and share documents
Insert text and paragraphs
Format text and paragraphs
Create and configure document sections

Section 2: Manage tables and lists

Create tables
Modify tables
Create and modify lists

Section 3: Create and manage references

Create and manage reference elements
Create and manage reference tables

Section 4: Insert and format graphic elements

Insert illustrations and text boxes
Insert shapes
Insert pictures
Insert SmartArt graphics
Insert screenshots and clips
Insert text boxes
Format illustrations & text boxes
Add text to graphic elements

Section 5: Manage document collaboration

Add and manage comments
Manage change tracking

Section 6: Maximize the AI features using Copilot in Microsoft Word
Draft a new document
Use the Copilot pane to chat with Copilot in Word
Linking files in Copilot in Word
Facilitate Collaboration using real-time coauthoring

Day 3: Microsoft PowerPoint 

Section 1: Working With Text 

Using an Outline Adding Text Using Bullets and Numbering Formatting Text & Paragraphs Using Text Boxes Setting Tabs

Section 2: Adding Multimedia Elements

Using Multimedia Elements Working With Pictures Applying Styles & Effects Modifying Hyperlinks Working With SmartArt

Section 3: Enhancing Presentations

Adding Audio & Video Media
Using Animation
Managing Multiple Transitions
Changing Animation Order
Using Slide Transitions

Section 4:  Preparing The Slide Show

Reviewing The Presentation Customizing the Presentation Proofing the Presentation Setting up a Slide Show Using Presentation Tools
Using Presenter View Rehearsing a Presentation Presenting The Slide Show

Section 5: Design captivating presentations with Microsoft 365 Copilot in PowerPoint

Create a new presentation
Transform written documents into presentations
Adjust layouts, reformat text, and time animations

Microsoft 365 Course in Singapore with Excel, Word, PowerPoint & Copilot - With WSQ Funding, UTAP, SkillsFuture, SFEC Grants & Absentee Payroll
Microsoft 365 Course in Singapore with Excel, Word, PowerPoint & Copilot – With WSQ Funding, UTAP, SkillsFuture, SFEC Grants & Absentee Payroll

Go To Top

Basic knowledge of computers, using the keyboard, mouse and Windows is required. This is an Intermediate level program, so we will teach you all about Microsoft Office and then how to get the most of it for day to day use at your office or home.

Go To Top

Post-Course Support

  • We provide free consultation related to the subject matter after the course.
  • Please email your queries to training@intellisoft.com.sg and we will forward your queries to the subject matter experts.
Microsoft Training at Intellisoft

Learn Practical Skills

Companies sponsoring their staff for this Microsoft Excel, Word, PowerPoint training will benefit from increased employee productivity.

Your team will learning the fundamentals of Microsoft Office 365 easily.

Excel Dashboard Training Participants

3 Days Workshop

Enhance your team's efficiency and effectiveness with Microsoft Excel, Word, PowerPoint Combined 3 Day Training.

Contact us for advise on how to go about how to get started in learning the fundamentals of Microsoft Office 365 easily.

Get Started Today!

Learn By Doing

You learn best when you Do It Yourself.

We teach you, step by step, how you can learn new skills, build your knowledge and enhance your career prospects quickly & easily, with Practical Tips & Tricks!

Training Course Fees

The full course fees for this training is S$980, before any Government funding.
For Singaporean/PR above 21 years, Training Grants are available.
For Foreigners, no government grants are available.

Grant Information

WSQ funding from SkillsFuture Singapore (SSG) is available to Singaporeans/PRs above 21.
(Both Individuals & Company Sponsored ).

Individual Singaporeans, 25 years & above can also use their SkillsFuture Credits for this training at Intellisoft.

NTUC Members can utilize UTAP Funds to offset 50% of the remaining fees*.

Contact us for more information on How to apply for this SkillsFuture Grant.
Call +65-6250-3575 for Details or WhatsApp Now at +65-9066-9991

up to 70% Grant

$686 Funding by SSG
Pay $294
  • Singaporeans Above 40 Years
  • Individuals
  • SME Companies
  • Individuals Can Use SkillsFuture
  • UTAP Funding*

up to 50% Grant

$490 Funding by SSG
Pay $490
  • Below 40 Years
  • Individuals
  • SG / PR / MNC Companies
  • SkillsFuture (Singaporeans only)
  • UTAP Funding*

Do You Have Any Questions or Need a Quotation?

Simple. Just tell us what you need. We’ll be glad to help you!

Some of the companies that experienced our trainings

How To Register

Register for the 3 Days of Microsoft Office 365 with Copilot training today by simply clicking on the chosen course date available at the top of this page. Need Help?

  1. Call us at +65 6250-3575, SMS / WhatsApp: +65 9066–9991
  2. Send an email  to  training@intellisoft.com.sg  OR
  3. Submit an online enquiry if you have  any questions regarding Microsoft 365 Excel, Word and PowerPoint with Copilot training.

You can call us at +65  6250-3575 for your Customized Corporate training enquiry.

Learn Microsoft Office 365 With CoPILOT
&
Enhance Your Productivity

Microsoft Office Training in Singapore - Learn Word, Excel, PowerPoint in 3 days

Data Analytics With Excel & Power BI​

This Data Analytics course gives you the essential knowledge &  skills to analyze data with modern tools like Excel & Visualize Data using Power BI.

Microsoft Power BI Suite Traning in Singapore
Microsoft Power BI Suite Traning in Singapore

Statistical Analysis techniques, Excel Pivot Tables Wizardary and Power BI Data Visualization Dashboards are explored to analyze big data from a diverse dataset. 

WSQ Grants & SkillsFuture can be used for Data Analytics Course.

A great course for Beginners to learn the Fundamentals of Data Analysis with the #1 Business Intelligence tools: Microsoft Power BI & Microsoft Excel.

Data Analytics make it easy to understand past data, and forecast future trends, helping you make sense of and decide on the Best course of action, with our Step-by-step, Practical, Hands-on training!

PowerBI Bar, Line, Column & Donut Charts

This WSQ Funded Data Analytics With Excel & Power BI course in Singapore teaches you how to get started into Data Analysis, use Statistical techniques in Excel, create Pivot Table Reports, and Visualize Data with Power BI Dashboards easily.

Power BI Dashboard training in Singapore

This course provides essential knowledge and skills relating to data analytics concepts, statistical analysis, data set preparation, data set summarization and data visualization successfully.

You will gain expertise in analyzing production data and chart future course of action confidently with these sophisticated Data Analytics Tools

Our objective is to train you to  be able to perform the following Data Analytics Tasks well:

  • Understand the key concepts of data analytics in business
  • Understand and apply key statistical analysis concepts
  • Import data into a spreadsheet and prepare it for analysis using data cleansing and filtering techniques
  • Summarize data sets using Pivot tables and Pivot charts.
  • Understand and apply Data Visualization Techniques & Tools
  • Create and Share Interactive Reports & Dashboards with the Best Data Visualization Tool – Power BI

HIGHLY Recommended for People who want to Upgrade themselves & Move to the Next Level

Go To Top

Course Duration:  2 full days

Course Timings: 8.45 am – 5.45 pm

Target Audience: For beginners in Data Analytics, or even complete newbies to Power BI.

You will learn the initial steps in understanding and analyzing data, using statistical analysis, importing large datasets from Excel, Websites or Databases, shaping data with formulas & functions, aggregate it with Excel Pivot Tables, create Frequency Distributions and finally create Dashboards to visualize it with amazing charts in Power BI.

Go To Top

SkillsFuture Data Analytics Training in SingaporeDATA ANALYTICS FUNDAMENTALS

  • Introduction to Data Science
  • Principles of Data Modeling
  • Data Science Techniques & Applications
  • Data Extraction Methods
  • Data Analysis Tools
  • Data Visualization in Power BI
  • Data Cleansing in Excel

DATA ANALYSIS TOOLS & TECHNIQUES

  • Data Protection & Compliance
  • Extract Data from Multiple Sources
  • Data Science Techniques
  • Application of Data Science Techniques to Excel Data
  • Advantages & Disadvantages of Business Intelligence Tools like Power BI
  • Creation of Data Structures for Data Science
  • Statistical Analysis in Excel & Power BI

Data Visualization for Business Insights

  • Create Dashboards in Power BI
  • Generate Business Insights from published and shared Dashboards
  • Present Business Reports & Insights to Target Audience

Go To Top

Prerequisites: Basic knowledge of PC skills, Microsoft Excel, and Windows and an open mind, interested in exploring and learning new things. Prior knowledge of Power BI is not required.

Certification: Successful trainees will receive the WSQ Certificate of Attainment for Data Analytics from SSG. Students must pass 120 minutes of written and practical assessment at the end of the Data Analytics training course to qualify for the Grants & Certification.

Learners’ Profile:

  1. Any learner with a basic proficiency in reading, writing, and understanding English, basic knowledge of Excel can pick up the Data Analytics Skills with Power BI
  2. We look for participants with Secondary education as a per-requisite
  3. Participants should have completed the Basic PC Skills training, Basic Excel Training and be familiar with Windows operating system.

Go To Top

Post-Course Support

  • We provide free consultation related to the subject matter after the course.
  • Please email your queries to training@intellisoft.com.sg and we will forward your queries to the subject matter experts.

SkillsFuture Ready

Singaporeans can use $500 SkillsFuture Credits for this training to offset the course fees.

Contact us for advise on how to go about claiming your SkillsFuture.

Get Started Today!

Learn By Doing

You learn best when you Do It Yourself.

We teach you, step by step, how you can learn new skills, build your knowledge and enhance your career prospects quickly & easily, with Practical Tips & Tricks!

Do You Have Any Questions or Need a Quotation?

Simple. Just tell us what you need. We’ll be glad to help you!

Some of the companies that experienced our trainings

"What I love about this training is that the trainers make sure we learn the steps and are able to do it on our own. This is a real advantage and I will definitely come back for more practical training"
Michele Martin
HR Manager
“The training was everything I hoped for, and more. Intellisoft Systems really makes a difference, I would have never discovered the hidden features of the sotftware on my own. Thanks a lot Intellisoft !"
Joy Tan
Project Engineer

How To Register

Simply fill this Online Registration Form to book your seat.
Our Training Officer will get in touch with you to confirm your seat shortly.

You can call at at +65 6252-5033 or 9066-9991 (Whatsapp now) if you have any questions.

Accelerate Your Career With the Most Effective & Practical Training.

Advanced Power BI MasterClass

Visualization using Advanced Power BI Tips & Tricks

Visualization using Advanced Power BI Tips & Tricks

Unlock the full potential of Power BI with our Advanced Power BI course!

Dive deep into

  • Advanced DAX measures,
  • Explore sophisticated use cases for Power Query, and
  • Master data visualization using advanced settings.

Learn to implement row-level security, keep your data models optimized, and import custom visuals.

Enhance your reports with Python or R visuals, and leverage new KPI cards, Gauges, and more to create Stellar Dashboards for your management.Add Python Visualizations and Scripts in Power BI

This comprehensive two-day Advanced Power BI course in Singapore is designed for those who already know the basics of Power BI and are ready to elevate their skills to the next level.

Learn From Power BI Experts

Led by Power BI Guru Vinai Prakash, with over 35 years of experience in data analysis and business intelligence, this course promises hands-on, practical learning to empower you with advanced skills.

This is a very practical, and hands-on course on Power BI that will transform your Data Analysis skills and make you a PRO in using Advanced Power BI Features

  • Master advanced DAX measures for more powerful data analysis.
  • Explore advanced use cases and techniques in Power Query.
  • Learn data visualization best practices and advanced settings.
  • Implement row-level security to protect your data.
  • Optimize your data models to keep them small and efficient.
  • Import and use custom visuals to enhance your reports.
  • Create Python or R visuals for more dynamic data presentations.
  • Utilize new KPI cards, gauges, and other visuals to add value.
  • Understand and apply AI features, Quick Measures, and Advanced Time Intelligence Comparisons.

Master Time Intelligence Function in Power BI Advanced Course at Intellisoft Singapore.

Go To Top

This course is perfect for:

  • Business analysts and data professionals who have a basic understanding of Power BI.
  • Professionals looking to enhance their data visualization and analysis skills.
  • Individuals seeking to implement advanced Power BI features in their work.
  • Anyone interested in taking their Power BI knowledge to an intermediate or advanced level.

Best Advanced Power BI dashboard Course in Singapore

Go To Top

ADVANCED POWER BI – COURSE OUTLINE

Section 1: Data analytics With Power BI

  • Understanding data analytics
  • Explore Roles in data Analysis
  • Key Tasks for a data analyst
  • Introduction to Power BI Desktop Advanced Features
  • Components of Power BI
  • Understanding Power BI Services

Section 2: Design a data model in Power BI

  • Get data from files & folders

    Advanced Analytics in Power BI Class

  • Get data from relational data sources
  • Get data from a NoSQL database
  • Get data from online services
  • Select a storage mode
  • Get data from Azure Analysis Services
  • Fix performance issues
  • Resolve data import errors
  • Understanding Constraints & Performance issues
  • Understand data types mismatch issues
  • Resolving data quality errors

Section 3: Data Cleansing With Power BI

  • Shape the initial data
  • Simplify the data structure
  • Evaluate and change column data types
  • Combine multiple tables into a single table
  • Profile data in Power BI
  • Use Advanced Editor to modify M code

Section 4: Creating Advanced DAX measures in Power BI

  • Using the Calculate function
  • Understanding Filter Context
  • Using IF, SWITCH, FIND
  • Using VALUES, HASONEVALUE, SELECTEDVALUE, and CONCATENATEXUse sophisticated Time Intelligence Functions in Power BI
  • Using ALL, ALLEXCEPT, ALLSELECTED, KEEPFILTERS
  • Creating Virtual Tables
  • Create semi-additive measures
  • Advanced Date Comparisons With Same Period Last Year, Year To Date, Month to date totals,
  • Using Date Functions like DATEADD, FIRSTDATE, LASTDATE, NEXTYEAR
  • Writing Custom Time Intelligence Functions
  • Using RELATED & RELATEDTABLE functions in Power BI

Section 5: Performance Optimization in Power BI

  • Performance optimization Considerations
  • Review performance of Measures, Relationships, and visuals
  • Using variables to improve performance & Troubleshooting
  • Reduce cardinality in the Data Model
  • Optimize DirectQuery models with table level storage
  • Create and manage aggregations

Power BI Dashboard Course for Advanced Users

Section 6: Working with Power BI visuals

  • Introduction to Advanced Power BI visualizations
  • Add visualization items to reports
  • Choose an effective visualization
  • Format and configure visualizations
  • Import a custom visual into Power BI
  • Add an R or PYTHON visual in a reportPython Visuals in Power BI Advanced training course

Section 7: Create a data-driven story with Power BI reports

  • Introduction to create a data-driven story with Power BI reports
  • Design a report layout
  • Add buttons, bookmarks, and selections
  • Design report navigation
  • Use advanced interactions and drill through
  • Configure conditional formatting
  • Apply slicing, filtering, and sorting
  • Publish and export reports
  • Comment on reports
  • Fine Tune report performance
  • Optimize reports for mobile use

Section 8: Create dashboards in Power BI

  • Introduction to dashboards
  • Configure data alerts
  • Explore data by asking questions
  • Add a dashboard theme
  • Pin a live report page to a dashboard
  • Configure a real-time dashboard
  • Configure data classification
  • Explore mobile view & Auto Mobile Layouts

Section 9: Perform analytics in Power BI

  • Introduction to analytics
  • Advanced Power BI Course in Singapore at Intellisoft SystemsExplore statistical summary
  • Identify outliers with Power BI visuals
  • Group and bin data for analysis
  • Apply clustering techniques
  • Conduct time series analysis
  • Use the Analyze feature
  • Use advanced analytics custom visuals
  • Review Quick insights
  • Apply AI Insights

Section 10: Work with AI visuals in Power BI

  • Introduction to working with AI visuals
  • Use the Q&A visual
  • Find important factors with the Key influencers visual
  • Use the Decomposition Tree visual to break down a measure

Section 11: Create and manage workspaces in Power BI

  • Distribute a report or dashboard
  • Monitor usage and performance
  • Recommend a development life cycle strategy
  • Troubleshoot data by viewing its lineage
  • Configure data protection

Section 12: Secure Access With Row-Level Security

  • Configure row-level security with the static method
  • Configure row-level security with the dynamic method

Section 13: Manage datasets in Power BI

  • Create dynamic reports with parameters
  • Create what-if parameters
  • Use a Power BI gateway to connect to on-premises data sources
  • Configure a dataset scheduled refresh
  • Configure incremental refresh settings
  • Manage and promote datasets
  • Troubleshoot service connectivity

Go To Top

  • Basic knowledge of Power BI, including data import and basic DAX measures.
  • Familiarity with creating basic reports and dashboards in Power BI.

Go To Top

Post-Course Support

  • We provide free consultation related to the subject matter after the course.
  • Please email your queries to training@intellisoft.com.sg and we will forward your queries to the subject matter experts.

SkillsFuture Ready

Singaporeans can use $500 SkillsFuture Credits for this training to offset the course fees.

Contact us for advise on how to go about claiming your SkillsFuture.

Get Started Today!

Learn By Doing

You learn best when you Do It Yourself.

We teach you, step by step, how you can learn new skills, build your knowledge and enhance your career prospects quickly & easily, with Practical Tips & Tricks!

Do You Have Any Questions or Need a Quotation?

Simple. Just tell us what you need. We’ll be glad to help you!

Some of the companies that experienced our trainings

"What I love about this training is that the trainers make sure we learn the steps and are able to do it on our own. This is a real advantage and I will definitely come back for more practical training"
Michele Martin
HR Manager
“The training was everything I hoped for, and more. Intellisoft Systems really makes a difference, I would have never discovered the hidden features of the sotftware on my own. Thanks a lot Intellisoft !"
Joy Tan
Project Engineer

How To Register

 Register for Advanced Power BI Training Course in Singapore at Intellisoft

  1. Visit Our Website: Go to Intellisoft Training.
  2. Find the Course: Navigate to the “Advanced Power BI” course page.
  3. Fill Out the Form: Complete the registration form with your details & Submit the form

This hands-on, practical course will be taught by Power BI Guru Vinai Prakash, who has over 35 years of experience in data analysis and business intelligence.

Don’t miss this opportunity to learn from the best and transform your data analysis capabilities!

TESTIMONIALS FROM OUR ADVANCED POWER BI COURSE ATTENDEES

“The Advanced Power BI course exceeded my expectations. Vinai’s expertise and practical approach made complex concepts easy to understand. I feel much more confident in my ability to create impactful reports and dashboards now.” Sarah Lim, Data Analyst, Vodafone

“Taking this course was a game-changer for my career. The hands-on exercises and real-world examples provided invaluable insights. Vinai is an outstanding instructor who truly cares about his students’ success.”
John Tan, Director, Business Innovation

Best Advanced Power BI dashboard Course in Singapore

 

Accelerate Your Career With the Most Effective & Practical Training.

Training Course Fees

The full course fees for this training is S$1,200, before any Government funding.
For Singaporean/PR above 21 years, Training Grants are available.
For Foreigners, no government grants are available.

Grant Information

WSQ funding from SkillsFuture Singapore (SSG) is available to Singaporeans/PRs above 21.
(Both Individuals & Company Sponsored ).

Individual Singaporeans, 25 years & above can also use their SkillsFuture Credits for this training at Intellisoft.

Companies sending Locals & Foreign staff for training can avail SFEC Funding
Use it to improve the skills of your entire department!

NTUC Members can utilize UTAP Funds to offset 50% of the remaining fees*.

Contact us for more information on How to apply for this SkillsFuture Grant.
Call +65-6252-5033 for Details or WhatsApp Now at +65-9066-9991

up to 70% Grant

$840 Funding by SSG
Pay $360
  • Singaporeans Above 40 Years
  • Individuals
  • SME Companies
  • Individuals Can Use SkillsFuture
  • UTAP Funding*

up to 50% Grant

$600 Funding by SSG
Pay $600
  • Below 40 Years
  • Individuals
  • SG / PR / MNC Companies
  • SkillsFuture (Singaporeans only)
  • UTAP Funding*

Power Query & Power Pivot for Deep Analysis with Excel

Power Query and Power Pivot in Excel Course at Intellisoft Singapore
Power Query and Power Pivot in Excel Course at Intellisoft Singapore
Power Query and Power Pivot in Excel Course at Intellisoft Singapore

Power Query is a feature in Excel that allows you to quickly import data from multiple sources and easily clean, transform, and reshape it to suit your needs. We show you how to use this powerful, time-saving tool to do deep cleansing of data, and then do a deeper analysis of data with Microsoft Excel’s Power Pivot. This course teaches you how to import, merge, rearrange, and clean data, as well as how to repeat the process with one click if the data changes.

Power Query Training in Singapore at Intellisoft

Discover how to split columns, unpivot data, and use joins to merge, segment, and compare datasets. Data Analysis Expressions (DAX) allow Microsoft Excel users to create powerful calculated fields in Power Pivot. In this course, you will learn how to use the DAX language and Power Pivot to explore and analyze relational data models. You will master how to add calculated columns and measures to data models in Excel.

Power Pivot Options in Excel - Learn Power Pivot with WSQ Funding in Singapore at Intellisoft

We highlight the differences between calculated columns and DAX measures, covers common DAX formulas and functions, and discusses best practices for working with DAX and Power Pivot.

Full of dozens of tips, tricks & techniques in this comprehensive, practical, hands-on training using Power Query and Power Pivot in Excel for Deep Data Analysis.

The “Power Query & Power Pivot for Deep Analysis with Excel” course is designed to equip participants with advanced skills in data manipulation, analysis, and visualization using Excel’s powerful tools, Power Query and Power Pivot.

Participants will start by mastering Power Query, learning how to import data from various sources, clean and transform it efficiently. Moving into Power Pivot, they will delve into data modeling techniques, establishing relationships between tables, and creating calculated columns and measures using DAX expressions.

Power Query Training in Excel at Intellisoft Singapore - Learn How To Merge in Power Query at Intellisoft

Throughout the course, emphasis will be placed on practical applications through hands-on exercises and real-world case studies, enabling participants to analyze complex datasets, generate insightful visualizations, and optimize performance for large-scale data scenarios.

By the end of the course, participants will have the tools and knowledge to confidently handle diverse data challenges, automate workflows, and enhance decision-making processes using Excel as a robust analytical platform.

Go To Top

The target audience for the “Power Query & Power Pivot for Deep Analysis with Excel” course includes professionals and individuals who work extensively with data in Excel and wish to deepen their analytical capabilities. This course is ideal for:

  1. Data Analysts: Professionals who analyze and interpret data regularly and want to leverage advanced Excel tools for more efficient and insightful analysis.
  2. Business Intelligence Professionals: Individuals involved in creating reports, dashboards, and data visualizations who seek to enhance their skills in data modeling and manipulation.
  3. Financial Analysts: Those responsible for financial modeling, forecasting, and budgeting who want to streamline data handling and improve accuracy in their analyses.
  4. Excel Power Users: Individuals already proficient in Excel who want to expand their toolkit with Power Query and Power Pivot for more sophisticated data transformations and analysis.
  5. Managers and Decision-Makers: Leaders who rely on data-driven insights to make informed decisions and wish to improve their ability to extract and present meaningful insights from data.
  6. IT Professionals and Consultants: Those tasked with managing and optimizing data workflows within organizations who want to leverage Excel’s capabilities for enhanced data management and reporting.

Overall, the course is suitable for anyone looking to advance their Excel skills specifically for data analysis, whether in business, finance, consulting, or other fields where data-driven decision-making is critical.

Go To Top

Power Query & Power Pivot for Deep Analysis with Excel

Course Outline

Day 1: Power Query Essentials and Intermediate Techniques

Power Pivot Data Model Training in Singapore at Intellisoft

Module 1: Introduction to Power Query

  • Understanding the Role of Power Query in Data Preparation
  • Navigating the Power Query Interface
  • Key Use Cases of Power Query in Business Scenarios
  • Differences Between Power Query in Excel and Power BI

Module 2: Data Transformation Basics

  • Importing Data from Various Sources (Excel, CSV, SQL, Web, etc.)
  • Data Cleaning Techniques: Removing Errors, Replacing Values
  • Reordering Columns and Rows for Analysis
  • Splitting and Merging Columns

Module 3: Advanced Data Transformation

  • Advanced Filtering Techniques for Targeted Data Extraction
  • Creating Custom Columns with Conditional Logic
  • Using the Fill Down and Fill Up Features for Missing Data
  • Advanced Grouping and Aggregating Techniques for Summarized Data

Module 4: Introduction to M Language

  • Exploring the M Language Syntax and Structure
  • Editing Queries Directly in the Advanced Editor
  • Creating Custom Functions for Reusable Logic
  • Common M Functions for Data Manipulation (e.g., Table.TransformColumns, Text.Combine)

Module 5: Case Studies and Practical Exercises

  • Real-World Scenario: Preparing Sales Data for Reporting
  • Combining Data from Multiple Files and Folders
  • Practice Exercises with Provided Datasets
  • Group Discussion on Common Data Challenges

Day 2: Power Pivot and Advanced Analytics

Module 6: Introduction to Power Pivot

  • Overview of the Power Pivot Add-in: Activation and Setup
  • Loading Data into the Power Pivot Data Model
  • Understanding Table Relationships: One-to-One, One-to-Many
  • Creating Hierarchies for Advanced Data Navigation

Module 7: DAX Fundamentals

  • Overview of DAX: Syntax and Functions
  • Understanding Row Context vs. Filter Context
  • Creating Basic Calculated Columns and Measures
  • Using Aggregation Functions (SUM, AVERAGE, COUNT, DISTINCTCOUNT)

Module 8: Advanced DAX Techniques

  • Time Intelligence Functions: Calculating YTD, QTD, MTD, and Rolling Averages
  • Advanced Logical Functions: SWITCH, IFERROR, CALCULATE
  • Working with Iterative Functions: SUMX, AVERAGEX
  • Troubleshooting DAX Formulas and Debugging Errors

Module 9: Optimizing Data Models

  • Understanding the Importance of Star and Snowflake Schemas
  • Best Practices for Efficient Data Models: Reducing File Size, Avoiding Duplicates
  • Using the Diagram View for Relationship Management
  • Performance Tuning: Analyzing and Optimizing Query Performance

Module 10: Advanced Analytics and Reporting

  • Creating Slicers and Filters for Interactive Dashboards
  • Designing Effective Power Pivot Reports with Visual Insights
  • Using KPIs to Track and Display Key Business Metrics
  • Integrating Power Query and Power Pivot for Dynamic Reporting

Module 11: Final Project and Review

  • Hands-On Project: Building an Interactive Dashboard from Raw Data
  • Applying Power Query and Power Pivot to Solve Business Problems
  • Course Recap: Key Takeaways and Best Practices

These objectives aim to provide participants with a comprehensive understanding and practical skills in leveraging Power Query and Power Pivot for deep data analysis within Excel, preparing them to handle complex data challenges effectively.

Go To Top

To join the “Power Query & Power Pivot for Deep Analysis with Excel” course, participants should ideally have the following prerequisites:

  1. Proficiency in Excel: Participants should be familiar with basic to intermediate Excel functionalities, including navigating through worksheets & using simple formulas and functions.
  2. Understanding of Data Concepts: A basic understanding of fundamental data concepts such as tables, rows, columns, and data types is recommended.
  3. Familiarity with Data Analysis: Some experience in data analysis tasks like sorting, filtering, and basic data manipulation within Excel will be beneficial.
  4. Motivation to Learn: An eagerness to explore advanced data manipulation techniques and a willingness to engage in hands-on exercises and case studies throughout the course.

These prerequisites will ensure that participants can effectively engage with the course content, grasp advanced concepts in Power Query and Power Pivot, and apply their knowledge to real-world data analysis challenges using Excel.

Go To Top

Post-Course Support

  • We provide free consultation related to the subject matter after the course.
  • Please email your queries to training@intellisoft.com.sg and we will forward your queries to the subject matter experts.

Venue:

All courses are conducted at:

190 Middle Road, 10-08 Fortune Centre, Singapore 188979.  5 mins walk from Bencoolen MRT station. Bugis, Rochor, Bras Basah MRT are nearby, within walking distance.

The venue is disabled-friendly.

SkillsFuture Ready

Singaporeans can use $500 SkillsFuture Credits for this training to offset the course fees.

Contact us for advise on how to go about claiming your SkillsFuture.

Get Started Today!

Learn By Doing

You learn best when you Do It Yourself.

We teach you, step by step, how you can learn new skills, build your knowledge and enhance your career prospects quickly & easily, with Practical Tips & Tricks!

Do You Have Any Questions or Need a Quotation?

Simple. Just tell us what you need. We’ll be glad to help you!

Some of the companies that experienced our trainings

"What I love about this training is that the trainers make sure we learn the steps and are able to do it on our own. This is a real advantage and I will definitely come back for more practical training"
Michele Martin
HR Manager
“The training was everything I hoped for, and more. Intellisoft Systems really makes a difference, I would have never discovered the hidden features of the sotftware on my own. Thanks a lot Intellisoft !"
Joy Tan
Project Engineer

How To Register

To register for the “Power Query & Power Pivot for Deep Analysis with Excel” course, you have several convenient options:

  1. Online Registration: Visit our website and navigate to the registration page. Fill out the online registration form with your details and course preferences. You can typically find the registration link under the course description or on our homepage.
  2. Walk-in Registration: Feel free to visit our office during business hours. Our staff will be happy to assist you with the registration process in person. You can find our office address and hours of operation on our website.
  3. Email Registration: Send us an email indicating your interest in the course. Include your name, contact information, and any specific questions you may have. Our team will respond promptly and guide you through the registration steps via email.
  4. WhatsApp: If you prefer to communicate via WhatsApp, send us a message with your name and the course you wish to register for. We will reply with further instructions and assist you through the registration process.
  5. Drop by Our Office: If you’re in the City Area around Bugis, Rochor, Bencoolen, Bras Basah, Dhoby Ghat, you can drop by our office directly at Fortune Centre. Our staff will be available to answer your questions and assist you with completing the registration form on-site.

For more information about the course, feel free to email us at training@intellisoft.com.sg or reach out via WhatsApp at +65-90669991. We look forward to helping you register and start your journey with Power Query and Power Pivot for deep analysis with Excel!

Accelerate Your Career With the Most Effective & Practical Training.

Training Course Fees

The full course fees for this training is S$1,000, before any Government funding.
For Singaporean/PR above 21 years, Training Grants are available.
For Foreigners, no government grants are available.

Grant Information

WSQ funding from SkillsFuture Singapore (SSG) is available to Singaporeans/PRs above 21.
(Both Individuals & Company Sponsored ).

Individual Singaporeans, 25 years & above can also use their SkillsFuture Credits for this training at Intellisoft.

Companies sending Locals & Foreign staff for training can avail SFEC Funding
Use it to improve the skills of your entire department!

NTUC Members can utilize UTAP Funds to offset 50% of the remaining fees*.

Contact us for more information on How to apply for this SkillsFuture Grant.
Call +65-6250-3575 for Details or WhatsApp Now at +65-9066-9991

70% Grant

$700 Funding by SSG
1000
Pay $300
  • Singaporeans Above 40 Years
  • Individuals
  • SME Companies
  • Individuals Can Use SkillsFuture
  • UTAP Funding*

50% Grant

$500 Funding by SSG
1000
Pay $500
  • Below 40 Years
  • Individuals
  • SG / PR / MNC Companies
  • SkillsFuture (Singaporeans only)
  • UTAP Funding*

Microsoft Project Training (WSQ)

Microsoft Project Course in Singapore With WSQ Grants from SSG
Microsoft Project training at Intellisoft

Microsoft Project Professional  (upto 70% WSQ Funding) is available to Singapore Companies (For company sponsored candidates). Call +65 6250-3575 for Details.

SkillsFuture credits ready for Singaporeans Learn how to Begin, Plan, Execute, Monitor &  Control,  and Close a project – all using the latest Microsoft Project software in our hands – on classroom training.

UTAP: In addition, NTUC members can utilize UTAP to offset 50% of remaining fees (capped at $250 per year).

Learn to plan various tasks involved,  resources required to accomplish the tasks,  and the overall cost in order to plan a project properly. Course Length: 2 days.

Recommended Reading: Microsoft Project Training Crucial to Project Success Many project managers think Microsoft Project software (Microsoft Project 2016, MS Project 2013 ) to be just useful for creating a list of things to do… like a laundry list.

Some think that MS Project is more of a scheduling software, and it is useful only upto coming up with a Gantt Chart or a Network Diagram for their project.  Nothing could be further from the truth!

Microsoft Project 2016 is a sophisticated piece of software, which is capable of doing much more than mere scheduling. 

To read more, please visit Microsoft Project Training Crucial to Project Success

Microsoft® Office Project Professional 2016 has an extensive range of easy to use shortcuts, tips and tricks, that will enable you to use it as a tool that assists in managing your projects effectively and efficiently.

In this Microsoft Project 2016 training course, you will create and modify a project plan, and begin to manage variances in a project, bringing the project to a success!

PLUS, you will learn completely NEW FEATURES introduced in Microsoft Project 2016! You will create and manage a project schedule using Microsoft® Project 2016.

Upon successful completion of this course, students will be able to:

Identify the basic features and components of the Microsoft Project environment.

• Create a new project plan file and enter project information.

• Manage tasks by organizing tasks and setting task relationships.

• Manage resources for a project.

• Finalize a project plan.

• Exchange project plan data with other applications.

• Update a project plan.

• Manage project costs.

Report project data visually.

• Reuse project plan information.

Go To Top

This course is designed for project managers, team leads, who have a basic understanding of project management concepts, who is responsible for creating and modifying project plans, and who needs a tool to manage those project plans.

Format: Instructor led, highly interactive classroom setting with many practical exercises to do and learn from in this session.

Each student will be provided with a Laptop to use in the training room, to do the exercises. You can bring in your laptop notebook for your use in the class. It must be pre-installed with Microsoft Project 2016 software for your use.

Go To Top

Day 1 of Microsoft Project 2016

Lesson 1: Starting a Project

  • Project Management 101
  • Navigate and Customize the Project 2013 Interface
  • Add Tasks to a Project
  • Add Resources to a Project
  • Save a Project

Lesson 2: Working with Project Calendars

  • Manage Project Time Frames
  • Change Working Time

Lesson 3: Working with Project Tasks

  • Manage Project Tasks
  • Add Summary Tasks and Milestones

Lesson 4: Working with Project Resources

  • Manage Project Resources
  • Allocate and Level Work Resources

Lesson 5: Delivering a Project Plan

  • Print Project Views
  • Share Projects
  • Export Projects
Day 2 of Microsoft Project 2016

Lesson 6: Managing the Project Environment

  • Link Projects
  • Baseline a Project
  • Work with Custom Fields

Lesson 7: Managing Task Structures

  • Change a Task List
  • Create a Network Diagram
  • Manage the Critical Path
  • Use Lag and Lead

Lesson 8: Generating Project Views

  • Use View Command
  • Use Existing Views
  • Create Custom Views
  • Format and Share the Timeline View

Lesson 9: Producing Project Reports

  • Use Existing Reports
  • Create Custom Reports
  • Export Visual Reports

Go To Top

Students enrolling in this class should have the following:

  • A general introductory-level understanding of project management concepts.
  • Basic end-user skills with any current Windows operating system.

Go To Top

Post-Course Support

  • We provide free consultation related to the subject matter after the course.
  • Please email your queries to training@intellisoft.com.sg and we will forward your queries to the subject matter experts.
Microsoft Training at Intellisoft

Claim SDF Grant

Companies sponsoring their staff for training can Claim SDF Funding, subject to SSG Eligibility Criteria.

Applicable for Company Sponsored Singaporeans & PRs.

SkillsFuture Ready

Singaporeans can use $500 SkillsFuture Credits for this training to offset the course fees.

Contact us for advise on how to go about claiming your SkillsFuture.

Get Started Today!

Learn By Doing

You learn best when you Do It Yourself.

We teach you, step by step, how you can learn new skills, build your knowledge and enhance your career prospects quickly & easily, with Practical Tips & Tricks!

Training Course Fees

The full course fees for this training is S$1,200, before any Government funding.
For Singaporean/PR above 21 years, Training Grants are available.
For Foreigners, no government grants are available.

Grant Information

WSQ funding from SkillsFuture Singapore (SSG) is available to Singaporeans/PRs above 21.
(Both Individuals & Company Sponsored ).

Individual Singaporeans, 25 years & above can also use their SkillsFuture Credits for this training at Intellisoft.

Companies sending Locals & Foreign staff for training can avail SFEC Funding
Use it to improve the skills of your entire department!

NTUC Members can utilize UTAP Funds to offset 50% of the remaining fees*.

Contact us for more information on How to apply for this SkillsFuture Grant.
Call +65-6252-5033 for Details or WhatsApp Now at +65-9066-9991

up to 70% Grant

$840 Funding by SSG
Pay $360
  • Singaporeans Above 40 Years
  • Individuals
  • SME Companies
  • Individuals Can Use SkillsFuture
  • UTAP Funding*

up to 50% Grant

$600 Funding by SSG
Pay $600
  • Below 40 Years
  • Individuals
  • SG / PR / MNC Companies
  • SkillsFuture (Singaporeans only)
  • UTAP Funding*

Do You Have Any Questions or Need a Quotation?

Simple. Just tell us what you need. We’ll be glad to help you!

Some of the companies that experienced our trainings

How To Register

Register for the 2 Days Microsoft Project 2016 Training today by simply clicking on the chosen course date available at the top of this page. Need Help?

  1. Call us at +65 6250-3575, SMS / WhatsApp: +65 9066 -9991
  2. Send an email  to  training@intellisoft.com.sg  OR
  3. Submit an online enquiry if you have  any questions regarding Microsoft Project 2016 training.

We have regular public classes and Customized Corporate Training can be arranged at your office too. If you have a group of people, we can arrange to conduct the Microsoft Project 2016 training at your office location too. Just contact us for details.

Master Microsoft Project &
Be a Better
Project Manager

Free Tips, Tutorials & Training Grants Info

Learn from expert tips, tricks and resources for Excel, PowerPoint, Photoshop, Python, Power BI, Project Management, IT, Soft Skills & more with our Email Newsletter.
Plus get the latest news on Grants. Join Today!

Found What You Were
Looking For?

Just Tell us...

We're Here To Help You!