Microsoft Excel 2013 - Intermediate
Course Description
This free online Excel 2013 Intermediate course starts by looking at the different views that Excel has, which is useful when you need to print specific parts of a spreadsheet or when you're looking at large files. The course then moves onto explaining how formulas work in Excel and how to work with multiple workbooks at a time.
Next, the course introduces you to incredibly useful functions in Excel like Find and Replace and Conditional Formatting. The course goes into depth on how to create great looking charts and graphs in Excel to help you bring your data to life - essential for any Excel user. You'll then learn about some of the most used Excel functions, specifically Lookup functions (VLOOKUP) and logical functions (IF).
Finally, the course starts you on your journey to really using Excel as a Data Analysis tool and you'll learn how to share and protect your workbooks for when multiple people are accessing them. Start this course today - you've learned the basics, now it's time to take your Excel to the next level.
What you'll learn in this course?
-
VLOOKUP
-
Data Analysis
-
Microsoft
-
Excel
Course Curriculum
- Learning Outcomes
- Financial Analysis Case Study - Part 1
- Financial Analysis Case Study - Part 2
- Quick Analysis Tool
- Adding and Formatting Shapes, Picture, Clip Art, WordArt and SmartArt
- Protecting Worksheets
- Protecting Workbooks
- Sharing and SkyDrive
- Trust Center; Export; Inspect Workbook
- Summary; More Help
SimonSezIT
United Kingdom
By