Excel Super User 1 Day Training in Albuquerque, NM

Certificate: Course Completion Certificate

Language: English

Duration: 1 Day

Credits: 8

Course Delivery: Classroom/ Virtual Live/ On-Site

Offers: Groups of 5 - 10 people 10% Discount | Groups of 11 - 20 people 15% Discount

Course Overview:

Take a leap forward in the way you use Excel. Learn from experts who have years of practical experience and are still developing high quality Excel based applications for clients throughout the region.

Have you looked at all the “Advanced” Excel courses and thought “They’re not advanced”? Well, we have just the course for you!

Learning Objectives:

In this course, you will learn:

• Advanced formulae that will provide you with increased functionality plus improved spreadsheet structure.
• The power of Microsoft Query and SQL in extracting data directly from databases, accounting systems and other data sources.
• Techniques that will expand your understanding of the vast range of possibilities within Excel.
• The functions used by experts to increase consistency and reduce data entry.
• An awareness of the risk of VLOOKUP and the safer alternatives.
• Active X and Form controls to allow user interactivity while maintaining control of your spreadsheets.
• Powerful data analysis and visualization techniques to identify trends and anomalies.
• An introduction to Visual Basic programming so that you can write your own customized functions and perform tasks not possible with formulae alone.

Prerequisites:

None

Course Materials:

Students will receive a course manual with presentation slides and reference materials.

Examination:

There is no exam for this course.

Advanced Names

How dynamic ranges can improve your spreadsheet models and two different techniques to create these.

What is a Named Formula and when should you use this?

Advanced Functionality

• Input dependent drop down lists
• Combo Boxes v List Boxes
• How to create a powerful Scenario Manager that displays live data from your model under multiple scenarios
• How to create a Dynamic Chart that automatically re-sizes itself depending on the data available
• Formula driven conditional formatting

Advanced Data Extraction and Manipulation

• Microsoft Query and SQL
• Extracting Data from external sources
• Pivot Table Tricks and new features in Excel 2010 plus Excel 2013

Power BI

• Introduction to Power Pivot, Power Query and Power Map
• Importing data and linking without lookups
• Creating Custom Fields
• Power Map
• Ways to visualize data that has a geographic aspect

Custom VBA Functions

• Extract Sheet Names
• Advanced Concatenate
• Impressive visualization techniques

Highly useful VBA Code (Macros)

• Introduction to VBA and the
• Recording Macros & what to re-write
• Write VBA code
• Learn about risks and best practice
• Automatic Pivot Refresh
• Automatically show and hide sheets, rows and columns
• Change-tracking code – how to build an audit trail into your models

Related Courses

Maximizing your Excel Productivity (1 day)

Target Audience:

This course is for users who are confident in their Excel skills but know there is still a huge amount to learn and want to take their skills to the next level.

Technical Requirements:

For eBooks:

Internet for downloading the eBook

Laptop, tablet, Smartphone, eReader (No Kindle)

Adobe DRM supported software (e.g. Digital Editions, Bluefire Reader) eBook download and activation instructions

Essential Management Skills Training:- Every day, managers solve difficult problems, turn organisations around, and achieve astonishing performance. To be successful, every organisation needs good managers.

These Essential Management Skills training suitable for anyone that works in a management or leadership role. They will provide the perfect foundation for new managers to develop and grow, while giving existing managers the chance to review their current skills and build on their performance.

Organizational Skill Training:- Developing good Organizational Skill is an investment that will provide benefits for years. To be successful means to be organized. These skills will filter through all aspects of your participants professional and personal lives. Throughout this workshop your participants will be given the tools necessary in developing better Organizational Skills.

Through Organizational Skills your participants will encounter improved productivity, better management, and an overall increase in professional growth. Everyday people waste numerous amounts of time looking for items. So stop looking for those important items, and start knowing where they are by getting organized.

Microsoft Power BI Training:- Power BI is the newest Analytics & Business Intelligence tool developed by Microsoft. Power BI is one of the most robust business Intelligence platforms available for data modeling

There will be demos and introduction about Power BI desktop, Power BI website, Mobile Apps and Office 365 Power BI Subscription. You will also learn the easy methods of using Power BI in some scenarios.

Human Resource Management Training:- Recently tasks that were originally thought to fall under the responsibility of the human resources department have become a part of many managers" job descriptions. The sharing and diffusion of these tasks throughout the organization has had an impact particularly on those that are not equipped with the skills or knowledge to deal with these issues.

The Human Resource Management workshop will give managers the basic tools to handle numerous human resource situations such as interviewing, orientation, safety, harassment, discrimination, violence, discipline, and termination. This workshop will provide your participants those skills and assist them with certain Human Resource situations.

Manager Management Training:- With this course, you will be able to provide the skills, guidance, and empowerment to your team of managers. They will then be better suited in leading and motivating their team and thus produce fantastic results. To be a successful manager means having a wide range of skills. Through this workshop, you will be able to disperse your knowledge and experience throughout your leadership team.

Manager Management takes a special type of leader. This workshop will expand your participant's knowledge and provide a way for them to teach and lead new and experienced managers. As every manager knows that learning never stops, this workshop will have something for everyone.

Personal Branding Training:- Personal Branding is identifying your assets, characteristics, strengths, and skills as an individual. Understanding Personal Branding will provide advantages in your participant’s personal and professional lives. Branding is a mix of how you present yourself and how others see you. It is important to be aware of how you are viewed.

With our Personal Branding course your participants will be able to share their vision and passions with others in your company. Utilize this knowledge through Social Media to define and influence how others see you. You are your brand so protect it. Live it.

Presentation Skill Training:- In today’s professional world many things are seen as a “given”. Every individual is expected to perform above average in its area of expertise and it is given that they will excel in interpersonal skills, including presentation and communication skills. Unfortunately this is not the norm. Presentations skills can be developed over time through practice and experience. However, without proper guidance and advice, anyone may develop wrongdoings that may unconsciously negatively impact the desired outcome; whether to entertain or educate the audience, or succeed in “selling” an specific idea or project.

Project Management Basics Training:- With this course you will gain a basic understanding of Project Management based on the Guide to the Project Management Body of Knowledge® – 5th Edition. The course covers information on project management theory, principles, techniques, and methods.

During the course, exercises are made based upon a case study. The case study may be one of three predefined case studies or a customized case study from the participant's organization.

Sales Presentation Mastery Training:- The Sales Presentation Skills Mastery program will introduce and immerse the participants in the most cutting edge tools, techniques, strategies and tactics required to create and lead powerful sales presentations and conversations that persuade prospects to action.

However, this 2 day training program is not for every team or organization. This has been crafted with masterful precision for teams and businesses that demand the very best and are ready to do the work to take their effectiveness to the next level.

Time Management Training:- Personal time management skills are essential for professional success in any workplace. Those able to successfully implement time management strategies are able to control their workload rather than spend each day in a frenzy of activity reacting to crisis after crisis - stress declines and personal productivity soars! These highly effective individuals are able to focus on the tasks with the greatest impact to them and their organization.

The Time Management workshop will cover strategies to help participants learn these crucial strategies. Your participants will be given a skill set that includes personal motivation, delegation skills, organization tools, and crisis management. We"ll cover all this and more during this workshop.