KEY ESSENTIALS OF FORMULAS FUNCTIONS & AUTOMATIC CALCULATION IN MS EXCEL
Duration : 90 Minutes
Ray Evans,
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
Please reach us at 1-888-844-8963 for any further assistance or if you wish to register
100% MONEY BACK GUARANTEED
Refund / Cancellation policyGet In Touch
Similar Trainings
Mastering Excel’s Top 10 Functions
LIVE : Scheduled on
06-January-2025 :01:00 PM EST
|
Automating Excel - An Introduction to VBA
LIVE : Scheduled on
08-January-2025 :01:00 PM EST
|
Leadership: Strategic Planning and Decision Making
LIVE : Scheduled on
08-January-2025 :02:00 PM EST
|
Microsoft Excel - A Beginner's Guide to Formulas
LIVE : Scheduled on
10-January-2025 :01:00 PM EST
|
3 Hour Microsoft Excel Automation Boot Camp
LIVE : Scheduled on
13-January-2025 :01:00 PM EST
|
