- Houston , Texas, USA.
- Info@mbstrainingcenter.com
Excel 2016 Expert
This course is part of Intellectual Development (Microsoft Office)
Instructors: Tammy McAllister
150,434 already enrolled
12 modules
Learn the fundamentals.
30 -40 hours to complete
Spread over 2 to 3 weeks
Flexible schedule
Learn at your own pace
★★★★☆ 4.8
(4,274 reviews)
About the Course
Participants will gain an advanced level of understanding for the Microsoft Excel environment, and the ability to guide others to the proper use of the program’s full features – critical skills for those in roles such as accountants, financial analysts, and commercial bankers.
Participants will create, manage, and distribute professional spreadsheets for a variety of specialized purposes and situations. They will customize their Excel 2016 environments to meet project needs and increase productivity. Expert workbook examples include custom business templates, multi-axis financial charts, amortization tables, and inventory schedules.
Course Objectives:
- Save a workbook as a template, with colors, fonts, cell styles and themes
- Reference data using structured references or data in another workbook
- Protect a workbook from further editing
- Prepare a workbook for internationalization
- Apply custom data formats and validation
- Apply advanced conditional formatting and filtering
- Use form controls
- Work with macros
- Course Objectives
- Manage Workbooks
- Save a Workbook as a Template
- Reference Data in Another Workbook
- Use Structured References
- Display Hidden Ribbon Tabs
- Manage Workbook Review
- Mark a Workbook as Final
- Protect Workbooks and Worksheets
- Password Protection
- Restrict Editing
- Protect Workbook Structure
- Manage Workbook Versions
- Setting Calculation Options
- Prepare a Workbook for Internationalization
- Apply Currency Formats
- Apply Date/Time Formats by Locale
- Apply Custom Data Formats and Validation
- Create Custom Number Formats
- Use Advanced Fill Series Options
- Configure Data Validation
- Advanced Conditional Formatting
- Create Custom Rules
- Use Formulas in Conditional Rules
- Manage Rules
- Create and Modify Custom Workbook Elements
- Custom Color Formats
- Font Sets
- Cell Styles and Themes
- Work with Macros
- Enable, Record, Run, and Edit Macros
- Copy Macros Between Workbooks
- Define Named Ranges and Objects
- Name Cells
- Use Named Cells in Formulas
- Manage Named Ranges
- Apply Functions in Formulas
- Logical Functions: AND, OR, NOT
- Nested Functions
- Conditional Functions: SUMIFS, AVERAGEIFS, COUNTIFS
- Look Up Data Using Functions
- VLOOKUP, HLOOKUP
- MATCH, INDEX
- Advanced Time and Date Functions
- NOW, TODAY
- Serialize Numbers Using Date/Time Functions
- Perform Data Analysis and Business Intelligence
- Import, Transform, Combine, and Display Data
- Consolidate Data
- What-If Analysis (Goal Seek and Scenario Manager)
- Troubleshoot Formulas
- Trace Precedence and Dependence
- Use the Watch Window
- Error Checking and Formula Evaluation
- Create Advanced Charts
- Add Trendlines
- Dual-Axis Charts
- Save Charts as Templates
- Create and Manage PivotTables
- Slicers
- Modify Fields and Options
- Group Data
- Use GETPIVOTDATA Function
- Add Calculated Fields
- Create and Manage PivotCharts
- Drill Down Details
- Apply Styles
- Manipulate Options
- Words from the Wise
Offered by
MBS Traing Center
Where Visionaries Grow and Succeed.
Recommended if you're interested in Finance
Business Development
Entrepreneurship Workshop
Develop essential skills to start, manage, and grow a successful business.
(4.7)
★★★★★ 4.7/5
- Free Webinar
- Include Certificate
Personal Growth
Social Development
Enhance interpersonal skills and build stronger professional relationships.
(4.7)
★★★★★ 4.7/5
- Free Webinar
- Include Certificate
Business Excellence
Professional Development
Master leadership, project management, and workplace efficiency techniques.
(4.7)
★★★★★ 4.7/5
- Free Webinar
- Include Certificate
Career Advancement
Intellectual Development
Critical thinking, organizational skills, and decision-making abilities.
(4.7)
★★★★★ 4.7/5
- Free Webinar
- Include Certificate
Why people choose MBS Traing Center for their career
The Entrepreneurship Workshop was an eye-opener for me. I gained practical insights into business planning and market analysis, which I was able to apply immediately to my startup. Highly recommended!
I took the Career Advancement course, and it transformed how I approach leadership and communication in my role. The interactive activities and real-world case studies were incredibly valuable.
I’ve attended multiple workshops, but the Business Excellence course stood out. The hands-on exercises and expert insights gave me a deeper understanding of how to improve my business operations.
Previous
Next
Everything You Need to Know About the Course
Yes! Upon successful completion of the course, you will receive a certificate that demonstrates your mastery of key entrepreneurial skills and knowledge.
The course typically takes 30-40 hours to complete, depending on your pace. The program is spread over 12 modules and can be completed in 3 weeks at 3 hours per week. You can also take the course at your own pace with flexible scheduling.
Yes, this course is designed for aspiring entrepreneurs, small business owners, and professionals transitioning into self-employment. It covers the fundamentals, as well as advanced strategies, to help you at any stage of your entrepreneurial journey.
In this workshop, you will learn how to start, manage, and grow a successful business. Topics include business planning, market analysis, employee management, securing financing, marketing strategies, and business growth techniques.
Yes! Upon successful completion of the course, you will receive a certificate that demonstrates your mastery of key entrepreneurial skills and knowledge.
There are no specific prerequisites. Whether you're new to entrepreneurship or already running a business, this workshop will provide valuable insights and practical tools.
Yes, you will have access to the course materials and resources even after completion, so you can refer back to them as needed.
To enroll, simply visit the course registration page, fill out the form, and select your preferred payment option. You will receive immediate access to the course materials upon enrollment.
We offer a 30-day money-back guarantee. If you are not satisfied with the course within the first 30 days, you can request a full refund.
Yes! The course is designed with flexibility in mind. You can complete the modules at your own pace and choose a schedule that works for you.
