[ux_slider] [ux_banner height=”545px” bg=”1188″ bg_size=”original” bg_pos=”62% 60%”] [text_box text_color=”dark” width=”37″ width__sm=”90″ padding=”2px 20px 2px 20px” animate=”none” position_x=”0″ position_y=”100″ position_y__sm=”95″ text_align=”left” bg=”rgba(255, 255, 255, 0.94)” depth=”1″]

Microsoft Office

Microsoft Excel

If you are looking to start a career in business or finance, having a working knowledge of Microsoft’s Excel 2016 is a must. Our new and exciting course taught by LearnKey Senior Instructor Jason Manibog will teach you how to reveal insights hidden in your data with the help of new features such as the “Tell Me” feature, chart options, and more!

[/text_box] [/ux_banner] [ux_banner height=”545px” bg=”1194″] [/ux_banner] [/ux_slider] [title style=”center” text=”Fees & Facts” tag_name=”h1″ color=”rgb(0, 109, 160)”] [section bg_color=”rgba(122, 156, 89, 0.16)” mask=”arrow”] [row style=”large” col_style=”divided” h_align=”center”] [col span=”3″] [featured_box img=”1213″ img_width=”74″ pos=”center” title=”Fees” margin=”1px 1px 1px 1″ icon_color=”rgb(0, 109, 160)”]

• $200 USD One Time
• Special Discount (75% OFF) Available for Online students
• Fees after scholarship*
  $150 international students 
  $150 US domestic students 

*Valid from June 2020 intake.

[/featured_box] [/col] [col span=”3″] [featured_box img=”1205″ pos=”center” title=”schedule” margin=”1px 1px 1px 1″]

• July 8, 2020
• September 16, 2020
• November 10, 2020

[/featured_box] [/col] [col span=”3″] [featured_box img=”1206″ img_width=”50″ pos=”center” title=”Duration” margin=”01px 1px 1px 1px”]

• Academic: 13 weeks in-class and 10 weeks practical Training.
• Total length: 6 Month including scheduled breaks.

[/featured_box] [/col] [col span=”3″] [featured_box img=”1207″ img_width=”67″ pos=”center” title=”Class Time:” margin=”1px 1px 1px 1″ icon_color=”rgb(0, 109, 160)”]

• Timing: 0830 – 1630 Hrs for Institute Students.
• Online Students: Day timing according to teacher/student schedule.

[/featured_box] [/col] [/row] [/section] [title style=”center” text=”Program Outcomes” tag_name=”h1″ color=”rgb(0, 109, 160)”] [section bg=”1201″ bg_size=”original” bg_overlay=”rgba(0,0,0,.5)” effect=”confetti” dark=”true” mask=”arrow” padding=”70px” border=”1px 1px 1px 1″ border_radius=”21″] [row style=”large” width=”full-width” v_align=”middle”] [col span=”6″ span__sm=”12″] [ux_image id=”7454″ depth=”2″] [/col] [col span=”6″ span__sm=”12″ divider=”0″ align=”left” bg_color=”rgb(0, 0, 0)” color=”light”]

• Gain the skills and confidence required to successfully obtain your Microsoft Office Excel 2016 certification.
• Test prep questions that meet all Excel 2016 exam objectives.
• View your online course ware anytime, anywhere.
• Enhance your personal and professional skills to achieve your goals.
• Develop the necessary skills and knowledge to become an effective professional.

[/col] [/row] [/section] [title style=”center” text=”Program Modules” tag_name=”h1″ color=”rgb(0, 109, 160)”] [section label=”Media Right” bg=”1202″ bg_size=”original” bg_overlay=”rgba(0, 0, 0, 0.6)” bg_pos=”0% 0%” dark=”true” mask=”arrow” padding=”1px” video_visibility=”visible”] [row style=”large” v_align=”middle”] [col span__sm=”12″ align=”left” bg_color=”rgba(0, 0, 0, 0.55)” color=”light”] [accordion] [accordion-item title=”Session 1″]

Section A: Introduction to Excel 2016

• About This Course

[divider align=”left” width=”10000px” height=”2px” margin=”2px” color=”rgb(242, 197, 197)”]

Section B: Create Worksheets and Workbooks

• Tour of Excel

• Create a Blank Workbook

• Create a Workbook Using Templates

• Add Data to a Worksheet

• Import Data

• Add a Worksheet

• Copy a Worksheet

• Move a Worksheet

[divider align=”left” width=”10000px” height=”2px” margin=”2px” color=”rgb(242, 197, 197)”]

Section C: Navigate in Worksheets and Workbooks

• Search for Data

• Navigate a Workbook

• Insert and Remove Hyperlinks

[divider align=”left” width=”10000px” height=”2px” margin=”2px” color=”rgb(242, 197, 197)”]

Section D: Format Worksheets and Workbooks

• Change Worksheet Tab Color

• Rename a Worksheet

• Change Worksheet Order

• Modify Page Setup

• Insert and Delete Columns or Rows

• Change Workbook Themes

• Adjust Row Height and Column Width

• Insert Headers and Footers

[divider align=”left” width=”10000px” height=”2px” margin=”2px” color=”rgb(242, 197, 197)”]

Section E: Customize Options and Views

• Hide and Unhide Worksheets

• Hide and Unhide Columns and Rows

• Customize the Quick Access Toolbar

• Change Workbook Views

• Change Window Views

• Modify Document Properties

• Change Magnification

• Display Formulas

[divider align=”left” width=”10000px” height=”2px” margin=”2px” color=”rgb(242, 197, 197)”]

Section F: Prepare Files for Distribution

• Set a Print Area

• Save Workbooks in Other Formats

• Print All or Part of a Workbook

• Set Print Scaling

• Display Repeating Row and Column Titles

• Inspect for Hidden Properties

• Inspect for Accessibility Issues

• Inspect for Compatibility Issues

[divider align=”left” width=”10000px” height=”2px” margin=”2px” color=”rgb(242, 197, 197)”]

Section G: Domain 1 Recap

• Domain 1 Test Tips

[/accordion-item] [accordion-item title=”Session 2″]

Section A: Manage Data

• Insert Data in Cells and Ranges

• Replace Data

• Cut and Paste Data

• Copy and Paste Data

• Paste Data with Special Paste Options

• Using AutoFill to Fill Cells

• Insert and Delete Cells

[divider align=”left” width=”10000px” height=”2px” margin=”2px” color=”rgb(242, 197, 197)”]

Section B: Format Cells and Ranges

• Merge Cells

• Modify Cell Alignment and Indentation

• Use Format Painter to Format Cells

• Wrap Text Within Cells

• Apply Number Formats

• Apply Cell Formats

• Apply Cell Styles

[divider align=”left” width=”10000px” height=”2px” margin=”2px” color=”rgb(242, 197, 197)”]

Section C: Summarize and Organize Data

• Insert Sparklines

• Outline Data

• Create Subtotals

• Apply Conditional Formatting

[divider align=”left” width=”10000px” height=”2px” margin=”2px” color=”rgb(242, 197, 197)”]

Section D: Domain 2 Recap

• Domain 2 Test Tips

[/accordion-item] [accordion-item title=”Session 3″]

Section A: Create Tables

• Create and Manage Tables

• Create an Excel Table from a Cell Range

• Convert a Table to a Cell Range

• Add or Remove Table Rows and Columns

[divider align=”left” width=”10000px” height=”2px” margin=”2px” color=”rgb(242, 197, 197)”]

Section B: Manage Table Styles and Options

• Apply Styles to Tables

• Configure Table Style Options

• Insert Total Rows

[divider align=”left” width=”10000px” height=”2px” margin=”2px” color=”rgb(242, 197, 197)”]

Section C: Filter and Sort a Table

• Filter Records

• Sort Data by Multiple Columns

• Sort Data by Custom Lists

• Change Sort Order

• Remove Duplicate Records

[divider align=”left” width=”10000px” height=”2px” margin=”2px” color=”rgb(242, 197, 197)”]

Section D: Domain 3 Recap

• Domain 3 Test Tips

[/accordion-item] [accordion-item title=”Session 4″]

Section A: Calculations with Formulas and Functions

• Use Basic Formulas and Functions

• Use Basic Formulas

• Use Absolute and Mixed References

• Using Formulas Across Worksheets

• Calculate with the SUM Function

• Use the MIN and MAX Functions

• Use the COUNT Functions

• Use the AVERAGE Functions

• Formula and Function Tips

[divider align=”left” width=”10000px” height=”2px” margin=”2px” color=”rgb(242, 197, 197)”]

Section B: Use Conditional Functions

• Use the IF Function

• Use the SUMIF Function

• Use the AVERAGEIF Function

• Use the COUNTIF Function

[divider align=”left” width=”10000px” height=”2px” margin=”2px” color=”rgb(242, 197, 197)”]

Section C: Use Text Functions

• Use the LEFT Function

• Use the MID Function

• Use the RIGHT Function

• Use the UPPER and LOWER Functions

• Use the PROPER Function

• Use the CONCAT Function

[divider align=”left” width=”10000px” height=”2px” margin=”2px” color=”rgb(242, 197, 197)”]

Section D: Domain 4 Recap

• Domain 4 Test Tips

[/accordion-item] [accordion-item title=”Session 5″]

Section A: Create Charts and Objects

• Create Charts

• Create a New Chart

• Add Additional Data Series

• Switch Orientation of Source Data

• Use Quick Analysis to Analyze Data

[divider align=”left” width=”10000px” height=”2px” margin=”2px” color=”rgb(242, 197, 197)”]

Section B: Format Charts

• Resize Charts

• Add and Modify Chart Elements

• Data Labels and Legends

• Gridlines

• Apply Chart Layouts and Styles

• Change Chart Type

• Create Secondary Axis

• Move Charts to a Chart Sheet

[divider align=”left” width=”10000px” height=”2px” margin=”2px” color=”rgb(242, 197, 197)”]

Section C: Insert and Format Objects

• Insert Text Boxes and Shapes

• Insert and Modify Images

• Add Alternative Text to Objects

[divider align=”left” width=”10000px” height=”2px” margin=”2px” color=”rgb(242, 197, 197)”]

Section D: Domain 5 Recap

• Domain 5 Test Tips

[divider align=”left” width=”10000px” height=”2px” margin=”2px” color=”rgb(242, 197, 197)”]

Section E: Test Taking Tips

• Overall Test Tips

[divider align=”left” width=”10000px” height=”2px” margin=”2px” color=”rgb(242, 197, 197)”]

Section F: Conclusion

• Course Ending

[/accordion-item] [/accordion] [/col] [/row] [/section] [title style=”center” text=”Other Program details” tag_name=”h1″ color=”rgb(0, 109, 160)”] [section bg_color=”rgba(122, 156, 89, 0.16)” mask=”arrow”] [row style=”large” col_style=”divided” h_align=”center”] [col span=”3″] [featured_box img=”1239″ img_width=”84″ pos=”center” title=”Admission Requirement” margin=”1px 1px 1px 1″ icon_color=”rgb(0, 109, 160)”]

All students must be at least eighteen (18) years of age on or before the first day of class. Students must provide a High School Diploma or a General Education Development Certificate (G.E.D) .

[/featured_box] [/col] [col span=”3″] [featured_box img=”1241″ img_width=”72″ pos=”center” title=”Assessment Method” margin=”1px 1px 1px 1″]

You must successfully complete all modules to be awarded the certificate.
The assessment of each module consists of:
• Individual assignment or class test: 50%
• Final exam: 50%

[/featured_box] [/col] [col span=”3″] [featured_box img=”1244″ img_width=”69″ pos=”center” title=”Benefits” margin=”01px 1px 1px 1px”]

• This is a 100% hands-on course; every student will have his or her own laptop/computer to work on.
• FREE retake for up to 9 months.
• Courses cover all required technique used in practical.
• Highly qualified Instructor and trainer.
• Great for beginners to intermediate users.
• Online courses are also available on demand.

[/featured_box] [/col] [col span=”3″] [featured_box img=”1245″ img_width=”110″ pos=”center” title=”Careers Opportunities” margin=”1px 1px 1px 1″ icon_color=”rgb(0, 109, 160)”]

After Passing this course can consider career opportunities which includes positions such as:

• Office Assistant
• Asst Project Coordinator
• Virtual Assistant
• Administrator

[/featured_box] [/col] [/row] [/section] [message_box bg_color=”rgba(122, 156, 89, 0.16)” padding=”12″] [row v_align=”middle”] [col span=”7″ span__sm=”12″]

Don’t Miss this opportunity

Apply Online

OR

Contact us for more information

[/col] [col span=”5″ span__sm=”12″ align=”right”] [button text=”Apply online” color=”alert” size=”larger” animate=”flipInY” link=”https://www.american-tech-institute.edu/apply-now/” target=”_blank”] [/col] [/row] [button text=”Contact us” color=”alert” size=”larger” animate=”flipInY” link=”https://www.american-tech-institute.edu/contact/”] [/message_box]