Performing key roles in a the private and public sectors and also as a Board Director, Ray's proven experience includes management, business analysis, audit, report writing, system documentation, website design and video production.
Ray has qualifications in Frontline Management, Accounting, Training and Assessment an Read more
To work efficiently with formulas and functions you must start with clear understanding, good habits, and application of correct structure and syntax.
Course Objectives:
To gain a practical “hands-on” understanding of formulas functions & automatic calculation in MS Excel.
Understand and work effectively with fundamental and versatile calculation and analysis techniques in Excel at introductory level.
This webinar effectively demonstrates and teaches examples of formulas and specific functions, providing the perspective you need to understand the depth and scope of these Excel features.
Gaining this knowledge is a fundamental and highly marketable skill set in Excel and is vital in a wide range of professions and fields including accounting, financial analysis, government and business administration.
Course Outline:
• Outline of the 450+ functions in Excel
• Essential functions review
• Setting automatic calculations
• Absolute and relative references
• Insert Function-to simplify creating complex functions
• Count functions
• IF function-incorporate nesting
• UPPER, lower and Proper – to control text case
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 of all levels
• Team Leaders
• Supervisors
• Administrative Specialists
• Anybody with large amounts of data
• Anybody who uses Microsoft Access/Excel on a regular basis, and wants to be more efficient and productive
• Accountants
• CPAs
• Controllers
• Financial Consultants
• IT Professionals
• Auditors
• Human Resource Personnel
• Bookkeepers
• Marketers
Excel ChatGPT Data Management Charting Protection & Formulas
LIVE : Scheduled on
30-September-2024 :01:00 PM EDT
|
Compelling Presentations with Excel and PowerPoint
LIVE : Scheduled on
07-October-2024 :01:00 PM EDT
|
Effective Communication for Improved Performance, Alignment, and Results
LIVE : Scheduled on
07-October-2024 :03:00 PM EDT
|
3 Hour Excel Automation Boot Camp: Sort and Filter Tools, Conditional Formatting, Data Validation and Visualizing Excel with Smart-Art and Charts
LIVE : Scheduled on
11-October-2024 :01:00 PM EDT
|
Subscribe to our newsletter and get industry updates along with exclusive deals on related trainings
SimpliCompliance.com is world‘s best online and classroom learning platform based in New York, USA. We offer quality learning in Professionals Certifications, Compliance and Technology courses through Online & Classroom training, webinars, seminars, workshops and conferences. | more...