faloof.blogg.se

You will use MS Outlook to compose and send email, schedule appointments and meetings, manage contact information, schedule tasks and create notes. The analytical features of Excel, such as Goal Seek, and how to create scenarios Work with PivotTables and PivotCharts, export and import data, and query external databases. Learn about data validation, and advanced data filtering, apply advanced chart formatting options, and create more complex charts. Work with advanced functions and formulas, lookup functions such as VLOOKUP, MATCH, and INDEX. Use advanced formulas organize worksheet and table data using various techniques create and modify charts analyze data using PivotTables, Slicers, and PivotCharts insert and modify graphic objects in a worksheet and customize and enhance workbooks and the MS Excel environment.įurther build on the skills acquired in the Basic and Intermediate courses. You will organize table data, present data as charts, and enhance the look and appeal of workbooks by adding graphical objects in MS Excel. Create a basic worksheet by using MS Excel perform calculations in an Excel worksheet modify an Excel worksheet format a worksheet print the content of an Excel workbook

You will create and edit basic MS Excel worksheets and workbooks. Fundamental knowledge and techniques needed to use more complex Access features such as maintaining databases and using programming techniques that enhance Access applications are covered. Learn the basic operations of the Microsoft Access database program to perform day-to-day responsibilities and become more productive at work. Center for Economic & Workforce Development (CEWD) +.On the Job Training Resource for Employers.Continuing and Professional Education +.JFK Muhlenberg Diagnostic Medical Sonography Program.JFK Muhlenberg Snyder School of Nursing/Union College Cooperative Nursing Program.Science, Technology, Engineering, & Math.Affirmative Action and Equal Opportunity Statement.Public Annual Notification of Non-Discrimination.Union County Board of County Commissioners.