LSU_ALPHA_LIST Report

In this topic you will learn how to run the LSU_ALPHA_LIST Report.

Steps:

1. Enter the desired information into the begins with field. Enter

    a valid value
    e.g.
    "LSU_ALPHA"
   .
   Step 1

2. Click the Search button.

   Step 2

3. Click the Edit link.

   Step 3

4. You will add a column to the existing query. On the Query tab, select record A: Job - EE Job History record and check the FTE option.

    

   Click the Query tab.

   Step 4

5. Click the Show Fields button for Record A Job - EE Job History.

   Step 5

6. Click the Sort fields alphabetically button.

   Step 6

7. Click the View 100 link.

   Step 7

8. Click the Down button of the scrollbar.

   Step 8

9. Click the Select option for FTE - FTE.

   Step 9

10. Click the Fields tab.

    Step 10

11. Click the Add Criteria button.

    Step 11

12. Enter the desired information into the Constant field. Enter "5 - character Business Unit".

     

    NOTE: In this example the EKLMC BU is used.

     

     

    Step 12

13. Click the OK button.

    Step 13

14. FTE displays as a Record.Fieldname.

     

    Click the Run tab.

    Step 14

15. NOTE: Queries should always be run in HTML format first to ensure that all data is viewed.

     

    Click the Download to Excel link.

     

    This will open a new window.

    Step 15

16. Click the Open button.

    Step 16

17. NOTE: Employee names, NIDs, Monthly Rates and  Hrly Rates have been removed for training purposes only.

     

    Click the Page Layout tab.

    Step 17

18. Click the Print Titles button.

    Step 18

19. Click the Landscape option.

    Step 19

20. Click the button to the right of the Paper size field.

    Step 20

21. Click the Legal option.

    Step 21

22. Click the OK menu.

    Step 22

23. The following topics will be demonstrated in this topic:

    •  Find and Replace;

    •  Sort;

    •  Subtotal;

    •  Formulas;

    •  Add/Delete Sheet; and

    •  Add/Delete columns.

    Step 23

24. Find and Replace

     

    Click the Home tab.

    Step 24

25. Click in the H3 field.

    Step 25

26. Click the Find & Select button.

    Step 26

27. Click the Replace... menu.

    Step 27

28. Enter the desired information into the Find what field. Enter

     a valid value
     e.g.
     "RN 2"
    .
    Step 28

29. Enter the desired information into the Replace with field. Enter

     a valid value
     e.g.
     "REG NURSE 2"
    .
    Step 29

30. Click the Replace All button.

    Step 30

31. Click the OK button.

    Step 31

32. Click the Close button.

    Step 32

33. Sort

     

    Click the Data option.

    Step 33

34. Click the Sort option.

    Step 34

35. Click the button to the right of the Sort by field.

    Step 35

36. Click the DeptID option.

    Step 36

37. Click the Add Level button.

    Step 37

38. Click the button to the right of the Then by field.

    Step 38

39. Click the Desc option.

    Step 39

40. Click the OK button.

    Step 40

41. Subtotal

     

    Click the Subtotals button.

    Step 41

42. Click the button to the right of the At each change in: field.

    Step 42

43. Click the DeptID option.

    Step 43

44. Click the OK button.

    Step 44

45. Add a Column

     

    Click the G cell to highlight the entire column.

    Step 45

46. Right-click the highlighted area.

    Step 46

47. Click the Insert option.

    Step 47

48. Click the G2 cell.

     

    Enter the desired information into the G2 field. Enter

     a valid value
     e.g.
     "Yearly Rt"
    .
    Step 48

49. Formulas

     

    You will multiply the number of hours worked in a year (2080) by the FTE and Hrly Rt to calculate the Yearly Rt.

     

    Enter the desired information into the G3 field. Enter

     a valid value
     e.g.
     "=2080*"
    .
    Step 49

50. Click the L3 cell.

    Step 50

51. Enter the desired information into the field. Enter

     a valid value
     e.g.
     "*"
    .
    Step 51

52. Click the M3 cell.

    Step 52

53. Press [Enter].

    Step 53

54. Right-click the G3 cell.

    Step 54

55. Click the Copy option.

    Step 55

56. In the G4 cell, press the left mouse button and drag the mouse down to highlight cells G4 thru G96.

    Step 56

57. Right-click the desired object.

    Step 57

58. Click the Paste option.

    Step 58

59. Click the Office button.

    Step 59

60. Point to the Print menu.

    Step 60

61. Click the Print Preview menu.

    Step 61

62. Click the Close Print Preview button.

    Step 62

63. Page Breaks

     

    Click the 23 cell.

    Step 63

64. Click the Breaks button.

    Step 64

65. Click the Insert Page Break list item.

    Step 65

66. The page break is inserted above line 23 on the worksheet. The page break is designated by the dashed line.

    Step 66

67. Add Sheet

     

    Click the Home button.

    Step 67

68. Click the button to the right of the Insert field.

    Step 68

69. Click the Insert Sheet list item.

    Step 69

70. Click the sheet 1 horizontal tab.

    Step 70

71. Click on cell A, press the left mouse button and drag the mouse to the right to highlight columns A thru M.

    Step 71

72. Right-click the highlighted area.

    Step 72

73. Click the Copy option.

    Step 73

74. Click the Sheet 2 horizontal tab.

    Step 74

75. Right-click the A1 cell.

    Step 75

76. Click the Paste option.

    Step 76

77. You may need to resize the columns so that the data will display properly.

    Step 77

78. Click the button to the right of the Delete field.

    Step 78

79. Click the Delete Sheet list item.

    Step 79

80. Click the Delete button.

    Step 80

81. Sheet Title

     

    Double-click the sheet 1 horizontal tab.

    Step 81

82. Enter the desired information into the sheet 1 field. Enter

     a valid value
     e.g.
     "ALPHA LIST"
    .
    Step 82

83. Click the G cell to highlight the entire column.

    Step 83

84. Right-click the highlighted area.

    Step 84

85. Click the Delete option.

    Step 85

86. Unhide

     

    Click the A cell, press the left mouse button and drag the mouse to the right to highlight all columns.

    Step 86

87. Right-click the highlighted area.

    Step 87

88. Click the Unhide option.

    Step 88

This completes LSU_ALPHA_LIST Report.

Table of Contents  Start Topic