In 1985, Microsoft (MSFT) introduced Excel to businessmen, conglomerates, organizations, and SMEs, and it quickly became one of the most vital software for businesses around the globe. Whether you’re tracking stock inventories, profit & losses (P&L), revenues, or budgeting, Excel was the tool for it.

Excel turned manual processes, which typically took weeks to complete back in the 80s into an hour’s worth of work or less. The program can easily add, subtract, multiply, and divide with ease. However, Excel isn’t just good for solving basic math problems.

Many users don’t realize Excel was designed to do the heavy lifting even in the most complex financial problems. Here are 8 Excel features you probably didn’t know about and should highly take advantage of.

 

Flash Fill

The 2013 version of Excel (or the more recent) allows you to automatically fill in columns or rows based on patterns detected by the program. This is quite a handy feature when you’re trying to organize mailing lists or database records. Here’s how to do it:

Type on the first two cells how it should look. Then, highlight the entries and select the empty cells. Press CTRL+E to flash fill remaining cells.

 

Goal Seek

No matter what industry you’re in, whether you’re in sales, marketing, retail, or manufacturing, setting business goals is important. Fortunately, Excel can help you compute targets for forecasting or analytics reports. No need to manually calculate for it.

Just click Data Tools under the Data tab, go to What-if Analysis, and then Goal Seek.

 

Conditional Formatting

When you’re submitting reports to your boss, the analysis should be evident at first glance. With the conditional formatting function, you can easily highlight and emphasize key values on your report.

Just select “Conditional Formatting” under the home navigation bar and select which format applies. You can also highlight greater than or less than values, numbers in between, specific texts, and the like.

 

Small and Large Function

You may have been familiar with using MIN (minimum) and MAX (maximum), but did you know that Excel can also segregate based on the smallest and largest value? If you’re working in sales, this function can help you pinpoint without a sweat fast moving products from slow moving items. With the help of index and match, you can easy determine the greatest and least value in your data.

 

Removing Duplicates

Manually removing duplicate entries isn’t only tiring, it’s also an inefficient use of time. Good thing is that Excel understands this problem and introduced a function that solves everyone’s concern.

By selecting the data and clicking on the “remove duplicates” button, Excel cleans up your file in seconds.

 

Days Function

Wondering how long stocks last? How about the number of days between a given timeframe? Using the Days function on Excel, you can easily determine the answer to questions like this.

Just type in DAYS (start_date, end_date) on the cell and voila! There’s your answer.

 

Waterfall Charts

One of the most used tables for data visualization is a waterfall chart. Waterfall charts easily demonstrate gains and losses, without necessarily requiring long analysis to understand.

Creating your waterfall chart is easy. Under the Data tab, just hit on Insert and click on Insert Waterfall or Stock Chart.

 

Forecasting

Similar to the Goal Seek function, the forecasting function helps you calculate upper and lower bands to include margins for error and seasonality.

Just select the two corresponding data and click on Forecast sheets under the Data tab.

 

There are many functions on Excel that can help you create better systems and processes for your business. While it’s tempting to think anything and everything your team needs to learn is online, investing in advanced Excel training can help them learn about the critical functions they need.

Being equipped and learning about these functions can help your team produce and deliver reports that help build business efficiency.

E-Learning Landing Pop Up TEST

E-Learning Landing Pop Up TEST

×
calendar_popup

Calendar

No class / event scheduled for this month
No class / event scheduled for this month
No class / event scheduled for this month
Apr 19 - Apr 20DevOps FoundationManila, Philippines
Apr 23 - Apr 24ITIL Foundation (2011)Manila, Philippines
Apr 23 - Apr 2Certified Business Analysis Professional (CBAP®) TrainingManila, Philippines
Apr 24 - Apr 25MS Power BIManila, Philippines
Apr 26 - Apr 27ITIL Foundation (2011)Manila, Philippines
Apr 26 - Apr 2Agile SCRUM PractitionerManila, Philippines
May 3 - May 4HR Metrics and Workforce AnalyticsManila, Philippines
May 10 - May 11Certified Data Center Professional (CDCP)® TrainingManila, Philippines
May 10 - May 11Intro to Project ManagementCebu City, Philippines
May 16 - May 18Certified IT Specialist (CITS)® TrainingManila, Philippines
May 17 - May 18MS Excel Advanced Features (2010/2013)Manila, Philippines
May 21 - May 22ITIL Foundation (2011)Manila, Philippines
May 21 - May 23Certified Data Center Facilities Operations Manager (CDFOM)® TrainingManila, Philippines
May 21 - May 22Software Quality Management Professional (ASQ Aligned)Manila, Philippines
May 21 - May 22HR Business PartneringManila, Philippines
May 21 - May 23BCM Lead Implementer - ISO 22301 (ICOR Certified)Manila, Philippines
May 22 - May 25Project Management Professional (PMP)® Training - REP #4536Manila, Philippines
May 24 - May 25Enterprise Risk ManagementManila, Philippines
May 24 - May 25DevOps FoundationManila, Philippines
May 27 - Jun 1Certified Data Center Expert (CDCE)® TrainingManila, Philippines
May 30 - May 31CQP - Certified Quality ProfessionalManila, Philippines
May 30 - May 31DevOps FoundationManila, Philippines
May 30 - May 31Big Data FoundationManila, Philippines
May 31 - Jun 4Accelerated Six Sigma Green BeltManila, Philippines
Jun 2 - Jun 10Accelerated Six Sigma Green BeltManila, Philippines
Jun 4 - Jun 5HR Business PartneringManila, Philippines
Jun 5 - Jun 7Certified Business Analysis Professional (CBAP®) TrainingManila, Philippines
Jun 7 - Jun 8Agile SCRUM PractitionerManila, Philippines
Jun 7 - Jun 11Accelerated Six Sigma Green BeltManila, Philippines
Jun 7 - Jun 8MS Excel Advanced Features (2010/2013)Manila, Philippines
Jun 7 - Jun 8DRP - Disaster Recovery PractitionerManila, Philippines
Jun 7 - Jun 8Integrated Metrics Management (People, Process & Organization)Manila, Philippines
Jun 7 - Jun 8BIA - Business Intelligence and Analytics FoundationManila, Philippines
Jun 14 - Jun 15DevOps FoundationManila, Philippines
Jun 18 - Jun 19PRINCE2 FoundationKuala Lumpur, Malaysia
Jun 19 - Jun 22Project Management Professional (PMP)® Training - REP #4536Manila, Philippines
Jun 20 - Jun 22CPRE - Certified Professional for Requirements EngineeringManila, Philippines
Jun 20 - Jun 21Software Quality Expert (ASQ Aligned)Manila, Philippines
Jun 21 - Jun 25Accelerated Six Sigma Green BeltManila, Philippines
Jun 21 - Jun 22CompTIA Cloud EssentialsManila, Philippines
Jun 21 - Jun 22Scrum Master CertifiedManila, Philippines
Jun 25 - Jun 26ITIL Foundation (2011)Manila, Philippines
Jun 25 - Jun 28Project Management Professional (PMP)® Training - REP #4536Manila, Philippines
Jun 25 - Jun 27CQL - Certified Quality LeaderManila, Philippines
Jun 25 - Jun 26Complaints Management - Turning Complaints to ComplimentsManila, Philippines
Jun 25 - Jun 27SDA - Service Desk AnalystManila, Philippines
Jun 27 - Jun 29Certified Business Analysis Professional (CBAP®) TrainingManila, Philippines
Jun 27 - Jun 28HR Metrics and Workforce AnalyticsManila, Philippines
Jun 28 - Jun 29CCP - Crisis Communication Planner (ICOR Certified) TrainingManila, Philippines
Jun 28 - Jun 29MS Projects 74-343Manila, Philippines
Jul 11 - Jul 12PRINCE2 FoundationKuala Lumpur, Malaysia
Jul 12 - Jul 13Business Continuity Management PractitionerCebu City, Philippines
Jul 12 - Jul 13BIA - Business Intelligence and Analytics AdvancedManila, Philippines
Jul 16 - Jul 17BIA - Business Intelligence and Analytics FoundationManila, Philippines
Jul 19 - Jul 20ITIL Foundation (2011)Manila, Philippines
Jul 19 - Jul 20ISMS (Information Security Management Systems) PractitionerManila, Philippines
Jul 24 - Jul 27Project Management Professional (PMP)® Training - REP #4536Manila, Philippines
Jul 24 - Jul 25Intro to Project ManagementCebu City, Philippines
Jul 30 - Jul 31DevOps FoundationManila, Philippines
Jul 30 - Jul 31Big Data FoundationManila, Philippines
Aug 2 - Aug 3ITIL Foundation (2011)Manila, Philippines
Aug 8 - Aug 10Certified Business Analysis Professional (CBAP®) TrainingManila, Philippines
Aug 9 - Aug 10Business Continuity Management PractitionerCebu City, Philippines
Aug 16 - Aug 17Certified Data Center Professional (CDCP)® TrainingManila, Philippines
Aug 16 - Aug 17MS Excel Advanced Features (2010/2013)Manila, Philippines
Aug 20 - Aug 21Agile SCRUM PractitionerManila, Philippines
Aug 23 - Aug 24ITIL Foundation (2011)Manila, Philippines
Aug 28 - Aug 31Project Management Professional (PMP)® Training - REP #4536Manila, Philippines
Aug 29 - Aug 31Certified Business Analysis Professional (CBAP®) TrainingManila, Philippines
Aug 29 - Aug 3Big Data FoundationManila, Philippines
Aug 30 - Aug 31DevOps FoundationManila, Philippines
Sep 1 - Sep 14MS Excel Advanced Features (2010/2013)Manila, Philippines
Sep 5 - Sep 7Certified Business Analysis Professional (CBAP®) TrainingManila, Philippines
Sep 6 - Sep 7BIA - Business Intelligence and Analytics FoundationManila, Philippines
Sep 10 - Sep 15Combined Lead Auditor (CLA) Training - ISMS, BCMManila, Philippines
Sep 17 - Sep 18MS Excel Advanced Features (2010/2013)Manila, Philippines
Sep 17 - Sep 18DevOps FoundationManila, Philippines
Sep 20 - Sep 21ITIL Foundation (2011)Manila, Philippines
Sep 20 - Sep 21Enterprise Risk ManagementManila, Philippines
Sep 24 - Sep 25ITIL Foundation (2011)Manila, Philippines
Sep 24 - Sep 27Project Management Professional (PMP)® Training - REP #4536Manila, Philippines
Sep 24 - Sep 25DevOps FoundationManila, Philippines
Sep 27 - Sep 28CompTIA Cloud EssentialsManila, Philippines
Oct 11 - Oct 12Big Data FoundationManila, Philippines
Oct 15 - Oct 17Certified Business Analysis Professional (CBAP®) TrainingManila, Philippines
Oct 15 - Oct 16PRINCE2 FoundationKuala Lumpur, Malaysia
Oct 18 - Oct 19BIA - Business Intelligence and Analytics FoundationManila, Philippines
Oct 18 - Oct 19DevOps FoundationManila, Philippines
Oct 18 - Oct 19Intro to Project ManagementCebu City, Philippines
Oct 23 - Oct 26Project Management Professional (PMP)® Training - REP #4536Manila, Philippines
Oct 25 - Oct 2MS Projects 74-343Manila, Philippines
Oct 29 - Oct 30ITIL Foundation (2011)Manila, Philippines
Nov 8 - Nov 9MS Excel Advanced Features (2010/2013)Manila, Philippines
Nov 12 - Nov 14Certified Business Analysis Professional (CBAP®) TrainingManila, Philippines
Nov 12 - Nov 13DevOps FoundationManila, Philippines
Nov 13 - Nov 15BCM Lead Implementer - ISO 22301 (ICOR Certified)Manila, Philippines
Nov 15 - Nov 16MS Excel Advanced Features (2010/2013)Manila, Philippines
Nov 20 - Nov 23Project Management Professional (PMP)® Training - REP #4536Manila, Philippines
Nov 21 - Nov 23Certified Business Analysis Professional (CBAP®) TrainingManila, Philippines
Nov 21 - Nov 23CPRE - Certified Professional for Requirements EngineeringManila, Philippines
Nov 22 - Nov 23ITIL Foundation (2011)Manila, Philippines
Nov 22 - Nov 23ITIL Foundation (2011)Manila, Philippines
Nov 26 - Nov 28OMCA™ - Online Marketing Certified AssociateManila, Philippines
Nov 27 - Nov 28Certified Data Center Professional (CDCP)® TrainingManila, Philippines
Nov 27 - Nov 28Enterprise Risk ManagementManila, Philippines
Nov 28 - Nov 29Big Data FoundationManila, Philippines
Dec 3 - Dec 4BIA - Business Intelligence and Analytics FoundationManila, Philippines
Dec 6 - Dec 7ITIL Foundation (2011)Manila, Philippines
Dec 6 - Dec 7CompTIA Cloud EssentialsManila, Philippines
Dec 10 - Dec 11Business Continuity Management PractitionerCebu City, Philippines
Dec 10 - Dec 11Intro to Project ManagementCebu City, Philippines
Dec 11 - Dec 12MS Excel Advanced Features (2010/2013)Manila, Philippines
Dec 13 - Dec 14DevOps FoundationManila, Philippines
x

Calendar

No class / event scheduled for this month
No class / event scheduled for this month
No class / event scheduled for this month
Apr 19 - Apr 20DevOps FoundationManila, Philippines
Apr 23 - Apr 24ITIL Foundation (2011)Manila, Philippines
Apr 23 - Apr 2Certified Business Analysis Professional (CBAP®) TrainingManila, Philippines
Apr 24 - Apr 25MS Power BIManila, Philippines
Apr 26 - Apr 27ITIL Foundation (2011)Manila, Philippines
Apr 26 - Apr 2Agile SCRUM PractitionerManila, Philippines
May 3 - May 4HR Metrics and Workforce AnalyticsManila, Philippines
May 10 - May 11Certified Data Center Professional (CDCP)® TrainingManila, Philippines
May 10 - May 11Intro to Project ManagementCebu City, Philippines
May 16 - May 18Certified IT Specialist (CITS)® TrainingManila, Philippines
May 17 - May 18MS Excel Advanced Features (2010/2013)Manila, Philippines
May 21 - May 22ITIL Foundation (2011)Manila, Philippines
May 21 - May 23Certified Data Center Facilities Operations Manager (CDFOM)® TrainingManila, Philippines
May 21 - May 22Software Quality Management Professional (ASQ Aligned)Manila, Philippines
May 21 - May 22HR Business PartneringManila, Philippines
May 21 - May 23BCM Lead Implementer - ISO 22301 (ICOR Certified)Manila, Philippines
May 22 - May 25Project Management Professional (PMP)® Training - REP #4536Manila, Philippines
May 24 - May 25Enterprise Risk ManagementManila, Philippines
May 24 - May 25DevOps FoundationManila, Philippines
May 27 - Jun 1Certified Data Center Expert (CDCE)® TrainingManila, Philippines
May 30 - May 31CQP - Certified Quality ProfessionalManila, Philippines
May 30 - May 31DevOps FoundationManila, Philippines
May 30 - May 31Big Data FoundationManila, Philippines
May 31 - Jun 4Accelerated Six Sigma Green BeltManila, Philippines
Jun 2 - Jun 10Accelerated Six Sigma Green BeltManila, Philippines
Jun 4 - Jun 5HR Business PartneringManila, Philippines
Jun 5 - Jun 7Certified Business Analysis Professional (CBAP®) TrainingManila, Philippines
Jun 7 - Jun 8Agile SCRUM PractitionerManila, Philippines
Jun 7 - Jun 11Accelerated Six Sigma Green BeltManila, Philippines
Jun 7 - Jun 8MS Excel Advanced Features (2010/2013)Manila, Philippines
Jun 7 - Jun 8DRP - Disaster Recovery PractitionerManila, Philippines
Jun 7 - Jun 8Integrated Metrics Management (People, Process & Organization)Manila, Philippines
Jun 7 - Jun 8BIA - Business Intelligence and Analytics FoundationManila, Philippines
Jun 14 - Jun 15DevOps FoundationManila, Philippines
Jun 18 - Jun 19PRINCE2 FoundationKuala Lumpur, Malaysia
Jun 19 - Jun 22Project Management Professional (PMP)® Training - REP #4536Manila, Philippines
Jun 20 - Jun 22CPRE - Certified Professional for Requirements EngineeringManila, Philippines
Jun 20 - Jun 21Software Quality Expert (ASQ Aligned)Manila, Philippines
Jun 21 - Jun 25Accelerated Six Sigma Green BeltManila, Philippines
Jun 21 - Jun 22CompTIA Cloud EssentialsManila, Philippines
Jun 21 - Jun 22Scrum Master CertifiedManila, Philippines
Jun 25 - Jun 26ITIL Foundation (2011)Manila, Philippines
Jun 25 - Jun 28Project Management Professional (PMP)® Training - REP #4536Manila, Philippines
Jun 25 - Jun 27CQL - Certified Quality LeaderManila, Philippines
Jun 25 - Jun 26Complaints Management - Turning Complaints to ComplimentsManila, Philippines
Jun 25 - Jun 27SDA - Service Desk AnalystManila, Philippines
Jun 27 - Jun 29Certified Business Analysis Professional (CBAP®) TrainingManila, Philippines
Jun 27 - Jun 28HR Metrics and Workforce AnalyticsManila, Philippines
Jun 28 - Jun 29CCP - Crisis Communication Planner (ICOR Certified) TrainingManila, Philippines
Jun 28 - Jun 29MS Projects 74-343Manila, Philippines
Jul 11 - Jul 12PRINCE2 FoundationKuala Lumpur, Malaysia
Jul 12 - Jul 13Business Continuity Management PractitionerCebu City, Philippines
Jul 12 - Jul 13BIA - Business Intelligence and Analytics AdvancedManila, Philippines
Jul 16 - Jul 17BIA - Business Intelligence and Analytics FoundationManila, Philippines
Jul 19 - Jul 20ITIL Foundation (2011)Manila, Philippines
Jul 19 - Jul 20ISMS (Information Security Management Systems) PractitionerManila, Philippines
Jul 24 - Jul 27Project Management Professional (PMP)® Training - REP #4536Manila, Philippines
Jul 24 - Jul 25Intro to Project ManagementCebu City, Philippines
Jul 30 - Jul 31DevOps FoundationManila, Philippines
Jul 30 - Jul 31Big Data FoundationManila, Philippines
Aug 2 - Aug 3ITIL Foundation (2011)Manila, Philippines
Aug 8 - Aug 10Certified Business Analysis Professional (CBAP®) TrainingManila, Philippines
Aug 9 - Aug 10Business Continuity Management PractitionerCebu City, Philippines
Aug 16 - Aug 17Certified Data Center Professional (CDCP)® TrainingManila, Philippines
Aug 16 - Aug 17MS Excel Advanced Features (2010/2013)Manila, Philippines
Aug 20 - Aug 21Agile SCRUM PractitionerManila, Philippines
Aug 23 - Aug 24ITIL Foundation (2011)Manila, Philippines
Aug 28 - Aug 31Project Management Professional (PMP)® Training - REP #4536Manila, Philippines
Aug 29 - Aug 31Certified Business Analysis Professional (CBAP®) TrainingManila, Philippines
Aug 29 - Aug 3Big Data FoundationManila, Philippines
Aug 30 - Aug 31DevOps FoundationManila, Philippines
Sep 1 - Sep 14MS Excel Advanced Features (2010/2013)Manila, Philippines
Sep 5 - Sep 7Certified Business Analysis Professional (CBAP®) TrainingManila, Philippines
Sep 6 - Sep 7BIA - Business Intelligence and Analytics FoundationManila, Philippines
Sep 10 - Sep 15Combined Lead Auditor (CLA) Training - ISMS, BCMManila, Philippines
Sep 17 - Sep 18MS Excel Advanced Features (2010/2013)Manila, Philippines
Sep 17 - Sep 18DevOps FoundationManila, Philippines
Sep 20 - Sep 21ITIL Foundation (2011)Manila, Philippines
Sep 20 - Sep 21Enterprise Risk ManagementManila, Philippines
Sep 24 - Sep 25ITIL Foundation (2011)Manila, Philippines
Sep 24 - Sep 27Project Management Professional (PMP)® Training - REP #4536Manila, Philippines
Sep 24 - Sep 25DevOps FoundationManila, Philippines
Sep 27 - Sep 28CompTIA Cloud EssentialsManila, Philippines
Oct 11 - Oct 12Big Data FoundationManila, Philippines
Oct 15 - Oct 17Certified Business Analysis Professional (CBAP®) TrainingManila, Philippines
Oct 15 - Oct 16PRINCE2 FoundationKuala Lumpur, Malaysia
Oct 18 - Oct 19BIA - Business Intelligence and Analytics FoundationManila, Philippines
Oct 18 - Oct 19DevOps FoundationManila, Philippines
Oct 18 - Oct 19Intro to Project ManagementCebu City, Philippines
Oct 23 - Oct 26Project Management Professional (PMP)® Training - REP #4536Manila, Philippines
Oct 25 - Oct 2MS Projects 74-343Manila, Philippines
Oct 29 - Oct 30ITIL Foundation (2011)Manila, Philippines
Nov 8 - Nov 9MS Excel Advanced Features (2010/2013)Manila, Philippines
Nov 12 - Nov 14Certified Business Analysis Professional (CBAP®) TrainingManila, Philippines
Nov 12 - Nov 13DevOps FoundationManila, Philippines
Nov 13 - Nov 15BCM Lead Implementer - ISO 22301 (ICOR Certified)Manila, Philippines
Nov 15 - Nov 16MS Excel Advanced Features (2010/2013)Manila, Philippines
Nov 20 - Nov 23Project Management Professional (PMP)® Training - REP #4536Manila, Philippines
Nov 21 - Nov 23Certified Business Analysis Professional (CBAP®) TrainingManila, Philippines
Nov 21 - Nov 23CPRE - Certified Professional for Requirements EngineeringManila, Philippines
Nov 22 - Nov 23ITIL Foundation (2011)Manila, Philippines
Nov 22 - Nov 23ITIL Foundation (2011)Manila, Philippines
Nov 26 - Nov 28OMCA™ - Online Marketing Certified AssociateManila, Philippines
Nov 27 - Nov 28Certified Data Center Professional (CDCP)® TrainingManila, Philippines
Nov 27 - Nov 28Enterprise Risk ManagementManila, Philippines
Nov 28 - Nov 29Big Data FoundationManila, Philippines
Dec 3 - Dec 4BIA - Business Intelligence and Analytics FoundationManila, Philippines
Dec 6 - Dec 7ITIL Foundation (2011)Manila, Philippines
Dec 6 - Dec 7CompTIA Cloud EssentialsManila, Philippines
Dec 10 - Dec 11Business Continuity Management PractitionerCebu City, Philippines
Dec 10 - Dec 11Intro to Project ManagementCebu City, Philippines
Dec 11 - Dec 12MS Excel Advanced Features (2010/2013)Manila, Philippines
Dec 13 - Dec 14DevOps FoundationManila, Philippines
ENROLL NOW








REQUEST A CUSTOM QUOTE








Request a callback
REQUEST FOR CALLBACK