Microsoft excel and the Microsoft access

1. Which two grooming school legal injury did you select and why?I chose the Microsoft pass by and the Microsoft access readying posing, the reason why I chose the stand out planning session was so that I could gain more knowledge on better information outline and ways in which unmatchable end make it more easier to insert formulas on data, excel is known for the analysis of a large sample of data. Microsoft access session is too concerned with data and therefore I wanted to learn more around how one can make computing easier when dealing with data that downslope in different categories.2. What were the highlights of the first training session?The first training session I chose was the Microsoft excel session, the main highlights included the great excel features, printing options of excel, creating a chart, enter formulas and working with the keyboard.3. What were the highlights of the second training session?The second training session was on Microsoft access, the main highlights in this session were differences between a list and a data base, primary keys, handle and tables and fin every last(predicate)y the four main objects that databases contain4. Describe three benefits from all(prenominal) training session (six totals) that you will use in your personal or professional life.From twain training sessions I have improved my seat package use with ease in understanding the application of both excel and access.Microsoft ExcelI learnt how to import data into a worksheet, this has helped me text edition to ease my work of transferring text like data into excel without having to bring out the whole data manually from other office packages such as word.I also learnt to use various formulas and short cuts to those formulas, in the episode where one has a sample whose sample is over a hundred one can simply sum up up easily and also find the mean and also draw a histogram and other charts.I also have learnt to use more than one chart, in t his moorage I have learnt also to auto fill formulas having only written the on the first row, this makes it easier to use on data that require to be multiplied by different columns on the worksheet.Microsoft AccessIn this fly the coop I learnt how to use queries and let access give an output, example in a case where one wants to know how many individuals in a company earn more than a certain level of income, all you need to do is enter a query and then(prenominal) you desex your results.I also learnt how to make a database which aids in memorial tablet of work, the data base will be created with fields such as address, location, department and even the name, this will aid in organization of the data of employees to a manager or accountant.I also learnt how to use the data in access to mail merge, this entails the writing of a letter in word and leaving some fields linked to the data and then one only has to merge the letter with the data base and one can write to a hundred pe ople within minutes.5. What would you add to either training session in terms of improvement, if anything?In terms of improving the training session I would recommend that there be more advanced learning concerning the various Microsoft packages, this will involve life sentence of ways in which various applications are applied.REFERENCEMicrosoft office training (2007) Microsoft excel and Microsoft access training sessions, retrieved on 26th July, available at www.office.microsoft.com/en-us/training/default.aspx