Mboma Training Consultants

29/01/2019

Whether you are just beginning in your Excel learning, or you have some skills and consider yourself as the expertise in Excel, there are a some advanced excel skills that you should think about Excel. Nowadays, many jobs require the advanced Excel skills. Besides, you might wonder if you will be sufficiently performing the Excel tasks the company expects from you.

In this article, we have compiled the essential advanced excel skills you need to know about Microsoft Excel. It also includes some of the best tips that can consider of to get you began as a beginner. And it will make you more productive as an experienced user. It should enable you to get an idea of where you feel confident. You can start learning excel today with the advanced Excel course to ensure you are well versed in Microsoft Excel.

Advanced Functions

The functions are easy to create in Microsoft Excel and, by design, they automate tasks that would be significantly more employee intensive. There are various functions that, in practice, need some skills to solve complex issues. Some portion of the challenge for you knows when and how you can apply these and how to design them for your particular reason. If this is a specific area you would like to work on, you can take the course on advanced Excel. Here are a few examples:

Logical Functions

IF: Provides an output based on whether a condition is true or false for a provided cell. Where the IF function begins to come in handy is when it is nested within a larger formula. An example you will come across fairly regularly is a chain of IF functions that efficiently create an algorithm.
OR and AND: It is frequently used as components of a more substantial formula. The OR and AND functions discover the truth or falseness of any defined condition or all specified conditions, respectively.

Data Functions

VLookup:

The searches a column within a range for a user-defined input and delivers a similar value from another defined column in that field.

HLookup:

The searches rows in a range for a user-defined input and delivers a similar value for a defined row. It transfers the VLookup method but will have several applications in daily use.

Text Functions

Concatenate:

Merges many values and strings and outputs them to a text string.

Mid:

Extracts a substring from a defined string. The user determines the starting and position and number of characters to extract. This function can be handy within larger formulas for data processing.

It is not a complete list by any means. However, exploring these functions and using them to problems will give you an excellent understanding of how to utilize the functions in Excel.

Array Functions

To get expertise with Microsoft Excel, you need to use output value to a single cell for most of the functions. Despite, there is another set of advanced functions that work on a whole range. A transpose function is one of the most used functions in Excel. It also enables you to switch the axes for your data so that the rows become the columns and vice versa.

Data Sorting and Entry

Understanding functions are critical to utilizing Microsoft Office Excel at an advanced level. However, it is not the main ability you will need to develop. Another area that might be essential in working with spreadsheets every day needs to do with organizing and preparing data and cells inside your tables. It also includes several features of MS Excel. Here are some of the most common ones:

Custom filtering:

If you have learned the basics of Microsoft Excel, you will understand how to apply filters to your tables. Inside those filters, you have advanced filtering choices to slice and dice data virtually every way you require. If you are not comfortable with the basic application of filters in Excel, you might need to do Excel course.

Applying data validation:

There are numerous cases in which you need to put parameters on the input a cell will accept.

Protecting sheets and locking cells:

When you are making an Excel spreadsheet that a group will be doing, you will need to be familiar with the tools that assure version control.

Creating drop-down selections:

Usually going hand-in-hand with data validation, users can apply drop-down selection lists including the accepted inputs for a given cell.

Macros and VBA

A basic understanding of macros in Microsoft Excel will enable any user to finish tasks more effectively. While in many cases, an employer might not mainly need this skill, utilizing macros can help you complete those tight turnaround reports without making mistakes or pulling all-nighters.

Learning VBA will give you finish control over your macros so you can customize them to do complex tasks, even ones including different programs. However, if you are working on a team that depends on spreadsheets consistently, your insight into VBA could enable you to make a few upgrades and rapidly demonstrate your esteem.

Statistical Analysis

If you will be working with statistics in Microsoft Office Excel, there are specific tools designed to enable you to do the math. Also, since they will save you a lot of time vs. manual calculations, you will probably be relied upon to know the ones that apply to your work. Make sure you have that resource installed and get to know some of the functions of it.

Dashboards

Making a report with data visualization (e.g., graphs and charts) is a capacity you learn at a fundamental level in a basic excel course. Despite, the tools you need to work with for this reason are robust and deserve particular attention if you create organization reports. You should consider taking a course in making Excel dashboards that look great and convey in the data analysis.

Others

The Microsoft Excel features incorporated here should give you a feel for what an advanced user can do with the program. However, there is still more to name a few; you might want to learn pivot tables, referencing data between sheets, financial modeling functions and workbooks.

Conclusion

However, these essential advanced Excel skills for you to learn that will enhance the way you use Microsoft Excel and make you more proficient. Consider how comfortable you are with all of these features and try out some of the useful resources for getting to know the ones that will take your abilities to the next level.

28/01/2019

Book your seat in our Microsoft Office Training courses we have available!
We have the following available:

1.Microsoft Office Excel 2010 - Foundation
Date: 16 March 2019

2. Microsoft Office Excel 2010 - Intermediate
Date: 23 March 2019

3. Microsoft Office Excel 2010 - Advanced
Date: 30 March 2019

ALL courses are ONLY R1900!

To book your seat please email [email protected]

28/01/2019

The most organized and profitable companies offer employee development programs to enable their employees to rise up through the ranks. Those that don’t tend to suffer from attrition, watching their best workers depart for greener pastures. If you don’t want to be the company that loses good talent – and you don’t want to be the worker that never becomes good talent – then continuing education is one of the best approaches.

In many cases, these programs involve advanced Excel training. The ability to organize, calculate and evaluate quantitative data are important skills needed today in many fields. Moreover, they’re commonly used in business and managerial decision-making, which means they’re extra-critical for those at the top. If you hope to advance to the C-Suite, or have a promising employee you’d like to see climb the ladder, Excel courses are a must.

Let’s talk about the top 10 business benefits of advanced Microsoft Excel, first for the employee and then for the company. Although if you look closely enough, you’ll probably notice that everyone benefits from all. (Wink).
For the Employee

1. Improve Your Skills

Advanced Microsoft Excel training teaches you a huge array of skills, including the ability to:

Visualize and manipulate data
Build complex equations to help you pose and answer questions about company finances, efficiency, workflow, inventory and much more
Clean up and prepare data for analysis
Design professional-level spreadsheets to lay out data intelligently and usefully
Analyze information quickly and accurately
Transition from one workplace to another with a common “language” in your pocket to help you speak to new employers, databases, etc.
Solve business problems with the advanced application of data
Balance complex accounts
Find and remove bugs in your workflow
Implement tracking systems for a huge variety of departments and operations

… and so much more. Taking a look at the list, chances are good you can already pick out at least five skills you could make good use of right off the bat. Once you become proficient at advanced Excel techniques, you’ll see even more.

2. Increase Efficiency

It’s probably obvious how using Excel faster can make your use of Excel itself more efficient. More importantly, though, understanding Excel at an advanced level enables you to complete a variety of other tasks more quickly. Make decisions more quickly, find the answers to questions immediately (both, those you’re asking and those that are being asked of you), and help team projects move along much more swiftly.

3. Up Your Value as an Employee

Obviously, as you have more skills to offer to your company and become faster at your work, you quickly become more useful to them. If you want to be indispensable in your employer’s eyes, it’s important you keep increasing your value. Otherwise, you’ll find that one day someone else comes along who has all of your skills – and more. You can avoid that by constantly learning, starting with Excel.

4. Make Your Job Easier in Ways You Can’t Imagine

Once you get truly proficient at it, you’ll see that Excel involves the use many shortcuts. Those shortcuts are applicable in more than just Microsoft Office, though; you can use them across your tasks and in other software as well. In some ways, learning advanced Excel strategies can help you become more proficient using the entire suite of Microsoft products. Even a class or two can teach you ways to become more proficient you wouldn’t even have imagined.

In the specifically Excel-oriented space, advanced use of spreadsheets has a large number of applications. From tracking tasks to organizing information to digging through data you don’t yet realize you have access to, Excel can give you a whole new outlook on work and life.

5. Enjoy Working More

Does this seem a little simplistic to you? It shouldn’t. Research indicates that when you’re better at your job, you enjoy it more. No one needs to tell you that, of course; all you have to do is think of a task you’re not that great at (dread) and one at which you excel (enjoyment) and you’ll see the difference in how they make you feel. Learning advanced Microsoft Excel techniques can make you better at what you do, which in turn makes it easier for you to zoom through your tasks, which finally makes the job more gratifying overall.

Plus, studies indicate that “those in more skilled roles tend to be happier (71%) and more interested (77%) in their work. Progression and training are therefore fundamental.” Why wouldn’t you want to be happier and more interested in your work? Answer: You would, so free training offered to you by your employer should be an automatic yes, please.
For the Company

6. Increase Efficiency

Wait, didn’t we already talk about this? Why, yes we did! In fact, your employees will become so much faster and more efficient after taking Advanced Microsoft Excel courses, that you can expect them to save the company overall boatloads of time. After all, if one employee becomes more efficient and shaves a few minutes (or a few hours) off their day, imagine how much time you’ll save if you multiply that by 10 or 20 people. Right?

7. Make Use of a Pre-existing Asset

Lots of skills require preloading of other assets before you can make use of them. You might have to buy specialty hardware, install new software on your company computers or even buy new machines themselves.

Not so with Excel. The great thing about teaching your employees to use Excel more effectively is that it’s already installed on basically every PC in existence. There’s no more efficient spreadsheet tool in the world, and yet it’s so ubiquitous as to be considered nearly free. Not to use this tool is almost a crime, because it’s just sitting there for the taking.

8. Get Quick and Painless Training

Even better news? Imparting advanced Excel skills to your employees doesn’t require paying for a great deal of training. In fact, most people with a basic understanding of Excel can progress to a fairly proficient state in a week or two. Those who already have an intermediate level of understanding can get there in less time.

If you want to give an employee the gift of new skills – and yourself the gift of better-equipped workers – it’s as simple as setting up a short training right within the walls of your company. Usually, when you hire a trainer to come in, you can save even more money by sending individual employees to separate classes (or even to the same classes) and can educate everyone at once.

9. Reduce IT Load

If you don’t teach your employees to use Excel effectively, then you’ll have to rely on your IT department to run numbers, analyze data and give you the numerical tools you need to make decisions. The problem with that is twofold:

Your IT department is already kept busy running from workstation to workstation to help employees, upgrading systems, interfacing with software vendors and more. They don’t have time for another task.
IT professionals may be able to “do the math,” but that doesn’t mean they can apply the resulting information to best effect.

On the other hand, if you train your employees to use Excel themselves in an advanced fashion, they’ll be able both to manipulate data in the moment and to draw meaningful conclusions from it to keep your company whizzing right along.

10. Keep Good Talent Around

If your employees know they can receive ongoing education and rise through the ranks at your company, they’ll have more motivation to stick around. If, on the other hand, your people don’t have faith that they can get much more out of the company past a certain point, they will start looking elsewhere.

One of the best ways to reduce turnover and keep good talent around is to offer to educate your employees. It’s a win-win, because they get to put something on their resume, and you get to leverage those skills immediately after training them.

If you want to train them thoroughly, you might consider sending employees to school for an Advanced Excel Course, or even a master’s program (not to say this is necessary; it’s just an option). In these cases, it’s beneficial to have employees sign a contract stipulating that they will work with you for a certain amount of time afterwards. Often, the skills they’ve learned make them so much more valuable to your business that you’re willing to compensate them at a significantly higher rate, and they have all the motivation they need to stand by you.

At the end of the day, knowledge is always a good thing. If your employees use Excel at all in their work, it’s a good idea to train them. Not only can they perform pre-existing tasks more efficiently, they can use their newfound skills to develop new processes and ideas to improve your organization overall.

21/01/2019

Let’s start with a little word association. When we say soft, what other words does that conjure? Balmy, benign, bland, delicate, gentle, light, mellow, mild, nonabrasive, soothing, tender. Hardly the types of words we people use when talking about building up their strength. Now let’s look at what we mean by soft skills – they are the personal attributes that enable someone to interact effectively and harmoniously with other people. There is a huge disconnect here, and it is only growing as the skills defined as soft are now so critical in the current talent market.

I am taking part in Brené Brown’s read along with her new book Dare to Lead – each week she posts a 10-minute video of her answering readers’ questions about a specific chapter. During one of these sessions, someone brought up the subject of soft skills and wondered why we don’t rename them as the name suggests they are not as important as hard or technical skills. In typical Brené fashion, she answered, “If I put a team of technical people in a room and asked them to choose between working on soft skills – curiosity, vulnerability and shame or hard or technical skills, invariably they’d select hard every time.” In other words, “Things with sharp corners are easier.”

However, this raises a good point. Since the inclusion of soft in the title somewhat diminishes the importance of these skills, is there a better, more satisfying name? Brené suggests courage building skills. While I don’t think our corporate customers are ready for us to put a courage skills collection together, I do think we need to change how we talk about soft skills and why they are now more relevant than ever.

The hard role soft skills play

A lack of good communication, collaboration and conflict resolution are holding people back. West Monroe Partners research shows that 98% of HR leaders believe soft skills are important for candidates looking for technology roles, so important that 67% say they withheld a job offer from a talented IT candidate due to a lack of soft skills. Yet, an incredible 40% of employers do not provide training in soft skills.

A 2018 Bloomberg Next and Workday study found that four in ten corporations and almost half of the academic institutions believe new hires lack the soft skills required to perform at a high level.

In the future, soft skills will also take on even greater significance as artificial intelligence, and other technologies transform the workplace. According to a report by PwC, as many as 30% of existing roles in the UK could be automated by 2030; however, there are still crucial, “human” if you will skills that robots cannot perform.

Are soft skills the hard skills of the future?

In its Future of Jobs report, the World Economic Forum looked at current employment, skills and workforce strategies to identify the top 10 skills that everyone will need in the fourth industrial revolution.

21/01/2019

Why Soft Skills is important for your resume!

Take a minute and bring up a mental image of your resume. Aside from the usual, what’s on it? Did you Google the top skills employers are looking for and tailor your list to match them as much as possible? Did you fudge a little on some? Choose words that are general enough to suggest competencies or experience, yet might be stretching the truth just a fraction?

We’ve all been there and done that, and in fact, as the hiring process evolves, it is getting harder to nail exactly what it is employers want. I did a quick Google search and I was bombarded with a slew of contradictory advice.

Looking for employment in technology is even more of a quagmire, as each year the top in-demand jobs change while that degree you worked so hard to get loses its resume punch a mere three years after graduation. And as each year passes there is new, fresh talent, aka competition, flooding the market and further making your skills and knowledge appear outdated.

So how do you stay competitive, employed or in the running for a promotion?

Keep training, keep upskilling and stay current.

But equally important, you have to make sure that your skill set, like granola, has a healthy mix of oats and nuts, or this case, hard skills and soft skills.

The ‘hard skills’, the tech skills, you probably have them covered, or know what ones you need to excel or expand in for a given IT position.

The ‘soft skills’ are subtler. These are the implicit skills you develop through self-awareness and concerted effort. Everything from communication skills, interpersonal skills, listening skills, ability to negotiate or mediate conflict to working well in a team.

As Caroline Beaton, writing for Forbes, is keen to point out, “Employers value technical skills, to be sure. But I asked more than 100 top HR managers, recruiters and CEOs which was more important for entry-level job seekers, and nearly all of them said soft skills.”

In other words, if you want to succeed, you will need to acquire the following:

Working & Managing in a Virtual Environment
Time Management
Writing Skills
Leading Change
Work Ethic
Agility
Negotiation
Communication
Humility and Patience
Leadership
Team Building
Interpersonal Intelligence
Emotional Intelligence
Problem Solving Skills
Listening

In a nut shell, soft skills are essentially “people skills” and not only do they dictate how we interact with other people, they enable us to successfully navigate the complex and ever-changing work environment. They can be difficult to quantify, but like a visionary new app, they are not unattainable, it just takes focused effort.

Soft skills are best approached as if they were a hard skill, which is why we’ve organized them together into courses, giving you the familiarity of a curriculum in what might be unfamiliar terrain.

21/01/2019

The Importance of Soft Skill Training

I accept that leveraging technology is a high priority for organizations today, with many organizations heavily emphasizing the development of “hard” or technical skills among their employees. And yes, hard skills are vital and necessary to maintain a competitive advantage, but in our social media obsessed world, it is becoming ever more apparent that no organization can afford to take their eye off the “soft skills ball.”

If you have any doubt about why soft skills are more critical now than ever, here’s a hint: social media.

Social media makes everyone’s behavior more public than it has ever been, resulting in employees’ behavior towards customers and suppliers surfacing as a new barometer for brand equity and brand perception. From the CEO to the entry-level employee, an incident that in the past might have gone unnoticed is now just a few clicks away from a full-blown PR crisis that can negatively affect brand equity – and negatively impact a company’s bottom line. All it takes is one video posted on Facebook, one snap, one tweet to turn this narrative on its head.

And yet despite the evidence and recent debacles demonstrating the value of soft skills, companies still regard soft skills as the fluff of work life and just expect employees to know how to behave at work, that they will innately know how to control their emotions and handle customers with tact and diplomacy even when under stress.

But it’s not just the recent PR nightmares that are shining a spotlight on the importance of soft skills training. The shift from a manufacturing to a service economy, the increased pace of innovation and digital transformation, the emerging gig economy and globalization itself are all placing an increased pressure on soft skills and drawing attention to that fact that organizations need to tackle head-on how to best develop both the intrapersonal and interpersonal skills of their leaders, managers, and employees.

A word of advice though before you rush out and sign up for just any soft skills course. Not all soft skills training was created equally. Good training needs to be relevant, relatable, and engaging so that what is learned sticks and results in real behavioral change, thereby, hopefully, ensuring that employees will know exactly how to react even in the most unpredictable and stressful of circumstances.

Additionally, even if you believe your industry is immune or not affected by PR disasters, it is worth noting that employees with strong soft skills are better at attracting and retaining other talent and holding onto their customers, and maximizing the bottom line.

17/01/2019

Microsoft Office products help improve work efficiency with user friendly features that enable easy and secure information sharing. Microsoft Office products provide resources for professional presentation of data that is compatible with most operating systems.

Whether you are looking to expand your Microsoft Office skills for personal use, embarking on a new career, or working towards career advancement, Mboma Training Consultants has the Microsoft Office training that you are looking for.

Mboma designs its Microsoft Office classes to get the student engaged in real life situations, so that you or your team can take the skills learned and apply them to everyday scenarios.

16/01/2019

We offer Microsoft Office training courses from introductory to advanced level. Microsoft Office courses include the Office collection of Excel, PowerPoint, Word and Outlook. We train at our premises in Cape Town and can organise training at your site or at any other convenient site. Our services are differentiated by the following items:

We provide customised handouts to the learners.
We provide individualised service, based on a client specific need.
We offer hands-on learning whereby our learners learn by doing.
We provide free training manual

Our classes are small in size; this allows learners to interact more with facilitators. We offer hands-on learning whereby our learners learn by doing.

Please leave your email address below and we will contact you.

Please like and share our page:
https://web.facebook.com/Mboma-Training-Consultants-516107101892084/

16/01/2019

We often know we can do something in Microsoft Office, but can’t quite figure out how to do it.

Mboma Training Consultants Microsoft Office training quickly points you to the right tutorial to answer your most current “How Do I…” question.

Build your MS Office knowledge one short tutorial at a time or dive into a course to gain a more comprehensive understanding of a specific feature. Our extensive coverage of all MS Office applications and versions offered ensures that, whatever your question, we’ve got you covered.
MS Office courses cover Word, Excel, PowerPoint, Outlook, Access, and more.

Beginner, Intermediate, and Advanced courses lets YOU choose the level that suites you best.

24/03/2016

http://bursaries.skillsportal.co.za/bursary/shoprite-retail-and-hospitality-bursary-2015

Closing Date: December, 2016Field of Study: Food and BeveragesHospitality (hotels and leisureBursary Details: Shoprite has a Retail and Hospitality Bursary Opportunity for 1st, 2nd and 3rd year Honours Students. Bursary: Retail Business / Hospitality Management 2015 Value of Bursary:R 47500 Job Type…