- Houston , Texas, USA.
- Info@mbstrainingcenter.com
Excel 2016 Essentials
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:
- Create worksheets and workbooks
- Navigate in worksheets and workbooks
- Format worksheets and workbooks
- Change views and configurations
- Print and distribute worksheets and workbooks
- Manage data cells and ranges
- Create tables, charts and objects
- Perform operations with formulas and functions
- Course Objectives
- Create Worksheets and Workbooks
- Create a Workbook
- Open a CSV File
- Add Worksheets to Existing Workbooks
- Navigate in Workbooks and Worksheets
- Search for Data
- Navigate to Named Cells
- Insert/Remove Hyperlinks
- Hide/Unhide Columns, Rows, or Sheets
- Modify Worksheets
- Insert/Delete Rows and Columns
- Adjust Row Height/Column Width
- Insert Headers/Footers
- Rename/Color Worksheet Tabs
- Format Workbooks
- Copy/Move Worksheets
- Modify Page Setup
- Change Themes
- Customize Options/Views
- Add Quick Access Toolbar Items
- Adjust Zoom, Views, and Properties
- Show/Hide Formulas
- Configure Workbooks for Distribution
- Print Setup
- Save in Other Formats
- Accessibility/Compatibility Checks
- Insert/Replace Data in Cells
- Cut, Copy, Paste with Options
- Use Autofill
- Insert/Delete Cells
- Format Cells and Ranges
- Merge/Align/Wrap Text
- Apply Number Formats, Styles, and Conditional Formatting
- Use the Format Painter
- Summarize and Organize Data
- Insert Sparklines
- Group and Outline Data
- Add Subtotals
- Create/Manage Tables
- Convert Cell Ranges to Tables
- Modify Table Rows, Columns, and Styles
- Filter and Sort Data
- Apply Filters (Text, Number, Custom)
- Sort by Multiple Columns
- Remove Duplicates
- Build/Edit/Copy Formulas
- Relative vs. Absolute References
- Perform Basic Functions
- Use SUM, AVERAGE, COUNT, etc.
- Conditional Functions (IF, SUMIF, COUNTIF)
- Format and Modify Text
- Use UPPER, LOWER, PROPER, CONCAT, LEFT, RIGHT, MID
- Analyze Data with Quick Analysis
- Formatting, Totals, and Charts
- Create/Format Charts
- Recommended Charts, Additional Data Series, Chart Styles/Layout
- Insert and Format Objects
- Shapes, Text Boxes, Pictures
- Add Alternative Text
- Words from the Wise
- Completion of Action Plans and Evaluations
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.
