Microsoft Excel Expert – Access 2010/2013

• 1

• 2

• 12

  weeks

Master Excel skills (cell, sheet and workbook), insert and work with different types of data, create formulas, work with data ranges, insert functions, insert and format charts, work with databases, create and work with tables dynamics and create, record and run macros. Making the most of all the possibilities that Access offers, relying on its innovative user interface, will address tasks such as the proper use of different types of data, the design of forms and reports, or the most common maintenance functions.

• 1

• 2

• 12

  weeks

· Microsoft Excel, – What's new in Excel 2010/2013?, – Create an Excel workbook, – Work with data and data tables, – Perform calculations with data, – Change the appearance of documents, – Focus on data – Reorder and summarize data, – Combine data from multiple sources, – Analyze alternative data sets, – Create pivot lists with pivot tables, – Create pivot charts using pivot tables, – Print, – Automate repetitive tasks using macros, – Work with other programs in the Microsoft Office system, – Collaborate with others · Microsoft Access, – Exploring Access, – Create a database, – Populate a database, – Share and reuse information, – Simplify data entry using forms, – Locate specific information, – Keep your information accurate, – Work with reports, – Make the database easy to use, – Protect and share information

• 1

• 2

• 12

  weeks

1