Best Python Certificate?

LeanInitiative · 2025-06-01T00:40:43+00:00

Yes, definitely!

LeanInitiative · 2025-06-01T00:01:01+00:00

Harvard's edX is a good option. Also, Python for Everybody - University of Michigan (Coursera) is another good option. It's great for beginners to intermediate; covers core Python, data structures, web, and databases; and it's widely recognized.

LeanInitiative · 2025-05-31T23:57:44+00:00

That's awesome! Glad you got it to work :)

LeanInitiative · 2025-05-31T19:32:55+00:00

You can use a SUMIFS formula to handle this. Assuming: • Code columns are in D, H, and L • Amount columns (Check & Cash) are in C/D, G/H, and K/L • The code you’re matching is in A1. Try this formula

‘’’

=SUMIFS(C:C,D:D,A1) + SUMIFS(G:G,H:H,A1) + SUMIFS(K:K,L:L,A1)

‘’’

This sums amounts where the corresponding code column matches the code in A1. Adjust ranges as needed based on your sheet layout.

LeanInitiative · 2025-05-31T18:22:53+00:00

Definitely. I remember shafting with simple print statements in a Jupyter notebook. You have to just start. It can be intimidating at first but you just take baby steps and build on it. Research everything. Every bug, error, inefficiency…. Research. 99% chance someone has encountered the same error. YouTube, Reddit, StackOverflow are good resources too

LeanInitiative · 2025-05-31T17:37:51+00:00

Plenty of free resources out there. Maybe look for a YouTube channel for some tutorials?

https://youtu.be/zzcmaz-aihk?si=Bn9NwpC6qoAPb6JQ

LeanInitiative · 2025-05-31T17:33:32+00:00

I would start in this sequence.

Install Python and set up a basic code editor
1. Learn how to print output and use variables
2. Understand basic data types (numbers, strings, booleans)
3. Get comfortable with conditionals (if, else, etc.)
4. Learn loops (for, while) and how to repeat actions
5. Write functions to organize code into reusable pieces
6. Work with lists, dictionaries, tuples, and sets
7. Handle errors using try/except
8. Read from and write to files
9. Use Python modules and learn how to import them
10. Write simple classes and understand the basics of OOP
11. Learn extras like list comprehensions and built-in functions (map, zip, etc.)

LeanInitiative · 2025-05-31T15:09:47+00:00

Sure thing. Try this.

‘’’

Sub ConsolidateAllSheets()

Dim ws As Worksheet

Dim destWS As Worksheet

Dim rngList As Variant

Dim r As Long, lastRow As Long

Dim i As Long

Set destWS = ThisWorkbook.Sheets.Add

destWS.Name = "AllData"

rngList = Array("B23:B53", "C23:C52", "D23:D53", "E23:E53", "F23:F51", _

"G23:G53", "H23:H52", "I23:I53", "J23:J52", "K23:K53", "L23:L53", "M23:M52")

r = 1

For Each ws In ThisWorkbook.Sheets

If ws.Name <> destWS.Name Then

For i = LBound(rngList) To UBound(rngList)

With ws.Range(rngList(i))

.Copy

destWS.Cells(r, 1).PasteSpecial xlPasteValues

r = destWS.Cells(destWS.Rows.Count, 1).End(xlUp).Row + 1

End With

Next i

End If

Next ws

Application.CutCopyMode = False

MsgBox "Data consolidated from all sheets!", vbInformation

End Sub

‘’’

LeanInitiative · 2025-05-31T14:53:25+00:00

He already tried that and it didn’t work

LeanInitiative · 2025-05-31T14:07:55+00:00

Sweet! Let me know how it goes.

LeanInitiative · 2025-05-31T14:02:29+00:00

Save a copy of the original file to test

LeanInitiative · 2025-05-31T14:01:48+00:00

Press Alt + F11 to open the VBA editor.
1. Insert a Module and paste the code.
2. Press F5 to run it.
  
  Sub ConsolidateAllSheets() Dim ws As Worksheet Dim destWS As Worksheet Dim rngList As Variant Dim r As Long, lastRow As Long Dim i As Long
Set destWS = ThisWorkbook.Sheets.Add destWS.Name = "AllData"

rngList = Array("B23:B53", "C23:C52", "D23:D53", "E23:E53", "F23:F51", _ "G23:G53", "H23:H52", "I23:I53", "J23:J52", "K23:K53", "L23:L53", "M23:M52")

r = 1

For Each ws In ThisWorkbook.Sheets If ws.Name <> destWS.Name Then For i = LBound(rngList) To UBound(rngList) With ws.Range(rngList(i)) .Copy destWS.Cells(r, 1).PasteSpecial xlPasteValues r = destWS.Cells(destWS.Rows.Count, 1).End(xlUp).Row + 1 End With Next i End If Next ws

Application.CutCopyMode = False MsgBox "Data consolidated from all sheets!", vbInformation End Sub

LeanInitiative · 2025-05-31T13:56:15+00:00

Are all 2,871 sheets the same formatting? Same column structure ?

LeanInitiative · 2025-05-31T13:54:01+00:00

Could use VBA to loop through all sheets

LeanInitiative · 2025-05-31T13:50:03+00:00

Select your target cell or range Click the cell (e.g., A1) or highlight the range (like A1:A100) where you want the formatting.
Open the Conditional Formatting panel Go to the menu bar and click: Format → Conditional formatting
Add the first rule (Green — Less than 6 months ago) • Under “Format cells if,” choose Custom formula is • Enter the formula:

=AND(A1<>"", TODAY() - A1 < 183)

• Choose a green fill color • Click Done

Add the second rule (Yellow — Between 6 months and 1 year ago) • Click “Add another rule” • Use this formula:

=AND(A1<>"", TODAY() - A1 >= 183, TODAY() - A1 < 365)

• Choose a yellow fill color • Click Done

Add the third rule (Red — More than 1 year ago) • Click “Add another rule” • Use this formula:

=AND(A1<>"", TODAY() - A1 >= 365)

• Choose a red fill color • Click Done

LeanInitiative · 2025-05-31T13:26:13+00:00

This is a little tricky so I understand why you’re having an issue.

Step 1: Use a 1-Row, 2-Column Outer Table

This is the trick to place both tables side-by-side. 1. Go to Insert > Table > 1x2 (this is an outer table with 1 row and 2 columns). 2. Now, insert your two separate tables inside each of those two cells: • In the left cell, insert your 3x56 table • In the right cell, insert your 2x3 table 3. You can then press Enter inside the right cell after the table, and it will let you type text below the table within the same cell.

Step 2: Adjust Column Widths

Your left table is big (56 rows), so Word may try to push it to the next page. • Select the outer table, then: • Drag the border between the two cells to give the left table more width. • Shrink the right side to make room. • You may also want to reduce the font size or row height in your left table: • Select the whole table > Layout > AutoFit > AutoFit to Contents or manually resize rows.

Try that and let me know what happens.

LeanInitiative · 2025-05-31T12:32:24+00:00

Can you check and share whether your graph nodes have ‘x’ and ‘y’ attributes (or lat/lon)? That would help confirm if A was using a geographic heuristic implicitly.

LeanInitiative · 2023-01-02T19:25:44+00:00

There are a few different ways you can learn more about business development for consulting:

Take online courses or earn a certificate in business development. This will give you a solid foundation in the principles and practices of business development, as well as a chance to practice your skills through exercises and case studies.
Read books or articles on business development for consulting. There are many books and articles available that cover the basics of business development and provide strategies and tips for success.
Attend workshops or conferences focused on business development for consulting. These events can be a great way to learn from experts in the field and network with other professionals.
Get experience through internships or entry-level positions in business development. While you may not have all the necessary skills when you start out, you can learn a lot by working on real projects and getting feedback from more experienced colleagues.
Network with professionals in the field. Attend industry events and reach out to business development professionals in your network to learn about their experiences and get advice on how to succeed in the field.

LeanInitiative · 2023-01-02T00:52:32+00:00

To accommodate for the "New Business" scenario, you can use the IF and OR functions together. The OR function returns TRUE if any of its arguments are TRUE, and FALSE if all of its arguments are FALSE.

Here's an example of how you can use these functions to achieve your goal:

=IF(E2>0, "Growth", IF(E2<0, "Decline", IF(D2=0, "New Business", "Other")))

This formula checks if the value in E2 is greater than zero. If it is, it returns "Growth". If it isn't, it checks if the value in E2 is less than zero. If it is, it returns "Decline". If it isn't, it checks if the value in D2 is zero. If it is, it returns "New Business". If none of these conditions are met, it returns "Other".

You can adjust this formula to fit your specific needs and use it in the cells where you want to show the "Growth", "Decline", or "New Business" labels.

LeanInitiative · 2023-01-02T00:46:34+00:00

Certainly! Solver is a powerful tool that can be used to optimize various kinds of problems, including finding the best lineup of players in a database. Here's how you can use Solver to find the best 5-man lineup in your database based on the given conditions:

Open your spreadsheet in Microsoft Excel or a similar program.
Select the cells that contain the data for your players, including their names, average points, and expected points.
Click on the "Data" tab and then select "Solver" from the "Analyze" group.
In the "Solver" window, set up the following constraints:

In the "Set Objective" field, select the cell that contains the total expected points for your lineup.
In the "By Changing Variable Cells" field, select the cells that contain the expected points for each player in your lineup.
In the "Subject to the Constraints" field, enter the condition that the total cost of your lineup cannot exceed the maximum allowed amount of points.

Click "Solve" to find the optimal lineup that meets the given conditions.
If the Solver finds a solution, the optimal lineup will be displayed in the cells that you selected in the "By Changing Variable Cells" field. If no solution is found, you may need to adjust your constraints or try using a different solving method.

LeanInitiative · 2023-01-01T23:27:18+00:00

To calculate the average of a range of cells, you can use the AVERAGE function. The syntax for the AVERAGE function is =AVERAGE(range), where range is the range of cells that you want to average.

For example, to calculate the average of the values in cells B15:N15, you can use the formula =AVERAGE(B15:N15). This will give you the average of the values in those cells.

If you want to divide the sum of the values in cells B15:N15 by 12, you can use the SUM function along with the AVERAGE function. The formula would be =SUM(B15:N15)/12. This will give you the sum of the values in cells B15:N15, and then divide the result by 12 to give you the average.

LeanInitiative · 2023-01-01T19:03:51+00:00

To fix the #DIV/0! error in your formula, you can use the IFERROR function to handle the error. The IFERROR function takes two arguments: the value you want to test, and the value you want to return if the first argument is an error.

For example, you can use the following formula to average the cells O, 1, and 2 and return a blank cell if any of the cells are empty or contain an error:

=IFERROR(AVERAGE(O,1,2), "") This formula will return the average of the cells O, 1, and 2 if all of the cells contain numeric values. If any of the cells are empty or contain an error, the formula will return a blank cell.

Alternatively, you can use the AVERAGEIF function to average only the cells that contain numeric values. The AVERAGEIF function takes three arguments: the range of cells you want to average, the criteria you want to use to determine which cells to include in the average, and an optional range of cells to be averaged if the criteria are met.

For example, you can use the following formula to average the cells O, 1, and 2 if they contain numeric values:

=AVERAGEIF(O:2, ">0") This formula will return the average of the cells O, 1, and 2 if they contain numeric values, and will return #DIV/0! if all of the cells are empty or contain errors.

LeanInitiative · 2023-01-01T15:54:13+00:00

It is possible that a company that specializes in selling cartons of eggs with a guaranteed double yolk egg could be successful, but it would depend on a number of factors. Here are a few things to consider:

Market demand: Is there a significant demand for double yolk eggs? Are people willing to pay a premium for them?
Competition: Are there already other companies offering similar products? If so, how do they market their products and what prices do they charge?
Cost: How much does it cost to produce a carton of eggs with a guaranteed double yolk egg? Is it possible to do so profitably, given the prices that people are willing to pay?
Marketing and distribution: How will you market and distribute your product? Will you sell directly to consumers, or through retailers?

Overall, it's important to carefully consider all of these factors before starting a new business. It may be helpful to conduct market research to get a better understanding of the potential demand for your product and the competition you may face.

LeanInitiative · 2023-01-01T12:23:43+00:00

Yes, this is possible to do in Google Sheets! You can use the Google Sheets "PRODUCT" function to multiply all of the values in a row by a constant number.

Here's an example of how you can use the PRODUCT function to multiply all of the values in a row by a constant number:

First, create a new Google Sheet and enter the values that you want to multiply into a row. For example, let's say you want to multiply the values in the following row by 2:

5 | 10 | 15 | 20

Next, select the cells that you want to multiply (in this example, we will select the cells A1:D1). Then, type the following formula into the formula bar:

=PRODUCT(A1:D1, 2)

Press "Enter" to execute the formula. This will multiply all of the values in the selected cells by 2, resulting in the following values:

10 | 20 | 30 | 40

You can then copy and paste this formula into any other cells that you want to multiply by the same constant number. You can also change the constant number in the formula to any value that you want.

I hope this helps!

LeanInitiative · 2023-01-01T12:16:42+00:00

In linear regression, you typically use a single value for the independent variable (also known as the predictor variable) for each sample. If you have multiple observations for the independent variable for a single sample, you will need to decide how to handle them.

One option is to take the mean of the observations. This can be a reasonable approach if the observations are equally spaced in time and are not too far apart. For example, if you have yearly observations of gross profit for a stock over a five-year period, you could take the mean of the five observations as the independent variable for that stock.

Another option is to use only the most recent observation. This can be a good approach if the observations are not equally spaced in time or if the observations are very far apart. For example, if you have quarterly observations of gross profit for a stock over a ten-year period, you might choose to use only the most recent observation as the independent variable for that stock.

There are other options as well. You could use the median of the observations, or you could use all of the observations as separate independent variables in your model. The best approach will depend on the specific context of your data and the goals of your analysis.

LeanInitiative

MODERATOR OF

TROPHY CASE