Something More for Research

Explorer of Research in Information Technology

  • Blog Stats

    • 31,712 hits
  • Subscribe

  • Enter your email address to follow this blog and receive notifications of new posts by email.

    Join 2,972 other followers

  • Calendar

    August 2014
    M T W T F S S
    « Jul    
     123
    45678910
    11121314151617
    18192021222324
    25262728293031
  • Goodreads

  • Spam Blocked

  • Pages

  • Blogs I Follow

  • Categories

VISUAL STUDIO 2012 ADD-IN FOR QT5

Posted by Hemprasad Badgujar on August 20, 2014

VISUAL STUDIO 2012 ADD-IN FOR QT5

We need to download the following two:

  • Qt5 SDK , In my case, it’s the Qt 5.1.1 for Windows 64-bit (VS 2012, OpenGL, 522 MB) (Info)
  • Visual Studio Add-in 1.2.2 for Qt5

    Once the Add-in installed successfully, we should now see QT5 show up on the Menu Bar:

    Qt5inVS.png

    SETTING QT5 OPTIONS

    The next step is to let the VS know where to get bin/qmake and lib/libraries. Without this step, we may get “Unable to find a Qt build! To solve this problem specify a Qt build” when we try to create a new Qt5 project.

    In my case, they are under “C:\Qt\Qt5.1.1\5.1.1\msvc2012_64_opengl”.

    QtPath_to_qmake.png

    So, we need to pass this information.

    From the top menu, QT5->Qt Options. Then, select “Add” and type the path into “Path”

    AddNewQtVersion.png

    The “Version name” should be filled with 5.1.1. Hit OK.

    Qt_Options.png

    CREATING A NEW QT5 PROJECT

    Now, let’s create a new Visual Studio Project: File -> New -> Project. We will now see a new addition called Qt5 Projects. This allows us to create various Qt applications. For now, select “Qt Application”

    NewProject.png

    WelcomQt5GUI.png

    ProjectSettings.png

    We just leave everything untouched.

    GeneratedClass.png

    Press “Finish”

    SolutionExplorer.png

    BUILDING QT5 PROJECT

    Let’s build the project and run.

    We’re going to add simple UI (QProgressBar and QSlider) with “valueChanged(int)” signal and “setValue(int)” slot.

    Before we start building the project, we may want to make sure that our host and target are set properly.

    Things to check – in my case, Host:x64, Target (Platform):x64

    If this is not set properly, we may get “linking problem: fatal error LNK1112: module machine type ‘x64′ conflicts with target machine type ‘X86′ or something similar error messages.

    • Check properties options in linker settings at: Properties > Configuration Properties > Linker > Advanced > Target Machine. In my case, it should be x64.
    • Select Build > Configuration Manager from the main menu in visual studio. Make sure our project has the correct platform specified.

    After that, we should check Qt Project Settings as well. If this hasn’t been set, we may get “There’s no Qt version assigned to this project for platform x64″ – visual studio plugin for Qt:

    Right click the project > Qt Peoject Settings > Under the Properties tab > Version

    QtProjectSettings_5_1_1.png

    Set signal and slot for the UI we added:

    Signal_Slot_valueChanged_setValue.png

    Build and run:

    HelloQtRun.png

    The progress bar keeps updated as we move the slider. So, seems to be working fine!

Posted in Computer Vision, Project Related | Leave a Comment »

RSVP/Join to a Meetup

Posted by Hemprasad Badgujar on August 16, 2014

RSVP to a Meetup

On your Meetup Group home page, you’ll find each upcoming Meetup listed in the center of the page along with an RSVP button.

Click on the RSVP button to view the details of the Meetup. Then you can RSVP by checking Yes or No and clicking the RSVP button. Use the fields provided to add guests or a comment to your RSVP, which will be added to the Meetup’s conversation stream.

111

 
​​When you receive an email announcement of a new Meetup, you can click on the Yesor No button in the email to register your RSVP directly from your email inbox.

 

122222

The email will also display some other upcoming Meetups for the group, so that you can RSVP to those as well.

If your plans change, click the Change RSVP button to change the number of guests you’ll be bringing, or to alert your Organizer that you are no longer able to go to.

 

Posted in Mixed | Leave a Comment »

How to convert apk file to source code

Posted by Hemprasad Badgujar on August 9, 2014

Step 1:
Make a new folder and put .apk file in it (which you want to decode). Now rename the extension of this .apk file to .zip (eg. rename from filename.apk to filename.apk.zip) and save it. Now you get classes.dex files, etc. At this stage you are able to see drawable but not java & xml files, so continue.
** UPDATE: Android Complete tutorial now available here.
Step 2:
Now extract this zip apk file in the same folder. Now download dex2jar from this link dex2jar and extract it to the same folder. Now open command prompt and change directory to that folder. Then write dex2jar classes.dex and press enter. Now you get classes.dex.dex2jar file in the same folder. Then download java decompiler from this link Java.decompiler.free and now double click on jd-gui and click on open file. Then open classes.dex.dex2jar file from that folder. Now you get class files and save all these class files (click on file then click “save all sources” in jd-gui) by src name. At this stage you get java source but the xml files are still unreadable, so continue to Step 3.

Step 3:
Now open another new folder and put these files

  1. Put .apk file which you want to decode
  2. Download apktool v1.x AND apktool install window using Google(http://code.google.com/p/android-apktool/downloads/list) (Very important first download apktool-install-windows-r05-ibot and extract the file . Second download apktool1.5.2, extract jar in that and put it in same folder ) and put in the same folder
  3. Download framework-res.apk file using Google and put in the same folder (Not all apk file need framework-res.apk file)
  4. Open a command window
  5. Navigate to the root directory of APKtool and type the following command: apktool if framework-res.apk
  6. apktool and "fname".apk (“fname” denotes filename which you want to decode)

Now you get a file folder in that folder and now you can easily read xml files also.

Step 4:
It’s not any step just copy contents of both folder to the single one and now enjoy with source code.

Posted in Mixed | Leave a Comment »

How to solve error message “The application was unable to start correctly (0x000007b). Click OK to close the application”

Posted by Hemprasad Badgujar on August 5, 2014

How to solve error message “The application was unable to start correctly (0x000007b). Click OK to close the application”

This error message may occur on 64 bit operating systems when the Microsoft Visual C++ Redistributable Package is not properly configured.

You can find below the procedure for replacing the corrupted /misconfigured Windows files which should solve the issue you are dealing with:

1. Click here to download the archive and decompress it to reveal the correct Windows files.

The archived contains 5 files:

mfc100.dll, mfc100u.dll, msvcr100.dll, msvcp100.dll and msvcr100_clr0400.dll

Please save these files to any location on your PC;

2. Please reboot your computer in Safe Mode

[How to restart in SAFE MODE]

- Restart the computer;

- Press the “F8″ key (several times before Microsoft Windows begins to load; you need to press “F8″ until you will be displayed a text menu;

- Select “SAFE MODE”;

3. Access C:\\Windows\\System32;

4. Locate the 5 files you have downloaded and extracted;

5. Next, copy all those files to C:\\Windows\\System32 replacing the current ones;

6. Reboot in normal mode;

Posted in Mixed | Tagged: , , | Leave a Comment »

History of computer data storage devices

Posted by Hemprasad Badgujar on August 4, 2014

 History of computer data storage devices

Humankind has always tried to find ways to store information. In today s modern age, people have become accustomed to technological terminology, such as CD-ROM, USB Key, and DVD. Floppy disks and cassette tapes have been forgetting except for the most nostalgic. Subsequent generations have simply forgotten about the technology that helped evolve the efficient computer storage systems we all use everyday. As time humanity continues to push the envelope of innovation to create new possibilities.

1725 Punch cards () :The oldest known form of data storage, the punch card, was created by Basile Bouchon in 1725. The punch card is a perforated paper loop used to store patterns rather than actual data. In fact, punch cards were used to store settings for various machines and had a capacity of 960 bits.

Punch card Fortran program

 

1846 Punched tape -Punched tape was first used in 1846 by inventor of the fax machine, Alexander Bain. Punch tape consists of a long strip of paper in which holes are punched to store data. Each row on the strip represents a single character, yet considerably more data can be stored by creating a fanfold. When folded, punch tape can store up to a few dozen kilobytes—much more data than punch cards.

 

 

1928 Magnetic TapebFritz Pfleumer, a German engineer, patented magnetic tape in 1928. He based his invention off Vlademar Poulsen’s magnetic wire.
1932 Magnetic DrumG. Taushek, an Austrian innovator, invented the magnetic drum in 1932. He based his invention off a discovery credited to Fritz Pfleumer.

Selectron tubes (1946)

In 1946 RCA began developing the Selectron tube—an early form of random access storage that was never produced in a commercially viable form. The original Selectron tube measured 10 inches and could store 4096 bits but was expensive to build and therefore replaced in the market by the widely available core memory.

1946 Williams TubeProfessor Fredrick C. Williams and his colleagues developed the first random access computer memory at the University of Manchester located in the United Kingdom. He used a series of electrostatic cathode-ray tubes for digital storage. A storage of 1024 bits of information was successfully implemented in 1948.
Selectron TubeIn 1948, The Radio Corporation of America (RCA) developed the Selectron tube, an early form of computer memory, which resembled the Williams-Kilburn design.
Selectron tube
1949 Delay Line MemoryThe delay line memory consists of imparting an information pattern into a delay path. A closed loop forms to allow for the recirculation of information if the end of the delay path connects to the beginning through amplifying and time circuits. A delay line memory functions similar to inputting a repeating telephone number from the directory until an individual dials the number.
Magnetic CoreA magnetic core memory, also known as a ferrite-core memory, uses small magnetic rings made of ceramic to store information from the polarity to the magnetic field it contains.
1956 Hard diskA hard disk implements rotating platters, which stores and retrieves bits of digital information from a flat magnetic surface.

 

1963 Music tapePhilips introduced the compact audio cassette in 1963. Philips originally intended to use the audio cassette for dictation machines; however, it became a popular method for distributing prerecorded music. In 1979, Sony’s Walkman helped transformed the use of the audio cassette tape, which became widely used and popular.

1965 Compact cassette :The Compact Cassette was introduced by Philips in 1963 as a type of magnetic tape, although it didn’t gain popularity until the 1970s. A typical 90-minute cassette could store close to 700kB to 1MB of data per side of the tape. Compact Cassettes were used to store data in a few computers and remained popular until the late 1980s. 

 

1966 DRAM (PDF)In 1966, Robert H. Dennard invented DRAM cells. Dynamic Random Access Memory technology (DRAM), or memory cells that contained one transistor. DRAM cells store bits of information as an electrical charge in a circuit. DRAM cells increased overall memory density.

1968 Twistor MemoryBell Labs developed Twistor memory by wrapping magnetic tape around a wire that conducts electrical current. Bell Labs used Twistor tape between 1968 to the mid-1970s before it was totally replaced by RAM chips.
1970 Bubble MemoryIn 1970, Andrew Bobeck invented the Bubble Memory, a thin magnetic film used to store one bit of data in small magnetized areas that look like bubbles. The development of the Twistor memory enabled him to create Bubble Memory.
1971 8″ FloppyIBM started its development of an inexpensive system geared towards loading microcode into the System/370 mainframes. As a result, the 8-inch floppy emerged. A floppy disk, a portable storage device made of magnetic film encased in plastic, made it easier and faster to store data.
1976 5.25″ FloppyAllan Shugart developed a the 5.25-inch floppy disk in 1976. Shugart developed a smaller floppy disk, because the 8-inch floppy was too large for standard desktop computers. The 5.25-inch floppy disk had a storage capacity of 110 kilobytes. The 5.25-inch floppy disks were a cheaper and faster alternative to its predecessor.
1980 CDDuring the 1960s, James T. Russel thought of using light to record and replay music. As a result, he invented the optical digital television recording and playback television in 1970; however, nobody took to his invention. In 1975, Philips representatives visited Russel at his lab. They paid Russel millions for him to develop the compact disc (CD). In 1980, Russel completed the project and presented it to Sony.
1981 3.5″ FloppyThe 3.5-inch floppy disk had significant advantages over its predecessors. It had a rigid metal cover that made it harder to damage the magnetic film inside.
1984 CD RomThe CD-ROM, also known as the Compact Disk Read-Only Memory, used the same physical format as the audio compact disks to store digital data. The CD-ROM encodes tiny pits of digital data into the lower surface of the plastic disc, which allowed for larger amounts of data to be stored.
1987 DATIn 1987, Sony introduced the Digital Audio Tape (DAT), a signal recording and playback machine. It resembled the audio cassette tape on the surface with a 4 millimeter magnetic tape enclosed into a protective shell.
1989 DDSIn 1989, Sony and Hewlett Packard introduced the Digital Data Storage (DDS) format to store and back up computer data on magnetic tape. The Digital Data Storage (DDS) format evolved from Digital Audio Tape (DAT) technology.
1990 MOD (PDF)The Magneto-Optical disc emerged onto the information technology field in 1990. This optical disc format used a combination of optical and magnetic technologies to store and retrieve digital data. A special magneto-optical drive is necessary to retrieve the data stored on these 3.5 to 5.25-inch discs.
1992 MiniDiscThe MiniDisk stored any kind of digital data; however, it was predominately used for audio. Sony introduced MiniDisk technology in 1991. In 1992, Philip’s introduced the Diigtal Compact Cassette System (DCC). MiniDisk was intended to replace the audio cassette tape before it eventually phased out in 1996.
1993 DLT (PDF)The Digital Equipment Corporation invented the Digital Linear Tape (DLT), an alternative to the magnetic tape technology used for computer storage.
1994 Compact FlashCompactFlash (CF), also known as “flash drives,” used flash memory in an enclosed disc to save digital data. CF devices are used in digital cameras and computers to store digital information.
ZipThe Zip drive became commonly used in 1994 to store digital files. It was a removable disk storage system introduced by Iomega.
1995 DVDDVD became the next generation of digital disc storage. DVD, a bigger and faster alternative to the compact disc, serves to store multimedia data.
SmartMediaToshiba launched the SmartMedia, a flash memory card, in the summer of 1995 to compete with MiniCard and SanDisk.
Phasewriter DualThe Phasewriter Dual (PD) was the first device that used phase-change technology to store digital data. Panasonic introduced the Phasewriter Dual device in 1995. It was replaced by the CD-ROM and DVD.
CD-RWThe Compact Disc Rewritable disc, a rewritable version of the CD-ROM, allows users to record digital data over previous data.
1997 Multimedia CardThe Multimedia Card (MMC) uses a flash memory card standard to house digital data. It was introduced by Siemen’s and SanDisk in 1997.
1999 MicrodriveA USB Flash Drive uses a NAND-type flash memory to store digital data. A USB Flash Drive plugs into the USP interface on standard computers.
SD CardThe Secure Digital (SD) flash memory format incorporates DRM encryption features that allow for faster file transfers. Standard SD cards measure 32 millimeters by 32 millimeters by 2.1 millimeters. A typical SD card stores digital media for a portable device.
2003 Blu Ray (PDF)Blu-Ray is the next generation of optical disc format used to store high definition video (HD) and high density storage. Blu-Ray received its name for the blue laser that allows it to store more data than a standard DVD. Its competitor is HD-DVD.
xD-Picture CardOlympus and Fujifilm introduced the xD-Picture Card in 2002, which are exclusively used for Olympus and Fujifilm digital cameras.
2004 WMV-HDThe Windows Media High Definition Video (WMV-HD) references high definition videos encoded with Microsoft Media Video nine codecs. WMV-D is compatible for computer systems running Windows Vista, Microsoft Windows XP. In addition, WMV-D is compatible with Xbox-360 and Sony’s PlayStation 3.
HD-DVDHigh-Density Digital Versatile Disc (HD-DVD), a digital optical media format, uses the same disc size as Blu-Ray. It is promoted by Toshiba, NEC, and Sanyo.
Holographic (PDF)The future of computer memory resides in holographic technology. Holographic memory can store digital data at high density inside crystals and photo-polymers. The advantage of holographic memory lies in its ability to store a volume of recording media, instead of just on the surface of discs. In addition, it enables a 3D aspect that allows a phenomenon known as Bragg volume to occur.
Cloud Backup SolutionsZetta’s cloud enables businesses to protect data using backup, recover from a disaster, and archive unused files using only a lightweight sofware client and Zetta’s bi-coastal datacenters. As storage hardware and internet bandwidth continue to develop, so will Zetta’s performance.

The future of data storage

The way we store information today has certainly evolved since the 1725 advent of data storage, and the evolution is certainly for the better. Like all forms of technology, mediums of data storage will continue to change, performing better and faster while smaller in size. Think a thumb drive is about as good as it gets? Read on for a glimpse of what you may eventually be storing your files in.

E. coli

Yup, it’s possible that we may one day store our precious memories in bacteria. Researchers in Hong Kong have discovered that a single gram of bacteria is capable of holding more information than a 900TB hard drive. Storing information in bacteria and other living organisms, a process called biostorage, is a growing field of interest for students at Hong Kong’s Chinese University, who are using E. coli to test the limits of data storage.

Research in 2007 by a group of Japanese researchers, reasoned that due to bacteria’s ability to constantly reproduce, a group of these organisms could hold information for thousands of years. Students in Hong Kong are building on this previous research and have discovered a way to condense data, store it by chunks in organisms and then map the DNA to easily find the information at a later time. Biocryptography, as the process is called, could mean a revolution in the storage of text, images, music and video, because not only can so much information be stored, but it’s also resistant to hacking. These researchers are testing E. coli and other types of bacteria to determine which work best for storage and access after encryption. Some bacteria are capable of surviving nuclear radiation, leading scientists to believe our information may eventually survive even the worst of disasters. While bacteria aren’t putting the hard drive industry out of business yet, that day may come.

 

Sand

A single Carbon Crystal, reduced one atom at a time by nanomachinery, can store up to 887,808 petabytes. Yeah, yeah, but how big is that? For comparison, 1 petabyte is equivalent to over 1billion megabytes, and eight years ago, our society recorded 2,200 petabytes of data. All of that data could fit into a single grain of sand. And suppose we use diamonds instead? One nanoscale diamond is capable of storing a lifetime of data for six billion people. What’s more, this information would exist after the end of the human race.

 

Posted in Mixed | Tagged: , , , , | Leave a Comment »

Learn English quickly

Posted by Hemprasad Badgujar on August 2, 2014

Reading, listening and speaking are the most important aspects of any language. The same applies to English language. I think this article will be definitely useful for people who are more passionate about learning English quickly.

EnglishTips to speak fluent English

 

  • Read and listen

We are so fluent in our mother tongue only because we read and listen to the same language all around us. Instead of trying to converse in English at the earlier stage it is better to read English novels and then listen to English albums.  Watch English movies preferably with subtitles.  This will increase your listening capacity as well as your vocabulary. Record your own voice and listen to it. This will help you to evaluate yourself.

 

  • Improving your Vocabulary

Carry a pocket dictionary always with you. When you hear a new word then find out its meaning and antonyms.  Learn few common idioms and phrases.  Use the words which you learnt in your conversations.

  • Motivation is the half work

 

You should have a strong passion for learning English.  Dedication is the key to success. So dedicate your time as much as you can.

 

  • Be confident

“To err is human” so don’t feel to speak English. Learn the pronunciation of the words clearly then practice it. Encourage people around you to correct your mistakes. Try to find a partner who is passionate like you to learn English quickly.  Work together this will help a lot more.

 

  • Think in English

Instead of thinking in your mother tongue then translating it in to English is not a good way to improve English.  So try to think in English.

  • Stop studying grammar

Many researches prove that studying grammar alone is an inefficient way to learn English quickly.  Put away your grammar books. Grammar rules teach you to think in English.  There should be a degree of naturalness while speaking without thinking.

 

  • Study correct materials

Read good English magazines and listen to audio articles.  “Practice makes a man perfect”. So if you practice with some material which is not correct then you will be used to speak incorrectly.  So you use the materials which are used by most people.

 

  • Online chat

The easy thing for people who don’t have a chance to speak is to use online chat since because we have to think and respond quickly.

These are my suggestions that will help you achieve your goal of learning English fluently.

Posted in Computer Languages, Computer Research, Research Menu | Tagged: , , , , | Leave a Comment »

Russia Wants Apple & SAP To Turn Over Their Source Codes

Posted by Hemprasad Badgujar on August 1, 2014

Russia Wants Apple & SAP To Turn Over Their Source Codes

russiankeyboardAs you’re probably aware by now, China is not the biggest fan of Microsoft and has accused the company of anti-monopoly activities and also to a certain extent, spying. Well it looks like Russia too has fears about spying, although not necessarily from Microsoft. According to a report from Reuters, it seems that the Russian government is asking that Apple and SAP turn over their source code for inspection.

According to the Russian government, they claim that the proposal for the source code of both companies is to ensure the rights of consumers and corporate users are protected in terms of privacy of personal data, as well as to ensure state security. It seems highly unlikely that either Apple or SAP will be turning their source codes over.

After all, the source codes to their software is the bread and butter of their business activities, and if it somehow got leaked in the process of inspection, well safe to say that will be extremely disastrous.

In a statement made by Russia’s Communications Minister, Nikolai Nikiforov, “Edward Snowden’s revelations in 2013 and U.S. intelligence services’ public statements about the strengthening of surveillance of Russia in 2014 have raised a serious question of trust in foreign software and hardware.” What do you guys think? Any chance of Apple or SAP turning over their source code to the Russian government anytime soon?

Posted in Mixed | Leave a Comment »

TOOLS TO DEVELOP THE NEXT KILLER IOS OR ANDROID APP

Posted by Hemprasad Badgujar on July 22, 2014

POST NAVIGATION

  1. Random + Noteworthy Tools
  2. DIY (No Coding) App Creation Tools
  3. Development, Analytics and Management Platforms
  4. Mockup and UI Design Tools
  5. Mobile Ads + Monetization
  6. Test, Refine and Get Feedback
  7. App Promotion & Marketing
  8. Enhance App Functionality
  9. Other and Miscellaneous

RANDOM + NOTEWORTHY TOOLS

  1. Tapjoy – Drive more installs and boost your revenue.
  2. Vungle – Video trailers for your app.
  3. Skala Preview – Sends lossless, color-accurate previews to any iOS device.
  4. Apptopia – Buy and sell app ownership.
  5. appbackr – Get your apps funded or profit from funding apps.
  6. Ooomf – Create a beautiful landing page for your iPhone app in minutes.
  7. App Annie – App store analytics and market intelligence.
  8. Mopapp – App store analytics.
  9. Pieceable – Make your iOS apps work in the browser.
  10. Chupa – The marketplace for buying/selling mobile app components.
  11. Distimo – Providing valuable insight into the app store marketplace.
  12. Appsfunder – Fund your development. Build up customers. Keep ownership.
  13. PlayHaven – Mobile game LTV maximization platform and cross-promotion.
  14. Appstores.com – White label app store and distribution platform.
  15. Cloudmine – Stop writing backends for your mobile apps.

 

DIY (NO CODING) APP CREATION TOOLS

  1. Cabana – The visual way to make gorgeous custom mobile apps. *RG
  2. Mobile Roadie – Full CMS, no coding app builder for iOS and Android.
  3. Appafolio – 100% native apps, content caching for offline viewing and more.
  4. AppMakr – Point and click solution for building rich content based apps.
  5. RareWire – DIY app creation studio. Coming soon.
  6. GameSalad Creator – Create, test and publish your own game. Drag and drop.
  7. Bizness Apps – Mobile apps for businesses made easy.
  8. WebMobi – Create a mobile web app in minutes. Many features.
  9. SwebApps – An easy way to build your app in minutes.
  10. TapLynx – Create an app from your website in minutes.
  11. AppBreeder – “The online iPhone app builder.”
  12. App Press – Build iOS apps without coding.
  13. Dapp – The app design app. WYSIWYG editor with 100% money back guarantee.

DEVELOPMENT, MANAGEMENT & ANALYTICS PLATFORMS

  1. Parse – Add a powerful and scalable backend to your app in minutes.
  2. Appboy – User engagement, CRM, analytics and more.
  3. Flurry – Analytics, traffic acquisition and monetization.
  4. Mixpanel – Mobile analytics. Actions speak louder than page views.
  5. Scoreloop – Cross-platform mobile gaming SDK. Virtual currency and more.
  6. PhoneGap – Open source HTML5 framework that supports 7 platforms.
  7. Kontagent – User analytics for the mobile web.
  8. Appcelerator – Mobile app platform for building on Android, iOS and mobile web.
  9. Kendo UI Mobile – Build HTML5 apps that look native on any device.
  10. Appoxee – Making mobile app engagement easy, effective and trackable.
  11. Localytics – Powerful tools and actionable insights.
  12. Precog – Harness the power of big data to build smarter apps.
  13. Apsalar – Allows mobile publishers to analyze, optimize and monetize.
  14. Sencha – HTML5 framework for mobile devies.
  15. Flow – Build real-time apps faster, better, smarter.
  16. Game Closure – Offer a JavaScript game SDK. Runs on mobile/tablet devices.
  17. StackMob – Robust and flexible end-to-end HTML5 platform.
  18. Claritics – Intelligent analytics for mobile app developers.
  19. Tiggzi – Cloud-based mobile app builder.
  20. Capptain – Combines analytics and CRM features.
  21. Placed – The Placed SDK enables location analytics for your app.
  22. GENWI – Cloud publishing for mobile.

 

MOCKUP AND UI DESIGN TOOLS

  1. App Cooker – Advanced iOS mockup generator for mobile applications.
  2. Proto.io – Silly-fast mobile prototyping.
  3. Mockabilly – App for creating mockups on iPhone.
  4. UI Stencils – Stencils, sketch pads and accessories for UI design.
  5. Interface – Mockup and prototyping app for iPhone/iPad.
  6. justinmind – Rich interactive wireframes to define mobile apps.
  7. UXPin – User experience design tools for professionals.
  8. Symbolicons – Simple, precise and awesome vector icons.
  9. Prototypes – Turn your stackable designs into a tappable iPhone prototype.
  10. Blueprint – An iPad app for mocking up iPad/iPhone applications.
  11. Mobility – A free set of mobile UI design elements.
  12. Android GUI Set – Free Android GUI set including Photoshop files.

 

MOBILE ADS + MONETIZATION

  1. iAd – A significant revenue stream for iOS developers.
  2. Millenial Media – Monetization solutions for mobile app developers.
  3. inneractive – Mobile advertising and marketing.
  4. Burstly – Empowers developers and enables them to make more money.
  5. Airpush – Push ad network. Android app monetization.
  6. Medialets – Mobile rich media advertising.
  7. xAd – Local mobile ads.
  8. madvertise – European mobile advertising marketplace.
  9. Pontiflex – Mobile performance advertising.
  10. WHERE Ads – Deliver relevant local ads to your audience.
  11. Jumptap – Targeted mobile advertising.
  12. Tapgage – Mobile interstitial ads (also has a “click exchange” for driving traffic).

 

TEST, REFINE AND GET FEEDBACK

  1. Apptentive – Easy in-app feedback for iPhone application developers. *RG
  2. Apphance – Instant, accurate and complete mobile testing.
  3. Crashlytics – Powerful yet lightweight crash reporting for iOS and Android.
  4. StartUpLift – Submit your startup. Get featured. Get feedback.
  5. Crittercism – Gives you real-time, actionable crash reports for mobile apps.
  6. BetaBait – Find beta users and testers.
  7. BugSense – Crash reports for Android, WP and iOS apps.
  8. FieldTest – Currently in private beta.
  9. iPad GUI PSD – A free vector iPad GUI set.
  10. uTest – End-to-end software testing.
  11. Truevoo – Submit iPhone apps for users to review.

 

APP PROMOTION & MARKETING

  1. apptap – App search, recommendations and marketing.
  2. AppCod.es – iOS app store SEO and marketing.
  3. Appency – Professional mobile application marketing.
  4. App.net – Market your mobile apps with beauty, strength and intelligence.
  5. Chartboost – Succeed in the app store through cross-promotion.
  6. Appular – iPhone application marketing and public relations.
  7. Appia – An open app marketplace with over 32k developers.
  8. App Store Optimization – SEO for mobile apps.
  9. AppCircus – The global open app showcase platform.
  10. buzzdoes – App marketing and distribution tool.

 

ENHANCE APP FUNCTIONALITY

  1. PubNub – Blazingly fast cloud-hosted messaging service for real-time apps.
  2. Xtify – Push notifications for iOS, Android and Blackberry devices.
  3. Lookio – Live in-app support for mobile applications.
  4. CENZIC – Solutions for mobile application security.
  5. SecureUDID – A UDUD solution that’s secure and respects privacy.
  6. Verious – A mobile app component marketplace.
  7. ZooZ – Start accepting secure in-app payments within minutes.
  8. Applingua – iOS app localization (translation) service.
  9. Trestle – Powerful cloud services for your mobile apps.

 

OTHER AND MISCELLANEOUS

  1. Interstate – Plan and share development progress using roadmaps.
  2. Mobile Orchard – The iPhone app developer’s blog.
  3. Appolocious – Discover iPhone and iPad apps. A Yahoo directory.
  4. Orientation to Android Training – Official Android classes.
  5. StackOverflow – Question and answer site for programmers.
  6. Tap2Print – Monetize your photo/image app.
  7. StartApp – Get paid for your Android app downloads.
  8. AppLover – Helping build amazing applications.
  9. BlueStacks – Run Android apps on Windows.

 

Posted in Mixed | Tagged: , , , , , , , , | Leave a Comment »

What’s New In Microsoft PowerPoint 2013 ?

Posted by Hemprasad Badgujar on July 9, 2014

Revamped Landing Page

The landing page of PowerPoint 2013 has received the much needed facelift. The landing page of the previous version, Microsoft Office 2010, looked very bland and even confusing to some users. In the newer version, the landing page has been revamped to provide users with quick access to locally available templates, as well as the online database. The online templates are divided into several categories such as Business, Industry, Small Business, Presentation, Orientation, Design Sets, 4:3, Media, Nature, Marketing etc. While new presentations can be created from the main window, the left sidebar shows all the recently accessed presentations.

 

Color Themes For Templates

The templates can be used with different color themes. For instance, if the theme comes with a light color scheme, and you want to use darker colors, just click the template and all the available color schemes will be displayed. You can select the required one to use in your presentation. Just like the previous versions, you can also manually change the color and style of elements in a template.

 

Enhanced Presenter View

The Presenter View in PowerPoint 2013 displays the Active slide on the left side, the Next slide at the top right, while the Notes for the current slide are displayed in the bottom right corner. A timer appears above the preview of the current slide, and extra controls are available at the top and bottom of the Presenter View window.

Even though, Presenter View was also available in the previous versions of Microsoft PowerPoint, it was not activated by default. Users had to navigate to the Slide Show tab, and enable Presenter View in order to display it on secondary display screen. For this reason, a lot of people were not aware of its existence in the previous PowerPoint versions. Microsoft seemed to realize this in the latest release, and has enabled it by default. Now, whenever you run the slide show, the Presenter View will be displayed, if there are multiple display devices connected to the computer. Some changes have also been made to the console. Now you have an extra Laser Pointer Pen Tool, option to zoom parts of a slide, see all slides at a time, and ability to switch Slide show and Presenter Views between the connected display monitors.

 

Account Management

The Account Management window allows you to connect to your SkyDrive account, and add services to use with PowerPoint. Sign in to your Microsoft Account, and it will automatically connect to your SkyDrive account. You can use the same account to sign in to Microsoft Office 2013 on different devices. This way, all your saved documents will be synced to the cloud and will be available for viewing and editing from any device. This eliminates the need to carry your documents in removable storage drives. Using the SkyDrive account, you can easily share your presentations and invite others to collaborate on required presentation projects.

 

Share Documents To View & Edit In The Browser

The Share option offers a number of ways to share the document with others. You can Invite people by specifying their Email addresses, Send them a link to View and Edit the document, Post the document to Social networks, Email it to others as an attachment (PPTX), as a URL, as PDF, as XPS, or as internet Fax,Present it Online so that others can check out your presentation from their browsers, and Publish Slides to any Library or a SharePoint site. The person on the receiving end does not need to have Microsoft Office installed on his/her system in order to view or edit the document. If they have a Windows Live ID, everything can be performed from inside the browser.

 

 

Widescreen & Fullscreen Support

PowerPoint 2013 offers a slew of Widescreen templates and themes. The previous version also allowed you to switch to widescreen mode, however, you had to manually change the aspect ratio of the slide, which also changed the size of the slide elements. The new version of PowerPoint has built in support for Widescreen monitors. Moreover, there is also a new full screen mode available for editing. It allows you to view your slides, and edit them while consuming the available screen space. The Ribbon, containing all the editing options, can be activated and deactivated from a conveniently placed button at the top right corner.

 

UI Changes & Pane View

There are various UI related changes in PowerPoint 2013. First of all, everything feels smoother, from the movement of the cursor when you type, to the way animations appear in your presentation. Microsoft has also tried to improve the look and feel of the interface. There are now buttons available on the main interface to switch to the aforementioned Fullscreen View, and to access Notes and Comments.

Another welcome change to the UI is that a lot of options, which used to appear in separate dialog boxes, are now accessible through panes, appearing on the right side. For instance, in PowerPoint 2010, if you right-click a slide and select Format Background, a separate dialog box opens up. You can make changes to a slide, but the dialog box covers the slide, and you have to move it manually in order to view all the slide elements. Moreover, when you select Format Background option, instead of opening a separate dialog box, a pane is added to the right side. Anything that you change using from the pane is reflected on the slide in real time. It means that you don’t have to open and close the dialog box again and again to view the changes. Just like other Office 2013 suite applications, it includes an Online pictures option to let you quickly add background to the slide from your favorite online image resource; you can choose an image from the Office.com Clip Art Library, the Bing Image Search, or from your own SkyDrive and Flickr account.

 

Alignment Guides, Merge Shapes & Auto-Text Wrapping

A new feature, included in PowerPoint 2013, as well as Word 2013, is the Alignment Guides. It allows you to easily align objects and text in a slide, relative to each other. You can use the object alignment option to merge different shapes with each other. For instance, If you want to merge together two shapes, the alignment guides help you in quickly adjusting them together according to top, down, left and right margins. Another very useful, and much needed, feature added to PowerPoint 2013 is auto-text wrapping. When an image is added to a slide with text in it, the text automatically readjusts itself around the image so that there is no overlapping of any kind.

 

Insert Online Video, Image And Audio

PowerPoint 2013 now allows you to add videos, images and audio files directly from the internet, without first downloading them to your PC. Think of it as the object being embedded in your presentation. The previous version of PowerPoint also had the option to add videos from the web, however you had to copy the embed code of required video and paste it into PowerPoint. The latest version allows you to Insert an online video in your presentation using the integrated Bing Video Search, SkyDrive Account, YouTube, or From a Video Embed Code. For instance, to add a YouTube video, just search for it, select the required one from the search results and click OK to embed it into your presentation.

 

The image results are, by default, set to show the images that are licensed under Create Commons, so it eliminates the chance of copyright violation when you use an online image in your presentation. You can also choose to view all the web results for your search.

 

Export Presentation As WMV & MPEG-4 Video

PowerPoint 2010 also lets you save the presentation as a video, but only in WMV format. In PowerPoint 2013, another format, MPEG-4 is added to save converted presentation in video format. Due to the addition of MPEG-4 format, the presentation video can directly played on a lot of media players and devices. Now, users don’t require Windows Media CODEC installed on non-Windows devices to watch the presentation. Also, portable devices, as well as a lot of LCD/ LED TVs have built in support to play MPEG-4 format. Just go to Export, and select Create a Video. All the other options, including the Resolution, and whether to use recorded timings and narrations are available with the MPEG-4 format.

 

Start at the new Start screen

As with the other key Office 2013 applications, PowerPoint 2013 shares the new Modern-style interface and a revamped Start screen. Instead of the blank presentation you started with in PowerPoint 2010, this screen is packed with options including a range of templates. Also on the Start screen is a link to your current online SharePoint or SkyDrive account, a list of recently accessed PowerPoint files, and an Open Other Presentations link which you use to access files on disk or stored in the cloud.

You can also search online for templates and themes from the Start screen; a list of suggested searches helps here.

Now you can preview layouts before selecting a Theme to use.

Themes are sleeker, and Variants more varied

PowerPoint Themes are predesigned slide designs that spare you from doing the design work yourself. In PowerPoint 2010 there was a plethora of Themes, Color Schemes, Font Schemes and Effects to choose from. PowerPoint 2013 simplifies everything. The new Themes default to a 16:9 aspect ratio and each has a small subset of Variants, which provide variations in color and some design elements for that Theme.

You’ll find Themes from both the Start screen and the new Design tab. On the Start screen you can click a Theme, preview its variant,s and scroll through previews of the Theme Title, Title and Content, Smart Chart and Photo layouts before committing to one to use.

The old Merge Shape tools are now easier to find.

Shape tools get improvements

Although some of the Merge Shapes features that are touted as being new in PowerPoint 2013 were in PowerPoint 2010, they weren’t accessible from the Ribbon toolbar. In PowerPoint 2013, though, the Join, Combine, Fragment, Intersect and Subtract tools are accessible by selecting the Drawing ToolsFormat tab and clicking the Merge Shapesbutton. You’ll use these to create your own custom shapes by combining and merging simple shapes to make more complex ones. These tools have a handy live preview as well.

In addition, new alignment guides show when shapes are lined up to each other, to slide elements, and to borders and they make it easier to line up and space objects evenly on your slides.

Formatting options have become more visible.

Find new formatting tools

In PowerPoint 2013, you’ll find many formatting features from task docked to the right of the screen as you work. In earlier versions of PowerPoint, these options appeared in dialogs over the slide, which you had to move or close to continue working.

To access these new task panes, right-click a shape, for example, and choose Format Shape to see the available options for a shape in the task pane. Click a picture and the task pane changes to show picture formatting options. While most of the formatting options are not new, this makes them easier to find.

New is the Eyedropper tool, available when you are making a color choice. Use this to match colors by sampling a color to use from a shape or photo.

Lok online for videos to include in presentations from within PowerPoint.

Video input and output improve

PowerPoint 2013 supports additional video formats so it’s more likely videos will play in your presentation without you needing to install additional codecs.  For example, PowerPoint 2013 supports the MP4 and MOV formats for playing video, and you can export a PowerPoint presentation to video in MP4 or WMV formats.

The new Video button on the Insert tab includes options that let you search for a video from an online source and drop it into your deck without first downloading it to your computer.

At long last, there’s a button to play audio tracks in the background and across slides.

Audio playback options expand

PowerPoint 2013 supports a wide range of audio formats without requiring you to download and install additional codecs. Supported formats now include AIFF, AU, MID, MIDI, MP3, M4A, MP4, WAV, and WMA.

You can click a button in PowerPoint 2013 to play audio tracks across the entire slideshow or across slides. While this has always been possible, it was ridiculously annoying to set up.  Now all you need do is to insert the audio file, select it, and chooseAudio Tools, Playback tab and click the Play In Backgroundoption.

Only have one monitor? You can finally take advantage of Presentation View.

Presentation View becomes rosier

While the PowerPoint Presenter View was available in earlier versions of PowerPoint most users didn’t know it existed. Plus, if your computer only had one monitor you couldn’t access it —even to rehearse your presentation!

Now you can access Presenter View even on a single monitor by pressing Alt + F5. In Presenter View you can swap monitors for Presenter View and Slide Show View if desired. You can also view a thumbnail view of your slides, and click to view a slide out of sequence.

The new Zoom option lets you look close-up into an area on a slide to draw attention to it. There’s a new laser pointer tool here, too.

The new Comments task pane makes it easier to converse when working with others.

Work better with your team

When you’re designing a presentation with others, the new Comments feature will make it easier to discuss your slideshow with collaborators. When you add a comment, it appears in a Comments task pane down the right of the screen and stays visible while you work.

There are also options to add a comment from the Insert tab or the Comments task pane. The Comments task pane lets you navigate through comments, and see if there are comments on other slides. You can view your presentation with or without comments by selecting the Show Comments from the Review tab, and deselecting Show Comments.

The new Office Presentation Service expands features for Presentation View and video in online presentations.

Bring your presentation online

Now you can present a deck stored in the cloud or on your PC to the Web in real time. To use the new Office Presentation Service, choose File, Share, Present Online. You can also allow attendees to download the presentation to their own PC.

You’ll also see Presenter View while making your presentation. Plus, you can play video at presentation time, and viewers get their own set of video controls. In addition, viewers can navigate back to previous slides if they need to check or follow up on something.

 

Switching accounts / SkyDrive integration

I’ll admit, I really wasn’t crazy about the idea of “logging in” to Office initially. I also admit that this isn’t the most exciting or even impressive feature, but it is one that I am thankful for. As someone with several Microsoft Accounts, a couple Office 365 accounts, and therefore many SkyDrive accounts, it was a bit inconvenient having to go to the web, sign in to a SkyDrive account, and then download whatever file I needed. I really love being able to quickly switch between profiles to quickly access files in the cloud right from PowerPoint.

Having two Microsoft Accounts gives me a nice little “fence” to separate my personal and work files. All I have to do is click on “Switch account” to access my other accounts.

If I didn’t want to separate files via multiple Microsoft Accounts, I can also just add two different SkyDrive accounts to one profile. In other words, I sign into PowerPoint with one Microsoft account, but add all my SkyDrive accounts by clicking on “Add a Place” from the backstage open screen.

The only thing I don’t like about this second method is that at first glance there is no way to distinguish between my two different SkyDrive folders. As you can see in the above picture, PowerPoint only displays the user name (which is the same) next to each account. On the Open screen, I would love to see the email address display below the name like in the Accounts screen. Other than that, this is a wonderful addition, one that makes me utilize my free cloud storage more than ever before, and limits my need to “remote desktop” into my work computer.

Threaded comments

When collaborating with others, it is now a lot less complicated to follow conversations. Comments are now “threaded” and a lot easier on the eye.

Play From and Motion Path End

Technically, these are two separate but similar features that tie for third place in my book. I work with a lot of animations, and these two new additions have saved me a ton of time when working with and creating them.

Play From

The old Play button in the Animation Pane is now a Play From button, allowing you to preview a portion of the animations on a PowerPoint slide. Simply select an animation in the animation pane before pressing the Play From button.

Motion Path End

When drawing motion paths, PowerPoint now “ghosts” your object so you can see exactly where that object will appear when the animation completes, so no more guessing!

Color Picker

PowerPoint now includes a color picker! Better late than never, right?

The Eyedropper tool is found in the Shape Fill drop menu located from both the Home tab and the Drawing Tools Format tab. To select a color on the slide, simply click on the Eyedropper button, and then click on the desired color. To select a color from outside of the PowerPoint application window, click and drag.

Presenter View

The presenter view received quite the overhaul. It now is much darker, so presenting from behind a computer screen will not create a creepy glow.

It also includes three resizable panes: a slide preview, a next slide preview, and a notes area. To resize any of these areas, simply hover your mouse over any of the divider bars, then just click and drag.

Personally, I don’t need to see my current slide or the next slide. So my view usually looks like this:

In the above picture, I’ve completely collapsed the current slide view, resized the next slide view to a teeny-tiny thumbnail, and maximized my notes area to act as a kind of teleprompter.

There are also a lot of tools at your disposal that were once buried in hard-to-reach menus. All buttons are touch-friendly sized, making it easier to navigate a presentation from a touch-enabled monitor or tablet. The only problem is that these buttons appear in the Current Slide pane, so if you are like me and minimize that area, they are no longer easily accessible; however, you can still get to those options by right-clicking.

Also very useful, you can now jump to any slide or section in your presentation by clicking the Slide Sorter button (the one next to the pen tool) or by right-clicking and selecting “See All Slides.

Your view will change, but your audience will still see your previously selected slide. As you select a different slide, your audience will just see a flawless transition to a new slide and will never know you are presenting out of order.

But perhaps the best addition to the presenter view is the ability to zoom into a portion of a slide.

Simply select the Zoom In button (Magnifying Glass icon), hover your mouse over the area you’d like to zoom into, and click.

Well, now that PowerPoint 2013 has released to manufacturing, it’s time to publish my big list of new features. This is my list of new stuff in PowerPoint 2013, definitely not the same list Microsoft marketing publishes. So here we go…

Start UI. PowerPoint 2013 gives you a whole new experience from the get-go. Choose from a bunch of new templates and variants and see previews of a few slide layouts before you begin your presentation.

16×9. This is the new default slide aspect ratio. (The old one was 4×3.) Don’t worry, you can still set your default template to 4×3 if you want.

13.33″ x 7.5″. This is the new default slide size. (The old 4×3 was 10″ x 7.5″, and the old 16×9 was 10″ x 5.76″.) Personally, I think this is a very good thing.

Before I forget, Scale to Fit Paper is now ON by default in the File | Print dialog. I’m sure this is directly related to the 13.33×7.5 slide size feature above. (So the whole 16×9 slide will print on the page.)

Slide Size tool. There’s a new tool on the Design tab to help you switch your slides from 4×3 to 16×9 and back without completely wrecking all your content. Yay!

Variants and SuperThemes. We now have variations of a theme that are built-in. Most variants are very similar to the “base” theme, with changes to the color or font set. Themes that include variants are called SuperThemes.

Format panes. Instead of having a Format dialog, we now have a Format pane that is docked to the right side of the work space.

Insert Online Pictures. The Office programs now distinguish between inserting pictures from your hard drive and inserting them from online. Similar settings exist for Video and Audio.

Logging in. Log into your Microsoft.com account, and you’ll see more content and have more options. For example, if I’ve logged onto my MSFT account, my SkyDrive will show up (along with office.com, Flickr and Bing image search) when I click Insert Online Pictures.

Saving. When you save, online locations such as SharePoint team sites and Skydrive are in the forefront. Don’t forget to click Computer before browsing to a location if you’re saving to your hard drive!

Present Online. This is really the equivalent of Broadcast Slide Show, but the presenter has the option of letting people download the presentation as well (or not). Be aware — if you allow the audience to download, then they’ll also have the ability to navigate through the broadcast presentation at their own pace while you’re presenting.

Save as Video. By default this now creates an MPEG-4 Video. WMV (Windows Media Video) is still an option.

New Slide button. They finally added this to the Insert tab! (Only took three versions, sheesh. Unfortunately it’s still in the wrong place — it should be on the other side of the Images group, but nobody listens to me!) Don’t worry, it’s still on the Home tab also.

Popup menu in Slide Show View. The buttons that show in the lower left corner during slide show view have been tweaked for a better touch experience. They’re not as subtle as they could be, but they’re not as bad as they could be, either.

See All Slides. When in a slide show, we now have a view that looks kind of like Slide Sorter View. (There’s no longer a Go to Slide menu with an option to navigate by slide title, though.)

Presenter View. This is all kinds of new and all kinds of cool. And if you only have one monitor, use Alt+F5 to see and practice with Presenter View!

Page Curl transition. Yes, you heard (read) me right — we finally have a page turn transition! It’s actually called Peel Off, but what’s in a name? Actually, we have quite a few new transitions, including Page Curl, Curtains, and Fracture (among others). Also, while we’re on the subject of transitions, the bounce has been removed from the end of the Pan transition.

Play From. The animation pane now lets you play from the selected animation.

Motion Path End. A ghosted object now shows up to show you the end position of a motion path. Very, very helpful!

Animation Zombies. Some of the old animations (Stretch and Collapse, for example) are baaaaack!

Threaded Comments. Comments have been enhanced with a Comments Pane that shows the comments thread and avatars for those commenting.

Enhanced Smart Guides. Those whisker things that showed up in PowerPoint 2010 to help you align and position objects on a slide? Well, they got even better in 2013 because now they also help with distribution.

Enhanced Guides. We now have the equivalent of lockable, colorable guidelines, people! Wahooo! Put one set of guides on your slide master (to indicate margins, for example). Add others to any layouts that might require different guides. And add even more to the regular slides as you’ve always done. When you’re in Normal (editing) View, only the guides on the slides will be selectable — otherwise you’ll need to go to Master View to move them. Oh, and did I mention that you can recolor all of these? Just right-click a guide…

Color Picker. We now have eyedroppers to pick up and apply fill, outline and font colors. All together now: Thank you, PowerPoint Team!

Merge Shapes. These tools, which are similar to the Pathfinder tools in Illustrator, are now on the Ribbon (on the Drawing Tools Format tab). The group is called Merge Shapes instead of Combine Shapes. There is also a new tool, Fragment, to complement the other four.

Semantic Zoom. We can zoom and pan in Slide Show View now.

Charts. Charting is a lot better in many ways and a lot worse in others. Now a small Excel datasheet opens above the chart instead of Excel opening and taking up half your screeen. The interface is vastly improved. They added a combo chart to the types of charts (yay!). They added new chart styles (good) but removed the 2007/2010 chart styles (bad). They made the default chart font size 12 points (good or bad, depending if you like it or not) and the default chart font color a tint/shade of Dark 1/Light 1 (horrible if Dark 1/Light 1 is anything besides black or white).

PowerPoint Web App. This has lots of new features. We can now add, edit and format shapes, apply a new theme, and use animations and transitions. We also have audio and video playback in both Reading and Slide Show views. It still supports co-authoring, but now it supports co-authoring with regular ol’ PowerPoint, too. And if you embed your presentation into a web page or blog, it’s no longer just static pictures — it’s actually like a regular presentation with animations, transitions, audio and video. (Old embedded presentations will automatically update to behave this way, too.)

Default Office Theme is a bit different. The colors are different and the default effects set is way more subtle.

SmartArt graphics. We got some new SmartArt diagrams.

Backstage. Along with the overall interface overhaul to a newer, flatter look, Backstage has been reorganized once again.

WHAT’S MISSING (WELL, KIND OF…)

Save as HTML. Gone. Done. Kaput. It’s not in the interface, and it’s not accessible with VBA either.

Insert ClipArt. This has been replaced with Insert Online Pictures. No clipart or picture collections are installed with Office 2013.

Not missing, just moved. Theme Colors, Fonts and Effects dialog are no longer on the Design tab, but they are available in Slide Master View. Background Styles are available in Slide Master View.

Broadcast Slide Show. This isn’t really gone — it’s just morphed into Present Online.

Outline pane. Again, this isn’t actually gone, it just doesn’t show up any more next to the Slides pane in Normal (editing) View. Go to the View tab to turn the Outline pane on and off.

Combine Shapes. For those of you who used these, they’re not gone. They’ve been promoted to the Drawing Tools Format tab of the Ribbon and are now called Merge Shapes.

In Slide Show View, there’s no longer a Go to Slide menu with an option to navigate by slide title. Instead, we have the new See All Slides view, which looks similar to Slide Sorter view.

Posted in Computer Software, Computer Softwares, Documentations, My Research Related, Project Related, Research Menu | Tagged: , , | Leave a Comment »

What’s New In Microsoft excel 2013 ?

Posted by Hemprasad Badgujar on July 9, 2014

Microsoft’s updated spreadsheet tool isn’t getting a lot of new, whiz-bang features, but it is becoming more functional. That’s something both new and experienced users will enjoy—especially a new approach to an old problem that used to require a cumbersome workaround. Complex tasks become easier to perform, thanks to tools such as Recommended Charts and Recommended PivotTables tools. Other changes place choices closer to your data, and use big-business brawn to crunch data right into Excel.

To help you get up to speed, read on for 10 new features that make your work easier in the new Excel. Want to know more about the new Office suite? You’ll find our full review of Office 2013 here, as well 10 killer features in the new Word 2013 here.

Start screen sets the scene

Excel’s new Start Screen helps you get to work more quickly. Along its left edge are the most recently used worksheets, any of which can be pinned to your Recent list so they will always be visible. Here, too, you can click Open Other Workbooks to access your files from a disk or the cloud. The Start Screen’s top-right corner also shows the SkyDrive (or SharePoint) account you are currently connected to.

A range of templates appears here to help you quick start a project. These can also be pinned, or you can use the search feature to look online for other templates. A list of suggested searches can help you get started.

New users will appreciate the template choices, and existing users will likee the Recent file list and quick access to existing files. Although the Start Screen can be disabled, I find it useful enough to stick with it.

The Open tab has links to recently accessed files and locations.

Enjoy a new Backstage View

The Backstage View, introduced in Office 2010, is accessible from the File menu. In Excel this has been revamped to show exactly what you’re doing so you can choose the appropriate task.

The Open tab now gives you access to recently accessed workbooks, making it a combination of the Open and Recent tabs from Excel 2010. You can pin worksheets to this list or click Computer to access recently accessed locations (any of which you can pin permanently here, too). There’s also access to your SkyDrive account, and the option to set up additional SkyDrive or SharePoint accounts.

Want to split first and last names into two columns? Look to the new Flash Fill feature.

Make Flash Fill magic

The most whiz-bang new feature is the Flash Fill tool. Its predictive data entry can detect patterns and extract and enter data that follows a recognizable pattern. It solves some common problems that currently require cumbersome workarounds to achieve.

One such problem is extracting a person’s first name from a column of full names. In a blank column adjacent to the one that contains full names, you simply type the first name and then click the Home tab, and select Fill, Flash Fill. The first names of everyone in the list will be entered into that that column immediately. You can use the same process to extract last names, to join first and last names, to extract months, days or years from dates and even extract values from cells.  While you could have always done this with formulas, now Flash Fill ensures anyone can do it very quickly and easily.

Take the guess work out of which chart to choose to best display your data.

Simplify choices with Recommended Charts

This falls somewhere between a whiz-bang new feature and something that makes working in Excel more intuitive. Recommended Charts shows only a subset of chart types that are appropriate to the data you’ve selected. It will help inexperienced users create charts that help explain the data and don’t confuse the viewer.

To use the tool, select the data that you want to chart, click the Insert tab and selectRecommended Charts. A dialog appears with a range of charts to choose from—click each in turn to see how your data will look plotted on that chart. Select the desired option and click OK, and the chart is created automatically.

Change the look of your chart by selecting options from the pop-up menu.

Chart tools get smarter

In previous versions of Excel, when a chart is selected, the Chart Tools tab revealed three additional tabs: Design, Layout, and Format. The interface is simpler in Excel 2013, with only the Design and Format tabs to choose from.

In addition, a set of icons appears outside the top right edge of a chart when it is selected. Click any of these buttons—Chart  Elements, Chart Styles or Chart Filters—to reveal additional chart formatting options. Click Chart Elements to add or remove elements, such as axis titles and legends; click Chart Styles to change the style and color of your chart; or click Chart Filtersto view filtered data using a live preview.

Quick Analysis offers formatting, totals and charts for analyzing your data.

Quickly analyze your data

The new Quick Analysis tool can help both new and experienced users find options for working with selected data. To use it, select the data to analyze, and the Quick Analysis icon  appears in the bottom-right corner of the selected data.

Click that icon, and a dialog appears showing a range of tools for analyzing the data, such as Formatting, Charts, Totals, Tables and Sparklines. Click any option, and a series of selectable choices appear; preview those choices by mousing over them. Next, click the option you like to apply it to your data. This feature speeds up the process of formatting, charting and writing formulas.

PivotTables just became ridiculously simple to create.

Answer questions instantly with Pivot Tables

Pivot Tables are a powerful tool for analyzing and answering questions about  your data, but they’re not easy for new users to create. For the first time, though, if you can click a mouse key, then you can create a meaningful Pivot Table, thanks to the new Recommended PivotTables. To use it, select your data, including headings, and chooseInsert, Recommended PivotTables. A dialog appears showing a series of PivotTables with explanations of what they show. All you need do is to select the table that shows what you want to see, click OK,and the PivotTable is automatically drawn for you.

Excel 2013 now integrates Power View for beefy analysis and reporting.

imelines

A timeline lets you filter records in a PivotTable—it works similar to a slicer, but you’ll filter by dates. For instance, Figure E shows a PivotTable and timeline. (I used the same data range used in #3.) Once you have a PivotTable arranged, adding the timeline is simple:

  1. With the PivotTable selected, click the contextual Analyze tab.
  2. In the Filter group, click Insert Timeline.
  3. In the resulting dialog, check the date field (in this case, that’s Date) and click OK. Excel will embed the timeline alongside the PivotTable.

 

Excel_New_Ftrs.FigE.jpg

 

Use the new Timeline with a PivotTable.

To use the timeline, just drag the scroll bar or click a tile to further filter personnel totals by specific months. In the upper-right corner, you can change to years, quarters, months, and days. To clear the timeline filter, click the Clear button in the upper-right corner.

Make quick reports with Power View

The Power View add-in, available for previous versions of Excel, is now integrated inside Excel 2013. Power View is typically used for analyzing large quantities of data brought in from external data sources—just  the sort of tool that big business might use.

Incorporated within Excel, it’s now  accessible to anyone. To see it at work, select your data and choose Insert, Power View. The first time you use it, the feature installs automatically. Then a Power View sheet will be added to your workbook, and the analysis report will be created.

You can add a title and then filter the data and organize it to display the way you like. The Power View tab on the Ribbon toolbar displays report format options, such as Theme and text formats, as well View options for Field List and Filters Area panels that you can use to filter and sort your data.

Try to work on a worksheet that someone else is editing? You’ll be warned that it’s locked. You can view and download it, but can’t change it.

Share files and work with other people

Working with other people on shared files in real time is a double-edged sword. While it’s useful to do this, you will face problems when two people try to change the same item at the same time. In Excel 2013 you can share and work collaboratively on files with others via SkyDrive using the Excel WebApp, and multiple people can work on the same file at the same time. However, you cannot open a worksheet from SkyDrive in Excel 2013 on your local machine if someone else is currently working in the same worksheet. This protects the worksheet against conflicting changes.

Instead, if one person is editing an Excel file that’s stored online, others with permission can view and download it, but they cannot change the original, whichis locked until the person working with it is finished.

Like other applications in the Office 2013 suite, Excel 2013 saves files by default to the cloud. You can open, view, and edit Excel files  online in a browser using the Excel WebApp without having Excel 2013 on the local hard drive.

Share your cloud-stored worksheets with friends on Facebook, Twitter, or LinkedIn.

features to explore

Get started quickly

Some of the templates that are available in Excel

Templates do most of the set-up and design work for you, so you can focus on your data. When you open Excel 2013, you’ll see templates for budgets, calendars, forms, and reports, and more.

Instant data analysis

Data Analysis Lens

The new Quick Analysis tool lets you convert your data into a chart or table in two steps or less. Preview your data with conditional formatting, sparklines, or charts, and make your choice stick in just one click. To use this new feature, see Analyze your data instantly.

Fill out an entire column of data in a flash

Flash Fill in action

Flash Fill is like a data assistant that finishes your work for you. As soon as it detects what you want to do, Flash Fill enters the rest of your data in one fell swoop, following the pattern it recognizes in your data. To see when this feature comes in handy, see Split a column of data based on what you type.

Create the right chart for your data

Recommended Charts

With Chart recommendations, Excel recommends the most suitable charts for your data. Get a quick peek to see how your data looks in the different charts, and then simply pick the one that shows the insights you want to present. Give this feature a try when you create your first chart.

Filter table data by using slicers

Table slicer

First introduced in Excel 2010 as an interactive way to filter PivotTable data, slicers can now also filter data in Excel tables, query tables, and other data tables. Simpler to set up and use, slicers show the current filter so you’ll know exactly what data you’re looking at.

One workbook, one window

Two workbooks, two windows

In Excel 2013 each workbook has in its own window, making it easier to work on two workbooks at once. It also makes life easier when you’re working on two monitors.

New Excel functions

New Web functions

You’ll find several new functions in the math and trigonometry, statistical, engineering, date and time, lookup and reference, logical, and text function categories. Also new are a few Web service functions for referencing existing Representational State Transfer (REST)-compliant Web services. Look for details in New functions in Excel 2013.

Save and share files online

Online places to save your workbook

Excel makes it easier to save your workbooks to your own online location, like your free OneDrive or your organization’s Office 365 service. It’s also simpler to share your worksheets with other people. No matter what device they’re using or where they are, everyone works with the latest version of a worksheet— and you can even work together in real time. To learn more about it, see Save a workbook to the Web.

Embed worksheet data in a web page

To share part of your worksheet on the web, you can simply embed it on your web page. Other people can then work with the data in Excel Online or open the embedded data in Excel.

Share an Excel worksheet in an online meeting

No matter where you are or what device you’re on—be it your smartphone, tablet, or PC—as long as you have Lync installed, you can connect to and share a workbook in an online meeting. To learn more about it, seePresent a workbook online.

Save to a new file format

Now you can save to and open files in the new Strict Open XML Spreadsheet (*.xlsx) file format. This file format lets you read and write ISO8601 dates to resolve a leap year issue for the year 1900. To learn more about it, seeSave a workbook in another file format.

Top of Page TOP OF PAGE

New charting features

Changes to the ribbon for charts

Chart Tools

The new Recommended Charts button on the Insert tab lets you pick from a variety of charts that are right for your data. Related types of charts like scatter and bubble charts are under one umbrella. And there’s a brand new button for combo charts—a favorite chart you’ve asked for. When you click a chart, you’ll also see a simpler Chart Tools ribbon. With just a Design and Format tab, it should be easier to find what you need.

Fine tune charts quickly

Chart buttons to change chart elements, layout, or chart filters

Three new chart buttons let you quickly pick and preview changes to chart elements (like titles or labels), the look and style of your chart, or to the data that is shown. To learn more about it, see Format your chart.

Richer data labels

Bubble chart with data labels

Now you can include rich and refreshable text from data points or any other text in your data labels, enhance them with formatting and additional freeform text, and display them in just about any shape. Data labels stay in place, even when you switch to a different type of chart. You can also connect them to their data points with leader lines on all charts, not just pie charts. To work with rich data labels, see Change the format of data labels in a chart.

View animation in charts

See a chart come alive when you make changes to its source data. This isn’t just fun to watch—the movement in the chart also makes the changes in your data much clearer.

Powerful data analysis

Create a PivotTable that suits your data

Recommended PivotTables for your data

Picking the right fields to summarize your data in a PivotTable report can be a daunting task. Now you can get some help with that. When you create a PivotTable, Excel recommends several ways to summarize your data, and shows you a quick preview of the field layouts so you can pick the one that gives you the insights you’re looking for. To learn more about it, see Create a PivotTable to analyze worksheet data.

Use one Field List to create different types of PivotTables

Add more Tables in the Field List

Create the layout of a PivotTable that uses one table or multiple tables by using one and the same Field List. Revamped to accommodate both single and multi-table PivotTables, the Field List makes it easier to find the fields you want in your PivotTable layout, switch to the new Excel Data Model by adding more tables, and explore and navigate to all of the tables. To learn more about it, see Use the Field List to arrange fields in a PivotTable.

Use multiple tables in your data analysis

The new Excel Data Model lets you to tap into powerful analysis features that were previously only available by installing the Power Pivot add-in. In addition to creating traditional PivotTables, you can now create PivotTables based on multiple tables in Excel. By importing different tables, and creating relationships between them, you’ll be able to analyze your data with results you aren’t able to get from traditional PivotTable data. To learn more about it, see Create a Data Model in Excel.

Power Query

If you’re using Office Professional Plus 2013 or Office 365 Pro Plus, you can take advantage of Power Query for Excel. Use Power Query to easily discover and connect to data from public and corporate data sources. This includes new data search capabilities, as well as capabilities to easily transform and merge data from multiple data sources so that you can continue to analyze it in Excel. To learn more about it, see Discover and combine with Power Query for Excel.

Power Map

Power Map

If you’re using Office 365 Pro Plus, Office 2013, or Excel 2013, you can take advantage of Power Map for Excel. Power Map is a three-dimensional (3-D) data visualization tool that lets you look at information in new ways by using geographic and time-based data. You can discover insights that you might not see in traditional two-dimensional (2-D) tables and charts. Power Map is built into Office 365 Pro Plus, but you’ll need to download a preview version to use it with Office 2013 or Excel 2013. See Power Map for Excel for details about the preview. To learn more about using Power Map to create a visual 3-D tour of your data, see Get started with Power Map.

Connect to new data sources

To use multiple tables in the Excel Data Model, you can now connect to and import data from additional data sources into Excel as tables or PivotTables. For example, connect to data feeds like OData, Windows Azure DataMarket, and SharePoint data feeds. You can also connect to data sources from additional OLE DB providers.

Create relationships between tables

When you’ve got data from different data sources in multiple tables in the Excel Data Model, creating relationships between those tables makes it easy to analyze your data without having to consolidate it into one table. By using MDX queries, you can further leverage table relationships to create meaningful PivotTable reports. To learn more about it, see Create a relationship between two tables.

Use a timeline to show data for different time periods

A timeline makes it simpler to compare your PivotTable or PivotChart data over different time periods. Instead of grouping by dates, you can now simply filter dates interactively or move through data in sequential time periods, like rolling month-to-month performance, in just one click. To learn more about it, see Create a PivotTable timeline to filter dates.

Use Drill Down, Drill Up, and Cross Drill to get to different levels of detail

Drilling down to different levels of detail in a complex set of data is not an easy task. Custom sets are helpful, but finding them among a large number of fields in the Field List takes time. In the new Excel Data Model, you’ll be able to navigate to different levels more easily. Use Drill Down into a PivotTable or PivotChart hierarchy to see granular levels of detail, and Drill Up to go to a higher level for “big picture” insights. To learn more about it, seeDrill into PivotTable data.

Use OLAP calculated members and measures

Tap into the power of self-service Business Intelligence (BI) and add your own Multidimensional Expression (MDX)-based calculations in PivotTable data that is connected to an Online Analytical Processing (OLAP) cube. No need to reach for the Excel Object Model—now you can create and manage calculated members and measures right in Excel.

Create a standalone PivotChart

A PivotChart no longer has to be associated with a PivotTable. A standalone or de-coupled PivotChart lets you experience new ways to navigate to data details by using the new Drill Down, and Drill Up features. It’s also much easier to copy or move a de-coupled PivotChart. To learn more about it, see Create a PivotChart.

Power View

Power View

If you’re using Office Professional Plus, you can take advantage of Power View. Simply click the Power View button on the ribbon to discover insights about your data with highly interactive, powerful data exploration, visualization, and presentation features that are easy to apply. Power View lets you create and interact with charts, slicers, and other data visualizations in a single sheet. Learn more about Power View in Excel 2013.

New and improved add-ins and converters

Power Pivot for Excel add-in

If you’re using Office Professional Plus 2013 or Office 365 Pro Plus, the Power Pivot add-in comes installed with Excel. The Power Pivot data analysis engine is now built into Excel so that you can build simple data models directly in Excel. The Power Pivot add-in provides an environment for creating more sophisticated models. Use it to filter out data when importing it, define your own hierarchies, calculation fields, and key performance indicators (KPIs), and use the Data Analysis Expressions (DAX) language to create advanced formulas. Learn more about the Power Pivot in Excel 2013 add-in.

Inquire add-in

If you’re using Office Professional Plus 2013 or Office 365 Pro Plus, the Inquire add-in comes installed with Excel. It helps you analyze and review your workbooks to understand their design, function, and data dependencies, and to uncover a variety of problems including formula errors or inconsistencies, hidden information, broken links and others. From Inquire, you can start a new Microsoft Office tool, called Spreadsheet Compare, to compare two versions of a workbook, clearly indicating where changes have occurred. During an audit, you have full visibility of the changes in your workbooks.

Cloud support

Microsoft claims that its cloud support is the true shining star of the Office 2013 suite. If you need it, you probably agree; many organizations aren’t taking full advantage of it yet. If you’re curious, you can quickly hook up to SkyDrive or your organization’s SharePoint team site by using the Save As (or Open) screen, as shown in Figure F. Doing so has two advantages:

  • You have quick and easy access to your Excel files on any device that runs Excel 2013 (including a Windows tablet and smartphone).
  • Using Office 365 (you’ll need a subscription), you canreview and edit your workbooks online using almost any web browser.
    Excel_New_Ftrs.FigF.jpg

Data Model and Relationships

Excel 2013’s new integrated data model support is well beyond a simple recommendation tip like this. You’ll want to study and familiarize yourself with all of the possibilities:

  • Create PivotTables based on multiple tables.
  • Create one-to-one and one-to many relations between tables.
  • Easily connect to OData, Windows Azure DataMarket, and SharePoint.
  • Drill down to detail levels in a PivotTable or PivotChart.
  • Drill up for a high-end view.

Apps for Office

This new feature provides quick access to specialized programs at Office Store. Just a quick click and you’re shopping! To install an app, click the Insert tab and then click Apps for office in the Apps group. You’ll need an account at the store, which the feature will help you create the first time you use it. Figure G shows Bing Maps as an installed app.

Excel_New_Ftrs.FigG.jpg

 

After creating an Office Store account, adding Bing Maps took just a couple of clicks.

Present online

Sharing a workbook online used to take a bit of preparation, but in Excel 2013, on-the-fly sharing is no problem. First, install Lync. If you have Office Professional Plus, you already have it, but you’ll need to configure it. Before sharing, sign into Lync. Then, return to Excel 2013, close all workbooks that you don’t want to share, and do the following:

  1. Click the File tab.
  2. Choose Share in the left pane.
  3. Click Present Online (in the Share section).
  4. Click Present.
  5. Choose a Lync meeting or create one, and click OK.

At this point, you can share the workbook and even allow others to update it.

Share work to your social networks

Here’s a handy way to share a to-do list, an event planning worksheet, or whatever spreadsheet you desire with your social network. You can now share Excel workbooks with Facebook and more from within Excel 2013 itself. To see the Post to Social Networks option, the best way to save the file first to SkyDrive.

If you haven’t saved your file to SkyDrive, then choose File, Share, and click Invite People. You’ll be stepped through the process of saving the file to the Cloud so that Save Asoptions later appear automatically. Once this is done, you are returned to the Share panel where the Post to Social Networks option now appears. Here you can select any social network that you have linked to your Office 2013 account. You can select whether viewers can view or edit your shared worksheet, and you can include a message, and then post it for review.

Posted in Computer Software, Computer Softwares, Documentations, Free Tools, My Research Related, Research Menu | Tagged: , , | Leave a Comment »

 
Ronzii's Blog

Just your average geek's blog

Karan Jitendra Thakkar

Everything I think. Everything I do. Right here.

VentureBeat

News About Tech, Money and Innovation

Chetan Solanki

Helpful to u, if u need it.....

ScreenCrush

Explorer of Research in Information Technology

managedCUDA

Explorer of Research in Information Technology

siddheshsathe

A great WordPress.com site

Ari's

This is My Space so Dont Mess With IT !!

Business India 2.0

All about Business Travel 2.0 ideas,technology,ventures and the capital making its happen

Something More for Research

Explorer of Research in Information Technology

WordPress.com News

The latest news on WordPress.com and the WordPress community.

Follow

Get every new post delivered to your Inbox.

Join 2,972 other followers

%d bloggers like this: