Microsoft Excel: From Staff to Management (7-Course Bundle)

سرفصل های دوره

Excel Skills You Can Use for A Range of Professional Projects and Departments

1. Course 1 Working With SpreadsheetUsing Tables & Data Entry Forms

1. Introduction & Brief Overview of Database Setup

2. Using Tables

3. Using Excel Forms - Overview of Benefits for Using Excel Forms

4. Using Excel Forms II Navigating and Working with New Records

5. Using Excel Forms III Features Search, Restore, Delete

6. Data Validation Option with Excel Forms (Optional)

7. Outro

2. Course 2 Creating a CompanyNonprofit Budget

1. Budget Components & Where to Get Data

2. Optional Layouts Types of Budget Sheets

3. Overview & Examples of Expenses and Revenue

4. Automating Calculations & Automating Expenses Across Multiple Sheets

3. Course 3 Data Visualization Tables & Charts for Budgets and Reports

1. Introduction Purpose of Data Visualization

2. Organizational Budget Charts and Moving Charts to Reports

3. Progress Doughnut Chart with Conditional Formatting

4. Additional Charts, Including Pivot Charts

4. Course 4 Creating Employee Timesheets from Scratch

1. Intro Sheet Setup, DesignFormatting, And More

2. Formulas and Calculations I

3. Formulas and Calculations II

4. Wrap-Up

5.1 Sample Timesheet Cover Page_eTeach uExcel.pdf

5.2 Timesheet Tax and Benefit Calculations Resources.pdf

5. Optional Downloadable Resources.html

5. Course 5 Creating a Color-Coded Employee Scheduling Calendar

1. Creating a One-Month Calendar In Excel

2. Adding Employees and Formatting Color Codes

3. Duplicating for Remaining Months

4. Replacing Employees

6. Course 6 Excel for Grant Writing & Reporting

1. Introduction, Purposes, and Intended Takeaways

2. Review of Typical Data Requested

3. Automating Databases (In Excel)

7. Course 7 Mail Merge, All-Inclusive

1. Introduction

2. Set-up and Review Items

3. Writing a Letter Template

4. Preparing the Excel File

5. Templates for Labels and Badges

6. Design and Layout for Labels, Badges, Appt Reminder Cards and Adding a Logo

7. Simple Step-by-Step Mail Merge Letters

8. Simple Step-by-Step Mail Merge Mailing Address Labels

9. Simple Step-by-Step Mail Merge Return Address Labels

10. Simple Step-by-Step Mail Merge Appointment Reminder Cards

11. Simple Step-by-Step Mail Merge Name Badges With and Without Company Logo

12.1 General Database for Mail Merge_eTeach uExcel course.xlsx

12.2 TEMPLATE_Mail Merge - Letter_eTeach uExcel course.docx

12.3 TEMPLATE_Mail Merge - Reminder Card_eTeach uExcel course.doc

12.4 Workshop Leaders List for Appt Cards_eTeach uExcel course.xlsx

12. Full Downloadable Resources.html

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training