Ask your admin employee to explain how to do the following

• 1. Remove extra spaces in column A
  
  
  
  

  ---

  
  

  2. What happened? You deleted column A (Full Name). How would you fix it? (value)

  
  
  
  
  
  
  

  3. Separate city, state, zip into their own column (separate)

  
  
  
  
  

  ---

  
  

  4. Open a new workbook and create this gannt chart (gantt)

  
  
  
  
  

  ---

  
  

  5. Open a new workbook and create this loan table (loan)

  
  
  
  
  

  ---

  
  

  6. (1) Find the duplicates and put them in a red font color. (duplicates)
  
  (2) Then, put all the duplicates in red font at the top of the spreadsheet.
  
  (3) Then, remove the duplicates.

  
  
  
  
  

  ---

  
  

  7. Vertical: You want the data in A2 through F7 to be shown vertically as it is in A12 through F17. Explain how to do that. (t - i shorted this)

  
  
  
  
  

  ---

  
  

  8. Top 3: Use conditional formatting to find the top ten highest sales figures in the sales column. The top ten results will show in red font. (top 3 / verify))

  
  
  
  
  

  ---

  
  

  9. Billions to B. Billions and Millions re-shoot videos (billion / verify))

  
  
  
  
  

  ---

  
  

  11. Protect the cells with data so they cannot be changed, or deleted. (protect / verify)

  
  
  
  
  

  ---

  
  

  12. Delete empty rows all at once

  
  
  
  
  

  ---

  
  

  13. Create a macro called ten_sheets. Save the macro.(macro / verify) )

  
  
  
  
  

  ---

  
  

  14. Put the macro you created on the Quick Access Toolbar. (macro / verify)

  
  
  
  
  

  ---

  
  

  15. Change the macro you created on the Quick Access Toolbar to a happy face icon.(macro / verify)

  
  
  
  
  

  ---

  
  

  Thank you for your time today.

  
  
  

  ---

  
  
  
  Tim Owens
  
  Saving staffing agency owners millions in revenue since 2006
  Hero to the modern-day Admin Professional
  

  ---

  
  
  • 1. Over 20-years as a professional admin consultant
  • 2. Microsoft Certified Trainer (MCT)
  • 3. Microsoft Certified Systems Engineer (MCSE)
  • 4. Veteran - U.S. Marine Corps 1/9
  • 5. Live "on-site" Corporate Trainer for over 20 years
  • 6. Conducts Microsoft Word and Excel skills assessment for clients with their admin professional hires
  • 7. Remote training "live" / "online in real time" for Microsoft Office
  • 8. Admin Professional consultant available for hire
  • 9. Available for remote consulting and advising
  • 10. Public Speaker
  • 11. Training available world-wide

  Contact Tim Owens. Please leave a message.
  Phone
  1-(310) 625-7711
  Unfortunately no texting
  Los Angeles office
  Email
  tvowens@outlook.com