fbpx

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
Mar 21 - Mar 25Accelerated Six Sigma Green BeltManila, Philippines
Mar 25 - Mar 26DevSecOps Engineering (DSOE)Singapore, Singapore
Mar 27 - Mar 29Certified Data Center Facilities Operations Manager (CDFOM)® TrainingManila, Philippines
Mar 27 - Mar 28Recruitment AnalystManila, Philippines
Mar 27 - Mar 29SDA - Service Desk AnalystManila, Philippines
Mar 27 - Feb 27Value Stream Mapping (VSM) for DevOpsSingapore, Singapore
Apr 4 - Apr 5HR Business PartneringManila, Philippines
Apr 11 - Apr 12HRMET - HR Metrics and Workforce AnalyticsManila, Philippines
Apr 11 - Apr 12Big Data FoundationManila, Philippines
Apr 12 - Apr 12RCSA - Risk Control Self AssessmentManila, Philippines
Apr 15 - Apr 16MS Power BIManila, Philippines
Apr 22 - Apr 23COBIT 5 FoundationManila, Philippines
Apr 22 - Apr 24Certified Business Analysis Professional (CBAP®) TrainingManila, Philippines
Apr 22 - Apr 23Integrated Metrics Management (People, Process & Organization)Manila, Philippines
Apr 22 - Apr 23Big Data FoundationManila, Philippines
Apr 22 - Apr 26CEH - Certified Ethical HackerManila, Philippines
Apr 24 - Apr 26RE - Requirements EngineeringManila, Philippines
Apr 25 - Apr 26Agile SCRUM PractitionerManila, Philippines
Apr 29 - Apr 30CQP - Certified Quality ProfessionalManila, Philippines
Apr 29 - Apr 30BIA - Business Intelligence and Analytics FoundationManila, Philippines
Apr 29 - Apr 30DevOps FoundationManila, Philippines
Apr 29 - Apr 30PRINCE2 FoundationKuala Lumpur, Malaysia
May 9 - May 11SDA - Service Desk AnalystManila, Philippines
May 15 - May 16BCMP - Business Continuity Management PractitionerCebu City, Philippines
May 16 - May 17MS Excel Advanced Features (2010/2013)Manila, Philippines
May 16 - May 17SMC - Scrum Master CertifiedManila, Philippines
May 16 - May 17DPA - Data Privacy Act RA 10173Manila, Philippines
May 16 - May 17Data Story TellingManila, Philippines
May 20 - May 21Certified Data Center Professional (CDCP)® TrainingManila, Philippines
May 20 - May 24Certified Data Center Expert (CDCE)® TrainingManila, Philippines
May 20 - May 25Combined Lead Auditor (CLA) Training - ISMS, BCMManila, Philippines
May 22 - May 24Certified Data Center Specialist (CDCS)® TrainingManila, Philippines
May 22 - May 23BIA - Business Intelligence and Analytics AdvancedManila, Philippines
May 23 - May 24Six Sigma Yellow BeltManila, Philippines
May 23 - May 24DevOps FoundationManila, Philippines
May 30 - May 31CCP - Crisis Communication Planner (ICOR Certified) TrainingManila, Philippines
May 30 - May 31Data Security Practitioner - Payment Card IndustryManila, Philippines
May 30 - May 31Enterprise Risk ManagementManila, Philippines
Jun 4 - Jun 7Project Management Professional (PMP)® Training - REP #4536Manila, Philippines
Jun 13 - Jun 14Agile SCRUM PractitionerManila, Philippines
Jun 17 - Jun 18Complaints Management - Turning Complaints to ComplimentsManila, Philippines
Jun 18 - Jun 21BCM Lead Auditor – ISO 22301 (ICOR Certified)Manila, Philippines
Jun 18 - Jun 19HR Business PartneringManila, Philippines
Jun 18 - Jun 21Big Data FoundationManila, Philippines
Jun 18 - Jun 21Big Data Hadoop AdministratorManila, Philippines
Jun 20 - Jun 21DRP - Disaster Recovery PractitionerManila, Philippines
Jun 20 - Jun 21DevOps FoundationManila, Philippines
Jun 24 - Jun 26CQL - Certified Quality LeaderManila, Philippines
Jun 24 - Jun 25I2BA - Intro to Business AnalysisManila, Philippines
Jun 25 - Jun 26MS Power BIManila, Philippines
Jun 26 - Jun 28Certified IT Specialist (CITS)® TrainingManila, Philippines
Jun 27 - Jun 28ISMS (Information Security Management Systems) PractitionerManila, Philippines
Jun 27 - Jun 28CompTIA Cloud EssentialsManila, Philippines
Jun 27 - Jun 28PSM I - Professional Scrum MasterManila, Philippines
Jul 8 - Jul 9MS Excel Advanced Features (2010/2013)Manila, Philippines
Jul 17 - Jul 19Certified Business Analysis Professional (CBAP®) TrainingManila, Philippines
Jul 23 - Jul 24HRMET - HR Metrics and Workforce AnalyticsManila, Philippines
No class / event scheduled for this month
No class / event scheduled for this month
No class / event scheduled for this month
No class / event scheduled for this month
No class / event scheduled for this month
x

Calendar

No class / event scheduled for this month
No class / event scheduled for this month
Mar 21 - Mar 25Accelerated Six Sigma Green BeltManila, Philippines
Mar 25 - Mar 26DevSecOps Engineering (DSOE)Singapore, Singapore
Mar 27 - Mar 29Certified Data Center Facilities Operations Manager (CDFOM)® TrainingManila, Philippines
Mar 27 - Mar 28Recruitment AnalystManila, Philippines
Mar 27 - Mar 29SDA - Service Desk AnalystManila, Philippines
Mar 27 - Feb 27Value Stream Mapping (VSM) for DevOpsSingapore, Singapore
Apr 4 - Apr 5HR Business PartneringManila, Philippines
Apr 11 - Apr 12HRMET - HR Metrics and Workforce AnalyticsManila, Philippines
Apr 11 - Apr 12Big Data FoundationManila, Philippines
Apr 12 - Apr 12RCSA - Risk Control Self AssessmentManila, Philippines
Apr 15 - Apr 16MS Power BIManila, Philippines
Apr 22 - Apr 23COBIT 5 FoundationManila, Philippines
Apr 22 - Apr 24Certified Business Analysis Professional (CBAP®) TrainingManila, Philippines
Apr 22 - Apr 23Integrated Metrics Management (People, Process & Organization)Manila, Philippines
Apr 22 - Apr 23Big Data FoundationManila, Philippines
Apr 22 - Apr 26CEH - Certified Ethical HackerManila, Philippines
Apr 24 - Apr 26RE - Requirements EngineeringManila, Philippines
Apr 25 - Apr 26Agile SCRUM PractitionerManila, Philippines
Apr 29 - Apr 30CQP - Certified Quality ProfessionalManila, Philippines
Apr 29 - Apr 30BIA - Business Intelligence and Analytics FoundationManila, Philippines
Apr 29 - Apr 30DevOps FoundationManila, Philippines
Apr 29 - Apr 30PRINCE2 FoundationKuala Lumpur, Malaysia
May 9 - May 11SDA - Service Desk AnalystManila, Philippines
May 15 - May 16BCMP - Business Continuity Management PractitionerCebu City, Philippines
May 16 - May 17MS Excel Advanced Features (2010/2013)Manila, Philippines
May 16 - May 17SMC - Scrum Master CertifiedManila, Philippines
May 16 - May 17DPA - Data Privacy Act RA 10173Manila, Philippines
May 16 - May 17Data Story TellingManila, Philippines
May 20 - May 21Certified Data Center Professional (CDCP)® TrainingManila, Philippines
May 20 - May 24Certified Data Center Expert (CDCE)® TrainingManila, Philippines
May 20 - May 25Combined Lead Auditor (CLA) Training - ISMS, BCMManila, Philippines
May 22 - May 24Certified Data Center Specialist (CDCS)® TrainingManila, Philippines
May 22 - May 23BIA - Business Intelligence and Analytics AdvancedManila, Philippines
May 23 - May 24Six Sigma Yellow BeltManila, Philippines
May 23 - May 24DevOps FoundationManila, Philippines
May 30 - May 31CCP - Crisis Communication Planner (ICOR Certified) TrainingManila, Philippines
May 30 - May 31Data Security Practitioner - Payment Card IndustryManila, Philippines
May 30 - May 31Enterprise Risk ManagementManila, Philippines
Jun 4 - Jun 7Project Management Professional (PMP)® Training - REP #4536Manila, Philippines
Jun 13 - Jun 14Agile SCRUM PractitionerManila, Philippines
Jun 17 - Jun 18Complaints Management - Turning Complaints to ComplimentsManila, Philippines
Jun 18 - Jun 21BCM Lead Auditor – ISO 22301 (ICOR Certified)Manila, Philippines
Jun 18 - Jun 19HR Business PartneringManila, Philippines
Jun 18 - Jun 21Big Data FoundationManila, Philippines
Jun 18 - Jun 21Big Data Hadoop AdministratorManila, Philippines
Jun 20 - Jun 21DRP - Disaster Recovery PractitionerManila, Philippines
Jun 20 - Jun 21DevOps FoundationManila, Philippines
Jun 24 - Jun 26CQL - Certified Quality LeaderManila, Philippines
Jun 24 - Jun 25I2BA - Intro to Business AnalysisManila, Philippines
Jun 25 - Jun 26MS Power BIManila, Philippines
Jun 26 - Jun 28Certified IT Specialist (CITS)® TrainingManila, Philippines
Jun 27 - Jun 28ISMS (Information Security Management Systems) PractitionerManila, Philippines
Jun 27 - Jun 28CompTIA Cloud EssentialsManila, Philippines
Jun 27 - Jun 28PSM I - Professional Scrum MasterManila, Philippines
Jul 8 - Jul 9MS Excel Advanced Features (2010/2013)Manila, Philippines
Jul 17 - Jul 19Certified Business Analysis Professional (CBAP®) TrainingManila, Philippines
Jul 23 - Jul 24HRMET - HR Metrics and Workforce AnalyticsManila, Philippines
No class / event scheduled for this month
No class / event scheduled for this month
No class / event scheduled for this month
No class / event scheduled for this month
No class / event scheduled for this month
ENROLL NOW








REQUEST A CUSTOM QUOTE






Request a callback
[contact-form-7 404 "Not Found"]