special 2 phases excel skill program
Ultimate Excel
Pivot Tables, Data Validation, VLOOKUP's, Match, Index and SUMIF's. Familiar to You?
If it does not, then most probably you are not using Microsoft Excel at its fuller capacity.
The Ultimate Microsoft Excel Training Certification is not just the title, it equips you also with the practical know-how to increase your proficiency in using Microsoft Excel in our everyday life, be it filing and reporting in the office or when it comes to tabulating your own personal daily budget and expenses.
Excel is a SKILL. It can be Learnt, Mastered and Recognised.
Excel Training has evolved. There are so many convenient command and functions to ease your workflow. Once mastered this skills, Excel can be a humble and trusted friend. Making work so much smoother and enjoyable.
So many people need Excel Training. Being a Certified Microsoft Office Specialist you can do so much more as a leader in your Team and Community.
If you Know What to Use and How to use it. Excel can be a very Powerful Tool.
Having a powerful tool is awesome, provided you know how to use them efficiently.
Able to navigate and call the right Excel function fast and smoothly is a skill, it can be learnt. Use a spreadsheet confidently, save time and now you and your team can reserve precious brainpower on things that really matter.
People do judge! How you use and present that spreadsheet does speak loudly about your Professionalism.
There is a huge difference between saying you are a “proficient excel user”…
and able to prove it with a Microsoft Office Specialist Certificate.
Have the skill is "good". Able to PROVE it is "GREAT"!
Imagine standing from HR point of view, you need someone with Excel skill. One candidate wrote: “proficient Excel user” while another candidate wrote: Certified “Microsoft Office Specialist” in Excel. Who would you rather promote or recruit?
Having the Skill and Certificate to PROOF make your life and other’s so much easier.
Join this 2 Phases Excel Program.
Grab Ultimate Excel Training Programme.
Our Unique THREE Steps Process
Here's how it works
01
Learnt
Learn the necessary concept and functions. Know what is what and how to use them. Get the concept and ways to use it.
02
Mastered
Excel is a Skill it is not a spectator sport. When you see the presenter present the Functions, you can only capture less than 50% of the skill (How we know? We use a critical point test. We let candidate test their skill after Video Learning, and again after their practice session. Time and again the result shows twice better than their first attempt).
When you put what you see into action, in the right practice environment, you can master the skills. Mastery is just about TRULY own the technique and let it become your second nature.
03
Recognised
Internationally the passing rate is approximately 60%. We are glad to say we have an above 97% passing rate. Most importantly our candidates usually get the awesome score of 83% to 97%
(Passing score: 70%).
All this is not by accident. We put in a lot of time and effort to improve and change our system. Until we come up with this right combination and learning journey which is repeatable and able to show a consistent result. Many candidates have done it, you can do it too!
Join this 2 Phases Excel Program.
Grab Ultimate Excel Training Programme.
Step 01
Learnt
Ultimate Excel Training is divided into 2 phases : Intermediate and Expert Level. Lets embark on this exciting journey to Excel Mastery.
Phase I : Here's what you will cover in Intermediate Level
After this Intermediate Level you will have the ability to create and edit a workbook with multiple sheets, and use a graphic element to represent data visually.
Practical Workbook examples are use, which will include :
- Professional-looking budgets,
- Financial statements,
- Team performance charts,
- Sales invoices, and
- Data-entry logs.
1. Manage Worksheets and Workbooks
Set the groundwork and skills needed to manage excel worksheet effectively.
1.1 Import data into workbooks
- Import data from .txt and .csv files
1.2 Navigate within workbooks
- Search for data within a workbook
- Navigate to named cells, ranges, or workbook elements
- Insert and remove hyperlinks
1.3 Format worksheets and workbooks
- Modify page setup
- Adjust row height and column width
- Customize headers and footers
1.4 Customize options and views
- Customize the Quick Access toolbar
- Display and modify workbook content in different views
- Freeze worksheet rows and columns
- Change window views
- Modify basic workbook properties
- Display formula
1.5 Configure content for collaboration
- Set a print area
- Save workbooks in alternative file formats
- Configure print settings
- Inspect workbooks for issues
2. Manage Data Cells and Ranges
Format cells and ranges is a day to day activity for excel user.
2.1 Manipulate data in worksheets
- Paste data by using special paste options
- Fill cells by using Auto Fill
- Insert and delete multiple columns or rows
- Insert and delete cells
2.2 Format cells and ranges
- Merge and unmerge cells
- Modify cell alignment, orientation, and indentation
- Format cells by using Format Painter
- Wrap text within cells
2.3 Define and reference named ranges
- Define a named range
- Name a table
2.4 Summarize data visually
- Insert Sparklines
- Apply built-in conditional formatting
- Remove conditional formatting
3. Manage Tables and Table Data
Set the groundwork and skills needed to manage excel worksheet effectively.
3.1 Create and format tables
- Create Excel tables from cell ranges
- Apply table styles
- Convert tables to cell ranges
3.2 Modify tables
- Add or remove table rows and columns
- Configure table style options
- Insert and configure total rows
3.3 Filter and sort table data
- Filter records
- Sort data by multiple columns
4. Perform Operations by using Formulas & Functions
4.1 Insert references
- Insert relative, absolute, and mixed references
- Reference named ranges and named tables in formulas
4.2 Calculate and transform data
- Perform calculations by using the AVERAGE(), MAX(), MIN(), and SUM() functions
- Count cells by using the COUNT(), COUNTA(), and COUNTBLANK() functions
- Perform conditional operations by using the IF() function
4.3 Format and modify text
- Format text by using RIGHT(), LEFT(), and MID() functions
- Format text by using UPPER(), LOWER(), and LEN() functions
- Format text by using the CONCAT() and TEXTJOIN() functions
5. Manage Charts
5.1 Create charts
- Create charts
- Create chart sheets
5.2 Modify charts
- Add data series to charts
- Switch between rows and columns in source data
- Add and modify chart elements
5.3 Format charts
- Apply chart layouts
- Apply chart styles
- Add alternative text to charts for accessibility
Phase II : Here's what you will cover in Expert Level
The exam covers the ability to customize Excel environments to meet project needs and to enhance productivity.
Practical Workbook examples are use, which will include :
- Creating, Managing, and Distributing professional spreadsheets for a variety of specialized purposes and situations.
- Custom business templates,
Multiple-axis financial charts, - Amortization tables, and
Inventory schedules.
1.
Manage Workbook Options and Settings
We begin the expert level with macro and set the workbook for more advanced and complex features in excel.
1.1 Manage workbooks
- Copy macros between workbooks
- Reference data in other workbooks
- Enable macros in a workbook
- Manage workbook versions
1.2 Prepare workbooks for collaboration
- Restrict editing
- Protect worksheets and cell ranges
- Protect workbook structure
- Configure formula calculation options
- Manage comments
1.3 Use and configure language options
- Configure editing and display languages
- Use language-specific features
2. Manage and Format Data
Flash fill is one of the most intelligent features of excel. Filling in a long list of data automatically? Everyone will appreciate this convenience. Data validation and conditional formating is the highlight of excel. Allows you to do so many magic and limit the chance of error substantially.
2.1 Fill cells based on existing data
- Fill cells by using Flash Fill
- Fill cells by using advanced Fill Series options
2.2 Format and validate data
- Create custom number formats
- Configure data validation
- Group and ungroup data
- Calculate data by inserting subtotals and totals
- Remove duplicate records
2.3 Apply advanced conditional formatting and filtering
- Create custom conditional formatting rules
- Create conditional formatting rules that use formulas
- Manage conditional formatting rules
3. Create Advanced Formulas and Macros
Here's where we see complex formula come to live. It is an exciting and very highly valued excel skill. With the use of macro, you suddenly have a group of minions ready to serve you and make the mundane and repeatable task so easy and less labour intensive.
3.1 Perform logical operations in formulas
- Perform logical operations by using nested functions including the IF(),IFS(), SWITCH(), SUMIF(),AVERAGEIF(), COUNTIF(), SUMIFS(),AVERAGEIFS(), COUNTIFS(),MAXIFS(), MINIFS(), AND(), OR(),and NOT() functions
3.2 Look up data by using functions
- Look up data by using theVLOOKUP(), HLOOKUP(), MATCH(),and INDEX() functions
3.3 Use advanced date and time functions
- Reference date and time by usingthe NOW() and TODAY() functions
- Calculate dates by using theWEEKDAY() and WORKDAY()functions
3.4 Perform data analysis
- Summarize data from multiple ranges by using the Consolidate feature
- Perform what-if analysis by using Goal Seek and Scenario Manager
- Forecast data by using the AND(),IF(), and NPER() functions
- Calculate financial data by using the PMT() function
3.5 Troubleshoot formulas
- Trace precedence and dependence
- Monitor cells and formulas by usingthe Watch Window
- Validate formulas by using error checking rules
- Evaluate formulas
3.6 Create and modify simple macros
- Record simple macros
- Name simple macros
- Edit simple macros
4. Manage Advanced Charts and Tables
The most exciting and challenging component of this excel training. Pivot chart and Pivot tabled has always been the poster boys and girls. So many people hear of this. Now you get to go into the details and learn how to use them effectively.
4.1 Create and modify advanced charts
- Create and modify dual axis charts
- Reference named ranges and named tables in formulas
- Create and modify charts including Box & Whisker, Combo, Funnel,Histogram, Map, Sunburst, and Waterfall charts
4.2 Create and modify PivotTables
- Create PivotTables
- Modify field selections and options
- Create slicers
- Group PivotTable data
- Add calculated fields
- Format data
4.3 Create and modify PivotCharts
- Create Pivot Charts
- Manipulate options in existing Pivot Charts
- Apply styles to Pivot Charts
- Drill down into Pivot Chart details
Join this 2 Phases Excel Program.
Grab Ultimate Excel Training Programme.
Can you speed up the time from junior to a master?
Some think experience need time. An experienced instructor will say: the experience can be planned. Structured practice and timely feedback is the secret to expedite mastery.
Step 02
Mastery
We rejoice when our last 13 candidates all scored between 83% to 97%. It does not matter whether they score really badly during their initial test, after adding this extra component, the result suddenly becomes repeatable. Their score range for the best student and the worst is not more than 15%.
It is not always like this. When we first started this journey on Excel Skill Training, we faced a very challenging problem. Despite going through the same learning modules, some candidates did very well, some only get half of the score (they failed miserably
).
We have a huge problem (we cannot help some of these candidates master excel). What is preventing these students from mastering excel, is it language? Is it the quality of online training? Why did they fail?
After months of observation and trial and error, here’s the Solution: Practice! Not any practice. It must be project based practices with immediate feedback.
Imagine having a coach standing over your shoulder, watching you do the practice and provide feedback immediately when you make that first wrong move.
It is effective but highly intimidating. Not if it is software that let you practice in a real excel environment and the software is the one that prompts you when the answer is not correct.
Better still this software is very similar to the real certification environment. You don’t just gain the Excel skill, you will gain the internationally recognised certification with TWO “simple” Excel exam. You are in good hands, there are so many before you which passed with flying colours, what they gain is not just the certification but also the confident that Excel will be a trusted friend and useful tool whenever they need it.
Join this 2 Phases Excel Program.
Grab Ultimate Excel Training Programme.
Step 03
Recognised
Certification + Proficiency Recognised Globally.
Yes, the Ultimate Microsoft Excel Training Programme is recognised wherever you go. We are both a training center as well as Authorised Testing Center licensed by Microsoft.
It is exciting to see so many unexpected opportunities and doors open up when you have this practical and highly valuable certification. Here’s some interesting experiences:
We had candidates who are using them to prove to immigration officer they have this Excel Skills when they are migrating to another country.
We also had professional candidates from MNC to prove to their headquarter that they are employed because they also possess this Excel Skills.
We also had successful candidate being successfully employed via Zoom interview because they are able to prove to HR with just a flash of their certification. It is easier to “flash” than to “say “with million words you have the excel skill.
Why So many people love this Ultimate Excel programme.
We think it is because of these 3 reasons
- We don't just teach, we make sure you learnt the skills by assessing your progress on a timely manner.
- We don't just ask you to practice, we assess you while you practice. So immediately you will know whether you are doing it right or wrong. There is no waste of time being stuck.
- We don't just ask you to learn the skill, we bring you the internationally recognised Microsoft Office Specialist exam. So that you don't need to "tell" people you have the skill, you just need to "flash" them your cert.
- (we said 3 reasons but we can't help it, we just heard the forth) We don't just throw the online program at you and let you swim in it alone, we monitor and assign a guide to each candidate. You are not doing this alone. There is this real human there accountable to make sure you are ready and able to master the skills before the exam.
PS: If you found more reasons to love this program do let us know. We need motivation to keep us going. We think Microsoft Office Specialist (MOS) is a very practical and functional skill. We take this training and exam very seriously. We want to make it a common skill which is not just popular overseas but also a common skill in Malaysia and available to all.
Why they signed up for
this Ultimate Excel Training Programme?
Real reasons from candidates who recently signed up for this programme.
Previous
Next
Join this 2 Phases Excel Program.
Grab Ultimate Excel Training Programme.
Do you think you have what it takes to become Microsoft Excel Expert?
With our online courses and Microsoft Certification you can easily do so. Get yourself equipped with both the practical know-how, as well as the Certification awarded directly by Microsoft.
Skill + Certification speaks it all.
Get the Ultimate Excel Training Today!
At the affordable price of RM 900 for TWO Internationally Recognised Certification
Wait No More? Get the rare opportunity to Learn and be Recognised by Microsoft from the comfort of your home.
Covid-19 has disrupted our lives in many ways, it also provide this rare opportunity to do the learning and certification online any where you are (we have candidate who did first exam here in hostel in Malaysia, the second exam online from her home town in Taiwan).
This is highly convenient regardless of your location is, take this opportunity and get certified today.