Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
This course is taught by a professional corporate trainer in a friendly, step by step method so that you can follow along and do the steps with the instructor. If you prefer to watch and listen, that works great too!
This course is designed to give you complete confidence in your knowledge of Excel. You will learn core features that you will use and build on throughout the course as we increase our knowledge of key features.
We start with a blank workbook and will build out multiple sheets from entering values to calculations and functions, all the way to building charts and updating data series.
This course is titled Beginning Excel but actually covers intermediate topics, too!
Can you answer these questions?
1. What is the difference between workbooks, spreadsheets, templates, sheets, file?
2. What is the difference between labels and values and why is that important?
3. Can you confidently use and modify calculations and average, sum, min and max formulas?
5. When should you convert your data to a table range and what are the pro's and con's?
6. How do I sort and filter my data by multiple criteria?
7. How do I add a series to a data range and have a chart automatically update?
If you answered "no" to any of these questions, then this course is for you!
We will answer all of these questions and much more!
Come on in and join us! We look forward to having you!
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Course Introduction|
|Section 2: Excel Fundamentals|
Launching Excel for Mac 2011
Adding Excel Icon to your Dock
Overview of the Excel Program Screen
Navigating a Worksheet & Keyboard Tips
A Bit of Excel Terminology: Workbook vs Worksheet vs Spreadsheet vs File
Create, Open & Close a Workbook
|Section 3: Getting Started with Worksheets|
Entering & Editing Labels and Values
Entering Data Automatically - Tip
Saving Your Workbook, Save vs Save as...Preview
Selecting a Cell Range and Entering Data - Tip
Entering Data in a Cell Range - Tip 2
Entering Data: Labels vs Values (convert a number to text)
Entering and Formatting Dates
|Section 4: Getting Started with Formulas & Functions|
Functions & Formulas Introduction. Sum Function.Preview
Sum Function. Editing the Formula.
Sum Function. Copying the Formula.
Math Operators: Additions, Subtraction, Multiplication, Division
Formulas: Absolute vs. Relative Reference
Formulas: Average, Min, Max
|Section 5: Editing a Worksheet|
Moving and Copying Cell Contents
Copying Cell Contents to a New Sheet
Paste Menu Options
|Section 6: Formatting a Worksheet|
Format and Merge Cells
Why Format Options on Ribbon are Different
Number Formatting Overview
Number Formatting: Currency
Clear Formatting vs Clear Contents
Adjusting Column Widths
Adjusting Row Height
Alignment: Top, Bottom, Wrap Text
Inserting and Deleting Columns
Adding Cell Borders
Copy Formatting using Format PainterPreview
Print & Print Preview
|Section 7: Working with Charts|
Updating Data in Charts
Copying and Moving Charts
37Adding A Chart Series
|Section 8: Sorting Data|
Download PB Travel Sales Report Training.xlsx FilePreview
Sorting Your Data
Sorting a Selected Range vs Automated Sorting
Sorting Outside of a Range
Sorting a selected Range
Sort by Multiple Criteria
|Section 9: Filtering Data|
Filter by Number
|Section 10: Introduction to Tables|
Introduction To Tables (Tables vs Filtering)
|Section 11: Working with Multiple Worksheets|
Creating, Copying and Naming Worksheets
Moving and Navigating between Worksheets
Deleting Worksheets and Changing Tab Color
Printing Multiple Worksheets
|Section 12: Working with Images|
Inserting and Formatting Images
|Section 13: Course Certificate|
Course Certificate & Feedback
Francie has a twenty year progression through technology, training, project management, software development, and IT management.
You can see Francie on ABC TV News' weekly "App Chat" segment as the featured tech expert.
Francie helped start the computer training department for a Fortune 100 company and has written and taught computer training courses for beginning - advanced levels of Microsoft Word, Microsoft Excel, PowerPoint, FileMaker Pro, HTML Programming, UNIX, iPad, iOS7 and many other topics including custom applications.
Her written materials have been used by thousands of corporate employees and she has taught thousands of students worldwide in instructor led and online webinar training sessions.
As a technology consultant, some of the largest companies in America have contracted with Francie to present and train employees on a wide variety of technical topics.
Francie is bringing her training experience to a larger audience as a new instructor with Udemy. She has started her Udemy courses with beginning Excel and will be offering many more topics.
Here friendly, step by step, instruction will give you the solid knowledge you need!
Francie has a business degree from UNC Charlotte and an MBA from Pepperdine University in Malibu, CA.
Come on in and join the course! We're so happy to have you!