Slider

Recent Movies

Health Outcomes Data Communications, Market Access and Contracting Conference Speakers




About The Conference

Now in its fourth iteration, ACI’s Health Outcomes Data Communications, Market Access and Value Based Contracting conference returns with a revised conference agenda geared at providing drug manufacturers, PBMs, plans, and pharmacies with the critical information that they require to navigate the challenges of today, during a time when increased scrutiny exists in the pharmaceutical space.

The program will provide the practical guidance on developing successful strategies to achieve positive formulary determinations, as well as explore how the call for value based contracts over the tradition volume based ones will affect your current contracting models and metrics. In addition, a review of the latest headlines will ensure you remain up-to-date and well informed of the most vital developments in this constantly changing space.
Based on your feedback, new topics have been included on this year’s program to provide you with the knowledge base you need going forward into 2018 and beyond, including dedicated sessions on:

  • Market access challenges seen in oncology, rare diseases, and the development of orphan drugs
  • Effective methods for conducting and presenting cost benefit analysis

  • Current enforcement trends impacting the industry examining the roles of real world evidence and the patient perspective on health outcomes data

  • Strategies for achieving positive results related to formulary determinations



In addition, a renowned diverse faculty of experienced in-house professionals, seasoned outside counsel, and government officials will present these key concepts to ensure you have a wellrounded understanding of the current environment. Built in networking breaks also allow for you to benchmark with colleagues to confirm that best practices are in place.


Conference Date January 22 - 24, 2018
Conference Place Hyatt at the Bellevue, Philadelphia, PA

7th Industry Forum on U.S. Export & Re-Export Compliance For Canadian Operations Speakers

Building on six years of success, American Conference Institute’s 7th Annual Forum on US Export & Re-Export Compliance For Canadian Operations addresses the most critical, pressing U.S. along with Canadian challenges affecting industry with operations in Canada.
The 2018 program has been updated to reflect the latest compliance program implementation challenges, licensing hurdles, enforcement risks and key developments.
New Conference Highlights:
  • First-Hand Dialogue with Global Affairs Canada and the Controlled Goods Directorate
  • BIS and DDTC to Discuss Cloud, Foreign Nationality, Definitions of “Defense Services” and More
  • Latest Best Practices for Strengthening Cyber-security Protocols and Intangible Export Compliance
  • How to Incorporate Evolving U.S. and Canadian Economic Sanctions into Your Program
  • Managing Multi-Jurisdictional Exposure and Coordination Among U.S. and Canadian Agencies
 
Conference Date January 29 - 31 2018
Conference Place Hilton Toronto Airport Hotel & Suites, Toronto, ON

Read more on official website - American Conference Institute
Note: Information reference American Conference Institute

History Of The Excel - Where it came from

In this Article you will learn

  • A Brief History About Spreadsheets.
  • Journey of Spreadsheet ! Evolution of Excel.
  • Why Excel is favourite of Developers.

A Brief History About Spreadsheets.

Spreadsheets have been used by accountants for hundreds of years. Nowadays we all are using Spreadsheet software for calculations ind its easy and quick also. There was really a era where modern spreadsheet were not available, would you able to think, how people are doing their job. This is a really tough task. Back then people relied on clumsy calculators and spend hours  doing what now takes only minutes.



The First Electronic spreadsheet of the history The VisiCalc.

Professor Richard Mattessich pioneered the development of computerised spreadsheets for use in business accounting in 1961. But The world’s first electronic spreadsheet, VisiCalc, was came in to the picture by Dan Bricklin and Bob Frankston in 1978. Back then personal computers are unheard and out of reach of most professionals. Visicalc was developed for the Apple II. But VisiCale was just like nothing if we compare today's standard. VisiCalc essentially laid the foundation for future spreadsheets, and you can still find its row-and-column-based layout and formula syntax in modern spreadsheet products like Microsoft Excel, LibreOffice Calc, Kingsoft Spreadsheet, OpenOffice etc.

VisiCalc Get populer in veri short time, and many forward-looking companies purchased the Apple II for the sole purpose of developing their budgets with VisiCalc. Consequently, VisiCalc is also a pillar for much of the Apple II’s initial success.

In the meantime, another class of personal computers was evolving; these PCs ran the CP/M operating system. Sorcim a US based company developed SuperCalc, which was a spreadsheet that also attracted the companies.

In 1981 IBM personal computers cam into the picture, Both VisiCorp and Sorcim modified with a PC virsion of their softwares. By current Standards both VisiCalc and SuperCalc were extremely clumsy.

  • You cannot increase cell width.
  • If you want to enter lengthy titles, then you have to use multiple cells.
See The Picture of VisiCalc

Nevertheless, the ability to automate the budgeting tedium was enough to lure thousands of accountants from paper ledger sheets to floppy disks.


Next Step of the Journey - Lotus 1-2-3

After the VisiCal Success, Many of the developers are trying to develop a application like this. Few among them Mitch Kapor, Jonathan Sachs and the company designed a new product and launched the software industry’s first
full-fledged marketing blitz. They have advertise every ware for the same.

Specification of Lotus 1-2-3

  • Lotus 1-2-3 improved on all the basics embodied in VisiCalc and SuperCalc.
  • First program to take advantage of the new and unique features found in the powerful 16-bit IBM PC AT
  • 1-2-3 bypassed the DOS calls and wrote text directly to display memory.
  • More Responsive and dynamic.
  • The online help system.
  • Dynamic menu bars, and many more.

Next Step of the Journey - Quattro Pro

Quattro Pro was launched by Borland International. Borland International came into the industry in 1987 with the Quattro Pro. 

Specification of Quattro Pro.

  • Menu system was better then others.
  • Low Cost.
  • Familiar Commands like Lotus 1-2-3.
  • Familiar with Macros.
  • Work In multiple worksheet at a time.
  • Movable and resize able windows.

Final Step The Evolution of Excel

Microsoft was also launched spreadsheet application in 1982 called MultiPlan. MultiPlan was launched for Apple II, Apple III, XENIX, and MS-DOS. MultiPlan essentially ignored existing software user-interface standards. Difficult to learn and use,it never earned much of a following in the United States. Not surprisingly, Lotus 1-2-3 pretty much left MultiPlan in the dust.

Evolution of Excel

Excel Evolved from Multiplan. Excel was a graphics-based program. Microsoft released the first version of Excel for Windows in 1987.
Excel first macro languave enabled 

What is Bitcoin? how to earn free bitcoin in India

What is Bitcoin? how to earn free bitcoin in India

Bitcoin is a virtual currency which has gained popularity over the few the few years. If you are just listen about Bitcoins you may have few questions in your mind like from where Bitcoins come? Where can I get them? Is Bitcoins Legal or not?

In this article, we are going to discuss with you about Bitcoins in detail which will help you to know all about Bitcoins and other cryptocurrencies.

We are going to discuss about the following topics in this series:

What is Bitcoin?
Interesting things about Bitcoins.
Why Bitcoin?
How Bitcoins works?
Value of Bitcoins
Bitcoin Mining
How to buy Bitcoins in India?

So here we go

What is Bitcoin?

Bitcoin is a cryptocurrency and digital payment system. It is the electronic currency and a variety of digital public money. It is the first decentralized digital currency because the system of Bitcoins works without a central repository or single administrator. Bitcoin was invented in 2009 by an unknown person or group under the name of Satoshi Nakamoto.

The Bitcoin system is peer-to-peer and transactions take place between users directly without any intermediary. The transactions are verified by network nodes and recorded in a public distributed ledger called blockchain

How to pay credit cards bill using Paytm Wallet

Now you can pay credit cards bills on PayTm.

To reading this article in Hindi click here हिंदी में इस लेख को पढ़ने के लिए यहां क्लिक करें
pay credit card bills on paytm.

As of now you can pay bills for mobile, electricity, landline, fees, metro, DTH, Cable Tv Etc. using PayTm. Now they are planning to provide the credit card bill payment facility from Paytm wallet soon. The Option will look like as below:



How to pay credit cards bill using Paytm Wallet

They have already launched for IndusInd bank credit card. 

See the picture below or you can Check here 

How to pay credit cards bill using Paytm Wallet


I also had a word with Paytm Customer Care Representatives (call reference numbers: 47044840 and 47046031) for the same and they told me that company is working on this. Probably they will launch this facility for all banks soon.

PayTm is the largest wallet in the India. Paytm is biggest e-payments and eCommerce brand in India.  Launched in august 2010. Paytm’s parent company is One97 Communications. PayTm is acronym for "Payment Through Mobile". 

I my opinion this will be the great breakthrough for Paytm.

I am waiting to see this facility in paytm. Are you?

Please comment is if you are waiting for this option. Also you can share this article with your friends, have a grad day.


How to use V-Lookup, V Lookup Examples and uses method

If you are working on excel on huge data in you office, school or collage you must know the uses of VLookup. when we talk about data lookups, V lookup is a initial part of the same. Please go through the full article for your better understanding. Must watch the video also.

1. What is V lookup?
Ans. V lookup is a lookup function.

2. What are limitation of v lookup?
Ans. V lookup only match data left to right.

3. What we need for the Function?
Ans. 2 data sets with one unique column.

Here is the example of V lookup Function:-

1. If you are going to use v lookup you must have 2 data sets. as i mentioned below.

vlookup example

In above image you are able to see that we are looking for sales in data 2. So We have employee id in common so we can use vlookup here.

2. See the formula here:


Article writing competition - write and win up to 1000 INR


This article is intended to inform you that we are organizing a Article writing completion for all amateur bloggers. This contest is taken place to motivate to share your thoughts, experiences, knowledge. No matter how good you are in writing or how your article is. Let’s express your words and get prizes to and let the world decide about your writing skills, presentation and your idea. We will appreciate you with exciting prices, certificates.


    Register Here





Prizes and appreciations

This contest have lots of exiting prices and appreciation for all the Participants. Please find below:
  • First prize - (A) 500 INR Paytm Cash. (B) Free entry for next Mega Contest. (C) A Appreciation certificate from The independent Leaning.
  • Second Prize - (A) 300 INR Paytm Cash. (B) Free entry for next Mega Contest. (C) A Appreciation certificate from The independent Leaning.
  • Third Prize - (A) 300 INR Paytm Cash. (B) Free entry for next Mega Contest. (C) A Appreciation certificate from The independent Leaning.
  • Complementary Prizes - All participants will be awarded by a certain PayTm cash bonuses.*
Other benefits
  • INR 20 PayTm Cash for first 15 participants.
  • Certificate of participation and complementary prizes for all participants.
  • Blogging related tips and for all participants.
  • Basic excel classes for all participants.
   

       Register Here

If you are interested in participating in this article writing competition please read the FAQs below.


Q1. How can i participate?

Ans. if you have not any idea about blogger you can simply write your article on a word document and submit to us via email. we will publish behalf of you.
If you are a blogger and you have the idea about how to write the posts on blog-spot then you can simply register here and we will provide you login id and password and you can easily access the page where you write.


Q1. Who can participate?

Ans. Anyone. From any country.

Q2. What type of articles are required?

Ans. This contest is open for any type of content. Read the points below:
a. A good post must have minimum 800 words, and minimum a picture. 
b. Not any adult only content or fake news. 
c. All information source will be trust worthy to avoid legal actions. 
d. Try to come up with your own idea. 
e. You can write a story, your travel experience, any article related to technology, mythology, Science fiction etc.

Q3. What is the procedure to decide the winners?

Ans. Your articles will be shared on social media. We are not only the person that decide which article is the best one. We will track how much people are liking your content and sharing on social media. Article with maximum engagements will win the contest.

See the details below:
a. 1 click on social media share**  = 2 Votes
b. 1 comment on the Article***     = 1 Vote
c. 1 Unique page view                   = 1 Vote


Read below for few idea that will help you to win this contest.

Of course a good article will attract more visitors, but you can share a modified link with help us to track/count engagements. You can share your article to Whatsapp, Facebook, Twitter, Google+ and other all social media platform to get more visitor to your post. You can ask your friends to read your article and support you. You can also ask them to share your article to social media.

In-short only writing the good post will not let you win you need to market it very well also.

   Register Here




"Please share only the link which provided by us. Unless we will not able to track exact engagements with your social media shares and it will not good for participation."


You can write us at   info.indelearning@gmail.com

*Any article less then 100 views will not awarded by any prizes.
**Please do not try to click by yourself because is will be tracked and your  participation will be terminated.
***We will count only 2 comments per unique reader.

Note:- Please avoid spamming. 

Hack Your WhatsApp - Download anyone's Video status

Hi everyone welcome, I am here with all new cool information. Read this article carefully, I am sure you will not be disappointed.



We all know that WhatsApp has recently updated and now allowing to share Stories/Statuses. The Stories/Statuses are automatically vanished after 24 hours. 
We all saw few really inspiring, heart touching or funny Video/Gifs Statuses/Stories from our contacts on daily basis.

What If we really likes the Stories/Statuses and wish to save, we cannot do the same because simple WhatsApp has not the download feature for Stories/Statuses.

However, for images we can take screenshots but what is the solution for GIF and Video files? We cannot save that in our phone storage.

But I have the solution for this problem.

Now you can download anyone’s WhatsApp status. Images as well as Video statuses also.

Please follow the below mentioned steps:


With simple WhatsApp Application it’s not possible. You need to download Whatsapp mod application “YoWhatsApp”.


Important Points: 

You can text between WhatApp and YoWhatsApp without any problem. Both party don’t need the installing the same application.
In short you can exchange chats and use all simple Whatsapp features between WhatsApp and YoWhataApp.




Please click below mentioned link to go to download page.




  • After downloading please follow the simple steps, asked by application during installation, its will be almost similar to normal WhatsApp installation method.
  • After installing successfully you can use YoWhatsApp as normal version of WhatsApp.
  • Now you are ready to download anyone's Statues/Stories. if you need to download any ones status updates just watch that. 
  • At the time you will watching you will be able to see a Down Arrow Bottom-Right Corner of the screen. You just need to touch it and your status will be saved in your file manager in the folder “YoWhatsapp Statues”

See Picture below
WhatsAppStatusDownload
WhatsApp_Status_Download

You can also download videos and images statuses by the same way.






I Hope you liked the information. Please share with your friends and appreciate my work.

Other features of YoWhatsApp:

  1. Increase limit videos to GIF, up to 30 Seconds.
  2. You can change themes.
  3. Customs privacy settings.
  4. Change contact name color in home screen.
  5. Disable calls option for a single contact.
Please visit YoWhatApp official site for any other information. click here





HOW TO GET LIVE CRICKET SCORE ON EXCEL SHEET ???



Hello friends I am  Neeraj Kumar, Welcome to the Independent learning- Excel Classes.

And today we are going to learn that how can we create an automated cricket scorecard in our Excel File. Please follow the below mentioned steps carefully to get it.



Cricket score in excel

How get live cricket score on our excel sheet

1.  Firstly open your excel sheet and click Data tab like mention below screenshot.



2.    Click From Web Tab



3. Copy website URL Where do you take data from any cricket live score website.
     and pest open tap then press go.

     if you have receive any script error popup like mention screenshot press yes all time


4. Click yellow box.





5.  After click yellow box , box color change in green.



6. Click Import button



7. Select Range where you want get score.



8. After import data you get cricket score on your excel sheet.




9.  If you want score update automatic then press Data tab  then connection tab.like mention as              screenshot.





10. After open Dialog Box Click Properties tab




11. Click Refresh Every and fill minute As you wish.  





Thank you for your time. I hope it will help you to learn Excel tricks. Stay tuned for more cool excel tricks. Click here to watch excel training videos. Share if you have liked it.

You can submit your queries us at info.indelearning@gmail.com

                                   ----:The End:----






Advanced Excel Course - Paste Special in Excel 2013

Hello friends welcome to The independent Learning. Today we will learn about Paste Special. As we already know how to use Cut, Copy and Paste in previous lesson. 

Excel Basics 101 - Uses of Cut, Copy and Paste in Excel 2013

Excel basics course class one!

About the course: This course is designed for MS Excel Beginners, we will cover each basic functions and formulas in this course. After completing this course you will be able to do basic work on MS Excel. You will also able to recognize requirements of formulas and function in practical and daily work.

I know you are waiting for this course since long time, i am sorry for the delay. Now onward i will share a lesson daily. Thanks for your support. The course will go on and we learn complete MS Excel Basics. we will learn about all tabs of  Excel. stay tuned with and ask more so i can full-fill your requirements. In this class i will let you know about the following:

1) Copy
2) Cut
3) Paste

Please watch the video to learn this lesson in Hindi.

Descriptions

1) Copy :  This option allows you to copy content that is already entered into your sheets/workbooks and paste that content to other cells/sheets/workbooks, which can save you time and effort. See example

(a) Select the cell/cells you want to copy:









(b) Go to Home tab then select Copy or press CTRL + C keyboard or right mouse click and click on copy as shown in picture:










(c) Select the cell(s) where you want to paste the content. The copied cells will now have a dashed box around them, see picture below:









(d)  Click the Paste command on the Home tab, or press Ctrl+V on your keyboard. See image below:









(e) And you will be able to see the result and data has been copied . See images below:









2) Cut  :   Unlike copying and pasting, which duplicates cell content, cutting allows you to move content between cells. In simple words when to Cut, you move the data location. See below.
(a) Select the cell(s) you want to cut. as you selected when to tried to copy.
(b) Go to Home tab then select Cut or press CTRL + X keyboard or right mouse click and click on Cut as shown in picture:















(c) Select the cell(s) where you want to paste the content. The Cuted cells will now have a dashed box around them. see picture below:
(d)  Click the Paste command on the Home tab, or press Ctrl+V on your keyboard. See image below:













(e) And you will be able to see the result and data has been moved to new location. See images below:














2) Paste  : As we already used pastes option in above examples. There is nothing much in simple Paste. We will learn about Paste Special in next tutorials.


Thank you so much for your support. Stay tuned for next class as it will be shared soon. Please do share if you loves this and please let me know about your requirements, I will try to get that fulfilled. I always try to bring best topics for you as no one is perfect so your suggestion are welcome. 

If any one want write something and seeking for platforms, please let me know it will be great pleasure to help you. 

Conditional Formatting 101

How to use CountA function In Conditional Formatting.


Hi friends please go through the you tube video for the full session. it is quick and easy.
in this video you will able to learn how to highlight certain cells using conditional formatting


Please don't forget to subscribe the YouTube channel.
 
Copyright © 2015. DubbedInHindi