Course Code: GES176
I. Introduction to Microsoft Excel
A. Creating a Microsoft Excel Workbook
B. The Ribbon
C. The Backstage View (The File Menu)
D. Entering Data in Microsoft Excel Worksheets
E. Formatting Microsoft Excel Worksheets
F. Using Formulas in Microsoft Excel
G. Working with Rows and Columns
H. Editing Worksheets
I. Finalizing Microsoft Excel Worksheets
J. Microsoft Excel Features that Were New in 2013
K. Features New in 2016
L. Introduction to Microsoft Excel 2016 Exam
II. Intermediate Microsoft Excel 2016
A. Advanced Formulas
B. Working with Lists
C. Working with Illustrations
D. Visualizing Your Data
E. Working with Tables
F. Advanced Formatting
G. Microsoft Excel Features that Were New in 2013
H. Features New in 2016
I. Intermediate Microsoft Excel 2016 Exam
III. Advanced Microsoft Excel 2016
A. Using Pivot Tables
B. Auditing Worksheets
C. Data Tools
D. Working with Others
E. Recording and Using Macros
F. Random Useful Items
G. Microsoft Excel Features that Were New in 2013
H. Advanced Microsoft Excel 2016 Exam
IV. Microsoft Excel Final Exam
Cindy Lamkin has been employed in the dental field for over 20 years. She graduated from the University of South Dakota with a degree in dental hygiene and holds Registered Dental Assistant and Registered Dental Hygienist credentials. In addition to practicing clinical hygiene, she has also worked in dental office administration and treatment coordination. Her career includes general dentistry, as well as specialty practices of periodontics, endodontics, pedodontics, and orthodontics.
Tracy Berry has been a senior graphic designer/programmer, instructor, and consultant since 1993 and has developed hundreds of logos, marketing materials, websites, and multimedia solutions for customers worldwide. She was also involved in several large corporate software rollouts.
She has helped many organizations optimize and streamline data solutions. She teaches both onsite and online courses and has her CTT (Certified Technical Trainer) certification. Tracy specializes in teaching graphics, desktop publishing, web design, and reporting/productivity applications.
You should be proficient in keyboarding, have a basic understanding of a word-processing computer program (Microsoft Word is recommended), and have a command of English grammar and punctuation. You should be comfortable in a Windows environment, and have the ability to launch and close activities and navigate to information stored on the computer. They should also have an ability to manage files and folders. No dental office work experience is required.
This course is designed to prepare you for an entry-level position as a full-charge bookkeeper. You do not need any prior experience or training in this field.
The instructional materials required for this course are included in enrollment. The following textbooks will be shipped to you approximately 7-10 business days after enrollment:
Additionally, this course will provide you with DENTRIX® software that consists of sample practice opportunities. You can use this software to engage in activities and tasks that you would perform in an actual practice and use it to demonstrate your skills.
Manuals are included as downloadable PDFs throughout the course.
Yes, ed2go courses are completely online. However, keep in mind that not all certifying bodies or industry-specific certifications are recognized internationally. Please review your country’s regulations prior to enrolling in courses that prepare for certification.
Yes, you will be prepared for the Microsoft exams 77-727 and 77-728 (Excel) and 77-725 and 77-726 (Word).
This course is open enrollment, so you can register and start the course as soon as you are ready. Access to your course can take 24-48 business hours.
This course is self-paced and open enrollment, so you can start when you want and finish at your own pace. When you register, you'll receive eighteen (18) months to complete the course.
The time allotted for course completion has been calculated based on the number of course hours. However, if you are unable to complete the course, contact your Student Advisor to help you work out a suitable completion date. Please note that an extension fee may be charged.
You may be assigned with an instructor or team of industry experts for one-on-one course interaction. Your support will be available (via e-mail) to answer any questions you may have and to provide feedback on your performance. All of our instructors are successful working professionals in the fields in which they teach. You will be assigned to an Advisor for academic support.
Upon successful completion of the course, you will be awarded a Certificate of Completion.
This course will provide you with the skills you need to obtain an entry-level position in most cases. Potential students should always do research on the job market in their area before registering.
ed2go courses are non-credit, so they do not qualify for federal aid, FAFSA and Pell Grant. In some states, vocational rehab or workforce development boards will pay for qualified students to take our courses. Additionally, some students may qualify for financial assistance when they enroll, if they meet certain requirements. Financing is available from select schools. Learn more: https://www.ed2go.com/career/financial-assistance
If you have questions that are not answered on our website, representatives are available via LIVE chat. You can also call us at 1-877-221-5151 during regular business hours to have your questions promptly answered. If you are visiting us during non-business hours, please send us a question using the “Contact Us” form.