340 likes | 354 Vues
Learn effective file management strategies including date modification, word processing, proofreading, Excel functions, and mail merge integration for improved productivity and organization.
E N D
File management Perez
1.12 Date modified FIRST Perez
Word Perez
2.4 cm3 Superscript Perez
2.5 Tabs Leading Decimal (Money) Left Perez
2.9 Accent Insert, Symbol, Normal text Perez
2.12 Proof reading Transpose Delete Perez
3.2.2 Outline numbering Level 1 Level 2 Perez
3.4.2 Split table Click where you want the split
3.4.4 Inside lines Click the Inside lines
3.5.2 Sort Cost in rand Select table Descending No header row Perez
Excel Perez
4.3 Date format Custom format as Month and then Day Type it in yourself Mmm-dd
4.4 Round and Average Round to 0 decimals Average Perez
4.6 Nested IF Perez
5.1.2 Left, Right, Concatenate Left Right Concatenate Perez
5.1.3 If Perez
5.1.4 Minutes used in January by Golden clients =SUMIF(K5:K11,"Golden client",D5:D11) Perez 19
Access Perez
6.2.3 Total number of clients Sorting and Grouping Yes In Group Footer add Formula
6.3.5 *@* Rule Message Perez
Integration Perez
7.1.1 Insert chart, then two columns 2 columns Line Select JUST the required text and graph Perez
7.1.3 Insert linked data Edit Paste Special Microsoft Office Excel
7.2 Import spreadsheet into database -1/2 File, Get External Data Excel
7.2 Import spreadsheet into database – 2/2 First Row Contains Column Headings
7.3 Mailmerge 1/7 Link to data source Open data source on Mail merge toolbar Select data source Mdb
7.3 Mailmerge 2/7 Link to correct table in data source Select correct table in the database Perez
7.3 Mailmerge 3/7 Have to select those with correct age
7.3 Mailmerge 4/7 Get correct age group Advanced Get the correct age
7.3 Mailmerge 5/7 Sort according to Surname Just click on Surname
7.3 Mailmerge 6/7 Insert Merge Fields
7.3 Mailmerge 7/7 Merge to New Document Perez