Sunday, 12 March 2017

 is a commercial spreadsheet application written and distributed by Microsoft for Windows and Mac OS X users. It features calculation, graphing tools, pivot tables and a macro programming language called Visual Basic for Applications. With its powerful functions, Excel has been a very widely applied spreadsheet tool in many fields, this article shows some example on 

The commonly usage of Excel is to manage data records. You don't have to plan in advance on how the table should look like, as preset layout allows you to create tables on the fly, just fill in information and data, the table is developed on the go. Another more attractive point is that you have the ability to sort the list and filter the listing like a database tool.

Besides the good use on managing data, Excel is a great analytical tool for business. With the pivot table contained within Excel, you can easily analyze a large number of data, as the pivot table can automatically sort, count, and total the data stored in one table or spreadsheet and create a second table displaying the summarized data.

You can use Excel to create not only a simple form that contains boxes, but also professional forms which include option buttons that allow you to select answers, dropdown list to select a particular answer from list of items. Together with charts, you can use Excel to compile answers to tests or quizzes and analyze the profile of the class (If you are a teacher) or your team (If you are a supervisor).

A major business use of Excel is to corporate budgeting. Many companies, from big corporations to small companies use Excel for their budgeting. Despite numerous calls by suppliers of Business Performance Management Systems (BPM) to move away from Excel as a budgeting tool, 70% to 80% of all corporations still use Excel as their primary budgeting tool.

To manually find out the breakeven for a project, you have to perform many calculations using different numbers as it's inputs. And the calculation becomes even more complex if the components include fixed cost and step up cost. But with the goal seek function in Excel, this task can be completed in a few seconds

Sometimes, you may need to convert Excel to PDF, for instance, you have done the sales analysis and need to send to others, you save the Excel analysis to PDF so that they cannot revise any information in the reports. Then you can use some PDF creator like Simpo PDF Creator Pro to save Microsoft Excel to PDF.

On the other hand, when you want to reuse data information in a PDF and would prefer to export PDF to Excel, you can try this PDF converter - Simpo PDF Converter Ultimate, which not just converts the whole PDF file to Excel spreadsheet, but it also extracts only tables from PDF to Excel.

Sunday, 19 February 2017

tech fair

task one 


task two


task three 






reflections 

through my research of finding out my project I learned allot about how the car works as i will be doing a car that runs on its own generated battery life so for that i had to research how this could be possible to create even though i will only be doing a model and not a real car, like for some of the things are like how battery works in electric cars and how i could fit a disk that creates electricity whilst the car moves and so on. the websites i used were pretty useful to me and i actually found really good ones so i didnt struggle on that as for many people struggle finding good websites. i did follow tasks as instructed in class but i admit i can some times fall behind with tasks and some times not doing them and that i think is what i have to work on. for some tasks i met deadlines and others not so much because i think i got a little to exited with the project itself and forgot about the work. i think my project is definitely good enough as i never heard of some one doing what i did and according to the project itself it is for fact a tech fair project. if i were to redo the tech fair i would focus more on the work and then the project. i will not be redoing the project as its fine like this.