Formulas, Automatic Calculation and Key Functions in Microsoft 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
Understand and work effectively with fundamental and versatile calculation and analysis techniques in Excel.
To work efficiently with formulas and functions you must start with clear understanding, good habits, and application of correct structure and syntax.
This presentation 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 Objectives:
• Gain practical knowledge of key Excel fundamentals.
• Discover and understand key essentials that provide a foundation for mastering MS Excel
• Gain a practical understanding of effective Excel function and calculation techniques.
• Retain over 75% of your knowledge gained through practice using the step-by-step Learner Guide and exercise files provided.
Benefits & Why Should You Attend:
• Build a solid foundation for a highly marketable
• Boost productivity and save significant time through improved efficiency
• Work smarter, not harder
• Enhance the standard and quality of work produced
• Achieve more in less time
• Improve job satisfaction, team performance
• Impress your management, peers
• Advance all co-workers using MS Office to a consistent standard
Course Outline:
• Outline of over 450 functions in Excel
• Essential functions review
• Setting automatic calculations to save time
• Absolute and relative references in formulas
• Insert Function wizard - to simplify creating complex functions
• Count functions
• IF function - incorporating nesting
• UPPER, lower and Proper – to control text case
What You Get:
• 90 minutes packed with clear demonstrations and practical examples
• Professional step-by-step, easy to follow Learner Guide
• Exercise file(s) aligned with Learner Guide
• Shortcuts, hints, tips and productivity techniques
• Training Reference Materials
• Live Q&A with our Expert
• Participation Certificate
• Access to Signup Community (Optional)
• Reward Points
Who Will Benefit:
Anyone seeking to significantly boost efficiency, productivity, job satisfaction and effective use of their technology investment. Particularly in the following fields:
• Accounting
• Audit
• Banking
• Business Analysis
• Economics
• Finance
• Insurance
• Investment
• Management
• Statistics
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
|
Leadership: Strategic Planning and Decision Making
LIVE : Scheduled on
08-January-2025 :02:00 PM EST
|
Automating Excel - An Introduction to VBA
LIVE : Scheduled on
08-January-2025 :01: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
|
