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.
Strong verbal and written communication skills are some of the most important qualifications for an administrative assistant. For an executive assistant, communication is the most important skill. A large part of the job involves speaking with people at all levels within the company, as well as clients and customers. You'll also need to write letters, memos and prepare reports and information for distribution.