A multinational, involved in manufacturing of building materials, wants to fill the following roles:

1. Finance Manager.

Pay: 150,000 -200,000 net
Location: Lekki
Male preferred, but female can apply
Inorder to cater for their Igbo speaking clients, only Igbo’s are encouraged to apply

Qualification:
• 3-5years experience as an Accountant/Finance Manager
• Inventory experience, strongly desired
• Young and smart
• ACCA Added Advantage

2. Field Marketing Executive

Pay: N80,000
Location: Lekki
Male preferred, but female can apply
Inorder to cater for their Igbo speaking clients, only Igbo’s are encouraged to apply

Qualification:
1-3 years sales experience
Experience selling building or construction materials, strongly desired.

Interested and qualified candidates should send their cvs to recruitmentforclients@gmail.com, using role applied as subject of mail. 1st level interview holds on Wed-Oct 10, 2018.

Urgent vacancy for the post of a Supervisor in a fast-growing bakery/confessionary in Abuja. 1-3 years working experience. Minimum of OND qualification. Salary is very attractive. Interested and qualified candidates should send their CV's to ollyjoseph@yahoo.com on or before 15th of October 2018. ABUJA RESIDENCE ONLY

Urgent vacancy for the post of a Supervisor in a fast-growing bakery/confessionary in Abuja. 1-3 years working experience. Minimum of OND qualification. Salary is very attractive. Interested and qualified candidates should send their CV's to ollyjoseph@yahoo.com on or before 15th of October 2018. ABUJA RESIDENCE ONLY

The number is switched off

dicksonadams:
I need someone to help me write up my Cv/resume and cover letter.

Chat me 08034288798

Vacancy exist for the position of Audit trainees in a professional practice firm based in Ikeja, Lagos. B.sc/HND accounting.

Must have flair for financial technology with demonstrable ability to learn fast.

Interested applicants should send their CV to:
recruitment@estaudit.ng

A furniture Manufacturing company requires the following as a matter of urgency. Location is Sango Ogun state.

1. Assistant Admin Manager/PA to the General Manager
Must be a graduate with at least 3 years work experience in
related field .
Must be a male.
2. Assistant Production Manager for Metal furniture.
Must have hands on/supervisory experience in metal
furniture and spraying.
Must be able to pay attention to details.
Must be a male.
Must have at least 5 years work experience in metal
furniture.

If interested, please inbox me. Or send c.v to tolaniolalekan@yahoo.com

Interview is this Friday. 11/10/18

Urgent Vacancy!
Position: Corporate Finance Analyst (Tax & GL)
Location: Ikoyi, Lagos
Job Purpose:
The job holder will proactively provide support to the Tax and General Ledger Teams to ensure full compliance with relevant tax laws and accounting standards.
Responsibilities not limited to:
• Withholding Tax (WHT) reconciliation and preparation of monthly WHT remittance schedules
• Value Added Tax (VAT) reconciliation and preparation of monthly VAT remittance schedules
• Preparation and sign-off of all tax reconciliation schedules; Value Added Tax (VAT), WHT, Excise, PAYE and other Employee Related Taxes
• WHT credit note process management
• Ensure timely filing of all tax related returns
• Follow up with the banks to obtain proof of remittance and official revenue receipts
• Scanning all tax receipts & updating the tax remittance database
Qualification
• Bachelor’s degree in Accounting or any other business related field
• Accounting certification (ICAN or ACCA) - Minimum (Professional Level)
Experience
• 3-5yrs cognitive experience in FMCG or similar environment
• Knowledge and use of any ERP
Qualified candidates should forward CVs to vacancies@tusenconsulting.com using the position as the subject of the email.

Do you have the map of Lagos in your head?
Are you great controlling the wheels of cars or trucks?
Can you perform magic with both auto and manual transmissions?

Then you are a great driver.

Now, are you between 28-32 years of age and would like to work with dynamic young engineers?
Do you live around Ikeja/Osodi/Agege or Ketu Axis?

Do you have a valid Drivers' license and LASDRI ID?

Then send your CV to careers.aril@gmail.com using DRIVER as the subject

Application closes by 12th October, 2018.

Referrals would be appreciated.

Cars45 Ltd is currently seeking to recruit Sales/Customer Service Officers for our various Inspection centers in Lagos.

Job Requirements: 1-2 years experience in Marketing (Insurance, Direct Sales Agent, etc), Excellent Negotiating Skills, Strong Marketing Skills, Excellent Communication Skills, HND/BSC in any discipline.

Interested individuals should send their CV to careers@cars45.com with LINKINDMKT APPLICATION as email subject on or before Wednesday, 10th October, 2018.

A furniture Manufacturing company requires the following as a matter of urgency. Location is Sango Ogun state.

1. Assistant Admin Manager/PA to the General Manager
Must be a graduate with at least 3 years work experience in
related field .
Must be a male.
2. Assistant Production Manager for Metal furniture.
Must have hands on/supervisory experience in metal
furniture and spraying.
Must be able to pay attention to details.
Must be a male.
Must have at least 5 years work experience in metal
furniture.

If interested, please inbox me. Or send c.v to tolaniolalekan@yahoo.com

Interview is this Friday. 11/10/18

The past 10 years have seen a wave of innovative big data software designed to analyze, manipulate, and visualize data. Yet for the regular knowledge worker, Microsoft Excel, 30 years on, remains the go-to product for people looking to make sense of data. Satya Nadella, Microsoft’s CEO, maintains that Excel is still the one Microsoft product that stands above the rest — and 750 million knowledge workers worldwide support that claim every day.

We’ve been teaching and testing Microsoft Excel for a decade, and a survey of several hundred office staff we ran suggests we spend more than 10% of our working lives spreadsheeting, and for those working in research and development or finance, it’s more like 30%, or 2.5 hours a day.

Imagine, then, if this substantial proportion of the global workforce were a little better at using the application. Time would be saved, and productivity would improve.

INSIGHT CENTER
Scaling Your Team’s Data Skills
SPONSORED BY SPLUNK
Help your employees be more data-savvy.
Last year we put together The Definitive 100 Most Useful Excel Tips, for which we consulted Excel experts and looked at tens of thousands of test results and course usage data. Though every Excel feature has a use case, no single person uses every Excel feature themselves. Cut through the 500+ functions, and you’re left with 100 or so truly useful functions and features for the majority of modern knowledge workers. We’ve selected ten from that list which are especially easy to learn (approximately 2 hours total) and which can make a material difference to productivity. These ten are listed in decreasing order of utility from our top 100 list. If, like many, you’re stuck on what to learn next in Excel, you might want to look at this 2×2 matrix, which factors in usefulness and time needed to learn a skill.

Paste Special (10 minutes to learn)
Copy and paste is one of the simplest and most used functions in Excel. But we often carry over a format we don’t want, or we copy a formula over, when instead we just want a value.

These little frustrations can take time to fix, which is why Paste Special is so… special. Paste Special enables you to pick which elements of the copied cell you bring over. After you’ve copied your cell (Ctr+C) hit Ctrl+Alt+V (or go to the Clipboard section of the Home ribbon, or Edit > Paste Special) to bring up Paste Special and make your selection. Alt+E+S+V is the shortcut to just paste values — probably the most common use of Paste Special.

Add Multiple Rows (2 minutes to learn)
We often need to add new rows between existing rows. The shortcut (Ctrl, shift, +) is pretty handy, especially as you can toggle the + to add multiple rows. Often, just highlighting the number of rows you want to add (say 5) and using right click, insert is quicker when adding in bulk as it will add the number of rows you’ve highlighted.

Flash Fill (30 minutes to learn)
Excel developed a mind of its own in 2013 with this feature. Flash Fill automatically fills your data when it senses a pattern.

Suppose you have a list of product numbers in the first ten cells of column A, e.g. ‘ABC-00001’ to ‘ABC-00010’ and you only need the numbers after the ‘-’. You can easily discard the ‘ABC’ using Flash Fill. Pre-2013 this was possible, but relied on a combination of functions (FIND, LEFT, &, etc). Now, this is much faster and will impress people.

Establish the pattern by typing ‘00001’ into the first blank cell. If Flash Fill is turned on (File Options, Advanced) just start to type the next product number in the cell below and Flash Fill will recognize the pattern and fill down the remaining product numbers for you. Just hit the Enter key to accept. Or, get it going manually by clicking Data > Flash Fill, or Ctrl+E.

Flash Fill is like magic, and can be used in many different scenarios. It’s a fantastic time saver when you need to input or change a lot of data quickly and accurately. Flash Fill is a jaw-dropping feature.


INDEX-MATCH (45 minutes to learn)
Aside from VLOOKUP (which looks up the value in one column and returns a corresponding value from another column), INDEX and MATCH are the most widely used and most powerful tools in Excel for performing lookups. Used separately, these functions are invaluable, but it’s when you combine them that their true power is unleashed. INDEX and MATCH used in combination help you extract the data you need from a large dataset efficiently and precisely. Mastering these functions will not only make you look like an Excel whiz to your colleagues and manager, but can make a tedious, mundane task quick and simple. Here’s how these functions work:

VLOOKUP is a great function, but it has its limitations. It can only look up values from left to right. The lookup value must be on the left in the lookup table. INDEX and MATCH allows you to look up a value anywhere in the lookup table regardless of its position.

Let’s say you have a spreadsheet with a list of products. You have columns titled “Product Number”, “Profit”, “Product Name”, and “Revenue”. On another spreadsheet, you have a list of the product names and you want to look up how much profit each product has generated. In this scenario, we are using the product name (our lookup value) to look up the profit. The product name sits to the right of the profit and so VLOOKUP would not work. This is the perfect scenario for INDEX and MATCH.

The syntax would be:

=INDEX(Profit column,MATCH(Lookup

Value,Product Name column,0))

Here’s a good way to remember how it works:

=INDEX (Column I want a return value from, MATCH (My Lookup Value, Column I want to Lookup against, Enter “0” )) (Zero gives you an exact match, you can match against less than (-1) or greater than (1) as well.)

At first and even second glance, INDEX and MATCH looks complex. It certainly needs some practice, but it’s worth getting your head around as it is more flexible and more powerful than a VLOOKUP. It’s one of the most important uses of Excel, period.

SUM (2 minutes to learn)
This is one of the first functions you’re likely to learn in Excel — how to sum a row or column. But did you know you can select the cell at the end of a row or column and press Alt + to do this functions in seconds?

CTRL Z / CTRL Y (1 minutes to learn)
This is your Excel get-out-of-jail-free card. If you aren’t using Ctrl Z to undo mistakes in Excel, then you should be. What many people don’t know is that Ctrl Y does the opposite — redo. The two work in tandem very nicely, and you cycle through iterations of your work until you find the right one.

Remove Duplicates (10 minutes to learn)
This is so simple and quick to use. Remove Duplicates does exactly what you’d expect — it removes the duplicates in any given range of data. Our advice is to remove the values you want to dedupe and place them in another sheet. It’s found on the Data tab in the Data Tools section of the Ribbon.

If you just want to highlight duplicates, you can do this using Conditional Formatting. The shortcut to get you there is Alt H L. (Or find it on the Home ribbon under Styles).


Freeze Panes (15 minutes to learn)
Ever scroll down a large table of data only to forget which columns are which? Freeze Panes is the answer here. You can freeze just the top row, first column or any number of either, just highlight the rows/columns you want to freeze and go to the View tab and Freeze Panes in the Window section. Alt W F is the shortcut.

F4 (10 minutes to learn)
There are two especially satisfying ways to use F4 in Excel. The first is when creating an Absolute Reference: F4 toggles you through the various options. The second is one that few people know about, but could seriously improve your Excel productivity. F4 repeats your last action, where available. For example, if you’ve just applied a border to one cell, use F4 to apply it to others.

CTRL + Arrows (5 minutes to learn)
If you’ve found yourself scrolling through a dataset to reach the bottom of it, stop right now and start using Ctrl + the arrow keys! This simple shortcut takes you straight to the end of the data in a column or row you are using. Combine it with Ctrl, Shift to highlight/select large areas of data in seconds.

Warning: If you have gaps in your data this will just take you down to the first gap. So if you want to get to the bottom fast, choose a column of data which has no gaps.

Harness just a few of these ten items, and you can transform your typical work day. Whether you want to help justify data-driven business decisions at a high level, or simply get home to your family earlier, mastering the right Excel functions is a quick and easy way to maximize your productivity.

Bluesquard Company - Our client, an Insurance company, is currently recruiting suitably qualified candidates to fill the position below:

Job Title: Industrial Attachment Student

Location: Lagos

Job Description
We are currently recruiting for IT Students to function as a support staff in our Administrative department.
Job Responsibilities
Handle administrative request from staff
Develop and maintain a filling system
Book traveling arrangement
Assist in developing periodic administrative report
Qualifications
Ordinary National Diploma in any field
Duration of 1 year Industrial Attachment with a valid IT Letter
Must be smart with good interpersonal skills
Excellent communications skills and good use of Microsoft office is essential
Application Closing Date
11th October, 2018.

How to Apply
Interested and qualified candidates should send their Resume to: careers@bluesquard.com using the role as the subject of the mail.

Bluesquard Company - Our client, an Insurance company, is currently recruiting suitably qualified candidates to fill the position below:

Job Title: Industrial Attachment Student

Location: Lagos

Job Description
We are currently recruiting for IT Students to function as a support staff in our Administrative department.
Job Responsibilities
Handle administrative request from staff
Develop and maintain a filling system
Book traveling arrangement
Assist in developing periodic administrative report
Qualifications
Ordinary National Diploma in any field
Duration of 1 year Industrial Attachment with a valid IT Letter
Must be smart with good interpersonal skills
Excellent communications skills and good use of Microsoft office is essential
Application Closing Date
11th October, 2018.

How to Apply
Interested and qualified candidates should send their Resume to: careers@bluesquard.com using the role as the subject of the mail.

Urgent Vacancy :

Customer Service Executive
Location : Kaduna
Requirements : B.Sc / HND in social sciences or Arts.
Ability to take customer/consumer complaints & report on same.
Cvs to Temi.oyedepo@yahoo.com
Subject : Customer Service

Urgent Vacancy :

Customer Service Executive
Location : Kaduna
Requirements : http://B.Sc / HND in social sciences or Arts.
Ability to take customer/consumer complaints & report on same.
Cvs to Temi.oyedepo@yahoo.com
Subject : Customer Service

A post nysc Medical officer needed for employment in a Private hospital in Kuje Abuja. Accommodation available. If interested, pls send TEXT only, of your name and location to 08061561599 . Salary is open to negotiation with the proprietor/ Medical Director .

Reputable Medical Officer needed urgently in a reputable Hospital in IKEJA. Must be ready to resume immediately after interview.
Added Advantage : Good Administrative Skills. Interested persons send resume to 247nursingandcare@gmail.com or call 09098266432

A Post-NYSC doctor or Dr. awaiting NYSC needed at a private hospital in Aba.
Alt days of the week.9am -6pm for 4-6weeks
Sound clinical skills to make appropriate diagnosis
Ability to write Correct & Adequate Prescriptions
To Resume as soon as possible
08092860380

A doctor needed in Royal clinic off DSC road, Warri ,Delta state.
requirement(surgical skills in C/S,appendectomy, herniorrhapy as well as ultrasound skills)
pay 120k + 10% in surgery+15% in ultrasound scan.
contact
07052657945 for further information

OPEN CALL For NEW FACES!

Date: 20th Oct 2018
Venue: RIJ Studios (Duplex 5, Mabuchi Ultra Modern Market, Jahi Abuja - Nigeria)‎
Time: 10 am - 3pm

REQUIREMENTS:

FEMALE :
• Height: 5'9 ft - 6 ft‎
• Age: ‎15 Yrs - 22 Yrs
• Size: 0 - 6‎

Female Dress Code/Look : Black tang top on blue jean/leggings, comfortable heels‎, hair packed away from the face, no make up and accessories.

MALE : ‎
• Height: 6'1 ft - 6'3 ft‎
‎• Age: 17 Yrs - 24
• Size: Slim and Fit

Male Dress Code/Look : Black round neck polo on blue skinny jean.
Good pair of sneakers, hair cleaning shaved, and no accessories.

NOTE : This OPEN CALL is open only to ‎unsigned and aspiring models. And all aspiring models are expected to come with hard copy head shot and full body length photo of them.

For Sponsorship/Partnership/Inquiries:‎
Tel: +2348036877603 | ‎+2348115969104
Email: enrolemodelmgt@gmail.com‎
Instagram: @enrolemodels
Facebook: facebook.com/enrolemodels
‎
SPONSORS:
• Smile Communications Nigeria (@smilecomsng)
• RIJ Studios (@rijstudios)
• House Of Gents (@houseofgentsnig)

This OPEN CALL is aimed at discovering NEW FACES for our local market (NIGERIA) and the big fashion capitals (NEW YORK, LONDON, PARIS and MILAN)

And it is POWERED By :
ENROLE Model Management

OPEN CALL For NEW FACES!

Date: 20th Oct 2018
Venue: RIJ Studios (Duplex 5, Mabuchi Ultra Modern Market, Jahi Abuja - Nigeria)‎
Time: 10 am - 3pm

REQUIREMENTS:

FEMALE :
• Height: 5'9 ft - 6 ft‎
• Age: ‎15 Yrs - 22 Yrs
• Size: 0 - 6‎

Female Dress Code/Look : Black tang top on blue jean/leggings, comfortable heels‎, hair packed away from the face, no make up and accessories.

MALE : ‎
• Height: 6'1 ft - 6'3 ft‎
‎• Age: 17 Yrs - 24
• Size: Slim and Fit

Male Dress Code/Look : Black round neck polo on blue skinny jean.
Good pair of sneakers, hair cleaning shaved, and no accessories.

NOTE : This OPEN CALL is open only to ‎unsigned and aspiring models. And all aspiring models are expected to come with hard copy head shot and full body length photo of them.

For Sponsorship/Partnership/Inquiries:‎
Tel: +2348036877603 | ‎+2348115969104
Email: enrolemodelmgt@gmail.com‎
Instagram: @enrolemodels
Facebook: facebook.com/enrolemodels
‎
SPONSORS:
• Smile Communications Nigeria (@smilecomsng)
• RIJ Studios (@rijstudios)
• House Of Gents (@houseofgentsnig)

This OPEN CALL is aimed at discovering NEW FACES for our local market (NIGERIA) and the big fashion capitals (NEW YORK, LONDON, PARIS and MILAN)

And it is POWERED By :
ENROLE Model Management

Account Clerk (Female)

Requirements
Candidates should possess OND/
Minimum experience: 1 Years
Additional qualification: AAT

6, Solo Amhaotu Str., Off Eleganza B/sto, Ajao-estate

OK guys! It's official. This is the opportunity you've all been waiting for. Tell every comedian you know to grab this opportunity. Visit www.9jagotcomedy.ng

We are looking forward to having new scouts on board!!! - Location is not a barrier
- Must be 18 years and above
- Must be available to travel
- Must have a good vision for scouting marketable talents
- Communicative and friendly,good sense of humour and vibrant.
- Must be quick in learning about the industry

Apply by sending your CV (bio data) to kamanokompany@gmail.com or contact for further enquiries (+234) 09076705751

Do you have the runway coaching skill or experience?
Or you know a competent catwalk coach (tag him or her)
Send us a mail now at pandfmodels@gmail.com and become the upcoming modelling training season's RUNWAY COACH
P.S attach catwalk video files if any.