Excel Intermediate Skills

In: Computers and Technology

Submitted By Skyriter
Words 617
Pages 3
EXCEL INTERMEDIATE SKILLS
Customer’s Name:
Institution Affiliation:
Date:

WORKDAY.INTL Function
This is only available in Microsoft Excel 2010. It is a modification of the WORKDAY date function in Microsoft Excel 2007. While the WORKDAY function is useful in cases where the weekend days are predetermined, WORKDAY.INTL is useful in cases where the weekend days are neither Saturday nor Sunday. It is also useful in a location where they are single weekend days.
WORKDAY.INTL is useful in finding the date that a project is ending or starting given the duration the project will take (Microsoft, 2012). This function automatically omits the days regarded as weekend days and the statutory holidays. Unlike the WORKDAY function, it allows the user to spell out which days are weekdays and which days are weekend. In fact, the user is at liberty to do away with all the weekends. It does not automatically set two days as weekend days without the user’s consent.
A user can employ WORKDAY.INTL in calculating several applications. These include calculating the due date of an invoice; the probable delivery dates for materials or goods; the date a project is ending if the starting date and number of workdays of the same project is specified; and the date a project is starting given the end date of the same project and the number of workdays (Microsoft, 2012).
Syntax and Argument
Syntax is the layout of a function. It comprises of the name of the function, bracket, and its arguments. The syntax of WORKDAY.INTL is as below:
WORKDAY.INTL (Start_date, Days, Weekend, Holidays)
It is important to that the user should use a date function to enter the start date. A problem arises if the user enters the date as text.
The syntax above contains four arguments namely: Start_date, Weekend, Days, and Holidays. The Start_date argument represents the date the project is supposed to start.…...

Similar Documents

Excel

...Applied Statistics Microsoft Excel Decomposition may reduce appeal emphasis on applications. Flow charts help make the analysis decision by identifying technique, computing statistics, and interpreting results. Associated data set accompanies the set purports to build a excel spreadsheet that discovers formula, illustrates the parameters, observes dynamic graphs and simulations that recodes, edits, validate, charts, and automatically links equations, data, and formulas to recalculate the data analysis. Excel recognizes statistical capability conjunction that carries out complex algorithms that implement correlated data columns. Excel quickly analyzes and interprets information filtered into a spreadsheet so the process is much easier then working out these formulas by hand. Excel spreadsheets create charts, graphs, and filters data all into one. Excel uses all of the basic mathematical operations such as addition, subtraction, division, and multiplication. Fractions and decimals are just as common for interpretation data into a excel spreadsheet. An advantage about excel is you can place any formula into the spreadsheet whether in ascending or descending order and using the same formula, it will automatically compute the answer for the next equation. Another advantage is if information is inaccurate, you can go back and check your work with just a click, unlike using y calculations or by hand you have to erase so much and start all over again, which could be time...

Words: 377 - Pages: 2

Intermediate

...CONTENTS Preface to the Instructor Chapter 1 Chapter 2 Chapter 3 Chapter 4 Chapter 5 Chapter 6 Chapter 7 Chapter 8 Chapter 9 Chapter 10 Chapter 11 Chapter 12 Chapter 13 Chapter 14 Chapter 15 Chapter 16 Chapter 17 Chapter 18 Chapter 19 Chapter 20 Chapter 21 Chapter 22 Chapter 23 Chapter 24 Financial Accounting and Accounting Standards Conceptual Framework Underlying Financial Accounting The Accounting Information System Income Statement and Related Information Balance Sheet and Statement of Cash Flows Accounting and the Time Value of Money Cash and Receivables Valuation of Inventories: A Cost Basis Approach Inventories: Additional Valuation Issues Acquisition and Disposition of Property, Plant, and Equipment Depreciation, Impairments, and Depletion Intangible Assets Current Liabilities and Contingencies Long-Term Liabilities Stockholders’ Equity Dilutive Securities and Earnings Per Share Investments Revenue Recognition Accounting for Income Taxes Accounting for Pensions and Postretirement Benefits Accounting for Leases Accounting Changes and Error Analysis Statement of Cash Flows Full Disclosure in Financial Reporting iii PREFACE—TO THE INSTRUCTOR The presentation of the subject matter in each of the chapters in Intermediate Accounting, 12e is followed by questions, brief exercises, exercises, problems, and concepts for analysis. Another section entitled “Using Your Judgment” is also provided (financial reporting, financial statement analysis, comparative analysis...

Words: 406105 - Pages: 1625

Excel

... both of these constraints should be entered is shown below: a. Cell reference entry: D6 / Operator: >= / Constraint entry: d9*28% b. Cell reference entry: D6 / Operator: <= / Constraint entry: d9*32% 3. Laser Imaging machines (D7) should be greater than or equal to 28% of the total machines produced (d9*28%); also enter a constraint for less than or equal to 32% (d9*32%) 4. Magnes machines (D8) should be greater than or equal to 38% of the total machines produced (d9*38%); also enter a constraint for less than or equal to 42% 5. Number to make (D6:D8) must be whole units (use int) Verify that all parameters have been entered (set objective, changing cells and constraints), Solve and create an Answer Report. Resave your practice exam. This will still be a macro-enabled file. If you want feedback on your practice exam, please upload your file to Oncourse / Assignment 2 / Excel Case Practice link. On test day you will submit your completed exam to the Oncourse Assignment2 link....

Words: 1218 - Pages: 5

Excel

...Terms Definitions The First step in creating an effective workseet is to make sure you __________. Understand what is required In Excel, a number can contain the charaters ________. 0 1 2 3 4 5 6 7 8 9 The cell being copied is called the source area (copy area). The range of cells recieving the copy is called the ________. receiving range You ________ a worksheet to emphasize certain entires and make the worksheet easier to read and understand. Format Pressing the _________ keyboard shorcut key(s) selects cell A1. CTRL + HOME How many chart types does Excel offer? 11 Which of the following keys is an alternative to double-clicking the cell to edit it? F2 Which of the following Opton buttons gives options for filling cells following a fill operation? Auto Fill Options A ________ cell in Excel has a numerical value of zero. Blank The ________ AutoComplete list contains those functiond that akohabetically match the letters you type following thr equal sign. Formula The most popular background color is _______. White ________ text often provides a strong visual appeal. Underlined To open the format cells dialog box with the Alignment sheet active, click the Format Cells ________. Dialog Box Launcher Which of the following is an extension of the fill patten Sunday, Tuesday? Thursday, Saturday, Monday Which of the following formula contains the absolute cell reference? =$B$4 A(n) _______ chart provides a simple way to show trends and variatons in a range of...

Words: 423 - Pages: 2

Digi Excel

...EXCEL DIGI LAB Hemant Yashwant Satpute Electronic Science Department, Fergusson College, Pune 4 [Affiliated to University of Pune] India (Maharashtra) hys0671@rediffmail.com Abstract Being a teacher, my aim is to always encourage students and other colleague teachers to make optimum use of PC machine which one has purchased and full functionality of the softwares available with that machine. As an example, here I am illustrating use of EXCEL to learn Digital Electronics. One can verify Truth tables and study the working of various logic gates (AND, OR, NOT, EXOR, EXNOR, NAND, NOR), Various combinational logic circuits like Half Adder, Full Adder, Controlled Inverter, Multi bit adder, Multi bit subtractor, Multi bit adder Subtractor, Multiplexers, Demultiplexers, Shift Registers, Flip flops, Counters, Parity Generators and checkers using EXOR gates, Encoders, Decoders, Controlled Inverter using EXOR gates and their uses and many more, by entering inputs directly and verifying outputs at various intermediate stages. One can also study use of universal gates to build various logic functions with the help of this tool. These outputs are derived by using various functions built in EXCEL. This was demonstrated to teachers and students. This idea helps teachers to make subject more illustrative and interesting. It has been proved to be an excellent tool for innovative class room teaching. This can be used as a learning material for open source learning and...

Words: 2004 - Pages: 9

Stude Skill

... isnecessary to feel good about yourself especially for who study in nursing field. Also personal development helps you to adjust whatever thesituation. You can improve and develop yourpersonality by supporting the community around you(Carolyn Jackson , Claire Thurgate , 2011). Personal development for nursing student is the notions of framework in nursing education where it provide the abilityto have enhanced professional vocational, ameliorate the quality of caring of the patient and Standards forstudentretention. Also, it is about the skill of developing goals setting up, and asses the needs of others (Meleis, 2011). There are four components of personal development which include reflective writing, learning from experience, cognitive process and developing analytical skills. These four components coexist with the professional development of nurses. Achieving personal development for a nurse will guarantee more career's success and better professionalism approach (Jasper, 2011). Another important component for nursing success is time management. Time management can be defined as the ability to plan schedule ahead and setting the tasks to be done over a specific period of time. An effective time management plan requires high productivity ratio which is the sum of the output over the input effort done. The high productivity cannot be achieved without strictlysticking to the time plan, reviewing the daily schedule, keep tracking the tasks completed, staying focused on the...

Words: 756 - Pages: 4

Skill Development

...Skill Development Assignment 1 Devry University MGMT 592: Leadership in the 21st Century Dr. Erickson January 13, 2013 Upon completion of reading the material on the traits of effective leaders I have determined my strengths and areas of improvement. This exercise will allow me to be refreshed in the areas of expertise while also allowing me to discover which areas I should seek improvement. The following three traits of my strengths are which I have learned and mastered over my lifetime of professional and military experience. Three Strengths: 1. Self-confidence - Self-confidence specifies self-assurance in judgments, decision making ideas, and capabilities (2010, Lussier). This area is my best trait due to my military background. Prior to entering the military I had very little self-confidence that resulted in not achieving my full potential. The military has taught me to be very self-confident and it allowed me to not have any self-doubt when I am on an assignment or any other type of endeavor. Therefore, I have carried over from what I have obtained from my military experience to my professional career and it has allowed me to contribute to my organization successfully and to receive positive feedback from upper management. 2. Integrity – Integrity refers to behavior that honest and ethical that can make one trustworthy to others (2010, Lussier). It is also linked with self-confidence because it takes self-confidence to be an honest and...

Words: 970 - Pages: 4

Excel Intermediate Skills

...EXCEL INTERMEDIATE SKILLS Customer’s Name: Institution Affiliation: Date: WORKDAY.INTL Function This is only available in Microsoft Excel 2010. It is a modification of the WORKDAY date function in Microsoft Excel 2007. While the WORKDAY function is useful in cases where the weekend days are predetermined, WORKDAY.INTL is useful in cases where the weekend days are neither Saturday nor Sunday. It is also useful in a location where they are single weekend days. WORKDAY.INTL is useful in finding the date that a project is ending or starting given the duration the project will take (Microsoft, 2012). This function automatically omits the days regarded as weekend days and the statutory holidays. Unlike the WORKDAY function, it allows the user to spell out which days are weekdays and which days are weekend. In fact, the user is at liberty to do away with all the weekends. It does not automatically set two days as weekend days without the user’s consent. A user can employ WORKDAY.INTL in calculating several applications. These include calculating the due date of an invoice; the probable delivery dates for materials or goods; the date a project is ending if the starting date and number of workdays of the same project is specified; and the date a project is starting given the end date of the same project and the number of workdays (Microsoft, 2012). Syntax and Argument Syntax is the layout of a function. It comprises of the name of the function, bracket, and its arguments...

Words: 617 - Pages: 3

Excel

...ADVANCED EXCEL TRAINING Quality Management Objective  To provide the participants with an understanding of the advanced features of MS Excel Today is 7/22/2011 2 Advanced  ® EXCEL Topics Working with Data Lists Naming Cells and Ranges   Conditional Functions Lookup Functions   Pivot Tables Data Validation  Today is 7/22/2011 3 Naming Cells and Ranges Today is 7/22/2011 4 Name cells by using labels Name cells by using existing row and column labels Select the range you want to name, including the row or column labels. On In the Insert menu, point to Name, and then click Create. the Create names in box, designate the location that contains the labels by selecting the Top row, Left column, Bottom row, or Right column check box. Note A name created by using this procedure refers only to the cells that contain values and does not include the existing row and column labels. Today is 7/22/2011 5 Name a Cell or Range Using Names Box  1. Select the cell or range you want to name.  2. Click the Name box on the formula bar.  3. Type a name for the range. A range name can include uppercase or lowercase letters, numbers, and punctuation, but no spaces. Try to use a simple name that reflects the type of information in the range, such as BookTitle.  4. Press Enter. The range name will appear in the Name box whenever you select the range. Today is 7/22/2011 6 Conditional...

Words: 1579 - Pages: 7

Presentation Skill

...The talk is about how to make an effective presentation and the presenter is Professor Pete Lane, the Chair of Marketing Department of WSBE. If you have a good idea but cannot present well, and your idea is lose out. Fortunate, the presentation skill can be learn and develop. Built an effective presentation need focus to the four dimension, there are developing a presentation strategy, create the story line, create slides that work and present looking someone like pro. Developed a presentation strategy has three idea. Firstly, you have to known what is the purpose of your presentation. For example, are you going to persuade, or to make recommendation, or just giving information to your audience. Secondly, who is your primary audience and thinking about them when you design your presentation. Lastly, did the organization requirement the presentation? Normally, organization have stated norm requirement for how you put information together, and make sure you understand what that is. A very good organization also will include feedback on how you present. Story line is a compelling narrative that drawn your audience into your view of the word. The presentation need to starting strong and has a strong introduction. You can open with brief problem statement, list types of analyses done, and brief summary of insight and recommendation. This is very important to let people have a sense where you will go. Then, build solid logic into your presentation. Mean you have...

Words: 538 - Pages: 3

Excel

...Function keys editing in a cell is turned off SHIFT+F2 adds or edits a cell comment. in excel ALT+F1 creates a chart of the data in the current range ALT+SHIFT insert a new worksheet Edits the active cell and positions the insertion point at the end of the cell contents. It also moves the insertion point into the Formula Bar when CTRL+F2 displays the Print Preview window When a cell reference or range is selected in a formula, F4 cycles through the various combinations of absolute and relative references. CTRL+F4 closes the selected workbook window Switches between the worksheet, Ribbon, task pane, and Zoom controls. In a worksheet that has been split (View menu, Manage This Window, Freeze Panes, Split Window command), F6 includes the split panes when switching between panes and the Ribbon area. SHIFT+F6 switches between the worksheet, Zoom controls, task pane, and Ribbon. CTRL+F6 switches to the next workbook window when more than one workbook window is open. Calculates all worksheets in all open workbooks. SHIFT+F9 calculates the active worksheet. CTRL+ALT+F9 calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation. CTRL+ALT+SHIFT+F9 rechecks dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated. CTRL+F9 minimizes a workbook window to an icon. Creates a chart of the data in the current range. SHIFT+F11 inserts a new......

Words: 274 - Pages: 2

Excel

...New Perspectives Excel 2013 Tutorial 3: SAM Project 1a Spring Software ENHANCE A TIMESHEET Project Goal M Project Name Project Goal New Perspectives Excel 2013 Tutorial 3: SAM Project 1a Spring Software ENHANCE A TIMESHEET Project Goal M Project Name Project Goal PROJECT DESCRIPTION Devon Hastings is the human resources director for Spring Software, a software development company in Cambridge, Massachusetts. He has created a workbook for employees to use in recording the hours they work. He would like your help finishing the timesheet. GETTING STARTED * Download the following file from the SAM website: * NP_Excel2013_T3_P1a_FirstLastName_1.xlsx * Open the file you just downloaded and save it with the name: * NP_Excel2013_T3_P1a_FirstLastName_2.xlsx * Hint: If you do not see the .xlsx file extension in the Save file dialog box, do not type it. Excel will add the file extension for you automatically. * With the file NP_Excel2013_T3_P1a_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. If cell B6 does not display your name, delete the file and download a new copy from the SAM website. PROJECT STEPS 1. On the Employee List worksheet, select cells A1:B1 and then use the Format Painter copy the format only to the range A2:B9. 2. In cell B1 enter bs001, in cell B2 enter cg001, in cell B3 type dh001, and then use Flash...

Words: 790 - Pages: 4

Excel

... outcome is more likely to be positive. UAP often receive a work assignment consistent with their job description and consequently the RN takes for granted the assignment will be completed with minimal communication (Potter et al., 2010). As noted, the care delivery model can facilitate the frequency, quality, and timeliness of communication between the RN and the nursing assistant. Any care delivery model can build strategies to facilitate effective communication associated with the delegation process. These strategies include shift reports, huddles, rounds, and the use of communication technologies (portable phones, hands-free mobile communication). The RN may also establish bedside rounds with the nursing assistant at the beginning and end of a shift. What and When Can Nurses Delegate Delegation decisions must be based on the fundamental principle of public protection. The RN cannot delegate responsibilities requiring nursing judgments, such as patient assessment, care planning, and evaluation of care. To delegate a task, the RN must use judgment regarding the condition of the patient, the competence of UAP, and the degree of supervision needed (ANA, 2012; NCSBN, 2005). Specifically, the RN must evaluate the following: ⦁ Potential for harm. What is the likelihood of patient harm? The greater the potential for harm, the greater the need for the RN to render the care. ⦁ Complexity of care. Which cognitive and psychomotor skills are required?......

Words: 5394 - Pages: 22

Excel

... has FP rate of 0 and TP rate of 0, represented as point (0, 0). The “classification” that assigns “Test Positive” to every value has FP rate of 1 and TP rate of 1, represented as the point (1, 1). Joining all known (x, y) points by straight lines, the area under the resulting empirical ROC curve is known as the Area Under the Curve or AUC. The AUC ranges from 0.5, for a test no better than chance, to 1, for a perfect test. The Area Under the Curve is calculated by the summation of the average height multiplied by the width, as follows: ! ! T P (n) + T P (n + 1) 1 2 (F P (n + 1) F P (n)) See Excel Spreadsheets for examples of calculating each point on an empirical ROC Curve. 2 2.1 2.1.1 Information Measures Probability Review Basic Probability Definitions Joint probability: p(X, Y ) The probability that both X and Y are true. Joint probability is commutative: p(X, Y ) = p(Y, X). Conditional probability: p(X|Y ) The probability that X is true, given that Y is true. Note that “Rates,” PPV and NPV are Conditional Probabilities: True Positive Rate = p(T P T est|+), 3 False Negative Rate = p(F N T est|+), False Positive Rate = p(F P T est| ), True Negative Rate = p(T N T est| ), Positive Predictive Value = p(+|T est P ositive), Negative Predictive Value = p( |T est N egative). Marginal probability: p(X) The probability that X is true, independent of the value of Y. Product distribution: p(X)p(Y ) The product of two marginal...

Words: 4475 - Pages: 18

Intermediate

... Tax Accounting Career Path Intermediate Accounting II- Spring 2014 Submitted to Dr. Jeffery Hillard Dante Pennix Sr. April 21, 2014 My goal is to become a Certified Public Accountant while achieving the goal of owning a lucrative CPA firm. One of the great benefits of choosing tax accounting as a career is that you will always have a job when you graduate. Tax accountants and CPAs will always be in high demand as long as the globalizations of marketplaces continue to develop. Tax accountants also create tax strategies to reduce the amount of taxes a client owes while remaining compliant with GAAP and tax laws. The qualities of a tax accountant consist of begin able to be organized, competent, have an attention to detail, ethical, and most in important effective communications, both written and verbal. For example, common responsibilities for tax accountants include preparing and filing taxes, financial planning, completing continuing education credits, and researching and reviewing past tax filings. In summary, the career path of a tax accountant and CPA is very tedious and technical but overall, the journey is worthwhile. The reason why I elected tax accounting as a career path was because of the stability and longevity that it holds. Another reason I choose this career choice was for the challenging and gratifying work that it brings. Tax accounting is a specialized field because of the ever changing rules in the accounting arena as with new regulations and laws of...

Words: 805 - Pages: 4