Board logo

subject: Online Ms Excel Tutorial [print this page]


Online Ms Excel Tutorial

Why is Excel essential for life in academia?



Numbers are an irreplaceable part of academic life, and MS Excel is the best software around when it comes to numbers.



Build your own little tracker: Need to keep a tab on how youre doing on all those tests, exams and surprise quizzes? It takes very little effort to conjure up a small tracker on Excel that can help you keep watch on how you are doing on academically. And just a couple of hours with Excels awe-inspiring charting engine can have that tracker looking all spiffy and impressive. Plus, adjust the scale of your graphics and your any Cs youve got will start to look like As.



Transform those tables: Academic research involves tabulation of some kind or the other. Its a bleak fac t of life, but its not going to go away. But if youve been building those tables in MS Word, or something comparable, why not give Excel a try? Not only is making tables a gazillion times easier in Excel, it is also very easy to convert base numbers into percentages. You can use Excels sorting feature to quickly arrange your table in ascending or descending order if you wish. And getting totals (row-wise and column-wise!) involves clicking on a button thats it!



Put the Pivot Table to use: Excel has a magician inside it. It may not be as impressive as Merlin of yore, but its packed to the gills with powerful features. Transform that base data that runs into thousands of rows into a small, flexible table that can aggregate and process your numbers.



Make math malleable: Are you confused about what an exponential function really is? Do you need to visualize a logarithmic function before you can truly understand it? It takes next to no time to prepare dummy data, and an accompanying chart for practically any mathematical function. So the next time Napier and his tables make your head swim, turn to Excel for help!



Statistics simplified: Excel probably has more statistical tools in its armory than you have formulas in your stats textbook. Well, that may be pushing it a little, but there is no denying the fact that Excel is replete with statistical tools that can help you complete your assignment in minutes instead of hours. More importantly, preparing a simple statistical model is a piece of cake try it, and you are bound to be pleasantly surprised.



And the best part is, these are just the proverbial tip of the iceberg. No matter what academic field you are working in, Microsoft excel 2007 tutorial has the capability to dramatically lessen the load on your shoulders. And in an academic set-up, thats a welcome quiver in your bow.



So if you havent already, do give Excel a try. And stick around here for tips and tricks on how to become a veritable Zen master when it comes to MS Excel.



by: Excel Everest




welcome to Insurances.net (https://www.insurances.net) Powered by Discuz! 5.5.0   (php7, mysql8 recode on 2018)