SECRETARIAT TRAINING INSTITUTE STAFF DEVELOPMENT
04-Jul-2023 • Basics of Microsoft Office. (MS Word/ Power point/Excel). • Practical Exercises. Capacity Building in required skills. Stenotypists/ UDCs ...
ms-excel-exercises.pdf
MS Excel Exercises. Page 2. BIS202 Exercises. 2
Page. Exercise 1. Objectives: ▻ Introduction to MS Excel files Workbooks
Columns and Rows.
Excel functions you will need to use in the practical exercises
There are several versions of Microsoft Excel available for both Mac and Windows operating systems. The version of Excel you have will require. VBA
2017 Excel Lab Exercises Practice and Take home
Excel Practice Exercises Lab Session #1. Simple arithmetic. 3. Extending an Microsoft excel 2007 or later as follows: =SUMIFS(C2:C9 A2:A9
Microsoft Excel Part 1: Creating Workbooks
09-Jan-2020 xlsx workbook to practice. Freezing Rows And/Or Columns: You may want ... Single Argument Exercise: Open WeekOne worksheet Excel Part4 Functions.
Excel Practice Spreadsheet
Once you have launched Microsoft Excel you should see the program interface with a blank worksheet labeled “Workbook1”. Page 2. • Choose File > Open then
Excel-Fundamentals-Manual.pdf
☐. Page 60. Microsoft Excel 2013 - Level 1. © Watsonia Publishing. Page 56. Chapter 10 - Practice Exercise. PRACTICE EXERCISE SAMPLE. Creating Charts. A. B.
EXCEL BASICS: PROJECTS
Before you begin working on the exercises in the practice workbook you should learn how to open a blank workbook
Microsoft Excel 2016 LEVEL 1
Exercise – “Welcome to Excel Read the instructions and complete the exercises to learn and practice more ...
Information Technology (ITCC)
The course will be taught with a mixture of analytical methods and practical exercises. Students will use Microsoft Excel® to create and format spreadsheets;
Microsoft Excel for Beginners
16 Jan 2018 Microsoft Excel for Beginners ... Microsoft Excel is a spreadsheet program. We use it to ... Exercise 2: Quarter Total .
Word and Excel Practice Exercise
This exercise requires you to use the following: • Microsoft Excel for creating tables scatter plots
Microsoft Excel Exercises For Beginners (PDF) - m.central.edu
23 Jun 2022 manuals for Microsoft Excel 2019 for Lawyers. 479 pages and 224 individual topics. Includes practice exercises and keyboard shortcuts.
Excel practice exercises vlookup pdf
From novices to advanced types practice exercises help to grow keyboard skills with stretch fingers
Microsoft Excel 2016 LEVEL 1
In this class you will learn the basics of Excel and work on a What is Microsoft Excel? ... complete the exercises to learn and practice.
advanced excel – vlookup hlookup and pivot tables
25 Feb 2014 Drag the arrow to column D. 25. A dotted line appears around the selected data. 26. Excel places the name of the file worksheet
Intermediate Microsoft Excel: Practice 1
Microsoft Excel Practice Exercises. Page 1. Intermediate Microsoft. ®. Excel: Practice 1 Save the spreadsheet and name it: Excel Intermediate Practice 1 ...
Microsoft Excel Part 1: Creating Workbooks
09 Jan 2020 Microsoft Excel 2016: Part 4 ... Exercise Part 1-3: ... use WeekOne worksheet in the same Excel Part4 Functions.xlsx workbook to practice.
Introduction to MS EXCEL 2010
Getting started with Microsoft Excel . MS Excel Practical Exercise . ... This document is an updated version of the Introduction to MS Excel 2007 guide ...
Excel Advanced
However the power of the advance filter tool really shines Excel's traditional formulas do not work on filtered data since the function will be ...
Comma ProductionsMicrosoft Excel Practice ExercisesPage1 IntermediateMicrosoft®Excel: Practice1RUBRIC035810Less than 25% ofitems completedcorrectly.More than 25%of itemscompletedcorrectlyMore than 50%of itemscompletedcorrectlyMore than 75%of itemscompletedcorrectlyAll itemscompletedcorrectlyEach step to complete is considered a single item, even if it is part of a larger string of steps.Objectives:The Learner will be able to1. Apply Currency formatting to cells in Excel2. Use the AutoSum tool to add cells3. Use the Function tool to calculate the average of a range of cells4. Insert an IF function5. Rename spreadsheetEnter the labelsandformat the labels big, bold, and centerediIn Cell A1 type: First NameiIn Cell B1 type: Last NameiIn Cell C1type: DepartmentiIn Cell D1 type: SalaryAdd the dataType at least fivesamplerecords. For example:ABCD1First NameLast NameDepartmentSalary2DeeterPoohbahTraining$34,000Format the ColumnsSelect column D and use the Currency toolCreating EquationsSelect Cell D7 and use AutoSum to add up the SUMof the Salaries in the D Column.Select Cell D8 and useInsertFunction tocalculatethe AVERAGEof the Salaries.Using IF functionsThis activity compares the employee"s salary withthe Average in Cell D8.Insert the label "Compare" into cell E1In E2, insert the IF function.In the Wizard, enter the following informationLogical Test: D2>D8Value_if_true: "Above"Value_if_false: "Below"Use the Insert Function wizard to put the correct formula for the remaining cells.Savethe spreadsheetand name it:Excel Intermediate Practice1
Comma ProductionsMicrosoft Excel Practice ExercisesPage2IntermediateMicrosoft®Excel: Practice 2Objectives:The Learner will be able to:1.Explain what labels are2.Sort Excel data by using the labels in the header row3. Create a Custom Sort4. Modify the Custom Sort Order5.Change Page Orientation6. Create Custom headers and footers7. Save the spreadsheetWork with Sample DataType the given sample data in a new sheet.When prompted, SAVE toyourDocumentsfolderReview the DataABCDEF1MonthClientCategoryServiceClassDate2JanuaryRick TownerPrivateTrainingAccess1/12/20043JanuaryDarlene DavisPrivateTrainingAccess1/15/20044JanuaryHometown CommunityCollegeEducationalTrainingWord1/15/20045FebruaryHometown CommunityCollegeEducationalTrainingPowerPoint02/05/20046FebruaryHarmony Kitchen And BathCorporateTrainingExcel02/07/20047FebruaryDatabase ConsultantsCorporateTrainingAccess02/10/20048FebruaryBay CountyGovernmentTrainingOutlook02/12/2004Sort the DataSelect the entire spreadsheetand Sort the data byMonthDid the Months sort as expected or did they sort alphabetically?Try the Sort again: use the CUSTOM SORT and change the Order to Custom ListModify the Page LayoutFormat the following Page Layout Options:Make the orientation "Landscape"Create a Custom Header andtype a samplecompany a name in the centerCreate a Custom Footer with the current date on the rightSavethe spreadsheetand name it:Excel Intermediate Practice 2
Comma ProductionsMicrosoft Excel Practice ExercisesPage3Intermediate Microsoft®Excel: Practice 3Objectives:The Learner will be able to:1.Enter data into a Spreadsheet2.Use AutoFill with labels, data and formulas3.Format CellBorders and Contents4.Calculate the total across the rows5.Calculate the total for each column6.Use Conditional FormattingABCDEFG1MondayTuesdayWednesdayThursdayFridaySaturdayTotal28888884834567888888488Overtime8Enter the Labels in the first rowIn Cell A1 type: MondayUse the AutoFill handle to add Tuesday through SaturdayCalculate the TotalIn Cell G1 type: TotalIn Cell G2 create the equation: =Sum(A2:F2)Use the AutoFill handle to fill down that equation to G6Calculate the Daily TotalEnter sample data in cell A2 through F2Select Cell A7 and AutoSum the totalUse the AutoFill handle to add this equation to Cells B7 throughG7Format the cellsMake the Labels BoldAlign all of the text Centered, in the middle of the cellsCalculate the overtime in Cell G8The equation in cell G8 would be: =G7-40Use Conditional Formatting on Cell G8Savethe spreadsheetand name it:Excel Intermediate Practice3
Comma ProductionsMicrosoft Excel Practice ExercisesPage4Intermediate Microsoft®Excel: Practice4Objectives:The Learner will be able to:1. Enter data into an Excel Spreadsheetat least 75% of the time2. Use Data Validation to create a DropDown Controlat least 75% of the time3. Rename a sheet in an Excel workbookat least 75% of the time4. Apply Conditional Formattingat least 75% of the time5. Use the Fill Down command6. Enter data using Drop Down Controlsat least 75% of the timeCreate alist of employeesType in the following information in Column ABill SmithKaylee WildHelen PulaskiCorey HaasAngelique RiolSelect the data and name the range. In the Name Boxtype: EmployeesName the sheet: EmployeesCreate a list of locations on another spreadsheet in the same workbookEnter the following Locations in Column Aand sort them A-ZAnn ArborBrightonLansingFlintDetroitGrand RapidsPontiacSelect the names and name the range. In the Name Box type: LocationName the sheet: LocationCreate a schedule on another spreadsheet in the same workbookRename Sheet3: ScheduleIn Cell A1 Type: Employee NameIn Cell A2, use Data Validation to create a Drop Down control using the "Employees" source.Include an Input Message that says: "Select an employeefrom the list"Fill down Five rowsIn Cell B1 Type: LocationIn Cell B2, use Data Validation to create a Drop Down control using "Location" as the sourceInclude and Input Message that says: "Select a Location from the list."Fill Down five rowsApplyConditional FormattingFill in 3 rows of Employees with locations.If the Location is Pontiac, format the text to be GREEN.Does Pontiac show up Green?;-)Savethe spreadsheetand name it:Excel Intermediate Practice4
quotesdbs_dbs2.pdfusesText_2[PDF] advanced excel practice exercises free
[PDF] advanced excel practice exercises online
[PDF] advanced excel practice exercises pdf
[PDF] advanced excel practice exercises xls
[PDF] advanced excel practice exercises xlsx
[PDF] advanced excel practice questions
[PDF] advanced excel practice test free
[PDF] advanced excel question paper
[PDF] advanced excel skills for accountants
[PDF] advanced excel skills list
[PDF] advanced excel skills pdf
[PDF] advanced excel skills resume
[PDF] advanced excel skills test
[PDF] advanced excel skills training
