Excel Tips & Tricks – Comments
Excel has many ways to analyze data and present a picture to users. Occasionally, you may find it helpful to enter a comment or note on a specific field.
To enter a comment, find the field you want to notate and right-click. Select "new note." You may begin typing your commentary. Click somewhere in the free space of your spreadsheet to move out of the c...
Read More
About Excel Tips & Tricks – Comments
Happy Labor Day: Holiday Hours 2022
In observance of Labor Day, the holiday that honors working people in the United States and Canada, our offices will be closed on Monday, September 5th.
Fundings received on Monday will be processed on Tuesday, September 6th. Payments received will be processed on Wednesday, September 7th.
Should you have questions regarding the processing of any transact...
Read More
About Happy Labor Day: Holiday Hours 2022
How Zaner Harden Firm Won a Premises Liability Case When All Evidence Was Destroyed
Meet two of America's Top Trial Lawyers, Kurt Zaner and Marc Harden of Zaner Harden Law, as they are interviewed by Donna Jones, President and Director of Associate & Client Experience, about a client having permanent damage resulting from electrocution in a premises liability case. Learn what made this case so unique.
Read More
About How Zaner Harden Firm Won a Premises Liability Case When All Evidence Was Destroyed
Tips to Fight Inflation
Are you self-funding? Advocate Capital has tips to help you overcome record-high inflation.
For every inflation point, your firm could lose $10,000 on $1MM in case costs. For example, if inflation is 7% and you have $1MM out in case expenses, you may lose $70,000 for every $1MM you have out in case expenses annually.
Could you do something better with $70...
Read More
About Tips to Fight Inflation
Excel Tips & Tricks – Named Ranges
Named ranges are an advanced Excel feature that you may find helpful in your formulas, pivot tables, and charts.
I recently learned about this feature, and I was shocked at how easy it is to use. Let's say, for example, you have a column of data called "State." If you plan to reference this column of data often, you can give it a named range, making refer...
Read More
About Excel Tips & Tricks – Named Ranges
We’re Headed to Vegas for CAALA!
Authored by: Amanda Unterreiner
Are you attending the Consumer Attorneys Association of Los Angeles 2022 Annual Convention this week?
Maria Escamilla, Associate Director of Client Management Services, and Susan Greene, Executive Client Manager, will be heading to Las Vegas, Nevada. Our team will attend the conference from September 1st to 4th at The Bella...
Read More
About We’re Headed to Vegas for CAALA!
Zaner Harden Law Gives Back With Scholarship For Motor Vehicle Collision Victims
Kurt Zaner and Marc Harden of Zaner Harden law were interviewed by Donna Jones, President, and Director of Associate & Client Experience about a unique scholarship opportunity available to families affected by motor vehicle accidents in Colorado. Hear their stories about giving back to the community and assisting victims in achieving their educational...
Read More
About Zaner Harden Law Gives Back With Scholarship For Motor Vehicle Collision Victims
Happy 5th Anniversary, Candace Whitman!
Advocate Capital is glad to celebrate Candace Whitman’s 5th anniversary. We understand that one of the ingredients that makes Advocate unique is the wonderful folks like Candace, who come to work with a smile and passion for their career.
Candace joined Advocate in 2017 as a Marketing Coordinator. She now serves as a Marketing Communications Manager and i...
Read More
About Happy 5th Anniversary, Candace Whitman!
NYC Workers to Receive $20M from Chipotle Following Compensation and Paid Sick Leave Violations
Authored by: Elizabeth Kapamas
As the most significant settlement of the Fair Workweek law to date, a $20 million lawsuit against Chipotle has been settled by the New York City Department of Labor. Chipotle was found to have violated policies regarding scheduling hours and sick leave during the time period of November 2017 to April 2022, according to the...
Read More
About NYC Workers to Receive $20M from Chipotle Following Compensation and Paid Sick Leave Violations
How to Host a Productive Law Firm Marketing Brainstorming Sessions
Authored By: Candace Whitman
When it comes to marketing your law firm, it is important to try new ideas in order to stand out from the crowd. One way to come up with fresh ideas is to hold a brainstorming session. Gina Rubel provides some tips for productive brainstorming sessions in an article for Attorney at Work.
Organize ideas
Decide how you would li...
Read More
About How to Host a Productive Law Firm Marketing Brainstorming Sessions