Tuesday, June 19, 2012

Nhờ giải thích giúp chỉ tiêu hiện giá trong dự án đầu tư

Nhờ giải thích giúp chỉ tiêu hiện giá trong dự án đầu tư


Nhờ giải thích giúp chỉ tiêu hiện giá trong dự án đầu tư

Posted: 19 Jun 2012 01:01 AM PDT

Nhờ giải thích giúp chỉ tiêu hiện giá trong dự án đầu tư


Nhờ giải thích giúp chỉ tiêu hiện giá trong dự án đầu tư

Posted: 18 Jun 2012 07:39 PM PDT

Chào các anh chị,
em có một bảng nghiên cứu tính khả thi của dự án đầu tư,
nhưng em đọc các tài liệu mãi không hiểu cái chỉ tiêu hiện giá được tính như thế nào,ý nghĩa của nó?em nhờ các các bậc tiền bối chỉ giáo giúp em với ạ,
em xin chân thành cảm ơn
file em gửi kèm vào đây,chỉ tiêu hiện giá em đánh giấu màu vàng ạ
Tập tin đính kèm

Thủ thuật vi tính - Thuthuatso.com

Posted: 18 Jun 2012 11:14 PM PDT

Thủ thuật vi tính - Thuthuatso.com


Wallpaper mang sắc màu thiên nhiên lên desktop của bạn

Posted: 18 Jun 2012 04:17 PM PDT

Hôm nay thuthuatso.com cùng chia sẻ với các bạn một bộ wallpaper thiên nhiên tuyệt đẹp. Hy vọng nó sẽ mang đến cảm giác dẽ chịu khi nhìn vào màn hình máy tính của mình. Các bạn có thể tải … Đọc tiếp

Cần giúp đỡ làm Excel về tuổi

Posted: 18 Jun 2012 11:23 AM PDT

Excel

Cần giúp đỡ làm Excel về tuổi


Cần giúp đỡ làm Excel về tuổi

Posted: 18 Jun 2012 04:07 AM PDT

Em đang bắt đầu học về CNTT năm đầu ĐH và mới học về phần hàm tuy nhiên do chương trình học gấp quá giáo viên không hướng dẫn gì về mục hàm cả nên có 1 số bài tập có sử dụng các hàm và cách ghép hàm mà em không biết mong các bác chỉ giùm. Bài này về tính tuổi. Em đã lập công thức theo hàm sau: YEAR(TODAY())-YEAR(ô năm sinh) nhưng không được ma nó ra kết quả loạn hết ra. Ai biết chỉ giùm.
Tập tin đính kèm

Tính tổng các số đứng trước chữ cái?

Posted: 18 Jun 2012 01:30 AM PDT

Mình có 1 biểu thức mà giá trị các cột gồm số và chữ cái (ví dụ 5AB, 1.5BC, ...) mình muốn tính tổng của các số (chia ra nhóm AB, BC) mà chưa có cách nào cả . Nhờ các bạn trong diễn đàn hỗ trợ giúp mình với nhé.
Vui lòng xem chi tiết trong file kèm theo.
Cảm ơn các bạn.
Tập tin đính kèm

Dò tìm dữ liệu không liên tục, nhưng có cấu trúc

Posted: 17 Jun 2012 10:27 PM PDT

Phần mềm xuất ra Time Card từ cột A - L tùy vào số lượng nhân viên, thường là trên 2000 nhân viên.
Em cần dò tìm giờ vào và ra cho từng nhân viên (giờ vào là IN của MORNING, ra là ô có dữ liệu cuối cùng trong dãy từ B đến G, VD: ngày 1 cho nhân viên 500001 là E6, ngày 3 là D3)
Với ngày tùy ý vào ô P1, một cách tổng quát và tối ưu (để dùng lại cho tháng sau, dữ liệu nhiều nên cần nhanh)
Em đã làm được như trong file đính kèm, nhưng vẫn chưa tổng quát, vì phần out không làm được một cách tổng quát.
Xin các anh chị giúp em công thức cho phần out, và xem lại các phần trước như vậy đã tối ưu chưa? Còn cách nào nhanh hơn nữa không?
Tập tin đính kèm

Em cần dùng hàm Excel để điền giá trị vào các bảng mà em ko biết làm!

Posted: 17 Jun 2012 10:57 AM PDT

Tình hình là E có bảng KQ cần điền giá trị bằng các hàm mà em lại ko biết cách làm.Anh chị em nào biết thì giúp em với ạ.E cảm ơn nhiều!
Bảng và chi tiết yêu cầu em gửi kèm theo rồi đấy ạ!
Tập tin đính kèm

Các bác cho em hỏi hàm sumif trường hợp của em??

Posted: 16 Jun 2012 08:40 PM PDT

Trong bài tập này em có 1 sheet Chi tiết doanh thu và 1 sheet Mã Khách hàng, mã dịch vụ, mã đơn vị
Em đã lập sheet Tổng hợp Doanh Thu (TH DT) nhưng không biết cách dò tìm theo hàng tháng thì sẽ sử dụng hàm như thế nào và trong Sheet Chi tiet doanh thu phải thêm cột gì??
Trong Sheet TH DT ĐV (Tổng hợp doanh thu theo đơn vị) yêu cầu đặt ra là ở cột Mã ĐV chỉ cần đánh mã vào sẽ nhảy ra số liệu tương ứng.
Các Bác giúp em với.
Em xin chân thành cảm ơn kết hợp với hậu tạ ^^
Tập tin đính kèm

Tịnh tiến ô dữ liệu trong công thức

Posted: 16 Jun 2012 08:36 PM PDT

Các bác chỉ giùm em cái này với (em nhớ là có thì phải-nhưng không rõ tên hàm): em đang có công thức thế này
=SUMIF($C$82:$C$90,$P48,$E$82:$E$90)
em muốn là cái range màu đỏ sẽ nhày 2 cột so với range màu xanh.
vẫn sử dụng giá trị $.
cảm ơn cả nhà.

Giúp mình giải đề thi với

Posted: 16 Jun 2012 09:10 AM PDT

Các bạn giải giúp mình đề thi này tí mài mò hoài ko được , mai thi rồi ..
Tập tin đính kèm

Về hàm vlookup

Posted: 16 Jun 2012 02:24 AM PDT

Xin chào ACE trên diễn đàn !
Tôi dùng hàm vlookup để tìm dữ liệu ở sheet bên cạnh để điền vào bảng nhưng bị lội #N/A.
Xin nhờ mọi người giúp đỡ để khắc phục lỗi này. Tôi xin gửi file kèm theo. Xin cảm ơn mọi người !
Tập tin đính kèm

Cần các cao thủ giúp đỡ về bộ lọc Filter

Posted: 15 Jun 2012 07:47 PM PDT

Em có 1 cái bảng Tính Exel chuyên về bộ lọc filter chỉ dùng filter thôi
em làm bằng tay thì được. nhưng bây giờ phải đặt công thức
Các bác đọc kỹ giúp em nhé. từ bảng 1 bảng ban đầu với yêu ầu của bảng 2 và hiện ra bảng cuối cùng ần làm
Làm ơn giúp em với nhé các pro
Pro nào làm được cho em xin liên hệ





Tu van luat, dang ky kinh doanh, dich vu ke toan, ke khai thue, ve may bay,luật doanh nghiệp, SEO top 10 Google, thành lập công ty, đăng ký thương hiệu

Tự động lọc dữ liệu

Posted: 15 Jun 2012 06:35 PM PDT

các bác giúp e với, em đang làm một file nhưng chưa ra, e xin trình bày chỗ e chưa làm đc như sau:
Cột B tại sheet1 link với cột C sheet2 (Có chứa Danh sách tên các loại thuốc rất khó viết đúng).
Cột B sheet1 là cột nhập tên thuốc có chứa trong cột C sheet2, em muốn nhập tên vào cột B mà chỉ cần gõ vài chữ cái đầu excel sẽ lọc trong cột C2 sheet2 và hiện ra list tên chứa những chữ cái cho mình chọn để khi dùng hàm tìm kiếm link đến cột B sheet1 thì mới đc. mong các bác giúp đỡ!

Cần giúp đỡ: Hàm tìm giá trị ngẫu nhiên giữa hai giá trị cho số lẽ

Posted: 15 Jun 2012 02:14 AM PDT

Chào các anh chị. Em muốn tìm giá trị ngẫu nhiên từ 0 đến 5 mà cho kết quả không phải là số nguyên thì dùng hàm gì.
Em dùng hàm Rand nhưng cho kết quả là số nguyên.

Ví dụ: Giá trị ngẫu nhiên giữa 0 đến 5 cho giá trị là: 0,6; 1,2; 2,7; 3,4; 4,8 ....

Chân thành cảm ơn.

E muốn hỏi về các hàm thường sử dụng cho công việc nhân viên thống kê thu chi xưởng?

Posted: 14 Jun 2012 10:50 PM PDT

Chào các bạn , mình là mem mới , mình chuẩn bị xin việc vào vị trí Nhân viên thống kê Xưởng ( Xưởng may )
Vậy bạn nào hoặc có kinh nghiệm vào vị trí tương tự xin cho mình hỏi làm ở vị trí này thì những hàm thường sử dụng là những hàm nào?
Nếu có bài tập cụ thể thì có thể cho mình luôn với.
Cám ơn mọi ng ^^.
Rất mong đc mọi ng giúp đỡ :x

[Giúp Đỡ] SUMPRODUCT nhưng trong cột chứa ký tự char(32)

Posted: 14 Jun 2012 10:06 PM PDT

như tiêu đề e nói và có bác đã sửa lỗi này nhưng có điều e hỏi là làm sao biết trong cột chứa ký tự char(32) và bác đó bảo dùng Replace nhưng e k hiểu ký tự char(32) là gì và sao Replace các bác có thể nói rõ giúp e được k
Tập tin đính kèm

Xin chào mọi người

Posted: 14 Jun 2012 08:43 PM PDT

Nhờ các cao thủ giúp em cách lấy dữ liệu tự động từ các file con sang 1 file tổng. Em gửi file đính kèm luôn.
Thanks!
Tập tin đính kèm

Giúp mình bài sử dụng Hlookup, Vlookup, Match, Index với

Posted: 14 Jun 2012 08:21 PM PDT

Mọi người giải giúp mình với. mình làm cái Hlookup thì được mà làm Vlookup thì toàn bị lỗi thôi. Nhớ là dùng 4 hàm trên nha. Tks mọi người nhiều!
Tập tin đính kèm

Giúp em vẽ biểu đồ 3D theo kiểu này với!

Posted: 18 Jun 2012 09:49 AM PDT

Giúp em vẽ biểu đồ 3D theo kiểu này với!


Giúp em vẽ biểu đồ 3D theo kiểu này với!

Posted: 17 Jun 2012 11:34 PM PDT

Dear all,
Em muốn vẽ biểu đồ 3D như hình đính kèm. Em cũng đã thử vẽ nhưng không ra được hình như này. Vậy các anh/chị cho em hỏi có thể vẽ được biểu đồ như thế này trên excel không? Nếu được, các anh chị vui lòng chỉ cho em cách vẽ với ạ. Em xin cảm ơn!
-\\/.
Hình đính kèm

Here's Why World Of Warcraft More Than Just A Game And Helps Minds Grow!

Posted: 18 Jun 2012 08:35 AM PDT

Here's Why World Of Warcraft More Than Just A Game And Helps Minds Grow!


by Michael Kelley


Imagine living in and exploring one of the most epic, fantasies of all time, a visually beautiful world, that is also filled with highly entertaining music, endless fun things to do, friends waiting on you to travel with, and incredible rewards. World of Warcraft is that world. If you haven't tried it you should. There are many ways to play "WoW' (an acronym for World Of Warcraft) so that the game becomes entirely the best entertainment more and more specific to you.

Do you like to be social? Join a high powered guild and align yourself with the powers of the realm to compete for top positions and treasures from epic raids, heroic dungeons and events. Do you like to be a lone wolf? You can take on endless cool challenges, monsters and dungeons. Like to make and sell powerful items, magic potions, scrolls, weapons etc.? You become the person players will respect and want to meet.

Master professions and help other players succeed and you will grow in wealth and reputation. You can sell your products in one of many auction houses that are filled with players always looking for good deals. Some players that have mastered World Of Warcraft auction houses have been able to use this skill on to places like E bay and made real money!

If you crave a true challenge you can enter into arenas or places called battlegrounds and fight other players. Nothing is more challenging than outwitting other thinking people. You can earn fantastic in game prizes from Blizzard (the creator of the game) and some of the top players earn thousands of dollars as experts helping other players achieve rankings. PVP as it is called (player versus player) is very exciting to watch and participate in and you can actually become a living legend, earn honor points that can be used to purchase better combat gear, achievements as well as titles that will make you the envy of many gamers.

World Of Warcraft is also about a great way to just relax as you enter into another an incredible world and get the chance to "vacation away" from your real life. Become a completely different person and your avatar explores the world of WoW which is filled with epic scenery. This is a great way to get a break from your own reality and just enjoy incredible artwork, cool music and ever increasing challenges.

Explore Elvish woods filled with sing song music where the mystics and Ancients once walked the earth. See the ruins of once powerful civilizations that are long gone. Witness the clash of the titanic, epic struggles and play a part in the best storyline in fantasy. So what are you waiting for? Real life can be dull. Play World Of Warcraft and you will find that you will be happier having a true hobby and more fulfilled. Have fun checking out this incredible game. We would be glad to help you learn the ropes and master the game!




About the Author:





You are receiving this because you signed up for it on 2012-06-06 from IP 222.254.146.95


To fine-tune your selection of which articles to receive, just login here
using your username:


To unsubscribe please use the following link:

Unsubscribe



Is Your MLM Leads List Exploding?

Posted: 18 Jun 2012 07:37 AM PDT

Is Your MLM Leads List Exploding?


by Steven Suchar


If you're serious about building a moneymaking network marketing business, then it is important to appreciate that leads are the name of the game. The person who acquires or generates the largest mlm leads list and finds a technique to effectively contact them, wins.

Taking your business to the next level is a simple matter of connecting with people, directing them to a product or business opportunity display and following up to gather a decision, either they're in or they move on.

The challenge starts in the contacting phase. We connect to folks we all know and we connect to folks we do not know. Employing a fresh mlm leads list is the best, most powerful way to connect with folks we do not know. It becomes more crucial when you begin to run straight out of warm marketing contacts.

Here are a few ideas regarding how to get your hands on a good mlm leads list. In a nutshell, you can buy them or you can construct your own. There are significant benefits and drawbacks to both approaches, so let's chat about that.

The hidden key to building any rewarding mlm business is to discover a technique to get your name, product and home based business opportunity in front of the people who are actively looking to start a brand new business, on a consistent and regular basis.

The swiftest, most straightforward way to manifest a mlm leads list is to buy business venture searcher leads from an internet lead broker. The quality of these possible customers will range seriously relying totally on the way the contact information was generated.

The least qualified leads are those collected by a co-registration opt out process. This implies the potential prospect was presented with twelve small classified ads, all preselected, with a note to unselect those offers they are not fascinated by receiving more information about.

Sadly, many people don't read the instructions and ignorantly now, are put on a mlm leads list. They really had little interest in learning anything further.

The most qualified are folks who have visited a web site, completed a long form survey that asks them specifically pointed questions about their wish to start a home based business. Time they have available every week to build their business and the quantity of capital available to start. These prospects are then phone confirmed by a live operator in regards to their motivation and ability to afford and start their own business.

The highest quality mlm leads list you can assemble are those you have generated yourself by writing, distributing and promoting informative articles, blog entries, and videos that talk about your specific product, niche and industry. Folks who inquire and respond to this info, in a sense, are pre qualifying themselves to be at least enthusiastic about your type of products, niche selling and opportunity.




About the Author:





You are receiving this because you signed up for it on 2012-06-06 from IP 222.254.146.95


To fine-tune your selection of which articles to receive, just login here
using your username:


To unsubscribe please use the following link:

Unsubscribe



Make Funds With Particular Niche Advertising

Posted: 18 Jun 2012 07:31 AM PDT

Make Funds With Particular Niche Advertising


by Dollie Jarret


Particular niche marketing is something that I really love. I have actually had lots of excellent experiences with structure profitable websites.

Nevertheless, I have actually even had numerous failures also. In this article, I will certainly clarify the fundamentals of developing quality specific niche sites. Here is exactly what you require to concentrate on:

1. Material is master. I'm certain you've heard this in the past. In fact, this expression has actually been overused for lots of years.

The issue is that lots of folks do not understand ways to make the finest content for their internet sites. And without quality, one-of-a-kind content, you can easily not also intend to succeed with this procedure.

The very best means to produce quality content for your websites is to produce it yourself. Ensure to place in your 2 cents about your topic.

Making use of other people's content is a rapid means to fail with search engine optimization. The search engines like material that appears natural. So create your own posts with your own point of views in them.

2. Focus on the inexpensive competitors markets. If you desire to prosper with particular niche advertising, you require to concentrate more of your energy and time on smaller sized markets that are still rewarding.

In order for them to be profitable, there requires to be a need for the product or service you are promoting.

3. Making use of the appropriate keywords is crucial for success. Keywords that are high in search volume and reasonable in competitors are the ones you need to focus on. Be positive to never ever over optimize your web pages.

With the new algorithm updates that Google has actually put into spot, you ought to simply feature your target keyword once in the whole article. Be sure to include it in your title tag too.

4 Avoid using to lots of affiliate links. Google does not like to see an internet site that has dozens of affiliate links on it. A really good formula to follow would certainly be 2 affiliate links per page.

5. The moment you have your niche website up and running, you require to concentrate on facility links to your website. Google likes to see links pertaining to your website in a natural pattern.

This suggests that you ought to never ever build links quickly. Instead, you ought to concentrate on structure regular links over time. There is no secret to doing this.

Merely be certain to construct links over the next few months that your site is live on the internet. Avoid dishonest link structure methods. These are not going to help you in the long run.

By the method, do you would like to learn precisely how to construct specific niche sites that produce free of charge traffic from Google and income every month?




About the Author:





You are receiving this because you signed up for it on 2012-06-06 from IP 222.254.146.95


To fine-tune your selection of which articles to receive, just login here
using your username:


To unsubscribe please use the following link:

Unsubscribe



How to Determine the Right SEO Strategy for Your Internet Site Promotion

Posted: 18 Jun 2012 07:21 AM PDT

How to Determine the Right SEO Strategy for Your Internet Site Promotion


by David Dischler


In the wake of the current process updates by Google, web-masters around the planet are dashing to wash their internet sites of any potential elements that might endanger their internet presence or Google rankings. All of a sudden, the web-masters have woken up to the significance of moral SEO practices, leaving nada to chances. In this context, it's vital for the new webmasters to learn how to approach the internet site optimization to gain tolerable visibility for their web sites.

First of all, you have got to understand the constituents of the ultimate SEO mix. Though Google doesn't have anything laid out in explicit terms about the way the webmasters should approach their site promotion, it still is believed Google tends to like internet sites that are meant to help users and not confuse or trap them. For instance, if a user lands on your website and gets confused with your bewildering navigational links, it'd upset Google big time.

The only real way to approach your internet site promotion is to design a campaign or your method in a way that combines accessible content with a great design that makes it straightforward for your visitors to navigate through your site. If the visitors find your internet site an excellent spot to hang around for their informational needs, possibilities are Google will like it too.

Before approaching the online promotion for your internet site, it is important to ensure the internet site is meant to help your users. Factors like navigational structure, quality information and internal links could play a big role in the success of your campaign.

You don't need to promote a badly-designed web site to your users and then risk Google's wrath. Therefore, consult an SEO agency to cross-check your website before inventing a tough promotional system for your business.




About the Author:





You are receiving this because you signed up for it on 2012-06-06 from IP 222.254.146.95


To fine-tune your selection of which articles to receive, just login here
using your username:


To unsubscribe please use the following link:

Unsubscribe



Strategies about how Starting A Multi Level Markeing Blog Can easily Grow Your Home Business?

Posted: 18 Jun 2012 06:42 AM PDT

Strategies about how Starting A Multi Level Markeing Blog Can easily Grow Your Home Business?


by Robin Marks


If you find yourself thinking about starting a network marketing blog, all I can say is do not be reluctant and just do it! I started my blog about a year ago and it has become a really valuable resource in which at this time I am unable to see myself without. You are only able to do so much with the multi level marketing company replicated web-site. With regards to growing ones own home business there are plenty of rewards of beginning your very own blog. Read about a few of the most important reasons.

Your personal Multilevel Marketing Blog Is Your Personal On line Real Estate

If you are a network marketer there exists a good chance that you've a company replicated web page along with information regarding your home based business. But what about you? People join people they don't really join businesses. You should have a place in which prospects can go to learn more about you. You mlm blog would be the starting place in terms of growing relationships with your potential clients. I use social network marketing to connect with clients about my talk fusion business.

Attract New Prospective clients And Quality Leads

Having a home business blog give you countless marketing possibilities to generate quality potential clients and targeted leads using the internet. You can do such things as posting videos and articles to the blog that generate leads for you as long as you have optimized this content correctly.

It's A Place In Which You Get Website Traffic And Leads From Search Engines

The first place people utilize when they are looking for answers is Search engines. Imagine finding the content of your blog on the very first page of google whenever someone looks for some thing. This is quite possible with for those who start a blog.

By having a multi-level marketing blog you're situated to get search traffic and leads from targeted prospective buyers whenever they turn to the online market place for answers. You do this by updating your blog with the type of content that you know your target market is are looking for the answer to online. This can be home business companies review or different types of online mlm training.

Out of this targeted site traffic you get from the engines like google you can generate high quality leads everyday for your small business. These kind of prospects are superior to any leads that one could ever purchase on the internet.

Post Your Personal Marketing Team Training

If you have been in multi level marketing any amount of time you understand that training is very important. By having a blog you can now post content to train and motivate you team. Things like best numbers to use for 3 way calls or how to host a PBR are all good things that can train your team and and give them what they need to achieve success.

Hopefully this gives you several powerful reasons to start your own mlm marketing blog right now.




About the Author:





You are receiving this because you signed up for it on 2012-06-06 from IP 222.254.146.95


To fine-tune your selection of which articles to receive, just login here
using your username:


To unsubscribe please use the following link:

Unsubscribe



Are You Marketing On Facebook Correctly?

Posted: 18 Jun 2012 04:21 AM PDT

Are You Marketing On Facebook Correctly?


by Steven Suchar


Facebook has become an arena of its own online and marketing on Facebook is critical these days.

The place where we could find lost friends and communicate simply with our favorite folks and see footage of our favorite stars has changed a lot since it started. Facebook has turned into a giant mall, like it or don't like it, there are huge chances for every online marketing business on Facebook with 700 million potential customers.

Marketing on Facebook is serious stuff and there are numerous tips and tricks for gaining traffic and funneling it through to your internet site to make money. You can do this by participating in Facebook groups and creating a page for your business and you can also pay to advertise to closely targeted demographic groups.

Don't believe that the only people on Facebook are bored teenagers, that is not the case. Increasingly large numbers of older people are using Facebook for any quantity of reasons. Though shopping would possibly not be their primary reason, many folks who use Facebook are starting to use it just like they might the web in general for help and info. Do not forget to open a page for your Facebook business not a profile. If you do you'll be violating Facebook's terms of service.

Selling your business via a social media platform like Facebook needs a larger post than I am able to offer here and Facebook is constantly updating and changing its rules. The essence of any social media is being companionable, so it is a methodology where you'll be continually engaged with your fans, answering questions and posting engaging and useful content. Use your company logo if you have one so that your product is distinguishable. If you're an associate or niche marketing expert, use a huge image of you looking appropriate to your business. If you sell surfboards you don't have to wear a suit, perhaps a wetsuit.

First impressions are very important, just imagine you are at a gigantic party full of vital folks. You present yourself well and interact as much as practical to win new buddies, in this situation, fans. You may share information with them by uploading footage, videos, status updates, hosting discussions and displaying wall posts. Pages are apparent to everyone on the web and are often better for long-term relationships with your fans, readers or patrons. Facebook events will help you connect with your audience and invite them to your events, even if they are not one of your fans.

Just like a domain, you have to keep adding articles or posts to keep your fans attention. It is a great place for folks to ask questions about your product and post testimonials. You may find, once your website has reached a specific number of visitors it may be tough to keep under control. You need to answer your fans questions in a timely manner but you do not want to be on your Facebook page 24 hours per day, which can simply happen as you'll have fans from all over the world. Use different pages to aim at different demographics. You can run contests, polls and reward your most loyal adherents also. It is a huge subject, but do not delay, start building your fan base right away by promoting on Facebook.




About the Author:





You are receiving this because you signed up for it on 2012-06-06 from IP 222.254.146.95


To fine-tune your selection of which articles to receive, just login here
using your username:


To unsubscribe please use the following link:

Unsubscribe



No comments:

Post a Comment

IT và cuộc sống