Excel Tips & Tricks – Identify the Nth Row
There may be times during your data manipulations that you need to identify every 7th row, or every 13th row – every Nth row, for example.
Recently, a colleague contacted me and asked how to complete this function. She wanted to take a random sampling of her data by taking every 13th row of data and copying and pasting to a new spreadsheet.
To perform thi...
Read More
About Excel Tips & Tricks – Identify the Nth Row
Judge Rejects Public Nuisance Claim in Opioid Trial
Authored by: Ollie Lammers
According to Law.com, a judge recently ruled in favor of drug companies against California counties that had citizens impacted by the opioid epidemic.
The judge found the plaintiffs, the city of Oakland and three counties in California, did not differentiate between illegal activities and overdoes and legitimate use of the drugs...
Read More
About Judge Rejects Public Nuisance Claim in Opioid Trial
Veterans Day 2021
Authored By: Candace Whitman
Each year on November 11th, we honor all American veterans for their willingness to serve our country. We recognize and appreciate all of the sacrifices that they made.
Veterans Day began in 1919 a year after the ending of World War I. It was originally called “Armistice Day” to mark the temporary cease in hostilities that to...
Read More
About Veterans Day 2021
Apple and T-Mobile Loses Bid for Arbitration
Authored by: Ollie Lammers
According to Law.com, a federal judge has denied Apple's renewed attempt to force arbitration in a proposed class-action suit. The judge says Apple and T-Mobile could not force arbitration after they found a new document.
The class action against the companies accuses the companies of concealing a flaw in its operating system. T...
Read More
About Apple and T-Mobile Loses Bid for Arbitration
Meet Advocate Capital Client Ron Kramer
Authored By: Elizabeth K.Meet one of America's top trial lawyers and Advocate Capital client, Ron Kramer as he is interviewed by Michael J. Swanson, CEO, Chairman, and author of "How David Beats Goliath: Access to Capital for Contingent-Fee Law Firms".Listen to the positive experiences shared since working with Advocate Capital and how his client’s cases...
Read More
About Meet Advocate Capital Client Ron Kramer
Tips to Improve Your Firm's Social Media Presence
Authored by: Ollie Lammers
Social media is an essential strategy for marketing your law firm to potential clients. Your firm needs to have social media accounts, but you need to do more than having an account and occasionally posting. According to Annette Choti’s Attorneyatwork.com article, here are a few ways your social media posting for your might not...
Read More
About Tips to Improve Your Firm's Social Media Presence
Johnson & Johnson Bankruptcy
Authored by: Ollie Lammers
According to Law.com, Johnson & Johnson recently filed for bankruptcy under a new subsidiary, LTL Management LLC. The company filing bankruptcy allows for shifting legal liability over its talc-based baby powder.
The company has faced many lawsuits over the last few years alleging their talc-based baby powder causes cancer....
Read More
About Johnson & Johnson Bankruptcy
Having Successful Virtual Relationships with Your Employees
Authored by: Ollie Lammers
Having successful relationships with your law firm employees can be tricky, especially working from home. According to Camille Stell’s Attorneyatwork.com article, here are a few ways you can have a successful relationship with your employees.
Boundaries
Make sure when you are creating relationships with employees that you are re...
Read More
About Having Successful Virtual Relationships with Your Employees
What Makes Trucking Accidents Different With Ron Kramer
Authored By: Elizabeth K.Ron Kramer of Kramer Law Group was interviewed by Michael J. Swanson, CEO, Chairman, and author of "How David Beats Goliath: Access to Capital for Contingent-Fee Law Firms". In this interview, Kramer talks about what factors play into trucking incidents that make them different from other vehicle collisions.Kramer focuses on how t...
Read More
About What Makes Trucking Accidents Different With Ron Kramer
Samuel Nordean of Nordean Law Obtains $1 Million for Client
Authored by: Ollie Lammers
Attorney Samuel Nordean of Nordean Law, took on a case against a ridesharing company's auto insurance on behalf of his client. Attorney Nordean was able to obtain $1 million for his client despite being forced into arbitration.
The plaintiff was significantly injured and in terrible pain after the accident. The plaintiff had inj...
Read More
About Samuel Nordean of Nordean Law Obtains $1 Million for Client