Tracking time and attendance

22 Jan BENEFITS OF TRACKING TIME AND ATTENDANCE WITH TAMS

BENEFITS OF TRACKING TIME AND ATTENDANCE WITH TAMS

As technology continues to revolutionize the way we do business, small business owners time and again neglect a vital aspect of their business: their employee time tracking system. Time and attendance systems based on paper time cards or sheets, memory recall of the past week’s schedule and “buddy punching” lead to hundreds of hours and millions of naira lost each year. A paradigm shift towards an automated time and attendance software that employs the use of a biometric system like TAMS HR Solution will help you track your employees’ time, leading to a more productive, efficient and happy workplace for all involved.

Towards the end of each month, HR Managers spend long hours preparing payroll for organisation’s employees – a time-consuming task that can be carried out effectively with an automated payroll management software in little time.

The advantages of upgrading from a manual time tracking system to a dedicated time and attendance system are always obvious and are neither farfetched. Here are benefits of tracking time accurately:

SPEND LESS TIME ON PAYROLL

The most basic benefit to your business is that less time will be spent; both by employees and HR, tracking, recording and processing their time spent working each day, week and month. By upgrading, some businesses cut their time calculating payroll each month by up to 70%. Employees can focus on their respective jobs, rather than the additional task of accounting for themselves.

PREVENT TIME THEFT

Time theft can include everything from taking a longer lunch than allotted or clocking in for a friend when they are late to work, otherwise known as “buddy punching.” The American Payroll Association estimates that over 75% of businesses lose money from buddy punching. Whether intentional or innocuous, time theft can be costly and automated time and attendance systems like TAMS HR Solution prevent it altogether.

PREVENT HUMAN ERROR IN BOOKKEEPING

Nobody is perfect, not even if they have a calculator, spreadsheet or other computation devices handy. Even the most accurate typist makes one mistake for every 300 keystrokes.  One misplaced digit or decimal can lead to accounting errors that need to be corrected, or worse, are left uncorrected and can affect your bottom line negatively.

KEEP EMPLOYEES INFORMED

An all-too-common question for those working in HR is how much time off an employee has left this year, or whether they have any sick days remaining. Rather than letting discrepancies cut into work, quality time and attendance software will allow employees to access that information on their own at any time.

Allowing employees to see their time records on demand will help them see how well they’re utilizing their time at work. The insight gained from seeing how much time is spent on particular projects or at certain sites can be invaluable and will help them eliminate inefficiencies.

SPEND LESS TIME AND RESOURCES ON PAPERWORK

Merely sorting through, organizing and processing paperwork can be time-consuming. Additionally, the cost of replenishing the items needed to maintain an old-time and attendance system, paper, pens/pencils, printer ink, and toner, etc. can be prohibitive in the long run.

STAY ON THE RIGHT SIDE OF THE LAW

State and federal labour laws regulate things like overtime pay and record keeping, both of which can be problematic to track if you have a manual time and attendance system. Rather than opening your business up to future lawsuits, which can result in millions of dollars awarded in back wages, stay on the right side of the law with accurate time tracking.

UTILIZE A SYSTEM THAT CAN GROW WITH YOUR BUSINESS

A paper-based system may work, in some respects, for your small business now. If you expect your business to grow, and who doesn’t hope for the best in that regard, you’ll want a system that can grow with you as you hire more employees and have more information to track.

Rather than beginning the search for an upgrade before it’s too late, get out ahead of the curve and upgrade while your timekeeping needs are still manageable.

CREATE A CENTRAL DATABASE THAT CAN BE ACCESSED THROUGHOUT THE COMPANY

If your company is spread out across multiple offices or sites, it’s much easier to calculate payroll via a system that is standardized for all employees. This creates a central database, with guaranteed practices, that can be accessed from anywhere, including on the go.

The disadvantages of relying on time-consuming and outdated methods of employee time-tracking are numerous, it costs time and money; it can get you in legal trouble; it can lead to stress-related illnesses for those who have to spend hours each week collecting, correcting and calculating timesheets; it distracts employees from completing the tasks they were hired to tackle each week. Rather than staying in the past, embrace the future by switching to quality time and attendance system, and let your company enjoy the benefits of accurately tracked time.

TRACKING OF PROJECTS AND TASKS

You can also use the time-tracking software to find out how well some projects and duties are being carried out. For instance, if you recognize that normally a particular task takes two to three hours to complete, but a worker took five hours this will be a sign indicating that there is a problem. You can engage the employee and discover if they require further training to make the project easier. You can realize if somebody else had delayed part of the project or the material that was necessary to accomplish the task. Utilizing the records from the system will alert the employer about potential setbacks that need to be resolved. You can identify these issues at the initial stages of the project and thus wind up using time more resourcefully to attain the company goals.

How would adding an automated time and attendance system save your company money each month? Contact Us today and let’s hear from you.

 

Read More
Tams Hr Solution

18 Jan Primera Africa Legal Deploy’s TAMS HR Solution

PRIMERA AFRICA LEGAL DEPLOY’S TAMS HR SOLUTION

Primera Africa Legal, an award-winning full-service law firm is now on TAMS. Their Law firm is proudly Nigerian with a global reach and they serve their clients from their offices in Lagos and Abuja in which they recently deployed the TAMS HR Solution to strengthen workplace efficiency, as part of the many steps to improve good service delivery in Nigeria.

Primera Africa Legal applies in-depth understanding of the Nigerian, regional and global markets to provide accurate and ethically sound legal advice to their clients, this guarantee’s trust and support from their complex local and cross-border transactions with businesses in both established and emerging markets instinctively.

With the TAMS HR Solution, achieving great strides by delivering competitive rates for legal advisory and support services, and providing adequate advisory services tailored to suit their client’s mandate will become much easier.

Primera Africa Legal now joins over 1,000 TAMS clients across Nigeria and West Africa. TAMS HR Solution is renowned for its affordability and ease of use- attributes such as these have made it a workplace solution of choice for small, medium and large organizations.

 

TAMS HR Solution is a proven biometric human resources management solution that has improved organizations return on investment through an automated system of detecting time theft and curbing employee’s laxity. The features or services on the TAMS Solution includes Time Attendance, Payroll System, Job Cloud, Verification and Identity Management, Electronic Voting, Event Management, Asset Management, Reports & Statistics, and Communication

Today over 1,000 thriving organizations are using TAMS HR Solution to automate their workforce management and increase operational efficiency, as a result, they are seeing a significant reduction in direct and indirect labour costs.

Find out why more than 1000 companies and organisations in different sectors of the economy are using the TAMS HR Solution as a workplace panacea to improve workforce productivity.

Read More
5 SMALL BUSINESS TECHNOLOGY TIPS TO BOOST YOUR NEW BUSINESS

08 Jan 5 BUSINESS TECHNOLOGY TIPS TO BOOST YOUR NEW BUSINESS

5 Business Technology Tips to Boost Your New Business

We live in an advanced society where new ventures can start with little money and a big idea can carve out a successful business. While it is true that not every new business will survive, there are some simple techniques that can be utilized to make the most of your money, resources, and time.

When it comes to managing the technology side of your new business, you should definitely keep these tips for starting a small business in mind.

Store data in the cloud to reduce IT cost

When you’re starting out, you want to keep costs low. A great way to save money on IT costs is by using cloud storage instead of a physical server.

Cloud storage is particularly well suited to small businesses, and you can easily keep track of your spending as you will only ever be charged for the space you use. Best of all, cloud storage doesn’t require the same IT capacity or expertise, so you won’t need to hire an entire IT team. Just be aware that as you expand, you may need to spend more or make the switch to a dedicated server.

Get the best and cheapest Internet

Whether you work from home or sell physical goods in a store, a good business internet connectivity deal is essential.

The best bookkeeping apps and inventory management software are now cloud-based, so connectivity is very important. Most business packages offer priority service as a standard, meaning your providers are obliged to get your connection up and running immediately should something wrong. You will also want to look for a deal that offers optimum speeds for your area, as well as a comprehensive security package.

Be realistic about your social media presence

You may have big plans for the marketing side of your business, but just remember that less can be more when it comes to social media. If you don’t have the time or resources to commit to maintaining several accounts, just stick to one or two. A single Twitter account that is updated several times a day and has a healthy following is far more valuable than a trio of Facebook, Instagram, and Tumblr accounts which were last updated six months ago.

You can hire someone to manage your communications in the later on. But when you are starting out, stick to one channel and do it justice. And do not forget that scheduling tools like Hootsuite, TweeDeck, and Postfity can seriously optimize your time.

Plan your website’s purpose and structure

To make the most of your website, think of it as an extension of your real-world business. It should use the same tone of voice and branding so that when any visitor ends up on your site, they can quickly grasp its purpose within seconds. It’s also important for the user journey to be clear and straightforward.

Try it out yourself — how many tabs or buttons do you have to click to engage with the service? Don’t forget that the average person only has an attention span of eight seconds, so you need to grab them quickly!

Make sure your website is mobile-friendly

In 2015, Google made a big change to its algorithms, meaning they now prioritize mobile-friendly websites in the rankings. Give your website a real chance on the search engine results page by making changes that streamline it for mobile and tablet technology.

Key features of a mobile-friendly site are a simple design, fast loading speeds, and mobile-optimized features such as “call-to-action” buttons. If in doubt, opt for a mobile-responsive design when building your site.

Lastly, don’t forget that the specific needs of every business are different. Spend some time deciding which technology tip or tools will benefit your site the most and do not rush into anything you can not easily reverse.

Read More

28 Dec Ways to Be More Productive in 2019 – Employee Productivity Manual

Ways to Be More Productive in 2019 – Employee Productivity Manual

Do you want to be more productive in 2019? Would you like to tune up your productivity skills? When it comes to getting things done, you can’t go wrong going back to basics. Mastering basic productivity skills can make a world of difference in your daily routines. In this post, we offer ways to be more productive in 2019. Whenever you need a productivity boost in the New Year, try one or more of these basic tips. You will be glad you did!

 

  1. Be more flexible ­- Have a contingency plan.

When things do not go as planned during your day, remember that flexibility can mean the difference between getting things done and not getting things done. Have contingency plans for when things go a bit haywire?

For instance, if the internet goes out at work, could you take care of some filing, or organize your receipts for your expense report? If an in-person meeting is suddenly not possible, how about holding an impromptu conference call?

When it comes to getting things done, think flexible thoughts, create contingency plans, and see what you can accomplish!

  1. Shorten your to-do list.

Have a mile-long to-do list? Take a moment to trim your daily list down to three to five tasks.

A smaller list will allow you to focus your energy and attention on what’s important which means you will more likely to complete items on your list. Begin by making a list of tasks, and then prioritize items, one by one. Need help identifying which tasks are urgent and important? You can evaluate each of your tasks using the Eisenhower Box method.

  1. Put your personal time first.

Your calendar doesn’t have to be completely filled with external activities in order for it to be important.

Your calendar is important because it is your calendar! That being said, take the proactive approach when it comes to your personal time.

Physically schedule your personal time, such as vacation or leave time, exercise, hobbies, recreation, and other activities into your calendar.

Treat your time just like you would any other appointment, meeting, or event; once your calendar is booked, it’s booked.

  1. Take time to track your progress.

Having trouble keeping track of your progress on a project or assignment? Why not use a visual aid?

Having a visual representation of all of your hard work can be incredibly motivating.

Try tracking your work sessions using a hanging wall calendar or calendar printable, jot down your progress in a notebook or journal, or create your very own productivity diary. Yes, things may seem like slow going at first, but you’ll see marked progress, day by day, which can be extremely exciting.

  1. Get adequate rest.

Here’s a quick question for you: are you getting enough rest during your daily routine? There are many ways to get adequate rest during the day. This tip, however, requires you to keep your eyes open…and to think creatively! Where in your day can you make sure you get adequate rest?

For starters, how about taking your full lunch break every day so you have time to recover from your work or studies? Or how about fully disconnecting from digital devices, social media, and email for a couple of hours so you can relax and unwind? Or how about keeping to a reasonable bedtime?

  1. Go offline every now and then.

We may live in the digital age, but it’s a good idea to take a mental break from technology once in a while. Try completing basic tasks by hand, such as making simple mathematic calculations on a piece of paper, writing out a to-do list, reading a physical book, or dialing a phone number manually.

And if you think you can’t be productive when you switch to analog mode, think again! Taking the time to complete a task manually will make you slow down and focus more on what you’re doing. You may even find an error or have a flash of insight that leads you to be more productive during your time online.

  1. Make solid decisions.

Life is full of gray areas, but that doesn’t mean you can’t be firm in your day-to-day decisions. Just imagine for a moment: what if you could eliminate unnecessary stress and flip-flopping during your day?

Here’s an easy way to do so: answer questions using only a “yes” or “no” response (using words such as “maybe” and “might” can slow down the decision-making process). You’ll stop wasting valuable mental energy and can focus your attention on what really matters.

  1. Carry a small notebook and pen with you.

Be ready for those flashes of insight, fabulous ideas, and list, after list, after list!

A plain old notebook and a pen can be incredibly powerful productivity tools. Sure, digital devices are handy, but nothing compares to writing things down by hand (plus, there’s no need to worry about charging batteries or finding a signal!).

You can quickly jot down ideas and thoughts, write a story, take notes at a meeting, draw a map for a lost traveler, plan a party, draw or doodle in your spare time, leave a note for someone, write a shopping list, or brainstorm vacation travel plans.

  1. Expand your library of productivity books

There are plenty of books and monumental articles about productivity — what to choose?

When it comes to putting all of these books together, it is very difficult to choose between them, with so many good ones out there. You can check out these productivity books.

  1. The Power of Full Engagement by Jim Loehr & Tony Schwartz.
  2. Getting Results the Agile Way by J.D. Meier & Michael Kropp
  3. The Happiness Advantage by Shawn Achor
  4. The 4-Hour Workweek by Timothy Ferriss
  5. The Power of Habit by Charles Duhigg
  6. 7 Habits of Highly Effective People by Stephen Covey
  7. The Magic of Thinking Big by David J. Schwartz

Insightful posts and articles are also powerful. Here’re some great examples:

Top 27 Productivity Hacks for 2019

Top 10 Professional Life Hacks

 

  1. Always think positively

There is no best way to explain this other than to practice it daily – positive thoughts beget positive actions – like begets like.

How about you? Which of these tips resonates with you the most? Which of the above tips are you going to try out this year? How might you modify or interpret the above tips for your daily routines? Join the conversation and leave a comment below!

 

 

 

 

 

 

Read More
GLOBACOM ON TAMS

20 Dec GLOBACOM LIMITED NOW ON TAMS

GLOBACOM LIMITED NOW ON TAMS

 

Globacom Limited mostly known as GLO, a Nigerian multinational telecommunications company headquartered in Lagos is now on TAMS. GLO is a privately owned telecommunications carrier that started operations on 29 August 2003. It currently operates in four countries in West Africa, namely Nigeria, Republic of Benin, Ghana and Côte d’Ivoire. As of June 2009, the company has employed more than 2,500 people worldwide.

GLO has an estimate of over 34 million subscribers (April 2016) of which 26 million are internet subscribers, and it is a 100 percent Nigerian owned company. Having soared high in their aspiration to build Africa’s biggest and best telecommunications network with millions of subscribers in Nigeria, Republic of Benin and Ghana, Globacom recently deployed the TAMS brand of workplace technologies at their branches in Lagos, Abuja and Port Harcourt to enable them improve workforce productivity in order to continue playing massive roles in Africa

Globacom now joins over 1,000 TAMS clients across Nigeria and West Africa. TAMS is renowned for its affordability and ease of use – attributes such as these have made it a workplace solution of choice for small, medium and large organizations.

 

ABOUT TAMS

TAMS workplace Solution is a proven biometric human resources management solution that has improved organizations return on investment through an automated system of detecting time theft and curbing employee’s laxity. The features or services on the TAMS Solution includes Time Attendance, Payroll System, Job Cloud, Verification and Identity Management, Electronic Voting, Event Management, Asset Management, Reports & Statistics, and Communication.

Today over 1,000 thriving organizations are using TAMS to automate their workforce management and increase operational efficiency and as a result, they are seeing a significant reduction in direct and indirect labour costs.

Find out why more than 1000 companies and organisations in different sectors of the economy are using the TAMS Workplace solution as a workplace panacea to improve workforce productivity.

Read More
Productivity Using Technology

11 Dec 10 Ways to Effectively Increase Productivity Using Technology

10 Ways to Effectively Increase Productivity Using Technology

Productivity in workplaces has been a matter of concern for decades – it primarily centre’s on how employees can work towards the achievement of organizational goal effectively and efficiently. Although with the availability of modern technology, employee productivity is still a matter of concern and this brings the question of whether technology aids or bedevils employee productivity in the workplace. Below are how modern devices and applications can help employees work more efficiently, increase their productivity and ultimately achieve their business goals.

READ ASLOTop 10 Professional Life Hacks

  1. Make Sure You Use the Right Technology

Understand that technology can be a blessing or a curse for productivity depending on how it is utilized. Increasing productivity with technology is possible when the right tools are utilized. Determine where you need a productivity boost in your everyday life and research if there is a tech tool readily available to fill that gap — chances are, there is.

  1. Incorporate Automation Tools

Find the tools that automate everything, from scheduling and bill pay to email responses and contact update lists. Also, add as many apps as possible that provide a way to digitize any manual processes such as list making or gift giving.

  1. Manage Passwords Effectively

Passwords are being phased out in lieu of biometric authentication. Until most applications offer a seamless, intuitive UX such as a selfie for logging in or voice recognition for payment, management of passwords is essential. Password reissues and resets are costly both operationally and financially. It is recommended that you manage your credentials across devices with a tool such as 1Password.

  1. Only Use Technology Where You Need Help the Most

First, identify the areas where you’re regularly wasting time. Then, select mobile apps or services that directly meet those needs. My go-to’s are Evernote and Headspace. There is a technological solution for nearly every problem you’ll face, but if you engage in every app and service, you’ll actually decrease your productivity.

  1. Use Chrome Extensions

Let’s face it: Everyone wants to get more done in less time. The best way I’ve found to do this is to add all your tools to your Chrome browser, allowing you to access them much quicker. I recommend adding extensions such as Lastpass, which saves and remembers all of your passwords to every website you have to log into. This saves considerable amounts of time and increases productivity greatly.

  1. Organize Your Time with a Calendar App

Calendars are the most underutilized productivity tool by far. Reminders pair really well with good planning. Once you have the week entered into your calendar, your productivity has some rails to guide it.

  1. Take Advantage of Free Applications

Strictly from a consumer perspective, taking advantage of free applications can make everyday life more productive. Here are some examples that have had an impact on our life, which includes a family of five: mobile grocery ordering and pickup, mobile home electronics monitoring (HVAC, alarm, etc.) and application-based scheduling (bus, sports, etc.).

  1. Useless Technology Altogether

Obviously, automation of processes and workflows yields great efficiency returns, but we sometimes forget that most of our productivity is achieved by uninterrupted periods of time where we think and work hard and make breakthroughs, not through ever-decreasing incremental improvements on our to-do list app or finessing with our tools of the trade.

  1. Enhance What You Already Have

Employ an easy-to-use add-on or plug-in function to optimize your existing programs. For example, I use Boomerang for Outlook as an email filing/reminder system. I get so many emails, so it’s nice to have Boomerang clean up my inbox by archiving important messages and bringing them back when I need them.

  1. Set Clear Goals and Keep It Simple

There is power in setting goals, and common smartphone features are a simple way to stay focused and productive. Record goals and set reminders to keep them top of mind. Daily, weekly and monthly reminders force you to revisit the bigger picture frequently. I have found this to be the easiest way to stay on track with my goals, and it ultimately results in greater achievement and future success.

Read More
TAMS - Time and Attendance Solution for the Banking Sector

05 Dec TAMS – Time and Attendance Solution for the Banking Sector

TAMS – Time and Attendance Solution for the Banking Sector

With distributed employees across locations and even states, banks need to be able to quickly summarize and analyze employee information to make staffing, scheduling and leave management decisions. Pay, Overtime and Holiday reports are also critical. No matter if it′s small retail branch or large corporate banking institute, safety and security is always a concern of any customer. To have satisfied clients, Banks look ahead for a technological Time & Attendance software product that is highly reliable, easy to use and capable to connect all their branches.

Clients participation becomes the key for Banking sector and TAMS Time & Attendance solutions for banking vertical comes in an effort to provide a unique client experience that focuses on improving the relationship with their bankers. Our solutions are tailor-made to meet the standards of the banking firm and to provide the best Time & Attendance system in practice.

TAMS can be used by any Banking organization that requires a streamlined system that saves supervisors the time of gathering, collating and sending this information using less efficient methods like paper timesheets. TAMS offers a comprehensive Time & Attendance solution that will meet the challenges of every bank.

TAMS advanced Time & Attendance solutions are a range of intelligently designed services to meet all the critical requirements of the Banking industry. TAMS offer Time & Attendance solutions for retail, corporate banks and financial institutes. TAMS supports Banking sector to meet their demand of access control, time management, multi-site connectivity, centralized report, leave management, and holiday management.

TAMS TIME AND ATTENDANCE MANAGEMENT SOLUTION

Managing your workforce in an efficient, fast and smart way can significantly improve your business in terms of profit and productivity. One way to ensure you’re getting the most from your staff – and to discover better ways to manage your team’s working hours – is to integrate an employee time and attendance system into your business

We understand the importance of simplified and automated Time and Attendance software. As the pioneers of web-based computerized clocking-in systems, our Time Attendance Management System (TAMS) is used by some of the country’s leading organizations, across a wide range of industries; including manufacturing, transport, retail, health and service centres.

Our reporting solutions empower you with informed real-time decision-making capabilities so you can easily convert data into actionable, valuable information.

WHY TAMS? – CONTROL LABOR COST & INCREASE OPERATIONAL EFFICIENCY

According to research, companies without an automated time and attendance solution tend to overpay employees by 1.5% to 10% of gross payroll due to time theft and error driven calculations, costing businesses billions of naira each year. For a company with 10 employees, that can amount to more than $10,000 a year. TAMS time and attendance solution helps you eliminate calculation errors by helping you accurately calculate hourly totals and automatically applying overtime policies accordingly, and maintaining you in compliance with labour laws

POWERFUL REPORTING AND STATISTICAL ANALYSIS

Gain complete visibility with TAMS Enterprise reporting/statistical analytical features which empower you with informed real-time decision-making capabilities so you can easily convert data into actionable, valuable information. Instant access for managers and executives to reporting, query, and analysis tools enables your organization to proactively manage business needs, instead of just reacting to them.

BENEFITS OF USING TAMS

  • Improve employee productivity.
  • Avoids the hassle of auditing paper-based employee time cards
  • Reduces costly manual payroll & data entry errors
  • Minimizes payroll processing time
  • Stay in compliance with labour laws by applying overtime policies accordingly
  • Reduce the time required to schedule employees
  • Eliminate the need to calculate vacation, sick and other paid time off
  • Enjoy up to the minute real-time visibility on your time & attendance data
  • With our cloud solution, no need to install or maintain software
  • Access anytime, and from anywhere using a web browser
  • Identify & eliminate time theft (early in, late out, & buddy punching)
  • Export time totals in minutes to all payroll providers and software
  • Holiday management is easy and simple
  • Lower overtime costs by proactively changing schedules quickly
Read More
Microsoft Excel

04 Dec 10 Most Useful Microsoft Excel Tips for Employees

30 years since entering the market Microsoft Excel remains the most widely used software by businesses. Despite its wide use, the full capabilities of Excel are still poorly understood. You won’t be suprised that, of 100,000 workers less than half know what Conditional Formatting – an essential feature – even does.

For all those in need of a quick dose of tips to improve their Excel proficiency check out the top 10 tips below.

So let’s start!

 

1. Conditional Formatting

Graphical conditional formatting in Excel

Making sense of our data-rich, noisy world is hard but vital. Used well, Conditional Formatting brings out the patterns of the universe, as captured by your spreadsheet. That’s why Excel experts and Excel users alike vote this the #1 most important feature. This can be sophisticated. But even the simplest colour changes can be hugely beneficial. Suppose you have volumes sold by sales staff each month. Just three clicks can reveal the top 10% performing salespeople and tee up an important business conversation.

 

2. PivotTables

Mastering PivotTables in Excel

At 4 hours to get to proficiency, you may be put off learning PivotTables, but don’t be. Use them to sort, count, total or average data stored in one large spreadsheet and display them in a n1ew table, cut however you want. That’s the key thing here. If you want to look only at sales figures for certain countries, product lines or marketing channels, it’s trivial. Warning: Make sure your data is clean first!

 

3. Paste Special

How and why to use paste special in Excel

Grabbing (i.e. copying) some data from one cell and pasting it into another cell is one of the most common activities in Excel. But there’s a lot you might copy (formatting, value, formula, comments, etc.) and sometimes you won’t copy all of it. The most common example of this is where you want to lose the formatting. The place this data is going is your own spreadsheet with your own styling. It’s annoying and ugly to plonk in formatting from elsewhere. So just copy the values and all you’ll get is the text, number, whatever the value is. The shortcut after copying the cell (Ctrl C) is Alt E S V – easier to do than it sounds. The other big one is Transpose. This flips rows and columns around in seconds. Shortcut Alt E S E.

 

4. Add Multiple Rows

Adding multiple rows in Microsoft Excel

Probably one of the most frequently carried out activities in spreadsheeting. Ctrl Shift + is the shortcut, but actually it takes longer than just right-clicking on the row numbers on the left of the Excel display. So Right Click is our recommendation. And if you want to add more than one, select as many rows or columns as you’d like to add and then Right Click and add.

 

5. Absolute References

How to used fixed references in Excel

Indispensable! The dollar in front of the letter fixes the column, the dollar sign in front of number fixes the row, F4 toggles through the four possible combinations. Try it out with the following exercise. Type out three foods horizontally in cells B1, C1, D1 (Olives, Granola, Tomatoes) and three colours in cells A2, B2, C2 (Green, Blue, Yellow). Now type in cell B2 ‘=A2&” “&B1’. Congratulations: Green Olives! Now – and here’s the exercise – add dollar signs so that when you copy the formula across you get green everything. Or just Granola, but of different colours. Experiment!

 

6. Print Optimisation

How to optimise printing in Microsoft Excel

Everyone has problems printing from Excel. But imagine if what you printed were always just what you intended. It IS possible. But there are a few components to this: print preview, fit to one page, adjusting margins, print selection, printing headers, portrait vs landscape and spreadsheet design. Invest the time to get comfortable with it. You’ll be carrying out this task many, many times in your working life.

 

7. Extend Formula Across/Down

Using Excel's crosshair to extend formulas

The beauty of Excel is its easy scalability. Get the formula right once and Excel will churn out the right calculation a million times. The + cross hair is handy. Double clicking it will take it all the way down if you have continuous data. Sometimes a copy and paste (either regular paste or paste formulas) will be faster for you.

 

8. Flash Fill

Benefits of using Flash Fill in Excel

Excel developed a mind of its own in 2013. Say you have two columns of names and you need to construct email addresses from them all. Just do it for the first row and Excel will work out what you mean and do it for the rest. Pre-2013 this was possible but relied on a combination of functions (FIND, LEFT, &, etc). Now this is much faster and WILL impress people. If Flash Fill is turned on (File Options Advanced) it should just start working as you type. Or get it going manually by clicking Data > Flash Fill, or Ctrl E.

 

9. INDEX-MATCH

Combining INDEX and MATCH in Excel

This is one of the most powerful combinations of Excel functions. You can use it to look up a value in a big table of data and return a corresponding value in that table. Let’s say your company has 10,000 employees and there’s a spreadsheet with all of them in it with lots of information about them like salary, start date, line manager etc. But you have a team of 20 and you’re only really interested in them. INDEX-MATCH will look up the value of your team members (these need to be unique like email or employee number) in that table and return the desired information for your team. It is worth getting your head around this as it is more flexible and therefore more powerful than VLOOKUPs.

 

10. Filters

How to use Filters in Excel

Explore data in a table quickly. Filtering effectively hides data that is not of interest. Usually there’s a value (e.g. Blue cars) that you’re looking for and Filters will bring up those and hide the rest. But in more modern versions of Excel, you can now also filter on number values (e.g. is greater than, top 10%, etc), and cell colour. Filtering becomes more powerful when you need to filter more than one column in combination e.g. both colours and vehicles to find your blue car. Alt D F F is the shortcut (easier than it sounds – give it a go). Conditional Formatting and Sorting serve related purposes. Sorting involves rearranging your spreadsheet, which is intrusive and may not be desirable. Conditional formatting brings visualisation. Filtering is fast and effective. Choose well.

 

Read More
Safety Tips for the Workplace

30 Nov 8 Safety Tips for the Workplace – Corporate Safety Tips

8 Safety Tips for the Workplace

Workplace Safety is a huge topic for all organizations, both big and small. The most valuable assets in the company are the employees, making safety the highest priority. It is a way of living and working for you and everyone around you. Your company may have its own set of safety procedures and guidelines, but here are some general safety tips that can help create and promote a safer work environment.

  1. Observe and practice the correct procedures established for your job. Many companies have set safety procedures and guidelines for employees to follow, but some positions may require extra safety precautions. Review the safety procedures required of your position and make sure you are following them correctly. If you have a question or concern, contact your supervisor or manager for further instruction, guidance, or training.

  1. Report any unsafe conditions or acts to your supervisor. If you see anything out of place or someone doing something incorrectly, tell your supervisor or management. It is important that hazardous conditions and acts are reported immediately to avoid anyone getting hurt.

  1. Report any sickness or injury to your supervisor immediately. This is just as important as reporting unsafe conditions or acts. If you get sick or injured on the job, no matter how minor, you should tell your supervisor right away. Your safety and health should be your number one priority, so don’t take any injuries or sickness lightly. Near misses are just as important to report, so we can build on lessons learned.

  1. Keep your workspace clean and organized. Whether you have a desk job or you work in a warehouse, keeping your area neat and tidy is important for workplace safety. Keep items off the floor, put all personal items in a safe place, and keep any and all distractions to a minimum.

  1. Ensure a clear and easy route to emergency exits and equipment. Do not block fire extinguishers or alarms. Make sure all emergency exits are easily and readily accessible. Both emergency equipment and emergency exits should be regularly maintained to ensure they are in proper working order. It is also important to practice fire drills and talk about what to do in the event of an emergency.

  1. Be attentive at all times to your work surroundings. Remain awake and alert in your workspace. Being attentive and alert can prevent any workplace-related injuries. Be conscious of others around you and what they are doing so you don’t pose a hazard to them and vice versa.

  1. Dress appropriately for your specific workspace and/or task. If your position or a certain task requires you to wear protective equipment, make sure you have and wear safety glasses, protective headgear and foot gear, safety harnesses, etc. As a general rule, you should be following the general guidelines for dress code set forth in your employee handbook.

  1. Make safety a team effort. Make sure everyone is educated about the safety requirements established by the organization. Participate in workplace safety training if necessary and work together to develop emergency plans and procedures. Remember to always keep communication lines open with your co-workers, employers, and employees. Open communication can promote and maintain a safe environment.

Safety is no accident! It is a lifestyle, and it begins with you!

Read More
radisson blu

29 Nov RADISSON BLU NOW ON TAMS

RADISSON BLU NOW ON TAMS

 

Radisson Blu is an Iconic, stylish and sophisticated brand that creates excitingly individual hotels for individual minds. They delight their travel savvy, modern guests with a genuine, inviting ambiance and also create excitement with their stunning, leading-edge design. Radisson Blu recently deployed the TAMS brand of workplace technologies at their Victoria Island office in Lagos to improve employee productivity and great customer experience.

Radisson Blu features more than 380 unique hotels in the world’s most desirable destinations: dynamic major cities, nearby airport gateways and in the most sought-after leisure hotspots. It is a perfect equation that adds up to a highly individual – and unforgettable – 360° hospitality experience, unrivaled anywhere in the world today.

Radisson Blu now joins over 1,000 TAMS clients across Nigeria and West Africa. TAMS is renowned for its affordability and ease of use- attributes such as these have made it a workplace solution of choice for small, medium and large organizations.

Read More