Excel Tips & Tricks – Absolute Value Function
In today’s blog, we will review how to use the absolute value (ABS) in Excel.
This formula is helpful if you are converting a column of both negative and positive numbers to positive numbers only.
Let’s say column A has a list of numbers beginning in field A2. They are both negative and positive. In column B, enter the formula =abs(A2) and then hit enter....
Read More
About Excel Tips & Tricks – Absolute Value Function
Advocate Cares Volunteers for Valentine’s Day!
Authored by: Ollie Lammers
Advocate Cares teamed up with Monroe Harding to make Valentine’s Day goodie bags.
Monroe Harding is a nonprofit organization in Nashville that provides resources for youths in foster care, foster care families, and those who have aged out of foster care.
Our volunteers decorated and stuffed 60 goodie bags. These goodie bags will...
Read More
About Advocate Cares Volunteers for Valentine’s Day!
What Should I Do if I Get an Unexpected Tax Bill?
Jeff East, a Certified Financial Planner through Raymond James, talks with CEO and Chairman, Michael J. Swanson, about what to do if you receive a tax bill that you weren't expecting.
Raymond James is not affiliated with Advocate Capital, Inc. You should discuss any tax or legal
matters with the appropriate professional. Securities offered through Raym...
Read More
About What Should I Do if I Get an Unexpected Tax Bill?
Advocate Capital, Inc. Hosts Annual Soup/Chili Cookoff
Authored By: Maria Escamilla
The Executive Client Management & Training Team (ECMT) decided to host a little friendly competition in celebration of Superbowl Sunday.
Bring on our Annual Soup & Chili Cookoff! Soup… or… Bowl?! (😉)
This year, we had over 13 participants and everything from Deer Chili to Tomato bisque. All employees acted as judges b...
Read More
About Advocate Capital, Inc. Hosts Annual Soup/Chili Cookoff
The Advocate Capital Team Lets Loose
At the end of each year, our remote sales team comes to our headquarters in Nashville for our annual company meeting. It is always nice to have the entire team together for the meeting and include our families at the company dinner.
While everyone is in one place, we take the yearly company photo. Employees have to stand still while the photographer moves...
Read More
About The Advocate Capital Team Lets Loose
Sexual Harassment and Whistleblowers Case Finally Settles After 14 Years
As seen on Seeking Alpha, Yahoo Finance!, and Market Watch.
Attorneys Gary Gwilliam and Randall Strauss of Gwilliam, Ivary, Chiosso, Cavalli & Brewer recently settled a case they were prosecuting for 14 years involving sexual harassment, whistleblowers, bankruptcy, and forced arbitration.
Six women observed misconduct at their mortgage firm, but when...
Read More
About Sexual Harassment and Whistleblowers Case Finally Settles After 14 Years
Your Financial Plan Doesn't Need to be Perfect
Authored By: Amanda Unterreiner
Jeff East, a Certified Financial Planner through Raymond James, talked with CEO and Chairman, Michael J. Swanson, about financial planning. He explains that most financial plans aren't perfect. Watch the video below to learn how to make progress towards realistic goals.
Raymond James is not affiliated with Advocate Capital...
Read More
About Your Financial Plan Doesn't Need to be Perfect
$3 Million Settlement Awarded in Brain Injury Case
On January 6, 2017, a New Jersey resident filed a personal injury complaint in the Middlesex County Circuit Court, Docket #MID L 000140-17, alleging multiple counts of negligence. The suit stated the defendants failed to properly maintain an elevator shaft located inside an under-construction building, resulting in the plaintiff’s fall and subsequent bra...
Read More
About $3 Million Settlement Awarded in Brain Injury Case
Cossé Law Firm Scores Huge Win for Client on the Eve of Trial
Congratulations to our friend, Chip Cossé of Cossé Law Firm, and his client on obtaining a confidential settlement as the jury was being impaneled.
The plaintiff was seriously injured after a horrific work-related vehicle accident that took place in January 2014. Before the accident, the plaintiff was gainfully employed as a runner with a marine transport...
Read More
About Cossé Law Firm Scores Huge Win for Client on the Eve of Trial
Trojan Horse CLE Discount for Advocate Capital, Inc. Clients
Start your 2020 CLE curriculum on a high note by attending the Voir Dire School & Case Analysis Program offered through Trojan Horse Method. The sessions are January 17 and 18, 2020 at the JW Marriott Resort & Spa in Las Vegas, NV. Registration information can be found here.
Advocate Capital clients are eligible for a $200 discount on registrati...
Read More
About Trojan Horse CLE Discount for Advocate Capital, Inc. Clients
