Skip to main content

How to learn MS Excel without any tutor and without any money ?

How to learn MS Excel without any tutor and without any money ?
Microsoft Excel (full name Microsoft Office Excel) is a spreadsheet program written and distributed by Microsoft for computers using the Microsoft Windows operating system and for Apple Macintosh computers. It features an intuitive interface and capable calculation and graphing tools which, along with aggressive marketing, have made Excel one of the most popular microcomputer applications to date. It is overwhelmingly the dominant spreadsheet application available for these platforms and has been so since version 5 in 1993 and its bundling as part of Microsoft Office. Just visit the following links to learn excel without any tutor and without spending any money on books/courses etc. :
Free Tutorial/Help Files :
Tips & Tricks,Resources,Templates,Softwares :
Various Tips From Vertex42

Free Excel Templates from Vertex 42
Accounting and Reporting :: Income statements, balance sheets, expense reports ...Business Finance :: Real option valuation, risk analysis, financial modeling ...Business Plans :: Startup expenses, finance statements, break-even analysis ...Calendars and Planners :: Yearly and weekly calendars, planners ...Education :: Gradebooks, weekly schedules, attendance logs ... Gradebook and Grade TrackingMusic and Graph Paper Engineering Templates :: Modeling, units, design ...General Excel Templates :: Templates for demonstrating Excel techniques ...Home and Health :: Home inventory, workout logs, meal planning ...Medicine and Biology :: Diagnostics ...Orders and Inventory :: Invoices, packing slips, price lists ...Payroll and Scheduling :: Timesheets, payroll, shift schedules ...Personal Finance :: Loans, budgets, checkbooks, investments ...Project Management and Planning :: Budgets, cash flow, timelines, projects ...Real Estate :: Amortization, mortgages, renting, closing costs ...Sports :: Scorecards, rosters, tournament brackets ...Statistics :: Data analysis, statistics examples ...Travel :: Mileage logs, expense reports, itineraries ...
Excel Tools from http://www.excel-extools.com
1.Introduction
2.Favorite Files
3.Favorite Text Clips
4.Delete Empty Cells in Columns
5.Transpose
6.Reverse Order
7.Check for Duplicates
8.Multiple Selection Copy
9.Save Selection as File
10.Save Selection as HTML
11.Save Selection as Picture
12.View
13.Compare Worksheets
14.Create Worksheet Map
15.Sort Sheets
16.Hide Blank Rows/Columns at End of Sheet
17.Conditional Select Cells by Value
18.Conditional Select Cells by Format
19.Conditional Select Rows by Value
20.Select Cell with Max Value
21.Copy Cell Formula as is
22.Convert Formula to Constant Value
23.Convert Between Absolute and Relative Reference
24.Perform Math Calculation on Selection
25.Unit Converter
26.Round Numbers
27.Convert Percents to Numbers
28.Convert Numbers to Ordinals
29.Convert Numbers to Text
30.Convert Between Roman and Arabic Numbers
32.Set Subscript/Superscript
33.Word Wrap On/Off
34.Print Multiple Sheets
35.Add Days to a Date
36.Calculator

Excel to Software
Test
The above links are enough to give you the confidence to start working with Excel.So open excel from START >ALL PROGRAMS > MS EXCEL and start ‘programming’.

Comments

Post a Comment

Popular posts from this blog

How to make software without code ?

Programming language like C, C++, Java or scripts like PHP, JavaScript help us to make ineractive applications that can easily accomplish repetitive works or complex goals. But can you build such applications without knowing any programming languages? Each application is based on data .Data is stored in a database. The programming languages take the data as required and with the data it performs the job it was instructed to do. So every application has a database and programming language to solve the problem. It also has interfaces that help a user to give the input of the problem and also to see the output of the same. MS Excel can also do the same. With MS Excel and a software called Spread Sheet Converter (earlier Excel Everywhere) anyone can develop a complete user friendly application. Everyone using a computer need to know MS Excel which is a simple application that helps a user to perform various calculation and store data in a table like interface. If you know Excel well then
4 comments
Read more

How to save money by adjusting your use of electronic appliances ?

In an average middle class household you can expect one or more desktop computer, television, refrigerators, microwave, cell phone etc. If you live in a typical U.S. home, your appliances and home electronics are responsible for about 20 percent of your energy bills. These appliances and electronics include everything from clothes washers and dryers, to computers, to water heaters. Steps below describe the methods to save energy and hence money by some changes in your use of those electronic appliances. Consider buying a laptop for your next computer upgrade; they use much less energy than desktop computers. There is a common misconception that screen savers reduce energy use by monitors; they do not. Automatic switching to sleep mode or manually turning monitors off is always the better energy-saving strategy. Make sure power management is activated on your computer. To maximize savings with a laptop, put the AC adapter on a power strip that can be turned off (or will turn off automat
Post a Comment
Read more

How to apply Analytical Hierarchy Process in Water Resource Management ?

  Course Title: Application of Analytical Hierarchy Process in Water Resource Management Course Duration: 2 Week Course Outcome : 1)How to apply AHP in any kind of decision-making problems 2)One Paper in EIS Journal* 3)One book* Click on to Baipatra for acquiring the course.
Post a Comment
Read more