Excel - Become a Power User-Virtual Boot Camp (3 Hours)
Do you know that Excel helped Microsoft achieve the position of leading PC software developer?Undoubtedly, Excel is an amazing tool that helps business professionals in myriad efficient ways. If you want to exploit its full potential by taking your introductory knowledge to the next level, here’s an intensive boot camp that would help you become a power user.
AREAS COVERED
This is a 100% example-based comprehensive training with special focus on speed, automation and efficiency (the keys to becoming a power-user). Session highlights include…
- Data entry shortcuts including Transpose, AutoFill and Flash Fill
- Taking Find and Replace to the next level
- Automating cell formatting with Conditional Formatting
- Creating and managing dynamic ranges
- Pivot Table Power Tips
- Creating charts
- Heat maps and other data visualizations
- Using data across worksheets
- Using protection to "bullet-proof" your spreadsheets
- VLOOKUP and HLOOKUP functions
- IF and other "Logic" functions
- Creating a basic macro to automate a task
LEARNING OBJECTIVES
- You should attend this training if you need to use Excel to quickly build reports and summaries or if you simply want to learn how to create Pivot Tables to improve your knowledge of Excel.
- You don't have to be proficient in the use of Excel to attend. If you can create basic worksheets and can copy and paste and apply basic formatting to cells, you’ll be able to follow along.
WHO WILL BENEFIT
- Accountants
- CPAs
- CFOs
- Financial consultants
- Controllers
- Banking
- Finance
- Insurance
- Education
- Telecom
- IT
- Marketing
- Sales
- Investments
- Pharmaceutical
- Medical Devices
- FDA
- Aviation
- Energy
- Retail
- Human Resource
- Logistics & Supply Chain
- Accounts
- Audit
For more detail please click on this below link:
About Training Doyens
Based in Colorado, Training Doyens organizes world class webinars and seminars, providing training solutions to companies big and small. Training Doyens offers affordable pricing and customization for any budget.
Email: [email protected]
Toll Free: +1-888-300-8494
Tel: +1-720-996-1616
Fax: +1-888-909-1882
Speaker and Presenter Information
Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies including Microsoft Office and Apple Mac. In 2012, he founded theexceltrainer.co.uk where he has produced nearly 200 written and video-based Excel tutorials. He has recorded several Excel training courses for pluralsight.com and in his career delivered hundreds of courses and webinars on a variety of Excel topics.
Relevant Government Agencies
Dept of Education
Event Type
Webcast
This event has no exhibitor/sponsor opportunities
When
Fri, Dec 1, 2017, 1:00pm - 4:00pm
ET
Website
Click here to visit event website
Event Sponsors
Organizer
Training Doyens
