Online PC Support

OPS Technical Solutions : +1 833-522-1003

Welcome

First Look: Microsoft® Office 2013

Designed with Windows 8 in mind, Microsoft Corp. has unveiled the customer preview of Microsoft Office 2013. The most recent version of Microsoft Office is primarily an effort to make over the market-leading productivity suite from merely a computer-based application to a software that can be conveniently used on any device, and from anywhere.

Incorporating an intuitive design that works well with stylus, touch, keyboard or mouse across novel Windows-based devices, the new producitivity suite has so much to offer. Its prime highlights are:

SkyDrive: Microsoft Office 2013 by default saves documents to SkyDrive, offering anytime access to content across all Windows-based devices.

Inking: The newly revealed Office 2013 enables using stylus for creating content, taking notes and accessing features. It also lets you handwrite e-mail responses, add color to content and erase mistakes.

Stay connected: An intriguing aspect about the lately released Microsoft Office 2013 is that it includes the ability to follow people, documents, teams and sites in SharePoint. To always remain up-to-date it allows viewing and embedding video, pictures and Office content in the activity feeds.

Reading, markup: The Read Mode in the latest Microsoft Office 2013 Word offers an advanced reading experience that adjusts according to the screen size of your device. Also, there is an option to zoom in or zoom out content, view revision marks, and stream videos in the docs.

Touch everywhere, utility apps, new subscription services, and digital note-taking are some other aspects incorporated in the brand new Microsoft Office 2013 suite.

The latest productivity suite by Microsoft features dramatically improved Microsoft Word, Microsoft Excel, Microsoft OneNote, and Microsoft PowerPoint application programs.

[youtube http://www.youtube.com/watch?v=9zf0dqzTUPk]

How to Make Tables Using Microsoft Excel

Microsoft Excel is software from the Microsoft Corporation that comes bundled in its Famous Microsoft Office suite. Microsoft Office is a commercially marketed platform of which Microsoft Word, Microsoft Excel, Microsoft PowerPoint and Microsoft Access form a crucial part. Microsoft Office was launched in 1990 with Microsoft Word, Microsoft Excel and Microsoft PowerPoint; it has now come a long way with Microsoft Office 2010 launched for Windows and Microsoft Office 2011 launched for Mac OS X.

Microsoft Excel was first launched bundled with Mac in 1985 and the first Windows version in 1987. It has come a long way since then with its latest version are the 2010 version for windows and 2011 version for Mac.

Microsoft Excel is an application in Microsoft Office suite which is used for analyzing and manipulating data in spreadsheets. There are many tools in Microsoft Excel to solve all your data management problems. One of which is tabulating Raw Data. You can create a table in Excel 2007 for storing manipulating and organizing Data in tables.

Here are some of the very simple steps you must follow to create a table in Microsoft Excel:

Step 1:

First select an empty range of cells or cells that contain the data you want to tabulate

Step 2:

Take your mouse to the Home tab, click on “Styles”. Click on the button “Format as Table”

Step 3:

Excel shows a new tab named gallery, with some formatting choices for your table. Select the one most relevant to your data.

Step 4:

Remember to select the checkbox for the ‘Heading Row’ if necessary

Step 5:

A dialogue box will open; Select the range of cells you want to convert to a table

Click ok and your table is created.

These are some simple steps can be used to create a table in Microsoft Excel. One of the major advantages of using Microsoft Excel is that its parent suite Microsoft Office comes with a new, easy to use user interface with better applications. It has been worked on time again and again by Microsoft keeping in mind the changing needs of today’s professional environment and to keep it updated and bug free. Also due to the widespread use of Microsoft Excel the user seldom has not to worry about compatible software because most offices use Microsoft Excel. It is this attribute of Microsoft Excel that separates it from its competitors and has given it a chance to carve out a niche for itself in the professional environment. You wouldn’t expect anything better from the Hands of Microsoft.

Create a Microsoft Access Query That Uses More Than One Table

Microsoft Access is software from the Microsoft Corporation that comes in its Famous Microsoft Office suite. Microsoft Office is a commercially marketed platform which consists of Microsoft Word, Microsoft Excel, Microsoft PowerPoint and Microsoft Access. Microsoft Office was launched in 1990 with Microsoft Word, Microsoft Excel and Microsoft PowerPoint; it has now come a long way with Microsoft Office 2010 has been launched for Windows and Microsoft Office 2011 has been launched for Mac OS X. Microsoft Access was launched in the winter of 1992 and has come a long way since with the most current version Microsoft Access 2010 out.

Microsoft Access is a relational database management application available with the Microsoft office suite. It helps overcome the difficulties encountered in Excel while managing large databases. Like any computer software, to use Microsoft Access, you must first have it installed in your system. It is also available in the Microsoft Office suite. After installing it, to start this program select it from the Microsoft Office tab in your Start up Window.

Now, before learning how to create a Microsoft Access Query using more than one table, let us find out what exactly is a Query and a Table.

Query

They are a set of instructions that are used to retrieve Data from a database. A query can be written through the user interface provided in Microsoft Access, It can also be written using SQL (Structured Query Language)

Table

Tables are a combination of rows and columns in which data is filled.

Creating the query:

Step 1:

The First step should be to Click on the create option which will give you the option to create a database.

Step 2:

Then Go to query Wizard and from the various tabs shown chose the simple query wizard.

Step 3:

Choose the fields from ‘Available fields’ Tab for one table, then select a different table and chose the fields as above from that table.

Step 4:

Now from the tabs available click on Detail.

Step 5:

Give the query a title.

Here you must choose an appropriate title for your query; after giving it a name select “Open the query to view information.”

And your query is created.

It is this very property of Microsoft Access that separates it from other databases; its ability to link different tables in one database gives it the name of a ‘Relational Database’. Microsoft Access is designed with an easy to use user interface keeping in mind that the customers using it should not require an in-depth knowledge of Database management so as to utilize its key features and to keep tabs on your database so as to make a well informed decision. It is this attribute of Microsoft Access that separates it from its competitors and has given it a chance to carve out a niche for itself in the professional environment. You wouldn’t expect anything better from the Hands of Microsoft.

How to Develop Microsoft Excel through VBA Programming

Microsoft Excel is just not a spreadsheet application but if you have gone through it thoroughly, then you will be amazed to know what all can be achieved in Microsoft Excel. To be true what is visible in Excel is just a part of it and it carries a lot more behind the windows. It is a fully programmable and customizable database application and one can keep the data in Excel for backend needs and develop applications and interfaces which will work as frontend. All you need is to know how Windows and its applications work and how to use the active controls. Moreover you should know the programming language known as Visual Basic only then you can develop interface using the same in Microsoft Excel.

In this post I will discuss how to start with VBA programming on Microsoft Excel. Even if you know Visual Basic still you would need extra study material to know how Excel cells are referred and called in Visual Basic scripting.

Step1:

By default, the developer tab is hidden in Microsoft Excel so you need to get it available for you. To do the same click on the Excel options button and then in the Excel options window check the Show Developer Tab check box.

Step2:

Open a new Excel file and then press Alt+F11. This action will open a new Window which will look much like Visual Basic editor. This is the place where on the left side you will get list of all available sheets in the Excel Sheet. You can select any sheet and then in the console which opens on the right can be used for designing or writing macros.

Step3:

If you wish to have extra Windows in your Excel file then click on Insert and insert a new Form. Designing and controls of this Form will exactly be the same as you do in Visual Basic.

Step4:

Add controls and ActiveX items in your form. These additions and selection of controls will depend upon what you want to achieve and what your project is all about.

Step5:

Once you are done with the design and coding make sure that you save the file with an extension of XLSM which defines the file to be opened and used as programmable file.

Steps given above are simple steps to start the Visual basic project in an Excel file. You should always draw the flow of what you want to program as a flow chart on paper considering all the input, output and logical and arithmetic calculations. Drawing a flow chart on paper is the prerequisite for any programming to be done as it nearly makes the coding bug free. Also please note that once you use the Excel cells in your coding then do not delete rows and columns in your spreadsheet because coding uses a different approach for referring to Excel cells and the code doesn’t get auto updated on deleting or inserting rows and columns in Excel spreadsheet.

How to Create a Sum Formula in Microsoft Excel 2003

Microsoft Excel the best spreadsheet application and it has achieved a very high level of user acceptance and popularity by the ongoing research and development for its betterment. There have been number of new releases and versions of Excel since it was first launched and every new release has something new and advanced to offer. Excel has literally replaced the old hardboard registers and almost the entire book keeping is now done on Excel. Any piece of information which can be represented as a table can be saved in Excel and it can anytime be accessed or modified. Excel has given a whole new liberty to its users to interact with the data which they keep in Excel. Typically the files created in Excel are called as workbooks and these workbooks contain multiple worksheets within themselves, just like a register has multiple pages. You can enter information in these worksheets and can make calculations on the data. Excel uses smart background calculation techniques by which the results changes automatically as you change or add the data in related cells. Calculation in Excel is done by hundreds of predefined formulas which can be inserted in any cell and by defining the data sets on which the calculations will be carried. Excel doesn’t only do the basic calculations of Sum and Product but is also capable of calculating complex statistical calculations. In case you need help on using any formula in Excel you can just open the Help and get the relevant help on the topic.

In this post I will help you out with the most commonly used function for performing addition of the values in certain cells. This function is called as the Sum function in Excel

Syntax

=SUM (Number1, Number2……..)

Usage

Step1:

First and foremost enter the equals sign (=)

Step2:

Type the function name, which will be SUM in this case and then open the parenthesis.

Step3:

Click on the cells separated by comma if cells are not in sequence, or else you can select the entire range of cells on which you want to perform the addition.

Step4:

Once you are through with the cell selection close parenthesis.

Step5:

Press enter to let Excel calculate the results for you

Please not that the SUM function is a numerical function and works only on the cells which contains some numerical value. If you chose to perform SUM on the cells which have a non-numerical value, then the SUM function results in an error (#Value). In case, you see this error then you can trace the function backwards to find out which cell contains a non-numerical value. Also at times people while creating the Excel file tend to stop the Automatic calculation in the file. This helps in fast data entry because if there are many functions used in Excel file then after pressing enter Excel calculates all the functions again for any change in the result. So if it happens that you enter a formula and it is not calculated then check for Automatic calculation settings in Excel options.

How to Change the Language in Microsoft Excel

In this new age, people are using different kinds of technologies to get a better life and people have different kind of ways for it. Few decades ago, you should had to do your work by yourself, you don’t have any machine for that but now you have many machines to help you out and also few decades ago you have to write all the things on paper but now you can take a computer type the matter and you get a print out in seconds. So keeping these kinds of works in mind years ago Microsoft made its office, a program which has made by Microsoft and it called Microsoft Office.

Microsoft Excel is main part of Microsoft Office and without MS Exce,l MS Office would not be complete. Microsoft Excel is for your work, yes different kind of work like making reports, charts, graphs and making data files.

You can enter data and you can analysis the data in different ways.

Microsoft excel is very useful for business purpose also it can be used for proposes such as you can make your annual reports, your presentations etc. on it and you get the exact and clear results. You can use their default formulas or you can create by yourself, by using their formulas you can calculate data in it, you just have to enter your values and you get your results in just a few clicks. There are many ways to use Microsoft Excel in your daily life and one of the biggest uses of that is making graphs. If you want to plot a graph then you should use Microsoft Excel because it delivers the best graphs and you can make easily a graph on it.

If you are using Microsoft Excel and you want to change the default language in Microsoft Excel then you can do this easily. Microsoft allows you to work in any of hundreds of available languages.

If you want to Change the Language in Microsoft Excel then below are steps for you.

Step 1:

Open Microsoft Excel and click on the Microsoft Office button in the top left handed corner of your screen and go down to Microsoft Excel options. Now, you will see a window will appear and in that window you can click the popular tab which is on the left hand side of the screen. You can see a button at the bottom of the window that labeled Language Settings.

Step 2:

You can now click the Language Settings button and then select any languages that you want to work in from the box on the left click Add and to move it to the box on the right. Finally in the drop down box on the bottom of the screen labeled Primary editing language and select the language that you want to work in by default. You can now click OK to close the window and then click OK again.

Call Now: +1 833-522-1003
Call Now: +1 833-522-1003
Call Now: +1 833-522-1003