When dates in a worksheet aren't in the order you want, you can sort them. For example, you can sort them from oldest on top to newest on top. Drag down the column to select the dates you want to sort. Click Home tab > arrow under Sort & Filter, and then click Sort Oldest to Newest, or Sort Newest to Oldest.
Scheduling meetings, travel plans, billing, etc. will all require a successful personal assistant to have terrific organizational skills. Computer Skills: Writing emails, transcribing notes, faxing, copying, and creating spreadsheets or printing documents figure heavily in an personal assistant's day.
Download OfficeTeam and IAAP's Office of the Future Guide to learn more about in-demand skills shared among the best administrative professionals. Strong computer and internet research skills An executive assistant's computer proficiency must extend beyond spreadsheet management and word processing. Executive assistants often use their computer-based skills to maintain company records, set up filing systems or digitally manage daily operations. You may also be asked to take on special projects usually outside the realm of the administrative assistant, such as conducting market research for statistical reports.