You just moved to Florida with your family and are searching for doctors who can meet your family’s medical needs. You obtained a list of more than 150 board-certified physicians from the state licensing agency. Open e04b1doctors and save it as 04b1doctors_LastnameFirstname. Freeze the panes to keep the column labels and IDs from scrolling offscreen. Convert the data to a table, and apply an appropriate table style. Name the table Doctors. Filter the table to show only those who practice Cardiology, Pediatrics, and Internal Medicine and who are accepting new patients in Fort Lauderdale. Sort the filtered records by specialty, last name, and then first name. Set a print area to include all columns except the ID and New Patient columns. Apply a conditional format for dates after 1/1/2008 with a custom format of an Orange fill and a White font. Create a PivotTable based on the Doctors table. Add the fields Specialty, City, and New Patients. Display how many doctors are accepting new patients for each Specialty and City. (Hint: There will be 3 Cardiology doctors in Coral Gables that are accepting new patients.) Further filter the Pivot Table to show only doctors in Fort Lauderdale. The individual cities should not be visible in the final PivotTable. There will be 26 doctors that fit your criteria. Create a PivotChart of your choice based on your results. Modify the chart appropriately. Name all worksheets. On each worksheet, create a footer with your name, the sheet name code, and the file name code. Save and close the workbook, and submit to Blackboard.
0 comments