training

Hi fellow Excel fans! I'm about to do some Excel training for a group of people. Some of the topics are: IF, SUMIF, Pivot Tables, and VLOOKUP. I'm looking for inspiration to the specific assignments and examples that I'm going to use in the training. What do you guys use IF, SUMIF, Pivot...

Hi, I am looking for some help with a formula. I am creating a training matrix. the training values are 1,2,3,4 (1=training, 2=trained with minimal supervision, 4 = fully trained etc) My current formula is.. =COUNTIF(AR7:BB7,">1")*4 AR7:BB7 is my range I'm looking at, ">1" is saying count...

I am working on building a simple database for employee training records. Some of our specific training must be renewed on an annual basis. I am trying to format cells to change color when a date exceeds a specific amount of time. At the top of the data sheet I have a cell that displays the...

Hi, I am using a pivot table to display data. In the pivot table I have countries and under each country couple of names. Then how many training a person led and how big attendance there was. <tbody> Completed Cancelled Count of Title Sum of Attendance Count of Title Sum of Attendance...

Hi! I'm trying to enter a formula on a master sheet that would take information from 3 workbooks and summarize the data by date, and task. Here is data for 12/1/2017, and the master sheet is below. Does anyone have any ideas? Thank ;you <tbody> West 2017: Workbook 1 Date Task Time...

Good evening. The spreadsheet I've been working on is for my students to use as their training log. I've been trying to make the lists in the column of Exercise 1 and 2 dependent on the Training Split. Meaning when a person picks a training split like Legs And Back or Flexibility, all the...

I am creating a worksheet for training. Easy enough. In that worksheet I am creating drop down lists for hours trained. Easy enough. Now the issue - I need certain numbers on the list to automatically change the cell (or number) to red. This will signify the person is short on training...

Hi all Please advise for some "Advanced Access Macros Training" I'm working few years with Access + VBA, and i'm very successful, but for MACROS (not VBA) i can't find any advanced training. Thanks in advance.

Hi, I would like to know is it possible to create a dynamic link that i can select different worksheet in excel. Example: i) Once i have create the macro i will link it to a button on cell A20 and it will select sheet"1000 Training". ii) I will copy the button to A21 and it will select the...

I need your help excel heroes in debunking this formula. What's the formula if i want to automatically mark x in worksheet 1 if john's training result in worksheet 2 is pass Worksheet 1 <tbody> name safety training John x </tbody> Worksheet 2 <tbody> Name...

Hello, I have a large database at work for training. I have a lot of information on the individuals including their unique training card number (in the below format). I wanted excel to show a result including date and the total number of new training cards issued that day but the training...

Hi can anyone recommend some good sites or books for a rookie to provide a basic understanding of VBA in Excel? Any hints gratefully appreciated! Ali

I have a formula that calculates how many topics deserve how many days that topic deserves in a 50 day training schedule. Trying to assign those topics to a 50 day training schedule automatically, based on how many days were assigned for those topics.

I have a Training Spreadsheet which houses all training courses held for a company throughout the year. I want to be able to filter (slicer) by year, so I have created a table of fiscal years (dates) and the year that I would like to return as below: Fiscal Start Fiscal End Return...

Hi, I need to get the list of training records for a particular employee from the overall employee training matrix in different sheet. Attached the requirement in sample sheet. sheet 1 (data) is the training matrix and sheet 2 (summary) is where I need the formula to retrieve the info based on...

From where I get free Excel Training from Beginner to Advance level.

Hi, I've currently got; =COUNTIFS(INDEX('Training Levels'!B5:K32,MATCH(Shifts!A$5,'Training Levels'!A5:A32,0),MATCH(Shifts!A4,'Training Levels'!B4:K4,0)),1,Shifts!B5,"ASH") But I'm looking to do this for everyone row that meets this criteria between B5:B35. Something I thought but doesn't...

Hi All, I'm new to access and looking for some advice on how to redo an excel staff training database in Access. In excel, I have a userform that will search a worksheet of staff members (with ID number, department, position etc) and add them to an "Attended" worksheet, which contains training...

I have a evaluation form that I NEED help with. There are 4 Rating levels to choose, E, S, NI, and NA with a value of 3, 2, 1, and 0. Each Category (Blue row) has subtask (Green rows) with a percentage weight for each. In the example below, you can see in Column F that each weight is 25% for...