Learn all the intricacies of using Excel’s Formatting feature. Learn about formatting numbers (what all those codes are, like _($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_), Alignment, Font, Underlines, borders, angle text, merged cells, Format painter, and more.
Course Objectives:
Excel is a powerful program for managing and analyzing lengthy lists of data. What tips, tricks, and techniques do you need to know to quickly and easily sort and filter a range or table of data? Join this training course to explore the shortcuts and solutions for effectively working with large worksheets of data.
Course Outline:
• The codes like those listed in the description, above
• Alignment of data
• Format painter
• Special codes to enable you to enter today’s date and have it show in the cell as:
Today is 5/6/2022, instead of just 5/6/2022
• Font color
• Cell color
• Gradient fills
• Fill effects
What You Get:
• Training Materials
• Live Q&A Session with our Expert
• Participation Certificate
• Access to Signup Community (Optional)
• Reward Points
Who Will Benefit:
• Business Owners
• CEO's / CFO's / CTO's
• Managers
• Accountants
• CPA's
• Financial Consultants
• IT Professionals
• Auditors
• Human Resource Personnel
• Bookkeepers
• Marketers
• Anybody with large amounts of Data
• Anybody who uses Microsoft Excel on a regular basis, and wants to be more efficient and productive
2 Hours Virtual Seminar on Microsoft Excel Functions
Get Instant Access 120 Minutes View Program |
2 Hours Virtual Seminar on Visualizing Data with Excel Charts
Get Instant Access 120 Minutes View Program |
2 Hours Virtual Seminar on MS Excel Pivot Tables 101
Get Instant Access 120 Minutes View Program |
6-Hour Virtual Seminar on Learning the Highlights of Excel - A Complete Set of Useful Tools
Get Instant Access 360 Minutes View Program |
Lookup Function Essentials in Microsoft Excel
Get Instant Access 60 Minutes View Program |
Get Instant Access On-Demand Access
Preparing for the ICE Storm: What to Do During I 9 Audits and ICE Raids
Janette S. Levey
Human Resources
Get Instant Access On-Demand Access
OSHA Inspections and Investigations-How to Manage Them
Irwin Dobrushin
Environment Health and Safety | OSHA
Get Instant Access On-Demand Access
29 CFR 1904: OSHA's New Injury Recordkeeping E-Submission Rule
Occupational Safety and Health Administration
Get Instant Access On-Demand Access
Working with Excel Databases: Sort, Filter, Subtotal and More
Cathy Horwitz
Cross Industry | Skill Enhancement
Get Instant Access On-Demand Access
Writing Audit Reports
Jonnie T. Keith CIA, CFE, CGAP, CICA
Governance, Risk and Compliance
Get Instant Access On-Demand Access
BSA Reporting Requirements
Banking and Financial Services Industry
Get Instant Access On-Demand Access
Human Factors-Usability Based on ISO 62366
Medical Device | Diagnostic | Pharmaceutical | Biologics fields
Get Instant Access On-Demand Access
Chat GPT for Project Managers
Charles H. Paul
All FDA Regulated Industry