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

Focused View

Cheriamor Houston

6:05:16

101 View

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

1. Introduction & Brief Overview of Database Setup.mp4

07:39

2. Using Tables.mp4

14:06

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

05:13

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

03:23

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

04:55

6. Data Validation Option with Excel Forms (Optional).mp4

03:35

7. Outro.mp4

02:01

2. Course 2 Creating a CompanyNonprofit Budget

1. Budget Components & Where to Get Data.mp4

03:51

2. Optional Layouts Types of Budget Sheets.mp4

02:47

3. Overview & Examples of Expenses and Revenue.mp4

03:40

4. Automating Calculations & Automating Expenses Across Multiple Sheets.mp4

28:41

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

1. Introduction Purpose of Data Visualization.mp4

01:47

2. Organizational Budget Charts and Moving Charts to Reports.mp4

27:28

3. Progress Doughnut Chart with Conditional Formatting.mp4

26:04

4. Additional Charts, Including Pivot Charts.mp4

28:53

4. Course 4 Creating Employee Timesheets from Scratch

1. Intro Sheet Setup, DesignFormatting, And More.mp4

19:01

2. Formulas and Calculations I.mp4

15:53

3. Formulas and Calculations II.mp4

08:52

4. Wrap-Up.mp4

12:28

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.mp4

16:33

2. Adding Employees and Formatting Color Codes.mp4

05:43

3. Duplicating for Remaining Months.mp4

06:12

4. Replacing Employees.mp4

02:42

6. Course 6 Excel for Grant Writing & Reporting

1. Introduction, Purposes, and Intended Takeaways.mp4

05:52

2. Review of Typical Data Requested.mp4

04:01

3. Automating Databases (In Excel).mp4

38:14

7. Course 7 Mail Merge, All-Inclusive

1. Introduction.mp4

06:09

2. Set-up and Review Items.mp4

00:49

3. Writing a Letter Template.mp4

03:32

4. Preparing the Excel File.mp4

09:44

5. Templates for Labels and Badges.mp4

07:39

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

10:16

7. Simple Step-by-Step Mail Merge Letters.mp4

08:20

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

03:39

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

02:08

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

07:31

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

05:55

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

Description

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

What You'll Learn?

Excel skills for employees who wish to work for or at management levels
Learn everyday office skills in Microsoft Excel that can make your job quicker and easier and prove yourself to be an asset to any company
Learn how to apply Excel knowledge to a real-world office projects
Learn how to create budgets in Excel for companies and nonprofit organizations
Learn how to automate calculations across multiple worksheets on a budget
Data visualization for budgets and reports
Excel for Grant Writing and Reporting
Minimize manual work for grant reports by structuring and automating specific required data at your fingertips .
Mass produce bulk materials while still customizing the recipients; letters, forms, and badges with logos
Create calendars, timesheets with more info than typical templates, use embedded Data Entry forms for faster workflows, and more!
Learn how to format and manage an Excel spreadsheets and databases for quicker work processes
Become more efficient and productive on your job or business

Who is this for?

This course is good for beginners and experienced office professionals, especially those who manage projects or assist managers on daily office projects. If you're looking to expand your skills to grow in your career, this will be a great course bundle to have.

More details

Description
Go beyond basic data entry and understand how to use more functions and features in Excel. In this course you'll learn skills that can be used in various departments and prepare you for higher administrative roles or to assist leadership in grant reporting, human resources, and formatting budget sheets in Excel.
This course list is good for employees and management and can increase the knowledge of employees who seeks to potentially advance to higher levels or take on larger positions for higher pay.
Use all of this information to expand your knowledge and SHOW A RANGE OF SKILLS TO FUTURE BOSSES OR FOR YOUR OWN BENEFIT!!
This course is an all-in-one combo course that includes

Creating a Company or Nonprofit Budget
You'll learn to automate numbers across multiple worksheets
Data Visualization: Charts for Budgets and Reports
Working With Spreadsheets Using Tables Excel Data Entry Quick Forms (for quicker data entry and more efficient automation)
Create Employee Timesheets from Scratch
Unlike most templates, this one will not only calculate hours and pay, but include taxes and benefits as well
Create a Color-Coded Employee Scheduling Calendar
All-Inclusive Mail Merge
Learn to mass produce bulk materials to customized audience, including badges with your company's logo for events.Â You can create letters, address labels, return address labels, appointment reminder cards, and name badges with logos without manually typing all data on every single letter, label, or badge. Impress your boss with this knowledge!
Excel for Grant Writing and Reporting (the original workshop, originally sold separately!)
This is a rather quick course list, so you can learn and put to use immediately. You'll always have the videos and resources at your fingertips to refer back to.
Who this course is for:
This course is good for beginners and experienced office professionals, especially those who manage projects or assist managers on daily office projects. If you're looking to expand your skills to grow in your career, this will be a great course bundle to have.

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Cheriamor Houston

Instructor's Courses

Cheriamor Houston is a Program Coordinator and former Development Manager and Administrator with over 20 years in the nonprofit sector. She has worked in many facets of nonprofit and managed multiple projects. Cheriamor’s areas of experience in nonprofit include community engagement, social media marketing, office administration, special and annual events, graphic design, volunteer coordination, human resources, and fundraising management, using Excel in many of these capacities. Cheriamor has led a number of training courses, including a series in Excel. She has a Master’s of Nonprofit Administration and three non-profit certificates.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.