TEKSKILLS Computer Learning Center

Administrative Specialist

To be a successful administrative professional, you must possess skills to handle a wide variety of workplace tasks and scenarios.  it provides you with a broad selection of essential skills and knowledge to effectively work as an administrative assistant in fields including education, technology, government, and medicine.

You will learn the basics of Word, Excel, Outlook, PowerPoint and Access in workplace administration as well as how to begin and grow a successful career as an administrative professional. The course covers the intricacies of organizational communication, office and records management, and human resources fundamentals, among other topics. You will also learn to effectively write for business, produce documents, and utilize informational technology. You’ll gain event and project management skills, which includes virtual meeting coordination. As technology develops, this skill has become increasingly useful. Each course module concludes with a hands-on Lab, helping you to effectively track your progress and test your skills.

This program will also prepare you to sit for the Microsoft Office Specialist Certification Exams, which cover Word, Excel, This course offers enrollment with vouchers. The voucher is prepaid access to sit for the certifying exam upon eligibility. Proctor fees may apply, which are not included.

In addition to Office skills, prepare for a career in the high-demand field of bookkeeping and accounting as you master QuickBooks, the leading financial software tool for small businesses. Even with no bookkeeping experience, you’ll be able to do professional bookkeeping for a small business after taking this online course. The course will teach you how to plan a budget, manage payroll systems, and manage accounts. It also makes you aware of the legal standards that apply to accounting methods, giving you the proper credentials you need to practice bookkeeping with confidence.

Certification: 

OfficePro/Microsfot Office Specialist (MOS)

Intuit Certified Bookkeeping Professional

Ms Office :

Microsoft Word
Introduction to Word
Creating Documents and Using the Clipboard
Modifying Fonts
Formatting Paragraphs
Formatting Pages
Editing Documents
Inserting Illustrations and Other Elements
Creating and Formatting Tables
Using Themes, Styles, and Templates
Managing References
Managing Headers, Footers, and Sections
Using Office Collaboration Features
Using Macros

Microsoft Excel
Introduction to Excel
Creating and Managing Workbooks
Organizing and Entering Data
Changing Properties and Printing Worksheets
Formatting Cells
Entering Simple Formulas
Using Advanced Functions
Displaying Data in Charts
Organizing Data in Tables
Summarizing Complex Data

Microsoft PowerPoint
Introduction to PowerPoint
Creating and Managing Presentations
Formatting Textual Content
Designing Slides
Using the Slide Master
Formatting SmartArt and Shapes
Formatting Tables and Charts
Formatting Pictures and Other Media
Applying Animations and Transitions
Delivering Presentations

Microsoft Access
Introduction to Access
Managing Databases
Designing and Creating Tables
Using Simple Queries
Creating Forms
Creating Reports
Surveying Advanced Access Features

Microsoft Outlook
Introduction to Outlook
Sending and Receiving Messages
Managing Messages
Managing Contacts and Groups
Working with the Calendar

  • QuickBooks Basics
    1. Welcome to QuickBooks: Demonstrate how to set up a QuickBooks company file for a business by creating an Ace Photography QuickBooks company file.
    2. Working with Company Files: Have a better understanding of how to work with company files in QuickBooks precisely and accurately.
    3. Securing Your Company Files: Demonstrate how to secure company files in QuickBooks by managing users and data.
  • Bookkeeping Building Blocks
    1. Bookkeeping Defined: Apply bookkeeping concepts to accounting problems.
    2. The Journal, the Ledger, and Special Journals: Run QuickBooks reports for the general journal and the general ledger, as well as reports for subsidiary journals.
  • Preparing the Company File
    1. The Chart of Accounts: Work with the Chart of Accounts in QuickBooks, including adding and changing accounts.
    2. Company Lists: Administer various company lists in QuickBooks by adding customers and vendor.
  • Cash and Fixed Asset Transactions
    1. Bank Accounts and Cash Transactions in QuickBooks: Record bank account transactions in QuickBooks by entering cash account transactions and completing a bank reconciliation.
    2. Fixed Assets and Depreciation in QuickBooks: Record fixed assets and depreciation in QuickBooks.
  • Understanding Accounts Payable
    1. Accounts Payable I: Record bills in QuickBooks by entering various accounts payable transactions into the course.
    2. Accounts Payable II: Produce accounts payable history and reports in QuickBooks.
  • Reviewing Accounts Receivable
    1. Accounts Receivable I: Demonstrate the invoice procedure by producing a customer invoice in QuickBooks.
    2. Accounts Receivable II: By the end of this lesson, you’ll be able to manage payments, deposits, and returned checks in QuickBooks.
    3. Accounts Receivable III: Check for outstanding invoices and bill for the reimbursement of expenses in QuickBooks.
    4. Batch Invoicing and Creating Letters: Produce batches of invoices and customer letters in QuickBooks.
  • Managing Inventory Transactions
    1. Introduction to Inventory and Customer Estimates: Create and revise customer estimates, and you’ll practice recording and tracking inventory transactions.
    2. List Items and Inventory in QuickBooks: Assign classes, add and edit multiple list entries, and track inventory in QuickBooks.
    3. Ordering and Selling Inventory in QuickBooks: Order and sell inventory by creating sales and purchase orders and receiving inventory.
    4. Vendor Discounts and Credits and Adjusting Inventory in QuickBooks: Manage vendor discounts and credits and adjust inventory in QuickBooks.
    5. Tracking Price Levels and Customer Discounts in QuickBooks: Manage price levels and customer discounts in QuickBooks by creating price levels, discounted items, and customer discounts.
    6. Working with Customer Balances: Learn techniques for working with customer balances in QuickBooks.
  • Closing the Books and Reporting in QuickBooks
    1. Closing the Books and Reporting: How to close the books in QuickBooks and how to run and use important reports.
    2. Your Career Roadmap: The Job Search and Future Opportunities: How the job market works, and you’ll obtain skills to help you navigate it.
    3. Communication: Learn basic concepts related to effective business communication.

Requirements:

Hardware Requirements:

  • This course can be taken on either a PC or Mac. Mac users are encouraged to have access to a Windows environment on their device.
  • A reliable Internet connection of at least 1 Mbps – to view video tutorials.
  • Headphones or speakers connected to your computer – to listen to video tutorials.
  • Any web cam with a minimum of 640×480 video pixel resolution – including both external and built-in web cams.
  • A microphone connected to your computer.

Software Requirements:

  • PC: Windows 10 or later.
  • Mac: macOS 10.6 or later.
  • Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
  • Authority to install software on your computer.
  • Software must be installed and fully operational before the course begins.
  • Email capabilities and access to a personal email account.

Note: The Online Lab System is compatible with PC and Mac computers. All students are provided detailed instructions for setting-up a home virtual lab system as well.

To enroll in this program,  you should have Highschool Level education and basic knowledge of computer hardware and operating systems—for example, how to power up and log on to a machine, how to use a mouse and keyboard, and basic Microsoft Windows navigation skills. In addition, You have to pass the testout Pro Perfomance based exams before you tackle the CompTIA exams

George Davis

Energetic, results driven Information Technology Expert with extensive experience in corporate and government information technology strategies. Expert knowledge in Client/Server Windows and Unix environments; Cisco Routing and Switching deployment and administration. Excel in Integrating virtualization, cyber security and cloud services to maximize the potential of existing technology options. Solid background in managing complex technology projects with cross functional teams. Dedicated to delivering a superior end user experience by balancing technical expertise with rapport building skills.

Retired US Army NCO where he held manny technology positions. George continued his IT Career in the following jobs: Technology Instructor, System Administration, Network Technology Specialist, System Engineer, Help Desk Support,

He holds a dual Master of Science Degree in Information Technology and Human Resource Development from Webster University St lious Mo.

Technology Certification:

Microsoft:  MOS, MCP, MCSA, MCSE, MCITP (Security, Exchange, SharePoint)
Cisco:  CCNA, CCDA, CCNP
CompTia:  A+, Network+, Security +, Linux+
Oracle:  PL/SQL
ProSoft: Certified Internet Webmaster
Dapartment of Defense Security Clearance
(DOD8570.1 certificates)

Can I register for courses if I am an international student?

Yes, Tekskills 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.

Does this course prepare for a certification?

Yes, this course will prepare you for the PcPro/Network Pro/ Security Pro / CompTIA A+/Network+/Security+  Certificate exams and you will receive exam vouchers after successful completion of the program and financial obligation.

When can I start this course?

This course is open enrollment, so you can register and start the course whenever you are ready. Access to your course can take 24-48 business hours.

How long does it take to complete this course?

After you register, you will have up to 6 months to complete the course. The time allotted for completion has been calculated based on the number of course hours.

What if I don’t have enough time to complete the course within the time frame provided?

If you are unable to complete the course, contact your  itcoach@tekskillsacademy.com to help you work out a suitable completion date. Please note that an extension fee will be charged. If you are funded through a third-party organization, approval may also be required.

What kind of support will I receive?

The course instructor will be available by email to answer any questions you may have and to provide feedback on your performance. Occasionally, your course may be supported by a team of industry experts. You will also be assigned a Student Advisor for academic support.

What happens when I complete the course?

Upon successfully passing the final exam, you will be awarded a certificate of completion from the school or organization that you registered through.

Am I guaranteed a job?

Tekskills courses will help you gain the skills you need to obtain an entry-level position in most cases. However, you should always research the job market in your area before enrolling.

Can I get financial assistance?

Tekskills 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 may provide funding to take our courses.

How can I get more information about this course?

If you have questions that are not answered on our website, representatives are available via LIVE chat.  If you are visiting us during non-business hours, please send us a question using the “Contact Us.” Button

You can apply to similar entry level open positions after you graduate from this course:

Microsoft Office Specialist Jobs, Employment in Phoenix, AZ | Indeed.com

Quickbooks Bookkeeper Jobs, Employment in Phoenix, AZ | Indeed.com

Upload your resume – Let employers find you